使用isql 插入記錄出現(xiàn)錯誤

fenglimian

大家?guī)臀铱纯丛撛趺刺幚恚?br /> $ isql -Usa -Sf40_sy -i /sybase/myLog.txt
Password:

myLog.txt文件是一些insert語句，由于語句太多，結果出現(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ù)后重啟，結果錯誤信息如下，該怎么修改才可以？
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

這不是鎖資源和緩存的問題！

是日志空間不夠了！

使用sa執(zhí)行 dump tran dbname with truncate_only

bluetune

好像是master數(shù)據(jù)庫的事務日志空間快滿了，這通常是非常危險的，應該立即清除事務日志。

RS9000

master數(shù)據(jù)庫日志滿了嗎？你對哪個數(shù)據(jù)庫操作呀？？不會是master吧�。�

Blackrose

你忘了在 insert 腳本中加上

use DBNAME
go

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