Skip to Content
0
Former Member
Jan 21, 2016 at 02:02 PM

SQL Anywhere 17.0.0.1358 constantly crashes (assertion fails 200505, 101412)

1069 Views

For following week me and my team had problem with SQL Anywhere 17 (17.0.0.1211 and 17.0.0.1358) constant assertion crashes.

Database was completely reloaded and engine updated to the latest version, but problem still exists. It usually it happens 4-5 times a day.

Here are the errors, they randomly alternate.

SQLANYs_...: *** ERROR *** Assertion failed: 200505 (17.0.0.1211)

Checksum failure on page 64845

SQLANYs_...:: *** ERROR *** Assertion failed: 101412 (17.0.0.1211)

Page number on page does not match page requested

What could be the culprit here? Could this be the fault of hardware or DBMS engine failure? We tried request logging, but catching a faulty query in our case is close to impossible. Furthermore, after assertion, DMP file appeared, which pointed to a page failure on TEMP DbSpace. So far, we have no solution how to reproduce the error.