Re: HDR and log checkpoints
Posted in 2006
Topics: High Availability & Replication, Backup & Restore, Logging & Checkpoints, Platform-Specific Issues
Hi,
Check your network speed connection between both servers.
Checkpoints between primary and secondary servers
running HDR are synchronous, regardless of DRINTERVAL parameter is
-1 (= SYNCHRONOUS) or not.
So your primary server could be delayed waiting for the
confirmation-acknowledge from
secondary server because of network issues, or may be your secondary server
has less resources (memory, processor, ... ) and it takes a long time to
send the confirmation-Acknowledge to the primary server.
Hope this helps you
Regards
----- Original Message -----
From: "pan pan" <pan_1234@yahoo.com>
To: <informix-list@iiug.org>
Sent: Thursday, September 14, 2006 10:14 AM
Subject: HDR and log checkpoints
> AIX 5.3 Informix version 10.00 UC4.
> I have set up HDR, when the secondary is behind and
> catching up the checkpoints are normal, when both are
> in sync the checkpoint like 20/20/100 secs. If I stop
> HDR and start again after few minutes so that few logs
> on primary get used up and secondary have to do a
> catch up the checkpoints return to 1/2 sec.
> HDR mode is async.
>
> CLEANERS 128 # Number of buffer> cleaner processes
> BUFFERPOOL
> size=4K,buffers=1000000,lrus=512,lru_min_dirty=0.400000,lru_ma
> x_dirty=0.600000
> DRAUTO 0 # DR automatic> switchover
> DRINTERVAL 30 # DR max time between> DR
> buffer flushes
> (in sec)
> DRTIMEOUT 30 # DR network timeout
> (in sec)
> DRLOSTFOUND /opt/informix/patron/ # DR lost+found> file path
> DRIDXAUTO 1 # DR automatic index
> repair.
> 0=off, 1=on>
> I am pasting few lines from msg logs
>
> 12:47:33 Maximum server connections 1076
> 12:52:16 Logical Log 60339 Complete, timestamp:> 0xa92d4bf9.
> 12:52:17 Logical Log 60339 - Backup Started
> 12:52:50 Checkpoint Completed: duration was 17
> seconds.
> 12:52:50 Checkpoint loguniq 60340, logpos 0x4663bc,> timestamp: 0xa92dfada
>
> 12:52:50 Maximum server connections 1076
> 12:52:51 Logical Log 60339 - Backup Completed
> 12:57:44 Logical Log 60340 Complete, timestamp:> 0xa9418e3c.
> 12:57:45 Logical Log 60340 - Backup Started
> 12:58:11 Checkpoint Completed: duration was 21
> seconds.
> 12:58:11 Checkpoint loguniq 60341, logpos 0x189118,> timestamp: 0xa94201d4
>
> 12:58:11 Maximum server connections 1076
> 12:58:13 Logical Log 60340 - Backup Completed
> 13:03:34 Checkpoint Completed: duration was 23
> seconds.
> 13:03:34 Checkpoint loguniq 60341, logpos 0x6180258,> timestamp: 0xa95c632b
>
> 13:03:34 Maximum server connections 1076
> 13:03:42 Logical Log 60341 Complete, timestamp:> 0xa95d2bb0.
> 13:03:42 Logical Log 60341 - Backup Started
> 13:03:59 Logical Log 60341 - Backup Completed
> 13:05:36 Logical Log 60342 Complete, timestamp:> 0xa97e8db0.
> 13:05:36 Logical Log 60342 - Backup Started
> 13:05:55 Logical Log 60342 - Backup Completed
> 13:11:18 DR: Send error
> 13:11:18 ASF Echo-Thread Server: asfcode = -25580:> oserr = 32: errstr = : System error occurred in
> network function.
> System error = 32.
> 13:11:18 Checkpoint Completed: duration was 164
> seconds.
> 13:11:18 Checkpoint loguniq 60343, logpos 0x41c4060,> timestamp: 0xa9975706
>
> 13:11:18 Maximum server connections 1076
> 13:11:20 DR: Turned off on primary server
> 13:11:20 DR: Cannot connect to secondary server
> 13:11:30 DR: Primary server connected
> 13:11:30 DR: Configuration parameter values of the> paired servers do not match:
> Parameter: TAPEBLK
> Current server's value: 64
> Paired server's value: 80
> WARNING: The parameter values must match
> if ontape is used as
> backup/recovery tool.
> 13:11:30 DR: Secondary server needs failure recovery
>
> 13:11:33 Logical Log 60343 Complete, timestamp:> 0xa9a05279.
> 13:11:33 DR: Sending log 60343, size 25600 pages,> 89.15 percent used
> 13:11:33 Logical Log 60343 - Backup Started
> 13:11:50 Logical Log 60343 - Backup Completed
> 13:14:09 Logical Log 60344 Complete, timestamp:> 0xa9bc4622.
> 13:14:09 Logical Log 60344 - Backup Started
> 13:14:25 Logical Log 60344 - Backup Completed
> 13:14:48 Logical Log 60345 Complete, timestamp:> 0xa9df3039.
> 13:14:48 Logical Log 60345 - Backup Started
> 13:14:53 Checkpoint Completed: duration was 1
> seconds.
> 13:14:53 Checkpoint loguniq 60346, logpos 0xf95d48,> timestamp: 0xa9e34df5
>
> 13:14:53 Maximum server connections 1076
> 13:14:58 Logical Log 60345 - Backup Completed
> 13:15:37 DR: Sending log 60344, size 25600 pages,> 100.00 percent used
> 13:16:37 Logical Log 60346 Complete, timestamp:> 0xa9fbe4f2.
> 13:16:37 Logical Log 60346 - Backup Started
> 13:16:47 Logical Log 60346 - Backup Completed
> 13:19:45 Checkpoint Completed: duration was 3
> seconds.
> 13:19:45 Checkpoint loguniq 60347, logpos 0x620b6ac,> timestamp: 0xaa180623
>
> 13:19:45 Maximum server connections 1076
> 13:19:53 Logical Log 60347 Complete, timestamp:> 0xaa18719d.
> 13:19:53 Logical Log 60347 - Backup Started
> 13:20:19 Logical Log 60347 - Backup Completed
> 13:20:40 DR: Sending log 60345, size 25600 pages,> 100.00 percent used
> 13:24:22 Logical Log 60348 Complete, timestamp:> 0xaa2d4d4a.
> 13:24:22 Logical Log 60348 - Backup Started
> 13:24:36 Logical Log 60348 - Backup Completed
> 13:24:52 Checkpoint Completed: duration was 2
> seconds.
> 13:24:52 Checkpoint loguniq 60349, logpos 0xa4efc8,> timestamp: 0xaa2f22e6
>
>
> Any suggestions?
>
> Thanks
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>