PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief

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

Responses

Browse pgsql-novice by date

  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?