Re: Deadlock while doing VACUUM??

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: <kevin(at)sysexperts(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deadlock while doing VACUUM??
Date: 2003-03-27 17:51:43
Message-ID: 2200.63.226.186.156.1048787503.squirrel@mail.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Haroldo Stenger 2003-03-27 21:15:27 Re: [HACKERS] Solution to UPDATE...INSERT problem
Previous Message Tom 2003-03-27 17:37:47 Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0