We have run up against a database recovery failure in SQL Anywhere 18.104.22.16852.
I allow the system to send you failure data but the error I received was
** ERROR *** Assertion failed: 100904 (22.214.171.12452) 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
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-user-has-row-locked
answered 28 Jul '12, 11:00
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:
You may want to consider downloading a recent EBF and see if you can recover the database using the newer software?
answered 30 Jul '12, 08:45