"Freeing page not in arena" -- the whole database gets corrupted

[Former Member]

Hi, I have the following major crash on the following case:

I'm using SQLAnywhere 16.0.0.2234

Structure Table:

When I click Data tab

Very few records: 14 rows

When I execute interactive sql: Select * From Proc_pic_survey results are ok

When I execute an Update command I have the following:

I've got the final error:

The set of domains could not be read from the database.

Connection was terminated

[Sybase][ODBC Driver][SQL Anywhere]Connection was terminated

SQLCODE: -308

SQLSTATE: 08S01

When I tried to delete the complete table, the Sybase Central freezes and the service stops. I cannot restart it, and the whole database seems corrupted after that - the service that uses is cannot initialize, and I can't connect to it any more via ODBC.

Anyone have any idea what the error message means? Could it be some sort of limitation on the size of the pictures stored?

Thanks for all suggestion

Pascal

[former_member186998]

Hi Pascal,

You should try the following options first.

-f database server recovery option

http://dcx.sap.com/index.html#sa160/en/dbadmin/rec-f-database-dbengine.html

When you do not restore with this option, you try following KBA.

1958942 - Error: "Assertion failed: 123456" / SQLCODE -301 "Internal Database Error" - Handling an Assertion Failure

1959030 - How To Salvage Data When There are Corrupt Pages in the Database

Thanks,
Atsushi

[former_member207653]

Can you please verify if the latest patch of SQL Anywhere helps?

If not, can you open an incident with Product Support?