|
In our product new version we are using SA 12.0.1.3827 Linux (previous product version based on SA 12.0.1.3519 Linux).On two customers sites after 1-2 month running appears follow problem - DB stopped allows any activities :
What could be reason for this problem? Please Advise |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 26 Jul '13, 15:42
question was seen: 2,335 times
last updated: 27 Jul '13, 14:47
Your best bet would be to contact Tech Support: http://www.sybase.com/contactus/support/
After killing the process, can they restart the server, and does it work OK after that? How long does it take before crashing again?
Historically speaking, SQL Anywhere 9 exhibited the following symptom at one financial services client site I was familiar with: The database would become unresponsive, with no activity at all, no new connections allowed. The workaround was to kill the process and restart the server. This became a regular activity, performed by IT staff without discussion, and the management and user community became used to it. Upgrading to SQL Anywhere 10 eliminated the symptom.
I am NOT saying this is happening again, to you... I am just telling you that "unresponsive server" is one of the hardest symptoms to deal with.
The good news is, Version 12 has a lot more tech support instrumentation built in, so maybe they can help.
After DB server kill and restart DB server and applications. The service continue to work properly. Meanwhile it doesn't happens twice on the same customers sites, but as mention it was happen on two different customers sites, after upgrade product version based on SA 12.0.1.3519 to SA 12.0.1.3827