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 l...@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@lists.osgeo.org> >Sent: Tuesday, September 16, 2025 10:48 AM >To: postgis-users < postgis-users@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 - 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@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@postgres_5432 DEBUG: >shmem_exit(-1): 6 on_shmem_exit callbacks to make >2025-09-16 09:44:08.738 UTC [321778] develop@postgres_5432 DEBUG: >proc_exit(-1): 3 callbacks to make >2025-09-16 09:44:08.738 UTC [321778] develop@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@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@postgres_5432 DEBUG: >shmem_exit(-1): 6 on_shmem_exit callbacks to make >2025-09-16 09:44:08.747 UTC [321781] develop@postgres_5432 DEBUG: >proc_exit(-1): 3 callbacks to make >2025-09-16 09:44:08.747 UTC [321781] develop@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@postgres_5432 DEBUG: InitPostgres >2025-09-16 09:44:08.753 UTC [322032] develop@postgres_5432 DEBUG: my backend >ID is 152 >2025-09-16 09:44:08.753 UTC [322032] develop@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@postgres_5432 DEBUG: processing >received SASL response of length 77 >2025-09-16 09:44:08.754 UTC [322032] develop@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@postgres_5432 DEBUG: processing >received SASL response of length 176 >2025-09-16 09:44:08.760 UTC [322032] develop@postgres_5432 DEBUG: sending >SASL challenge of length 46 >2025-09-16 09:44:08.761 UTC [322032] develop@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@postgres_5432 DEBUG: InitPostgres >2025-09-16 09:44:08.772 UTC [322033] develop@postgres_5432 DEBUG: my backend >ID is 153 >2025-09-16 09:44:08.772 UTC [322033] develop@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@postgres_5432 DEBUG: processing >received SASL response of length 77 >2025-09-16 09:44:08.773 UTC [322033] develop@postgres_5432 DEBUG: sending >SASL challenge of length 84 >2025-09-16 09:44:08.779 UTC [322033] develop@postgres_5432 DEBUG: processing >received SASL response of length 176 >2025-09-16 09:44:08.779 UTC [322033] develop@postgres_5432 DEBUG: sending >SASL challenge of length 46 >2025-09-16 09:44:08.780 UTC [322033] develop@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@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@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@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@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@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@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@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@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@postgres DEBUG: InitPostgres >2025-09-16 09:44:11.483 UTC [322035] postgres@postgres DEBUG: my backend ID >is 202 >2025-09-16 09:44:11.484 UTC [322035] postgres@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@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@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@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@postgres DEBUG: shmem_exit(0): >4 before_shmem_exit callbacks to make >2025-09-16 09:44:11.488 UTC [322035] postgres@postgres DEBUG: shmem_exit(0): >6 on_shmem_exit callbacks to make >2025-09-16 09:44:11.488 UTC [322035] postgres@postgres DEBUG: proc_exit(0): 2 >callbacks to make >2025-09-16 09:44:11.488 UTC [322035] postgres@postgres DEBUG: exit(0) >2025-09-16 09:44:11.488 UTC [322035] postgres@postgres DEBUG: shmem_exit(-1): >0 before_shmem_exit callbacks to make >2025-09-16 09:44:11.488 UTC [322035] postgres@postgres DEBUG: shmem_exit(-1): >0 on_shmem_exit callbacks to make >2025-09-16 09:44:11.488 UTC [322035] postgres@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@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@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@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@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@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@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@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@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@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@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@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@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@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@postgres_5432 DEBUG: >InitPostgres >2025-09-16 09:44:12.594 UTC [322039] postgres@postgres_5432 DEBUG: my backend >ID is 202 >2025-09-16 09:44:12.594 UTC [321757] postgres@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@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@postgres_5432 DEBUG: processing >received SASL response of length 58 >2025-09-16 09:44:12.595 UTC [322039] postgres@postgres_5432 DEBUG: sending >SASL challenge of length 84 >2025-09-16 09:44:12.595 UTC [321757] postgres@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@postgres_5432 DEBUG: processing >received SASL response of length 104 >2025-09-16 09:44:12.597 UTC [322039] postgres@postgres_5432 DEBUG: sending >SASL challenge of length 46 >2025-09-16 09:44:12.598 UTC [322039] postgres@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@postgres_5432 DEBUG: >successfully loaded JIT provider in current session >2025-09-16 09:44:12.622 UTC [322039] postgres@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@postgres_5432 DEBUG: time to >inline: 0.000s, opt: 0.001s, emit: 0.000s >2025-09-16 09:44:12.669 UTC [321757] postgres@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@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@postgres_5432 DEBUG: rehashing >catalog cache id 32 > >-- >С уважением, >Ярослав Минин
