informix server is down

Our informix 10 server is loaded in suse Linux 9 in one system. In other system red hat linux is loaded. In redhat system i loaded Clint SDK and php5.0. At first it is running smoothly without any problem. After some days when ever i running PHP Programs the informix server is down. i.e. when seeing onstat- it is showing "Shared Memory not initialised"

Send more of your online.log file to see what other messages you are getting from the time it was running fine to the errors. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of THAMMANA VEERA VENKATA PHANI KUMAR Sent: Thursday, March 06, 2008 9:49 PM To: ids@iiug.org Subject: informix server is down [11529] Our informix 10 server is loaded in suse Linux 9 in one system. In other system red hat linux is loaded. In redhat system i loaded Clint SDK and php5.0. At first it is running smoothly without any problem. After some days when ever i running PHP Programs the informix server is down. i.e. when seeing onstat- it is showing "Shared Memory not initialised" ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

online.log:- 08:19:31 Maximum server connections 28 08:21:48 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:51 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:53 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:56 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:59 Contiguous shared memory segment allocation failed at 0x55471000. Allocation successful at 0x55800000. Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std. If you are using the correct SHMBASE value in your ONCONFIG file, then consider this message informational only. 08:21:59 shmat: [22]: operating system error 08:21:59 Client could not attach server shared memory segment, use IFX_XFER_SHMBASE. 08:21:59 Assert Failed: errors occurred during mt_notifyvp 08:21:59 IBM Informix Dynamic Server Version 10.00.UC4 08:21:59 Who: Session(120, student@::ffff:172.57.100.69, 3267, 0x51392aac) Thread(168, sqlexec, 5136fa48, 1) File: mt.c Line: 11134 08:21:59 stack trace for pid 5066 written to /home/informix/tmp/af.490adce 08:21:59 See Also: /home/informix/tmp/af.490adce, shmem.490adce.0 08:22:02 mt.c, line 11134, thread 168, proc id 5066, errors occurred during mt_notifyvp. 08:22:03 The Master Daemon Died 08:22:03 PANIC: Attempting to bring system down 08:22:03 semctl: errno = 22 08:22:03 semctl: errno = 22 . . . 08:25:52 IBM Informix Dynamic Server Started. 08:25:52 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'bnm' poll threads started on NET VPs. 08:25:52 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'bnmsco' poll threads started on NET VPs. Fri Mar 7 08:25:52 2008 08:25:52 Event alarms enabled. ALARMPROG = '/home/informix/etc/alarmprogram.sh' 08:25:52 Booting Language <c> from module <> 08:25:52 Loading Module <CNULL> 08:25:52 Booting Language <builtin> from module <> 08:25:52 Loading Module <BUILTINNULL> 08:25:57 DR: DRAUTO is 0 (Off) 08:25:57 Dynamically allocated new message shared memory segment (size 836KB) 08:25:57 Dynamically allocated new message shared memory segment (size 836KB) 08:25:58 Dynamically allocated new message shared memory segment (size 836KB) 08:25:58 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000 08:25:59 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 08:25:59 Physical Recovery Started at Page (1:1020). 08:25:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 08:25:59 Logical Recovery Started. 08:25:59 10 recovery worker threads will be started. 08:26:02 Logical Recovery has reached the transaction cleanup phase. 08:26:02 Logical Recovery Complete. 126 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 08:26:03 Dataskip is now OFF for all dbspaces 08:26:03 Checkpoint Completed: duration was 0 seconds. 08:26:03 Checkpoint loguniq 1507, logpos 0x1832018, timestamp: 0x46d956d0 08:26:03 Maximum server connections 0 08:26:03 On-Line Mode 08:26:03 Affinitied VP 1 to phys proc 2 08:26:08 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:10 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:13 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:15 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:20 Assert Warning: Unable to allocate a transaction for user id 0, session id 0 08:26:20 IBM Informix Dynamic Server Version 10.00.UC4 08:26:20 Who: Session(35, informix@, 0, (nil)) Thread(21, sm_listen, 0, 1) File: rsshmem.c Line: 1802 08:26:20 Results: Memory allocation error. 08:26:20 Action: Make more virtual memory available to Dynamic Server 08:26:20 stack trace for pid 8289 written to /home/informix/tmp/af.3fdaed3 08:26:20 See Also: /home/informix/tmp/af.3fdaed3 08:26:20 Unable to allocate a transaction for user id 0, session id 0 08:26:20 (35) connection rejected - too many users, or invalid user name 08:26:20 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create an user thread. On NT check username and IXUSERS group. 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory 08:26:20 listener-thread: err = -406: oserr = 2: errstr = : Memory allocation failed. System error = 2. 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory

