bfcheck: bad page
Posted in 1993
Topics: High Availability & Replication, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL
I need suggestions on what to do with a Fail Consistency Check error
This is the message I received
Date: 05/08/93 Time: 10:51:15
Program error at "rec_conj.4gl", line number 768.
SQL statement error number -242.
Could not open database table (sic.auxitem).
SYSTEM error number -105.
ISAM error: bad isam file format.
I know all the consistency failure errors give exactly the same
isam error (as 5.0 admin guide says)
The weird thing here is that sic.auxitem is the name of a temp table
which is created and dropped by the 4gl process.
It'd happened once, 3 months ago but now it's appeared 3 times during
last week.
This is the message in the informix messages log
bfcheck: bad page: pg_flags 0 != type 2, userp = 80401bf4, pid = 11953, uid = 2240
buffer header:
8043b2bc: 00000000 00000000 bc7b4380 bc7b4380 ........ .{C..{C.
8043b2cc: dc034080 3cba4380 02000000 090c0000 ..@.<.C. ........
8043b2dc: 61003000 00f84780 00000000 00000000 a.0...G. ........
8043b2ec: 01000000 c40d4480 00010000 ......D. ....
page header:
8047f800: 61003000 841a3107 00000000 1800e407 a.0...1. ........
8047f810: 00000000 00000000 ........
slot table and stamp:
8047fffc: 841a3107 ..1.
partition header error:
80420df4: 00000000 00000000 00000000 01000000 ........ ........
80420e04: 5e000003 61003000 00000000 00000000 ^...a.0. ........
80420e14: 00000000 00000000 00000000 00000000 ........ ........
80420e24: 00000000 00000000 00000000 00000000 ........ ........
80420e34: 00000000 00000000 00000000 00000000 ........ ........
80420e44: 00000000 00000000 00000000 00000000 ........ ........
80420e54: 00000000 63000003 61090a00 1f010100 ....c... a.......
80420e64: 00000100 ba0e612c 01000000 08000000 ......a, ........
80420e74: 08000000 08000000 00000000 00000000 ........ ........
80420e84: 00000000 00000000 00000000 00000000 ........ ........
80420e94: 77143000 08000000 00000000 00000000 w.0..... ........
80420ea4: 00000000 00000000 00000000 00000000 ........ ........
80420eb4: 00000000 00000000 00000000 00000000 ........ ........
80420ec4: 00000000 00000000 00000000 08000000 ........ ........
80420ed4: 00000000 00000000 00000000 00000000 ........ ........
-- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page -- pid=11953 user=2240 us=80401bf4
Any ideas welcomed.
Please contact me by e-mail, I'm not reading the list by now.
Thanks a lot
ale.
--
Maria Alejandra Perez Weiss alex@lucas.mrec.ar
PNUD - Min. Rel. Exteriores alex%lucas.mrec.ar@uunet.uu.net
Buenos Aires - Argentina ...!uunet!atina!lucas!alex