Re: ***Urgent**** on the production. PLEASE HELP******

In technical terms, you're hosed. When a long transaction fills the logs, the system locks up and you're looking at a restore from a tape archive. I hope you have one. If you don't, that's hard lesson number one. Now, 7000 rows isn't much, so first off your logical logs are too small. Make em big, disk is cheap. Time isn't. On a big system, 2-4 GB or more isn't uncommon. LTXHWM and LTXEHWM also keep you out of trouble with long transactions, yours should be OK when you expand the logical log. Everybody has to get burned by this once. Welcome to the club. Greg Nobody Nowhere wrote: > (Was n't sure if the previous one went through). So trying again... > --------------------------------------------------------------- > > Guru's out there Please help!!!!!!!!!!!!!1 > > OK this is what (we think) had happened. > > We use this informix server9.13 and as a part of the release to production, > I tried to populate a fairly huge > table with about 7000 rows. ( basically I wrote a scriot which first creates > the table using "CREATE TABLE" > and then inserts the 7000 rows using an insert. But in the process, the > logical logs were full and the script was just > sitting there doing nothing. Then We killed the script.Now hte database is > locked up and I cannot do anything. I tried to shutdown > the instance using onmode - yuk. But it sits there doing nothing.I have no > idea how to bring down the server and bring it up again. > > I am almost sure that this is because of the problem with the logical logs > being filled up. > I also tried to bakcup the logical logs using ontape -a. But it did not free > up log space. > > Some guru out there could you please help!!!! > > I am Not a DBA. So I am new to these kind of problems. > This is the error messages that are seen when I do onstat -m > ============================================================================ > ======== > 14:35:29 Logical Log 11 Complete. > 14:35:36 Logical Log Files are Full -- Backup is Needed > > 14:35:36 Booting Language <spl> from module <> > 14:35:36 Loading Module <SPLNULL> > 14:35:36 Logical Log 7 - Backup Started > 14:47:53 Logical Log 7 - Backup Aborted > Aborted by client. > 14:48:04 INFORMIX-Universal Server Stopped. > 14:53:01 Assert Failed: mt_notifyvp timed out > 14:53:01 INFORMIX-Universal Server Version 9.13.UC3 > 14:53:01 Who: Session(12, informix@pba, 0, 0) > Thread(21, onmode_mon, 0, 1) > File: mt.c Line: 8132 > 14:53:32 See Also: /tmp/af.15a2e4, shmem.15a2e4.0 > 14:53:36 mt.c, line 8132, thread 21, proc id 26158, mt_notifyvp timed out. > 14:58:30 shmget: [EEXIST][17]: key 52584801: shared memory already exists > 14:58:30 mt_shm_init: can't create resident segment > > 15:12:16 shmget: [EEXIST][17]: key 52584801: shared memory already exists > 15:12:16 mt_shm_init: can't create resident segment > > 16:19:40 shmget: [EEXIST][17]: key 52584801: shared memory already exists > 16:19:40 mt_shm_init: can't create resident segment > > 16:20:20 shmget: [EEXIST][17]: key 52584801: shared memory already exists > 16:20:20 mt_shm_init: can't create resident segment > > 16:28:20 shmget: [EEXIST][17]: key 52584801: shared memory already exists > 16:28:20 mt_shm_init: can't create resident segment > ============================================================================ > ========> > Also, I am attaching the configuration file....... > > Please help. > > Thanks very much for all your help. > I really appreciate your time. > > ..Prasad > > INFORMIX-Universal Server Version 9.13.UC3 -- Shutting Down (CKPT REQ) -- Up 0 > 9:56:42 -- 29384 Kbytes > Blocked:CKPT > > Configuration File: /usr/informix/etc/onconfig.att2 > #************************************************************************** > # > # INFORMIX SOFTWARE, INC. > # > # Title: onconfig.std > # Description: INFORMIX-Universal Server Configuration Parameters > # This is the config file for the second instance on the prod server. > #************************************************************************** > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /usr/informix/data/rootdbs > #Path for device containing root dbspace > ROOTOFFSET 2 # Offset of root dbspace into device (Kbytes) > ROOTSIZE 50000 # Size of root dbspace (Kbytes)> > # Disk Mirroring Configuration Parameters > > MIRROR 0 # Mirroring flag (Yes = 1, No = 0) > MIRRORPATH # Path for device containing mirrored root > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> > # Physical Log Configuration > > PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSFILE 1000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 6 # Number of logical log files > LOGSIZE 500 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /usr/informix/online2.log # System message log file path > CONSOLE /dev/console # System console message path > ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path> # System Archive Tape Device > > TAPEDEV /tmp/backup2 # Tape device path > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 102400000 # Maximum amount of data to put on tape (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /tmp/backup_logs2 # Log tape device path > LTAPEBLK 16 # Log tape block size (Kbytes) > LTAPESIZE 1024000 # Max amount of data to put on log tape (Kbytes)> > # Optical > > STAGEBLOB # INFORMIX-OnLine/Universal Server staging area > > # System Configuration > > SERVERNUM 2 # Unique id corresponding to a OnLine instance > DBSERVERNAME attpba913_2 # Name of default database server > DBSERVERALIASES attpba913_tcp_2 # List of alternate dbservernames > NETTYPE ipcshm,1,15,CPU # Configure poll thread(s) for nettype > NETTYPE tlitcp,1,15,NET # Configure poll thread(s) for nettype > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. > RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) > > MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor > NUMCPUVPS 1 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one > > NOAGE 0 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 2000 # Maximum number of locks > BUFFERS 10000 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps>