dbTalk Databases Forums  

assertion error

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss assertion error in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Rolseth
 
Posts: n/a

Default assertion error - 08-04-2009 , 05:16 PM






We are running 11.0.1.2044 as a service on a Windows 2003 service.

Today, and several times since migrating to ASA11, the db locked up and we
received the message below in our EAServer log:
Aug 04 16:47:29 2009: cm__odbc_error: SQLError: -301, SQLState: HY000,
[Sybase][ODBC Driver][SQL Anywhere]Internal database error *** ERROR ***
Assertion failed: 201501 (11.0.1.2044)

Page for requested record not a table page or record not present on page --
transaction rolled back.

We rebooted the server and it seems to be running fine. I found one bad
index which I had to rebuild in Sybase Central. What can I do to determine
what is behind this error? Any ideas based on the assertion error id
(201501)? Thanks, Tom

Reply With Quote
  #2  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: assertion error - 08-05-2009 , 11:01 AM






Its probable this could be related to this bug

================(Build #2132 - Engineering Case #548870)================
A database could have become corrupted when deleting rows containing long
string (or binary) values that were indexed. The server then may have
crashed,
or failed an assertion, when attempting to read rows from the table at a
later time. The server would likely have crashed during full validation of
a table corrupted in this manner. This has been fixed. Dropping and
re-creating
the index should be a valid workaround.

which is fixed in the latest ebfs.

"Tom Rolseth" <trolseth (AT) microedge (DOT) com> wrote

Quote:
We are running 11.0.1.2044 as a service on a Windows 2003 service.

Today, and several times since migrating to ASA11, the db locked up and we
received the message below in our EAServer log:
Aug 04 16:47:29 2009: cm__odbc_error: SQLError: -301, SQLState: HY000,
[Sybase][ODBC Driver][SQL Anywhere]Internal database error *** ERROR ***
Assertion failed: 201501 (11.0.1.2044)

Page for requested record not a table page or record not present on
page -- transaction rolled back.

We rebooted the server and it seems to be running fine. I found one bad
index which I had to rebuild in Sybase Central. What can I do to
determine what is behind this error? Any ideas based on the assertion
error id (201501)? Thanks, Tom


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.