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 failed 50260 page number on page does not match page requested

7 posts in General Discussion (old) Last posting was on 2009-01-21 15:13:32.0Z
John Vai Posted on 2009-01-19 11:49:31.0Z
From: "John Vai" <john_vai@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Assertion failed 50260 page number on page does not match page requested
Lines: 16
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: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <497468cb$1@forums-1-dub>
Date: 19 Jan 2009 03:49:31 -0800
X-Trace: forums-1-dub 1232365771 10.22.241.152 (19 Jan 2009 03:49:31 -0800)
X-Original-Trace: 19 Jan 2009 03:49:31 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:236
Article PK: 866681

Dear Experts:

I would like to know if there is a way to recover a 5.5 database if i have
no valid transaction log.

i have set up the engine server with truncating the translation log on
checkpoint, and the only thing i have a very old database file and the
corrupted database file and a very old transaction log.

can i recover the database with the current data?

i tried the unload but it keeps saying assertion failed.

thank you


Stephen Rice [Sybase] Posted on 2009-01-19 14:55:11.0Z
From: "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom>
Newsgroups: sybase.public.sqlanywhere
References: <497468cb$1@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4974944f@forums-1-dub>
Date: 19 Jan 2009 06:55:11 -0800
X-Trace: forums-1-dub 1232376911 10.22.241.152 (19 Jan 2009 06:55:11 -0800)
X-Original-Trace: 19 Jan 2009 06:55:11 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:237
Article PK: 866678

