backend error after upgrading to 3.6.0
Regina Obe
lr at pcorp.us
Tue Sep 16 10:53:40 PDT 2025
I think JIT uses LLVM under the hood. So my guess your issue is what you originally thought the incompatibility with LLVM 14 vs. 15. Turning off JIT probably just prevents LLVM from being used. So fix the packaging incompatibility and you can probably turn it back on.
From: Ярослав Минин <yaras_phoenix at inbox.ru>
Sent: Tuesday, September 16, 2025 1:41 PM
To: Regina Obe <lr at pcorp.us>
Cc: postgis-users <postgis-users at lists.osgeo.org>
Subject: Re: RE: backend error after upgrading to 3.6.0
I've already tried and with JIT off it works.
"Also did you only upgrade PostGIS or did you upgrade PostgreSQL as well."
PostGIS only. PostgreSQL stayed the same.
I guess there are some scenarios when active JIT is preferable which leads me to the following question: is there any chance to know which PostGIS version will work for me or just experimentally?
--
Sincerely,
Yaras
вторник, 16 сентября 2025г., 17:36 +02:00 от Regina Obe lr at pcorp.us <mailto:lr at pcorp.us> :
I know we’ve had issues with jit in the past slowing things down or other issues and somewhere along the line they defaulted jit to be on. Before it used to be by default off.
Can you try disabling JIT and then run the query again.
SET jit = off;
Rerun your query:
Also did you only upgrade PostGIS or did you upgrade PostgreSQL as well.
If you don’t need jit at all, I’d suggest just turning it off systemwide.
ALTER SYSTEM set jit = off;
SELECT pg_reload_conf();
From: Ярослав Минин via postgis-users <postgis-users at lists.osgeo.org <https://e.mail.ru/compose?To=postgis%2dusers@lists.osgeo.org> >
Sent: Tuesday, September 16, 2025 10:48 AM
To: postgis-users <postgis-users at lists.osgeo.org <https://e.mail.ru/compose?To=postgis%2dusers@lists.osgeo.org> >
Subject: backend error after upgrading to 3.6.0
- Versions:
PostgreSQL 15.3 (Ubuntu 15.3-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~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/> 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/2a9898ec/attachment.htm>
More information about the postgis-users
mailing list