IO Error

From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
To: pgsql-performance(at)postgresql(dot)org
Cc: Hendrik De Hertogh <hendrik(dot)dehertogh(at)ecseed(dot)com>
Subject: IO Error
Date: 2005-11-12 14:18:09
Message-ID: c256f650965bb4f7ca2243468b4725a8@implements.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Attachment Content-Type Size
Pasted Graphic 2.tiff image/tiff 5.6 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-11-12 15:53:14 Re: IO Error
Previous Message hubert depesz lubaczewski 2005-11-12 09:14:49 Re: slow queries after ANALYZE