Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Frequent Assertion error on 9.02.3924

2 posts in General Discussion Last posting was on 2010-04-12 10:28:00.0Z
Ivan Zivkovic Posted on 2010-04-12 09:27:42.0Z
From: Ivan Zivkovic <ivan.zivkovic@mdprofy.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Frequent Assertion error on 9.02.3924
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bc2e78e$1@forums-1-dub>
Date: 12 Apr 2010 02:27:42 -0700
X-Trace: forums-1-dub 1271064462 10.22.241.152 (12 Apr 2010 02:27:42 -0700)
X-Original-Trace: 12 Apr 2010 02:27:42 -0700, vip152.sybase.com
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7996
Article PK: 7024

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


Breck Carter [TeamSybase] Posted on 2010-04-12 10:28:00.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Frequent Assertion error on 9.02.3924
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <7dt5s5t9qjuqcam1hjvip0bn7o11u2itvp@4ax.com>
References: <4bc2e78e$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 12 Apr 2010 03:28:00 -0700
X-Trace: forums-1-dub 1271068080 10.22.241.152 (12 Apr 2010 03:28:00 -0700)
X-Original-Trace: 12 Apr 2010 03:28:00 -0700, vip152.sybase.com
Lines: 51
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7997
Article PK: 7023

See
http://sqla.stackexchange.com/questions/613/frequent-assertion-error-on-9-02-3924

On 12 Apr 2010 02:27:42 -0700, Ivan Zivkovic

<ivan.zivkovic@mdprofy.com> wrote:

>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

--
Breck Carter

Visit SQLA! ...the new SQL Anywhere online community
http://sqla.stackexchange.com

Blog: http://sqlanywhere.blogspot.com/

RisingRoad helps SQL Anywhere developers make better databases...
http://www.risingroad.com/

Breck.Carter at gmail