Exception MT_EX_OS ??

> > Error in the logfile: > > 09:59:34 Assert Failed: No Exception Handler > 09:59:34 Informix Dynamic Server Version 7.31.UC4 > 09:59:34 Who: Session(2, informix@, 0, 0) > Thread(8, soctcppoll, 0, 1) > File: mtex.c Line: 446 > 09:59:34 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 09:59:34 Action: Please notify Informix Technical Support. > 09:59:47 See Also: /tmp/af.3f04176, shmem.3f04176.0 Are you using DNS ? Can you, please, send us your sqlhosts file ? > 09:59:49 mtex.c, line 446, thread 8, proc id 31658, No Exception > Handler. > NETTYPE soctcp,,100, # Configure poll thread(s) for nettype Try to remove poll thread to the NET vp. This might help in this case. > 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 Also, if you are not adding CPU vp's dynamically, set SINGLE_CPU_VP to 1. This will force OnLine to do not use code related to the multiprocessor part - probably this can help too. Anyway, you'll get some performance increase. It would be nice, if you'll send your af.3f04176 file to us for more analysis. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285

Hi, After migration of the IDS Server from 7.23.UC1 to 7.31.UC4 we get an Exception MT_EX_OS about twice a day. Any hint is welcome. TIA Helmut Error in the logfile: 09:59:34 Assert Failed: No Exception Handler 09:59:34 Informix Dynamic Server Version 7.31.UC4 09:59:34 Who: Session(2, informix@, 0, 0) Thread(8, soctcppoll, 0, 1) File: mtex.c Line: 446 09:59:34 Results: Exception Caught. Type: MT_EX_OS, Context: mem 09:59:34 Action: Please notify Informix Technical Support. 09:59:47 See Also: /tmp/af.3f04176, shmem.3f04176.0 09:59:49 mtex.c, line 446, thread 8, proc id 31658, No Exception Handler. 09:59:49 PANIC: Attempting to bring system down onconfig: #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/ROOTDB # Path for device containing rootdbspace ROOTOFFSET 4 # Offset of root dbspace into device (Kbytes) ROOTSIZE 516092 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 10000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 30 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr/informix/online.log # System message log file path CONSOLE /dev/console # System console message pathALARMPROGRAM /usr/informix/log_full.sh # Alarm program path # System Archive Tape Device TAPEDEV /dev/rmt0 # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 12000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt1 # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 12000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLineinstance DBSERVERNAME herbios_on # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE soctcp,,100, # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 40000 # Maximum number of locks BUFFERS 2000 # Maximum number of shared buffers NUMAIOVPS # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 32 # Maximum number of logical log files CLEANERS 1 # Number of buffer cleaner processes SHMBASE 0x30000000 # Shared memory base address SHMVIRTSIZE 8000 # initial virtual shared memory segmentsize SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water markpercentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. # To determine the page size used by OnLine on your platform # see the last line of output from the command, 'onstat -b'. # Recovery Variables # OFF_RECVRY_THREADS: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline workerthreads ON_RECVRY_THREADS 1 # Default number of online workerthreads # Data Replication Variables # DRAUTO: 0 manual, 1 retain type, 2 reverse type DRAUTO 0 # DR automatic switchover DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec)DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path # CDR Variables CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes) CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional) CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes) # Backup/Restore variables BAR_ACT_LOG /tmp/bar_act.log BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 # Read Ahead Variables RA_PAGES # Number of pages to attempt to readahead RA_THRESHOLD # Number of pages left before next group # DBSPACETEMP: # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that the OnLine SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the OnLine system is brought online. If not specified, or if # all dbspaces specified are invalid, various ad hoc queries will create # temporary files in /tmp instead. DBSPACETEMP iostempdbs # Default temp dbspaces # DUMP*: # The following parameters control the type of diagnostics information which # is p

Yuri Dovgart wrote: > > > > Error in the logfile: > > > > 09:59:34 Assert Failed: No Exception Handler > > 09:59:34 Informix Dynamic Server Version 7.31.UC4 > > 09:59:34 Who: Session(2, informix@, 0, 0) > > Thread(8, soctcppoll, 0, 1) > > File: mtex.c Line: 446 > > 09:59:34 Results: Exception Caught. Type: MT_EX_OS, Context: mem > > 09:59:34 Action: Please notify Informix Technical Support. > > 09:59:47 See Also: /tmp/af.3f04176, shmem.3f04176.0> > Are you using DNS ? Can you, please, send us your sqlhosts file ? > > > 09:59:49 mtex.c, line 446, thread 8, proc id 31658, No Exception > > Handler.> > > NETTYPE soctcp,,100, # Configure poll thread(s) for nettype> > Try to remove poll thread to the NET vp. This might help in this case. > > > 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> > Also, if you are not adding CPU vp's dynamically, set SINGLE_CPU_VP to 1. > This will force OnLine to do not use code related to the multiprocessor > part - probably this can help too. Anyway, you'll get some performance > increase. > > It would be nice, if you'll send your af.3f04176 file to us for more > analysis. > > -- > ------------------------------------------------- > With best regards, Yuri Dovgart > SAP R/3, Informix technical consultant, > Informix Certified Professional, > Senior System Consultant > System Architecture and High Availability Systems, > 'Telecominvest' company > Email y_dovgart@tci.ukrtel.net > ICQ 39284285 Additional infos: DNS is not used. sqlhosts: # demo_on onipcshm on_hostname on_servername # demo_se seipcpip se_hostname sqlexec herbios_on onsoctcp herberts_ios on_herbios herberts_on onsoctcp herberts on_herbios synthios_on onsoctcp Moritz on_synthios Unfortunately the customer has deleted the af.xxxxx file. I will post as soon as we get a new one (if the problem should not be solved by then). Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.

Helmut Leininger wrote: > > Hi, > > After migration of the IDS Server from 7.23.UC1 to 7.31.UC4 we get an > Exception MT_EX_OS about twice a day. > > Any hint is welcome. > > TIA > Helmut > > Error in the logfile: What are the previous 6 or 8 lines? There may be a hint about what the engine was doing. OOOOH! I just noticed this is BUG# 113804 a crash caused by running dbschema! See if you can get anyone to verify if someone was using dbschema at the time of the crashes. The fix to this bug is in IDS 7.31UC5 which was just released last week. Meanwhile get my myshema.ec utility which does not seem to trigger the bug the way that dbschema does. Myschema is contained in the package utils2_ak in the IIUG Software Repository. It has some nice features beyond what dbschema provides and does everything that dbschema does except print out data distributions (I'll decode those suckers someday). > 09:59:34 Assert Failed: No Exception Handler > 09:59:34 Informix Dynamic Server Version 7.31.UC4 > 09:59:34 Who: Session(2, informix@, 0, 0) > Thread(8, soctcppoll, 0, 1) > File: mtex.c Line: 446 > 09:59:34 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 09:59:34 Action: Please notify Informix Technical Support. > 09:59:47 See Also: /tmp/af.3f04176, shmem.3f04176.0 > 09:59:49 mtex.c, line 446, thread 8, proc id 31658, No Exception > Handler. > 09:59:49 PANIC: Attempting to bring system down> > onconfig: [SNIP] > SHMBASE 0x30000000 # Shared memory base address [SNIP]Is this the correct SHMBASE for your platform? Check the release notes it looks rather odd to me, but you did not post platform info so who knows? Art S. Kagel