PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief
От | Brian Neu |
---|---|
Тема | PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief |
Дата | |
Msg-id | 210687.55558.qm@web51903.mail.re2.yahoo.com обсуждение исходный текст |
Ответы |
Re: PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief
|
Список | 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
В списке pgsql-novice по дате отправления: