2024-11-17 21:32:47.145 UTC [24380][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-11-17 21:32:47.145 UTC [24380][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-fsRI9a/.s.PGSQL.65312" 2024-11-17 21:32:47.151 UTC [24383][startup] LOG: database system was shut down at 2024-11-17 21:32:06 UTC 2024-11-17 21:32:47.158 UTC [24384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.158 UTC [24384][client backend] [[unknown]][:0] FATAL: the database system is starting up 2024-11-17 21:32:47.161 UTC [24380][postmaster] LOG: database system is ready to accept connections 2024-11-17 21:32:47.210 UTC [24396][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.212 UTC [24396][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.212 UTC [24396][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-11-17 21:32:47.233 UTC [24396][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2024-11-17 21:32:47.251 UTC [24432][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.252 UTC [24432][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.252 UTC [24432][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-11-17 21:32:47.366 UTC [24432][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.115 user=postgres database=postgres host=[local] 2024-11-17 21:32:47.406 UTC [24444][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.410 UTC [24444][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.411 UTC [24444][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress 2024-11-17 21:32:47.458 UTC [24444][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.053 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:47.516 UTC [24446][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.520 UTC [24446][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.520 UTC [24446][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_setup 2024-11-17 21:32:47.622 UTC [24446][client backend] [pg_regress/pltcl_setup][:0] LOG: disconnection: session time: 0:00:00.107 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:47.690 UTC [24450][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.691 UTC [24450][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.691 UTC [24450][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_queries 2024-11-17 21:32:47.724 UTC [24450][client backend] [pg_regress/pltcl_queries][4/12:0] ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2024-11-17 21:32:47.724 UTC [24450][client backend] [pg_regress/pltcl_queries][4/12:0] STATEMENT: select tcl_cdomain_arg(row('tkey', -1, 'ref2')); 2024-11-17 21:32:47.727 UTC [24450][client backend] [pg_regress/pltcl_queries][4/17:0] ERROR: invalid command name "returm" 2024-11-17 21:32:47.727 UTC [24450][client backend] [pg_regress/pltcl_queries][4/17:0] CONTEXT: while executing "returm 1" (procedure "__PLTcl_proc_tcl_error" line 2) invoked from within "__PLTcl_proc_tcl_error" in PL/Tcl function tcl_error() 2024-11-17 21:32:47.727 UTC [24450][client backend] [pg_regress/pltcl_queries][4/17:0] STATEMENT: select tcl_error(); 2024-11-17 21:32:47.728 UTC [24450][client backend] [pg_regress/pltcl_queries][4/19:0] ERROR: column name/value list must have even number of elements 2024-11-17 21:32:47.728 UTC [24450][client backend] [pg_regress/pltcl_queries][4/19:0] STATEMENT: select bad_record(); 2024-11-17 21:32:47.729 UTC [24450][client backend] [pg_regress/pltcl_queries][4/21:0] ERROR: column name/value list contains nonexistent column name "cow" 2024-11-17 21:32:47.729 UTC [24450][client backend] [pg_regress/pltcl_queries][4/21:0] STATEMENT: select bad_field(); 2024-11-17 21:32:47.735 UTC [24450][client backend] [pg_regress/pltcl_queries][4/27:0] ERROR: return_next cannot be used in non-set-returning functions 2024-11-17 21:32:47.735 UTC [24450][client backend] [pg_regress/pltcl_queries][4/27:0] CONTEXT: while executing "return_next 1" (procedure "__PLTcl_proc_non_srf" line 2) invoked from within "__PLTcl_proc_non_srf" in PL/Tcl function non_srf() 2024-11-17 21:32:47.735 UTC [24450][client backend] [pg_regress/pltcl_queries][4/27:0] STATEMENT: select non_srf(); 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/29:0] ERROR: column name/value list must have even number of elements 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/29:0] CONTEXT: while executing "return_next [list a]" (procedure "__PLTcl_proc_bad_record_srf" line 3) invoked from within "__PLTcl_proc_bad_record_srf" in PL/Tcl function bad_record_srf() 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/29:0] STATEMENT: select bad_record_srf(); 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/31:0] ERROR: column name/value list contains nonexistent column name "cow" 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/31:0] CONTEXT: while executing "return_next [list a 1 b 2 cow 3]" (procedure "__PLTcl_proc_bad_field_srf" line 3) invoked from within "__PLTcl_proc_bad_field_srf" in PL/Tcl function bad_field_srf() 2024-11-17 21:32:47.736 UTC [24450][client backend] [pg_regress/pltcl_queries][4/31:0] STATEMENT: select bad_field_srf(); 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/38:0] ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/38:0] STATEMENT: select * from tcl_dcomposite_result(-1); 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/40:0] ERROR: function returning record called in context that cannot accept type record 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/40:0] STATEMENT: select tcl_record_result(42); 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/41:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-17 21:32:47.742 UTC [24450][client backend] [pg_regress/pltcl_queries][4/41:0] STATEMENT: select * from tcl_record_result(42); 2024-11-17 21:32:47.746 UTC [24450][client backend] [pg_regress/pltcl_queries][4/44:0] ERROR: column name/value list contains nonexistent column name "q3" 2024-11-17 21:32:47.746 UTC [24450][client backend] [pg_regress/pltcl_queries][4/44:0] STATEMENT: select * from tcl_record_result(42) as (q1 text, q2 int, q4 int); 2024-11-17 21:32:47.746 UTC [24450][client backend] [pg_regress/pltcl_queries][4/45:0] ERROR: wrong # args: should be "quote string" 2024-11-17 21:32:47.746 UTC [24450][client backend] [pg_regress/pltcl_queries][4/45:0] CONTEXT: while executing "quote foo bar" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {quote foo bar}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.746 UTC [24450][client backend] [pg_regress/pltcl_queries][4/45:0] STATEMENT: select tcl_eval('quote foo bar'); 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/48:0] ERROR: wrong # args: should be "argisnull argno" 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/48:0] CONTEXT: while executing "argisnull" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text argisnull" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/48:0] STATEMENT: select tcl_eval('argisnull'); 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/49:0] ERROR: argno out of range 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/49:0] CONTEXT: while executing "argisnull 14" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {argisnull 14}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/49:0] STATEMENT: select tcl_eval('argisnull 14'); 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/50:0] ERROR: expected integer but got "abc" 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/50:0] CONTEXT: while executing "argisnull abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {argisnull abc}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.747 UTC [24450][client backend] [pg_regress/pltcl_queries][4/50:0] STATEMENT: select tcl_eval('argisnull abc'); 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/51:0] ERROR: wrong # args: should be "return_null " 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/51:0] CONTEXT: while executing "return_null 14" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {return_null 14}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/51:0] STATEMENT: select tcl_eval('return_null 14'); 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/52:0] ERROR: wrong # args: should be "spi_exec ?-count n? ?-array name? query ?loop body?" 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/52:0] CONTEXT: while executing "spi_exec" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_exec" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/52:0] STATEMENT: select tcl_eval('spi_exec'); 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/53:0] ERROR: missing argument to -count or -array 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/53:0] CONTEXT: while executing "spi_exec -count" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -count}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/53:0] STATEMENT: select tcl_eval('spi_exec -count'); 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/54:0] ERROR: missing argument to -count or -array 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/54:0] CONTEXT: while executing "spi_exec -array" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -array}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/54:0] STATEMENT: select tcl_eval('spi_exec -array'); 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/55:0] ERROR: expected integer but got "abc" 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/55:0] CONTEXT: while executing "spi_exec -count abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -count abc}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.748 UTC [24450][client backend] [pg_regress/pltcl_queries][4/55:0] STATEMENT: select tcl_eval('spi_exec -count abc'); 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/56:0] ERROR: wrong # args: should be "query ?loop body?" 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/56:0] CONTEXT: while executing "spi_exec query loop body toomuch" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec query loop body toomuch}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/56:0] STATEMENT: select tcl_eval('spi_exec query loop body toomuch'); 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/57:0] ERROR: pltcl: SPI_execute failed: SPI_ERROR_TRANSACTION 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/57:0] CONTEXT: while executing "spi_exec "begin; rollback;"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec "begin; rollback;"}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/57:0] STATEMENT: select tcl_eval('spi_exec "begin; rollback;"'); 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/58:0] ERROR: missing argument to -count or -array 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/58:0] CONTEXT: while executing "spi_execp" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_execp" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/58:0] STATEMENT: select tcl_eval('spi_execp'); 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/59:0] ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/59:0] CONTEXT: while executing "spi_execp -count" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -count}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.749 UTC [24450][client backend] [pg_regress/pltcl_queries][4/59:0] STATEMENT: select tcl_eval('spi_execp -count'); 2024-11-17 21:32:47.750 UTC [24450][client backend] [pg_regress/pltcl_queries][4/60:0] ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:32:47.750 UTC [24450][client backend] [pg_regress/pltcl_queries][4/60:0] CONTEXT: while executing "spi_execp -array" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -array}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.750 UTC [24450][client backend] [pg_regress/pltcl_queries][4/60:0] STATEMENT: select tcl_eval('spi_execp -array'); 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/61:0] ERROR: expected integer but got "abc" 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/61:0] CONTEXT: while executing "spi_execp -count abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -count abc}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/61:0] STATEMENT: select tcl_eval('spi_execp -count abc'); 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/62:0] ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/62:0] CONTEXT: while executing "spi_execp -nulls" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -nulls}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/62:0] STATEMENT: select tcl_eval('spi_execp -nulls'); 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/63:0] ERROR: invalid queryid '' 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/63:0] CONTEXT: while executing "spi_execp """ ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp ""}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/63:0] STATEMENT: select tcl_eval('spi_execp ""'); 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/64:0] ERROR: wrong # args: should be "spi_prepare query argtypes" 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/64:0] CONTEXT: while executing "spi_prepare" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_prepare" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.761 UTC [24450][client backend] [pg_regress/pltcl_queries][4/64:0] STATEMENT: select tcl_eval('spi_prepare'); 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/65:0] ERROR: type "b" does not exist 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/65:0] CONTEXT: while executing "spi_prepare a b" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_prepare a b}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/65:0] STATEMENT: select tcl_eval('spi_prepare a b'); 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/66:0] ERROR: unmatched open brace in list 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/66:0] CONTEXT: while executing "spi_prepare a "b {"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_prepare\ a\ \"b\ \{\"" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.762 UTC [24450][client backend] [pg_regress/pltcl_queries][4/66:0] STATEMENT: select tcl_eval('spi_prepare a "b {"'); 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/70:0] ERROR: wrong # args: should be "elog level msg" 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/70:0] CONTEXT: while executing "elog" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text elog" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/70:0] STATEMENT: select tcl_eval('elog'); 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/71:0] ERROR: bad priority "foo": must be DEBUG, LOG, INFO, NOTICE, WARNING, ERROR, or FATAL 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/71:0] CONTEXT: while executing "elog foo bar" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {elog foo bar}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/71:0] STATEMENT: select tcl_eval('elog foo bar'); 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/72:0] ERROR: forced error 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/72:0] CONTEXT: while executing "error "forced error"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {error "forced error"}" in PL/Tcl function tcl_eval(text) 2024-11-17 21:32:47.765 UTC [24450][client backend] [pg_regress/pltcl_queries][4/72:0] STATEMENT: select tcl_eval('error "forced error"'); 2024-11-17 21:32:47.767 UTC [24450][client backend] [pg_regress/pltcl_queries][4/75:0] ERROR: error message 2024-11-17 21:32:47.767 UTC [24450][client backend] [pg_regress/pltcl_queries][4/75:0] CONTEXT: while executing "error "error message"" invoked from within "spi_execp -array A $prep { elog NOTICE "col1 $A(col1), col2 $A(col2)" switch $A(col1) { 2 { elog NOTICE "..." (procedure "__PLTcl_proc_tcl_spi_exec_boolean_text" line 6) invoked from within "__PLTcl_proc_tcl_spi_exec_boolean_text t error" in PL/Tcl function tcl_spi_exec(boolean,text) 2024-11-17 21:32:47.767 UTC [24450][client backend] [pg_regress/pltcl_queries][4/75:0] STATEMENT: select tcl_spi_exec(true, 'error'); 2024-11-17 21:32:47.769 UTC [24450][client backend] [pg_regress/pltcl_queries][4/79:0] ERROR: error message 2024-11-17 21:32:47.769 UTC [24450][client backend] [pg_regress/pltcl_queries][4/79:0] CONTEXT: while executing "error "error message"" invoked from within "spi_exec -array A $query { elog NOTICE "col1 $A(col1), col2 $A(col2)" switch $A(col1) { 2 { elog NOTICE "..." (procedure "__PLTcl_proc_tcl_spi_exec_boolean_text" line 31) invoked from within "__PLTcl_proc_tcl_spi_exec_boolean_text f error" in PL/Tcl function tcl_spi_exec(boolean,text) 2024-11-17 21:32:47.769 UTC [24450][client backend] [pg_regress/pltcl_queries][4/79:0] STATEMENT: select tcl_spi_exec(false, 'error'); 2024-11-17 21:32:47.878 UTC [24450][client backend] [pg_regress/pltcl_queries][:0] LOG: disconnection: session time: 0:00:00.190 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:47.931 UTC [24454][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:47.933 UTC [24454][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:47.933 UTC [24454][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_trigger 2024-11-17 21:32:47.979 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/41:0] ERROR: duplicate key '1', 'KEY1-3' for T_pkey2 2024-11-17 21:32:47.979 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/41:0] CONTEXT: while executing "elog ERROR "duplicate key '$NEW(key1)', '$NEW(key2)' for T_pkey2"" invoked from within "if {$n > 0} { elog ERROR \ "duplicate key '$NEW(key1)', '$NEW(key2)' for T_pkey2" }" (procedure "__PLTcl_trigger_trig_pkey2_before" line 32) invoked from within "__PLTcl_trigger_trig_pkey2_before pkey2_before 16454 t_pkey2 public {{} key1 key2 txt} BEFORE ROW INSERT {key1 1 key2 {KEY1-3 } txt {shou..." in PL/Tcl function trig_pkey2_before() 2024-11-17 21:32:47.979 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/41:0] STATEMENT: insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 2024-11-17 21:32:47.988 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/45:0] ERROR: key for t_dta1 not in t_pkey1 2024-11-17 21:32:47.988 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/45:0] CONTEXT: while executing "elog ERROR "key for $GD($planrel) not in $keyrel"" (procedure "__PLTcl_trigger_check_primkey" line 92) invoked from within "__PLTcl_trigger_check_primkey dta1_before 16457 t_dta1 public {{} tkey ref1 ref2} BEFORE ROW INSERT {tkey {trec 4 } ref1 1 ref2 {key1-4 ..." in PL/Tcl function check_primkey() 2024-11-17 21:32:47.988 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/45:0] STATEMENT: insert into T_dta1 values ('trec 4', 1, 'key1-4'); 2024-11-17 21:32:47.992 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/49:0] ERROR: key for t_dta2 not in t_pkey2 2024-11-17 21:32:47.992 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/49:0] CONTEXT: while executing "elog ERROR "key for $GD($planrel) not in $keyrel"" (procedure "__PLTcl_trigger_check_primkey" line 92) invoked from within "__PLTcl_trigger_check_primkey dta2_before 16460 t_dta2 public {{} tkey ref1 ref2} BEFORE ROW INSERT {tkey {trec 4 } ref1 1 ref2 {KEY1-4 ..." in PL/Tcl function check_primkey() 2024-11-17 21:32:47.992 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/49:0] STATEMENT: insert into T_dta2 values ('trec 4', 1, 'KEY1-4'); 2024-11-17 21:32:47.994 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/53:850] ERROR: key '1', 'key1-1 ' referenced by T_dta1 2024-11-17 21:32:47.994 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/53:850] CONTEXT: while executing "elog ERROR "key '$OLD(key1)', '$OLD(key2)' referenced by T_dta1"" invoked from within "if {$check_old_ref} { # # Check for references to OLD # set n [spi_execp -count 1 $GD(plan_dta1) [list $OLD(key1) $OLD(key2)]] if {$n > 0}..." (procedure "__PLTcl_trigger_trig_pkey1_before" line 79) invoked from within "__PLTcl_trigger_trig_pkey1_before pkey1_before 16451 t_pkey1 public {{} key1 key2 txt} BEFORE ROW UPDATE {key1 1 key2 {key1-9 } txt {test..." in PL/Tcl function trig_pkey1_before() 2024-11-17 21:32:47.994 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/53:850] STATEMENT: update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 2024-11-17 21:32:47.995 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/55:852] ERROR: key '1', 'key1-2 ' referenced by T_dta1 2024-11-17 21:32:47.995 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/55:852] CONTEXT: while executing "elog ERROR "key '$OLD(key1)', '$OLD(key2)' referenced by T_dta1"" invoked from within "if {$check_old_ref} { # # Check for references to OLD # set n [spi_execp -count 1 $GD(plan_dta1) [list $OLD(key1) $OLD(key2)]] if {$n > 0}..." (procedure "__PLTcl_trigger_trig_pkey1_before" line 79) invoked from within "__PLTcl_trigger_trig_pkey1_before pkey1_before 16451 t_pkey1 public {{} key1 key2 txt} BEFORE ROW DELETE {} {key1 1 key2 {key1-2 } txt {t..." in PL/Tcl function trig_pkey1_before() 2024-11-17 21:32:47.995 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/55:852] STATEMENT: delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/87:0] ERROR: argisnull cannot be used in triggers 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/87:0] CONTEXT: while executing "argisnull 1" (procedure "__PLTcl_trigger_trigger_data" line 19) invoked from within "__PLTcl_trigger_trigger_data show_trigger_data_trig 16464 trigger_test public {{} i v {} test_skip test_return_null test_argisnull} BEFORE ROW INSERT ..." in PL/Tcl function trigger_data() 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/87:0] STATEMENT: insert into trigger_test(test_argisnull) values(true); 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/88:0] ERROR: return_null cannot be used in triggers 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/88:0] CONTEXT: while executing "return_null" (procedure "__PLTcl_trigger_trigger_data" line 16) invoked from within "__PLTcl_trigger_trigger_data show_trigger_data_trig 16464 trigger_test public {{} i v {} test_skip test_return_null test_argisnull} BEFORE ROW INSERT ..." in PL/Tcl function trigger_data() 2024-11-17 21:32:48.021 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/88:0] STATEMENT: insert into trigger_test(test_return_null) values(true); 2024-11-17 21:32:48.033 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/99:0] ERROR: cannot set generated column "j" 2024-11-17 21:32:48.033 UTC [24454][client backend] [pg_regress/pltcl_trigger][5/99:0] STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2024-11-17 21:32:48.037 UTC [24454][client backend] [pg_regress/pltcl_trigger][:0] LOG: disconnection: session time: 0:00:00.106 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.072 UTC [24458][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:48.074 UTC [24458][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:48.074 UTC [24458][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_call 2024-11-17 21:32:48.094 UTC [24458][client backend] [pg_regress/pltcl_call][6/17:0] ERROR: could not parse function return value: list element in braces followed by ")" instead of space 2024-11-17 21:32:48.094 UTC [24458][client backend] [pg_regress/pltcl_call][6/17:0] STATEMENT: CALL test_proc10('abc'); 2024-11-17 21:32:48.103 UTC [24458][client backend] [pg_regress/pltcl_call][:0] LOG: disconnection: session time: 0:00:00.030 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.129 UTC [24462][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:48.131 UTC [24462][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:48.131 UTC [24462][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_start_proc 2024-11-17 21:32:48.140 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/3:0] ERROR: function no_such_function() does not exist 2024-11-17 21:32:48.140 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/3:0] CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:32:48.140 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/3:0] STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:32:48.141 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/4:0] ERROR: function no_such_function() does not exist 2024-11-17 21:32:48.141 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/4:0] CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:32:48.141 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/4:0] STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:32:48.144 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/7:0] ERROR: function "public.tcl_initialize" must not be SECURITY DEFINER 2024-11-17 21:32:48.144 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/7:0] CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:32:48.144 UTC [24462][client backend] [pg_regress/pltcl_start_proc][7/7:0] STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:32:48.149 UTC [24462][client backend] [pg_regress/pltcl_start_proc][:0] LOG: disconnection: session time: 0:00:00.020 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.180 UTC [24466][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:48.182 UTC [24466][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:48.182 UTC [24466][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_subxact 2024-11-17 21:32:48.209 UTC [24466][client backend] [pg_regress/pltcl_subxact][:0] LOG: disconnection: session time: 0:00:00.029 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.231 UTC [24470][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:48.232 UTC [24470][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:48.232 UTC [24470][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_unicode 2024-11-17 21:32:48.256 UTC [24470][client backend] [pg_regress/pltcl_unicode][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.286 UTC [24474][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-17 21:32:48.287 UTC [24474][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/tcl/tmp_check/data/pg_hba.conf:117) 2024-11-17 21:32:48.287 UTC [24474][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/pltcl_transaction 2024-11-17 21:32:48.307 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/18:969] ERROR: invalid transaction termination 2024-11-17 21:32:48.307 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/18:969] CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_test2" line 6) invoked from within "__PLTcl_proc_transaction_test2" in PL/Tcl function transaction_test2() 2024-11-17 21:32:48.307 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/18:969] STATEMENT: SELECT transaction_test2(); 2024-11-17 21:32:48.309 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/21:972] ERROR: invalid transaction termination 2024-11-17 21:32:48.309 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/21:972] CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_test1" line 6) invoked from within "__PLTcl_proc_transaction_test1" invoked from within "spi_exec "CALL transaction_test1()"" (procedure "__PLTcl_proc_transaction_test3" line 3) invoked from within "__PLTcl_proc_transaction_test3" in PL/Tcl function transaction_test3() 2024-11-17 21:32:48.309 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/21:972] STATEMENT: SELECT transaction_test3(); 2024-11-17 21:32:48.314 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/27:979] ERROR: cannot commit while a subtransaction is active 2024-11-17 21:32:48.314 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/27:979] CONTEXT: while executing "commit" invoked from within "spi_exec -array row "SELECT * FROM test2 ORDER BY x" { spi_exec "INSERT INTO test1 (a) VALUES ($row(x))" commit }" (procedure "__PLTcl_proc_transaction_test4a" line 3) invoked from within "__PLTcl_proc_transaction_test4a" in PL/Tcl function transaction_test4a() 2024-11-17 21:32:48.314 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/27:979] STATEMENT: CALL transaction_test4a(); 2024-11-17 21:32:48.317 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/31:984] ERROR: cannot roll back while a subtransaction is active 2024-11-17 21:32:48.317 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/31:984] CONTEXT: while executing "rollback" invoked from within "spi_exec -array row "SELECT * FROM test2 ORDER BY x" { spi_exec "INSERT INTO test1 (a) VALUES ($row(x))" rollback }" (procedure "__PLTcl_proc_transaction_test4b" line 3) invoked from within "__PLTcl_proc_transaction_test4b" in PL/Tcl function transaction_test4b() 2024-11-17 21:32:48.317 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/31:984] STATEMENT: CALL transaction_test4b(); 2024-11-17 21:32:48.326 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/37:0] ERROR: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" 2024-11-17 21:32:48.326 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/37:0] CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_testfk" line 5) invoked from within "__PLTcl_proc_transaction_testfk" in PL/Tcl function transaction_testfk() 2024-11-17 21:32:48.326 UTC [24474][client backend] [pg_regress/pltcl_transaction][10/37:0] STATEMENT: CALL transaction_testfk(); 2024-11-17 21:32:48.337 UTC [24474][client backend] [pg_regress/pltcl_transaction][:0] LOG: disconnection: session time: 0:00:00.051 user=postgres database=pl_regression host=[local] 2024-11-17 21:32:48.356 UTC [24380][postmaster] LOG: received fast shutdown request 2024-11-17 21:32:48.356 UTC [24380][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "postmaster.c", Line: 2887, PID: 24380 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fd3e6251f31] postgres(ExceptionalCondition+0xe6)[0x55d421997da1] postgres(+0xc80cad)[0x55d4214e6cad] postgres(+0xc811e1)[0x55d4214e71e1] postgres(+0xc8231c)[0x55d4214e831c] postgres(PostmasterMain+0x1b98)[0x55d4214ea613] postgres(main+0x28e)[0x55d4212900f3] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fd3e504824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fd3e5048305] postgres(_start+0x21)[0x55d420c823a1]