Make your SHMVIRTSIZE value much larger. THAMMANA VEERA VENKATA PHANI KUMAR <tvvphanikumar1@rediffmail.com> wrote: online.log:- 08:19:31 Maximum server connections 28 08:21:48 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:51 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:53 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:56 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:59 Contiguous shared memory segment allocation failed at 0x55471000. Allocation successful at 0x55800000. Check SHMBASE is consistent with the value in $INFORMIXDIR/etc/onconfig.std. If you are using the correct SHMBASE value in your ONCONFIG file, then consider this message informational only. 08:21:59 shmat: [22]: operating system error 08:21:59 Client could not attach server shared memory segment, use IFX_XFER_SHMBASE. 08:21:59 Assert Failed: errors occurred during mt_notifyvp 08:21:59 IBM Informix Dynamic Server Version 10.00.UC4 08:21:59 Who: Session(120, student@::ffff:172.57.100.69, 3267, 0x51392aac) Thread(168, sqlexec, 5136fa48, 1) File: mt.c Line: 11134 08:21:59 stack trace for pid 5066 written to /home/informix/tmp/af.490adce 08:21:59 See Also: /home/informix/tmp/af.490adce, shmem.490adce.0 08:22:02 mt.c, line 11134, thread 168, proc id 5066, errors occurred during mt_notifyvp. 08:22:03 The Master Daemon Died 08:22:03 PANIC: Attempting to bring system down 08:22:03 semctl: errno = 22 08:22:03 semctl: errno = 22 .. .. .. 08:25:52 IBM Informix Dynamic Server Started. 08:25:52 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'bnm' poll threads started on NET VPs. 08:25:52 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'bnmsco' poll threads started on NET VPs. Fri Mar 7 08:25:52 2008 08:25:52 Event alarms enabled. ALARMPROG = '/home/informix/etc/alarmprogram.sh' 08:25:52 Booting Language from module <> 08:25:52 Loading Module 08:25:52 Booting Language from module <> 08:25:52 Loading Module 08:25:57 DR: DRAUTO is 0 (Off) 08:25:57 Dynamically allocated new message shared memory segment (size 836KB) 08:25:57 Dynamically allocated new message shared memory segment (size 836KB) 08:25:58 Dynamically allocated new message shared memory segment (size 836KB) 08:25:58 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000 08:25:59 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 08:25:59 Physical Recovery Started at Page (1:1020). 08:25:59 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 08:25:59 Logical Recovery Started. 08:25:59 10 recovery worker threads will be started. 08:26:02 Logical Recovery has reached the transaction cleanup phase. 08:26:02 Logical Recovery Complete. 126 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 08:26:03 Dataskip is now OFF for all dbspaces 08:26:03 Checkpoint Completed: duration was 0 seconds. 08:26:03 Checkpoint loguniq 1507, logpos 0x1832018, timestamp: 0x46d956d0 08:26:03 Maximum server connections 0 08:26:03 On-Line Mode 08:26:03 Affinitied VP 1 to phys proc 2 08:26:08 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:10 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:13 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:15 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:18 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:18 out of virtual shared memory 08:26:20 Assert Warning: Unable to allocate a transaction for user id 0, session id 0 08:26:20 IBM Informix Dynamic Server Version 10.00.UC4 08:26:20 Who: Session(35, informix@, 0, (nil)) Thread(21, sm_listen, 0, 1) File: rsshmem.c Line: 1802 08:26:20 Results: Memory allocation error. 08:26:20 Action: Make more virtual memory available to Dynamic Server 08:26:20 stack trace for pid 8289 written to /home/informix/tmp/af.3fdaed3 08:26:20 See Also: /home/informix/tmp/af.3fdaed3 08:26:20 Unable to allocate a transaction for user id 0, session id 0 08:26:20 (35) connection rejected - too many users, or invalid user name 08:26:20 listener-thread: err = -25571: oserr = 0: errstr = : Cannot create an user thread. On NT check username and IXUSERS group. 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory 08:26:20 listener-thread: err = -406: oserr = 2: errstr = : Memory allocation failed. System error = 2. 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory 08:26:20 shmget: [EEXIST][17]: key 52574811: shared memory already exists 08:26:20 out of virtual shared memory ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.