Error 684

"Rollback occurred due to deadlock during prefetch"

Item Description

SQLCode

-684L

Constant

ROLLBACK_ON_PREFETCH

SQLState

WW019

ODBC 2 State

40001

ODBC 3 State

40001

Sybase Error Code

2313

Severity Code

13

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com