| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <icub3d(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: ERROR: could not read block |
| Date: | 2005-11-15 15:12:04 |
| Message-ID: | 4379A66402000025000006D3@gwmta.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
It appears that the log file is not being written -- I'll start a
separate thread on that issue.
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
-Kevin
>>> Joshua Marsh <icub3d(at)gmail(dot)com> >>>
Does the log file tell you anymore information?
Have you tried to rerun the query? If so, did you get similar results?
-Josh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-11-15 15:55:08 | Re: Major Problem, need help! Can't run our website! |
| Previous Message | Tom Lane | 2005-11-15 14:32:22 | Re: Reg: Changing Column type |