Hello everybody,

we are running SQL Anywhere 17 (17.0.8.4103) as a MobiLink consolidated on a Windows machine and the operating system crashed. After starting windows again, the database does not start anymore. We get the following message:

Running Windows 2012R2 Build 9600  on X86_64
Server built for X86_64 processor architecture
1144928K of memory used for caching
Minimum cache size: 1143808K, maximum cache size: 28305136K
Using a maximum page size of 4096 bytes
Multiprogramming level: minimum:5, current:20, maximum:80
Automatic tuning of multiprogramming level is enabled
Starting database "sam_p" (C:\ooo.db) at Wed May 16 2018 09:58
Performance warning: Database file "C:\ooo.db" consists of 23629 disk fragments
Database recovery in progress
    Last checkpoint at Tue May 15 2018 16:54
    Checkpoint log...
    Transaction log: sam_p.log...
    ... recovery 0% complete
    ... recovery 14% complete
    ... recovery 41% complete
    ... recovery 69% complete
    ... recovery 95% complete
    ... recovery 100% complete

*** ERROR *** Assertion failed: 106200 (17.0.8.4103)

Unable to undo index changes during rollback

We tried to start the db without log (-f), but did not work either. Any idea what could be done to get the db back up and running?

Thanks for the help and best regards, Alex

asked 16 May, 04:14

Alexander%20Ilg's gravatar image

Alexander Ilg
176131321
accept rate: 0%

Other than trying with the newest v17 EBF (17.0.9.4793 on Windows AFAIK) if that can recover the current database, I guess "[use the] back up and [go] running" with applying the current log should be the way to go...

(16 May, 05:06) Volker Barth

It would ideal to get to a later SP as we have added additional diagnostic information to the assertion. The SP should be build 4148 or later. This will not address the assertion but will provide more information about the problem encountered. This change is Engineering Case #813493.

(16 May, 10:02) Chris Keating
Be the first one to answer this question!
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:

×47
×46

question asked: 16 May, 04:14

question was seen: 52 times

last updated: 16 May, 10:02