Question Re: An assertion failures on SQL Anywhere 12 in Technology Q&A

An assertion failures on SQL Anywhere 12

Former Member — Tue, 30 Aug 2011 03:34:51 GMT

We recently upgraded our databases from SQL Anywhere 10 to SQL Anywhere 12 (12.0.1.3356).

After this we receive an assertion failures very often. Here is some of them:
Assertion failed: 201129 (12.0.1.3356) File is shorter than expected;
Assertion failed: 201501 (12.0.1.3356) Page 0x0:0x705 for requested record not a table page;
Assertion failed: 200130 (12.0.1.3356) Invalid page found in index.

Is there a way to prevent such failures? Were they resolved in the EBF?

Re: An assertion failures on SQL Anywhere 12

MCMartin — Tue, 30 Aug 2011 04:50:01 GMT

Sounds to me like an error of the underlying filesystem. Is the error independent of the used hardware?

Re: An assertion failures on SQL Anywhere 12

VolkerBarth — Tue, 30 Aug 2011 05:42:52 GMT

As to the question whether newer EBFs have solved these issues (which I do not know...), you just might look into the readme of the newest EBF and search for these assertion numbers...

Re: An assertion failures on SQL Anywhere 12

Former Member — Wed, 31 Aug 2011 05:16:33 GMT

The remote database is used on the PDA under Windows Mobile 6 (we have tested it only on iPAQ214, 624 MHz, 128 Mb SDRAM). The database is stored on the SD Card.

Re: An assertion failures on SQL Anywhere 12

Former Member — Wed, 31 Aug 2011 09:52:53 GMT

The first and last assertions that you mentioned (201129 and 200130) are indicative of physical corruption of the database file, which we see from customers periodically when the database is stored on an SD card. Unfortunately, SD card storage is, often, not nearly as robust as other media. The second assertion, 201501, has a number of potential causes, but physical corruption is one of them.

I suggest you copy the database from the SD card, put it on a Windows XP (or Vista or Windows7) machine and see if you can start the database; then try to validate the database file using dbvalid.