Assertion Failure Message
Posted in 1998
I am constantly having problems with my informix ver 7.2 database on HP-UX
10.2 which is constantly hanging and gives the following error message in the
log file. and dumps the file shmem.101c9b.1 in /tmp. After this the whole
system becomes slow and for it to be fast you remove this file but in some
cases the database goes down. I tried to use stream pipes but the database
could not come up. What is the problem?
online .log logs this message. 08:27:26 Process exited with return code 139:
/bin/sh /bin/sh -c /u/informix/et c/log_full.sh 2 23 "Logical Log 2051
Complete." "Logical Log 2051 Complete." 08:27:28 Logical Log 2051 - Backup
Completed 08:28:45 Logical Log 2052 Complete. 08:28:46 Process exited with
return code 139: /bin/sh /bin/sh -c /u/informix/et c/log_full.sh 2 23
"Logical Log 2052 Complete." "Logical Log 2052 Complete." 08:28:49 Logical
Log 2052 - Backup Started 08:28:54 Logical Log 2052 - Backup Completed
08:31:43 Assert Failed: Memory free block header corruption detected inmt_shm_malloc_segid 1 08:31:43 Informix Dynamic Server Version 7.30.UC3
08:31:43 Who: Session(90417, informix@, 0, 0) Thread(17, soctcplst, 0, 1)
File: mtshpool.c Line: 2562 08:31:43 Results: Pool repaired 08:31:43Action: Please notify Informix Technical Support. 08:32:02 Checkpoint
Completed: duration was 32 seconds. 08:32:32 Logical Log 2053 Complete.
08:32:36 Logical Log 2053 - Backup Started 08:32:41 Logical Log 2053 -
Backup Completed 08:34:13 See Also: /tmp/af.11058c, shmem.11058c.11 08:34:13
Error writing '/tmp/shmem.11058c.11' errno = 28 @
my config file is set up as follows.
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/rdsk/c1t12d0 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 500000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)PHYSDBS logsdbs # Location (dbspace) of physical log
PHYSFILE 250000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 32 # Number of logical log files
LOGSIZE 5000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /u/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /u/informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /u/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS 1
# System Archive Tape Device
TAPEDEV /dev/rmt/1m # Tape device path TAPEBLK 1024 # Tape block size(Kbytes) TAPESIZE 12000000 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/rmt/2m # Log tape device path LTAPEBLK 1024 # Log tapeblock size (Kbytes) LTAPESIZE 4000000 # Max amount of data to put on log
tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a Dynamic Server in stance
DBSERVERNAME ok_srvr # Name of default database server DBSERVERALIASESok_tcp # List of alternate dbservernames #DBSERVERALIASES ok_tcp,ok_str #
List of alternate dbservernames NETTYPE ipcshm,2,150,NET # Configure poll
thread(s) for nettype NETTYPE soctcp,2,200,NET # Configure poll thread(s)
for nettype #NETTYPE ipcstr,2,200,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT
1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 forsingle-processor, 1 for multi-processor NUMCPUVPS 2 # Number of user (cpu)
vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 700000 # Maximum number of locks BUFFERS 15000 # Maximum number ofshared buffers NUMAIOVPS # Number of IO vps PHYSBUFF 128 # Physical log
buffer size (Kbytes) LOGBUFF 128 # Logical log buffer size (Kbytes) LOGSMAX
100 # Maximum number of logical log files CLEANERS 8 # Number of buffer
cleaner processes SHMBASE 0x0 # Shared memory base address SHMVIRTSIZE
100000 # initial virtual shared memory segment size SHMADD 40000 # 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 queuesLRUS 8 # Number of LRU queues LRU_MAX_DIRTY 5 #
LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty
end cleaning limit LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c
# Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes)
# System Page Size # BUFFSIZE - Dynamic Server no longer supports this
configuration parameter. # To determine the page size used by Dynamic Server
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 worker threads
ON_RECVRY_THREADS 5 # Default number of online worker threads DRAUTO 0 #DR automatic switchover DRINTERVAL 30 # DR max time between DR buffer
flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND
/u/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 (Kb ytes)
# 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
# Informix Storage Manager variables ISM_DATA_POOL ISMData # If the data
pool name is changed, be sure to # Read Ahead Variables RA_PAGES 512 #
Number of pages to attempt to read ahead RA_THRESHOLD # Number of pages left
before next group # # Parallel Database Queries (pdq) MAX_PDQPRIORITY 100 #
Maximum allowed pdqpriority DS_MAX_QUERIES # Maximum number of decision
support queries DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans DATASKIPoff # List of dbspaces to skip
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
@@