[Pgpool-general] panic: index siblings mismatch

[Gerd König]

Hello Jaume,

thanks for answering, and I really don't want to blame pgpool, since I
appreciate it very much ;-)

My first thought was postgresql-related also, but it appeared just after setting
up pgpool in that test environment and that confused me a bit...

- fsck finished without errors
- upgrade to 8.3.6 is highly welcomed, but I haven't found rpm's for
opensuse10.3-64bit (software.opensuse.org offers 8.3.5)

I've set up this node again via pcp_recovery_node, and I'll keep an eye on
it...(and if it happens again I will try your hints with reindexing/-creating
the indexes)

kind regards....GERD....



Jaume Sabater schrieb:
> On Tue, Mar 10, 2009 at 10:35 PM, Gerd König <koenig at transporeon.com> wrote:
> 
>> today I recognized an error while playing with pgpool-II 2.1 and
>> postgresql 8.3.5 (on 64bit linux).
>> I really don't know if the error is caused by pgpool or if it's
>> postgresql-related...?!?
> 
> I think that you have either data corruption in your filesystem or
> inside your PostgreSQL server(s). Suggestions:
> 
> - Check your filesystem with fsck or similar tool.
> - Update to the latest version of PostgreSQL, 8.3.6, dump and restore
> the database, or recreate all indexes. I am not aware whether there
> exists or not a tool to check data integrity at PostgreSQL level.
> 
> I can't really find a reason to blame pgpool-II there, but I don't
> know enough to be sure either.
> 

-- 
/===============================\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 99
| Web: www.transporeon.com
|
\===============================/



Bleiben Sie auf dem Laufenden.
Jetzt den Transporeon Newsletter abonnieren!
http://www.transporeon.com/unternehmen_newsletter.shtml


TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon