On Mon, 13 May 2024 10:09:48 +0200 Christoph Berg <m...@debian.org> wrote:
> Re: Vladimir Stupin > > Package: postgresql-15 > > Version: 15.6-0+deb12u1 > > > > dropdb on any database hangs up. pg_activity shows query DROP DATABASE > > <database name>; in state ProcSignalBarrier. > > > > I found fix for the trouble at > > https://www.postgresql.org/message-id/E1pKAd5-005BKs-Vr%40gemulon.postgresql.org > > > > I use apt-source to check sources to found fix described at link above. > > Sources was not fixed. Please update package to fix the trouble. > > Hi, > > the fix you link to was included in 15.2 as > 267135d01d79c63dfba7fe69dd3b40c125c49a6f. > How did you determine it wasn't included? Checked sources secondary. Sorry, you right. Fix already applied. > Can you pull a backtrace of the hanging process? > https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD Here backtrace, that you asked: Continuing. Program received signal SIGINT, Interrupt. 0x00007feb07d29de3 in epoll_wait () from /lib/x86_64-linux-gnu/libc.so.6 #0 0x00007feb07d29de3 in epoll_wait () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x000055759a1305be in WaitEventSetWait () #2 0x000055759a130908 in WaitLatch () #3 0x000055759a13c534 in ConditionVariableTimedSleep () #4 0x000055759a1363c3 in WaitForProcSignalBarrier () #5 0x0000557599f7173c in dropdb () #6 0x000055759a159700 in standard_ProcessUtility () #7 0x00007feb076556cd in ?? () from /usr/lib/postgresql/15/lib/pg_stat_statements.so #8 0x000055759a1579e1 in ?? () #9 0x000055759a157af8 in ?? () #10 0x000055759a15808e in PortalRun () #11 0x000055759a15432d in ?? () #12 0x000055759a155069 in PostgresMain () #13 0x000055759a0d2d81 in ?? () #14 0x000055759a0d3d55 in PostmasterMain () #15 0x0000557599e3aa5b in main () Detaching from program: /usr/lib/postgresql/15/bin/postgres, process 2227776 [Inferior 1 (process 2227776) detached] May be i need to install some additional packages with debug symbols to get more detailed backtrace? Here postgresql-packages currently installed: $ dpkg -l | grep postgresql ii postgresql-15 15.6-0+deb12u1 amd64 The World's Most Advanced Open Source Relational Database ii postgresql-15-repack 1.4.8-1+b1 amd64 reorganize tables in PostgreSQL databases with minimal locks ii postgresql-client-15 15.6-0+deb12u1 amd64 front-end programs for PostgreSQL 15 ii postgresql-client-common 248 all manager for multiple PostgreSQL client versions ii postgresql-common 248 all PostgreSQL database-cluster manager ii timescaledb-2-loader-postgresql-15 2.14.1~debian12 amd64 The loader for TimescaleDB to load individual versions. ii timescaledb-2-postgresql-15 2.14.1~debian12 amd64 An open-source time-series database based on PostgreSQL, as an extension. -- Владимир Ступин <stupi...@ufanet.ru>