:(

So, given you are trying to unload that means you can start the database and
it asserts at some point during the unload process?

If it does then you can try unloading the data table by table using either
unload table or select/output. It looks like it's a simple corrupt page(s).
The trick to to keep selecting stuff that you can get to without hitting the
corrupt page. This is an intensely manual process but you will get most of
what is available back.

An alternative is to contact technical support to request a database
salvage. This service costs significant $ and does not guarentee any
results.

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"John Vai" <john_vai@hotmail.com> wrote in message
news:497468cb$1@forums-1-dub...
> Dear Experts:
>
> I would like to know if there is a way to recover a 5.5 database if i have
> no valid transaction log.
>
> i have set up the engine server with truncating the translation log on
> checkpoint, and the only thing i have a very old database file and the
> corrupted database file and a very old transaction log.
>
> can i recover the database with the current data?
>
> i tried the unload but it keeps saying assertion failed.
>
> thank you
>
>


John Vai Posted on 2009-01-19 16:34:38.0Z
From: "John Vai" <john_vai@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
References: <497468cb$1@forums-1-dub> <4974944f@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 63
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4974ab9e@forums-1-dub>
Date: 19 Jan 2009 08:34:38 -0800
X-Trace: forums-1-dub 1232382878 10.22.241.152 (19 Jan 2009 08:34:38 -0800)
X-Original-Trace: 19 Jan 2009 08:34:38 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:238
Article PK: 866682

Dear Stephen:

the problem is that the engine is not starting at all otherwise i would know
how to unload step by step till i remove all the corrupted data. the thing
is that when it gets to the "recovery progress" on engine start, it gives
the assertion failed. the database is not running at all.

when it hits the corrupted page it gives the message and closes the engine.

thanks for the help!

"Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
news:4974944f@forums-1-dub...
> :(
>
> So, given you are trying to unload that means you can start the database
> and it asserts at some point during the unload process?
>
> If it does then you can try unloading the data table by table using either
> unload table or select/output. It looks like it's a simple corrupt
> page(s). The trick to to keep selecting stuff that you can get to without
> hitting the corrupt page. This is an intensely manual process but you
> will get most of what is available back.
>
> An alternative is to contact technical support to request a database
> salvage. This service costs significant $ and does not guarentee any
> results.
>
> --
> /steve
> Stephen Rice, Sybase iAnywhere
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
> "John Vai" <john_vai@hotmail.com> wrote in message
> news:497468cb$1@forums-1-dub...
>> Dear Experts:
>>
>> I would like to know if there is a way to recover a 5.5 database if i
>> have
>> no valid transaction log.
>>
>> i have set up the engine server with truncating the translation log on
>> checkpoint, and the only thing i have a very old database file and the
>> corrupted database file and a very old transaction log.
>>
>> can i recover the database with the current data?
>>
>> i tried the unload but it keeps saying assertion failed.
>>
>> thank you
>>
>>
>
>


Stephen Rice [Sybase] Posted on 2009-01-20 19:10:20.0Z
From: "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom>
Newsgroups: sybase.public.sqlanywhere
References: <497468cb$1@forums-1-dub> <4974944f@forums-1-dub> <4974ab9e@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 92
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4976219c$1@forums-1-dub>
Date: 20 Jan 2009 11:10:20 -0800
X-Trace: forums-1-dub 1232478620 10.22.241.152 (20 Jan 2009 11:10:20 -0800)
X-Original-Trace: 20 Jan 2009 11:10:20 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:239
Article PK: 866680

So whatever is corrupted is being accessed during recovery - an ugly thing
to be sure.

I would try renaming/moving the transaction log (usually <dbfilename>.log)
and then starting the engine as dbeng5 -f dbfilename.db. This starts the
database without a transaction log (skips recovery from the log)

If that doesn't work then you can try dbeng5 -O dbfilename.db This forces
the database to ignore the checkpoint log.

Both of these will leave your database in an inconsitent state so you will
need to verify the data manually

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"John Vai" <john_vai@hotmail.com> wrote in message
news:4974ab9e@forums-1-dub...
> Dear Stephen:
>
> the problem is that the engine is not starting at all otherwise i would
> know how to unload step by step till i remove all the corrupted data. the
> thing is that when it gets to the "recovery progress" on engine start, it
> gives the assertion failed. the database is not running at all.
>
> when it hits the corrupted page it gives the message and closes the
> engine.
>
> thanks for the help!
>
>
> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
> news:4974944f@forums-1-dub...
>> :(
>>
>> So, given you are trying to unload that means you can start the database
>> and it asserts at some point during the unload process?
>>
>> If it does then you can try unloading the data table by table using
>> either unload table or select/output. It looks like it's a simple
>> corrupt page(s). The trick to to keep selecting stuff that you can get to
>> without hitting the corrupt page. This is an intensely manual process
>> but you will get most of what is available back.
>>
>> An alternative is to contact technical support to request a database
>> salvage. This service costs significant $ and does not guarentee any
>> results.
>>
>> --
>> /steve
>> Stephen Rice, Sybase iAnywhere
>> Please reply only to the newsgroup
>>
>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>> -> Choose SQL Anywhere Studio
>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>
>> "John Vai" <john_vai@hotmail.com> wrote in message
>> news:497468cb$1@forums-1-dub...
>>> Dear Experts:
>>>
>>> I would like to know if there is a way to recover a 5.5 database if i
>>> have
>>> no valid transaction log.
>>>
>>> i have set up the engine server with truncating the translation log on
>>> checkpoint, and the only thing i have a very old database file and the
>>> corrupted database file and a very old transaction log.
>>>
>>> can i recover the database with the current data?
>>>
>>> i tried the unload but it keeps saying assertion failed.
>>>
>>> thank you
>>>
>>>
>>
>>
>
>


John Vai Posted on 2009-01-21 08:37:12.0Z
From: "John Vai" <john_vai@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
References: <497468cb$1@forums-1-dub> <4974944f@forums-1-dub> <4974ab9e@forums-1-dub> <4976219c$1@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 127
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4976deb8@forums-1-dub>
Date: 21 Jan 2009 00:37:12 -0800
X-Trace: forums-1-dub 1232527032 10.22.241.152 (21 Jan 2009 00:37:12 -0800)
X-Original-Trace: 21 Jan 2009 00:37:12 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:240
Article PK: 866683

Dear Stephen:

i tried what you told me.

when i try to remove/rename the transaction log it does it successfully
(dblog -t or -n) but when i use dbeng50 or dbsrv50 - f after this step and
run the command it gives me the assertion failed immediately, so i cannot
proceed with the remaining steps. even if i try to make -f -O in one command
the Asserion hits again.

the asserion error is like this:
********************************
2048K of memory used...
Database recovery in progress
last checkpoint on Sunday ...
Checkpoint log...

ERROR: Assertion failed 50260
page number on page does not match page requested

*******************************
it's very weird...

i just want to remind again that the original databasefile was set to have
its log file truncated on checkpoint
so when the computer shutdown unexpectedly, there was no checkpoint log. it
was deleted already...

i really appreciate your help!

"Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
news:4976219c$1@forums-1-dub...
> So whatever is corrupted is being accessed during recovery - an ugly thing
> to be sure.
>
> I would try renaming/moving the transaction log (usually <dbfilename>.log)
> and then starting the engine as dbeng5 -f dbfilename.db. This starts the
> database without a transaction log (skips recovery from the log)
>
> If that doesn't work then you can try dbeng5 -O dbfilename.db This forces
> the database to ignore the checkpoint log.
>
> Both of these will leave your database in an inconsitent state so you will
> need to verify the data manually
>
> --
> /steve
> Stephen Rice, Sybase iAnywhere
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
> "John Vai" <john_vai@hotmail.com> wrote in message
> news:4974ab9e@forums-1-dub...
>> Dear Stephen:
>>
>> the problem is that the engine is not starting at all otherwise i would
>> know how to unload step by step till i remove all the corrupted data. the
>> thing is that when it gets to the "recovery progress" on engine start, it
>> gives the assertion failed. the database is not running at all.
>>
>> when it hits the corrupted page it gives the message and closes the
>> engine.
>>
>> thanks for the help!
>>
>>
>> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
>> news:4974944f@forums-1-dub...
>>> :(
>>>
>>> So, given you are trying to unload that means you can start the database
>>> and it asserts at some point during the unload process?
>>>
>>> If it does then you can try unloading the data table by table using
>>> either unload table or select/output. It looks like it's a simple
>>> corrupt page(s). The trick to to keep selecting stuff that you can get
>>> to without hitting the corrupt page. This is an intensely manual
>>> process but you will get most of what is available back.
>>>
>>> An alternative is to contact technical support to request a database
>>> salvage. This service costs significant $ and does not guarentee any
>>> results.
>>>
>>> --
>>> /steve
>>> Stephen Rice, Sybase iAnywhere
>>> Please reply only to the newsgroup
>>>
>>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>>> -> Choose SQL Anywhere Studio
>>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>>
>>> "John Vai" <john_vai@hotmail.com> wrote in message
>>> news:497468cb$1@forums-1-dub...
>>>> Dear Experts:
>>>>
>>>> I would like to know if there is a way to recover a 5.5 database if i
>>>> have
>>>> no valid transaction log.
>>>>
>>>> i have set up the engine server with truncating the translation log on
>>>> checkpoint, and the only thing i have a very old database file and the
>>>> corrupted database file and a very old transaction log.
>>>>
>>>> can i recover the database with the current data?
>>>>
>>>> i tried the unload but it keeps saying assertion failed.
>>>>
>>>> thank you
>>>>
>>>>
>>>
>>>
>>
>>
>
>


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-01-21 14:42:04.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Assertion failed 50260 page number on page does not match page requested
References: <497468cb$1@forums-1-dub> <4974944f@forums-1-dub> <4974ab9e@forums-1-dub> <4976219c$1@forums-1-dub> <4976deb8@forums-1-dub>
In-Reply-To: <4976deb8@forums-1-dub>
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: <4977343c@forums-1-dub>
Date: 21 Jan 2009 06:42:04 -0800
X-Trace: forums-1-dub 1232548924 10.22.241.152 (21 Jan 2009 06:42:04 -0800)
X-Original-Trace: 21 Jan 2009 06:42:04 -0800, vip152.sybase.com
Lines: 145
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:241
Article PK: 866684

If you are not able to start the database files with the options
suggested, you may need to consider a data salvage (and technically the
unload of a corrupt database is a data salvage since there is a
potential for data loss). For salvage, you should provide the
database/transaction log prior to issuing any of the switches that Steve
suggested.

Alternatively, you can revert to the last good backup you have.

Whatever your decision, you should - once this crisis is addressed -
revisit your disaster plan for this system as it does not seem to be
meeting your needs. As a starting point, you may need to stop using -m
as it impedes recoverability. An alternative for managing your
transaction log size is to truncate the log while performing a backup of
the database. This approach provides you a backup should you encounter
problems with the database.Backup and recovery planning is discussed in
the documentation. You must determine the approach that best fits your
risk tolerance.

John Vai wrote:
> Dear Stephen:
>
> i tried what you told me.
>
> when i try to remove/rename the transaction log it does it successfully
> (dblog -t or -n) but when i use dbeng50 or dbsrv50 - f after this step and
> run the command it gives me the assertion failed immediately, so i cannot
> proceed with the remaining steps. even if i try to make -f -O in one command
> the Asserion hits again.
>
> the asserion error is like this:
> ********************************
> 2048K of memory used...
> Database recovery in progress
> last checkpoint on Sunday ...
> Checkpoint log...
>
> ERROR: Assertion failed 50260
> page number on page does not match page requested
>
> *******************************
> it's very weird...
>
> i just want to remind again that the original databasefile was set to have
> its log file truncated on checkpoint
> so when the computer shutdown unexpectedly, there was no checkpoint log. it
> was deleted already...
>
> i really appreciate your help!
>
>
> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
> news:4976219c$1@forums-1-dub...
>> So whatever is corrupted is being accessed during recovery - an ugly thing
>> to be sure.
>>
>> I would try renaming/moving the transaction log (usually <dbfilename>.log)
>> and then starting the engine as dbeng5 -f dbfilename.db. This starts the
>> database without a transaction log (skips recovery from the log)
>>
>> If that doesn't work then you can try dbeng5 -O dbfilename.db This forces
>> the database to ignore the checkpoint log.
>>
>> Both of these will leave your database in an inconsitent state so you will
>> need to verify the data manually
>>
>> --
>> /steve
>> Stephen Rice, Sybase iAnywhere
>> Please reply only to the newsgroup
>>
>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>> -> Choose SQL Anywhere Studio
>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>
>> "John Vai" <john_vai@hotmail.com> wrote in message
>> news:4974ab9e@forums-1-dub...
>>> Dear Stephen:
>>>
>>> the problem is that the engine is not starting at all otherwise i would
>>> know how to unload step by step till i remove all the corrupted data. the
>>> thing is that when it gets to the "recovery progress" on engine start, it
>>> gives the assertion failed. the database is not running at all.
>>>
>>> when it hits the corrupted page it gives the message and closes the
>>> engine.
>>>
>>> thanks for the help!
>>>
>>>
>>> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
>>> news:4974944f@forums-1-dub...
>>>> :(
>>>>
>>>> So, given you are trying to unload that means you can start the database
>>>> and it asserts at some point during the unload process?
>>>>
>>>> If it does then you can try unloading the data table by table using
>>>> either unload table or select/output. It looks like it's a simple
>>>> corrupt page(s). The trick to to keep selecting stuff that you can get
>>>> to without hitting the corrupt page. This is an intensely manual
>>>> process but you will get most of what is available back.
>>>>
>>>> An alternative is to contact technical support to request a database
>>>> salvage. This service costs significant $ and does not guarentee any
>>>> results.
>>>>
>>>> --
>>>> /steve
>>>> Stephen Rice, Sybase iAnywhere
>>>> Please reply only to the newsgroup
>>>>
>>>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>>>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>>>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>>>> -> Choose SQL Anywhere Studio
>>>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>>>
>>>> "John Vai" <john_vai@hotmail.com> wrote in message
>>>> news:497468cb$1@forums-1-dub...
>>>>> Dear Experts:
>>>>>
>>>>> I would like to know if there is a way to recover a 5.5 database if i
>>>>> have
>>>>> no valid transaction log.
>>>>>
>>>>> i have set up the engine server with truncating the translation log on
>>>>> checkpoint, and the only thing i have a very old database file and the
>>>>> corrupted database file and a very old transaction log.
>>>>>
>>>>> can i recover the database with the current data?
>>>>>
>>>>> i tried the unload but it keeps saying assertion failed.
>>>>>
>>>>> thank you
>>>>>
>>>>>
>>>>
>>>
>>
>
>


Stephen Rice [Sybase] Posted on 2009-01-21 15:13:32.0Z
From: "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom>
Newsgroups: sybase.public.sqlanywhere
References: <497468cb$1@forums-1-dub> <4974944f@forums-1-dub> <4974ab9e@forums-1-dub> <4976219c$1@forums-1-dub> <4976deb8@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 152
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49773b9c$1@forums-1-dub>
Date: 21 Jan 2009 07:13:32 -0800
X-Trace: forums-1-dub 1232550812 10.22.241.152 (21 Jan 2009 07:13:32 -0800)
X-Original-Trace: 21 Jan 2009 07:13:32 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:242
Article PK: 866685

As Chris notes, if those didn't work you will not be able to recover the
data. Our salvage service might be able to, but I suspect the corruption is
in the database header pages so it's hard to say how successfull it might
be.

If you are interested in a salvage you will need to open a technical support
case then enter into a salvage contract. Both cost $.

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"John Vai" <john_vai@hotmail.com> wrote in message
news:4976deb8@forums-1-dub...
> Dear Stephen:
>
> i tried what you told me.
>
> when i try to remove/rename the transaction log it does it successfully
> (dblog -t or -n) but when i use dbeng50 or dbsrv50 - f after this step and
> run the command it gives me the assertion failed immediately, so i cannot
> proceed with the remaining steps. even if i try to make -f -O in one
> command the Asserion hits again.
>
> the asserion error is like this:
> ********************************
> 2048K of memory used...
> Database recovery in progress
> last checkpoint on Sunday ...
> Checkpoint log...
>
> ERROR: Assertion failed 50260
> page number on page does not match page requested
>
> *******************************
> it's very weird...
>
> i just want to remind again that the original databasefile was set to have
> its log file truncated on checkpoint
> so when the computer shutdown unexpectedly, there was no checkpoint log.
> it was deleted already...
>
> i really appreciate your help!
>
>
> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
> news:4976219c$1@forums-1-dub...
>> So whatever is corrupted is being accessed during recovery - an ugly
>> thing to be sure.
>>
>> I would try renaming/moving the transaction log (usually
>> <dbfilename>.log) and then starting the engine as dbeng5 -f
>> dbfilename.db. This starts the database without a transaction log (skips
>> recovery from the log)
>>
>> If that doesn't work then you can try dbeng5 -O dbfilename.db This
>> forces the database to ignore the checkpoint log.
>>
>> Both of these will leave your database in an inconsitent state so you
>> will need to verify the data manually
>>
>> --
>> /steve
>> Stephen Rice, Sybase iAnywhere
>> Please reply only to the newsgroup
>>
>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>> -> Choose SQL Anywhere Studio
>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>
>> "John Vai" <john_vai@hotmail.com> wrote in message
>> news:4974ab9e@forums-1-dub...
>>> Dear Stephen:
>>>
>>> the problem is that the engine is not starting at all otherwise i would
>>> know how to unload step by step till i remove all the corrupted data.
>>> the thing is that when it gets to the "recovery progress" on engine
>>> start, it gives the assertion failed. the database is not running at
>>> all.
>>>
>>> when it hits the corrupted page it gives the message and closes the
>>> engine.
>>>
>>> thanks for the help!
>>>
>>>
>>> "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom> wrote in message
>>> news:4974944f@forums-1-dub...
>>>> :(
>>>>
>>>> So, given you are trying to unload that means you can start the
>>>> database and it asserts at some point during the unload process?
>>>>
>>>> If it does then you can try unloading the data table by table using
>>>> either unload table or select/output. It looks like it's a simple
>>>> corrupt page(s). The trick to to keep selecting stuff that you can get
>>>> to without hitting the corrupt page. This is an intensely manual
>>>> process but you will get most of what is available back.
>>>>
>>>> An alternative is to contact technical support to request a database
>>>> salvage. This service costs significant $ and does not guarentee any
>>>> results.
>>>>
>>>> --
>>>> /steve
>>>> Stephen Rice, Sybase iAnywhere
>>>> Please reply only to the newsgroup
>>>>
>>>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>>>> iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
>>>> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
>>>> -> Choose SQL Anywhere Studio
>>>> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>>>>
>>>> "John Vai" <john_vai@hotmail.com> wrote in message
>>>> news:497468cb$1@forums-1-dub...
>>>>> Dear Experts:
>>>>>
>>>>> I would like to know if there is a way to recover a 5.5 database if i
>>>>> have
>>>>> no valid transaction log.
>>>>>
>>>>> i have set up the engine server with truncating the translation log on
>>>>> checkpoint, and the only thing i have a very old database file and the
>>>>> corrupted database file and a very old transaction log.
>>>>>
>>>>> can i recover the database with the current data?
>>>>>
>>>>> i tried the unload but it keeps saying assertion failed.
>>>>>
>>>>> thank you
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>