The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hey everybody,

Sybase 10 32 Bitis running as a Service on Server 2008x64. Last 4 weeks the server crashes 2 times with following error with not entry in logfile

Error in application dbsrv10.exe, version 10.0.1.3415, time stamp 0x46094b94, faulty module dbserv10.dll, version 10.0.1.3415, time stamp 0x46096fa0, exception code 0xc0000005, fault offset 0x002f3be5, process id 0x1394, application start time 01cfd8d5a795cc57.

Is it possible to activate an extended log to see for the next time? I have heard from the verbose log, but solves that my problem?

asked 08 Oct '14, 05:24

pmiller's gravatar image

pmiller
17191419
accept rate: 28%

with not entry in logfile

What do you mean with logfile? Do you already use a console log file, such as via "dbsrv10 -o MyConsole.log"? (If not, that would be highly recommended...)

(08 Oct '14, 06:29) Volker Barth

Yes, sorry i mean the console log. There is no entry at the crashtime. So at the moment i do some tests with

CALL sa_server_option( 'DebuggingInformation','YES' );

I will see if this show me more informations about the service when go to taskmanager an kill the service (in a testmaschine)...

(08 Oct '14, 06:59) pmiller
Replies hidden

FWIW, that option (aka dbsrv10 -z) will usually have an impact on performance so it may not be used in general for production systems... - OTOH, it's not that easy to set that option immediately before a crash - there's a lack of a "about to crash" system event:)

(08 Oct '14, 07:24) Volker Barth

   Error in application dbsrv10.exe, version 10.0.1.3415, time stamp 0x46094b94, 
   faulty module dbserv10.dll, version 10.0.1.3415, time stamp 0x46096fa0, 
   exception code 0xc0000005, fault offset 0x002f3be5, process id 0x1394, 
   application start time 01cfd8d5a795cc57.

That's a fatal internal server crash; the "exception code 0xc0000005" gives it away. That is a C0000005 access violation... a bug inside SQL Anywhere that should not happen, and certainly should not be caused by anything you do... and no amount of bug hunting on your part is going to find the cause.

SQL Anywhere 10.0.1.3415 is pretty old. 10.0.1.4310 exists; it may or may not be the latest EBF, and it may or may not fix the problem, but it is worth trying a recent EBF.

However, it may not be easy to obtain that EBF since "the gates have been closed" on downloading recently.

Also, Version 10 has been rejected by the SAP Death Panel is no longer supported as far as bug fixes are concerned, so if you have stumbled on a new bug it will not be fixed.

Technical support is still available, however, so if you can get a crash dump you might get someone to look at it; i.e., fixes might not be available, but diagnostic services are. They may suggest a workaround.

Even better: Upgrade to Version 12 or 16.

permanent link

answered 08 Oct '14, 08:42

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%

edited 08 Oct '14, 08:45

1

and certainly should not be caused by anything you do... and no amount of bug hunting on your part is going to find the cause

Well, the user certainly is not responsible for that crash but I remember (rare) situations when I could reproduce a db server crash by re-doing a particular SQL statement, so a user still might cause such a crash - and might be able to prevent that particular command...

That being said, I certainly agree that there's not much sense in bug hunting here - it just may be that the bug finds you:)

(08 Oct '14, 09:12) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×36

question asked: 08 Oct '14, 05:24

question was seen: 322 times

last updated: 08 Oct '14, 09:12