Server won't boot. Stuck on "Starting Sybase Adaptive Server Anywhere"

[Former Member]

I have a Sun X2250 Running SUSE Linux Enterprise Server 10. It's getting stuck during the boot process when trying to start the SyBase DB. Any suggestions on how to force the server to load past this? Any way to get it to skip this step when booting? I have tried booting into single user mode and turning off the Sybase on startup. When I did this it complained, rebooted, and tried to start Sybase again.

[former_SQLA_member1694874]

Up voted for the genius way of taking a "screenshot" 🙂 love it.

[Former Member]

I was able to resolve the issue. Once in single user mode I was able to go to the /home/sybase/databases directory and see there was an "original" version of the DB and Log there. I renamed the existing DB and Log, and copied the originals in their place. Rebooted and the server started up fine. The DB was re-populated by running a command on the server that feeds data to this server, and all is well again.

[MarkCulp]

I suspect that the database server is recovering your database and hence the appearance that it has hung.... but this is just a guess.

Exactly what are you referring to as "it" in your statement "When I did this it complained". I.e. What is complaining and what was the message?

What version and build of SQL Anywhere are you using?

Without knowing more it is difficult to make any recommendations.

[Former Member]

By "it" I mean the server/linux. Basically it sees that Sybase isn't set to start, and says it has to fix the services. Reboots, turns sybase back on, and then sits at this point again.

It may be trying to repair the DB, but it's not successful. I left the server in this state Sunday afternoon, and when I came in this morning it was still in the same state.

Since I can login in Single user mode, are there any commands I can run to try and repair the DB?

Thanks

[MarkCulp]

Does your server have a console log? If yes then you should look at the log to determine if there are any messages that might help determine what is happening during startup. If there isn't a console log then add one - add "-o <some-file-name>" to the service definition.

If you want to test the state of the database in single user mode then just try running "dbsrvX databasename.db" from the command line (you may need to source the {sa|asa}_config.sh file first? - it will depend on your environment).

Please tell us what version and build number of SQL Anywhere that you are using?