鎖不夠也會(huì)導(dǎo)致數(shù)據(jù)庫(kù)掛起嗎？請(qǐng)大蝦們指教，附日志

eagle001

sybase真的很爛，上午我的數(shù)據(jù)庫(kù)被掛起了
日志報(bào)錯(cuò)如下

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.
接著報(bào)：
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.
然后數(shù)據(jù)庫(kù)就登錄不上了，isql也不行。

flybean

只能說(shuō)。。。。。

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

leno_mx

只能增加鎖