From: | "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Autovacuum deadlock - bug or not? |
Date: | 2005-11-17 15:18:09 |
Message-ID: | 7F10D26ECFA1FB458B89C5B4B0D72C2B0A01E2@sesrv12.wirelesscar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Unfortunately, relfilenodes 68950 and 68122 don't exist anymore, could be that they were temporary copies of tables or indexes. I know that process 15865 was the autovacuum pid, I looked that up when it happened (pg was restarted with autovacuum=off afterwards, so that process is also gone)
Could it be that the deadlock was caused by autovacuum trying to vacuum one of the temp copies?
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: den 17 november 2005 16:04
To: Mikael Carneholm
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Autovacuum deadlock - bug or not?
"Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> writes:
> variant: CLUSTER indexname ON tablename
Hmph. Looking at the code, that should always lock the table first,
so I don't see where the problem is. Would you look up the numbers
for us --- exactly which relations were involved in the deadlock,
and (if you can tell) which process was which?
Also, what PG version is this exactly?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Mikael Carneholm | 2005-11-17 15:20:44 | Re: Autovacuum deadlock - bug or not? |
Previous Message | Matt | 2005-11-17 15:13:38 | Huge query stalls at PARSE/BIND stage (1) |