Could not open file pg_xlog/000000010....

From: Victor <only-victor(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Could not open file pg_xlog/000000010....
Date: 2010-10-12 15:26:10
Message-ID: 1286897170.3266.8.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello, my name is Viktor, I am from Ukraine.

I work under ArchLinux.
I have installed Postgresql 8.4.4 and I can't run it.

Report log:

Oct 12 17:53:25 localhost postgres[26997]: [1748-1] LOG: database
system was shut down at 2010-10-12 17:43:07 EEST
Oct 12 17:53:25 localhost postgres[26997]: [1749-1] DEBUG: checkpoint
record is at 0/7000020
Oct 12 17:53:25 localhost postgres[26997]: [1750-1] DEBUG: redo record
is at 0/7000020; shutdown TRUE
Oct 12 17:53:25 localhost postgres[26997]: [1751-1] DEBUG: next
transaction ID: 0/3162; next OID: 17842
Oct 12 17:53:25 localhost postgres[26997]: [1752-1] DEBUG: next
MultiXactId: 1; next MultiXactOffset: 0
Oct 12 17:53:25 localhost postgres[26997]: [1753-1] PANIC: could not
open file "pg_xlog/000000010000000000000007" (log file 0, segment
7): ???????????? ????????
Oct 12 17:53:25 localhost postgres[26995]: [1748-1] DEBUG: reaping dead
processes
Oct 12 17:53:25 localhost postgres[26995]: [1749-1] LOG: startup
process (PID 26997) was terminated by signal 6: Aborted
Oct 12 17:53:25 localhost postgres[26995]: [1750-1] LOG: aborting
startup due to startup process failure
Oct 12 17:53:25 localhost postgres[26995]: [1751-1] DEBUG:
shmem_exit(1): 3 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1752-1] DEBUG:
proc_exit(1): 3 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1753-1] DEBUG: exit(1)
Oct 12 17:53:25 localhost postgres[26995]: [1754-1] DEBUG:
shmem_exit(-1): 0 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1755-1] DEBUG:
proc_exit(-1): 0 callbacks to make

I hadn't this problem under previous version Postgresql 8.4.3.
I tried pg_resetxlog -f /var/lib/postgres/data, but it didn't resolve
this problem.
I tried reinit database but result is the same.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Evans 2010-10-12 15:48:45 BUG #5707: Cross compilation for windows is broken
Previous Message Craig Ringer 2010-10-12 13:57:10 Re: BUG #5706: Install error 1935 (Microsoft Visual C++ 2005)