Re: Deadlock while doing VACUUM?? - Mailing list pgsql-hackers

From Thomas T. Thai
Subject Re: Deadlock while doing VACUUM??
Date
Msg-id 2200.63.226.186.156.1048787503.squirrel@mail.minnesota.com
Whole thread Raw
In response to Deadlock while doing VACUUM??  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-hackers
> Even dropping the table and all of its indexes and recreating it does
> nothing to solve this problem, so I don't have any reason to suspect
> corruption of the table itself.  Corruption elsewhere is a
> possibility, I suppose, but I haven't noticed any strangeness
> elsewhere.

This sounds very similiar to problems I was having under the thread:
 Re: [HACKERS] BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0

Dropping the table, indexes, and recreating it didn't help me either. I
had to drop the database!

What kind of platform are you on? 64-bit?

I've noticed that 7.4-snapshot fixed a huge amount of bugs, but the vacuum
analyze bug is still there.

--
Thomas



pgsql-hackers by date:

Previous
From: "Tom"
Date:
Subject: Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0
Next
From: Haroldo Stenger
Date:
Subject: Re: Solution to UPDATE...INSERT problem