sybase11.9.2的errorlog

[复制链接]
查看11 | 回复6 | 2005-7-28 13:31:50 | 显示全部楼层 |阅读模式
最近服务器(Windows 2000 Server+Sybase11.9.2)老是报错,现将errorlog部分出错信息,摘下来请教各位,不知是哪里出问题了
===========================
00:00000:00018:2005/07/28 13:31:50.42 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00031:2005/07/28 13:31:52.20 kernelCannot send, host process disconnected: ntmain 1184 spid: 31
00:00000:00031:2005/07/28 13:31:52.20 serverError: 1608, Severity: 18, State: 4
00:00000:00031:2005/07/28 13:31:52.20 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00007:2005/07/28 13:32:11.82 server6 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00051:2005/07/28 13:32:57.12 kernelCannot send, host process disconnected: ntmain 932 spid: 51
00:00000:00051:2005/07/28 13:32:57.12 serverError: 1608, Severity: 18, State: 4
00:00000:00051:2005/07/28 13:32:57.12 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00029:2005/07/28 13:33:09.90 kernelCannot send, host process disconnected: ntmain 864 spid: 29
00:00000:00029:2005/07/28 13:33:09.90 serverError: 1608, Severity: 18, State: 4
00:00000:00029:2005/07/28 13:33:09.90 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00007:2005/07/28 13:33:11.87 server6 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00038:2005/07/28 13:33:20.59 serverSpace available in the log segment has fallen critically low in database 'tempdb'.All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00053:2005/07/28 13:33:20.59 serverError: 2812, Severity: 16, State: 5
00:00000:00053:2005/07/28 13:33:20.59 serverStored 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:00007:2005/07/28 13:34:11.79 server6 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00038:2005/07/28 13:34:39.29 kernelCannot send, host process disconnected: ntmain 880 spid: 38
00:00000:00038:2005/07/28 13:34:39.29 serverError: 1608, Severity: 18, State: 4
00:00000:00038:2005/07/28 13:34:39.29 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00049:2005/07/28 13:55:39.03 serverSpace available in the log segment has fallen critically low in database 'tempdb'.All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00040:2005/07/28 13:55:39.03 serverError: 2812, Severity: 16, State: 5
00:00000:00040:2005/07/28 13:55:39.03 serverStored 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:00007:2005/07/28 13:57:11.90 server7 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00007:2005/07/28 13:58:11.84 server8 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00007:2005/07/28 13:59:11.87 server8 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00014:2005/07/28 13:59:23.48 kernelCannot send, host process disconnected: ntmain 1296 spid: 14
00:00000:00014:2005/07/28 13:59:23.48 serverError: 1608, Severity: 18, State: 4
00:00000:00014:2005/07/28 13:59:23.48 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00049:2005/07/28 13:59:23.48 serverSpace available in the log segment has fallen critically low in database 'tempdb'.All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00015:2005/07/28 13:59:23.63 serverError: 2812, Severity: 16, State: 5
00:00000:00015:2005/07/28 13:59:23.63 serverStored 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:00053:2005/07/28 19:57:50.04 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 95, oamarray unused: 0, deltaused: 1, deltaunused: 6, spid: 0. Contact your System Admin.
00:00000:00058:2005/07/28 19:58:09.42 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 96, oamarray unused: 6, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 19:58:19.07 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 97, oamarray unused: 5, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 19:58:52.43 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 98, oamarray unused: 4, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00058:2005/07/28 20:02:10.92 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 99, oamarray unused: 3, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00058:2005/07/28 20:02:13.67 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 100, oamarray unused: 2, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:05:03.24 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 101, oamarray unused: 1, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:05:03.37 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 102, oamarray unused: 0, deltaused: 1, deltaunused: 7, spid: 0. Contact your System Admin.
00:00000:00058:2005/07/28 20:07:57.78 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 103, oamarray unused: 7, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:17:14.12 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 104, oamarray unused: 6, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:18:26.34 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 105, oamarray unused: 5, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:19:03.56 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 106, oamarray unused: 4, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:21:55.54 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 107, oamarray unused: 3, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00058:2005/07/28 20:27:58.12 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 108, oamarray unused: 2, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
00:00000:00053:2005/07/28 20:41:17.68 serverThe requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count.allocation page: 43520, oamarray used: 109, oamarray unused: 1, deltaused: 1, deltaunused: -1, spid: 0. Contact your System Admin.
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
cpu占用率也是忽上忽下,而且比较有规律
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
00:00000:00007:2005/07/28 13:33:11.87 server 6 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00049:2005/07/28 13:55:39.03 server Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.

00:00000:00053:2005/07/28 19:57:50.04 server The requested update to the OAM for object 512004855, dbid 7, index 0, oam page 720, would cause a negative page count. allocation page: 43520, oamarray used: 95, oamarray unused: 0, deltaused: 1, deltaunused: 6, spid: 0. Contact your System Admin.

你的日志里主要是这3个错误
1、你的tempdb够不够大?
2、对于前面2个错误,你试着执行几个常用的存储过程看,比方说sp_helpdb等等,如果这些存储过程都不能执行,那你sp_configure "number of open objects"看看打开的对象是不是已经用完了。我曾经碰到过这种情况。 如果不是这种情况,很有可能你的tempdb过小。
3、dbcc检查一下object_id为512004855在 dbid为7的数据库里。这个表可能有问题了。如果确实有问题,重建它。
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
总数据3G,目前temdb40M
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
多谢了,我先试试看。总数据量3G左右,tempdb应该开多少左右?
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
tempdb只有40MB?
太小了吧,因为许多事务会用到tempdb的,计算中间结果、排序等等,如果你的磁盘空间充足的话,调整到1个GB也无所谓啊
回复

使用道具 举报

千问 | 2005-7-28 13:31:50 | 显示全部楼层
tempdb太小了
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行