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

Re: Could not open file pg_xlog/000000010....

From: Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Could not open file pg_xlog/000000010....
Date: 2010-10-12 17:31:31
Message-ID: 4CB49B73.6060203@ort.edu.uy (view raw or flat)
Thread:
Lists: pgsql-bugs
  El 12/10/2010 13:26, Victor escribió:
> 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. 
hi, you upgrade from 8.4.3 to 8.4.4,
do you have the file in $pgdate/pg_xlog/000000010000000000000007, 
assuming pgdata in /var/lib/pgsql/data.
the database try to redo some transaction but don't have the log file.
have any backup prior upgrade?.
the logfile number is to small, this is not a production database, no?


Fernando Rodriguez

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2010-10-12 18:25:20
Subject: Re: BUG #5707: Cross compilation for windows is broken
Previous:From: Peter EisentrautDate: 2010-10-12 17:27:20
Subject: Re: wrong timezone precision using plpythonu trigger

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