sybase error 2812（比较急，谢谢！）

xgene

02:00000:00858:2007/08/16 16:52:18.00 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
00:00000:00551:2007/08/16 16:52:18.00 server  Error: 2812, Severity: 16, State: 5
00:00000:00551:2007/08/16 16:52:18.00 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).
04:00000:00858:2007/08/16 16:54:29.69 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
05:00000:00966:2007/08/16 16:54:29.70 server  Error: 2812, Severity: 16, State: 5
05:00000:00966:2007/08/16 16:54:29.70 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).
01:00000:00858:2007/08/16 16:55:45.72 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
01:00000:00316:2007/08/16 16:55:45.72 server  Error: 2812, Severity: 16, State: 5
01:00000:00316:2007/08/16 16:55:45.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).
01:00000:00858:2007/08/16 16:57:02.78 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
01:00000:00317:2007/08/16 16:57:02.78 server  Error: 2812, Severity: 16, State: 5
01:00000:00317:2007/08/16 16:57:02.79 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).
04:00000:00858:2007/08/16 16:59:14.37 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
03:00000:00967:2007/08/16 16:59:14.37 server  Error: 2812, Severity: 16, State: 5
03:00000:00967:2007/08/16 16:59:14.37 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).
03:00000:00858:2007/08/16 17:03:37.15 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
04:00000:00860:2007/08/16 17:03:37.16 server  Error: 2812, Severity: 16, State: 5
04:00000:00860:2007/08/16 17:03:37.16 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).
00:00000:00318:2007/08/16 17:08:15.81 server  Space available in the log segment has fallen critically low in database 'tempdb1'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
04:00000:00143:2007/08/16 17:08:15.82 server  Error: 2812, Severity: 16, State: 5
04:00000:00143:2007/08/16 17:08:15.82 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).
04:00000:00009:2007/08/16 17:09:12.82 server  Space available in the log segment has fallen critically low in database 'tempdb1'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
04:00000:00009:2007/08/16 17:09:12.82 server  Space available in the log segment has fallen critically low in database 'tempdb1'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
05:00000:00968:2007/08/16 17:09:12.83 server  Error: 2812, Severity: 16, State: 5
05:00000:00968:2007/08/16 17:09:12.83 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).
04:00000:00319:2007/08/16 17:10:40.21 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
04:00000:00969:2007/08/16 17:10:40.22 server  Error: 2812, Severity: 16, State: 5
04:00000:00969:2007/08/16 17:10:40.22 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).
05:00000:00319:2007/08/16 17:12:39.19 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
05:00000:01113:2007/08/16 17:12:39.19 server  Error: 2812, Severity: 16, State: 5
05:00000:01113:2007/08/16 17:12:39.19 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).




财务人员在修改某些数据的时候，报错，不能修改

sp_helpdb看tempdb的log满了，于是重启了数据库

但是，重启了后，错误依旧，只不过报错中的“tempdb”变成了“tempdb2”
05:00000:00319:2007/08/16 17:12:39.19 server  Space available in the log segment has fallen critically low in database 'tempdb2'.  All future modifications to this database will be aborted until the log is successfully dumped and space becomes available.
05:00000:01113:2007/08/16 17:12:39.19 server  Error: 2812, Severity: 16, State: 5
05:00000:01113:2007/08/16 17:12:39.19 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).



但是用
use tempdb2
go
sp_helpsegment logsegment
go
发现 free_pages还有很多



不明白该怎么解决了，，，，，希望大家能指点一下菜鸟啊。。。。。。。。。。－_－!!!



谢谢。。。。。。。。。。。。。。。

hobbylu

空间快满了，扩空间

fhp

扩展tempdb空间，多个临时库都要扩。你的临时库太小，设了3个，每个应该不小于1GB，日志和数据可以不分开。

然后把tempdb日志设置为自动截断。重新启动服务器就好。

xgene

原帖由 fhp 于 2007-8-17 07:47 发表
扩展tempdb空间，多个临时库都要扩。你的临时库太小，设了3个，每个应该不小于1GB，日志和数据可以不分开。

然后把tempdb日志设置为自动截断。重新启动服务器就好。

谢谢～！

这个数据库建立了4个tempdb，数据为2G，日志为1G，也都加入到了default group里，而且也设置了自动截断日志

chuxu

检查一下应用了，是否有关联条件写的不好的，直接变成的无条件关联的了。

ljb222521

好象是说某一个存储过程没有发现,导致日志文件无法启用.
可以试一试重新建立日志设备与数据库的关联

fhp007

你的SYBASE版本是多少？
不会是12.5.1吧。如果是这个版本，存储过程会有问题，升级或者降级到12.5.0.3看看

xgene

把tempdb从master上分离出来，又增加了个tempdb3，使tempdb增加到4个，大小都为3G，目前还没出现什么问题。。。

sybase版本原来就是12.5.0.3

lihg

我也认为是应用方面有问题或者说是应用方面的原因。我建议：
1、扩展tempdb空间；
2、与应用开发方确认是哪个功能模块引起，并检查是否有问题。

Eisen

把所有的tempdb都要扩，然后你最好用sp_tempdb 'show'看一看其他的tempdb是否确实都挂在default的临时库组里。
最后，感觉上还是你的应用有问题，基本上猜测是什么联立查询引发了笛卡尔乘积，造成tempdb空间占满。

[ 本帖最后由 Eisen 于 2007-9-29 11:41 编辑 ]