Re: Could not open file pg_xlog/000000010.... - Mailing list pgsql-bugs

From Rodriguez Fernando
Subject Re: Could not open file pg_xlog/000000010....
Date
Msg-id 4CB49B73.6060203@ort.edu.uy
Whole thread Raw
In response to Could not open file pg_xlog/000000010....  (Victor <only-victor@mail.ru>)
List 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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: wrong timezone precision using plpythonu trigger
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #5707: Cross compilation for windows is broken