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
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 |