on 12-03-2015 8:34 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.