Re: [HACKERS] canceling autovacuum task woes

2012-08-30 Thread Robert Haas
On Mon, Aug 13, 2012 at 11:59 PM, Peter Eisentraut wrote: > On Tue, 2012-07-24 at 16:14 -0400, Robert Haas wrote: >> On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane wrote: >> > Robert Haas writes: >> >> Yeah, you're right. So you do get the table name. But you don't get >> >> the cause, which is wha

Re: [HACKERS] canceling autovacuum task woes

2012-08-13 Thread Peter Eisentraut
On Tue, 2012-07-24 at 16:14 -0400, Robert Haas wrote: > On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane wrote: > > Robert Haas writes: > >> Yeah, you're right. So you do get the table name. But you don't get > >> the cause, which is what you really need to understand why it's > >> happening. Attache

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas writes: > On Jul 24, 2012, at 4:31 PM, Tom Lane wrote: >> ... This means that with respect to (a), the connection >> from the process doing the kill to the AV proc may be inadequately >> documented by this patch, and with respect to (b), there might well be >> cases where we found an

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Jul 24, 2012, at 4:31 PM, Tom Lane wrote: > Robert Haas writes: >> On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera >> wrote: >>> Looks great. Are you considering backpatching this? > >> Well, that would certainly make MY life easier. I am not sure whether >> it would be in line with projec

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas writes: > On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera > wrote: >> Looks great. Are you considering backpatching this? > Well, that would certainly make MY life easier. I am not sure whether > it would be in line with project policy, however. +1 for a backpatch. Otherwise it'l

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane wrote: > Robert Haas writes: >> Yeah, you're right. So you do get the table name. But you don't get >> the cause, which is what you really need to understand why it's >> happening. Attached is a patch that adds some more detail. > > Uh, what's the adde

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Tom Lane
Robert Haas writes: > Yeah, you're right. So you do get the table name. But you don't get > the cause, which is what you really need to understand why it's > happening. Attached is a patch that adds some more detail. Uh, what's the added dependency on pgstat.h for? Looks sane to the eyeball o

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 4:03 PM, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of mar jul 24 15:52:23 -0400 2012: >> On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera >> wrote: >> > Yep, it says: >> > >> > ERROR: canceling autovacuum task >> > CONTEXT: automatic vacuum of table "alv

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar jul 24 15:52:23 -0400 2012: > On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera > wrote: > > Yep, it says: > > > > ERROR: canceling autovacuum task > > CONTEXT: automatic vacuum of table "alvherre.public.foo" > > > > So at least that part seems pilot err

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 3:35 PM, Alvaro Herrera wrote: > Yep, it says: > > ERROR: canceling autovacuum task > CONTEXT: automatic vacuum of table "alvherre.public.foo" > > So at least that part seems pilot error more than anything else. Yeah, you're right. So you do get the table name. But you

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of mar jul 24 15:30:49 -0400 2012: > > > On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: > > > I am running into a lot of customer situations where the customer > > > reports that "canceling autovacuum task" shows up in the logs, and > > > it's uncl

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Alvaro Herrera
> On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: > > I am running into a lot of customer situations where the customer > > reports that "canceling autovacuum task" shows up in the logs, and > > it's unclear whether this is happening often enough to matter, and > > even more unclear what

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Andrew Dunstan
On 07/24/2012 01:48 PM, Robert Haas wrote: I am running into a lot of customer situations where the customer reports that "canceling autovacuum task" shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Me: So, do you

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
On Tue, Jul 24, 2012 at 2:11 PM, Steve Singer wrote: > On 12-07-24 01:48 PM, Robert Haas wrote: >> I am running into a lot of customer situations where the customer >> reports that "canceling autovacuum task" shows up in the logs, and >> it's unclear whether this is happening often enough to matte

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Steve Singer
On 12-07-24 01:48 PM, Robert Haas wrote: I am running into a lot of customer situations where the customer reports that "canceling autovacuum task" shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Could autovacuum

Re: [HACKERS] canceling autovacuum task woes

2012-07-24 Thread Andres Freund
Hi, On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: > I am running into a lot of customer situations where the customer > reports that "canceling autovacuum task" shows up in the logs, and > it's unclear whether this is happening often enough to matter, and > even more unclear what's caus

[HACKERS] canceling autovacuum task woes

2012-07-24 Thread Robert Haas
I am running into a lot of customer situations where the customer reports that "canceling autovacuum task" shows up in the logs, and it's unclear whether this is happening often enough to matter, and even more unclear what's causing it. Me: So, do you know what table it's getting cancelled on? Cus