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.

Internal db error***Assertion***

4 posts in General Discussion Last posting was on 2004-11-23 10:20:58.0Z
Ollie Posted on 2004-11-22 16:42:16.0Z
Sender: 2024.41a21411.1804289383@sybase.com
From: Ollie
Newsgroups: ianywhere.public.general
Subject: Internal db error***Assertion***
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41a216e8.2094.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Nov 2004 08:42:16 -0800
X-Trace: forums-1-dub 1101141736 10.22.241.41 (22 Nov 2004 08:42:16 -0800)
X-Original-Trace: 22 Nov 2004 08:42:16 -0800, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3896
Article PK: 7791

Hi all,

We are getting the following error when trying to start
an Adaptive server anywhere 8.0.3 database on a client site
running Windows 2000.

Internal database error **Assertion Failure**
invalid count or free space offset detected on
a free list page. Transaction rolled back.

I've tried recorvering the database using the -f (recovery)
parameter but no joy, is my only option recovering from a
backup or is there anything else I can try.

Any help will be gratly appreciated.


Chris Keating (iAnywhere Solutions) Posted on 2004-11-22 18:02:16.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <41a216e8.2094.1681692777@sybase.com>
Subject: Re: Internal db error***Assertion***
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <41a229a8$1@forums-1-dub>
Date: 22 Nov 2004 10:02:16 -0800
X-Trace: forums-1-dub 1101146536 10.25.98.199 (22 Nov 2004 10:02:16 -0800)
X-Original-Trace: 22 Nov 2004 10:02:16 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3898
Article PK: 7790

-f is NOT a recovery switch. In fact, you can do more damage than good using
switches such as -f if you do not understand what they do and their proper
use. Hopefully, you have a copy of the problem database files and logs prior
to issuing the -f so that you can start fresh.

You should review the documentation related to recovery. I would recommend
that you use recovery methods that start with a backup and leave the -f
swtich when the recovery from backup and other methods fail.

<Ollie> wrote in message news:41a216e8.2094.1681692777@sybase.com...
> Hi all,
>
> We are getting the following error when trying to start
> an Adaptive server anywhere 8.0.3 database on a client site
> running Windows 2000.
>
> Internal database error **Assertion Failure**
> invalid count or free space offset detected on
> a free list page. Transaction rolled back.
>
> I've tried recorvering the database using the -f (recovery)
> parameter but no joy, is my only option recovering from a
> backup or is there anything else I can try.
>
> Any help will be gratly appreciated.


Ollie Posted on 2004-11-23 10:20:58.0Z
Sender: 2cde.41a30e28.1804289383@sybase.com
From: Ollie
Newsgroups: ianywhere.public.general
Subject: Re: Internal db error***Assertion***
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41a30f0a.2cf5.1681692777@sybase.com>
References: <41a229a8$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Nov 2004 02:20:58 -0800
X-Trace: forums-1-dub 1101205258 10.22.241.41 (23 Nov 2004 02:20:58 -0800)
X-Original-Trace: 23 Nov 2004 02:20:58 -0800, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3900
Article PK: 7795

Thanks for your help guys, time for some backup
recovery. Many Thanks.

Ollie

> -f is NOT a recovery switch. In fact, you can do more
> damage than good using switches such as -f if you do not
> understand what they do and their proper use. Hopefully,
> you have a copy of the problem database files and logs
> prior to issuing the -f so that you can start fresh.
>
> You should review the documentation related to recovery. I
> would recommend that you use recovery methods that start
> with a backup and leave the -f swtich when the recovery
> from backup and other methods fail.
>
>
>
> <Ollie> wrote in message
> > news:41a216e8.2094.1681692777@sybase.com... Hi all,
> >
> > We are getting the following error when trying to start
> > an Adaptive server anywhere 8.0.3 database on a client
> > site running Windows 2000.
> >
> > Internal database error **Assertion Failure**
> > invalid count or free space offset detected on
> > a free list page. Transaction rolled back.
> >
> > I've tried recorvering the database using the -f
> > (recovery) parameter but no joy, is my only option
> > recovering from a backup or is there anything else I can
> try. >
> > Any help will be gratly appreciated.
>
>


Joshua Savill Posted on 2004-11-22 17:53:56.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41a216e8.2094.1681692777@sybase.com>
Subject: Re: Internal db error***Assertion***
Lines: 46
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: jsavill-xp.sybase.com
X-Original-NNTP-Posting-Host: jsavill-xp.sybase.com
Message-ID: <41a227b4@forums-1-dub>
Date: 22 Nov 2004 09:53:56 -0800
X-Trace: forums-1-dub 1101146036 10.25.98.148 (22 Nov 2004 09:53:56 -0800)
X-Original-Trace: 22 Nov 2004 09:53:56 -0800, jsavill-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3897
Article PK: 7793

Ollie,

If you cannot start the database using the -f (recovery) switch, then you
best bet is to recover from a valid backup and apply the transaction log.
Before proceeding, I recommend making backup copies of the current state of
the database and log files. For instructions please refer to:

SQL Remote User's Guide
11. Administering SQL Remote for Adaptive Server Anywhere
Transaction log and backup management
Recovery from database media failure for consolidated databases
Recovery with a single transaction log
or
SQL Remote User's Guide
11. Administering SQL Remote for Adaptive Server Anywhere
Transaction log and backup management
Recovery from database media failure for consolidated databases

Recovery with multiple transaction logs
NOTE: Usually the best way of recovering a corrupt database is to "start" by
using a valid backup and applying the transaction logs to bring the database
back up to date. It is only recommend to us the -f (recovery) switch if
there is no backup or a non-valid backup.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<Ollie> wrote in message news:41a216e8.2094.1681692777@sybase.com...
> Hi all,
>
> We are getting the following error when trying to start
> an Adaptive server anywhere 8.0.3 database on a client site
> running Windows 2000.
>
> Internal database error **Assertion Failure**
> invalid count or free space offset detected on
> a free list page. Transaction rolled back.
>
> I've tried recorvering the database using the -f (recovery)
> parameter but no joy, is my only option recovering from a
> backup or is there anything else I can try.
>
> Any help will be gratly appreciated.