Problem with removing an instance from Enterprise
User encountered errors (error -214, -62) when removing Enterprise Replication from a 13-instance environment on Informix 10.00.FC11. The syscdr database persisted after removal. Proposed solution: restart instance with oninit -D, remove syscdr database, then re-add to replication. Expert agreed with plan but noted delete tables must also be removed. User asked for table names/locations but no further response recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
All,
Informix 10.00.FC11 on Sun Solaris 5.10
We have an ER environment consisting of 13 instances. Last night I had to
remove ER and all went tickety-bo until one of the instances reported the
following problem:
CDR NIF Shutdown: connections all shutdown.
20:13:41 CDR The NIF sub-component has shut down.
20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
20:13:42 CDR shutdown failed
20:13:42 CDR GC: operation error reporting severe error message failed (error
62).
20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239 buffers not
flushed.
20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp: 0xa6c05a51
The syscdr database still exists. I looked on the internet for similar
messages and saw various submissions. I recreated the ER environment minus
this instance but I do need to add it. So my cunning plan at the moment is:
1 - Stop the instance and restart it using oninit -D and then remove the
syscdr database.
2 - Add the instance into replication.
Does this sounds reasonable? Any alternative suggestions?
Before anyone mentions it this weekend we will be migrating to V11.70.FC2.
Regards
Andy G.
Sounds like a plan to me.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Apr 4, 2012 at 6:18 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
> All,
>
> Informix 10.00.FC11 on Sun Solaris 5.10
>
> We have an ER environment consisting of 13 instances. Last night I had to
> remove ER and all went tickety-bo until one of the instances reported the
> following problem:
>
> CDR NIF Shutdown: connections all shutdown.
> 20:13:41 CDR The NIF sub-component has shut down.
> 20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
> 20:13:42 CDR shutdown failed
> 20:13:42 CDR GC: operation error reporting severe error message failed
> (error
> 62).
> 20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239 buffers
> not
> flushed.
> 20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp: 0xa6c05a51
>
> The syscdr database still exists. I looked on the internet for similar
> messages and saw various submissions. I recreated the ER environment minus
> this instance but I do need to add it. So my cunning plan at the moment is:
>
> 1 - Stop the instance and restart it using oninit -D and then remove the
> syscdr database.
> 2 - Add the instance into replication.
>
> Does this sounds reasonable? Any alternative suggestions?
>
> Before anyone mentions it this weekend we will be migrating to V11.70.FC2.
>
> Regards
>
> Andy G.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93406616702a604bcd8f3de
You will need to get rid of all of the delete tables as well.
From: "Art Kagel" <art.kagel@gmail.com>
To: ids@iiug.org
Date: 04/04/2012 06:45 AM
Subject: Re: Problem with removing an instance from Ent.... [26654]
Sent by: ids-bounces@iiug.org
Sounds like a plan to me.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Apr 4, 2012 at 6:18 AM, Andrew Grantham
<agrantha@hotmail.com>wrote:
> All,
>
> Informix 10.00.FC11 on Sun Solaris 5.10
>
> We have an ER environment consisting of 13 instances. Last night I had to
> remove ER and all went tickety-bo until one of the instances reported the
> following problem:
>
> CDR NIF Shutdown: connections all shutdown.
> 20:13:41 CDR The NIF sub-component has shut down.
> 20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
> 20:13:42 CDR shutdown failed
> 20:13:42 CDR GC: operation error reporting severe error message failed
> (error
> 62).
> 20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239 buffers
> not
> flushed.
> 20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp:
0xa6c05a51
>
> The syscdr database still exists. I looked on the internet for similar
> messages and saw various submissions. I recreated the ER environment
minus
> this instance but I do need to add it. So my cunning plan at the moment
is:
>
> 1 - Stop the instance and restart it using oninit -D and then remove the
> syscdr database.
> 2 - Add the instance into replication.
>
> Does this sounds reasonable? Any alternative suggestions?
>
> Before anyone mentions it this weekend we will be migrating to
V11.70.FC2.
>
> Regards
>
> Andy G.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93406616702a604bcd8f3de
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Could I trouble you for the names of these delete tables and their location?
> To: ids@iiug.org
> From: mpruet@us.ibm.com
> Subject: Re: Problem with removing an instance from Ent.... [26655]
> Date: Wed, 4 Apr 2012 10:26:34 -0400
>
> You will need to get rid of all of the delete tables as well.
>
> From: "Art Kagel" <art.kagel@gmail.com>
>
> To: ids@iiug.org
>
> Date: 04/04/2012 06:45 AM
>
> Subject: Re: Problem with removing an instance from Ent.... [26654]
>
> Sent by: ids-bounces@iiug.org
>
> Sounds like a plan to me.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated nor
>
> those of the entities themselves.
>
> On Wed, Apr 4, 2012 at 6:18 AM, Andrew Grantham
> <agrantha@hotmail.com>wrote:
>
> > All,
> >
> > Informix 10.00.FC11 on Sun Solaris 5.10
> >
> > We have an ER environment consisting of 13 instances. Last night I had to
>
> > remove ER and all went tickety-bo until one of the instances reported the
>
> > following problem:
> >
> > CDR NIF Shutdown: connections all shutdown.
> > 20:13:41 CDR The NIF sub-component has shut down.
> > 20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
> > 20:13:42 CDR shutdown failed
> > 20:13:42 CDR GC: operation error reporting severe error message failed
> > (error
> > 62).
> > 20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239 buffers
> > not
> > flushed.
> > 20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp:
> 0xa6c05a51
> >
> > The syscdr database still exists. I looked on the internet for similar
> > messages and saw various submissions. I recreated the ER environment
> minus
> > this instance but I do need to add it. So my cunning plan at the moment
> is:
> >
> > 1 - Stop the instance and restart it using oninit -D and then remove the
> > syscdr database.
> > 2 - Add the instance into replication.
> >
> > Does this sounds reasonable? Any alternative suggestions?
> >
> > Before anyone mentions it this weekend we will be migrating to
> V11.70.FC2.
> >
> > Regards
> >
> > Andy G.
> >
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae93406616702a604bcd8f3de
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
They will be in the database where the table which is being replicated. They
will start with cdr_deltab_XXXXXXX.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andrew
Grantham
Sent: Wednesday, April 04, 2012 2:47 PM
To: ids@iiug.org
Subject: RE: Problem with removing an instance from Ent.... [26656]
Could I trouble you for the names of these delete tables and their location?
> To: ids@iiug.org
> From: mpruet@us.ibm.com
> Subject: Re: Problem with removing an instance from Ent.... [26655]
> Date: Wed, 4 Apr 2012 10:26:34 -0400
>
> You will need to get rid of all of the delete tables as well.
>
> From: "Art Kagel" <art.kagel@gmail.com>
>
> To: ids@iiug.org
>
> Date: 04/04/2012 06:45 AM
>
> Subject: Re: Problem with removing an instance from Ent.... [26654]
>
> Sent by: ids-bounces@iiug.org
>
> Sounds like a plan to me.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own
> opinions and do not reflect on my employer, Advanced DataTools, the
> IIUG, nor any other organization with which I am associated either
> explicitly, implicitly, or by inference. Neither do those opinions
> reflect those of other individuals affiliated with any entity with
> which I am affiliated nor
>
> those of the entities themselves.
>
> On Wed, Apr 4, 2012 at 6:18 AM, Andrew Grantham
> <agrantha@hotmail.com>wrote:
>
> > All,
> >
> > Informix 10.00.FC11 on Sun Solaris 5.10
> >
> > We have an ER environment consisting of 13 instances. Last night I
> > had to
>
> > remove ER and all went tickety-bo until one of the instances
> > reported the
>
> > following problem:
> >
> > CDR NIF Shutdown: connections all shutdown.
> > 20:13:41 CDR The NIF sub-component has shut down.
> > 20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
> > 20:13:42 CDR shutdown failed
> > 20:13:42 CDR GC: operation error reporting severe error message
> > failed (error 62).
> > 20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239
> > buffers not flushed.
> > 20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp:
> 0xa6c05a51
> >
> > The syscdr database still exists. I looked on the internet for
> > similar messages and saw various submissions. I recreated the ER
> > environment
> minus
> > this instance but I do need to add it. So my cunning plan at the
> > moment
> is:
> >
> > 1 - Stop the instance and restart it using oninit -D and then remove
> > the syscdr database.
> > 2 - Add the instance into replication.
> >
> > Does this sounds reasonable? Any alternative suggestions?
> >
> > Before anyone mentions it this weekend we will be migrating to
> V11.70.FC2.
> >
> > Regards
> >
> > Andy G.
> >
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae93406616702a604bcd8f3de
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Ml
Sent from my iPhone
On Apr 5, 2012, at 3:46, "Andrew Grantham" <agrantha@hotmail.com> wrote:
> Could I trouble you for the names of these delete tables and their location?
>
>> To: ids@iiug.org
>> From: mpruet@us.ibm.com
>> Subject: Re: Problem with removing an instance from Ent.... [26655]
>> Date: Wed, 4 Apr 2012 10:26:34 -0400
>>
>> You will need to get rid of all of the delete tables as well.
>>
>> From: "Art Kagel" <art.kagel@gmail.com>
>>
>> To: ids@iiug.org
>>
>> Date: 04/04/2012 06:45 AM
>>
>> Subject: Re: Problem with removing an instance from Ent.... [26654]
>>
>> Sent by: ids-bounces@iiug.org
>>
>> Sounds like a plan to me.
>>
>> Art
>>
>> Art S. Kagel
>> Advanced DataTools (www.advancedatatools.com)
>> Blog: http://informix-myview.blogspot.com/
>>
>> Disclaimer: Please keep in mind that my own opinions are my own opinions
>> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
>> other organization with which I am associated either explicitly,
>> implicitly, or by inference. Neither do those opinions reflect those of
>> other individuals affiliated with any entity with which I am affiliated nor
>>
>> those of the entities themselves.
>>
>> On Wed, Apr 4, 2012 at 6:18 AM, Andrew Grantham
>> <agrantha@hotmail.com>wrote:
>>
>>> All,
>>>
>>> Informix 10.00.FC11 on Sun Solaris 5.10
>>>
>>> We have an ER environment consisting of 13 instances. Last night I had to
>>
>>> remove ER and all went tickety-bo until one of the instances reported the
>>
>>> following problem:
>>>
>>> CDR NIF Shutdown: connections all shutdown.
>>> 20:13:41 CDR The NIF sub-component has shut down.
>>> 20:13:42 CDR GC: operation catalog purge (drop) failed (error -214).
>>> 20:13:42 CDR shutdown failed
>>> 20:13:42 CDR GC: operation error reporting severe error message failed
>>> (error
>>> 62).
>>> 20:16:28 Fuzzy Checkpoint Completed: duration was 0 seconds, 239 buffers
>>> not
>>> flushed.
>>> 20:16:28 Checkpoint loguniq 102718, logpos 0x214d310, timestamp:
>> 0xa6c05a51
>>>
>>> The syscdr database still exists. I looked on the internet for similar
>>> messages and saw various submissions. I recreated the ER environment
>> minus
>>> this instance but I do need to add it. So my cunning plan at the moment
>> is:
>>>
>>> 1 - Stop the instance and restart it using oninit -D and then remove the
>>> syscdr database.
>>> 2 - Add the instance into replication.
>>>
>>> Does this sounds reasonable? Any alternative suggestions?
>>>
>>> Before anyone mentions it this weekend we will be migrating to
>> V11.70.FC2.
>>>
>>> Regards
>>>
>>> Andy G.
>>>
>>>
>>>
>>>
>>
>>
>
*******************************************************************************
>>
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>
>> --14dae93406616702a604bcd8f3de
>>
>>
>>
>
*******************************************************************************
>>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>