darren_jacobs@carmax.com

Thanks for the input.

Just a brainfart on my end. I have a script that checks every 10 minutes
to ensure the engine is online. However, it doesn't check for recovery
mode. My script was attempting to clean all shared memory and restart the
instance. I disabled my cron job which allowed the server to complete the
logical recovery.

thanks


"James Maes"
<jmaes@materialog
ic.com> To
<Darren_Jacobs@carmax.com>,
08/26/2005 04:56 <informix-list@iiug.org>
PM cc

Subject
RE: Little Help ASAP


Looks like you have something still holding on to a shared memory
connection
to the old instance of the database.

This used to happen to us when the server would crash and a dbaccess or
isql
session was left hanging around.

Make sure that all old processes which had a shared memory connection to
the
machine are kill (reboot if you have to) and then restart. Should come up
then.

James Maes
Materialogic
PH: 800-333-7144
PH: 314-997-4342 Ext.3422
FX: 314-997-7814

-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]On
Behalf Of Darren_Jacobs@carmax.com
Sent: Friday, August 26, 2005 3:32 PM
To: informix-list@iiug.org
Subject: Little Help ASAP

I'm getting the following errors in the log when attempting to restart the
engine after the server crashed. It appears it gets to a point in the
recovery and wants to restart itself.

HPUX 11.i v1
9.40 FC2


16:23:38 Dynamically allocated new virtual shared memory segment (size
1909316KB)

Fri Aug 26 16:23:46 2005

16:23:46 Event alarms enabled. ALARMPROG = '/usr/informix/etc/no_log.sh'
16:23:46 Booting Language <c> from module <>
16:23:46 Loading Module <CNULL>
16:23:46 Booting Language <builtin> from module <>
16:23:46 Loading Module <BUILTINNULL>
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 Dynamically allocated new message shared memory segment (size
884KB)
16:23:51 IBM Informix Dynamic Server Version 9.40.FC2W4 Software Serial
Number AAA#B000000
16:23:55 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.

16:23:55 DR: Reservation of the last logical log for log backup turned on
16:23:55 Physical Recovery Started at Page (2:17329).
16:23:58 Physical Recovery Complete: 15159 Pages Examined, 15046 Pages
Restored.
16:23:58 Logical Recovery Started.
16:23:58 10 recovery worker threads will be started.
16:23:58 HPUX Version B.11.11 -> Using flag/select style KAIO
16:23:58 HP KAIO concurrent requests changed from 1000 to 2300
16:27:01 IBM Informix Dynamic Server Started.
16:27:01 shmget: [EEXIST][17]: key 52564801: shared memory already exists
16:27:01 mt_shm_init: can't create resident segment
sending to informix-list
sending to informix-list