Re: Postgres error when adding new page - Mailing list pgsql-general

From Marco Craveiro
Subject Re: Postgres error when adding new page
Date
Msg-id CAKRNd4w_xtqjbcBquphf-UFz1Zbb_uwWBdDXb8us+iEAuks=pA@mail.gmail.com
Whole thread Raw
In response to Re: Postgres error when adding new page  (Peter Geoghegan <peter@2ndquadrant.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: opened connection
Next
From: Merlin Moncure
Date:
Subject: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS?