Re: PostgreSQL 15.5 stops processing user queries

2023-12-26 Thread Andrey Zhidenkov
Sorry, wrong stack trace. Here is a correct one: (gdb) bt #0 0x7f9acca1bdf6 in do_futex_wait.constprop () from /lib64/libpthread.so.0 #1 0x7f9acca1bee8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0 #2 0x007815a2 in PGSemaphoreLock () #3 0x007fca6c in

Re: PostgreSQL 15.5 stops processing user queries

2023-12-21 Thread Tom Lane
Andrey Zhidenkov writes: > We have encountered an issue with our PostgreSQL 15.5 installation. The > problem is that > PostgreSQL server periodically falls into a state when it accepts new > connections but > doesn't execute any queries. The session which runs a query hangs and > cannot be termina

PostgreSQL 15.5 stops processing user queries

2023-12-21 Thread Andrey Zhidenkov
Hello all, We have encountered an issue with our PostgreSQL 15.5 installation. The problem is that PostgreSQL server periodically falls into a state when it accepts new connections but doesn't execute any queries. The session which runs a query hangs and cannot be terminated via SIGINT (even if it