Cannot Add Index (-212) & (-105)
We were running our End of Month and one of the EOM thread failed with
error "Cannot Add Index (-212) & (-105). In the informix log has the
following error details :-
17:13:44 Maximum server connections 7
17:13:49 Assert Failed: Page Check Error in next_scan:bad data page
17:13:49 IBM Informix Dynamic Server Version 10.00.FC5
17:13:49 Who: Session(669, ymulla@prime2_endofday.cbq.com.qa, 1256,
29f571a68)
Thread(921, xchg_3.0, 29f53d7c0, 1)
File: rsdebug.c Line: 1056
17:13:49 Results: Possible inconsistencies in'prime20:"ymulla".tpaymentalloc'
17:13:49 Action: Run 'oncheck -cD 159383595'
17:13:49 stack trace for pid 2856 written to /export/home/informix/
tmp/af.781131c
17:13:49 See Also: /export/home/informix/tmp/af.781131c
17:13:54 Page Check Error in next_scan:bad data page
17:19:07 Fuzzy Checkpoint Completed: duration was 22 seconds, 12112buffers not flushed.
17:19:07 Checkpoint loguniq 8437, logpos 0x17cb0c0, timestamp:0x8c4f39bd
17:19:07 Maximum server connections 7
Our Informix version is IBM Informix Dynamic Server Version 10.00.FC5
and we are running on a Sun V890 Server with 16GB RAM. The database
size is around 500GB with around 150 DBSpaces.
Can this be due to insufficent Temporary DB Spaces. ( Below are
details of the onconfig and onstat -d Output ).
Please advise why this error appears. We also had similar error
"Cannot add index (-212)" when running our customer statements
generation.
If we are running out our temporary DBSpace how do I track it. Do we
have any logs to check if it had run out of spaces.
Dhaya
IBM Informix Dynamic Server Version 10.00.FC5 -- On-Line -- Up
13:38:43 -- 8130560 Kbytes
Configuration File: /export/home/informix/etc/onconfig.primelive
#**************************************************************************
## Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2005 All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace nameROOTPATH /dev/informix/rootdbs.d01
# Path for device containing root
dbspace
ROOTOFFSET 50 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 1000000 # 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 200000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 170 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL,
CONT)
# Tablespace Tablespace Configuration in Root Dbspace
TBLTBLFIRST 0 # First extent size (Kbytes) (0 =
default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 =
default)
# Security
# DBCREATE_PERMISSION:
# By default any user can create a database. Uncomment
DBCREATE_PERMISSON to
# limit database creation to a specific user. Add a new
DBCREATE_PERMISSION
# line for each permitted user.
#DBCREATE_PERMISSION informix
# DB_LIBRARY_PATH:
# When loading a (C or C++) shared object (for a UDR or UDT), IDS
checks that
# the user-specified path starts with one of the directory prefixes
listed in
# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string
# "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order
for
# extensibility and IBM supplied blades to work correctly.
# DB_LIBRARY_PATH $INFORMIXDIR/extend
# IFX_EXTEND_ROLE:
# 0 (or off) => Disable use of EXTEND role to control who can register
# external routines.
# 1 (or on) => Enable use of EXTEND role to control who can register
# external routines. This is the default behaviour.
#
IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role.
# Diagnostics
MSGPATH /export/home/informix/online.log # System message log
file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM /export/home/informix/etc/alarmprogram.sh # Alarm
program path
ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any eventoccur
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
#TAPEDEV /backup/Level0 # Tape device path
TAPEDEV /dev/rmt/0 # Tape device path#TAPEDEV /dev/null # Tape device path
TAPEBLK 256 # Tape block size (Kbytes)
TAPESIZE 100000000 # Maximum amount of data to put on
tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log
tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging
area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLineinstance
DBSERVERNAME primesun_live # Name of default database server
DBSERVERALIASES primesun_livetcp # List of alternate dbservernames
NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) fornettype
NETTYPE tlitcp,1,200,NET # Configure poll thread(s) fornettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one
NOAGE 0 # Process aging
AFF_SPROC 2 # Affinity start processor
AFF_NPROCS 4 # Affinity number of processors
# Shared Memory Parameters
LOCKS 800000 # Maximum number of locks
NUMAIOVPS 10 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 10 # Number of buffer cleaner processes
SHMBASE 0x10a000000 # Shared memory base address
SHMVIRTSIZE 1500000 # initial virtual shared memorysegment size
SHMADD 100000