Question Unexpected wake-up from wait code -3 (1007) caused database shutdown

[André Ficken]

The database at my client is 9.1e SP 4. They are running Workgroup server, Dataserver for SQL and 4 brokers for ODBC SQL access. In the past we occasionally ran into this error. We restarted the database and everything was ok. But since a few weeks this error occurs more frequent as in 3 times a week, so we are now anxious to get this error analysed and resolved.

From the shutdown this morning, I have traced the error back to a SQL client that connects via ODBC (READ UNCOMMITTED) at 1pm yesterday. Probably gets some work done on the database (mostly reading large volumes of records) and DOES NOT GET DISCONNECTED. I cannot find anything anymore on the session that started the SQL client, but at 5:53am this morning the SQL client connection got a wake-up call and the server responded with 'unexpected wake-up from wait code -3 user 11 (1007)'. This caused watchdog to shut the database down.

Progress message suggests a couple of things to do and causes, but none of these point me to the cause of the problem. I would like to know what the meaning of the wait-code -3 is.... so that I can continue my search for the thing that caused this database shutdown problem.

 

[Rob Fitzpatrick]

Did you check the Knowledge Base? I found some hits for "wait code" and "error 1007".

Wait code error numbers and their meanings which are returned from progress message 1007.
http://knowledgebase.progress.com/articles/Article/16510/p
Database crashes with SYSTEM ERROR 1007
http://knowledgebase.progress.com/articles/Article/P117466/p
Enterprise database crashes from unexpected wakeup calls (1007)
http://knowledgebase.progress.com/articles/Article/P101120/p
Error 1007 in the database log file.
http://knowledgebase.progress.com/articles/Article/P25868/p

Based on the above you might want to try adding -spin 1 to your primary broker startup parameters if you haven't already.

You can search for articles in the KB at the base URL above, or you can download and use the Windows GUI tool ProKB which is nice because of its different search capabilities and because it can be used offline.

ProKB:
http://download.progress.com/open/products/prokb/ProKBsetup.exe

If you are a partner you can access the Partner KB at:
https://progress.my.salesforce.com/knowledge/knowledgeHome.apexp