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.

BACKUP ... TRANSACTION LOG RENAME

6 posts in General Discussion Last posting was on 2004-10-18 13:22:26.0Z
Dmitriy Popov <none Posted on 2004-10-08 16:44:27.0Z
Newsgroups: ianywhere.public.general
Subject: BACKUP ... TRANSACTION LOG RENAME
From: Dmitriy Popov <none@none.>
Organization: Tenmast
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: 216.248.61.18
Message-ID: <4166c3e7$1@forums-2-dub>
X-Original-Trace: 8 Oct 2004 09:44:23 -0700, 216.248.61.18
Lines: 21
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Oct 2004 09:44:24 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Oct 2004 09:44:27 -0700
X-Trace: forums-1-dub 1097253867 10.22.108.75 (8 Oct 2004 09:44:27 -0700)
X-Original-Trace: 8 Oct 2004 09:44:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3715
Article PK: 7615

ASA 9.0.1 1922

When I run

BACKUP DATABASE DIRECTORY 'C:\\MyPath' TRANSACTION LOG RENAME MATCH

Sometimes the server just stops and I have to restart it.
Sometimes I get this:

Internal database error *** ERROR *** Assertion failed: 101518
(9.0.1.1922)
Freeing already-freed memory -- transaction rolled back
SQLCODE = -301, ODBC 3 State = "HY000"

db_valid with full check - no errors.

Unload database, all objects - Success, no errors.

Has anybody seen anything like this before?

Appreciate your help.


Nick Elson Posted on 2004-10-12 17:22:29.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <4166c3e7$1@forums-2-dub>
Subject: Re: BACKUP ... TRANSACTION LOG RENAME
Lines: 65
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: 10.25.98.139
X-Original-NNTP-Posting-Host: 10.25.98.139
Message-ID: <416c12d5$1@forums-1-dub>
Date: 12 Oct 2004 10:22:29 -0700
X-Trace: forums-1-dub 1097601749 10.25.98.139 (12 Oct 2004 10:22:29 -0700)
X-Original-Trace: 12 Oct 2004 10:22:29 -0700, 10.25.98.139
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3728
Article PK: 7627

If you run

dbbackup -t -r -n 'C:\\MyPath'

from a command prompt you should be able to measure how
far the backup has gotten and whether it has started renaming
the log, or has renamed the log, at the point of failure.


This sounds like an internal condition and something that would
be a soft assertion (and so dbvalid would never see corruption).

You may be able to avoid this by starting the server with a lot
more cache.

You can also get past this 'current log backup' [if that is the
only problem] by

1 - cycling the server down.
2 - Starting the engine once (to perform any recovery) and
3 - shutting that down (to perform a clean shutdown) ,
and then,
4 - manually copying and renaming the log file using XCOPY
and REN.

After which the server should restart and create the next log
cleanly (and without any gaps so replication and synchronization,
as well as, recoverability from backup should not be affected).

If you hit this problem after a successful backup and it occurs
every time or you are not able to get past this, then you might
want to open up a support case and speak with someone
directly about this. Alternatively, submitting this database,
server command line and -o console log [showing -Z output,
startup conditions and everything up to the assertion] is another
way to go; if production is not critically affected.

"Dmitriy Popov" <none@none.> wrote in message
news:4166c3e7$1@forums-2-dub...
> ASA 9.0.1 1922
>
> When I run
>
> BACKUP DATABASE DIRECTORY 'C:\\MyPath' TRANSACTION LOG RENAME MATCH
>
> Sometimes the server just stops and I have to restart it.
> Sometimes I get this:
>
> Internal database error *** ERROR *** Assertion failed: 101518
> (9.0.1.1922)
> Freeing already-freed memory -- transaction rolled back
> SQLCODE = -301, ODBC 3 State = "HY000"
>
> db_valid with full check - no errors.
>
> Unload database, all objects - Success, no errors.
>
> Has anybody seen anything like this before?
>
> Appreciate your help.


