2024-03-23 20:27:18.668 UTC [33404][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-23 20:27:18.668 UTC [33404][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-ZuaRR7/.s.PGSQL.55312" 2024-03-23 20:27:18.698 UTC [33413][startup] LOG: database system was shut down at 2024-03-23 20:25:53 UTC 2024-03-23 20:27:18.713 UTC [33414][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:18.713 UTC [33414][client backend] [[unknown]][:0] FATAL: the database system is starting up 2024-03-23 20:27:18.720 UTC [33404][postmaster] LOG: database system is ready to accept connections 2024-03-23 20:27:18.779 UTC [33420][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:18.780 UTC [33420][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-23 20:27:18.780 UTC [33420][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-03-23 20:27:18.819 UTC [33420][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.040 user=postgres database=postgres host=[local] 2024-03-23 20:27:18.841 UTC [33443][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:18.842 UTC [33443][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-23 20:27:18.842 UTC [33443][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-03-23 20:27:18.898 UTC [33443][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.057 user=postgres database=postgres host=[local] 2024-03-23 20:27:18.920 UTC [33454][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:18.921 UTC [33454][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-23 20:27:18.921 UTC [33454][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/select AddressSanitizer:DEADLYSIGNAL ================================================================= ==33454==ERROR: AddressSanitizer: SEGV on unknown address 0x0000001a69e8 (pc 0x55ef6c2e6b0c bp 0x62d0001a6a58 sp 0x7fff7ba62370 T0) ==33454==The signal is caused by a READ memory access. #0 0x55ef6c2e6b0c in get_expr_width /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6329 #1 0x55ef6c2fa729 in set_pathtarget_cost_width /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6300 #2 0x55ef6c35c77b in make_group_input_target /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:5479 #3 0x55ef6c36f816 in grouping_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:1577 #4 0x55ef6c373583 in subquery_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:1084 #5 0x55ef6c37455e in standard_planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:412 #6 0x7fe47a917f15 in pgss_planner /tmp/cirrus-ci-build/contrib/pg_stat_statements/pg_stat_statements.c:926 #7 0x55ef6c375b9a in planner /tmp/cirrus-ci-build/src/backend/optimizer/plan/planner.c:278 #8 0x55ef6c5dfc17 in pg_plan_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:904 #9 0x55ef6c5dffa4 in pg_plan_queries /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:996 #10 0x55ef6c5e092e in exec_simple_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:1193 #11 0x55ef6c5e46c4 in PostgresMain /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:4680 #12 0x55ef6c5d707e in BackendMain /tmp/cirrus-ci-build/src/backend/tcop/backend_startup.c:101 #13 0x55ef6c42cf90 in postmaster_child_launch /tmp/cirrus-ci-build/src/backend/postmaster/launch_backend.c:265 #14 0x55ef6c434b39 in BackendStartup /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:3593 #15 0x55ef6c43524d in ServerLoop /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1674 #16 0x55ef6c4374ed in PostmasterMain /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1372 #17 0x55ef6c1da68c in main /tmp/cirrus-ci-build/src/backend/main/main.c:197 #18 0x7fe47fd6cd09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #19 0x55ef6bb6a469 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres+0x402469) AddressSanitizer can not provide additional info. SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/backend/optimizer/path/costsize.c:6329 in get_expr_width ==33454==ABORTING 2024-03-23 20:27:19.495 UTC [33519][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.496 UTC [33519][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-23 20:27:19.496 UTC [33519][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/dml 2024-03-23 20:27:19.556 UTC [33519][client backend] [pg_regress/dml][:0] LOG: disconnection: session time: 0:00:00.061 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:19.588 UTC [33535][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.588 UTC [33535][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-23 20:27:19.588 UTC [33535][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/cursors 2024-03-23 20:27:19.611 UTC [33535][client backend] [pg_regress/cursors][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:19.650 UTC [33553][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.652 UTC [33553][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-23 20:27:19.652 UTC [33553][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/utility 2024-03-23 20:27:19.833 UTC [33553][client backend] [pg_regress/utility][:0] LOG: disconnection: session time: 0:00:00.183 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:19.865 UTC [33601][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.866 UTC [33601][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-23 20:27:19.866 UTC [33601][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/level_tracking 2024-03-23 20:27:19.899 UTC [33601][client backend] [pg_regress/level_tracking][:0] LOG: disconnection: session time: 0:00:00.036 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:19.916 UTC [33616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.917 UTC [33616][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-23 20:27:19.917 UTC [33616][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/planning 2024-03-23 20:27:19.941 UTC [33616][client backend] [pg_regress/planning][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:19.988 UTC [33630][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:19.989 UTC [33630][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-23 20:27:19.989 UTC [33630][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/user_activity 2024-03-23 20:27:20.029 UTC [33630][client backend] [pg_regress/user_activity][:0] LOG: disconnection: session time: 0:00:00.041 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:20.045 UTC [33637][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:20.046 UTC [33637][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-23 20:27:20.046 UTC [33637][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/wal 2024-03-23 20:27:20.068 UTC [33637][client backend] [pg_regress/wal][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:20.136 UTC [33654][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:20.137 UTC [33654][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-23 20:27:20.137 UTC [33654][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/entry_timestamp 2024-03-23 20:27:20.172 UTC [33654][client backend] [pg_regress/entry_timestamp][:0] LOG: disconnection: session time: 0:00:00.037 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:20.211 UTC [33667][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:20.212 UTC [33667][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-23 20:27:20.212 UTC [33667][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/cleanup 2024-03-23 20:27:20.222 UTC [33667][client backend] [pg_regress/cleanup][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:20.252 UTC [33675][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-23 20:27:20.253 UTC [33675][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-23 20:27:20.253 UTC [33675][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/oldextversions 2024-03-23 20:27:20.264 UTC [33675][client backend] [pg_regress/oldextversions][12/4:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-23 20:27:20.264 UTC [33675][client backend] [pg_regress/oldextversions][12/4:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-23 20:27:20.267 UTC [33675][client backend] [pg_regress/oldextversions][12/12:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-23 20:27:20.267 UTC [33675][client backend] [pg_regress/oldextversions][12/12:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-23 20:27:20.270 UTC [33675][client backend] [pg_regress/oldextversions][12/17:0] ERROR: permission denied for function pg_stat_statements_reset 2024-03-23 20:27:20.270 UTC [33675][client backend] [pg_regress/oldextversions][12/17:0] STATEMENT: SELECT pg_stat_statements_reset(); 2024-03-23 20:27:20.336 UTC [33675][client backend] [pg_regress/oldextversions][:0] LOG: disconnection: session time: 0:00:00.083 user=postgres database=contrib_regression host=[local] 2024-03-23 20:27:20.366 UTC [33404][postmaster] LOG: server process (PID 33454) was terminated by signal 6: Aborted 2024-03-23 20:27:20.366 UTC [33404][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-23 20:27:20.366 UTC [33404][postmaster] LOG: terminating any other active server processes 2024-03-23 20:27:20.371 UTC [33404][postmaster] LOG: shutting down because restart_after_crash is off 2024-03-23 20:27:20.384 UTC [33404][postmaster] LOG: database system is shut down