互联网服务errorserver

HDR关系下,同一个库为什么指定关系时间差距那么大?

HDR关系下,同一个库分别两次指定关系 时间不一样?为什么,请高手指点。(配置参数都没变过)或者请教怎么去查找该问题的原因?如果是性能问题,该怎么调优?日志一:00:00:18  Maximum server connections 100:15:53  Booting Language from module 00:15:53 ...显示全部
HDR关系下,同一个库分别两次指定关系 时间不一样?为什么,请高手指点。(配置参数都没变过)
或者请教怎么去查找该问题的原因?
如果是性能问题,该怎么调优?
日志一:
00:00:18  Maximum server connections 1
00:15:53  Booting Language from module <>
00:15:53  Loading Module
00:31:04  Checkpoint Completed:  duration was 0 seconds.
00:31:04  Checkpoint loguniq 23005, logpos 0x81018, timestamp: 0x6e272da

00:31:04  Maximum server connections 31
00:31:04  DR: Receive error in thread dr_secrcv [id: 95]
00:31:04  ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Network connection is broken.
System error = 4.
00:31:06  DR: Turned off on secondary server
00:31:10  Logical Recovery has reached the transaction cleanup phase.
00:31:10  Logical Recovery Complete.
          1292 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

00:31:10  Logical Recovery Complete.
00:31:11  Quiescent Mode
00:31:11  Logical Log 23004 Complete, timestamp: 0x6e272dd.
00:31:11  Checkpoint Completed:  duration was 0 seconds.
00:31:11  Checkpoint loguniq 23005, logpos 0x82018, timestamp: 0x6e272e8

00:31:11  Maximum server connections 31
00:31:11  DR: Reservation of the last logical log for log backup turned on
00:31:11  DR: new type = standard
00:31:12  On-Line Mode
00:31:13  DR: new type = primary, secondary server name = mscp_online2_net
00:31:13  DR: Trying to connect to secondary server = mscp_online2_net
00:31:14  DR: Cannot connect to secondary server
00:31:14  DR: Turned off on primary server
00:35:31  DR: Primary server connected
00:35:31  DR: Secondary server needs failure recovery

00:35:33  DR: Sending log 23005 (current), size 50000 pages, 0.31 percent used
00:35:34  DR: Sending Logical Logs Completed
00:35:35  DR: Primary server operational
00:35:35  Checkpoint Completed:  duration was 0 seconds.
00:35:35  Checkpoint loguniq 23005, logpos 0x9a018, timestamp: 0x6e72c5e

00:35:35  Maximum server connections 32
00:37:36  DR: ping timeout
00:37:36  DR: Receive error in thread dr_prsend [id: 195]
00:37:36  ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr = : Network connection is broken.

00:37:38  DR: Turned off on primary server
00:37:38  DR: Cannot connect to secondary server
01:00:01  Checkpoint Completed:  duration was 0 seconds.
01:00:01  Checkpoint loguniq 23005, logpos 0x3f64690, timestamp: 0x70a846f

日志二:
05:00:03  Maximum server connections 31
05:14:49  DR: ping timeout
05:14:49  DR: Receive error in thread dr_secrcv [id: 94]
05:14:49  ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Network connection is broken.
System error = 4.
05:14:50  DR: Receive Btree error
05:14:51  DR: Turned off on secondary server
05:15:00  Logical Recovery has reached the transaction cleanup phase.
05:15:00  Logical Recovery Complete.
          455353 Committed, 32 Rolled Back, 0 Open, 0 Bad Locks

05:15:00  Logical Recovery Complete.
05:15:01  Quiescent Mode
05:15:01  Logical Log 23902 Complete, timestamp: 0x49db70e4.
05:15:01  Checkpoint Completed:  duration was 0 seconds.
05:15:01  Checkpoint loguniq 23903, logpos 0x55f9018, timestamp: 0x49db70f7

05:15:01  Maximum server connections 31
05:15:01  DR: Reservation of the last logical log for log backup turned on
05:15:01  DR: new type = standard
05:15:02  On-Line Mode
05:15:02  DR: new type = primary, secondary server name = mscp_online2_net
05:15:02  DR: Trying to connect to secondary server = mscp_online2_net
05:16:03  DR: Cannot connect to secondary server
05:16:03  DR: Turned off on primary server
06:15:13  Checkpoint Completed:  duration was 0 seconds.
06:15:13  Checkpoint loguniq 23903, logpos 0x5616018, timestamp: 0x49dc10b1收起
参与10

查看其它 9 个回答alexycom的回答

alexycomalexycom项目经理IBM
回复 9# zhou5526


    现在文件解决了吗?
政府机关 · 2013-03-12
浏览1106

回答者

alexycom
项目经理IBM
擅长领域: 数据库数据安全存储

alexycom 最近回答过的问题

回答状态

  • 发布时间:2013-03-12
  • 关注会员:0 人
  • 回答浏览:1106
  • X社区推广