Skip to Content
avatar image
Former Member

Could not acquire a lock

Hello,

I'm trying to activate and smartform but every time I'm getting this dump:

Error Text of the Database: "[ASE Error SQL12205]Could not acquire a lock

within the specified wait period. SERVER level wait period=2400 seconds,

spid=259, lock type=exclusive row, dbid=4, objid=1260735642, pageno=5821264,

rowno=5. Aborting the transaction.#"

I've checked the LWM and HWM, and this paramteres have default value 2147483647.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2015 at 06:11 PM

    I don't think the LWM an HWM values will be relevant to this situation.  It sounds like some other process is holding an incompatible lock on this row for a long time, and your client is choosing to time out rather than continue to block.

    Use a query against master..syslocks (or wade through the output of sp_lock) to look for such a process.

    -bret

    Add comment
    10|10000 characters needed characters exceeded