[Info-ingres] B-Tree corrupt

[pwhite peercore]

Hi Richard,

 

It’s a good idea to log a support call to Actian. It will be helpful to know
the answers to these questions:

 

Errors in usermod log?

Any sudden outages in that period? 

Have you reviewed errlog.log?

Review dmfrcp.log for information about automatic recovery after sudden
outage.

Does the table have compression enabled?

MVC enabled for the database?

 

Suggest run auditdb DBNAME –table=XXXXX.  Look for inserts/updates hitting
this range of values.

Do you still have a copy of the checkpoint and journals for the period
before the maintenance and after the corruption?

You will be able to extract a copy of the table and indexes for review.

Hopefully all tables are journaled.

 

Paul

 

&
Shift Seven Solutions
www.shift7solutions.com.au

 

 

 

From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Zinndorf,
Richard
Sent: Tuesday, 6 March 2018 8:30 PM
To: Info-ingres at lists.planetingres.org
Subject: [Info-ingres] B-Tree corrupt

 

Hello, 

 

a customer had the following problem with II 10.2.0 (a64.lnx/100) 15031:

 

“the table xxxxxx seems to have been corrupted (especially the btree on
field group_code) 


data could be retrieved  with following query 
  select * from xxxxxx  where  group_code >  5093690 

but it was not possible to access them directly with the individual values

 
        select * from  xxxxxx  where  group_code =  5093691 
or    select * from  xxxxxx  where  group_code =  5093692 

For those  which were before group-code 5093691   the following query was
working  fine 

         select * from  xxxxxx  where  group_code =  5093690 

After recreation of the table with  copydb the application is working fine
again .. ”

 

The problem occurred last Monday. The day before the following maintenance
tasks had been performed:

usermod db

optimizedb -zk -uuser db

sysmod db

 

Does anyone have an idea how it is possible and how to  avoid such issue?

I would be grateful for any hint..

 

Mit freundlichen Grüßen / Regards

RICHARD ZINNDORF
DXC Technology

Neustadter Str. 62, 68309 Mannheim, Germany
Enhanced Technical Support MSS | p: +49.621.7001.0635 | f: +49.621.7001.6262
| m: +49.173.340.2127 |  <mailto:rzinndorf at csc.com> rzinndorf at csc.com |
www.csc.com/de 

Twitter <http://twitter.com/CSC_DE>  | Slideshare
<http://www.slideshare.net/CSCDeutschland>  

CSC • This is a PRIVATE message. If you are not the intended recipient,
please delete without copying and kindly advise us by e-mail of the mistake
in delivery.  NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose • CSC Deutschland GmbH • Registered Office:
Abraham-Lincoln-Park 1, 65189 Wiesbaden, Germany • Board of Directors: Claus
Schünemann (Chairman), Josef Ranner • Chairman of the Supervisory Board:
William L. Deckelman • Registered in Germany: HRB 11307

 

 


CSC Deutschland GmbH - Registered Office: Hewlett-Packard-Str. 1, 61352 Bad
Homburg, Germany - Board of Directors: Claus Schunemann (Chairman), Josef
Ranner - Chairman of the Supervisory Board: William L. Deckelman -
Registered in Wiesbaden: HRB 11307 
DXC Technology Company -- This message is transmitted to you by or on behalf
of DXC Technology Company or one of its affiliates. It is intended
exclusively for the addressee. The substance of this message, along with any
attachments, may contain proprietary, confidential or privileged information
or information that is otherwise legally exempt from disclosure. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient of this message, you are not authorized to
read, print, retain, copy or disseminate any part of this message. If you
have received this message in error, please destroy and delete all copies
and notify the sender by return e-mail. Regardless of content, this e-mail
shall not operate to bind DXC Technology Company or any of its affiliates to
any order or other contract unless pursuant to explicit written agreement or
government initiative expressly permitting the use of e-mail for such
purpose. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180307/455e3820/attachment.html>