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

dbsrv11.exe exception 0xc0000005

About 2 weeks ago SQL Anywhere server start crash about up to 5 times per day.

I'm try to catch error reasons but server do not write anything in logs to start investigation.

Server startup line looks like:

-n main_server -x tcpip(port=2638) -o d:\maindb.log -os 10M -oe d:\maindb_fatal.log -c 16g -ch 16g -gn 100 -xf d:\MainDB\server1state.txt d:\MainDB\main.db -sn main -xp "partner=(ENG=mirror_server;LINKS=tcpip(host=mirror_host;PORT=2638;TIMEOUT=1));auth=auth_string; arbiter=(ENG=arbiter;LINKS=tcpip(host=arbiter_host;PORT=2640;TIMEOUT=1));preferred=YES;mode=sync;autofailover=YES" -su su_pass

But then exception 0xc0000005 occurs nothing written in maindb.log or maindb_fatal.log. Primary server just stop working and mirror server become primary. And if I don't make any interventions after few hours mirror server stops too.

After translate transaction log last record always commit and previous records always linked to a different tables.

There is no environment changes makes on the Windows servers. And nothing valuable changes makes in database.

Did someone knows how to get more info about reasons of crash?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2015 at 12:54 PM

    We struggled with a similar problem a couple years ago. In our case the root cause was a bug that was triggered if we set a timeout on a JDBC query and the query took longer than the given timeout. Some sort of problem cleaning up DB resources after the timeout fired. The workaround was to extend or eliminate the timeout, which was not a great answer, but better than an outright crash. The problem is fixed in SQL Anywhere 16. I don't know if SAP ever rolled it into an EBF for version 11.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2015 at 01:51 PM

    Hi Andrey,

    The exception you are experiencing is caused by a internal problem in the database server, and is most likely a bug.

    Which version of SQL Anywhere 11 are you running? You can check this by running dbsrv11 -v . There's a chance that the issue you are encountering is resolved by an already posted service pack. The last build of SQL Anywhere 11 released was 11.0.1.3158. If possible, you should update to this version and see if the issue goes away.

    Version 11 has past it's end-of-life, so no new service packs to resolve issues can be posted. However, if you have a current support contract, we can still review the crash dump file for you. It's possible there could be a workaround for the bug you're hitting.

    Thanks,

    Mikel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2015 at 10:34 AM

    wrong forum - moved to SQL Anywhere...

    Add a comment
    10|10000 characters needed characters exceeded

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.