OnLine 5.00 database corruption
Posted in 1993
We just experienced inconsistencies in OnLine 5.00 databases on two
different ports. It started with log messages "bfcheck: bad page ..."
just two days after installation. Finally (after a week or so) the
database was completely unusable and had to be re-built from scratch.
The problem has been forwarded to technical support - but the weekend
has just begun here in Germany.
We really consider this as a serious situation. Any help would be
greatly appreciated.
Details follow.
Environment:
INFORMIX-OnLine 5.00.UC2 PRODUCT RELEASE, DATE: 02/04/93
PORT NUMBER: 001103, UnixWare SVR4.2 (running on USL SVR4.2)
INFORMIX-OnLine 5.00.UD4 PRODUCT RELEASE, DATE: 07/06/93
PORT NUMBER: 100051, Olivetti LSX5040, SVR4.0 MP
The first lines of these messages always start with "bfcheck: bad
page: pg_flags 0 != type 2".
15:51:06 bfcheck: bad page: pg_flags 0 != type 2, userp = 101bf4, pid = 7257, uid = 203
15:51:06 buffer header:
15:51:06 187c98: 00000000 00000000 f8ca1700 f8ca1700 ........ ........
15:51:06 187ca8: 948f1800 58021000 03000000 e9050000 ....X... ........
15:51:06 187cb8: 2d011000 00702300 00000000 00000000 -....p#. ........
15:51:06 187cc8: 01000000 08161a00 00010000 ........ ....
15:51:06 page header:
15:51:06 237000: 2d011000 52890000 00000000 1800e407 -...R... ........
15:51:06 237010: 00000000 00000000 ........
15:51:06 slot table and stamp:
15:51:06 2377fc: 52890000 R...
15:51:06 tblspace header error:
15:51:06 15a4d0: 00000000 00000000 00000000 01000000 ........ ........
15:51:06 15a4e0: 20010001 2d011000 00000000 00000000 ...-... ........
15:51:06 15a4f0: 00000000 00000000 00000000 00000000 ........ ........
15:51:06 15a500: 00000000 00000000 00000000 00000000 ........ ........
15:51:06 15a510: 00000000 00000000 00000000 00000000 ........ ........
15:51:06 15a520: 00000000 00000000 00000000 00000000 ........ ........
15:51:07 15a530: 00000000 03000001 02000a00 68000000 ........ ....h...
15:51:07 15a540: 02000400 d4cfe82c 6f010000 08000000 ......., o.......
15:51:07 15a550: 08000000 20000000 1d000000 11000000 .... ... ........
15:51:07 15a560: ffffffff 68750000 21010000 00000000 ....hu.. !.......
15:51:07 15a570: 561f1000 08000000 3e211000 10000000 V....... >!......
15:51:07 15a580: 96241000 18000000 de261000 20000000 .$...... .&.. ...
15:51:07 15a590: 00000000 00000000 00000000 00000000 ........ ........
15:51:07 15a5a0: 00000000 00000000 00000000 20000000 ........ .... ...
15:51:07 15a5b0: 00000000 00000000 00000000 00000000 ........ ........
15:51:07 15a5c0: d8971700 53890000 00000000 78a71700 ....S... ....x...
15:51:07 -- WARNING: Fail Consistency Check -- pthdrpage:ptalloc:bad partn page --
pid=7257 user=203 us=101bf4
RSAM Version 5.00.UC2 -- On-Line -- Up 02:52:45 -- 5168 Kbytes
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace nameROOTPATH /dev/online/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 200000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing root dbspace mirror
MIRROROFFSET 0 # Offset into mirror device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Name of dbspace that contains physical log
PHYSFILE 2000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 10 # Number of logical log files
LOGSIZE 1000 # Size of each logical log file (Kbytes)
# Message Files
MSGPATH /opt/informix-5.00/online.log # OnLine message log pathname
CONSOLE /dev/sysmsg # System console message pathname
# Identification Parameters
SERVERNUM 0 # Unique id associated with this OnLine instance
DBSERVERNAME ONLINE # Unique name of this OnLine instance
# Shared Memory Parameters
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)USERS 50 # Maximum number of concurrent user processes
TRANSACTIONS 50 # Maximum number of concurrent transactions
LOCKS 10000 # Maximum number of locks
BUFFERS 2000 # Maximum number of shared memory buffersTBLSPACES 500 # Maximum number of active tblspaces
CHUNKS 8 # Maximum number of chunks
DBSPACES 8 # Maximum number of dbspaces and blobspaces
PHYSBUFF 32 # Size of physical log buffers (Kbytes)
LOGBUFF 32 # Size of logical log buffers (Kbytes)LOGSMAX 10 # Maximum number of logical log files
CLEANERS 1 # Number of page-cleaner processes
SHMBASE 0x100000 # Shared memory base address
CKPTINTVL 300 # Checkpoint interval (in seconds)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent)
LTXHWM 80 # Long TX high-water mark (percent)
LTXEHWM 90 # Long TX exclusive high-water mark (percent)
# Machine- and Product-Specific Parameters
DYNSHMSZ 0 # Dynamic shared memory size (Kbytes)
GTRID_CMP_SZ 32 # Number of bytes to use in GTRID comparision
DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env.
TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)SPINCNT 0 # No. of times process tries for latch
STAGEBLOB # Reserved for INFORMIX-OnLine/Optical
# System Page Size
BUFFSIZE 2048 # Page size (do not change!)
--
Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090
Rebenring 33 Fax +49 531 2380935
oliver@infix.de 38106 Braunschweig F.R. Germany