锁不够也会导致数据库挂起吗？请大虾们指教，附日志

eagle001

sybase真的很烂，上午我的数据库被挂起了
日志报错如下

00:00000:00008:2005/12/22 08:33:31.12 server  Error: 1204, Severity: 17, State: 2
00:00000:00008:2005/12/22 08:33:31.13 server  SQL Server has run out of LOCKS.  Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.
02:00000:01002:2005/12/22 08:33:33.85 server  login: Process with spid 1002 could not connect to the SQL Server which has temporarily run out of locks.
02:00000:00607:2005/12/22 08:33:34.04 server  login: Process with spid 607 could not connect to the SQL Server which has temporarily run out of locks.
02:00000:00842:2005/12/22 08:33:34.04 server  Error: 216, Severity: 20, State: 3
02:00000:00842:2005/12/22 08:33:34.04 server  Attempt to automatically drop temporary table failed.
02:00000:00842:2005/12/22 08:33:34.04 server  Error: 216, Severity: 20, State: 3
02:00000:00842:2005/12/22 08:33:34.04 server  Attempt to automatically drop temporary table failed.
接着报：
02:00000:00290:2005/12/22 08:37:38.77 server  Could not obtain required number '3' of resource of type 'Free Locks'. Since the process absolutely requires this resource, it is going to wait indefinitely till the resource becomes available. Please increase the configuration parameter 'number of locks'.
00:00000:00290:2005/12/22 08:37:38.79 kernel  uasetalarm: no more alarms available
00:00000:00290:2005/12/22 08:37:38.79 kernel  uppause: No free alarms available.
然后数据库就登录不上了，isql也不行。

flybean

只能说。。。。。

[ 本帖最后由 flybean 于 2005-12-23 08:44 编辑 ]

leno_mx

只能增加锁