Exceeding Page Size Assertion

[Former Member]

We have one customer with a database (around 1GB, we've had much bigger!) and it's just a bunch of tables (about 130 tables).

They are getting an assertion error (latest version of Sybase SQL Anywhere 12.01)

Some data structure within the server is normally allocated within a single memory page and it is exceeding the page size

It is a production issue - and makes no sense.   Where would I even begin looking / why is it GPFing?

[former_member188493]

What is the page size?

What is the exact assertion error message?

Historically speaking, there have been problems when "a large number of X conflicts with a small page size Y"; e.g., millions of locks versus a 2K page size where the page size affected the internal space available to record the locks.

That may not have anything to do with your symptom, but your mention of "data structure within the server" raises the suspicion.

[reimer_pods]

What build of SQL Anywhere is being used (e.g. 12.0.1.3324)? This might possibly be a bug that has been fixed in a recent service pack.

[Former Member]

SQLANYs_roommaster

*** ERROR *** Assertion failed: 109505 (12.0.1.4216)[xdb]

Memory allocation size too large

They are on Sybase 12.0.1.4216

[former_member188493]

See this forum conversation.