亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標題: 使用isql 插入記錄出現(xiàn)錯誤 [打印本頁]

作者: fenglimian    時間: 2003-02-24 16:24
標題: 使用isql 插入記錄出現(xiàn)錯誤
大家?guī)臀铱纯丛撛趺刺幚恚?br /> $ isql -Usa -Sf40_sy -i /sybase/myLog.txt
Password:

myLog.txt文件是一些insert語句,由于語句太多,結(jié)果出現(xiàn)了如下錯誤:
00:00000:00001:2003/02/24 15:09:38.59 server  Space available in the log segment has fallen critically low in database 'master'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
Space available in the log segment has fallen critically low in database
'master'.  All future modifications to this database will be suspended until the
log is successfully dumped and space becomes available.
The transaction log in database master is almost full.  Your transaction is
being suspended until space is made available in the log.
00:00000:00007:2003/02/24 15:09:38.71 server  Error: 2812, Severity: 16, State: 5
00:00000:00007:2003/02/24 15:09:38.72 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

我將該進程終止后,shutdown server,修改了lock和total momery參數(shù)后重啟,結(jié)果錯誤信息如下,該怎么修改才可以?
00:00000:00001:2003/02/24 15:51:48.92 server  Space available in the log segment has fallen critically low in database 'master'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
Space available in the log segment has fallen critically low in database
'master'.  All future modifications to this database will be suspended until the
log is successfully dumped and space becomes available.
The transaction log in database master is almost full.  Your transaction is
being suspended until space is made available in the log.
00:00000:00007:2003/02/24 15:51:48.97 server  Error: 2812, Severity: 16, State: 5
00:00000:00007:2003/02/24 15:51:48.97 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
作者: jazy    時間: 2003-02-24 18:05
標題: 使用isql 插入記錄出現(xiàn)錯誤
這不是鎖資源和緩存的問題!

是日志空間不夠了!

使用sa執(zhí)行 dump tran dbname with truncate_only
作者: bluetune    時間: 2003-02-25 09:16
標題: 使用isql 插入記錄出現(xiàn)錯誤
好像是master數(shù)據(jù)庫的事務(wù)日志空間快滿了,這通常是非常危險的,應(yīng)該立即清除事務(wù)日志。
作者: RS9000    時間: 2003-02-25 09:59
標題: 使用isql 插入記錄出現(xiàn)錯誤
master數(shù)據(jù)庫日志滿了嗎?你對哪個數(shù)據(jù)庫操作呀??不會是master吧。
作者: Blackrose    時間: 2003-02-25 18:28
標題: 使用isql 插入記錄出現(xiàn)錯誤
你忘了在 insert 腳本中加上

use DBNAME
go

這句話了,表、數(shù)據(jù)全部逗弄進master了。如果你是故意的,你最好馬上停止這種做法。master數(shù)據(jù)庫不是拿來裝用戶數(shù)據(jù)的。




歡迎光臨 Chinaunix (http://72891.cn/) Powered by Discuz! X3.2