|
I created a new database and imported data from a CSV file. After 90 Mio rows the database has a size of 57GB and throwed the following error: ERROR Assertion failed: 200505 (16.0.0.2076) Checksum failure on page 7066120 At the time of the assertion there was no other warning or error message in the event log. The used file system is a relatively new SSD which showed so far no suspicious behavior and is still in good condition. The S.M.A.R.T. infos show no problems at all. The assertion occured during an increase of the database file. Is this a false alarm? Can I double check the healthyness of the database file, or do I have to start the import all over again? => Update Obviously the database is really broken, when I try to start it the following error occurs:
"...is larger than expected" and then |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
question asked: 20 Jul '15, 02:44
question was seen: 2,387 times
last updated: 20 Jul '15, 11:18
Assertion 200505 will occur of the page read from disk has a bad checksum. What OS (and version/kernel) are you using? We have seen some OS bugs that can cause this to happen.
Windows 8.1 - 64 bit using also the 64bit version of SQLA, filesystem is NTFS