Re: HDR - Blocked C
An HDR secondary (IDS 10.00.TC3 on Windows 2003) hung in Fast Recovery (Sec) with Blocked:CKPT after a reboot. Suggestions to point TAPEDEV/LTAPEDEV at a null device and to run 'onmode -c unblock' didn't help. The online.log showed the secondary stuck after 'Recovery Mode' while trying to connect to the primary, and 'onstat -g dri' revealed the primary's DR type was 'standard'/off, i.e. it no longer considered itself a primary, so the secondary had nobody to talk to. The advice was to run 'onmode -d primary <secondary_servername>' on the primary and review its log around the point HDR stopped. No confirmation of success is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
> Stu,
>
> This sounds like a problem I had recently; this may be the solution:
>
> Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> physical device - for example /dev/rmt0 - and the device is off-line or
> there is no backup tape in the device, IDS will wait in Fast Recovery
> until either a valid backup tape is supplied to the device or TAPEDEV
> and/or LTAPEDEV is set to /dev/null. This is what I did to make the
> change:
>
> bring down the engine;
> change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
> restart the engine.
>
> Let us know if this fixes the problem.
>
> Mike Badar
> ESRI
> 1 International Ct.
> Broomfield, CO 80021
> mba...@esri.com
> 303-449-7779www.esri.com
>
>
>
> > -----Original Message-----
> > From: informix-list-boun...@iiug.org
> > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > stumacpher...@hotmail.com
> > Sent: Thursday, February 22, 2007 2:37 AM
> > To: informix-l...@iiug.org
> > Subject: HDR - Blocked C
>
> > Hi
>
> > I'm running Informix 10 TC3 on Windows Server 2003 in an HDR
> > pair. I recently rebooted the secondary server, but it has
> > now stuck in fast recovery mode. The following is the output
> > from onstat -
>
> > IBM Informix Dynamic Server Version 10.00.TC3 -- Fast Recovery
> > (Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT>
> > Can anyone tell me how to resolve this?
>
> > Thanks
>
> > Stu.
>
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>
> - Show quoted text -
Hi Mike,
Thanks for your help.
I shutdown the server with oninit -ky,
In the onconfig LTAPEDEV was set to NUL
TAPEDEV was pointing to a file on disk, which I changed to NUL
I restarted the server with oninit
but it has still stopped in fast recovery with the Blocked:CKPT
Stu
> -----Original Message-----
> From: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org] On Behalf Of
> stumacpherson@hotmail.com
> Sent: Friday, February 23, 2007 3:56 AM
> To: informix-list@iiug.org
> Subject: Re: HDR - Blocked C
>
> On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
> > Stu,
> >
> > This sounds like a problem I had recently; this may be the solution:
> >
> > Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> > physical device - for example /dev/rmt0 - and the device is
> off-line
> > or there is no backup tape in the device, IDS will wait in Fast
> > Recovery until either a valid backup tape is supplied to
> the device or
> > TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did to
> > make the
> > change:
> >
> > bring down the engine;
> > change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
> restart the
> > engine.
> >
> > Let us know if this fixes the problem.
> >
> > Mike Badar
> > ESRI
> > 1 International Ct.
> > Broomfield, CO 80021
> > mba...@esri.com
> > 303-449-7779www.esri.com
> >
> >
> >
> > > -----Original Message-----
> > > From: informix-list-boun...@iiug.org
> > > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > > stumacpher...@hotmail.com
> > > Sent: Thursday, February 22, 2007 2:37 AM
> > > To: informix-l...@iiug.org
> > > Subject: HDR - Blocked C
> >
> > > Hi
> >
> > > I'm running Informix 10 TC3 on Windows Server 2003 in an
> HDR pair. I
> > > recently rebooted the secondary server, but it has now
> stuck in fast
> > > recovery mode. The following is the output from onstat -
> >
> > > IBM Informix Dynamic Server Version 10.00.TC3 -- Fast Recovery
> > > (Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT> >
> > > Can anyone tell me how to resolve this?
> >
> > > Thanks
> >
> > > Stu.
>
> Hi Mike,
>
> Thanks for your help.
>
> I shutdown the server with oninit -ky,
> In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
> to a file on disk, which I changed to NUL I restarted the
> server with oninit but it has still stopped in fast recovery
> with the Blocked:CKPT
>
> Stu
Stu,
Have you tried "onmode -c unblock"?
Mike
On 23 Feb, 14:12, "Mike Badar" <mba...@esri.com> wrote:
> > -----Original Message-----
> > From: informix-list-boun...@iiug.org
> > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > stumacpher...@hotmail.com
> > Sent: Friday, February 23, 2007 3:56 AM
> > To: informix-l...@iiug.org
> > Subject: Re: HDR - Blocked C
>
> > On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
> > > Stu,
>
> > > This sounds like a problem I had recently; this may be the solution:
>
> > > Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> > > physical device - for example /dev/rmt0 - and the device is
> > off-line
> > > or there is no backup tape in the device, IDS will wait in Fast
> > > Recovery until either a valid backup tape is supplied to
> > the device or
> > > TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did to
> > > make the
> > > change:
>
> > > bring down the engine;
> > > change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
> > restart the
> > > engine.
>
> > > Let us know if this fixes the problem.
>
> > > Mike Badar
> > > ESRI
> > > 1 International Ct.
> > > Broomfield, CO 80021
> > > mba...@esri.com
> > > 303-449-7779www.esri.com
>
> > > > -----Original Message-----
> > > > From: informix-list-boun...@iiug.org
> > > > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > > > stumacpher...@hotmail.com
> > > > Sent: Thursday, February 22, 2007 2:37 AM
> > > > To: informix-l...@iiug.org
> > > > Subject: HDR - Blocked C
>
> > > > Hi
>
> > > > I'm running Informix 10 TC3 on Windows Server 2003 in an
> > HDR pair. I
> > > > recently rebooted the secondary server, but it has now
> > stuck in fast
> > > > recovery mode. The following is the output from onstat -
>
> > > > IBM Informix Dynamic Server Version 10.00.TC3 -- Fast Recovery
> > > > (Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT>
> > > > Can anyone tell me how to resolve this?
>
> > > > Thanks
>
> > > > Stu.
>
> > Hi Mike,
>
> > Thanks for your help.
>
> > I shutdown the server with oninit -ky,
> > In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
> > to a file on disk, which I changed to NUL I restarted the
> > server with oninit but it has still stopped in fast recovery
> > with the Blocked:CKPT
>
> > Stu
>
> Stu,
>
> Have you tried "onmode -c unblock"?
>
> Mike- Hide quoted text -
>
> - Show quoted text -
Mike,
That didn't work either. I'm not very familiar with informix, so I'm
grateful the assistance you're providing.
Stu.
Stu-
What is in the online.log when the server hangs? Does it get to
this point?
17:17:41 Recovery Mode
17:17:48 DR: Secondary server connected 17:17:50 DR: Secondary serverneeds failure recovery
17:17:50 DR: Failure recovery from disk in progress ...
If it says something about reading logs from tape, you will
either have to supply it with backed up log tapes or restore a level 0
backup to restart data replication.
--EEM
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of
stumacpherson@hotmail.com
Sent: Friday, February 23, 2007 10:24 AM
To: informix-list@iiug.org
Subject: Re: HDR - Blocked C
On 23 Feb, 14:12, "Mike Badar" <mba...@esri.com> wrote:
> > -----Original Message-----
> > From: informix-list-boun...@iiug.org
> > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > stumacpher...@hotmail.com
> > Sent: Friday, February 23, 2007 3:56 AM
> > To: informix-l...@iiug.org
> > Subject: Re: HDR - Blocked C
>
> > On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
> > > Stu,
>
> > > This sounds like a problem I had recently; this may be the
solution:
>
> > > Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> > > physical device - for example /dev/rmt0 - and the device is
> > off-line
> > > or there is no backup tape in the device, IDS will wait in Fast
> > > Recovery until either a valid backup tape is supplied to
> > the device or
> > > TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did
to
> > > make the
> > > change:
>
> > > bring down the engine;
> > > change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
> > restart the
> > > engine.
>
> > > Let us know if this fixes the problem.
>
> > > Mike Badar
> > > ESRI
> > > 1 International Ct.
> > > Broomfield, CO 80021
> > > mba...@esri.com
> > > 303-449-7779www.esri.com
>
> > > > -----Original Message-----
> > > > From: informix-list-boun...@iiug.org
> > > > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > > > stumacpher...@hotmail.com
> > > > Sent: Thursday, February 22, 2007 2:37 AM
> > > > To: informix-l...@iiug.org
> > > > Subject: HDR - Blocked C
>
> > > > Hi
>
> > > > I'm running Informix 10 TC3 on Windows Server 2003 in an
> > HDR pair. I
> > > > recently rebooted the secondary server, but it has now
> > stuck in fast
> > > > recovery mode. The following is the output from onstat -
>
> > > > IBM Informix Dynamic Server Version 10.00.TC3 -- Fast
Recovery
> > > > (Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT
>
> > > > Can anyone tell me how to resolve this?
>
> > > > Thanks
>
> > > > Stu.
>
> > Hi Mike,
>
> > Thanks for your help.
>
> > I shutdown the server with oninit -ky,
> > In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
> > to a file on disk, which I changed to NUL I restarted the
> > server with oninit but it has still stopped in fast recovery
> > with the Blocked:CKPT
>
> > Stu
>
> Stu,
>
> Have you tried "onmode -c unblock"?
>
> Mike- Hide quoted text -
>
> - Show quoted text -
Mike,
That didn't work either. I'm not very familiar with informix, so I'm
grateful the assistance you're providing.
Stu.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
On 23 Feb, 16:45, "Everett Mills" <eemi...@nationalbeef.com> wrote:
> Stu-
> What is in the online.log when the server hangs? Does it get to
> this point?
>
> 17:17:41 Recovery Mode
> 17:17:48 DR: Secondary server connected 17:17:50 DR: Secondary server> needs failure recovery
>
> 17:17:50 DR: Failure recovery from disk in progress ...>
> If it says something about reading logs from tape, you will
> either have to supply it with backed up log tapes or restore a level 0
> backup to restart data replication.
>
> --EEM
>
>
>
> -----Original Message-----
> From: informix-list-boun...@iiug.org
>
> [mailto:informix-list-boun...@iiug.org] On Behalf Of
> stumacpher...@hotmail.com
> Sent: Friday, February 23, 2007 10:24 AM
> To: informix-l...@iiug.org
> Subject: Re: HDR - Blocked C
>
> On 23 Feb, 14:12, "Mike Badar" <mba...@esri.com> wrote:
> > > -----Original Message-----
> > > From: informix-list-boun...@iiug.org
> > > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > > stumacpher...@hotmail.com
> > > Sent: Friday, February 23, 2007 3:56 AM
> > > To: informix-l...@iiug.org
> > > Subject: Re: HDR - Blocked C
>
> > > On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
> > > > Stu,
>
> > > > This sounds like a problem I had recently; this may be the
> solution:
>
> > > > Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> > > > physical device - for example /dev/rmt0 - and the device is
> > > off-line
> > > > or there is no backup tape in the device, IDS will wait in Fast
> > > > Recovery until either a valid backup tape is supplied to
> > > the device or
> > > > TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did
> to
> > > > make the
> > > > change:
>
> > > > bring down the engine;
> > > > change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
> > > restart the
> > > > engine.
>
> > > > Let us know if this fixes the problem.
>
> > > > Mike Badar
> > > > ESRI
> > > > 1 International Ct.
> > > > Broomfield, CO 80021
> > > > mba...@esri.com
> > > > 303-449-7779www.esri.com
>
> > > > > -----Original Message-----
> > > > > From: informix-list-boun...@iiug.org
> > > > > [mailto:informix-list-boun...@iiug.org] On Behalf Of
> > > > > stumacpher...@hotmail.com
> > > > > Sent: Thursday, February 22, 2007 2:37 AM
> > > > > To: informix-l...@iiug.org
> > > > > Subject: HDR - Blocked C
>
> > > > > Hi
>
> > > > > I'm running Informix 10 TC3 on Windows Server 2003 in an
> > > HDR pair. I
> > > > > recently rebooted the secondary server, but it has now
> > > stuck in fast
> > > > > recovery mode. The following is the output from onstat -
>
> > > > > IBM Informix Dynamic Server Version 10.00.TC3 -- Fast
> Recovery
> > > > > (Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT
>
> > > > > Can anyone tell me how to resolve this?
>
> > > > > Thanks
>
> > > > > Stu.
>
> > > Hi Mike,
>
> > > Thanks for your help.
>
> > > I shutdown the server with oninit -ky,
> > > In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
> > > to a file on disk, which I changed to NUL I restarted the
> > > server with oninit but it has still stopped in fast recovery
> > > with the Blocked:CKPT
>
> > > Stu
>
> > Stu,
>
> > Have you tried "onmode -c unblock"?
>
> > Mike- Hide quoted text -
>
> > - Show quoted text -
>
> Mike,
> That didn't work either. I'm not very familiar with informix, so I'm
> grateful the assistance you're providing.
>
> Stu.
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>
> - Show quoted text -
Hi Everett,
No It dosn't get to that point. The last entries in the log are:
15:53:20 IBM Informix Dynamic Server Initialized -- Shared MemoryInitialized.
15:53:20 DR: Logs already cleared
15:53:20 Physical Recovery Started at Page (3:48516).
15:53:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages
Restored.
15:53:20 DR: Trying to connect to primary server = ctlprime1_primary
15:53:21 Dataskip is now OFF for all dbspaces
15:53:21 Restartable Restore has been ENABLED
15:53:21 Recovery Mode
Stu.
stumacpherson@hotmail.com wrote:
> On 23 Feb, 16:45, "Everett Mills" <eemi...@nationalbeef.com> wrote:
>
>>Stu-
>> What is in the online.log when the server hangs? Does it get to
>>this point?
>>
>>17:17:41 Recovery Mode
>>17:17:48 DR: Secondary server connected 17:17:50 DR: Secondary server>>needs failure recovery
>>
>>17:17:50 DR: Failure recovery from disk in progress ...>>
>> If it says something about reading logs from tape, you will
>>either have to supply it with backed up log tapes or restore a level 0
>>backup to restart data replication.
>>
>> --EEM
>>
>>
>>
>>-----Original Message-----
>>From: informix-list-boun...@iiug.org
>>
>>[mailto:informix-list-boun...@iiug.org] On Behalf Of
>>stumacpher...@hotmail.com
>>Sent: Friday, February 23, 2007 10:24 AM
>>To: informix-l...@iiug.org
>>Subject: Re: HDR - Blocked C
>>
>>On 23 Feb, 14:12, "Mike Badar" <mba...@esri.com> wrote:
>>
>>>>-----Original Message-----
>>>>From: informix-list-boun...@iiug.org
>>>>[mailto:informix-list-boun...@iiug.org] On Behalf Of
>>>>stumacpher...@hotmail.com
>>>>Sent: Friday, February 23, 2007 3:56 AM
>>>>To: informix-l...@iiug.org
>>>>Subject: Re: HDR - Blocked C
>>
>>>>On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
>>>>
>>>>>Stu,
>>
>>>>>This sounds like a problem I had recently; this may be the
>>
>>solution:
>>
>>
>>>>>Check the values of TAPEDEV and LTAPEDEV. If they are set to some
>>>>>physical device - for example /dev/rmt0 - and the device is
>>>>
>>>>off-line
>>>>
>>>>>or there is no backup tape in the device, IDS will wait in Fast
>>>>>Recovery until either a valid backup tape is supplied to
>>>>
>>>>the device or
>>>>
>>>>>TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did
>>
>>to
>>
>>>>>make the
>>>>>change:
>>
>>>>>bring down the engine;
>>>>>change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
>>>>
>>>>restart the
>>>>
>>>>>engine.
>>
>>>>>Let us know if this fixes the problem.
>>
>>>>>Mike Badar
>>>>>ESRI
>>>>>1 International Ct.
>>>>>Broomfield, CO 80021
>>>>>mba...@esri.com
>>>>>303-449-7779www.esri.com
>>
>>>>>>-----Original Message-----
>>>>>>From: informix-list-boun...@iiug.org
>>>>>>[mailto:informix-list-boun...@iiug.org] On Behalf Of
>>>>>>stumacpher...@hotmail.com
>>>>>>Sent: Thursday, February 22, 2007 2:37 AM
>>>>>>To: informix-l...@iiug.org
>>>>>>Subject: HDR - Blocked C
>>
>>>>>>Hi
>>
>>>>>>I'm running Informix 10 TC3 on Windows Server 2003 in an
>>>>
>>>>HDR pair. I
>>>>
>>>>>>recently rebooted the secondary server, but it has now
>>>>
>>>>stuck in fast
>>>>
>>>>>>recovery mode. The following is the output from onstat -
>>
>>>>>>IBM Informix Dynamic Server Version 10.00.TC3 -- Fast
>>
>>Recovery
>>
>>>>>>(Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT
>>
>>>>>>Can anyone tell me how to resolve this?
>>
>>>>>>Thanks
>>
>>>>>>Stu.
>>
>>>>Hi Mike,
>>
>>>>Thanks for your help.
>>
>>>>I shutdown the server with oninit -ky,
>>>>In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
>>>>to a file on disk, which I changed to NUL I restarted the
>>>>server with oninit but it has still stopped in fast recovery
>>>>with the Blocked:CKPT
>>
>>>>Stu
>>
>>>Stu,
>>
>>>Have you tried "onmode -c unblock"?
>>
>>>Mike- Hide quoted text -
>>
>>>- Show quoted text -
>>
>>Mike,
>> That didn't work either. I'm not very familiar with informix, so I'm
>>grateful the assistance you're providing.
>>
>>Stu.
>>
>>_______________________________________________
>>Informix-list mailing list
>>Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>>
>>- Show quoted text -
>
>
> Hi Everett,
>
> No It dosn't get to that point. The last entries in the log are:
> 15:53:20 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized.
> 15:53:20 DR: Logs already cleared
> 15:53:20 Physical Recovery Started at Page (3:48516).
> 15:53:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages
> Restored.
> 15:53:20 DR: Trying to connect to primary server = ctlprime1_primary
> 15:53:21 Dataskip is now OFF for all dbspaces
> 15:53:21 Restartable Restore has been ENABLED
> 15:53:21 Recovery Mode>
> Stu.
>
And what does the "primary" state in the online.log for this time?
and what does onstat -g dri state for both the primary and the secondary?
On Feb 23, 5:01 pm, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote:
> stumacpher...@hotmail.com wrote:
> > On 23 Feb, 16:45, "Everett Mills" <eemi...@nationalbeef.com> wrote:
>
> >>Stu-
> >> What is in the online.log when the server hangs? Does it get to
> >>this point?
>
> >>17:17:41 Recovery Mode
> >>17:17:48 DR: Secondary server connected 17:17:50 DR: Secondary server> >>needs failure recovery
>
> >>17:17:50 DR: Failure recovery from disk in progress ...>
> >> If it says something about reading logs from tape, you will
> >>either have to supply it with backed up log tapes or restore a level 0
> >>backup to restart data replication.
>
> >> --EEM
>
> >>-----Original Message-----
> >>From: informix-list-boun...@iiug.org
>
> >>[mailto:informix-list-boun...@iiug.org] On Behalf Of
> >>stumacpher...@hotmail.com
> >>Sent: Friday, February 23, 2007 10:24 AM
> >>To: informix-l...@iiug.org
> >>Subject: Re: HDR - Blocked C
>
> >>On 23 Feb, 14:12, "Mike Badar" <mba...@esri.com> wrote:
>
> >>>>-----Original Message-----
> >>>>From: informix-list-boun...@iiug.org
> >>>>[mailto:informix-list-boun...@iiug.org] On Behalf Of
> >>>>stumacpher...@hotmail.com
> >>>>Sent: Friday, February 23, 2007 3:56 AM
> >>>>To: informix-l...@iiug.org
> >>>>Subject: Re: HDR - Blocked C
>
> >>>>On 22 Feb, 14:42, "Mike Badar" <mba...@esri.com> wrote:
>
> >>>>>Stu,
>
> >>>>>This sounds like a problem I had recently; this may be the
>
> >>solution:
>
> >>>>>Check the values of TAPEDEV and LTAPEDEV. If they are set to some
> >>>>>physical device - for example /dev/rmt0 - and the device is
>
> >>>>off-line
>
> >>>>>or there is no backup tape in the device, IDS will wait in Fast
> >>>>>Recovery until either a valid backup tape is supplied to
>
> >>>>the device or
>
> >>>>>TAPEDEV and/or LTAPEDEV is set to /dev/null. This is what I did
>
> >>to
>
> >>>>>make the
> >>>>>change:
>
> >>>>>bring down the engine;
> >>>>>change TAPEDEV and LTAPEDEV in the onconfig to /dev/null;
>
> >>>>restart the
>
> >>>>>engine.
>
> >>>>>Let us know if this fixes the problem.
>
> >>>>>Mike Badar
> >>>>>ESRI
> >>>>>1 International Ct.
> >>>>>Broomfield, CO 80021
> >>>>>mba...@esri.com
> >>>>>303-449-7779www.esri.com
>
> >>>>>>-----Original Message-----
> >>>>>>From: informix-list-boun...@iiug.org
> >>>>>>[mailto:informix-list-boun...@iiug.org] On Behalf Of
> >>>>>>stumacpher...@hotmail.com
> >>>>>>Sent: Thursday, February 22, 2007 2:37 AM
> >>>>>>To: informix-l...@iiug.org
> >>>>>>Subject: HDR - Blocked C
>
> >>>>>>Hi
>
> >>>>>>I'm running Informix 10 TC3 on Windows Server 2003 in an
>
> >>>>HDR pair. I
>
> >>>>>>recently rebooted the secondary server, but it has now
>
> >>>>stuck in fast
>
> >>>>>>recovery mode. The following is the output from onstat -
>
> >>>>>>IBM Informix Dynamic Server Version 10.00.TC3 -- Fast
>
> >>Recovery
>
> >>>>>>(Sec) -- Up 1 days 00:29:07 -- 81792 Kbytes Blocked:CKPT
>
> >>>>>>Can anyone tell me how to resolve this?
>
> >>>>>>Thanks
>
> >>>>>>Stu.
>
> >>>>Hi Mike,
>
> >>>>Thanks for your help.
>
> >>>>I shutdown the server with oninit -ky,
> >>>>In the onconfig LTAPEDEV was set to NUL TAPEDEV was pointing
> >>>>to a file on disk, which I changed to NUL I restarted the
> >>>>server with oninit but it has still stopped in fast recovery
> >>>>with the Blocked:CKPT
>
> >>>>Stu
>
> >>>Stu,
>
> >>>Have you tried "onmode -c unblock"?
>
> >>>Mike- Hide quoted text -
>
> >>>- Show quoted text -
>
> >>Mike,
> >> That didn't work either. I'm not very familiar with informix, so I'm
> >>grateful the assistance you're providing.
>
> >>Stu.
>
> >>_______________________________________________
> >>Informix-list mailing list
> >>Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list-Hide quoted text -
>
> >>- Show quoted text -
>
> > Hi Everett,
>
> > No It dosn't get to that point. The last entries in the log are:
> > 15:53:20 IBM Informix Dynamic Server Initialized -- Shared Memory> > Initialized.
> > 15:53:20 DR: Logs already cleared
> > 15:53:20 Physical Recovery Started at Page (3:48516).
> > 15:53:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages
> > Restored.
> > 15:53:20 DR: Trying to connect to primary server = ctlprime1_primary
> > 15:53:21 Dataskip is now OFF for all dbspaces
> > 15:53:21 Restartable Restore has been ENABLED
> > 15:53:21 Recovery Mode>
> > Stu.
>
> And what does the "primary" state in the online.log for this time?
>
> and what does onstat -g dri state for both the primary and the secondary?- Hide quoted text -
>
> - Show quoted text -
Logs from primary server for same period
15:45:09 Maximum server connections 9
15:50:09 Checkpoint Completed: duration was 0 seconds.
15:50:09 Checkpoint loguniq 471, logpos 0x143c08, timestamp:0x5146a13
15:50:09 Maximum server connections 9
15:55:09 Checkpoint Completed: duration was 0 seconds.
15:55:09 Checkpoint loguniq 471, logpos 0x146018, timestamp:0x514715e
15:55:09 Maximum server connections 9
16:00:09 Checkpoint Completed: duration was 0 seconds.
16:00:09 Checkpoint loguniq 471, logpos 0x147018, timestamp:0x5147163
primary server reponse to onstat -g dri
IBM Informix Dynamic Server Version 10.00.TC3 -- On-Line -- Up 67
days 11:21
:03 -- 155520 Kbytes
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
standard off 112 / 1838
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND \\tmp
DRIDXAUTO 0
Secondary response
IBM Informix Dynamic Server Version 10.00.TC3 -- Fast Recovery
(Sec) -- Up 1
days 19:28:19 -- 81792 KbytesBlocked:CKPT
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
secondary off ctlprime1_primary 112 / 1838
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND \\tmp
DRIDXAUTO 0
< BIG snip>
...
>
> Logs from primary server for same period
>
> 15:45:09 Maximum server connections 9
> 15:50:09 Checkpoint Completed: duration was 0 seconds.
> 15:50:09 Checkpoint loguniq 471, logpos 0x143c08, timestamp:> 0x5146a13
>
> 15:50:09 Maximum server connections 9
> 15:55:09 Checkpoint Completed: duration was 0 seconds.
> 15:55:09 Checkpoint loguniq 471, logpos 0x146018, timestamp:> 0x514715e
>
> 15:55:09 Maximum server connections 9
> 16:00:09 Checkpoint Completed: duration was 0 seconds.
> 16:00:09 Checkpoint loguniq 471, logpos 0x147018, timestamp:> 0x5147163
>
> primary server reponse to onstat -g dri
>
> IBM Informix Dynamic Server Version 10.00.TC3 -- On-Line -- Up 67
> days 11:21
> :03 -- 155520 Kbytes>
> Data Replication:
> Type State Paired server Last DR CKPT (id/pg)
> standard off 112 / 1838
>
> DRINTERVAL 30
> DRTIMEOUT 30
> DRAUTO 0
> DRLOSTFOUND \\tmp
> DRIDXAUTO 0>
> Secondary response
>
>
> IBM Informix Dynamic Server Version 10.00.TC3 -- Fast Recovery
> (Sec) -- Up 1
> days 19:28:19 -- 81792 Kbytes> Blocked:CKPT
>
> Data Replication:
> Type State Paired server Last DR CKPT (id/pg)
> secondary off ctlprime1_primary 112 / 1838
>
> DRINTERVAL 30
> DRTIMEOUT 30
> DRAUTO 0
> DRLOSTFOUND \\tmp
> DRIDXAUTO 0>
Well, ya primary does not think it is a primary, so you secondary is
talking to no-one :(
You could try running the following on the primary :
onmode -d primary ctlprime1_secondary
IF that is the tcp DBSERVERNAME or ALIAS of the secondary.
Have a look through the "primary"s log to see when HDR WAS running
(around log 112), and any messages from there on.
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g