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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

Rollback occurred due to deadlock during prefetch

Error constant SQLE_ROLLBACK_ON_PREFETCH
ODBC 2 State 40001
ODBC 3 State 40001
Severity 13
SQLCODE –684
SQLSTATE WW019
Sybase error code 1205
Probable cause

One of the cursors that was opened with prefetch enabled was performing fetch operations, and a deadlock occurred during a prefetch. This is a deadlock situation and your transaction has been chosen as the one to rollback. The request that received this error was not executed, unless the request was to close the cursor, in which case the cursor was closed.