Sybase 12 Database Recovery Failure

[JimDiaz]

We have run up against a database recovery failure in SQL Anywhere 12.0.1.3152.

I allow the system to send you failure data but the error I received was

** ERROR *** Assertion failed: 100904 (12.0.1.3152)
Failed to redo a database operation (id=4, page_no=0x4a90, offset=0x6ca) 
- Error: User 'another user' has the row in 'DexterSensorsRealtimeData' l
    ... recovery 46% complete

[MarkCulp]

I'm not sure we will be able to identify the exact reason for your recovery failure without looking at the database (you may want to call Tech Support to have someone look at it).... but there have been a few issues fixed in builds more recent than what you are using:

• QTS 690114: Recovery could fail if server is started with certain features secured (fixed in 12.0.1.3497)
• QTS 686822: Recovery could fail after schema upgrade performed by dblmsync (fixed in 12.0.1.3479)
• and a few more that are related to mirroring (which may not be relevant here?)

You may want to consider downloading a recent EBF and see if you can recover the database using the newer software?

[Former Member]

Do you have materialized views defined in your database?

Please also follow a related post here "Applying Log Causes Assertion 100904 - User 'another user' has row locked" http://sqlanywhere-forum.sap.com/questions/12791/applying-log-causes-assertion-100904-user-another-u...

[JimDiaz]

No materialized views in this database. I had already seen the referenced post, it ends in a tech assist. Our issues closely mirrors the referenced post in that this is a hot standby database. We are presently refreshing the remote backup and validating, although these databases are validated and fully backed up weekly with no errors found. This will take several days since the database is roughly 200 GB.

Thanks for the assist.

Jim