RE: system hangs during accessing a particular table

On sober second thought - DON'T post onstat -a output to the list. They tend to be rather large and folks using a phone line to read the group will be unhappy. But you can send it here if you like. cheers j. > -----Original Message----- > From: Parker, Jack > Sent: Thursday, February 15, 2001 7:44 AM > To: 'sudhakar'; informix-list@iiug.org > Subject: RE: system hangs during accessing a particular table > > > > Sudhakar, > > If you want us to tell you what the problem is, please > include the af files mentioned in the log as well as output > from onstat -a shmem.298e2a7.0 (or whatever the shared memory > dump is called this crash). Otherwise we're stumbling around > in the dark. > > cheers > j. > > > -----Original Message----- > > From: sudhakar [mailto:k_sudhak@rediffmail.com] > > Sent: Tuesday, February 13, 2001 6:30 AM > > To: informix-list@iiug.org > > Subject: system hangs during accessing a particular table > > > > > > hello, > > we have informix 7.3 dynamic server on SCO unix open server 5.0.5 > > while running sql statement on a particular table .system hangs. > > while we gave oncheck -cD dbname ,no error has been reported. > > due to this dbexport,dbscehma also hangs the system. > > pls send a solution as soon as possible. > > > > error message from online.log is as follows > > > > 12:43:21 Checkpoint Completed: duration was 3 seconds. > > 13:00:47 Assert Failed: Memory block header corruption detected in > > mt_shm_malloc_segid 2 > > 13:00:47 Informix Dynamic Server Version 7.30.UC2 > > 13:00:47 Who: Session(645, root@efau01, 18519, 0) > > Thread(664, sqlexec, 0, 1) > > File: mtshpool.c Line: 2455 > > 13:00:47 Results: Pool repaired > > 13:00:47 Action: Please notify Informix Technical Support. > > 13:00:50 See Also: /tmp/af.298e2a7, shmem.298e2a7.0 > > 13:07:57 Assert Failed: Memory block header corruption detected in > > mt_shm_malloc_segid 2 > > 13:07:57 Informix Dynamic Server Version 7.30.UC2 > > 13:07:57 Who: Session(645, root@efau01, 18519, 0) > > Thread(664, sqlexec, 0, 1) > > File: mtshpool.c Line: 2455 > > 13:07:57 Results: Unable to repair pool > > 13:07:57 Action: Please notify Informix Technical Support.> > > > > > bye > > sudhakar > > > > -- > > Posted via CNET Help.com > > http://www.help.com/ > > >