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收起