In this blog post, you’ll learn more about the Sybase Error Rollback occurred due to deadlock during prefetch and the reason for receiving this error
Sybase SQL Error Message
Rollback occurred due to deadlock during prefetch
Reason for this Error
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.
