cannot extend error
Hi
We are using PostgreSQL 7.3.2
We have a transaction (JDBC) using which a postgres function is
called. Certain times (1 in 20 ..at times even less), we get this
error:
cannot extend "table name" input/output error check free disk space
The hard disk has about 1 gb free space.
Pls advise.
Thanks in advance.
Harjan
harjancheema@hotmail.com (harjan) writes:
cannot extend "table name" input/output error check free disk space
The hard disk has about 1 gb free space.
Pls advise.
The "check free disk space" bit is just a hint, which is not very
relevant in this case. The critical part of that message is the
kernel error: "input/output error". You apparently have got a disk
hardware problem. I'd suggest running badblocks and/or replacing
the disk ...
regards, tom lane