Frequent Assertion error on 9.02.3924

From: Ivan Zivkovic

Newsgroups: ianywhere.public.general

Subject: Frequent Assertion error on 9.02.3924

Date: 12 Apr 2010 02:27:42 -0700

Hi all,

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 (9.0.2.3924) 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 (9.0.2.3562) 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.

Best Regards,

Ivan

error

asked 12 Apr '10, 10:22

Breck Carter
32.5k●541●726●1050
accept rate: 20%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 12 Apr '10, 10:27

Breck Carter
32.5k●541●726●1050
accept rate: 20%

It is highly likely a faulty RAM. Some time ago, I had an ASA9 server sporadically crashing on my workstation. Memtest found a broken memory cell at some higher address, after RAM replacement everything was fine.

(12 Apr '10, 14:12) Dmitri

From personal experience, I must say I agree with Dmitri: I see RAM problems which mimic hard drive failures more often than actual hard drive failures. RAM problems can be worse, in that a hard drive problem may remain localized on the drive whereas a RAM problem can end up corrupting more and more of the data stored on the drive as the RAM errors garble more and more of the data passing through. If anyone suspects RAM the immediate reaction should be "power off" (stop further damage).

(13 Apr '10, 08:58) Breck Carter

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

error ×95

question asked: 12 Apr '10, 10:22

question was seen: 3,514 times

last updated: 12 Apr '10, 10:27

SAP SQL Anywhere

Frequent Assertion error on 9.02.3924

Follow this question

Related questions