Re: BUG #3790: pg_restore error canceling statement due to user request

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)