-- Fail Consistency Check -- challoc:bad chunk free list page -- ?
Posted in 1997
Topics: Storage & Space Management, Logging & Checkpoints, Migration, Import/Export & Data Conversion
Hi anybody:
We got problem with Online version 5.01 running under hpux 9.04.
What we have done before are:
1. tbunload the "xyz" database into tape, it works successfully;
2. tbload the "xyz" database (from that tape) as "abc", during loading
suddenly the online stopped and can't be turn on to Online mode. Even
tbinit fails to initialize the shares, the error message is "tbinit:
fatal error in share memory initialization".
Does anyone have experience with this problem and how to recover it?
Best regards,
Yohanes Liauw/Eko Siswanto
Attached is part of online.log when the problem occurs.
Fri Jul 11 22:51:18 1997
22:51:18 INFORMIX-OnLine Initialized -- Shared Memory Initialized
22:51:18 Physical Recovery Started
22:51:18 Checkpoint Completed
22:51:18 Physical Recovery Complete: 0 Pages Restored
22:51:19 Checkpoint Completed
22:51:19 Logical Recovery Complete 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
22:51:24 On-Line Mode
22:53:33 Checkpoint Completed
...
23:52:22 Checkpoint Completed
23:59:34 ERROR: page cleaner # 1 has timed out
Sat Jul 12 00:00:00 1997
00:00:00 Checkpoint Completed
00:07:04 ERROR: page cleaner # 0 has timed out
00:07:27 Checkpoint Completed
00:14:37 Checkpoint Completed
00:22:13 Checkpoint Completed
00:29:38 Checkpoint Completed
00:32:39 bfcheck: bad page: pg_addr 125512 != bp->bf_pagenum 400002,
userp = c001a2f0, pid = 584, uid = 201
00:32:39 buffer header:
00:32:39 c053c284: 00000000 00000000 00000000 00000001 ........
........
00:32:39 c053c294: 00000000 00000000 c04c3888 c0181540 ........
.L8....@
00:32:39 c053c2a4: c00184e8 c053c6f8 00020000 010a0000 .....S..
........
00:32:39 c053c2b4: 00400002 c3556000 c001a2f0 00000000 .@...U`.
........
00:32:39 c053c2c4: 00000000 c06961d8 04000000 .....ia. ....
00:32:39 page header:
00:32:39 c3556000: 00125512 1bdce9ca 00070001 07c70019 ..U.....
........
00:32:39 c3556010: 00000000 00000000 ........
00:32:39 slot table and stamp:
00:32:39 c35567fc: 1bdce9ca ....
00:32:39 -- Fail Consistency Check -- challoc:bad chunk free list page
-- pid=584 user=201 us=c001a2f0
00:32:39 bfcheck: bad page: pg_addr 2dc6c2 != bp->bf_pagenum 500002,
userp = c001a2f0, pid = 584, uid = 201
00:32:39 buffer header:
00:32:39 c053ab5c: 00000000 00000000 00000000 00000000 ........
........
00:32:39 c053ab6c: 00000000 00000001 c053c284 c0181540 ........
.S.....@
00:32:39 c053ab7c: c0018580 c053afd0 00020000 010c0000 .....S..
........
00:32:39 c053ab8c: 00500002 c352f000 c001a2f0 00000000 .P...R..
........
00:32:39 c053ab9c: 00000000 c0695f68 04000000 .....i_h ....
00:32:39 page header:
00:32:39 c352f000: 002dc6c2 1ca7d209 00090001 071700c1 .-......
........
00:32:39 c352f010: 00000000 00000000 ........
00:32:39 slot table and stamp:
00:32:39 c352f7fc: 1ca7d209 ....
00:32:39 -- Fail Consistency Check -- challoc:bad chunk free list page
-- pid=584 user=201 us=c001a2f0
00:32:39 bfcheck: bad page: pg_addr 125512 != bp->bf_pagenum 400002,
userp = c001a2f0, pid = 584, uid = 201
00:32:39 buffer header:
00:32:39 c053c284: 00000000 00000000 00000000 00000001 ........
........
00:32:39 c053c294: 00000000 00000000 c04c3888 c053ab5c ........
.L8..S.\\
00:32:39 c053c2a4: c053c238 c00184e8 00020000 020a0000 .S.8....
........
00:32:39 c053c2b4: 00400002 c3556000 c001a2f0 00000000 .@...U`.
........
00:32:39 c053c2c4: 00000000 c06961d8 04000000 .....ia. ....
00:32:39 page header:
00:32:39 c3556000: 00125512 1bdce9ca 00070001 07c70019 ..U.....
........
00:32:39 c3556010: 00000000 00000000 ........
00:32:39 slot table and stamp:
00:32:39 c35567fc: 1bdce9ca ....
00:32:39 -- Fail Consistency Check -- challoc:bad chunk free list page
-- pid=584 user=201 us=c001a2f0
00:32:39 bfcheck: bad page: pg_addr 2dc6c2 != bp->bf_pagenum 500002,
userp = c001a2f0, pid = 584, uid = 201
00:32:39 buffer header:
00:32:39 c053ab5c: 00000000 00000000 00000000 00000000 ........
........
00:32:39 c053ab6c: 00000000 00000001 c053c284 c0181540 ........
.S.....@
00:32:39 c053ab7c: c053a69c c04c30d0 00020000 020c0000 .S...L0.
........
00:32:39 c053ab8c: 00500002 c352f000 c001a2f0 00000000 .P...R..
........
00:32:39 c053ab9c: 00000000 c0695f68 04000000 .....i_h ....
00:32:39 page header:
00:32:39 c352f000: 002dc6c2 1ca7d209 00090001 071700c1 .-......
........
00:32:39 c352f010: 00000000 00000000 ........
00:32:39 slot table and stamp:
00:32:39 c352f7fc: 1ca7d209 ....
00:32:39 -- Fail Consistency Check -- challoc:bad chunk free list page
-- No dump for pid 584, uid 201. Already took 4.
00:32:39 c355d800: 003d7750 1cf51795 00090001 065007c0 .=wP....
.....P..
00:32:39 c355d810: 00000000 00000000 ........
00:32:39 ERROR: logread() - loguniq 4452 logpos 0x156264
00:32:39 INFORMIX-OnLine Must ABORT Log Error 'logread:bad log page'
us 0xc001a2f0 pid 584 us_flags 0x121
tx 0xc001b720 tx_flags 0x82403 tx_loguniq 4452 tx_logpos 0x156264
00:32:39 INFORMIX-OnLine entering ABORT mode!!!
00:32:39 -- Online Aborting -- us=c001a120, pid=190, uid=0
00:32:39 -- Online Aborting -- us=c001a2f0, pid=584, uid=201
00:32:45 INFORMIX-OnLine Stopped