Reading a 7.11 shmem.xxxxx file

Reading a 7.11 shmem.xxxxx file

Post by Darin Mel » Thu, 25 Jan 1996 04:00:00



When online 7.11 crashes and there is a message in my online log such as:

18:40:26  Assert Failed: Internal Error - Segmentation Violation

                Thread(8809, sqlexec, dcb3b94, 3)
18:40:26   Results: OnLine must abort
18:40:26   Action: Reinitialize shared memory
18:40:26   See Also: /tmp/af.eebcee0f, shmem.eebcee0f.0
18:41:25  rsdebug.c, line 3650, thread 8809, proc id 1443, Segmentation Violati

Question is:   how do you read the "shmem.eebcee0f.0" file?  Or is it a
waste of time?  I have a 40 GB database and periodically the engine just
crashes.  Any clues?

Thanks

+----------------------------------------------------------------------------+
|                 |                                                          |
|     .     .     |                                                          |
|    ...   ...    | Darin Melin                                              |
|   ..... .....   | Software Engineer, DBA                                   |
|  ..   ...   ..  | Business Systems Integration Group                       |
| .      .      . | Semiconductor Products Sector - LATG                     |
|                 | 2100 E. Elliot Road,   MD EL557                          |
|                 | Tempe, AZ 85284                                          |


|                 | Director - Arizona Informix Users Group                  |
+----------------------------------------------------------------------------+
|                  'connectionLESS IS MORE' -- Data Broker                   |
+----------------------------------------------------------------------------+

 
 
 

Reading a 7.11 shmem.xxxxx file

Post by Paul Watso » Sun, 28 Jan 1996 04:00:00


When online 7.11 crashes and there is a message in my online log such as:

18:40:26  Assert Failed: Internal Error - Segmentation Violation

                Thread(8809, sqlexec, dcb3b94, 3)
18:40:26   Results: OnLine must abort
18:40:26   Action: Reinitialize shared memory
18:40:26   See Also: /tmp/af.eebcee0f, shmem.eebcee0f.0
18:41:25  rsdebug.c, line 3650, thread 8809, proc id 1443, Segmentation
Violati

Question is:   how do you read the "shmem.eebcee0f.0" file?  Or is it a
waste of time?  I have a 40 GB database and periodically the engine just
crashes.  Any clues?

Thanks

onstat -i <shmem file>

This will allow you interactively examine what was happening when the
engine 'had a bad hair day'.  No it's not always a waste of time, but
can take some digging to find who was doing what, when, using which
resources etc.

Have fun

Paul Watson
WF Software Ltd.
Tel. (+44) 121-440-3179
Fax. (+44) 121-440-3809