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.

Assertion Error - Corrupt transaction log

2 posts in General Discussion Last posting was on 2007-03-19 14:07:20.0Z
ericr Posted on 2007-03-15 19:41:45.0Z
From: ericr@trans-soft.net
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Assertion Error - Corrupt transaction log
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ip68-3-164-106.ph.ph.cox.net
X-Original-NNTP-Posting-Host: ip68-3-164-106.ph.ph.cox.net
Message-ID: <45f9a179$1@forums-1-dub>
Date: 15 Mar 2007 11:41:45 -0800
X-Trace: forums-1-dub 1173987705 68.3.164.106 (15 Mar 2007 11:41:45 -0800)
X-Original-Trace: 15 Mar 2007 11:41:45 -0800, ip68-3-164-106.ph.ph.cox.net
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5892
Article PK: 1873

I have a client running the following:

ASA: 9.0.2.2451
OS: Window XP

Got the usual Assertion error, 'Invalid count or free space .....
transaction rolled back'

When I logged into their system, they had tried to restart the service
via Sybase Central and it failed. I found this in the server logfile:

I. 03/15 11:16:43. Transaction log: transoft.log...
E. 03/15 11:16:45. Error: Database cannot be started -- transoft.log is
an invalid transaction log
I. 03/15 11:16:45. Error: Database cannot be started -- transoft.log is
an invalid transaction log
I. 03/15 11:16:45.
E. 03/15 11:16:45. Database cannot be started -- transoft.log is an
invalid transaction log

I'm hoping I can restart the server and create a new transaction log
file and then dump the bad one out into sql and run it in isql.

How do I do that?

Thanks
Eric


Joshua Savill Posted on 2007-03-19 14:07:20.0Z
From: "Joshua Savill" <nospam_jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <45f9a179$1@forums-1-dub>
Subject: Re: Assertion Error - Corrupt transaction log
Lines: 39
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: jsavill-d620.sybase.com
X-Original-NNTP-Posting-Host: jsavill-d620.sybase.com
Message-ID: <45fe9918$1@forums-1-dub>
Date: 19 Mar 2007 06:07:20 -0800
X-Trace: forums-1-dub 1174313240 10.56.33.195 (19 Mar 2007 06:07:20 -0800)
X-Original-Trace: 19 Mar 2007 06:07:20 -0800, jsavill-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5899
Article PK: 1879

Good place to start:
http://www.ianywhere.com/developer/technotes/sa_how_to_handle_assertion_error.html

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<ericr@trans-soft.net> wrote in message news:45f9a179$1@forums-1-dub...
>I have a client running the following:
>
> ASA: 9.0.2.2451
> OS: Window XP
>
> Got the usual Assertion error, 'Invalid count or free space .....
> transaction rolled back'
>
> When I logged into their system, they had tried to restart the service via
> Sybase Central and it failed. I found this in the server logfile:
>
> I. 03/15 11:16:43. Transaction log: transoft.log...
> E. 03/15 11:16:45. Error: Database cannot be started -- transoft.log is an
> invalid transaction log
> I. 03/15 11:16:45. Error: Database cannot be started -- transoft.log is an
> invalid transaction log
> I. 03/15 11:16:45.
> E. 03/15 11:16:45. Database cannot be started -- transoft.log is an
> invalid transaction log
>
> I'm hoping I can restart the server and create a new transaction log file
> and then dump the bad one out into sql and run it in isql.
>
> How do I do that?
>
> Thanks
> Eric