Informix database couldnot startup
A user's Informix server wouldn't start, failing with "shmget: [EEXIST] key ...: shared memory already exists" and "mt_shm_init: can't create resident segment", even after removing the segment with ipcrm. Replies explained that leftover segments persist when processes (dbaccess, onstat, ontape, or a kill -9'd CPU VP) are still attached, and suggested onclean/onshutdown, clearing all segments, changing SERVERNUM, or rebooting. onclean and onshutdown didn't help; the poster resolved it by clearing all remaining shared memory segments, after which the server started.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All, Informix database couldn't startup and giving following error 11:44:25 IBM Informix Dynamic Server Started. 11:44:25 shmget: [EEXIST][17]: key 52584804: shared memory already exists 11:44:25 mt_shm_init: can't create resident segment I have cleared above the process ipcrm and still getting same error thank you very much Regards Baskaran --089e0149396409cf2904e3cc61bb
can you send me the os & Informix version that you have installed Pushpa
while you can use ipcrm to remove the memory you also have to=
remove all process which have attached to the shared memory segment.
If=
there is a stray process (onstat, ontape,...), the memory is still in
u= se and
the operating system will not release the segments.
<= br>John F. Miller III
STSM, Lead Architect
-----ids-bounces@iiug.org wrote: -----
>To: = ids@iiug.org
>From: "medkba"
>Sent by: ids-bounces@iiug.org
>Date: 08/12/2013 09:08PM
>Subject: Informix database couldnot st= artup [31165]
>
>Hi All, Informix database couldn't startup = and giving following
>error 11:44:25 IBM Informix Dynamic Server St= arted. 11:44:25
>shmget: [EEXIST][17]: key 52584804: shared memory a= lready exists
>11:44:25 mt=5Fshm=5Finit: can't create resident segmen= t I have
cleared
>above the process ipcrm and still getting same err= or thank you very
>much Regards Baskaran --089e0149396409cf290= 4e3cc61bb
>**********************************************************=
***********
>********** Forum Note: Use "Reply" to post a response= in the
>discussion forum. =
Hello.
Two great utilities for removing memory segments, are onshutdown and onclean.
I´d suggest onclean first, if you still get issues, I´d suggest a reboot in
your box. Some friends are complaining about these issues, but in most cases
they are related to operational system troubles, not Informix.
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: miller3@us.ibm.com
> Subject: Re: Informix database couldnot startup [31169]
> Date: Tue, 13 Aug 2013 04:15:39 -0400
>
> while you can use ipcrm to remove the memory you also have to=
>
> remove all process which have attached to the shared memory segment.
>
> If=
>
> there is a stray process (onstat, ontape,...), the memory is still in
>
> u= se and
>
> the operating system will not release the segments.
>
> <= br>John F. Miller III
>
> STSM, Lead Architect
>
> -----ids-bounces@iiug.org wrote: -----
>
> >To: = ids@iiug.org
>
> >From: "medkba"
>
> >Sent by: ids-bounces@iiug.org
>
> >Date: 08/12/2013 09:08PM
>
> >Subject: Informix database couldnot st= artup [31165]
>
> >
>
> >Hi All, Informix database couldn't startup = and giving following
>
> >error 11:44:25 IBM Informix Dynamic Server St= arted. 11:44:25
>
> >shmget: [EEXIST][17]: key 52584804: shared memory a= lready exists
>
> >11:44:25 mt=5Fshm=5Finit: can't create resident segmen= t I have
>
> cleared
>
> >above the process ipcrm and still getting same err= or thank you very
>
> >much Regards Baskaran --089e0149396409cf290= 4e3cc61bb
>
> >**********************************************************=
>
> ***********
>
> >********** Forum Note: Use "Reply" to post a response= in the
>
> >discussion forum. =
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi,
This usually happens when you segments are still there even if your
engine has been shut down. If you did a "kill -9" on the main CPU VP,
the engine no longer runs but sometimes the SHM segments are still
there. Sometimes this happens also when a dbaccess process is still
runnning or another application process.
If ipcrm does not help and all of the applications connected are not
there any longer, either you could change the SERVERNUM in the onconfig
file to another unused number (of course this is not the best thing
since you might consume more SHM but allows you to start the engine
quickly without having to reboot the server) and restart the Informix
engine, or reboot your server.
It looks like one of the SHM segments identified by the Key 0x52584804
is still there.
Cordialement, Regards,
Khaled Bentebal
Directeur Général - ConsultiX
Président UGIF - User Group Informix France
IIUG - Board of Directors
Tél: 33 (0) 1 39 12 18 00
Fax: 33 (0) 1 39 12 18 18
Mobile: 33 (0) 6 07 78 41 97
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr
Le 13/08/13 06:07, medkba a écrit :
> Hi All,
>
> Informix database couldn't startup and giving following error
>
> 11:44:25 IBM Informix Dynamic Server Started.
> 11:44:25 shmget: [EEXIST][17]: key 52584804: shared memory already exists
> 11:44:25 mt_shm_init: can't create resident segment
> I have cleared above the process ipcrm and still getting same error
>
> thank you very much
>
> Regards
> Baskaran
>
> --089e0149396409cf2904e3cc61bb
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Thank you for all their advice.
I have tried onshutdown.sh and onclean both does not works. Finally, I have
to clear all the memory segments and then start informix able to up
On Tue, Aug 13, 2013 at 6:44 PM, Alexandre Marini <alexandre@briug.org>wrote:
> Hello.
> Two great utilities for removing memory segments, are onshutdown and
> onclean.
>
> I´d suggest onclean first, if you still get issues, I´d suggest a reboot in
> your box. Some friends are complaining about these issues, but in most
> cases
> they are related to operational system troubles, not Informix.
>
> Hope it helps.
> Regards.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: miller3@us.ibm.com
> > Subject: Re: Informix database couldnot startup [31169]
> > Date: Tue, 13 Aug 2013 04:15:39 -0400
> >
> > while you can use ipcrm to remove the memory you also have to=
> >
> > remove all process which have attached to the shared memory segment.
> >
> > If=
> >
> > there is a stray process (onstat, ontape,...), the memory is still in
> >
> > u= se and
> >
> > the operating system will not release the segments.
> >
> > <= br>John F. Miller III
> >
> > STSM, Lead Architect
> >
> > -----ids-bounces@iiug.org wrote: -----
> >
> > >To: = ids@iiug.org
> >
> > >From: "medkba"
> >
> > >Sent by: ids-bounces@iiug.org
> >
> > >Date: 08/12/2013 09:08PM
> >
> > >Subject: Informix database couldnot st= artup [31165]
> >
> > >
> >
> > >Hi All, Informix database couldn't startup = and giving following
> >
> > >error 11:44:25 IBM Informix Dynamic Server St= arted. 11:44:25
> >
> > >shmget: [EEXIST][17]: key 52584804: shared memory a= lready exists
> >
> > >11:44:25 mt=5Fshm=5Finit: can't create resident segmen= t I have
> >
> > cleared
> >
> > >above the process ipcrm and still getting same err= or thank you very
> >
> > >much Regards Baskaran --089e0149396409cf290= 4e3cc61bb
> >
> > >**********************************************************=
> >
> > ***********
> >
> > >********** 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.
>
>
--089e01182dee78a58704e3d4c1d8
There are other segments. Run onclean to clear them all. Art On Aug 13, 2013 12:07 AM, "medkba" <medkba@gmail.com> wrote: > Hi All, > > Informix database couldn't startup and giving following error > > 11:44:25 IBM Informix Dynamic Server Started. > 11:44:25 shmget: [EEXIST][17]: key 52584804: shared memory already exists > 11:44:25 mt_shm_init: can't create resident segment > I have cleared above the process ipcrm and still getting same error > > thank you very much > > Regards > Baskaran > > --089e0149396409cf2904e3cc61bb > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133646089bbaf04e3d56df5