Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group