| 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: | Whole Thread | Raw Message | 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 |