Skip site navigation (1) Skip section navigation (2)

postgres 8.1 crashing

From: Kari Lavikka <tuner(at)bdb(dot)fi>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgres 8.1 crashing
Date: 2005-11-29 14:05:44
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs

I just upgraded pg 8.0.3 to 8.1 (dump and reload) and outcome was a 
corrupted database. pg 8.1 seemed to fly but backends were crashing

Hardware is Sun v40z with 64bit Debian Sarge, Linux Size of 
database is somewhere around 500M rows and it's loaded by a website with a 
lot of traffic.


Some backtraces (update queries are included in the bt):

And users-table which is involved in all the crashes is described
here (contains ~700000 rows):

I tried to reindex the table but it didn't help. PG went corrupted
after a while:

Any ideas?

     ( oo )    Kari Lavikka - tuner(at)bdb(dot)fi - (050) 380 3808
__ooO(  )Ooo_______ _____ ___ _ _  _   _    _      _                  _

pgsql-bugs by date

Next:From: ArjenDate: 2005-11-29 14:20:32
Subject: BUG #2075: Strange choice of bitmap-index-scan
Previous:From: Edoardo InnocentiDate: 2005-11-29 08:05:43
Subject: BUG #2074: Error switching connection in embedded PostgreSQL program

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group