From: Ivan Zivkovic
Subject: Frequent Assertion error on 9.02.3924
Date: 12 Apr 2010 02:27:42 -0700
SQL Anywhere 9.02.3924 OS Windows Server 2003 Standard Edition with Service Pack 2
I have database that was running for a long time on same server.
Recently Assertion error started to happen. First time that happened it was * ERROR * Assertion failed: 101412 (220.127.116.1124) Page number on page does not match page requested
I did unload/reload of database (without ordering data) and everything continued to work OK. In next 24 hours I got
* ERROR * Assertion failed: 201425 (18.104.22.16862) E. 03/12 21:20:08. Invalid count or free space offset detected on a free list page
After this error I had to unload/reload without table where problem was reported with dbvalid.
After this assertion error started to happen regularly at least once a day, every day. Than I moved database file to another server where it is working without any problem few weeks.
What can cause this problems?
Any help is appreciate.
asked 12 Apr '10, 10:22
The fact that the database works OK on a different server is very strong evidence that it is a hardware problem on the original server.
The hard drive or RAM on the original server is probably faulty. The symptoms point to "hard drive" but faulty RAM can cause the same symptoms: the data coming from the drive may be OK but it is getting messed up in the RAM, and it is the data in RAM that is checked by SQL Anywhere for validity.
answered 12 Apr '10, 10:27