From: | Brian Neu <proclivity76(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief |
Date: | 2010-11-03 19:50:33 |
Message-ID: | 210687.55558.qm@web51903.mail.re2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'll keep it simple: Postgres hates me, see below. Thanks.
# rpm -q postgresql; uname -a
postgresql-8.4.5-1.fc13.x86_64
Linux hostname 2.6.36-1.fc13.x86_64 #1 SMP Tue Nov 2 23:39:09 EDT 2010 x86_64
x86_64 x86_64 GNU/Linux
# service postgresql start
Starting postgresql service: [ OK ]
# ps aux |grep post
root 14926 0.0 0.0 103204 800 pts/7 S+ 14:56 0:00 grep post
# tail -n3 /var/lib/pgsql/data/pg_log/postgresql-Wed.log
PANIC: could not open file "pg_xlog/000000010000000100000023" (log file 1,
segment 35): Invalid argument
LOG: startup process (PID 14922) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
# su -l postgres -c "pg_resetxlog -f /var/lib/pgsql/data"
Transaction log reset
# service postgresql start
Starting postgresql service: [ OK ]
# ps aux |grep post
root 14926 0.0 0.0 103204 800 pts/7 S+ 14:56 0:00 grep post
# tail -n3 /var/lib/pgsql/data/pg_log/postgresql-Wed.log
PANIC: could not open file "pg_xlog/000000010000000100000024" (log file 1,
segment 36): Invalid argument
LOG: startup process (PID 16536) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
# tail -n4 /var/log/messages
Nov 3 15:43:08 hq2 abrt[16537]: saved core dump of pid 16536
(/usr/bin/postgres) to /var/spool/abrt/ccpp-1288813387-16536.new/coredump
(30986240 bytes)
Nov 3 15:43:08 hq2 abrtd: Directory 'ccpp-1288813387-16536' creation detected
Nov 3 15:43:08 hq2 abrtd: Crash is in database already (dup of
/var/spool/abrt/ccpp-1288794001-5932)
Nov 3 15:43:08 hq2 abrtd: Deleting crash ccpp-1288813387-16536 (dup of
ccpp-1288794001-5932), sending dbus signal
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-03 20:05:57 | Re: PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief |
Previous Message | Chris Browne | 2010-11-02 14:34:01 | Re: How to mark a transaction as SERIALIZABLE? |