Input/Output Error Message

From: Brian Chu <bchu(at)jetnet(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Input/Output Error Message
Date: 2002-06-18 12:17:09
Message-ID: F72CDFC92CAA204A9BE73476EED3821D1CB0A1@JETMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Input/Output Error Message</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Hello,</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>I had a question regarding an error message that I'm seeing during my testing using Postgres version 7.2. I'm not sure if this is related to Postgres or a disk I/O related problem. Any help or tips to pinpointing the problem would also help. Thanks in advance.</FONT></P>

<P><FONT SIZE=2>The error is as follows:</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=2> </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>[ERROR:&nbsp; cannot read &nbsp;&nbsp; block 6093 of &lt;table_name&gt;: Input/output error]</FONT>
</P>

<P><FONT SIZE=2>Note: I purposely left out the table name in question. Anyways, a few additional points:</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>- there is a cron type script (i.e. runs at defined time intervals - one hour) which reads data from the postgres database</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=2>- from the 'debug logs', this message was &quot;sporadically&quot; generated. What I mean by that is there no pattern (in terms of time)&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; when this error message occurs. In this particular case, the message only appeared on Sunday, June 16th and at varying&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; times during the day</FONT></P>

<P><FONT SIZE=2>Any help would be appreciated. Thanks again.</FONT>
</P>

<P><FONT SIZE=2>Brian Chu - S/W Verification Prime</FONT>
<BR><FONT SIZE=2>JetNet Internetworking Services Inc.</FONT>
<BR><FONT SIZE=2>333 Preston Street (Xerox Building)</FONT>
<BR><FONT SIZE=2>3rd Floor, Suite 300</FONT>
<BR><FONT SIZE=2>Ottawa, Ontario</FONT>
<BR><FONT SIZE=2>K1S 5N4</FONT>
<BR><FONT SIZE=2>Canada</FONT>
<BR><FONT SIZE=2>Phone: (613) 237-5995 x479</FONT>
<BR><FONT SIZE=2>Email: bchu(at)jetnet(dot)ca</FONT>
<BR><FONT SIZE=2>Fax: (613) 237-9002</FONT>
</P>

</BODY>
</HTML>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-06-18 12:25:07 Re: Stored Procedures for Shell Execution
Previous Message BRINER Cedric 2002-06-18 11:03:33 compiling problem: tab-complete.c