From: | A B <gentosaker(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Help! xlog flush request is not satisfied |
Date: | 2009-12-07 07:00:49 |
Message-ID: | dbbf25900912062300hf70ba44xd67d58b7b0821bf7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
I just logged into a system and found this in the log when trying to
start postgres.
LOG: database system shutdown was interrupted; last known up at
2009-12-07 06:27:33 CET
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 15/B320AF68
LOG: record with zero length at 15/B348B9B0
LOG: redo done at 15/B348B980
LOG: last completed transaction was at log time 2009-12-07 05:54:19.655173+01
FATAL: xlog flush request 15/B37CA000 is not satisfied --- flushed
only to 15/B348B9B0
CONTEXT: writing block 0 of relation base/16386/119806_vm
LOG: startup process (PID 27338) exited with exit code 1
LOG: aborting startup due to startup process failure
And now I'm unsure what to do. (running postgresql 8.4.1)
Any idea on what is wrong here, any suggestions on what I should do?
I've found out that there is a command pg_resetxlog that some people
have run in these circumstances, but I'd rather not run anthing before
someone tells me what is going on.
There is a backup (pg_dumpall) that is about 12 hours old that I
think I could use if that is the best option.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Tyler | 2009-12-07 09:53:18 | could not access status of transaction 825832753 |
Previous Message | Postgres User | 2009-12-07 00:28:50 | How to check status of bug (42804: structure of query does not match error where using RETURN QUERY) ? |