Skip to Content
author's profile photo Former Member
Former Member

Trouble with ASA9 database


We've got an ASA9 database that started causing us some trouble yesterday. It appears to not allow any connections to be made to it. Doesn't give any return messages, it just hangs at the client level and never does anything. The service window looks normal. Says the server is started normally, as well as the sharedmemory link, namedpipes link and TCPIP link. Starts on the port and says that it is now accepting requests. Try to connect through our application, scjview, dbisql, dbvalid, etc. all just hang with no response. Go to stop the service, and it just hangs as well. Have to kill all of the processes.

Had IT get me the backup, and it had the same problem. Had to go back 3 days to get a backup that would actually start and allow connections. I ended up translating the log and applying the sql to the last good backup in order to get us running again. Ran dbvalid against the database and nothing was found to be wrong.

I'm concerned that there is something else going on. Has anyone seen anything similar? Any thoughts on what the issue could be?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 17, 2014 at 02:05 PM

    Hi John,

    Assuming you still have a copy of the database that hangs, could you try starting it with request level logging enabled?

    dbsrv9 -z -zr ALL -zo C:\path\to\file.txt database.db

    As well as connecting with a client log:

    dbisql -c "UID=DBA;PWD=sql;ENG=database;LOG=C:\path\to\file2.txt"

    Which operating system are you running the server on?



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi John,

      Does the database contain sensitive information?

      If not, could you obtain a dump file of the process while it is hung? You can do this using the procdump utility ("procdump.exe dbsrv9"). The resulting file should be small enough to compress and upload.

      Be aware that the memory dump could contain any information from within the database in an unencrypted format (including passwords). If you have a support contract, your best option would be to open an incident.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.