Re: ERROR: could not read block

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: ERROR: could not read block
Дата
Msg-id 4379A66402000025000006D3@gwmta.wicourts.gov
обсуждение исходный текст
Список 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@gmail.com>  >>>

Does the log file tell you anymore information?

Have you tried to rerun the query? If so, did you get similar results?

-Josh


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Reg: Changing Column type
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Major Problem, need help! Can't run our website!