backend error after upgrading to 3.6.0
Ярослав Минин
yaras_phoenix at inbox.ru
Tue Sep 16 07:48:02 PDT 2025
- Versions:
PostgreSQL 15.3 ( Ubuntu 15.3 -1. pgdg22 . 04 + 1 ) on x86_64 - pc - linux - gnu , compiled by gcc ( Ubuntu 11. 3.0 - 1 ubuntu1 ~ 22.04 ) 11. 3.0 , 64 - bit
POSTGIS = "3.6.0 4c1967d" [ EXTENSION ] PGSQL = "150" GEOS = "3.10.2-CAPI-1.16.0" SFCGAL = "SFCGAL 1.4.1, CGAL 5.3.1, BOOST 1.74.0" PROJ = "8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT= https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db" ( compiled against PROJ 8. 2.1 ) GDAL = "GDAL 3.4.1, released 2021/12/27" LIBXML = "2.9.13" LIBJSON = "0.15" LIBPROTOBUF = "1.3.3" WAGYU = "0.5.0 (Internal)" RASTER
- PostGIS upgrade is not the issue as I’ve already installed the latest version (3.6.0).
- Executing the very same query (simple ST_IsValid) in PSQL results in unexpected connection close and reconnection.
Sample from the log with error:
2025-09-16 09:44:08.664 UTC [322029] DEBUG: successfully loaded JIT provider in current session
2025-09-16 09:44:08.665 UTC [322028] DEBUG: LLVMJIT detected CPU "skylake-avx512", with features "-avx512pf,-tsxldtrk,+cx16,+sahf,-tbm,-avx512ifma,-sha,+crc32,-fma4,-vpclmulqdq,+prfchw,+bmi2,-cldemote,+fsgsbase,-ptwrite,-amx-tile,-uintr,-gfni,+popcnt,-widekl,+aes,-avx512bitalg,-movdiri,-xsaves,-avx512er,-avxvnni,-avx512fp16,-avx512vnni,-amx-bf16,-avx512vpopcntdq,-pconfig,+clwb,+avx512f,+xsavec,-clzero,-pku,+mmx,-lwp,-rdpid,-xop,+rdseed,-waitpkg,-kl,-movdir64b,-sse4a,+avx512bw,-clflushopt,+xsave,-avx512vbmi2,+64bit,+avx512vl,-serialize,-hreset,+invpcid,+avx512cd,+avx,-vaes,-avx512bf16,+cx8,+fma,+rtm,+bmi,-enqcmd,+rdrnd,-mwaitx,+sse4.1,+sse4.2,+avx2,+fxsr,-wbnoinvd,+sse,+lzcnt,+pclmul,-prefetchwt1,+f16c,+ssse3,-sgx,-shstk,+cmov,-avx512vbmi,-amx-int8,+movbe,-avx512vp2intersect,+xsaveopt,+avx512dq,+sse2,+adx,+sse3"
2025-09-16 09:44:08.665 UTC [322029] DEBUG: LLVMJIT detected CPU "skylake-avx512", with features "-avx512pf,-tsxldtrk,+cx16,+sahf,-tbm,-avx512ifma,-sha,+crc32,-fma4,-vpclmulqdq,+prfchw,+bmi2,-cldemote,+fsgsbase,-ptwrite,-amx-tile,-uintr,-gfni,+popcnt,-widekl,+aes,-avx512bitalg,-movdiri,-xsaves,-avx512er,-avxvnni,-avx512fp16,-avx512vnni,-amx-bf16,-avx512vpopcntdq,-pconfig,+clwb,+avx512f,+xsavec,-clzero,-pku,+mmx,-lwp,-rdpid,-xop,+rdseed,-waitpkg,-kl,-movdir64b,-sse4a,+avx512bw,-clflushopt,+xsave,-avx512vbmi2,+64bit,+avx512vl,-serialize,-hreset,+invpcid,+avx512cd,+avx,-vaes,-avx512bf16,+cx8,+fma,+rtm,+bmi,-enqcmd,+rdrnd,-mwaitx,+sse4.1,+sse4.2,+avx2,+fxsr,-wbnoinvd,+sse,+lzcnt,+pclmul,-prefetchwt1,+f16c,+ssse3,-sgx,-shstk,+cmov,-avx512vbmi,-amx-int8,+movbe,-avx512vp2intersect,+xsaveopt,+avx512dq,+sse2,+adx,+sse3"
2025-09-16 09:44:08.665 UTC [322031] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.665 UTC [322031] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.666 UTC [322031] DEBUG: probing availability of JIT provider at /usr/lib/postgresql/15/lib/llvmjit.so
2025-09-16 09:44:08.666 UTC [322031] DEBUG: successfully loaded JIT provider in current session
2025-09-16 09:44:08.667 UTC [322030] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.667 UTC [322030] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.667 UTC [322031] DEBUG: LLVMJIT detected CPU "skylake-avx512", with features "-avx512pf,-tsxldtrk,+cx16,+sahf,-tbm,-avx512ifma,-sha,+crc32,-fma4,-vpclmulqdq,+prfchw,+bmi2,-cldemote,+fsgsbase,-ptwrite,-amx-tile,-uintr,-gfni,+popcnt,-widekl,+aes,-avx512bitalg,-movdiri,-xsaves,-avx512er,-avxvnni,-avx512fp16,-avx512vnni,-amx-bf16,-avx512vpopcntdq,-pconfig,+clwb,+avx512f,+xsavec,-clzero,-pku,+mmx,-lwp,-rdpid,-xop,+rdseed,-waitpkg,-kl,-movdir64b,-sse4a,+avx512bw,-clflushopt,+xsave,-avx512vbmi2,+64bit,+avx512vl,-serialize,-hreset,+invpcid,+avx512cd,+avx,-vaes,-avx512bf16,+cx8,+fma,+rtm,+bmi,-enqcmd,+rdrnd,-mwaitx,+sse4.1,+sse4.2,+avx2,+fxsr,-wbnoinvd,+sse,+lzcnt,+pclmul,-prefetchwt1,+f16c,+ssse3,-sgx,-shstk,+cmov,-avx512vbmi,-amx-int8,+movbe,-avx512vp2intersect,+xsaveopt,+avx512dq,+sse2,+adx,+sse3"
2025-09-16 09:44:08.667 UTC [322030] DEBUG: probing availability of JIT provider at /usr/lib/postgresql/15/lib/llvmjit.so
2025-09-16 09:44:08.667 UTC [322030] DEBUG: successfully loaded JIT provider in current session
2025-09-16 09:44:08.668 UTC [322030] DEBUG: LLVMJIT detected CPU "skylake-avx512", with features "-avx512pf,-tsxldtrk,+cx16,+sahf,-tbm,-avx512ifma,-sha,+crc32,-fma4,-vpclmulqdq,+prfchw,+bmi2,-cldemote,+fsgsbase,-ptwrite,-amx-tile,-uintr,-gfni,+popcnt,-widekl,+aes,-avx512bitalg,-movdiri,-xsaves,-avx512er,-avxvnni,-avx512fp16,-avx512vnni,-amx-bf16,-avx512vpopcntdq,-pconfig,+clwb,+avx512f,+xsavec,-clzero,-pku,+mmx,-lwp,-rdpid,-xop,+rdseed,-waitpkg,-kl,-movdir64b,-sse4a,+avx512bw,-clflushopt,+xsave,-avx512vbmi2,+64bit,+avx512vl,-serialize,-hreset,+invpcid,+avx512cd,+avx,-vaes,-avx512bf16,+cx8,+fma,+rtm,+bmi,-enqcmd,+rdrnd,-mwaitx,+sse4.1,+sse4.2,+avx2,+fxsr,-wbnoinvd,+sse,+lzcnt,+pclmul,-prefetchwt1,+f16c,+ssse3,-sgx,-shstk,+cmov,-avx512vbmi,-amx-int8,+movbe,-avx512vp2intersect,+xsaveopt,+avx512dq,+sse2,+adx,+sse3"
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.722 UTC [321778] develop at postgres_5432 DEBUG: shmem_exit(-1): 4 before_shmem_exit callbacks to make
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.724 UTC [322028] DEBUG: shmem_exit(-1): 5 before_shmem_exit callbacks to make
2025-09-16 09:44:08.724 UTC [322028] DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.724 UTC [322028] DEBUG: proc_exit(-1): 2 callbacks to make
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.726 UTC [322031] DEBUG: shmem_exit(-1): 5 before_shmem_exit callbacks to make
2025-09-16 09:44:08.726 UTC [322031] DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.726 UTC [322031] DEBUG: proc_exit(-1): 2 callbacks to make
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.728 UTC [322030] DEBUG: shmem_exit(-1): 5 before_shmem_exit callbacks to make
2025-09-16 09:44:08.728 UTC [322030] DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.728 UTC [322030] DEBUG: proc_exit(-1): 2 callbacks to make
2025-09-16 09:44:08.729 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.729 UTC [321583] DEBUG: unregistering background worker "parallel worker for PID 321778"
2025-09-16 09:44:08.729 UTC [321583] LOG: background worker "parallel worker" (PID 322028) exited with exit code 1
2025-09-16 09:44:08.730 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.730 UTC [321583] DEBUG: unregistering background worker "parallel worker for PID 321781"
2025-09-16 09:44:08.730 UTC [321583] LOG: background worker "parallel worker" (PID 322031) exited with exit code 1
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.731 UTC [322029] DEBUG: shmem_exit(-1): 5 before_shmem_exit callbacks to make
2025-09-16 09:44:08.731 UTC [322029] DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.731 UTC [322029] DEBUG: proc_exit(-1): 2 callbacks to make
2025-09-16 09:44:08.732 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.732 UTC [321583] DEBUG: unregistering background worker "parallel worker for PID 321781"
2025-09-16 09:44:08.732 UTC [321583] LOG: background worker "parallel worker" (PID 322030) exited with exit code 1
2025-09-16 09:44:08.736 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.736 UTC [321583] DEBUG: unregistering background worker "parallel worker for PID 321778"
2025-09-16 09:44:08.736 UTC [321583] LOG: background worker "parallel worker" (PID 322029) exited with exit code 1
2025-09-16 09:44:08.738 UTC [321778] develop at postgres_5432 DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.738 UTC [321778] develop at postgres_5432 DEBUG: proc_exit(-1): 3 callbacks to make
2025-09-16 09:44:08.738 UTC [321778] develop at postgres_5432 DEBUG: SSL: write alert (0x0100): "SSL negotiation finished successfully"
error: Not an int attribute (Producer: 'LLVM15.0.7' Reader: 'LLVM 14.0.0')
2025-09-16 09:44:08.744 UTC [321583] DEBUG: forked new backend, pid=322032 socket=8
2025-09-16 09:44:08.744 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.744 UTC [321583] DEBUG: server process (PID 321778) exited with exit code 1
2025-09-16 09:44:08.745 UTC [322032] [unknown]@[unknown] DEBUG: SSL: handshake start: "before SSL initialization"
2025-09-16 09:44:08.745 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "before SSL initialization"
2025-09-16 09:44:08.745 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "before SSL initialization"
2025-09-16 09:44:08.745 UTC [321781] develop at postgres_5432 DEBUG: shmem_exit(-1): 4 before_shmem_exit callbacks to make
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "before SSL initialization"
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read client hello"
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write server hello"
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write change cipher spec"
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.746 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.747 UTC [321781] develop at postgres_5432 DEBUG: shmem_exit(-1): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:08.747 UTC [321781] develop at postgres_5432 DEBUG: proc_exit(-1): 3 callbacks to make
2025-09-16 09:44:08.747 UTC [321781] develop at postgres_5432 DEBUG: SSL: write alert (0x0100): "SSL negotiation finished successfully"
2025-09-16 09:44:08.748 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.748 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read client hello"
2025-09-16 09:44:08.748 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write server hello"
2025-09-16 09:44:08.748 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 write encrypted extensions"
2025-09-16 09:44:08.748 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write certificate"
2025-09-16 09:44:08.749 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 write server certificate verify"
2025-09-16 09:44:08.750 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write finished"
2025-09-16 09:44:08.750 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.750 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.752 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read finished"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: handshake done: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL: accept exit (1): "SSL negotiation finished successfully"
2025-09-16 09:44:08.753 UTC [322032] [unknown]@[unknown] DEBUG: SSL connection from DN:"(anonymous)" CN:"(anonymous)"
2025-09-16 09:44:08.753 UTC [322032] develop at postgres_5432 DEBUG: InitPostgres
2025-09-16 09:44:08.753 UTC [322032] develop at postgres_5432 DEBUG: my backend ID is 152
2025-09-16 09:44:08.753 UTC [322032] develop at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.754 UTC [322032] develop at postgres_5432 DEBUG: processing received SASL response of length 77
2025-09-16 09:44:08.754 UTC [322032] develop at postgres_5432 DEBUG: sending SASL challenge of length 84
2025-09-16 09:44:08.755 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:08.756 UTC [321583] DEBUG: server process (PID 321781) exited with exit code 1
2025-09-16 09:44:08.760 UTC [322032] develop at postgres_5432 DEBUG: processing received SASL response of length 176
2025-09-16 09:44:08.760 UTC [322032] develop at postgres_5432 DEBUG: sending SASL challenge of length 46
2025-09-16 09:44:08.761 UTC [322032] develop at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.762 UTC [321583] DEBUG: forked new backend, pid=322033 socket=8
2025-09-16 09:44:08.763 UTC [322033] [unknown]@[unknown] DEBUG: SSL: handshake start: "before SSL initialization"
2025-09-16 09:44:08.763 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "before SSL initialization"
2025-09-16 09:44:08.763 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "before SSL initialization"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "before SSL initialization"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read client hello"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write server hello"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write change cipher spec"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.765 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.766 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.766 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read client hello"
2025-09-16 09:44:08.767 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write server hello"
2025-09-16 09:44:08.767 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 write encrypted extensions"
2025-09-16 09:44:08.767 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write certificate"
2025-09-16 09:44:08.768 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 write server certificate verify"
2025-09-16 09:44:08.768 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write finished"
2025-09-16 09:44:08.768 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.768 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept exit (-1): "TLSv1.3 early data"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "TLSv1.3 early data"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS read finished"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: handshake done: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept loop: "SSLv3/TLS write session ticket"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL: accept exit (1): "SSL negotiation finished successfully"
2025-09-16 09:44:08.771 UTC [322033] [unknown]@[unknown] DEBUG: SSL connection from DN:"(anonymous)" CN:"(anonymous)"
2025-09-16 09:44:08.772 UTC [322033] develop at postgres_5432 DEBUG: InitPostgres
2025-09-16 09:44:08.772 UTC [322033] develop at postgres_5432 DEBUG: my backend ID is 153
2025-09-16 09:44:08.772 UTC [322033] develop at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:08.773 UTC [322033] develop at postgres_5432 DEBUG: processing received SASL response of length 77
2025-09-16 09:44:08.773 UTC [322033] develop at postgres_5432 DEBUG: sending SASL challenge of length 84
2025-09-16 09:44:08.779 UTC [322033] develop at postgres_5432 DEBUG: processing received SASL response of length 176
2025-09-16 09:44:08.779 UTC [322033] develop at postgres_5432 DEBUG: sending SASL challenge of length 46
2025-09-16 09:44:08.780 UTC [322033] develop at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:09.494 UTC [321795] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:09.494 UTC [321794] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:09.494 UTC [321794] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:09.494 UTC [321795] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.447 UTC [321588] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.447 UTC [321588] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.449 UTC [322034] DEBUG: InitPostgres
2025-09-16 09:44:10.449 UTC [322034] DEBUG: my backend ID is 202
2025-09-16 09:44:10.449 UTC [322034] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.450 UTC [322034] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.450 UTC [322034] DEBUG: autovacuum: processing database "test"
2025-09-16 09:44:10.450 UTC [322034] DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.452 UTC [322034] DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.452 UTC [322034] DEBUG: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-09-16 09:44:10.452 UTC [322034] DEBUG: shmem_exit(0): 7 on_shmem_exit callbacks to make
2025-09-16 09:44:10.452 UTC [322034] DEBUG: proc_exit(0): 1 callbacks to make
2025-09-16 09:44:10.452 UTC [322034] DEBUG: exit(0)
2025-09-16 09:44:10.452 UTC [322034] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-09-16 09:44:10.452 UTC [322034] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-09-16 09:44:10.452 UTC [322034] DEBUG: proc_exit(-1): 0 callbacks to make
2025-09-16 09:44:10.455 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:10.455 UTC [321583] DEBUG: server process (PID 322034) exited with exit code 0
2025-09-16 09:44:10.496 UTC [321794] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.496 UTC [321795] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.496 UTC [321794] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:10.496 UTC [321795] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.482 UTC [321583] DEBUG: forked new backend, pid=322035 socket=8
2025-09-16 09:44:11.483 UTC [322035] postgres at postgres DEBUG: InitPostgres
2025-09-16 09:44:11.483 UTC [322035] postgres at postgres DEBUG: my backend ID is 202
2025-09-16 09:44:11.484 UTC [322035] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.485 UTC [322035] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.485 UTC [322035] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.487 UTC [322035] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: shmem_exit(0): 6 on_shmem_exit callbacks to make
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: proc_exit(0): 2 callbacks to make
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: exit(0)
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-09-16 09:44:11.488 UTC [322035] postgres at postgres DEBUG: proc_exit(-1): 0 callbacks to make
2025-09-16 09:44:11.491 UTC [321583] DEBUG: reaping dead processes
2025-09-16 09:44:11.491 UTC [321583] DEBUG: server process (PID 322035) exited with exit code 0
2025-09-16 09:44:11.496 UTC [321794] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.496 UTC [321795] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.496 UTC [321794] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:11.496 UTC [321795] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.497 UTC [321794] postgres at postgres DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.497 UTC [321795] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.497 UTC [321794] postgres at postgres DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.497 UTC [321795] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.592 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.592 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.592 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.592 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.593 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.593 UTC [321583] DEBUG: forked new backend, pid=322039 socket=8
2025-09-16 09:44:12.594 UTC [322039] postgres at postgres_5432 DEBUG: InitPostgres
2025-09-16 09:44:12.594 UTC [322039] postgres at postgres_5432 DEBUG: my backend ID is 202
2025-09-16 09:44:12.594 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.594 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.595 UTC [322039] postgres at postgres_5432 DEBUG: processing received SASL response of length 58
2025-09-16 09:44:12.595 UTC [322039] postgres at postgres_5432 DEBUG: sending SASL challenge of length 84
2025-09-16 09:44:12.595 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.597 UTC [322039] postgres at postgres_5432 DEBUG: processing received SASL response of length 104
2025-09-16 09:44:12.597 UTC [322039] postgres at postgres_5432 DEBUG: sending SASL challenge of length 46
2025-09-16 09:44:12.598 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.599 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.599 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.599 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.602 UTC [322039] postgres at postgres_5432 DEBUG: probing availability of JIT provider at /usr/lib/postgresql/15/lib/llvmjit.so
2025-09-16 09:44:12.606 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.606 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.612 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.612 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.613 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.613 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.614 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.614 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.615 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.615 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.615 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.615 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.617 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.617 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.618 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.618 UTC [321757] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.621 UTC [322039] postgres at postgres_5432 DEBUG: successfully loaded JIT provider in current session
2025-09-16 09:44:12.622 UTC [322039] postgres at postgres_5432 DEBUG: LLVMJIT detected CPU "skylake-avx512", with features "-avx512pf,-tsxldtrk,+cx16,+sahf,-tbm,-avx512ifma,-sha,+crc32,-fma4,-vpclmulqdq,+prfchw,+bmi2,-cldemote,+fsgsbase,-ptwrite,-amx-tile,-uintr,-gfni,+popcnt,-widekl,+aes,-avx512bitalg,-movdiri,-xsaves,-avx512er,-avxvnni,-avx512fp16,-avx512vnni,-amx-bf16,-avx512vpopcntdq,-pconfig,+clwb,+avx512f,+xsavec,-clzero,-pku,+mmx,-lwp,-rdpid,-xop,+rdseed,-waitpkg,-kl,-movdir64b,-sse4a,+avx512bw,-clflushopt,+xsave,-avx512vbmi2,+64bit,+avx512vl,-serialize,-hreset,+invpcid,+avx512cd,+avx,-vaes,-avx512bf16,+cx8,+fma,+rtm,+bmi,-enqcmd,+rdrnd,-mwaitx,+sse4.1,+sse4.2,+avx2,+fxsr,-wbnoinvd,+sse,+lzcnt,+pclmul,-prefetchwt1,+f16c,+ssse3,-sgx,-shstk,+cmov,-avx512vbmi,-amx-int8,+movbe,-avx512vp2intersect,+xsaveopt,+avx512dq,+sse2,+adx,+sse3"
2025-09-16 09:44:12.626 UTC [322039] postgres at postgres_5432 DEBUG: time to inline: 0.000s, opt: 0.001s, emit: 0.000s
2025-09-16 09:44:12.669 UTC [321757] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.689 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.703 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.704 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.704 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.706 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.706 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.706 UTC [322039] postgres at postgres_5432 DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.707 UTC [322039] postgres at postgres_5432 DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-09-16 09:44:12.734 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 32 for pg_index; 129 tups, 64 buckets
2025-09-16 09:44:12.736 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 7 for pg_attribute; 257 tups, 128 buckets
2025-09-16 09:44:12.740 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 32 for pg_index; 257 tups, 128 buckets
2025-09-16 09:44:12.744 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 7 for pg_attribute; 513 tups, 256 buckets
2025-09-16 09:44:12.749 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 32 for pg_index; 513 tups, 256 buckets
2025-09-16 09:44:12.760 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 7 for pg_attribute; 1025 tups, 512 buckets
2025-09-16 09:44:12.765 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 55 for pg_class; 257 tups, 128 buckets
2025-09-16 09:44:12.768 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 32 for pg_index; 1025 tups, 512 buckets
2025-09-16 09:44:12.792 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 7 for pg_attribute; 2049 tups, 1024 buckets
2025-09-16 09:44:12.801 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 55 for pg_class; 513 tups, 256 buckets
2025-09-16 09:44:12.806 UTC [322039] postgres at postgres_5432 DEBUG: rehashing catalog cache id 32
--
С уважением,
Ярослав Минин
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250916/151c20ed/attachment.htm>
More information about the postgis-users
mailing list