bad btree node
Posted in 1992
For days nows, we have been getting this same error (always the same userp).
Is there a way to know more/fix this mess, other than dbexporting the entire
database? That is entirely unfeasible since it would keep a production
customer down for days. I'm not even sure which table is broken, but most
of them have a million or more rows.
This problem is occuring on 4.0 Online on a Tandem machine. We would dearly
love to install 4.1, but it is not yet available.
Just on the off chance that someone may know this, has anyone ever heard of
a tbstat, launched by cron, causing this sort of problem? I know, it sounds
ridiculous, but the coincidence is phenomenal. When we turn on a cron script,
to run tbstat's every fifteen minutes, the crap starts. We get pages of
bizarre error messages, which stop immediately when we turn off the script.
Furthermore, for days afterwards, we get btree node errors (as above).
I'm sure we are not hallucinating, but Informix has basically blown us off
with mutterings on how tbstat could not be causing these problems. Ok, then,
how would one explain the amazing coincidence?
thx,
naomi
-----------------------------------------------------------------------------
19:29:44 bfcheck: bad page: pg_flags 4 != type 10, userp = 40401284, pid = 18286, uid = 102
19:29:44 buffer header:
19:29:44 404a63a4: 00000000 00000000 00000000 404a54a4 ........ ....@JT.
19:29:44 404a63b4: 404ad264 404a3fe4 404a4de4 00020000 @J.d@J?. @JM.....
19:29:44 404a63c4: 1a050000 00211420 40512000 40401284 .....!. @Q .@@..
19:29:44 404a63d4: 00000000 00000000 404b3c1c 02000000 ........ @K<.....
19:29:44 page header:
19:29:44 40512000: 00211420 031d306e 00000004 001807e4 .!. ..0n ........
19:29:44 40512010: 00000000 00000000 ........
19:29:44 slot table and stamp:
19:29:44 405127fc: 031d306e ..0n
19:29:44 -- Fail Consistency Check -- btusearch:bad btree node -- pid=18286 user=102 us=40401284
-----------------------------------------------------------------------------
--
Naomi Walker (aka N7FSA)
Anasazi Inc. Phoenix, Arizona 602-395-1731
{uunet!pyramid},{sun!sunburn!gtx!},{asuvax} !anasaz!qip!naomi