Re: ERROR: subtransaction logged without previous top-level txn record

Поиск
Список
Период
Сортировка
Искать
От
Arseny Sher
Тема
Re: ERROR: subtransaction logged without previous top-level txn record
Дата
Msg-id
87o8w7vv8h.fsf@ars-thinkpad
Ответ на
Список
Дерево обсуждения
ERROR: subtransaction logged without previous top-level txn record "Hsu, John" <hsuchen@amazon.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txnrecord Andres Freund <andres@anarazel.de>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Dan Katz <dkatz@joor.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Dan Katz <dkatz@joor.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar <dilipbalaut@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar <dilipbalaut@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar <dilipbalaut@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila <amit.kapila16@gmail.com>
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher <a.sher@postgrespro.ru>

Dan Katz  writes:

> Is the resolution of the issue in this thread being tracked elsewhere,
> either in a commit fest or other stream of work?

Ok, I've created a cf entry:
https://commitfest.postgresql.org/26/2383/

I believe it is the most important to commit at least

0002-Stop-demanding-that-top-xact-must-be-seen-before-sub.patch

from my mail above -- as we see, this issue creates problems in the
field. Moreover, the patch is trivial and hopefully I've shown that
ERROR triggers were spurious and there is no easy way to relax the
check.

--
Arseny Sher
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


В списке pgsql-bugs по дате отправления
От: PG Bug reporting form
Дата:
От: Tom Lane
Дата:
FAQ