Does anyone have any ideas on where to start looking when a database engine service simply disappears? No assertion, no error in the console log, nothing in the Windows event logs. Server re-starts without complaint. v10.0.1.4310 |
When the SQL Anywhere database server unexpectedly crashes, it will normally catch this event itself and automatically create a mini-dump file and supply this information to dbsupport. Depending upon your submission settings, dbsupport will either auto-submit this information automatically to SAP/Sybase or will hold on to the information until you submit it manually. Use If your server is still crashing and no information is being passed to dbsupport, there are other ways to manually collect this diagnostic information from the server (via procdump and psexec, if required). If you need to go this route though, we would recommend that you also open a technical support case with us so that we can work with you on collecting this output and have it analyzed. A reminder that SQL Anywhere 10.0.x has been end-of-life'd, so there could also be an outstanding technical issue with the product that will not be fixed by a software patch - we will attempt to provide "limited technical assistance" for the product via technical support instead (suggest workarounds, etc.). "Crashes" can frequently be related to database corruption (although this will typically be reported as an "assertion" in the database console log - I noted that you've already checked this: Update by Justin Willey - support found the problem in a query evaluation / optimizer routine. The routine was rewritten for v11 so shouldn't be present in v11 or higher versions. See comments below. Mnay thanks for the detailed reply Jeff - I'm seeing what we can find. On the point about corruption we have a full validation scheduled for Saturday. Also I can try those specific statements again as you suggest.
(21 Sep '12, 13:12)
Justin Willey
Replies hidden
Hi - just had a recurrence - have tried submitting but getting: Error submitting report: No reply received from web server. Error sending to www.ianywhere.com:80. Is it possible to send you the files? Many thanks
(15 Oct '12, 13:40)
Justin Willey
1
I believe we have a current outage in the submission server - I'm not sure when this is to be resolved. Do you have a support plan and can you open a support ticket for this issue?
(16 Oct '12, 13:27)
Jeff Albion
@Jeff, I've submitted the mini core files etc for event SA10_20121017_101730_3440 (this is another incident yesterday with the same symptoms) under case #11759414 - many thanks
(18 Oct '12, 06:42)
Justin Willey
The (full) validation completed without any problems.
(18 Oct '12, 06:43)
Justin Willey
1
Have heard back from support. The crash seems to relate to a portion of code in the query evaluation / optimization process. The routine in question has been re-written in v11 so the problem shouldn't be present in that or later versions.
(22 Oct '12, 09:06)
Justin Willey
|
Anything in the translated transaction log?
Hi Volker. I've translated it now, but there's nothing except a gap in time between normal activity and then a check point when the server came back up three minutes later:
The Recent objects record is inserted automatically and the timestamp on it (11:21:11) is just before the time the server died. The checkpoint at 11:24 matches the restart.
Have you used "DBTRAN -a -d" or other switches to "get most out of the log" for the according log part - say, in order to notice any uncommitted operations?
Besides that, I can't tell whether the contents gives any clues:(
good point re the -a , re-translating now.
This is the version with the -a -d switches
but no smoking gun that I can see...
A case for the great iAnywhere experts, obviously... - I hope they come around here:)
Sorry, I couldn't resist to note that this isn't the supposed meaning of the slogan "SQL Anywhere - The Invisible Database"...