Re: Postgres error when adding new page

Peter,

Thanks for your prompt reply.

A call to PageAddItem(), made within _bt_pgaddtup(), is where this
> failure seems to ultimately originate from. What we're missing here is
> the reason for PageAddItem() returning InvalidOffsetNumber. That is
> usually, though not necessarily, separately available within a WARNING
> log message, which you haven't included here. Could you please let us
> know if there is a WARNING that you didn't include just prior to the
> ERROR?
>

No warning I'm afraid. These are the statements I see on the Postgres log
file:

2012-10-01 13:09:12 WEST ERROR: failed to add old item to the right
sibling while splitting block 191 of index "crc323"
2012-10-01 13:09:12 WEST STATEMENT: INSERT INTO test
(projectid,crc32,name,path,command,details,output)
VALUES
('2','2548249718','utility/xml/closing_an_open_text_reader_does_not_throw','./projects/utility/spec','e:\cmake\bin\cmake.exe
"-E" "chdir"
"E:/mingw/msys/1.0/home/ctest/build/Continuous/dogen/mingw-1.0.17-i686-gcc-4.7/build/stage/bin"
"E:/mingw/msys/1.0/home/ctest/build/Continuous/dogen/mingw-1.0.17-i686-gcc-4.7/build/stage/bin/dogen_utility_spec"
"--run_test=xml/closing_an_open_text_reader_does_not_throw"','Completed','UnVubmluZyAxIHRlc3QgY2FzZS4uLgoKKioqIE5vIGVycm9ycyBkZXRlY3RlZAo=')

These are repeated several times as CDash keeps on retrying. After a few
retries we succeed (the actual number of retries is variable - 8, 10, etc).

Cheers

Marco
--
So young, and already so unknown -- Pauli

blog: http://mcraveiro.blogspot.com