Bad ISAM file Format
Hi all
Guys this looking bad! My queries are dying out with error BAD ISAM file
format! I read my logs and am getting the following message:
09:52:54 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:54 IBM Informix Dynamic Server Version 10.00.UC4
09:52:54 Who: Session(44, informix@myserver, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:54 Results: Possible inconsistencies in 'mydatabase:"informix".gsftrand'
09:52:54 Action: Run 'oncheck -cD 4194313'
09:52:54 stack trace for pid 6492 written to /home/informix/tmp/af.44a8ac4
09:52:54 See Also: /home/informix/tmp/af.44a8ac4
09:52:56 Page Check Error in mappage:bad bitmap page
09:52:56 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:56 IBM Informix Dynamic Server Version 10.00.UC4
09:52:56 Who: Session(44, informix@server1, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:56 Results: Possible inconsistencies in 'growers:"informix".gsftrand'
09:52:56 Action: Run 'oncheck -cD 4194313'
09:52:56 stack trace for pid 6492 written to /home/informix/tmp/af.44a8ac4
09:52:56 See Also: /home/informix/tmp/af.44a8ac4
09:52:58 Page Check Error in mappage:bad bitmap page
I have run the 'oncheck -cD 4194313' and the server is giving me the following
error message:
...
ERROR: Tablespace 0x400009. Page 0xfbc appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbd appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbe appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbf appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
BAD PAGE 4:248343: Invalid bitmap page 4032: unexpected page type 16
Abandoning checks on this table.
What is my problem!
Please help!!
Paul
Looks like you have crossed chunks somehow. Are the chunks on some network
device that might be shared by a different instance on another machine? IDS
protects you from stepping on chunks within an instance and between instances
on
a single machine since 7.10, but between machines using shared disks, there's
no protection possible.
Art S. Kagel
----- Original Message -----
From: Paul Gathogo <ids@iiug.org>
At: 4/11 3:07:23
Hi all
Guys this looking bad! My queries are dying out with error BAD ISAM file
format! I read my logs and am getting the following message:
09:52:54 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:54 IBM Informix Dynamic Server Version 10.00.UC4
09:52:54 Who: Session(44, informix@myserver, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:54 Results: Possible inconsistencies in 'mydatabase:"informix".gsftrand'
09:52:54 Action: Run 'oncheck -cD 4194313'
09:52:54 stack trace for pid 6492 written to /home/informix/tmp/af.44a8ac4
09:52:54 See Also: /home/informix/tmp/af.44a8ac4
09:52:56 Page Check Error in mappage:bad bitmap page
09:52:56 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:56 IBM Informix Dynamic Server Version 10.00.UC4
09:52:56 Who: Session(44, informix@server1, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:56 Results: Possible inconsistencies in 'growers:"informix".gsftrand'
09:52:56 Action: Run 'oncheck -cD 4194313'
09:52:56 stack trace for pid 6492 written to /home/informix/tmp/af.44a8ac4
09:52:56 See Also: /home/informix/tmp/af.44a8ac4
09:52:58 Page Check Error in mappage:bad bitmap page
I have run the 'oncheck -cD 4194313' and the server is giving me the following
error message:
....
ERROR: Tablespace 0x400009. Page 0xfbc appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbd appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbe appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbf appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
BAD PAGE 4:248343: Invalid bitmap page 4032: unexpected page type 16
Abandoning checks on this table.
What is my problem!
Please help!!
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Paul,
Looks like a corrupt chunk to me. By any chance, could you have
inadvertently configured another INFORIXSERVER (say server2) which is
using part of server1's chunks?
Stuart McCann
Integrated Spatial Services Unit
Information Communication & Technology
Department of Lands, Bathurst
Phone: (02) 63328285
stuart.mccann@lands.nsw.gov.au
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
PAUL GATHOGO
Sent: Wednesday, 11 April 2007 5:07 PM
To: ids@iiug.org
Subject: Bad ISAM file Format [8819]
Hi all
Guys this looking bad! My queries are dying out with error BAD ISAM file
format! I read my logs and am getting the following message:
09:52:54 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:54 IBM Informix Dynamic Server Version 10.00.UC4
09:52:54 Who: Session(44, informix@myserver, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:54 Results: Possible inconsistencies in
'mydatabase:"informix".gsftrand'
09:52:54 Action: Run 'oncheck -cD 4194313'
09:52:54 stack trace for pid 6492 written to
/home/informix/tmp/af.44a8ac4
09:52:54 See Also: /home/informix/tmp/af.44a8ac4
09:52:56 Page Check Error in mappage:bad bitmap page
09:52:56 Assert Failed: Page Check Error in mappage:bad bitmap page
09:52:56 IBM Informix Dynamic Server Version 10.00.UC4
09:52:56 Who: Session(44, informix@server1, 208, 0xa54e9038)
Thread(98, sqlexec, a54c0978, 1)
File: rsdebug.c Line: 1041
09:52:56 Results: Possible inconsistencies in
'growers:"informix".gsftrand'
09:52:56 Action: Run 'oncheck -cD 4194313'
09:52:56 stack trace for pid 6492 written to
/home/informix/tmp/af.44a8ac4
09:52:56 See Also: /home/informix/tmp/af.44a8ac4
09:52:58 Page Check Error in mappage:bad bitmap page
I have run the 'oncheck -cD 4194313' and the server is giving me the
following
error message:
....
ERROR: Tablespace 0x400009. Page 0xfbc appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbd appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbe appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
ERROR: Tablespace 0x400009. Page 0xfbf appears to be of type "btree",
which is out of sync with its bitmap representation (0xc).
BAD PAGE 4:248343: Invalid bitmap page 4032: unexpected page type 16
Abandoning checks on this table.
What is my problem!
Please help!!
Paul
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
***************************************************************
This message is intended for the addressee named and may contain confidential
information. If you are not the intended recipient, please delete it and
notify the sender.
Views expressed in this message are those of the individual sender, and are
not necessarily the views of the Department of Lands.
This email message has been swept by MIMEsweeper for the presence of computer
viruses.
***************************************************************