Problem with customer database: dbsrv16 keeps crashing while unloading a database. it crashes always at the same table with failure: "Assertierung fehlgeschlagen" seems to fail always at unloading the same table. What can cause such a problem? I have inconsistencies in another databases primekey index too, used by the same software. Appending the crash details here: Server SQL Anywhere 16 16.0.0.2322: Command dbunload -v -c "UID=sirius;PWD=***;Server=sa16jw;DBF=/home/jw/Kunden/PerformanceTest/Database/PerformanceTest.db;LINKS=TCPIP()" -r "/home/jw/Kunden/PerformanceTest/reload.sql" -ii "/home/jw/Kunden/PerformanceTest/unload"
|
There used to be tech note titled "I've Got An Assertion! What Should I Do?" but I can no longer find it. You may have a corrupted disk, or RAM errors, or a combination of both. In an ideal world, you will restore the database to a different computer, from a recent backup. In a less-than-ideal world, you may not have a usable backup, so... If you suspect RAM errors, further attempts to use the database may result in permanent disk errors as corrupt RAM values are written to the disk. It is suggested you stop updating the database until the data can be rescued. If you already know which table is having problems, you can uses dbunload with -t to unload all the other tables. If the primary key is having problems, try dropping the primary key before unloading that table. Do not write the unloaded data to the same suspect disk; consider using an external USB 3 drive. Run an extended RAM check on the suspect computer, or just replace the RAM (especially if you have recently installed suspect chips). Same thing with the disk drive, to make sure any corruption is transient; i.e., bad stored values rather failing bits. Do that before trying to rebuild the database from the unloaded data. thanks for your comprehensive answer. the hardware was checked, but with no results (no failures show out on RAM and HD).
(14 Feb '17, 04:40)
softecspprt
|
Here's a link from the SQL Anywhere Wiki to the topic mentioned by Breck: I guess that's the most official document on that topic currently... 1
Thanks for the link. We repaired the database by unloading it (without the table containing the defect), reloading to new database and adding the table again.
(20 Feb '17, 03:49)
softecspprt
|
What does a full validation of the database reveal, say via dbvalid?
both dbvalid and "VALIDATE DATABASE" in ISQL lets the server crash.
FEHLER "Assertierung fehlgeschlagen" ... Checksum error on page ....
to reproduce: example db for testing is available here: http://k00.fr/27xde (about 600 MB, including sybase crash log and dump)