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

asked 28 Jul '12, 09:55

J%20Diaz's gravatar image

J Diaz
830243044
accept rate: 14%

edited 28 Jul '12, 14:24

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844

Comment Text Removed

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

permanent link

answered 28 Jul '12, 11:00

Nica%20_SAP's gravatar image

Nica _SAP
866722
accept rate: 3%

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

(28 Jul '12, 16:36) J Diaz

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?

permanent link

answered 30 Jul '12, 08:45

Mark%20Culp's gravatar image

Mark Culp
22.9k9129269
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22

question asked: 28 Jul '12, 09:55

question was seen: 1,793 times

last updated: 22 Sep '12, 09:12