Re: Shared Memory Initialisation Problem

This problem occurs when system can't free SHM segments. You can check them using ipcs command. This command will show you current allocated semephores and shared memory segments. For example; $ipcs Message Queues: T ID KEY MODE OWNER GROUP q 0 0x41e502a2 --rw------- root system Shared Memory: T ID KEY MODE OWNER GROUP m 0 0x3253bc5c --rw-rw-rw- root system m 1 0x52604801 --rw-rw---- root informix m 2 0x52604802 --rw-rw---- root informix m 3 0x52604803 --rw-rw-rw- root informix m 4 0x52744801 --rw-rw---- root informix m 5 0x52744802 --rw-rw---- root informix m 6 0x52744803 --rw-rw-rw- root informix m 7 0x52744804 --rw-rw---- root informix m 8 0x52744805 --rw-rw---- root informix m 4105 0x52564801 --rw-rw---- root informix m 4106 0x52564802 --rw-rw---- root informix m 779 0x52564803 --rw-rw-rw- root informix Semaphores: T ID KEY MODE OWNER GROUP s 0 0x41e502a2 --ra------- root system : You can grep informix shmsegments using $ipcs |grep informix Than you should remove them. $ipcrm -m <segmentid> You're all set bring your database again.If this doesn't helps you you should reboot your system.And $oninit Alkin TEZUYSAL INFORMIX DBA mailto:atezuysal@hotmail.com >From: Patrick Herrera <patrickh@posit.com.au> >Reply-To: Patrick Herrera <patrickh@posit.com.au> >To: informix-list@iiug.org >Subject: Shared Memory Initialisation Problem >Date: Thu, 03 Jun 1999 16:49:32 +1000 > >Hello all, > >Could anyone shed light on why I get the following messages in the >online.log file every time I try to bring Informix on-line or to >quiescent mode from off-line. > >15:32:36 shmget: [EEXIST][17]: key 52644801: shared memory already>exists >15:32:36 mt_shm_init: can't create resident segment> >No matter how I shutdown the DB, for example from on-line to quiescent >or directly to off-line (all using onmode), I am unable to restart it. >The only solution I have found is to restart the entire system. > >My pressing problem is that after initiating a cold, full system >restore, the DB was unable to come back up as part of the process: > >15:16:55 Physical Restore of dbspc1, dbspc2, dbspc3 started. >15:17:07 Physical Restore of dbspc1, dbspc2, dbspc3 Completed. >15:17:08 Checkpoint Completed: duration was 0 seconds. >15:33:44 Shutdown Mode >15:33:45 Quiescent Mode >15:34:07 INFORMIX-OnLine Stopped. >15:37:23 shmget: [EEXIST][17]: key 52644801: shared memory already>exists >15:37:23 mt_shm_init: can't create resident segment> >We restarted the system and when Informix tried to come up we received >the following errors: > >15:55:17 INFORMIX-OnLine Initialized -- Shared Memory Initialized. >15:55:17 Physical Recovery Started. >15:55:23 Physical Recovery Complete: 368 Pages Restored. >15:55:23 Logical Recovery Started. >15:55:23 Checkpoint Record not Found in Logical Log. >15:55:24 Cannot Rollforward from Checkpoint. >15:55:24 INFORMIX-OnLine Stopped. >15:55:24 mt_shm_remove: WARNING: may not have removed all/correct>segments > >Can anyone help me fix this problem? Logical log backups have not been >made because the data is all relatively easy to recreate. >Our Informix version is INFORMIX-OnLine Dynamic Server 7.12.UC1 running >on Solaris 2.5 on a SPARC system. >Most of the settings, inc. shared memory are the defaults. > >Thanks in advance, > >Patrick >______________________________________________ > > THE DIGITAL MAGE > > Technical & development wizardry > for New Media solutions > > >Suite 24, Level 2 Ph: (03) 62 24 3535 >"City Mill Building" Fax: (03) 62 24 3545 >11 Morrison Street >Hobart, TAS 7000 > > Email: patrickh@posit.com.au ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com