By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,806 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,806 IT Pros & Developers. It's quick & easy.

cannot extend error

P: n/a
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
Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
ha**********@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.