2024-10-29 04:33:56.226 UTC [31489][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-10-29 04:33:56.226 UTC [31489][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-7yKEz2/.s.PGSQL.65312" 2024-10-29 04:33:56.236 UTC [31502][startup] LOG: database system was shut down at 2024-10-29 04:32:27 UTC 2024-10-29 04:33:56.245 UTC [31489][postmaster] LOG: database system is ready to accept connections 2024-10-29 04:33:56.281 UTC [31509][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-10-29 04:33:56.282 UTC [31509][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_trgm/tmp_check/data/pg_hba.conf:117) 2024-10-29 04:33:56.282 UTC [31509][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-10-29 04:33:56.320 UTC [31509][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.051 user=postgres database=postgres host=[local] 2024-10-29 04:33:56.386 UTC [31515][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-10-29 04:33:56.388 UTC [31515][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_trgm/tmp_check/data/pg_hba.conf:117) 2024-10-29 04:33:56.388 UTC [31515][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-10-29 04:33:56.478 UTC [31515][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.092 user=postgres database=postgres host=[local] 2024-10-29 04:33:56.537 UTC [31524][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-10-29 04:33:56.539 UTC [31524][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_trgm/tmp_check/data/pg_hba.conf:117) 2024-10-29 04:33:56.539 UTC [31524][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/pg_trgm 2024-10-29 04:33:56.774 UTC [31524][client backend] [pg_regress/pg_trgm][2/32:750] ERROR: value 0 out of bounds for option "siglen" 2024-10-29 04:33:56.774 UTC [31524][client backend] [pg_regress/pg_trgm][2/32:750] DETAIL: Valid values are between "1" and "2024". 2024-10-29 04:33:56.774 UTC [31524][client backend] [pg_regress/pg_trgm][2/32:750] STATEMENT: create index trgm_idx on test_trgm using gist (t gist_trgm_ops(siglen=0)); 2024-10-29 04:33:56.775 UTC [31524][client backend] [pg_regress/pg_trgm][2/33:751] ERROR: value 2025 out of bounds for option "siglen" 2024-10-29 04:33:56.775 UTC [31524][client backend] [pg_regress/pg_trgm][2/33:751] DETAIL: Valid values are between "1" and "2024". 2024-10-29 04:33:56.775 UTC [31524][client backend] [pg_regress/pg_trgm][2/33:751] STATEMENT: create index trgm_idx on test_trgm using gist (t gist_trgm_ops(siglen=2025)); AddressSanitizer:DEADLYSIGNAL ================================================================= ==31524==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x559058ae99b6 bp 0x625000a81820 sp 0x7ffde4be6c00 T0) ==31524==The signal is caused by a READ memory access. ==31524==Hint: address points to the zero page. #0 0x559058ae99b6 in ExecInterpExpr /tmp/cirrus-ci-build/src/backend/executor/execExprInterp.c:1605 #1 0x559058ad8dc2 in ExecInterpExprStillValid /tmp/cirrus-ci-build/src/backend/executor/execExprInterp.c:2035 #2 0x559058aed61f in ExecEvalExpr ../../../src/include/executor/executor.h:356 #3 0x559058aed61f in TupleHashTableHash_internal /tmp/cirrus-ci-build/src/backend/executor/execGrouping.c:446 #4 0x559058aefd63 in LookupTupleHashEntry /tmp/cirrus-ci-build/src/backend/executor/execGrouping.c:329 #5 0x559058b2bc2b in lookup_hash_entries /tmp/cirrus-ci-build/src/backend/executor/nodeAgg.c:2119 #6 0x559058b2c584 in agg_fill_hash_table /tmp/cirrus-ci-build/src/backend/executor/nodeAgg.c:2559 #7 0x559058b352c3 in ExecAgg /tmp/cirrus-ci-build/src/backend/executor/nodeAgg.c:2172 #8 0x559058b0b0a0 in ExecProcNodeFirst /tmp/cirrus-ci-build/src/backend/executor/execProcnode.c:469 #9 0x559058af4719 in ExecProcNode ../../../src/include/executor/executor.h:278 #10 0x559058af487a in ExecutePlan /tmp/cirrus-ci-build/src/backend/executor/execMain.c:1650 #11 0x559058af6593 in standard_ExecutorRun /tmp/cirrus-ci-build/src/backend/executor/execMain.c:361 #12 0x559058af680b in ExecutorRun /tmp/cirrus-ci-build/src/backend/executor/execMain.c:302 #13 0x559058ff0e9d in PortalRunSelect /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:924 #14 0x559058ff4d26 in PortalRun /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:768 #15 0x559058fec030 in exec_simple_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:1283 #16 0x559058fefe71 in PostgresMain /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:4792 #17 0x559058fe2011 in BackendMain /tmp/cirrus-ci-build/src/backend/tcop/backend_startup.c:107 #18 0x559058e46656 in postmaster_child_launch /tmp/cirrus-ci-build/src/backend/postmaster/launch_backend.c:266 #19 0x559058e4d6dd in BackendStartup /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:3417 #20 0x559058e4dda6 in ServerLoop /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1650 #21 0x559058e4fd66 in PostmasterMain /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1348 #22 0x559058bfa38c in main /tmp/cirrus-ci-build/src/backend/main/main.c:196 #23 0x7f9384c48249 (/lib/x86_64-linux-gnu/libc.so.6+0x27249) #24 0x7f9384c48304 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x27304) #25 0x5590585f23a0 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres+0x4183a0) AddressSanitizer can not provide additional info. SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/backend/executor/execExprInterp.c:1605 in ExecInterpExpr ==31524==ABORTING 2024-10-29 04:33:58.527 UTC [31661][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-10-29 04:33:58.529 UTC [31661][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_trgm/tmp_check/data/pg_hba.conf:117) 2024-10-29 04:33:58.529 UTC [31661][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/pg_word_trgm 2024-10-29 04:33:58.621 UTC [31661][client backend] [pg_regress/pg_word_trgm][:0] LOG: disconnection: session time: 0:00:00.096 user=postgres database=contrib_regression host=[local] 2024-10-29 04:33:58.665 UTC [31668][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-10-29 04:33:58.666 UTC [31668][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/contrib/pg_trgm/tmp_check/data/pg_hba.conf:117) 2024-10-29 04:33:58.666 UTC [31668][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=contrib_regression application_name=pg_regress/pg_strict_word_trgm 2024-10-29 04:33:58.674 UTC [31668][client backend] [pg_regress/pg_strict_word_trgm][4/3:0] ERROR: relation "test_trgm3" does not exist 2024-10-29 04:33:58.674 UTC [31668][client backend] [pg_regress/pg_strict_word_trgm][4/3:0] STATEMENT: COPY test_trgm3 FROM STDIN 2024-10-29 04:33:58.765 UTC [31668][client backend] [pg_regress/pg_strict_word_trgm][:0] LOG: disconnection: session time: 0:00:00.103 user=postgres database=contrib_regression host=[local] 2024-10-29 04:33:58.783 UTC [31489][postmaster] LOG: received fast shutdown request 2024-10-29 04:33:58.783 UTC [31489][postmaster] LOG: aborting any active transactions 2024-10-29 04:33:58.792 UTC [31489][postmaster] LOG: background worker "logical replication launcher" (PID 31507) exited with exit code 1 2024-10-29 04:33:59.501 UTC [31489][postmaster] LOG: server process (PID 31524) was terminated by signal 6: Aborted 2024-10-29 04:33:59.501 UTC [31489][postmaster] DETAIL: Failed process was running: SELECT DISTINCT city, similarity(city, 'Warsaw'), show_limit() FROM restaurants WHERE city % 'Warsaw'; 2024-10-29 04:33:59.501 UTC [31489][postmaster] LOG: terminating any other active server processes 2024-10-29 04:33:59.504 UTC [31489][postmaster] LOG: abnormal database system shutdown 2024-10-29 04:33:59.536 UTC [31489][postmaster] LOG: database system is shut down