Re: Informix 9.40 crash after stress test.

sharad wrote: > Hi , > > I had install informix 9.40 UC2 on AIX 5.2. > did anybody has idea how to check informix server is using tcp connection > and not shared memory connection.How to check memory leak in informix server > ? > > Here is some portion of online.log file . > =============================================================== > 16:28:31 shmat: [EMFILE][24]: out of shared memory segments, check system> SHMSEG > > 16:28:31 shmdt: errno = 22 > 16:28:31 out of virtual shared memory > > 16:28:31 shmat: [EMFILE][24]: out of shared memory segments, check system> SHMSEG > > 16:28:31 shmdt: errno = 22 > 16:28:31 out of virtual shared memory > > 16:28:31 Assert Failed: No Exception Handler > 16:28:31 IBM Informix Dynamic Server Version 9.40.UC2 > 16:28:31 Who: Session(16, informix@adolphus, 5002, 40215d00) > Thread(40, sqlexec, 401e5e68, 1) > File: mtex.c Line: 431 > 16:28:31 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 16:28:31 Action: Please notify IBM Informix Technical Support. > 16:28:31 stack trace for pid 32182 written to /tmp/af.410fd5e > 16:28:31 See Also: /tmp/af.410fd5e, shmem.410fd5e.0 > 16:29:06 mtex.c, line 431, thread 40, proc id 32182, No Exception Handler. > 16:29:08 The Master Daemon Died > 16:29:08 PANIC: Attempting to bring system down > =============================================================== I'm not sure why you are asking those questions as they are not related to your problems in the message log. I will answer based on your message log. IIRC AIX has a limit of about 10 shared memory segments per user, so if you check onstat -g seg, you will probably see a lot of virtual segments allocated. These may be due to a rogue session or they may be required. If you do require that amount of virtual space then you need to tune your SHMVIRTSIZE parameter to allocate a single segment for all your requirements. The fact that you ran out of SHM segments should not cause the database server to crash. I suggest you contact IBM Informix Technical Support to find out more. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list