求助！

jsy_cq

sybase 日志文件
00:00000:00084:2005/03/05 17:36:39.56 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:36:39.56 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042172,1). Drop and re-create the index.
01:00000:00084:2005/03/05 17:37:20.47 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:37:20.47 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042253,0). Drop and re-create the index.
01:00000:00084:2005/03/05 17:39:32.22 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:39:32.22 server  Index row entry for data row id (5302138, is missing from index page 12822755 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042380,7). Drop and re-create the index.
00:00000:00084:2005/03/05 17:39:42.69 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:39:42.69 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042384,6). Drop and re-create the index.
00:00000:00084:2005/03/05 17:41:46.39 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:41:46.39 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042720,12). Drop and re-create the index.
00:00000:00084:2005/03/05 17:42:07.70 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:42:07.70 server  Index row entry for data row id (5296862, 16) is missing from index page 12826255 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042756,13). Drop and re-create the index.
00:00000:00084:2005/03/05 17:42:45.68 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:42:45.68 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042797,17). Drop and re-create the index.
00:00000:00084:2005/03/05 17:42:55.70 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:42:55.70 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042802,22). Drop and re-create the index.
00:00000:00084:2005/03/05 17:43:44.92 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:43:44.92 server  Index row entry for data row id (5239410, 4) is missing from index page 12823532 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042851,10). Drop and re-create the index.
01:00000:00000:2005/03/05 17:43:45.38 kernel  nrpacket: recv, Connection timed out
00:00000:00084:2005/03/05 17:44:17.11 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:44:17.11 server  Index row entry for data row id (5302138, is missing from index page 12822755 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042890,17). Drop and re-create the index.
00:00000:00084:2005/03/05 17:44:28.35 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:44:28.35 server  Index row entry for data row id (5306957, 14) is missing from index page 12824224 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042910,15). Drop and re-create the index.
01:00000:00221:2005/03/05 17:45:23.05 kernel  Cannot read, host process disconnected:  -2028297 spid: 221
00:00000:00084:2005/03/05 17:45:30.78 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:45:30.78 server  Index row entry for data row id (5296862, 16) is missing from index page 12826255 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042927,0). Drop and re-create the index.
00:00000:00084:2005/03/05 17:45:37.30 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:45:37.30 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042933,2). Drop and re-create the index.
00:00000:00084:2005/03/05 17:45:43.44 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:45:43.44 server  Index row entry for data row id (5303516, 12) is missing from index page 12814594 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042937,16). Drop and re-create the index.
00:00000:00084:2005/03/05 17:46:05.61 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:46:05.61 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042960,11). Drop and re-create the index.
00:00000:00084:2005/03/05 17:46:09.49 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:46:09.49 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042960,13). Drop and re-create the index.
01:00000:00084:2005/03/05 17:46:16.87 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:46:16.88 server  Index row entry for data row id (5302138, is missing from index page 12822755 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042970,9). Drop and re-create the index.
01:00000:00084:2005/03/05 17:46:32.14 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:46:32.14 server  Index row entry for data row id (5327170, 9) is missing from index page 12824979 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042973,2). Drop and re-create the index.
01:00000:00084:2005/03/05 17:46:42.17 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:46:42.17 server  Index row entry for data row id (5303910, 17) is missing from index page 12815160 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042976,14). Drop and re-create the index.
00:00000:00000:2005/03/05 17:46:50.16 kernel  nrpacket: recv, Connection timed out
01:00000:00084:2005/03/05 17:46:50.47 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:46:50.47 server  Index row entry for data row id (5239410, 4) is missing from index page 12823532 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042977,4). Drop and re-create the index.
01:00000:00084:2005/03/05 17:46:54.39 server  Error: 644, Severity: 21, State: 1
01:00000:00084:2005/03/05 17:46:54.39 server  Index row entry for data row id (5296870, 11) is missing from index page 12824098 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042977,22). Drop and re-create the index.
00:00000:00084:2005/03/05 17:47:02.83 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:47:02.83 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042985,1). Drop and re-create the index.
00:00000:00084:2005/03/05 17:47:07.31 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:47:07.31 server  Index row entry for data row id (5302138, is missing from index page 12822755 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042991,20). Drop and re-create the index.
00:00000:00084:2005/03/05 17:47:11.32 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:47:11.32 server  Index row entry for data row id (5327170, 9) is missing from index page 12824979 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042991,22). Drop and re-create the index.
00:00000:00084:2005/03/05 17:47:17.86 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:47:17.86 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042994,0). Drop and re-create the index.
00:00000:00084:2005/03/05 17:47:21.32 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:47:21.32 server  Index row entry for data row id (5296870, 21) is missing from index page 12830021 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10042994,10). Drop and re-create the index.
00:00000:00084:2005/03/05 17:49:12.71 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:49:12.71 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10043017,. Drop and re-create the index.
00:00000:00084:2005/03/05 17:49:35.22 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:49:35.22 server  Index row entry for data row id (5297234, 9) is missing from index page 12824603 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10043039,0). Drop and re-create the index.
00:00000:00084:2005/03/05 17:50:20.02 server  Error: 644, Severity: 21, State: 1
00:00000:00084:2005/03/05 17:50:20.02 server  Index row entry for data row id (5299643, 16) is missing from index page 12826241 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10043075,12). Drop and re-create the index.
01:00000:00172:2005/03/05 17:53:50.76 kernel  Cannot read, host process disconnected:  -155015 spid: 172
00:00000:00000:2005/03/05 18:02:43.92 kernel  nrpacket: recv, Connection timed out
01:00000:00051:2005/03/05 18:02:47.08 kernel  Cannot read, host process disconnected:  -215117 spid: 51
01:00000:00070:2005/03/05 18:05:07.23 kernel  Cannot read, host process disconnected:  -202417 spid: 70
01:00000:00183:2005/03/05 18:08:01.03 kernel  Cannot read, host process disconnected:  -1975545 spid: 183
01:00000:00149:2005/03/05 18:08:45.99 kernel  Cannot read, host process disconnected:  -460849 spid: 149
01:00000:00080:2005/03/05 18:10:23.61 kernel  Cannot read, host process disconnected:  -1883145 spid: 80
01:00000:00235:2005/03/05 18:12:36.45 server  Error: 644, Severity: 21, State: 1
01:00000:00235:2005/03/05 18:12:36.45 server  Index row entry for data row id (5300921, 1) is missing from index page 12821448 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10044741,15). Drop and re-create the index.
01:00000:00235:2005/03/05 18:13:13.49 server  Error: 644, Severity: 21, State: 1
01:00000:00235:2005/03/05 18:13:13.49 server  Index row entry for data row id (5300921, 1) is missing from index page 12821448 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10044758,7). Drop and re-create the index.
01:00000:00198:2005/03/05 18:15:00.71 kernel  Cannot read, host process disconnected:  -383673 spid: 198
01:00000:00057:2005/03/05 18:19:45.66 kernel  Cannot read, host process disconnected:  -1841785 spid: 57
00:00000:00119:2005/03/05 18:23:01.66 kernel  Cannot read, host process disconnected:  -148639 spid: 119
01:00000:00000:2005/03/05 18:23:45.99 kernel  nrpacket: recv, Connection timed out
00:00000:00243:2005/03/05 18:27:40.66 server  Error: 644, Severity: 21, State: 1
00:00000:00243:2005/03/05 18:27:40.66 server  Index row entry for data row id (5300921, 1) is missing from index page 12821448 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10045695,0). Drop and re-create the index.
00:00000:00243:2005/03/05 18:27:45.99 server  Error: 644, Severity: 21, State: 1
00:00000:00243:2005/03/05 18:27:45.99 server  Index row entry for data row id (5300921, 1) is missing from index page 12821448 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10045753,20). Drop and re-create the index.
01:00000:00206:2005/03/05 18:27:57.06 server  Error: 644, Severity: 21, State: 1
01:00000:00206:2005/03/05 18:27:57.06 server  Index row entry for data row id (4404588, 21) is missing from index page 12828962 of index id 3 of table 'abc_dg' in database 'abcdb'. Xactid is (10045820,2). Drop and re-create the index.
01:00000:00000:2005/03/05 18:28:58.28 kernel  nrpacket: recv, Connection timed out
01:00000:00000:2005/03/05 18:32:32.93 kernel  nrpacket: recv, Connection timed out
01:00000:00192:2005/03/05 18:32:45.56 kernel  Cannot read, host process disconnected:  -320579 spid: 192
00:00000:00085:2005/03/05 18:33:52.12 kernel  Cannot read, host process disconnected:  -262991 spid: 85
00:00000:00188:2005/03/05 18:34:51.35 kernel  Cannot read, host process disconnected:  -132815 spid: 188
00:00000:00091:2005/03/05 18:38:21.08 kernel  Cannot read, host process disconnected:  -288751 spid: 91
01:00000:00065:2005/03/05 18:43:03.43 kernel  Cannot send, host process disconnected:  -412245 spid: 65
01:00000:00065:2005/03/05 18:43:03.44 server  Error: 1608, Severity: 18, State: 4
01:00000:00065:2005/03/05 18:43:03.44 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00000:2005/03/05 18:47:23.43 kernel  nrpacket: recv, Connection timed out
01:00000:00044:2005/03/05 18:53:02.63 kernel  Cannot read, host process disconnected:  -233303 spid: 44
01:00000:00174:2005/03/05 18:55:20.06 kernel  Cannot read, host process disconnected:  -96221 spid: 174
01:00000:00058:2005/03/05 18:55:20.67 kernel  Cannot read, host process disconnected:  -235269 spid: 58
00:00000:00156:2005/03/05 18:59:48.00 kernel  Cannot read, host process disconnected:  -160971 spid: 156
00:00000:00023:2005/03/05 19:03:09.93 kernel  Cannot read, host process disconnected:  -155435 spid: 23
01:00000:00192:2005/03/05 19:04:09.60 kernel  Cannot send, host process disconnected:  -377579 spid: 192
01:00000:00192:2005/03/05 19:04:09.60 server  Error: 1608, Severity: 18, State: 4
01:00000:00192:2005/03/05 19:04:09.60 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00079:2005/03/05 19:10:19.54 kernel  Cannot send, host process disconnected:  -395577 spid: 79
01:00000:00079:2005/03/05 19:10:19.54 server  Error: 1608, Severity: 18, State: 4
01:00000:00079:2005/03/05 19:10:19.54 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00197:2005/03/05 19:11:08.86 kernel  Cannot read, host process disconnected:  -192399 spid: 197
01:00000:00000:2005/03/05 19:12:54.90 kernel  nrpacket: recv, Connection timed out
01:00000:00178:2005/03/05 19:21:36.94 kernel  Cannot read, host process disconnected:  -223069 spid: 178
01:00000:00136:2005/03/05 19:22:34.00 kernel  Cannot read, host process disconnected:  -223069 spid: 136
01:00000:00194:2005/03/05 19:23:09.72 server  Error: 1608, Severity: 18, State: 4
01:00000:00194:2005/03/05 19:23:09.72 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00117:2005/03/05 19:31:01.93 kernel  Cannot read, host process disconnected:  1120 spid: 117
01:00000:00000:2005/03/05 19:34:35.37 kernel  nrpacket: recv, Connection timed out
00:00000:00104:2005/03/05 19:39:10.79 kernel  Cannot read, host process disconnected:  -333571 spid: 104
00:00000:00233:2005/03/05 19:42:32.97 kernel  Cannot read, host process disconnected:  -139383 spid: 233
除了要处理表的主键和索引外，还有什么问题呢

chuxu

做个dbcc看看吧

Eisen

dbcc checktable(tablename)
然后把系统表 sysindexes也检查一下