SQL Anywhere database service is shut down

[Former Member]

Does anyone have any idea about the following error?

*** ERROR *** Assertion failed: 200505 (16.0.0.1324) Checksum failure on page 438578

When we backed up the database, the database service was shut down with the error message above.

I looked up the failure and found that it has something to do with corrupted transaction log, but after we rebuilt the transaction log, the error still occurred after the restarted database service was run for several days.

Also, we also tried re-installing the SEPM on three different physical machines with different motherboard, hard drives and RAM modules and all of them exhibit the issue.

Version information is shown below.

[former_member186998]

Hi Tony,

Did you try a recovery option?
http://dcx.sap.com/index.html#sa160/en/dbadmin/rec-f-database-dbengine.html

Thanks,

Atsushi

[former_member186998]

Hi Tony,

I agree with Mirco opinion.
The latest build fixes the following problem.

==========(Build #1691  - Engineering Case #748170)===========
In rare timing dependent cases, a copy node that had just processed a Log
rRename could have failed assertion 200505, if its child was requesting log
pages. This has been fixed.

2255721 - SQLAnywhere 16.0 SP46 Build 2213 Release Notes Information

Thanks,

Atsushi

[former_member207653]

Have you tried to validate (dbvalid utility) the database file as well?
Have you determined the corruption of the transaction log file because dbtran utility fails to translate it into a sql file?

By the way, you should plan an upgrade of the software because 16.0.0.1324 is still the GA version. The latest build available for download is 2213 on Windows (you have not specified the operating system).

[Former Member]

It's not available, so I tried call sa_validate instead.