Can't drop table
Posted in 1999
Topics: High Availability & Replication, Error Codes & Troubleshooting
Can anybody help please? There are no disk errors appearing in turbo.log
so this one seems to be software. Unfortunately it looks like the only fix
is a reload of the whole database. bank_tab itself can be easily
recreated, but of course before that I need to get rid of it or rename
it; neither of which I am able to do. Oh, BTW, the following persists
after a shutdown->startup->online cycle of the engine, and tbcheck
shows the same message as below.
SCO 3.2.4.2
Online 4.10.UD2
$ isql -s acs <<!!!
drop table bank_tab!!!
18:52:40 bfcheck: bad page: pg_addr 6f6d6274 != bp->bf_pagenum 200014, userp = 80401ad4, pid = 19265, uid = 229
18:52:40 buffer header:
18:52:40 8045faf8: 00000000 00000000 b47c4580 e80a4680 ........ .|E...F.
18:52:40 8045fb08: 38e84580 78114680 02000000 120e0000 8.E.x.F. ........
18:52:40 8045fb18: 14002000 00e04e80 00000000 00000000 .. ...N. ........
18:52:40 8045fb28: 01000000 b9534680 00010000 .....SF. ....
18:52:40 page header:
18:52:40 804ee000: 74626d6f 64653a20 63616e6e 6f74206b tbmode: cannot k
18:52:40 804ee010: 696c6c20 70696420 ill pid
18:52:40 slot table and stamp:
18:52:40 804ee7fc: f6950b00 ....
18:52:40 partition header error:
18:52:40 80428bd4: 00000000 00000000 00000000 01000000 ........ ........
18:52:40 80428be4: 11000002 14002000 00000000 00000000 ...... . ........
18:52:40 80428bf4: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428c04: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428c14: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428c24: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428c34: 00000000 02000001 02000a00 24000000 ........ ....$...
18:52:40 80428c44: 01000100 ae7a2737 01000000 04000000 .....z'7 ........
18:52:40 80428c54: 04000000 04000000 03000000 01000000 ........ ........
18:52:40 80428c64: 00000000 48000000 02000000 00000000 ....H... ........
18:52:40 80428c74: 128f1200 04000000 00000000 00000000 ........ ........
18:52:40 80428c84: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428c94: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 80428ca4: 00000000 00000000 00000000 04000000 ........ ........
18:52:40 80428cb4: 00000000 00000000 00000000 00000000 ........ ........
18:52:40 -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page -- pid=19265 user=229 us=80401ad4
314: Table (bill.bank_tab) currently in use.
105: ISAM error: bad isam file format.
Stephen Walmsley wrote: > > Can anybody help please? There are no disk errors appearing in turbo.log > so this one seems to be software. Unfortunately it looks like the only fix > is a reload of the whole database. bank_tab itself can be easily > recreated, but of course before that I need to get rid of it or rename > it; neither of which I am able to do. Oh, BTW, the following persists > after a shutdown->startup->online cycle of the engine, and tbcheck > shows the same message as below. 4.10 is an incredibly old. Consider upgrading. Also tech support can drop the table for you. Art S. Kagel