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

Re: [HACKERS] select * from ..;vacuum crashes

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: t-ishii(at)sra(dot)co(dot)jp, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] select * from ..;vacuum crashes
Date: 1998-10-06 05:42:44
Message-ID: 199810060542.BAA00553@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> >You must enable Assert to see the crash.
> 
> I saw the crash without assertion enabled? This is FreeBSD 2.2.6.
> 
> >The cause may be because you are doing a vacuum INSIDE a transaction.  I
> >think that also explains the psql -e thing, because that does both
> >commands in the same transaction.
> >
> >Perhaps we need to disable vacuum inside transactions.  Vadim?

Turns out getting is being removed from pg_class.  If you run the
script, without the final psql command, and go into ptest, and look do:

	select oid, relname from pg_class

you see the table getting.  If you then run the 'select * from getting'
and 'vacuum' you will see from the backtrace it is trying to update
statistics on the 'getting' table, but it is gone.  If you go back into
ptest after the vacuum crash, 'getting' is gone from pg_class.

Looks like I may need help on this one.  How does that happen?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


In response to

pgsql-hackers by date

Next:From: Vadim MikheevDate: 1998-10-06 06:51:27
Subject: Re: [HACKERS] select * from ..;vacuum crashes
Previous:From: Bruce MomjianDate: 1998-10-06 05:34:37
Subject: Re: [HACKERS] select * from ..;vacuum crashes

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