After server crash getting "assertion failed 201129 (9.0.2.3412) File is shorter than expected."

Over 800GB were free on server at time of crash

Thanks for help

Randy

asked 17 Jan '12, 11:37

Randy's gravatar image

Randy
1111
accept rate: 0%

edited 17 Jan '12, 12:59

Mark%20Culp's gravatar image

Mark Culp
23.3k9132275


Your database is corrupt; you should review the "I've got an assertion! What should I do?" document for further details. To get back up and running, you should revert to the most recent and valid backup of the database, assuming it is available.

If you do not have a valid backup copy of the database, you can try to salvage the database via Sybase Technical Support (for an additional salvage engagement fee).


"File is shorter than expected" can happen when the database file's file-system metadata has not been flushed to disk correctly and power is lost to the drive. For some Intel disk controller manufacturers on Windows, there is a registry setting that must be set in order to have disk flushes happen correctly.

You should review our SQL Anywhere I/O whitepaper to ensure that your operating system environment is set up to store files correctly (at times of power loss / system restart / etc.).

If you are using NTFS on Windows, you should also be aware of the recent comments Microsoft has made regarding "NTFS file metadata integrity" on current versions of Windows.

permanent link

answered 17 Jan '12, 12:53

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

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:

×32

question asked: 17 Jan '12, 11:37

question was seen: 6,581 times

last updated: 17 Jan '12, 12:59