2025-03-31 05:12:09.132 GMT [5048][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30159, 64-bit 2025-03-31 05:12:09.135 GMT [5048][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/mNijQRxR2L/.s.PGSQL.22728" 2025-03-31 05:12:09.175 GMT [692][startup] LOG: database system was shut down at 2025-03-31 05:02:00 GMT 2025-03-31 05:12:09.183 GMT [5048][postmaster] LOG: database system is ready to accept connections 2025-03-31 05:12:09.333 GMT [2452][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.334 GMT [2452][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.335 GMT [2452][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.353 GMT [2452][client backend] [090_reindexdb.pl][0/2:0] LOG: statement: CREATE TABLESPACE reindex_tbspace LOCATION 'C:\cirrus\build/testrun/scripts/090_reindexdb\data/t_090_reindexdb_main_data/regress_reindex_tbspace'; 2025-03-31 05:12:09.355 GMT [2452][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.437 GMT [6484][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.439 GMT [6484][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.439 GMT [6484][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.442 GMT [6484][client backend] [090_reindexdb.pl][1/2:0] LOG: statement: CREATE TABLE test1 (a text); 2025-03-31 05:12:09.452 GMT [6484][client backend] [090_reindexdb.pl][1/3:0] LOG: statement: CREATE INDEX test1x ON test1 (a); 2025-03-31 05:12:09.455 GMT [6484][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.554 GMT [5256][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.556 GMT [5256][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.556 GMT [5256][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.559 GMT [5256][client backend] [090_reindexdb.pl][2/2:0] LOG: statement: SELECT reltoastrelid::regclass FROM pg_class WHERE oid = 'test1'::regclass; 2025-03-31 05:12:09.565 GMT [5256][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.666 GMT [5400][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.667 GMT [5400][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.667 GMT [5400][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.670 GMT [5400][client backend] [090_reindexdb.pl][3/2:0] LOG: statement: SELECT indexrelid::regclass FROM pg_index WHERE indrelid = 'pg_toast.pg_toast_16385'::regclass; 2025-03-31 05:12:09.674 GMT [5400][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.769 GMT [5248][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.770 GMT [5248][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.770 GMT [5248][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.773 GMT [5248][client backend] [090_reindexdb.pl][4/2:0] LOG: statement: CREATE TABLE index_relfilenodes (parent regclass, indname text, indoid oid, relfilenode oid); 2025-03-31 05:12:09.780 GMT [5248][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.863 GMT [1652][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.864 GMT [1652][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.864 GMT [1652][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.868 GMT [1652][client backend] [090_reindexdb.pl][5/2:0] LOG: statement: INSERT INTO index_relfilenodes SELECT b.oid::regclass, c.oid::regclass::text, c.oid, c.relfilenode FROM pg_class a JOIN pg_class b ON (a.oid = b.reltoastrelid) JOIN pg_index i on (a.oid = i.indrelid) JOIN pg_class c on (i.indexrelid = c.oid) WHERE b.oid IN ('pg_constraint'::regclass, 'test1'::regclass); 2025-03-31 05:12:09.873 GMT [1652][client backend] [090_reindexdb.pl][5/3:0] LOG: statement: INSERT INTO index_relfilenodes SELECT i.indrelid, a.oid::regclass::text, a.oid, a.relfilenode FROM pg_class a JOIN pg_index i ON (i.indexrelid = a.oid) WHERE a.relname IN ('pg_constraint_oid_index', 'test1x'); 2025-03-31 05:12:09.875 GMT [1652][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:09.963 GMT [6032][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:09.965 GMT [6032][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:09.965 GMT [6032][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:09.969 GMT [6032][client backend] [090_reindexdb.pl][6/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:09.970 GMT [6032][client backend] [090_reindexdb.pl][6/3:0] LOG: statement: REINDEX DATABASE postgres; 2025-03-31 05:12:09.986 GMT [6032][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:10.243 GMT [7024][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:10.244 GMT [7024][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:10.244 GMT [7024][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:10.248 GMT [7024][client backend] [090_reindexdb.pl][7/2:0] LOG: statement: SELECT b.parent::regclass, regexp_replace(b.indname::text, '(pg_toast.pg_toast_)\d+(_index)', '\1\2'), CASE WHEN a.oid = b.indoid THEN 'OID is unchanged' ELSE 'OID has changed' END, CASE WHEN a.relfilenode = b.relfilenode THEN 'relfilenode is unchanged' ELSE 'relfilenode has changed' END FROM index_relfilenodes b JOIN pg_class a ON b.indname::text = a.oid::regclass::text ORDER BY b.parent::text, b.indname::text 2025-03-31 05:12:10.264 GMT [7024][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:10.340 GMT [6292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:10.341 GMT [6292][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:10.341 GMT [6292][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:10.346 GMT [6292][client backend] [090_reindexdb.pl][8/2:0] LOG: statement: TRUNCATE index_relfilenodes; 2025-03-31 05:12:10.353 GMT [6292][client backend] [090_reindexdb.pl][8/3:0] LOG: statement: INSERT INTO index_relfilenodes SELECT b.oid::regclass, c.oid::regclass::text, c.oid, c.relfilenode FROM pg_class a JOIN pg_class b ON (a.oid = b.reltoastrelid) JOIN pg_index i on (a.oid = i.indrelid) JOIN pg_class c on (i.indexrelid = c.oid) WHERE b.oid IN ('pg_constraint'::regclass, 'test1'::regclass); 2025-03-31 05:12:10.358 GMT [6292][client backend] [090_reindexdb.pl][8/4:0] LOG: statement: INSERT INTO index_relfilenodes SELECT i.indrelid, a.oid::regclass::text, a.oid, a.relfilenode FROM pg_class a JOIN pg_index i ON (i.indexrelid = a.oid) WHERE a.relname IN ('pg_constraint_oid_index', 'test1x'); 2025-03-31 05:12:10.360 GMT [6292][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:10.451 GMT [7520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:10.452 GMT [7520][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:10.452 GMT [7520][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:10.459 GMT [7520][client backend] [090_reindexdb.pl][9/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:10.460 GMT [7520][client backend] [090_reindexdb.pl][9/3:0] LOG: statement: REINDEX SYSTEM postgres; 2025-03-31 05:12:11.033 GMT [7520][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.586 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:11.171 GMT [5204][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:11.172 GMT [5204][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:11.172 GMT [5204][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:11.202 GMT [5204][client backend] [090_reindexdb.pl][10/2:0] LOG: statement: SELECT b.parent::regclass, regexp_replace(b.indname::text, '(pg_toast.pg_toast_)\d+(_index)', '\1\2'), CASE WHEN a.oid = b.indoid THEN 'OID is unchanged' ELSE 'OID has changed' END, CASE WHEN a.relfilenode = b.relfilenode THEN 'relfilenode is unchanged' ELSE 'relfilenode has changed' END FROM index_relfilenodes b JOIN pg_class a ON b.indname::text = a.oid::regclass::text ORDER BY b.parent::text, b.indname::text 2025-03-31 05:12:11.216 GMT [5204][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:11.320 GMT [7444][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:11.322 GMT [7444][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:11.322 GMT [7444][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:11.325 GMT [7444][client backend] [090_reindexdb.pl][11/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.326 GMT [7444][client backend] [090_reindexdb.pl][11/3:0] LOG: statement: RESET search_path; 2025-03-31 05:12:11.326 GMT [7444][client backend] [090_reindexdb.pl][11/4:0] LOG: statement: SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace ns WHERE c.relnamespace OPERATOR(pg_catalog.=) ns.oid AND c.oid OPERATOR(pg_catalog.=) 'test1'::pg_catalog.regclass; 2025-03-31 05:12:11.335 GMT [7444][client backend] [090_reindexdb.pl][11/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.336 GMT [7444][client backend] [090_reindexdb.pl][11/6:0] LOG: statement: REINDEX TABLE public.test1; 2025-03-31 05:12:11.343 GMT [7444][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:11.454 GMT [6636][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:11.455 GMT [6636][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:11.455 GMT [6636][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:11.458 GMT [6636][client backend] [090_reindexdb.pl][12/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.459 GMT [6636][client backend] [090_reindexdb.pl][12/3:0] LOG: statement: RESET search_path; 2025-03-31 05:12:11.459 GMT [6636][client backend] [090_reindexdb.pl][12/4:0] LOG: statement: SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace ns WHERE c.relnamespace OPERATOR(pg_catalog.=) ns.oid AND c.oid OPERATOR(pg_catalog.=) 'test1'::pg_catalog.regclass; 2025-03-31 05:12:11.463 GMT [6636][client backend] [090_reindexdb.pl][12/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.463 GMT [6636][client backend] [090_reindexdb.pl][12/6:0] LOG: statement: REINDEX (TABLESPACE reindex_tbspace) TABLE public.test1; 2025-03-31 05:12:11.473 GMT [6636][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:11.542 GMT [1164][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:11.548 GMT [1164][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:11.548 GMT [1164][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:11.551 GMT [1164][client backend] [090_reindexdb.pl][13/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.552 GMT [1164][client backend] [090_reindexdb.pl][13/3:0] LOG: statement: RESET search_path; 2025-03-31 05:12:11.552 GMT [1164][client backend] [090_reindexdb.pl][13/4:0] LOG: statement: SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace ns WHERE c.relnamespace OPERATOR(pg_catalog.=) ns.oid AND c.oid OPERATOR(pg_catalog.=) 'test1x'::pg_catalog.regclass; 2025-03-31 05:12:11.556 GMT [1164][client backend] [090_reindexdb.pl][13/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.556 GMT [1164][client backend] [090_reindexdb.pl][13/6:0] LOG: statement: REINDEX INDEX public.test1x; 2025-03-31 05:12:11.567 GMT [1164][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:11.705 GMT [5012][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:11.707 GMT [5012][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:11.707 GMT [5012][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:11.710 GMT [5012][client backend] [090_reindexdb.pl][14/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:11.710 GMT [5012][client backend] [090_reindexdb.pl][14/3:0] LOG: statement: REINDEX SCHEMA pg_catalog; 2025-03-31 05:12:12.331 GMT [5012][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.629 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:12.428 GMT [872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:12.430 GMT [872][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:12.430 GMT [872][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:12.457 GMT [872][client backend] [090_reindexdb.pl][15/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:12.457 GMT [872][client backend] [090_reindexdb.pl][15/3:0] LOG: statement: RESET search_path; 2025-03-31 05:12:12.458 GMT [872][client backend] [090_reindexdb.pl][15/4:0] LOG: statement: SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace ns WHERE c.relnamespace OPERATOR(pg_catalog.=) ns.oid AND c.oid OPERATOR(pg_catalog.=) 'test1'::pg_catalog.regclass; 2025-03-31 05:12:12.461 GMT [872][client backend] [090_reindexdb.pl][15/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:12.461 GMT [872][client backend] [090_reindexdb.pl][15/6:0] LOG: statement: REINDEX (VERBOSE) TABLE public.test1; 2025-03-31 05:12:12.471 GMT [872][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.046 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:12.548 GMT [5856][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:12.550 GMT [5856][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:12.550 GMT [5856][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:12.553 GMT [5856][client backend] [090_reindexdb.pl][16/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:12.553 GMT [5856][client backend] [090_reindexdb.pl][16/3:0] LOG: statement: RESET search_path; 2025-03-31 05:12:12.553 GMT [5856][client backend] [090_reindexdb.pl][16/4:0] LOG: statement: SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace ns WHERE c.relnamespace OPERATOR(pg_catalog.=) ns.oid AND c.oid OPERATOR(pg_catalog.=) 'test1'::pg_catalog.regclass; 2025-03-31 05:12:12.557 GMT [5856][client backend] [090_reindexdb.pl][16/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:12.557 GMT [5856][client backend] [090_reindexdb.pl][16/6:0] LOG: statement: REINDEX (VERBOSE, TABLESPACE reindex_tbspace) TABLE public.test1; 2025-03-31 05:12:12.566 GMT [5856][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:12.683 GMT [4200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:12.684 GMT [4200][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:12.684 GMT [4200][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:12.688 GMT [4200][client backend] [090_reindexdb.pl][17/2:0] LOG: statement: TRUNCATE index_relfilenodes; 2025-03-31 05:12:12.694 GMT [4200][client backend] [090_reindexdb.pl][17/3:0] LOG: statement: INSERT INTO index_relfilenodes SELECT b.oid::regclass, c.oid::regclass::text, c.oid, c.relfilenode FROM pg_class a JOIN pg_class b ON (a.oid = b.reltoastrelid) JOIN pg_index i on (a.oid = i.indrelid) JOIN pg_class c on (i.indexrelid = c.oid) WHERE b.oid IN ('pg_constraint'::regclass, 'test1'::regclass); 2025-03-31 05:12:12.699 GMT [4200][client backend] [090_reindexdb.pl][17/4:0] LOG: statement: INSERT INTO index_relfilenodes SELECT i.indrelid, a.oid::regclass::text, a.oid, a.relfilenode FROM pg_class a JOIN pg_index i ON (i.indexrelid = a.oid) WHERE a.relname IN ('pg_constraint_oid_index', 'test1x'); 2025-03-31 05:12:12.707 GMT [4200][client backend] [090_reindexdb.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2025-03-31 05:12:12.809 GMT [7504][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-31 05:12:12.810 GMT [7504][client backend] [[unknown]][18/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/090_reindexdb/data/t_090_reindexdb_main_data/pgdata/pg_hba.conf:117) 2025-03-31 05:12:12.810 GMT [7504][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=090_reindexdb.pl 2025-03-31 05:12:12.813 GMT [7504][client backend] [090_reindexdb.pl][18/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-03-31 05:12:12.814 GMT [7504][client backend] [090_reindexdb.pl][18/3:0] LOG: statement: REINDEX DATABASE CONCURRENTLY postgres; TRAP: failed Assert("!TransactionIdIsValid(MyProc->xmin)"), File: "../src/backend/catalog/index.c", Line: 3703, PID: 7504 abort() has been called2025-03-31 05:12:14.046 GMT [5048][postmaster] LOG: client backend (PID 7504) was terminated by exception 0xC0000354 2025-03-31 05:12:14.046 GMT [5048][postmaster] DETAIL: Failed process was running: REINDEX DATABASE CONCURRENTLY postgres; 2025-03-31 05:12:14.046 GMT [5048][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2025-03-31 05:12:14.046 GMT [5048][postmaster] LOG: terminating any other active server processes 2025-03-31 05:12:14.066 GMT [5048][postmaster] LOG: shutting down because "restart_after_crash" is off 2025-03-31 05:12:14.067 GMT [5048][postmaster] LOG: database system is shut down