Re: BUG #3790: pg_restore error canceling statement due to user request - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #3790: pg_restore error canceling statement due to user request
Date
Msg-id 20071203235650.GB9782@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #3790: pg_restore error canceling statement due to user request  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #3790: pg_restore error canceling statement due touser request
Re: BUG #3790: pg_restore error canceling statement due to user request
List pgsql-bugs
Bruce Momjian escribió:
> Magnus Hagander wrote:
> > On Fri, Nov 30, 2007 at 10:13:53AM +0000, Gregory Stark wrote:
> > >
> > > "Mike C." <smith.not.western@gmail.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)

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #3790: pg_restore error canceling statement due to user request
Next
From: "thomas haegi"
Date:
Subject: BUG #3797: b4 msi installer fails when b3 is still installed