Dmitriy Popov <none Posted on 2004-10-13 12:37:16.0Z
Newsgroups: ianywhere.public.general
Subject: Re: BACKUP ... TRANSACTION LOG RENAME
From: Dmitriy Popov <none@none.>
References: <4166c3e7$1@forums-2-dub> <416c12d5$1@forums-1-dub>
Organization: Tenmast
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 216.248.61.18
X-Original-NNTP-Posting-Host: 216.248.61.18
Message-ID: <416d217c$1@forums-1-dub>
Date: 13 Oct 2004 05:37:16 -0700
X-Trace: forums-1-dub 1097671036 216.248.61.18 (13 Oct 2004 05:37:16 -0700)
X-Original-Trace: 13 Oct 2004 05:37:16 -0700, 216.248.61.18
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3729
Article PK: 7630

Thank you so much, Nick!

I got it to rename this time. It was able to rename, just wouldn't stay
on, so I couldn't schedule a weekly or monthly rename. I will try what
you were suggesting next time I dial in there.

Thanks for the "clean rename" option, too. Makes a lot of sence.

Dmitriy.

"Nick Elson" <no_spam_nicelson@sybase.com> wrote in news:416c12d5$1
@forums-1-dub:

> If you run
>
> dbbackup -t -r -n 'C:\\MyPath'
>
> from a command prompt you should be able to measure how
> far the backup has gotten and whether it has started renaming
> the log, or has renamed the log, at the point of failure.
>
>
> This sounds like an internal condition and something that would
> be a soft assertion (and so dbvalid would never see corruption).
>
> You may be able to avoid this by starting the server with a lot
> more cache.
>
> You can also get past this 'current log backup' [if that is the
> only problem] by
>
> 1 - cycling the server down.
> 2 - Starting the engine once (to perform any recovery) and
> 3 - shutting that down (to perform a clean shutdown) ,
> and then,
> 4 - manually copying and renaming the log file using XCOPY
> and REN.
>
> After which the server should restart and create the next log
> cleanly (and without any gaps so replication and synchronization,
> as well as, recoverability from backup should not be affected).
>
> If you hit this problem after a successful backup and it occurs
> every time or you are not able to get past this, then you might
> want to open up a support case and speak with someone
> directly about this. Alternatively, submitting this database,
> server command line and -o console log [showing -Z output,
> startup conditions and everything up to the assertion] is another
> way to go; if production is not critically affected.


Dmitriy Popov <none Posted on 2004-10-13 21:36:58.0Z
Newsgroups: ianywhere.public.general
Subject: Re: BACKUP ... TRANSACTION LOG RENAME
From: Dmitriy Popov <none@none.>
References: <4166c3e7$1@forums-2-dub> <416c12d5$1@forums-1-dub>
Organization: Tenmast
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 216.248.61.18
X-Original-NNTP-Posting-Host: 216.248.61.18
Message-ID: <416d9ffa$1@forums-1-dub>
Date: 13 Oct 2004 14:36:58 -0700
X-Trace: forums-1-dub 1097703418 216.248.61.18 (13 Oct 2004 14:36:58 -0700)
X-Original-Trace: 13 Oct 2004 14:36:58 -0700, 216.248.61.18
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3732
Article PK: 7633


> 4 - manually copying and renaming the log file using XCOPY
> and REN.
>
> After which the server should restart and create the next log
> cleanly (and without any gaps so replication and synchronization,
> as well as, recoverability from backup should not be affected).

I tried to rename the log and start the database - it won't create a new
one - fails to start. So I put the log back and used the TRANSACTION LOG
RENAME option.

If I don't rename it, and copy it as you said - how will it restart the
log?


Nick Elson Posted on 2004-10-15 16:29:57.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <4166c3e7$1@forums-2-dub> <416c12d5$1@forums-1-dub> <416d9ffa$1@forums-1-dub>
Subject: Re: BACKUP ... TRANSACTION LOG RENAME
Lines: 52
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
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <416ffb00$1@forums-2-dub>
X-Original-Trace: 15 Oct 2004 09:29:52 -0700, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Oct 2004 09:29:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Oct 2004 09:29:57 -0700
X-Trace: forums-1-dub 1097857797 10.22.108.75 (15 Oct 2004 09:29:57 -0700)
X-Original-Trace: 15 Oct 2004 09:29:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3737
Article PK: 7636


