Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences

Поиск
Список
Период
Сортировка
От Akshat Jaimini
Тема Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences
Дата
Msg-id 171170826140.2046436.12738244831107414180.pgcf@coridan.postgresql.org
обсуждение исходный текст
Ответ на Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
Ответы Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            tested, passed

Hii,

Thanks for the updated patch. I ran make installcheck-world after applying the patch and recompiling it. It did fail
fora particular test but from the logs it seems to be unrelated to this particular patch since it fails for the
following:

==========================
select error_trap_test();
-      error_trap_test      
----------------------------
- division_by_zero detected
-(1 row)
-
+ERROR:  cannot start subtransactions during a parallel operation
+CONTEXT:  PL/pgSQL function error_trap_test() line 2 during statement block entry
+parallel worker
 reset debug_parallel_query;
 drop function error_trap_test();
 drop function zero_divide();
==========================

The code seems to implement the feature and has good and explanatory comments associated with it.
I believe we can go ahead with committing patch although I would request some senior contributors to also take a look
atthis patch since I am relatively new to patch reviews.
 
Changing the status to 'Ready for Committer'.

Regards,
Akshat Jaimini

The new status of this patch is: Ready for Committer

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

Предыдущее
От: Alexander Lakhin
Дата:
Сообщение: Re: To what extent should tests rely on VACUUM ANALYZE?
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Improve eviction algorithm in ReorderBuffer