another pg database corruption?

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: another pg database corruption?
Date: 2003-10-27 17:21:40
Message-ID: 3F9D5424.781E6035@t1.unisoftbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS.
After ~30 days error free work my pg stops.
I my log I found:
PANIC: open of /mnt/diske/skladdb/pg_clog/0D02 failed: No such file or
directory
LOG: statement: COPY public.a_sp (ids, ids_ma, ids_mp, ids_mr, ids_mpr,
ids_mpdt, ids_mpkt, smetkas, smetkaa, smetkad1, smetkad2, tip, vaji,
ime, imeeng, balans, opr, pp, prihrazh_razh, prihrazh_prih, ids_firma)
TO stdout;
LOG: server process (pid 1252) was terminated by signal 6
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and
semaphores
LOG: database system was interrupted at 2003-10-27 14:34:01 EET
LOG: checkpoint record is at 2/1C591C4C
LOG: redo record is at 2/1C591C4C; undo record is at 0/0; shutdown TRUE

LOG: next transaction id: 493496; next oid: 197060600
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: record with zero length at 2/1C591C8C
LOG: redo is not required
LOG: database system is ready
PANIC: open of /mnt/diske/skladdb/pg_clog/09FD failed: No such file or
directory
LOG: statement: COPY public.a_acc (ids, ids_firma, ids_debit,
ids_kredit, date_op, ids_vid_doc, ids_otdel, ids_papka, ids_papka1,
ids_papka2, parv_doc, doc, nomer, val, voborot, kurs, oborotlv, zab1,
zab2, kod1, kod2, kod3, addkod, pp, instime, modtime, ids_slu) TO
stdout;
LOG: server process (pid 1260) was terminated by signal 6
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and
semaphores
LOG: database system was interrupted at 2003-10-27 14:37:10 EET

How can I found the reason for this problem.
Also we try to use pg in production and to replace oracle, but it looks
very unstable with this corruption.
Exist any way to prevent pg from this error (for example real time
backup for changes or realtime replication?).
We are using pg from 3 y. and we was very happy, but in production it
looks not so stable.

many thanks,
ivan.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Boes 2003-10-27 19:51:34 Partial/interrupted VACUUM FULL?
Previous Message Tom Lane 2003-10-27 16:19:06 Re: Visibility of objects in other schema's