Re: ERROR: could not read block

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: <icub3d(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: could not read block
Date: 2005-11-15 19:14:37
Message-ID: 4379DF3D0200002500000714@gwmta.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The table has about 23.3 million rows, of which about 200,000 will
be affected by this update. Run time is about an hour. During the
first run, the table was the target of about 45,000 inserts. This rerun
was done as the only task. A third run (also by itself) gave this:

ERROR: could not read block 1482762 of relation 1663/16385/16483:
Invalid argument

So the block number is increasing each time. I'm inclined to think
that this is the result of the scan passing over rows added by itself.

-Kevin

>>> Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> >>>

> I reran the query. Same error, same relation, different block.
>
> dtr=> UPDATE
> dtr-> "DbTranRepository"
> dtr-> SET "userId" = UPPER("userId")
> dtr-> WHERE (
> dtr(> ("userId" <> UPPER("userId")) AND
> dtr(> ("timestampValue" BETWEEN '2005-10-28' AND '2005-11-15'));
> ERROR: could not read block 1118215 of relation 1663/16385/16483:
> Invalid argument
>

So this is a big query? Somebody reported this error when IO is
intensive.
To conclude the reports we have received:

(1) If IO is intensive (no matter you have anti-virus software or not),
you may encounter "invalud argument" error;

(2) In some cases, anti-virus software could cause "invalid argument"
error;

(3) You may encounter "permission denied" problem (no matter you have
anti-virus software or not) in some unknown condition;

Unfortunately we haven't found out the cause of this problem ... I am
thinking an urgent need is let PG print the GetLastError() for Windows
version as well.

Regards,
Qingqing

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2005-11-15 19:48:44 Re: ERROR: could not read block
Previous Message Qingqing Zhou 2005-11-15 19:04:38 Re: ERROR: could not read block