Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

All threads are blocked

Error constant SQLE_THREAD_DEADLOCK
ODBC 2 State 40001
ODBC 3 State 40001
Severity 13
SQLCODE –307
SQLSTATE 40W06
Sybase error code 1205
Probable cause

You attempted to read or write a row and it is locked by another user. Also, all other threads (see the -gn server option) are blocked waiting for a lock to be released. This is a deadlock situation and your transaction has been chosen as the one to rollback.