 RE: [Info-ingres] what looks like iidbdb problems -
09-12-2005
, 09:37 AM
Hi Sam -
I have actually had the same problem on Ingres II 2.0/0001
(rs4.us5/00) patch 9181.
Sometimes you can get lucky and modify the table to rebuild the
indices. If the modify runs without errors and you can do a select
count(*) from the table without it reporting errors in the errlog.log -
you are good.
Sometimes that doesn't work. You can try copying the data out of the
table, truncating the table and copying the data back in. Do the select
count(*) again to look for errors.
We have also used verifydb to "fix" this problem. I would talk to CA
first before doing this because you will probably lose data.
I run an unloaddb every Sunday morning after some maintenance jobs
run on the database, just to make sure that the BAD_FILE_PAGE_ADDR isn't
there.
I have applied patch 9599 since these problems occurred.
Teisha Winkler
EDS - Lordstown
( Phone:+1-330-824-5711 )
________________________________
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of Sam Haidar
Sent: Monday, September 12, 2005 9:56 AM
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] what looks like iidbdb problems
Hi there,
we are running an ERP application using IngresII 2.0. As a
result of a routine job, the error.log reported the error below.
0000045c Sat Sep 10 01:41:41 2005
E_DM93A7_BAD_FILE_PAGE_ADDR Page 16564 in table ttdinv150001,
owner: mk, database: mk, has an incorrect page number: 1790. Other page
fields: page_stat 00000032, page_log_address (43217A70,1BEE6BFC),
page_tran_id (0000432143259A6C). Corrupted page cannot be read into the
server cache.
But that routine job finished fine according to the application.
The next day, after restarting the database services, As soon as I touch
the database using a database SQL session, I get the messages below.
Some times it points to $ingres.iiqrytext and $ingres.iitree.
MKDBS ::[II\INGRES\8d0 , 000008c8]: Sun Sep 11 09:48:37 2005
E_US0014 Database not available at this time.
o The database may be marked inoperable. This can occur if
CREATEDB failed.
o An exclusive database lock may be held by another
session.
o The database may be open by an exclusive (/SOLE) DBMS
server.
MKDBS ::[II\INGRES\8d0 , 000008c8]: Sun Sep 11 09:48:37 2005
E_SC0123_SESSION_INITIATE Error initiating session.
000008c4 Sun Sep 11 09:49:54 2005
E_DM00AA_BAD_ATT_KEY_COUNT Incorrect count of key attributes for
table $ingres.iixdbdepends database mk:
relkeys: 5 num keys found 0 last key num 28822.
000008c4 Sun Sep 11 09:49:54 2005
E_DM9C59_DM2T_READ_TCB Error occurred reading system catalog
information during initialization of a Table Control Block.
000008c4 Sun Sep 11 09:49:54 2005
E_DM9C8B_DM2T_TBL_INFO An error occurred while attempting to
build the Table Control Block for table (24,0) in database mk.
000008c4 Sun Sep 11 09:49:54 2005
E_DM9C89_DM2T_BUILD_TCB An error occurred while building a Table
Control Block for a table.
000008c4 Sun Sep 11 09:49:54 2005
E_DM9C8A_DM2T_FIX_TCB An error occurred while trying to locate
and/or build the Table Control Block for a table.
000008c4 Sun Sep 11 09:49:54 2005
E_RD0060_DMT_SHOW Cannot access table information due to a
non-recoverable DMT_SHOW error
000008c4 Sun Sep 11 09:49:54 2005
E_DM010B_ERROR_SHOWING_TABLE An error occurred while showing
information about a table.
MKDBS ::[II\INGRES\8d0 , 000008c4]: Sun Sep 11 09:49:54 2005
E_RD0060_DMT_SHOW Cannot access table information due to a
non-recoverable DMT_SHOW error
But when I touch the database using an application session, I
get the messages below.
00000990 Sun Sep 11 14:20:19 2005
E_DM00AA_BAD_ATT_KEY_COUNT Incorrect count of key attributes for
table mk.tccom0200012amk database mk:
relkeys: 2 num keys found 0 last key num 28822.
00000990 Sun Sep 11 14:20:19 2005
E_DM9C59_DM2T_READ_TCB Error occurred reading system catalog
information during initialization of a Table Control Block.
00000990 Sun Sep 11 14:20:19 2005
E_DM9C8B_DM2T_TBL_INFO An error occurred while attempting to
build the Table Control Block for table (62126,0) in database mk.
00000990 Sun Sep 11 14:20:19 2005
E_DM9C89_DM2T_BUILD_TCB An error occurred while building a Table
Control Block for a table.
00000990 Sun Sep 11 14:20:19 2005
E_DM9C8A_DM2T_FIX_TCB An error occurred while trying to locate
and/or build the Table Control Block for a table.
Any help or advise is greatly appreciated. Thank you.
Sam Haidar
Sr. Business Application Developer
WEIR Valves & Controls USA, Inc.
285 Canal Street
Salem, MA 01970
Phone: 1- 978 - 825 - 2529
Fax: 1- 978 - 745 - 0576
The information contained in this email (including any
attachments) is confidential, subject to copyright and for the use of
the intended recipient only. If you are not the intended recipient
please delete this message after notifying the sender. Unauthorized
retention, alteration or distribution of this email is forbidden and may
be actionable.
Attachments are opened at your own risk and you are advised to
scan incoming email for viruses before opening any attached files. We
give no guarantee that any communication is virus-free and accept no
responsibility for virus contamination or other system loss or damage of
any kind.
The information contained in this email (including any
attachments) is confidential, subject to copyright and for the use of
the intended recipient only. If you are not the intended recipient
please delete this message after notifying the sender. Unauthorized
retention, alteration or distribution of this email is forbidden and may
be actionable.
Attachments are opened at your own risk and you are advised to
scan incoming email for viruses before opening any attached files. We
give no guarantee that any communication is virus-free and accept no
responsibility for virus contamination or other system loss or damage of
any kind.
 |
Linear Mode
