IDS Forum

AW: chunk failed sanity check

Posted By: Model-Bosch, Tilman
Date: Monday, 19 December 2005, at 3:38 p.m.

In Response To: chunk failed sanity check (Alejandro Mtz Mejia)

Dear Alejandro,

It looks as if the power failure physically damaged the data on the
raw device or the raw device is not accessible anymore.

First try to make the raw device accessible again , ensure you can
read it with lets say 'dd' .

When you where succesful reading the device, you might try onspaces
to set the chunk online again.

If there is no real damage to the data, this should work.

If there is damage to the data, you might want to restore , which is not possible
as you said.

You will have to recreate the tables and data in the dbspace then from
an external source - if possible.




-----Urspr|ngliche Nachricht-----
Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] Im Auftrag von Alejandro M....
Gesendet: 16 December 2005 23:32
An: ids@iiug.org
Betreff: chunk failed sanity check [6132]

Hi all!



I have a big problem.



I was create an IDS2000 V 9.21 Intance database 10 days ago over UnixWare
7.1.3 OS. A database dbspace was damage by power failure and

I have no backup.



There is a way to recover the damaged dbspace??





I hope anybody help me!





List errors during database instance starting up:



$ oninit -v



Checking group membership to determine server run modesucceeded

Reading configuration file '/usr/informix/etc/onconfig10'...succeeded

Creating /INFORMIXTMP/.infxdirs ... succeeded

Creating infos file "/usr/informix/etc/.infos.deneb10" ...
"/usr/informix/etc/.c

onf.deneb10" ... succeeded

Writing to infos file ... succeeded

Checking config parameters...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 2272 kbytes...succeeded

Creating buffer pool 16002 kbytes...succeeded

Initializing rhead structure...succeeded

Initializing ASF ...succeeded

Initializing Dictionary Cache and SPL Routine Cache...succeeded

Bringing up ADM VP...succeeded

Creating VP classes...succeeded

Onlining 0 additional cpu vps...succeeded

Onlining 2 IO vps...succeeded

Forking main_loop thread...succeeded

Initializing DR structures...succeeded

Forking 1 'tlitcp' listener threads...succeeded

Starting tracing...succeeded

Initializing 1 flushers...succeeded

Initializing log/checkpoint information...succeeded

Opening primary chunks...Bad Primary Chunk '/bd/RAW/dbspace'.

succeeded

Opening mirror chunks...succeeded

Initializing dbspaces...succeeded

Validating chunks...succeeded

Initialize Async Log Flusher...succeeded

Forking btree cleaner...succeeded

Initializing DBSPACETEMP list

Checking database partition index...succeeded

Checking location of physical log...succeeded

Initializing dataskip structure...succeeded

Checking for temporary tables to drop

Forking onmode_mon thread...succeeded

Verbose output complete: mode = 5





$ onstat -d



Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- Up 00:00:52
-- 3

4812 Kbytes



Dbspaces

address number flags fchunk nchunks flags owner name

b33b7d0 1 0x1 1 1 N informix rootdbs

b37a6f8 2 0x2001 2 1 N T informix dbtemp

b37a840 3 0x1 3 1 N informix dblog

b37a988 4 0x5 4 1 ND informix dbspace

4 active, 2047 maximum



Chunks

address chk/dbs offset size free bpages flags pathname

b33b918 1 1 0 25000 22732 PO- /bd/RAW/rootdbs

b37a2a8 2 2 0 512000 511947 PO- /bd/RAW/dbtemp

b37a418 3 3 0 512000 201947 PO- /bd/RAW/dblog

b37a588 4 4 0 1048575 0 PD- /bd/RAW/dbspace

4 active, 2047 maximum





AMM

Messages In This Thread

• chunk failed sanity check
  Alejandro Mtz Mejia -- Friday, 16 December 2005, at 5:32 p.m.
  • Re: chunk failed sanity check
    Obnoxio The Clown -- Friday, 16 December 2005, at 7:54 p.m.
  • AW: chunk failed sanity check
    Model-Bosch, Tilman -- Monday, 19 December 2005, at 3:38 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.