Error 3307



Message text

Process %d was expected to hold logical lock on page %ld in database %S_DBID for object %S_OBJID, index number %d.


This error occurs when rolling back a transaction that made changes to non-leaf pages of an all-pages-locked (APL) index and the expected locks for this operation were not already held.


Look for other errors in the Adaptive Server error log as well as in your operating system error log to find out the specific source of the problem and clear those errors first, as they might be the actual cause of the error. This error can result in locks being held by the process that rolled back. Restarting Adaptive Server releases any locks that this transaction might still hold. However, this does not clear the root cause of this error.

If there are no other errors in the Adaptive Server error log or in your operating system error log, contact Sybase Technical Support for assistance.

Additional information

For more information about transactions, refer to “transaction” in the Transact-SQL User's Guide.

Before calling Technical Support, have the information available that is listed in “Reporting errors”, including the output of sp_lock and sp_who before restarting Adaptive Server.

Versions in which this error is raised

All versions