pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
IO Error 2+ messages / 2 participants [nested] [flat]
* IO Error @ 2005-11-12 14:18 Yves Vindevogel <yves.vindevogel@implements.be> 0 siblings, 1 reply; 2+ messages in thread From: Yves Vindevogel @ 2005-11-12 14:18 UTC (permalink / raw) To: pgsql-performance; +Cc: Hendrik De Hertogh <hendrik.dehertogh@ecseed.com> ns30966:~# NOTICE: Executing SQL: update tblPrintjobs set ApplicationType = 1 where ApplicationType is null and upper(DocumentName) like '%.DOC' ns30966:~# NOTICE: Executing SQL: update tblPrintjobs set ApplicationType = 1 where ApplicationType is null and upper(DocumentName) like 'DOCUMENT%' ns30966:~# ns30966:~# ERROR: could not read block 3231 of relation 1663/165707259/173511769: Input/output error CONTEXT: SQL statement "update tblPrintjobs set ApplicationType = 1 where ApplicationType is null and upper(DocumentName) like 'DOCUMENT%'" PL/pgSQL function "fnapplicationtype" line 30 at execute statement [1]+ Exit 1 psql -d kpmg -c "select fnApplicationType()" I get this error. Is this hardware related or could it be something with the postgresql.conf settings. I changed them for performance reasons. (More memory, more wal buffers). There are 2 databases. One got the error yesterday, I dropped it (was brand new), recreated it and the error was gone. Now the error is there again on another database. Personally, I think it's a HD error. Met vriendelijke groeten, Bien à vous, Kind regards, Yves Vindevogel Implements Mail: yves.vindevogel@implements.be - Mobile: +32 (478) 80 82 91 Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76 Web: http://www.implements.be First they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Ghandi. Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadPasted Graphic 2.tiff (image/tiff, 5.6K) download
view image
* Re: IO Error @ 2005-11-12 15:53 Tom Lane <tgl@sss.pgh.pa.us> parent: Yves Vindevogel <yves.vindevogel@implements.be> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-11-12 15:53 UTC (permalink / raw) To: Yves Vindevogel <yves.vindevogel@implements.be>; +Cc: pgsql-performance@postgresql.org, Hendrik De Hertogh <hendrik.dehertogh@ecseed.com> Yves Vindevogel <yves.vindevogel@implements.be> writes: > ns30966:~# ERROR: could not read block 3231 of relation > 1663/165707259/173511769: Input/output error > I get this error. Is this hardware related or could it be something > with the postgresql.conf settings. It's a hardware failure --- bad disk block, likely. You might find more details in the kernel log (/var/log/messages or equivalent). regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-12 15:53 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-11-12 14:18 IO Error Yves Vindevogel <yves.vindevogel@implements.be> 2005-11-12 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox