Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created
Дата
Msg-id 20150112181916.GG2092@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created  (cowwoc <cowwoc@bbs.darktech.org>)
Список pgsql-bugs
On 2014-12-09 17:25:43 -0500, Tom Lane wrote:
> cowwoc <cowwoc@bbs.darktech.org> writes:
> > Tom Lane-2 wrote
> >> That's bizarre.  It sounds like there's something corrupt about your
> >> pg_extension system catalog.  Does "select * from pg_extension" show
> >> reasonable-looking data?  If so, try "REINDEX TABLE pg_extension".
>
> > This error is quite random, so I'll have to try again the next time I run
> > into it. I get the following output when the database is in a "good" state:
>
> If it was non-reproducible, you really should have mentioned that to start
> with.  That fact changes the likely causes significantly.  Now I'm
> wondering about flaky hardware, for example.

cowwoc just talked about this on irc, and the explanation very likely is
that the extension commands are run in parallel on several
connections.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Johnny B
Дата:
Сообщение: Re: BUG #12523: postgresql-libs-8.4.22-i386 missing
Следующее
От: cowwoc
Дата:
Сообщение: Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created