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

Re: BUG #3790: pg_restore error canceling statement due touser request

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Gregory Stark <stark(at)enterprisedb(dot)com>, "Mike C(dot)" <smith(dot)not(dot)western(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3790: pg_restore error canceling statement due touser request
Date: 2007-12-03 23:56:50
Message-ID: 20071203235650.GB9782@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Bruce Momjian escribió:
> Magnus Hagander wrote:
> > On Fri, Nov 30, 2007 at 10:13:53AM +0000, Gregory Stark wrote:
> > > 
> > > "Mike C." <smith(dot)not(dot)western(at)gmail(dot)com> writes:
> > > 
> > > > I don't know if this is either a wording change, or a more serious bug, but
> > > > when I do a pg_restore (from a 8.1.9 setup) to a fresh 8.3beta3 created
> > > > database (createdb command only), I repeatedly see:
> > > >
> > > > ERROR:  canceling statement due to user request
> > > > CONTEXT:  automatic analyze of table "dbs.public.entity_event"
> > > 
> > > This is intentional, though perhaps the wording is confusing. What impression
> > > does the wording give you? Does it make you think something has gone wrong?
> > 
> > The fact that it says ERROR kind of hints that something has gone wrong,
> > no? (so yes, I agree the wording isn't very good)
> 
> What is causing this?  Statement_timeout?  I see different wording for
> that behavior.  Is the postmaster getting a signal from somewhere on the
> system?

It's the new autovacuum cancel stuff.

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"That sort of implies that there are Emacs keystrokes which aren't obscure.
I've been using it daily for 2 years now and have yet to discover any key
sequence which makes any sense."                        (Paul Thomas)

In response to

Responses

pgsql-bugs by date

Next:From: thomas haegiDate: 2007-12-04 01:31:18
Subject: BUG #3797: b4 msi installer fails when b3 is still installed
Previous:From: Bruce MomjianDate: 2007-12-03 23:37:48
Subject: Re: BUG #3790: pg_restore error canceling statement due to user request

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