2024-03-16 00:10:27.303 UTC [31396][postmaster] LOG: starting PostgreSQL 17devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-03-16 00:10:27.303 UTC [31396][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-EB827p/.s.PGSQL.55312" 2024-03-16 00:10:27.314 UTC [31430][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:27.314 UTC [31430][client backend] [[unknown]][:0] FATAL: the database system is starting up 2024-03-16 00:10:27.321 UTC [31429][startup] LOG: database system was shut down at 2024-03-16 00:09:09 UTC 2024-03-16 00:10:27.329 UTC [31396][postmaster] LOG: database system is ready to accept connections 2024-03-16 00:10:27.370 UTC [31455][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:27.371 UTC [31455][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:27.371 UTC [31455][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-03-16 00:10:27.388 UTC [31455][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-03-16 00:10:27.406 UTC [31468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:27.407 UTC [31468][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:27.407 UTC [31468][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-03-16 00:10:27.458 UTC [31468][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.053 user=postgres database=postgres host=[local] 2024-03-16 00:10:27.482 UTC [31491][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:27.483 UTC [31491][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:27.483 UTC [31491][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/select AddressSanitizer:DEADLYSIGNAL ================================================================= ==31491==ERROR: AddressSanitizer: SEGV on unknown address 0x0000001a69e8 (pc 0x560c2c15f762 bp 0x62d0001a6a58 sp 0x7fff4e6d9ac0 T0) ==31491==The signal is caused by a READ memory access. #0 0x560c2c15f762 in get_expr_width /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6328 #1 0x560c2c173485 in set_pathtarget_cost_width /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6299 #2 0x560c2c1d5450 in make_group_input_target /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:5479 #3 0x560c2c1e84fc in grouping_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:1577 #4 0x560c2c1ec273 in subquery_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:1084 #5 0x560c2c1ed24e in standard_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:412 #6 0x7fe61ef39f15 in pgss_planner /tmp/cirrus-ci-build/contrib/pg_stat_statements/pg_stat_statements.c:926 #7 0x560c2c1ee88a in planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:278 #8 0x560c2c4579c6 in pg_plan_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:904 #9 0x560c2c457d53 in pg_plan_queries /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:996 #10 0x560c2c4586dd in exec_simple_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:1193 #11 0x560c2c45c473 in PostgresMain /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:4680 #12 0x560c2c2a9a7e in BackendRun /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:4452 #13 0x560c2c2af19f in BackendStartup /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:4117 #14 0x560c2c2af63b in ServerLoop /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1780 #15 0x560c2c2b18d6 in PostmasterMain /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1478 #16 0x560c2c057820 in main /tmp/cirrus-ci-build/src/backend/main/main.c:197 #17 0x7fe62438dd09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #18 0x560c2b9fa469 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres+0x3fd469) AddressSanitizer can not provide additional info. SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6328 in get_expr_width ==31491==ABORTING 2024-03-16 00:10:28.229 UTC [31790][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.230 UTC [31790][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.230 UTC [31790][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/dml 2024-03-16 00:10:28.279 UTC [31790][client backend] [pg_regress/dml][:0] LOG: disconnection: session time: 0:00:00.050 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.307 UTC [31820][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.308 UTC [31820][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.308 UTC [31820][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/cursors 2024-03-16 00:10:28.319 UTC [31820][client backend] [pg_regress/cursors][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.360 UTC [31838][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.361 UTC [31838][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.361 UTC [31838][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/utility 2024-03-16 00:10:28.554 UTC [31838][client backend] [pg_regress/utility][:0] LOG: disconnection: session time: 0:00:00.194 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.594 UTC [31894][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.595 UTC [31894][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.595 UTC [31894][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/level_tracking 2024-03-16 00:10:28.638 UTC [31894][client backend] [pg_regress/level_tracking][:0] LOG: disconnection: session time: 0:00:00.047 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.693 UTC [31933][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.702 UTC [31933][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.702 UTC [31933][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/planning 2024-03-16 00:10:28.728 UTC [31933][client backend] [pg_regress/planning][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.785 UTC [31955][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.786 UTC [31955][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.786 UTC [31955][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/user_activity 2024-03-16 00:10:28.830 UTC [31955][client backend] [pg_regress/user_activity][:0] LOG: disconnection: session time: 0:00:00.046 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.891 UTC [31974][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.916 UTC [31974][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.916 UTC [31974][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/wal 2024-03-16 00:10:28.950 UTC [31974][client backend] [pg_regress/wal][:0] LOG: disconnection: session time: 0:00:00.060 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:28.997 UTC [31991][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:28.998 UTC [31991][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:28.998 UTC [31991][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/entry_timestamp 2024-03-16 00:10:29.029 UTC [31991][client backend] [pg_regress/entry_timestamp][:0] LOG: disconnection: session time: 0:00:00.032 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:29.109 UTC [32011][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:29.110 UTC [32011][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:29.110 UTC [32011][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/cleanup 2024-03-16 00:10:29.133 UTC [32011][client backend] [pg_regress/cleanup][:0] LOG: disconnection: session time: 0:00:00.028 user=postgres database=contrib_regression host=[local] 2024-03-16 00:10:29.191 UTC [32022][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-16 00:10:29.194 UTC [32022][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_stat_statements/tmp_check/data/pg_hba.conf:117) 2024-03-16 00:10:29.195 UTC [32022][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/oldextversions 2024-03-16 00:10:29.212 UTC [32022][client backend] [pg_regress/oldextversions][12/4:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-16 00:10:29.212 UTC [32022][client backend] [pg_regress/oldextversions][12/4:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-16 00:10:29.219 UTC [32022][client backend] [pg_regress/oldextversions][12/12:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-16 00:10:29.219 UTC [32022][client backend] [pg_regress/oldextversions][12/12:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-16 00:10:29.224 UTC [32022][client backend] [pg_regress/oldextversions][12/17:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-16 00:10:29.224 UTC [32022][client backend] [pg_regress/oldextversions][12/17:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-16 00:10:29.249 UTC [31396][postmaster] LOG: server process (PID 31491) was terminated by signal 6: Aborted 2024-03-16 00:10:29.249 UTC [31396][postmaster] DETAIL: Failed process was running: SELECT a, b, c FROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c) GROUP BY ROLLUP(a, b), rollup(a, c) ORDER BY a, b, c; 2024-03-16 00:10:29.249 UTC [31396][postmaster] LOG: terminating any other active server processes 2024-03-16 00:10:29.265 UTC [31396][postmaster] LOG: shutting down because restart_after_crash is off 2024-03-16 00:10:29.277 UTC [31396][postmaster] LOG: database system is shut down