Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Lock request timeout with no entry in systemtable "Locks"

Hi all,

we're running MaxDB 7.8.02.37 in an non SAP environment.

After some days of normal operation the error message "Lock request timeout (SQL-HY000) (LOCK TABLE yyy IN EXCLUSIVE MODE" occurs in our application.

During our analyse we thougth that in this case there should occur some data entries in the system table "locks", but there are no datasets in there.

Using the database studio we can see in the task manager the task which produce the table lock (with task status vWait).

Actual we have to restart the database to come back to a normal operation (for a while :-( ).

Is there a way to clean up the table state to get rid of the locking messages without doing a restart of the database?

Does somewho have any ideas about this behaviour?

Thanks

   Hannes

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question