on 2012 Sep 26 12:10 PM
One of our users received an assertion error message, on Windows 2008 server running SA 5.5.05 build # 2817. There is no transaction log defined and the event viewer displayed the error message below:
*** ERROR *** Assertion failed: 52101 Error during checkpoint when operating without transaction log
In order to restart the service they replaced the database with the last night's backup
Any suggestions on how to check the source of the issues?
UPDATE: dbvalid didn't indicate any issues.
Request clarification before answering.
It does need to be remember that versions 5.5 and 6.0 went "End of Support" 12 years ago. And in this case version 5.5 was never tested with any of the currently shipping operating systems so there may be an issue there.
For assertions you should first refer to the technical whitepaper:
"I've got an assertion! What should I do?"
http://www.sybase.com/detail?id=1010805
In your customer's case if the continue to have or are repeateding having the assertion even after restoring the backup then the problem may also exist in the backup. As such you may need to rebuild the backup or resort to a database salvage.
Adding a transaction log should change the nature of the assertion and may prove to be more diagnostic but if this is due to corruption in the file then you may have no choice but to salvage the file some other way.
Do contact technical support if you make no progress with the information provided in the link (above).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am sorry but I have found no recent support cases opened up concering this question. Did you contact 1-800-8-SYBASE (option 3) or a support office in your locale http://www.sybase.com/contactus/support#tech ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, did you check for email support as well? I made contact via email - I can forward it to anyone else.
There is no option to open official technical support cases via e-mail. You can either use the phone to call your local support office number and have a case opened for you, or you can log a case yourself via our website: http://case-express.sybase.com/ and have it dispatched to a technical support representative. Be sure to mention you are working with SQL Anywhere.
Since you are working with version 5, you will want to keep in mind our support policy on End-of-Life products, as we can only provide "limited technical assistance" through technical support - there is no engineering support.
If you e-mailed someone at Sybase directly, I'd recommend responding to them and instead open a case through the proper support channels (listed above). We can then track your issue properly once it's in the system.
User | Count |
---|---|
50 | |
10 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.