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 |
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 |