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> <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> <FONT SIZE=2> </FONT>
<BR> <FONT SIZE=2>[ERROR: cannot read block 6093 of <table_name>: 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> <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> <FONT SIZE=2>- from the 'debug logs', this message was "sporadically" generated. What I mean by that is there no pattern (in terms of time) when this error message occurs. In this particular case, the message only appeared on Sunday, June 16th and at varying 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 |
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 |