fdatasync failed, I/O error

From: "Brusser, Michael" <Michael(dot)Brusser(at)matrixone(dot)com>
To: "'Pgsql-Hackers'" <pgsql-hackers(at)postgresql(dot)org>
Subject: fdatasync failed, I/O error
Date: 2005-06-01 14:27:04
Message-ID: 9150DCE0CCB4D411A7DB00508BB0DBF2100614E1@msx1am.matrixone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Our customer is running Postgresql v. 7.3.4 on Linux(Redhat 3.0 Ent.)
The application crashed and I am trying to understand what could have caused
this kind of problems:

fdatasync of log file 0, segment 2 failed: input/output error
PGSTAT: Error closing temp stats file
.../.../postgresql/global/pgstat.tmp.10278: Input/output error

I suppose they could be using NFS (I know, I know... we have to deal with
that. But could it be something else? A bad disk?)

Thank you,
Mike

======================================================================

From the database log:
-------------------------
... ... ... ...
2005-06-01 11:55:25 PANIC: fdatasync of log file 0, segment 2 failed:
input/output error
2005-06-01 11:55:25 LOG: server process (pid 16178) was terminated by
signal 6
2005-06-01 11:55:25 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2005-06-01 11:55:25 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2005-06-01 11:55:25 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2005-06-01 11:55:25 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2005-06-01 11:55:25 WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
2005-06-01 11:55:28 LOG: all server processes terminated; reinitializing
shared memory and semaphores
2005-06-01 11:55:28 LOG: database system was interrupted at 2005-06-01
02:05:21 IDT
2005-06-01 11:55:28 LOG: checkpoint record is at 0/268BF24
2005-06-01 11:55:28 LOG: redo record is at 0/268BF24; undo record is at
0/0; shutdown FALSE
2005-06-01 11:55:28 LOG: next transaction id: 23827; next oid: 25973
2005-06-01 11:55:28 LOG: database system was not properly shut down;
automatic recovery in progress
2005-06-01 11:55:28 LOG: redo starts at 0/268BF64
2005-06-01 11:55:28 LOG: ReadRecord: record with zero length at 0/269A9EC
2005-06-01 11:55:28 LOG: redo done at 0/269A9AC
2005-06-01 11:55:31 PANIC: fdatasync of log file 0, segment 2 failed:
Input/output error
2005-06-01 11:55:31 LOG: startup process (pid 16180) was terminated by
signal 6
2005-06-01 11:55:32 LOG: PGSTAT: Error closing temp stats file
/apps/sync/syncdata/sync/10000/server_metadata/postgr
esql/global/pgstat.tmp.10278: Input/output error
2005-06-01 12:47:28 LOG: database system shutdown was interrupted at
2005-06-01 11:55:28 IDT
2005-06-01 12:47:28 LOG: checkpoint record is at 0/268BF24
2005-06-01 12:47:28 LOG: redo record is at 0/268BF24; undo record is at
0/0; shutdown FALSE
2005-06-01 12:47:28 LOG: next transaction id: 23827; next oid: 25973
2005-06-01 12:47:28 LOG: database system was not properly shut down;
automatic recovery in progress
2005-06-01 12:47:28 LOG: redo starts at 0/268BF64
2005-06-01 12:47:28 LOG: ReadRecord: record with zero length at 0/269AA2C
2005-06-01 12:47:28 LOG: redo done at 0/269A9EC
2005-06-01 12:47:30 LOG: database system is ready

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-06-01 14:27:56 Re: Interval->day proposal
Previous Message Alvaro Herrera 2005-06-01 14:24:32 Re: Quick-and-dirty compression for WAL backup blocks