Assertion Failure at ok
Posted in 1998
07:52:16 Assert Failed: Memory block header corruption detected inmt_shm_mallo c_segid 2 07:52:16 Informix Dynamic Server Version 7.30.UC3
07:52:16 Who: Session(847, informix@, 0, 0) Thread(17, soctcplst, 0, 1)File: mtshpool.c Line: 2455 I am constantly having this problem on my
informmix running on HP-UX 10.2 and once this has happened the database goes
down. and the following error is recorded. ERROR 07:52:16 Results: Pool
repaired 07:52:16 Action: Please notify Informix Technical Support. 07:52:22
Assert Failed: No Exception Handler 07:52:22 Informix Dynamic Server
Version 7.30.UC3 07:52:22 Who: Session(838, informix@, 0, 0) Thread(15,
sm_listen, 0, 3) File: mtex.c Line: 314 07:52:22 Results: Exception Caught.
Type: MT_EX_OS, Context: mem 07:52:22 Action: Please notify InformixTechnical Support. 07:52:22 stack trace for pid 1307 written to
/tmp/af.f0f15 07:52:22 07:52:22 mtex.c, line 314, thread 15, proc id 1307,
No Exception Handler. 07:52:22 PANIC: Attempting to bring system down
08:01:23 Segment locked: addr=0xc39a0000, size=155787264
MY onconfig 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)
# Physical Log Configuration
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 instance
DBSERVERNAME ok_srvr # Name of default database server #DBSERVERALIASESok_tcp # List of alternate dbservernames DBSERVERALIASES ok_tcp,ok_strm #
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,1,100,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 350000 # 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 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 # Longtransaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction
timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) 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
# update $INFORMIXDIR/bin/onbar. Change to
ISM_LOG_POOL ISMLogs
# Read Ahead Variables RA_PAGES 512 # Number of pages to attempt to read
ahead RA_THRESHOLD # Number of pages left before next group DUMPDIR /tmp #
Preserve diagnostics in this directory DUMPSHMEM 0 # Dump a copy of shared
memory DUMPGCORE 0 # Dump a core image using 'gcore' DUMPCORE 0 # Dump a
core image (Warning:this aborts Dynamic Server) DUMPCNT 1 # Number of
shared memory or gcore dumps for # a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for Dynamic Server to use when determining current time USEOSTIME 0
# 0: use internal time(fast), 1: get time from O S(slow)
# 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 DATASKIP off # List of dbspaces to
skip # OPTCOMPIND 0 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAITLBU_PRESERVE 0 # Preserve last log for log backup OPCACHEMAX 0 # Maximum
optical cache size (Kbytes) # # Optimization goal: -1 = ALL_ROWS(Default), 0
= FIRST_ROWS OPT_GOAL -1 Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES 1
# Status of restartable restore
RESTARTABLE_RESTORE off
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own