> I tried to rename the log and start the database - it won't create a new
> one - fails to start.

If you start and stop the engine a few times and not make any connections
or changes to the database, then the database and log should be entirely
quiesced and fully recovered. After that point the database should not
need the log to recover from and so should be able to start a new one.

If it fails to start without that log, then you have pending operations
that need to be rolled back or applied [most likely because of a problem
in the checkpoint log I suspect].

Why would it need to recover if there were not pending transactions?
I do not know, but can think of these possibilities:

- some event in the database that never completes, or commit
- maybe some Java code in the database that is spawning connections
or tasks
- some external processes that connect before you can shut the engine
down cleaning [look for running services, which could be web servers,
J2EE application servers, scheduled tasks, running application ... ]
- other databases that have proxy definitions to this database as a
remote
server ...

all of which could be a source of your original problem (if version 7 or
earlier
product) but all I can say at this point is ... happy hunting

> If I don't rename it, and copy it as you said - how will it restart the
> log?

It won't unless your BACKUP ... TRANSACTION LOG RENAME is
working now.

"Dmitriy Popov" <none@none.> wrote in message
news:416d9ffa$1@forums-1-dub...
>> 4 - manually copying and renaming the log file using XCOPY
>> and REN.
>>
>> After which the server should restart and create the next log
>> cleanly (and without any gaps so replication and synchronization,
>> as well as, recoverability from backup should not be affected).
>
> I tried to rename the log and start the database - it won't create a new
> one - fails to start. So I put the log back and used the TRANSACTION LOG
> RENAME option.
>
> If I don't rename it, and copy it as you said - how will it restart the
> log?


Dmitriy Popov <none Posted on 2004-10-18 13:22:26.0Z
Newsgroups: ianywhere.public.general
Subject: Re: BACKUP ... TRANSACTION LOG RENAME
From: Dmitriy Popov <none@none.>
References: <4166c3e7$1@forums-2-dub> <416c12d5$1@forums-1-dub> <416d9ffa$1@forums-1-dub> <416ffb00$1@forums-2-dub>
Organization: Tenmast
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 216.248.61.18
X-Original-NNTP-Posting-Host: 216.248.61.18
Message-ID: <4173c392$1@forums-1-dub>
Date: 18 Oct 2004 06:22:26 -0700
X-Trace: forums-1-dub 1098105746 216.248.61.18 (18 Oct 2004 06:22:26 -0700)
X-Original-Trace: 18 Oct 2004 06:22:26 -0700, 216.248.61.18
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3745
Article PK: 7643

I think I know what I was doing wrong. I don't remember if I did the
engine run on it. I probably failed to do it. I will try it all again
next time.

Thanks a lot for your help!

"Nick Elson" <no_spam_nicelson@sybase.com> wrote in
news:416ffb00$1@forums-2-dub:

>> I tried to rename the log and start the database - it won't create a
>> new one - fails to start.
>
> If you start and stop the engine a few times and not make any
> connections or changes to the database, then the database and log
> should be entirely quiesced and fully recovered. After that point
> the database should not need the log to recover from and so should be
> able to start a new one.
>
> If it fails to start without that log, then you have pending
> operations that need to be rolled back or applied [most likely because
> of a problem in the checkpoint log I suspect].
>
> Why would it need to recover if there were not pending transactions?
> I do not know, but can think of these possibilities:
>
> - some event in the database that never completes, or commit
> - maybe some Java code in the database that is spawning
> connections
> or tasks
> - some external processes that connect before you can shut the
> engine
> down cleaning [look for running services, which could be web
> servers, J2EE application servers, scheduled tasks, running
> application ... ]
> - other databases that have proxy definitions to this database as
> a
> remote
> server ...
>
> all of which could be a source of your original problem (if version 7
> or earlier
> product) but all I can say at this point is ... happy hunting
>
>> If I don't rename it, and copy it as you said - how will it restart
>> the log?
>
> It won't unless your BACKUP ... TRANSACTION LOG RENAME is
> working now.