xlog flush request 0/215D32E4 is not satisfied

From: Tim Vadnais <tvadnais(at)bwks(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: xlog flush request 0/215D32E4 is not satisfied
Date: 2005-01-27 18:53:27
Message-ID: B1BD543E7C06D51183B500A0C9AC2DB63E9F54@ntserver.asterion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can anyone help me with this problem; we are just about to go live (February
1), and all of a sudden our main database has an 'issue'. I'd like to save
the database if possible, if not, then I'll rebuild it from scratch which I
absolutely don't want to do since it will take about a month of continuous
work.

That said, I did a search on 'xlog flush request' and the only hits I got
were on version 7.1, and I'm using 7.4. In the other post, someone had run
pg_resetxlog, but I remember seeing somewhere serious warnings against using
that utility, especially if one runs it as root. If I'm suggested to run
it, should I run it as user postgres or myself?

I tried to do a 'pg_dump -d bwks > crash.dump' and got a failure.

Below please find the two different errors I get, the first is the 'xlog
flush' error and below that is the 'pg_dump error'.

Thank you in advance for your help.

Welcome to psql 7.4.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

bwks=# \d product
ERROR: xlog flush request 0/215D32E4 is not satisfied --- flushed only to
0/15138F7C
CONTEXT: writing block 4 of relation 17143/1682159
bwks=# select * from product;
code | short_desc | unit_value | unit_price | eff_date | term_date |
product_id | code_type_id | last_edit_user | last_edit_ts | ledger_column |
patient_resp | voucher_item | description
------+------------+------------+------------+----------+-----------+-------
-----+--------------+----------------+--------------+---------------+-------
-------+--------------+-------------
(0 rows)

bwks=# \q

_____________________________________________

$ pg_dump -d bwks > 2005.dumpall.crash
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: xlog flush request 0/215D738C is
not satisfied --- flushed only to 0/15138F7C
CONTEXT: writing block 5 of relation 17143/1682159
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid
= datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM
pg_database WHERE datname = 'bwks'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Potts 2005-01-27 18:55:27 postgress gnuplot and Geometric
Previous Message PFC 2005-01-27 18:24:37 Re: [GENERAL] My postmaster just crashed !