2024-11-21 04:51:10.662 UTC [20904][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-21 04:51:10.662 UTC [20904][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-VpFC8x/.s.PGSQL.65312" 2024-11-21 04:51:10.689 UTC [20917][startup] LOG: database system was shut down at 2024-11-21 04:51:10 UTC 2024-11-21 04:51:10.708 UTC [20927][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:10.709 UTC [20927][client backend] [[unknown]][:0] FATAL: the database system is starting up 2024-11-21 04:51:10.718 UTC [20904][postmaster] LOG: database system is ready to accept connections 2024-11-21 04:51:10.770 UTC [20947][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:10.771 UTC [20947][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:10.771 UTC [20947][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-11-21 04:51:10.792 UTC [20947][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2024-11-21 04:51:10.858 UTC [20970][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:10.859 UTC [20970][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:10.859 UTC [20970][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2024-11-21 04:51:10.964 UTC [20970][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.111 user=postgres database=postgres host=[local] 2024-11-21 04:51:11.031 UTC [21006][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:11.034 UTC [21006][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:11.034 UTC [21006][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_setup 2024-11-21 04:51:11.079 UTC [21006][client backend] [pg_regress/plperl_setup][2/5:750] ERROR: permission denied to create extension "plperl" 2024-11-21 04:51:11.079 UTC [21006][client backend] [pg_regress/plperl_setup][2/5:750] HINT: Must have CREATE privilege on current database to create this extension. 2024-11-21 04:51:11.079 UTC [21006][client backend] [pg_regress/plperl_setup][2/5:750] STATEMENT: CREATE EXTENSION plperl; 2024-11-21 04:51:11.080 UTC [21006][client backend] [pg_regress/plperl_setup][2/6:751] ERROR: permission denied to create extension "plperlu" 2024-11-21 04:51:11.080 UTC [21006][client backend] [pg_regress/plperl_setup][2/6:751] HINT: Must be superuser to create this extension. 2024-11-21 04:51:11.080 UTC [21006][client backend] [pg_regress/plperl_setup][2/6:751] STATEMENT: CREATE EXTENSION plperlu; 2024-11-21 04:51:11.132 UTC [21006][client backend] [pg_regress/plperl_setup][2/11:754] ERROR: permission denied to create extension "plperlu" 2024-11-21 04:51:11.132 UTC [21006][client backend] [pg_regress/plperl_setup][2/11:754] HINT: Must be superuser to create this extension. 2024-11-21 04:51:11.132 UTC [21006][client backend] [pg_regress/plperl_setup][2/11:754] STATEMENT: CREATE EXTENSION plperlu; 2024-11-21 04:51:11.182 UTC [21029][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:11.183 UTC [21029][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:11.183 UTC [21029][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_setup 2024-11-21 04:51:11.186 UTC [21006][client backend] [pg_regress/plperl_setup][:0] LOG: disconnection: session time: 0:00:00.159 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:11.200 UTC [21029][client backend] [pg_regress/plperl_setup][3/6:0] ERROR: permission denied for language plperl 2024-11-21 04:51:11.200 UTC [21029][client backend] [pg_regress/plperl_setup][3/6:0] STATEMENT: CREATE FUNCTION foo2() returns int language plperl as '2;'; 2024-11-21 04:51:11.241 UTC [21029][client backend] [pg_regress/plperl_setup][3/13:0] ERROR: cannot drop language plperl because extension plperl requires it 2024-11-21 04:51:11.241 UTC [21029][client backend] [pg_regress/plperl_setup][3/13:0] HINT: You can drop extension plperl instead. 2024-11-21 04:51:11.241 UTC [21029][client backend] [pg_regress/plperl_setup][3/13:0] STATEMENT: DROP LANGUAGE plperl CASCADE; 2024-11-21 04:51:11.267 UTC [21029][client backend] [pg_regress/plperl_setup][:0] LOG: disconnection: session time: 0:00:00.094 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:11.344 UTC [21056][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:11.346 UTC [21056][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:11.346 UTC [21056][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl 2024-11-21 04:51:11.416 UTC [21056][client backend] [pg_regress/plperl][4/28:0] ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-11-21 04:51:11.416 UTC [21056][client backend] [pg_regress/plperl][4/28:0] CONTEXT: PL/Perl function "perl_set" 2024-11-21 04:51:11.416 UTC [21056][client backend] [pg_regress/plperl][4/28:0] STATEMENT: SELECT perl_set(); 2024-11-21 04:51:11.417 UTC [21056][client backend] [pg_regress/plperl][4/29:0] ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-11-21 04:51:11.417 UTC [21056][client backend] [pg_regress/plperl][4/29:0] CONTEXT: PL/Perl function "perl_set" 2024-11-21 04:51:11.417 UTC [21056][client backend] [pg_regress/plperl][4/29:0] STATEMENT: SELECT * FROM perl_set(); 2024-11-21 04:51:11.426 UTC [21056][client backend] [pg_regress/plperl][4/35:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-21 04:51:11.426 UTC [21056][client backend] [pg_regress/plperl][4/35:0] STATEMENT: SELECT * FROM perl_record(); 2024-11-21 04:51:11.427 UTC [21056][client backend] [pg_regress/plperl][4/38:0] ERROR: function returning record called in context that cannot accept type record 2024-11-21 04:51:11.427 UTC [21056][client backend] [pg_regress/plperl][4/38:0] CONTEXT: PL/Perl function "perl_record" 2024-11-21 04:51:11.427 UTC [21056][client backend] [pg_regress/plperl][4/38:0] STATEMENT: SELECT perl_record(); 2024-11-21 04:51:11.428 UTC [21056][client backend] [pg_regress/plperl][4/39:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-21 04:51:11.428 UTC [21056][client backend] [pg_regress/plperl][4/39:0] STATEMENT: SELECT * FROM perl_record(); 2024-11-21 04:51:11.429 UTC [21056][client backend] [pg_regress/plperl][4/43:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-21 04:51:11.429 UTC [21056][client backend] [pg_regress/plperl][4/43:0] STATEMENT: SELECT * FROM perl_record_set(); 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/46:0] ERROR: function returning record called in context that cannot accept type record 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/46:0] CONTEXT: PL/Perl function "perl_record_set" 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/46:0] STATEMENT: SELECT perl_record_set(); 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/47:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/47:0] STATEMENT: SELECT * FROM perl_record_set(); 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/48:0] ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/48:0] CONTEXT: PL/Perl function "perl_record_set" 2024-11-21 04:51:11.430 UTC [21056][client backend] [pg_regress/plperl][4/48:0] STATEMENT: SELECT * FROM perl_record_set() AS (f1 integer, f2 text, f3 text); 2024-11-21 04:51:11.431 UTC [21056][client backend] [pg_regress/plperl][4/50:0] ERROR: function returning record called in context that cannot accept type record 2024-11-21 04:51:11.431 UTC [21056][client backend] [pg_regress/plperl][4/50:0] CONTEXT: PL/Perl function "perl_record_set" 2024-11-21 04:51:11.431 UTC [21056][client backend] [pg_regress/plperl][4/50:0] STATEMENT: SELECT perl_record_set(); 2024-11-21 04:51:11.431 UTC [21056][client backend] [pg_regress/plperl][4/51:0] ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-21 04:51:11.431 UTC [21056][client backend] [pg_regress/plperl][4/51:0] STATEMENT: SELECT * FROM perl_record_set(); 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/65:0] ERROR: Perl hash contains nonexistent column "z" 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/65:0] CONTEXT: PL/Perl function "foo_bad" 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/65:0] STATEMENT: SELECT * FROM foo_bad(); 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/67:0] ERROR: malformed record literal: "42" 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/67:0] DETAIL: Missing left parenthesis. 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/67:0] CONTEXT: PL/Perl function "foo_bad" 2024-11-21 04:51:11.450 UTC [21056][client backend] [pg_regress/plperl][4/67:0] STATEMENT: SELECT * FROM foo_bad(); 2024-11-21 04:51:11.451 UTC [21056][client backend] [pg_regress/plperl][4/69:0] ERROR: cannot convert Perl array to non-array type footype 2024-11-21 04:51:11.451 UTC [21056][client backend] [pg_regress/plperl][4/69:0] CONTEXT: PL/Perl function "foo_bad" 2024-11-21 04:51:11.451 UTC [21056][client backend] [pg_regress/plperl][4/69:0] STATEMENT: SELECT * FROM foo_bad(); 2024-11-21 04:51:11.452 UTC [21056][client backend] [pg_regress/plperl][4/71:0] ERROR: set-returning PL/Perl function must return reference to array or use return_next 2024-11-21 04:51:11.452 UTC [21056][client backend] [pg_regress/plperl][4/71:0] CONTEXT: PL/Perl function "foo_set_bad" 2024-11-21 04:51:11.452 UTC [21056][client backend] [pg_regress/plperl][4/71:0] STATEMENT: SELECT * FROM foo_set_bad(); 2024-11-21 04:51:11.453 UTC [21056][client backend] [pg_regress/plperl][4/73:0] ERROR: set-returning PL/Perl function must return reference to array or use return_next 2024-11-21 04:51:11.453 UTC [21056][client backend] [pg_regress/plperl][4/73:0] CONTEXT: PL/Perl function "foo_set_bad" 2024-11-21 04:51:11.453 UTC [21056][client backend] [pg_regress/plperl][4/73:0] STATEMENT: SELECT * FROM foo_set_bad(); 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/75:0] ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/75:0] CONTEXT: PL/Perl function "foo_set_bad" 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/75:0] STATEMENT: SELECT * FROM foo_set_bad(); 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/77:0] ERROR: Perl hash contains nonexistent column "z" 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/77:0] CONTEXT: PL/Perl function "foo_set_bad" 2024-11-21 04:51:11.454 UTC [21056][client backend] [pg_regress/plperl][4/77:0] STATEMENT: SELECT * FROM foo_set_bad(); 2024-11-21 04:51:11.460 UTC [21056][client backend] [pg_regress/plperl][4/82:0] ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-11-21 04:51:11.460 UTC [21056][client backend] [pg_regress/plperl][4/82:0] CONTEXT: PL/Perl function "foo_ordered" 2024-11-21 04:51:11.460 UTC [21056][client backend] [pg_regress/plperl][4/82:0] STATEMENT: SELECT * FROM foo_ordered(); 2024-11-21 04:51:11.463 UTC [21056][client backend] [pg_regress/plperl][4/86:0] ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-11-21 04:51:11.463 UTC [21056][client backend] [pg_regress/plperl][4/86:0] CONTEXT: PL/Perl function "foo_ordered_set" 2024-11-21 04:51:11.463 UTC [21056][client backend] [pg_regress/plperl][4/86:0] STATEMENT: SELECT * FROM foo_ordered_set(); 2024-11-21 04:51:11.474 UTC [21056][client backend] [pg_regress/plperl][4/94:0] ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-11-21 04:51:11.474 UTC [21056][client backend] [pg_regress/plperl][4/94:0] STATEMENT: SELECT perl_get_cfield((12,11), 'x'); 2024-11-21 04:51:11.475 UTC [21056][client backend] [pg_regress/plperl][4/99:0] ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-11-21 04:51:11.475 UTC [21056][client backend] [pg_regress/plperl][4/99:0] STATEMENT: SELECT perl_get_rfield((12,11)::orderedfootype, 'x'); 2024-11-21 04:51:11.509 UTC [21056][client backend] [pg_regress/plperl][4/118:0] ERROR: type "does_not_exist" does not exist at line 2. 2024-11-21 04:51:11.509 UTC [21056][client backend] [pg_regress/plperl][4/118:0] CONTEXT: PL/Perl function "perl_spi_prepared_bad" 2024-11-21 04:51:11.509 UTC [21056][client backend] [pg_regress/plperl][4/118:0] STATEMENT: SELECT perl_spi_prepared_bad(4.35) as "double precision"; 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/124:0] ERROR: 'system' trapped by operation mask at line 1. 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/124:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/124:0] STATEMENT: DO $$ system("/nonesuch"); $$ LANGUAGE plperl; 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/125:0] ERROR: 'quoted execution (``, qx)' trapped by operation mask at line 1. 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/125:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/125:0] STATEMENT: DO $$ qx("/nonesuch"); $$ LANGUAGE plperl; 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/126:0] ERROR: 'open' trapped by operation mask at line 1. 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/126:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:11.520 UTC [21056][client backend] [pg_regress/plperl][4/126:0] STATEMENT: DO $$ open my $fh, " qw(void) ; my @y; sort @y; 1; $do$ LANGUAGE plperl; 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/135:0] ERROR: cannot convert Perl array to non-array type text 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/135:0] CONTEXT: PL/Perl function "text_arrayref" 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/135:0] STATEMENT: SELECT text_arrayref(); 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/137:0] ERROR: cannot convert Perl hash to non-composite type text 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/137:0] CONTEXT: PL/Perl function "text_hashref" 2024-11-21 04:51:11.524 UTC [21056][client backend] [pg_regress/plperl][4/137:0] STATEMENT: SELECT text_hashref(); 2024-11-21 04:51:11.525 UTC [21056][client backend] [pg_regress/plperl][4/139:0] ERROR: cannot convert Perl hash to non-composite type text 2024-11-21 04:51:11.525 UTC [21056][client backend] [pg_regress/plperl][4/139:0] CONTEXT: PL/Perl function "text_obj" 2024-11-21 04:51:11.525 UTC [21056][client backend] [pg_regress/plperl][4/139:0] STATEMENT: SELECT text_obj(); 2024-11-21 04:51:11.536 UTC [21056][client backend] [pg_regress/plperl][:0] LOG: disconnection: session time: 0:00:00.203 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:11.609 UTC [21093][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:11.610 UTC [21093][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:11.610 UTC [21093][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_lc 2024-11-21 04:51:11.661 UTC [21093][client backend] [pg_regress/plperl_lc][5/3:0] ERROR: invalid byte sequence for encoding "UTF8": 0x00 2024-11-21 04:51:11.661 UTC [21093][client backend] [pg_regress/plperl_lc][5/3:0] CONTEXT: PL/Perl function "perl_zerob" 2024-11-21 04:51:11.661 UTC [21093][client backend] [pg_regress/plperl_lc][5/3:0] STATEMENT: SELECT perl_zerob(); 2024-11-21 04:51:11.664 UTC [21093][client backend] [pg_regress/plperl_lc][:0] LOG: disconnection: session time: 0:00:00.056 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:11.726 UTC [21113][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:11.728 UTC [21113][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:11.728 UTC [21113][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_trigger 2024-11-21 04:51:11.873 UTC [21113][client backend] [pg_regress/plperl_trigger][6/49:0] ERROR: trigger functions can only be called as triggers 2024-11-21 04:51:11.873 UTC [21113][client backend] [pg_regress/plperl_trigger][6/49:0] CONTEXT: compilation of PL/Perl function "direct_trigger" 2024-11-21 04:51:11.873 UTC [21113][client backend] [pg_regress/plperl_trigger][6/49:0] STATEMENT: SELECT direct_trigger(); 2024-11-21 04:51:11.916 UTC [21113][client backend] [pg_regress/plperl_trigger][6/70:0] ERROR: cannot set generated column "j" 2024-11-21 04:51:11.916 UTC [21113][client backend] [pg_regress/plperl_trigger][6/70:0] CONTEXT: PL/Perl function "generated_test_func1" 2024-11-21 04:51:11.916 UTC [21113][client backend] [pg_regress/plperl_trigger][6/70:0] STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2024-11-21 04:51:11.920 UTC [21113][client backend] [pg_regress/plperl_trigger][:0] LOG: disconnection: session time: 0:00:00.197 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:12.052 UTC [21154][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:12.054 UTC [21154][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:12.054 UTC [21154][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_shared 2024-11-21 04:51:12.203 UTC [21154][client backend] [pg_regress/plperl_shared][:0] LOG: disconnection: session time: 0:00:00.158 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:12.395 UTC [21209][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:12.396 UTC [21209][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:12.396 UTC [21209][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_elog 2024-11-21 04:51:12.528 UTC [21209][client backend] [pg_regress/plperl_elog][8/5:0] WARNING: implicit elog via warn at line 4. 2024-11-21 04:51:12.528 UTC [21209][client backend] [pg_regress/plperl_elog][8/5:0] CONTEXT: PL/Perl function "perl_warn" 2024-11-21 04:51:12.529 UTC [21209][client backend] [pg_regress/plperl_elog][8/7:888] ERROR: Global symbol "$global" requires explicit package name (did you forget to declare "my $global"?) at line 3. Global symbol "$other_global" requires explicit package name (did you forget to declare "my $other_global"?) at line 4. 2024-11-21 04:51:12.529 UTC [21209][client backend] [pg_regress/plperl_elog][8/7:888] CONTEXT: compilation of PL/Perl function "uses_global" 2024-11-21 04:51:12.529 UTC [21209][client backend] [pg_regress/plperl_elog][8/7:888] STATEMENT: create or replace function uses_global() returns text language plperl as $$ $global = 1; $other_global = 2; return 'uses_global worked'; $$; 2024-11-21 04:51:12.530 UTC [21209][client backend] [pg_regress/plperl_elog][8/8:0] ERROR: function uses_global() does not exist at character 8 2024-11-21 04:51:12.530 UTC [21209][client backend] [pg_regress/plperl_elog][8/8:0] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2024-11-21 04:51:12.530 UTC [21209][client backend] [pg_regress/plperl_elog][8/8:0] STATEMENT: select uses_global(); 2024-11-21 04:51:12.536 UTC [21209][client backend] [pg_regress/plperl_elog][8/14:0] ERROR: just die at line 2. 2024-11-21 04:51:12.536 UTC [21209][client backend] [pg_regress/plperl_elog][8/14:0] CONTEXT: PL/Perl function "just_die" 2024-11-21 04:51:12.536 UTC [21209][client backend] [pg_regress/plperl_elog][8/14:0] STATEMENT: select just_die(); 2024-11-21 04:51:12.555 UTC [21209][client backend] [pg_regress/plperl_elog][8/21:0] ERROR: this message contains a no-break space at line 2. 2024-11-21 04:51:12.555 UTC [21209][client backend] [pg_regress/plperl_elog][8/21:0] CONTEXT: PL/Perl function "error_with_nbsp" 2024-11-21 04:51:12.555 UTC [21209][client backend] [pg_regress/plperl_elog][8/21:0] STATEMENT: select error_with_nbsp(); 2024-11-21 04:51:12.558 UTC [21209][client backend] [pg_regress/plperl_elog][:0] LOG: disconnection: session time: 0:00:00.164 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:12.712 UTC [21224][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:12.714 UTC [21224][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:12.714 UTC [21224][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_util 2024-11-21 04:51:12.844 UTC [21224][client backend] [pg_regress/plperl_util][9/24:0] ERROR: value for domain perl_foo_pos violates check constraint "perl_foo_pos_check" 2024-11-21 04:51:12.844 UTC [21224][client backend] [pg_regress/plperl_util][9/24:0] CONTEXT: PL/Perl function "perl_encode_typed_literal" 2024-11-21 04:51:12.844 UTC [21224][client backend] [pg_regress/plperl_util][9/24:0] STATEMENT: select perl_encode_typed_literal(); 2024-11-21 04:51:12.847 UTC [21224][client backend] [pg_regress/plperl_util][:0] LOG: disconnection: session time: 0:00:00.143 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:12.964 UTC [21236][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:12.966 UTC [21236][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:12.966 UTC [21236][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_init 2024-11-21 04:51:13.034 UTC [21236][client backend] [pg_regress/plperl_init][10/5:0] ERROR: 'system' trapped by operation mask at line 1. 2024-11-21 04:51:13.034 UTC [21236][client backend] [pg_regress/plperl_init][10/5:0] CONTEXT: while executing plperl.on_plperl_init PL/Perl anonymous code block 2024-11-21 04:51:13.034 UTC [21236][client backend] [pg_regress/plperl_init][10/5:0] STATEMENT: DO $$ warn 42 $$ language plperl; 2024-11-21 04:51:13.052 UTC [21243][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.054 UTC [21243][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.054 UTC [21243][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_init 2024-11-21 04:51:13.057 UTC [21236][client backend] [pg_regress/plperl_init][:0] LOG: disconnection: session time: 0:00:00.102 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.070 UTC [21243][client backend] [pg_regress/plperl_init][11/6:0] WARNING: permission denied to set parameter "plperl.on_plperl_init" 2024-11-21 04:51:13.110 UTC [21243][client backend] [pg_regress/plperl_init][11/8:0] WARNING: 42 at line 1. 2024-11-21 04:51:13.110 UTC [21243][client backend] [pg_regress/plperl_init][11/8:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:13.111 UTC [21243][client backend] [pg_regress/plperl_init][11/10:0] ERROR: permission denied to set parameter "plperl.on_plperl_init" 2024-11-21 04:51:13.111 UTC [21243][client backend] [pg_regress/plperl_init][11/10:0] STATEMENT: SET SESSION plperl.on_plperl_init = 'test'; 2024-11-21 04:51:13.116 UTC [21243][client backend] [pg_regress/plperl_init][:0] LOG: disconnection: session time: 0:00:00.070 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.184 UTC [21257][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.186 UTC [21257][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.186 UTC [21257][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperlu 2024-11-21 04:51:13.234 UTC [21257][client backend] [pg_regress/plperlu][12/4:0] WARNING: 42 at line 1. 2024-11-21 04:51:13.234 UTC [21257][client backend] [pg_regress/plperlu][12/4:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:13.244 UTC [21257][client backend] [pg_regress/plperlu][:0] LOG: disconnection: session time: 0:00:00.061 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.325 UTC [21270][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.327 UTC [21270][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.327 UTC [21270][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_array 2024-11-21 04:51:13.389 UTC [21270][client backend] [pg_regress/plperl_array][13/8:0] ERROR: number of array dimensions exceeds the maximum allowed (6) at character 25 2024-11-21 04:51:13.389 UTC [21270][client backend] [pg_regress/plperl_array][13/8:0] STATEMENT: select plperl_sum_array('{{{{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}}, {{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}, {{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}}, {{{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}, {{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}}}' ); 2024-11-21 04:51:13.389 UTC [21270][client backend] [pg_regress/plperl_array][13/9:0] ERROR: malformed array literal: "{{{1,2,3}, {4,5,6,7}}, {{7,8,9}, {10, 11, 12}}}" at character 25 2024-11-21 04:51:13.389 UTC [21270][client backend] [pg_regress/plperl_array][13/9:0] DETAIL: Multidimensional arrays must have sub-arrays with matching dimensions. 2024-11-21 04:51:13.389 UTC [21270][client backend] [pg_regress/plperl_array][13/9:0] STATEMENT: select plperl_sum_array('{{{1,2,3}, {4,5,6,7}}, {{7,8,9}, {10, 11, 12}}}'); 2024-11-21 04:51:13.415 UTC [21270][client backend] [pg_regress/plperl_array][13/34:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-11-21 04:51:13.415 UTC [21270][client backend] [pg_regress/plperl_array][13/34:0] CONTEXT: PL/Perl function "plperl_md_array_out" 2024-11-21 04:51:13.415 UTC [21270][client backend] [pg_regress/plperl_array][13/34:0] STATEMENT: select plperl_md_array_out(); 2024-11-21 04:51:13.416 UTC [21270][client backend] [pg_regress/plperl_array][13/36:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-11-21 04:51:13.416 UTC [21270][client backend] [pg_regress/plperl_array][13/36:0] CONTEXT: PL/Perl function "plperl_md_array_out" 2024-11-21 04:51:13.416 UTC [21270][client backend] [pg_regress/plperl_array][13/36:0] STATEMENT: select plperl_md_array_out(); 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/38:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/38:0] CONTEXT: PL/Perl function "plperl_md_array_out" 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/38:0] STATEMENT: select plperl_md_array_out(); 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/40:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/40:0] CONTEXT: PL/Perl function "plperl_md_array_out" 2024-11-21 04:51:13.417 UTC [21270][client backend] [pg_regress/plperl_array][13/40:0] STATEMENT: select plperl_md_array_out(); 2024-11-21 04:51:13.422 UTC [21270][client backend] [pg_regress/plperl_array][:0] LOG: disconnection: session time: 0:00:00.098 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.508 UTC [21289][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.511 UTC [21289][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.511 UTC [21289][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_call 2024-11-21 04:51:13.630 UTC [21289][client backend] [pg_regress/plperl_call][:0] LOG: disconnection: session time: 0:00:00.124 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.695 UTC [21313][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.696 UTC [21313][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.696 UTC [21313][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_transaction 2024-11-21 04:51:13.798 UTC [21313][client backend] [pg_regress/plperl_transaction][15/31:986] ERROR: invalid transaction termination at line 5. 2024-11-21 04:51:13.798 UTC [21313][client backend] [pg_regress/plperl_transaction][15/31:986] CONTEXT: PL/Perl function "transaction_test2" 2024-11-21 04:51:13.798 UTC [21313][client backend] [pg_regress/plperl_transaction][15/31:986] STATEMENT: SELECT transaction_test2(); 2024-11-21 04:51:13.806 UTC [21313][client backend] [pg_regress/plperl_transaction][15/34:989] ERROR: invalid transaction termination at line 5. at line 2. 2024-11-21 04:51:13.806 UTC [21313][client backend] [pg_regress/plperl_transaction][15/34:989] CONTEXT: PL/Perl function "transaction_test3" 2024-11-21 04:51:13.806 UTC [21313][client backend] [pg_regress/plperl_transaction][15/34:989] STATEMENT: SELECT transaction_test3(); 2024-11-21 04:51:13.807 UTC [21313][client backend] [pg_regress/plperl_transaction][15/37:0] ERROR: invalid transaction termination at line 1. at line 2. 2024-11-21 04:51:13.807 UTC [21313][client backend] [pg_regress/plperl_transaction][15/37:0] CONTEXT: PL/Perl function "transaction_test4" 2024-11-21 04:51:13.807 UTC [21313][client backend] [pg_regress/plperl_transaction][15/37:0] STATEMENT: SELECT transaction_test4(); 2024-11-21 04:51:13.822 UTC [21313][client backend] [pg_regress/plperl_transaction][15/52:0] ERROR: division by zero at line 5. 2024-11-21 04:51:13.822 UTC [21313][client backend] [pg_regress/plperl_transaction][15/52:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:13.822 UTC [21313][client backend] [pg_regress/plperl_transaction][15/52:0] STATEMENT: DO LANGUAGE plperl $$ my $sth = spi_query("SELECT * FROM test2 ORDER BY x"); my $row; while (defined($row = spi_fetchrow($sth))) { spi_exec_query("INSERT INTO test1 (a) VALUES (12/(" . $row->{x} . "-2))"); spi_commit(); } $$; 2024-11-21 04:51:13.866 UTC [21313][client backend] [pg_regress/plperl_transaction][15/76:0] ERROR: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" at line 4. 2024-11-21 04:51:13.866 UTC [21313][client backend] [pg_regress/plperl_transaction][15/76:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:13.866 UTC [21313][client backend] [pg_regress/plperl_transaction][15/76:0] STATEMENT: DO LANGUAGE plperl $$ # this insert will fail during commit: spi_exec_query("INSERT INTO testfk VALUES (0)"); spi_commit(); elog(WARNING, 'should not get here'); $$; 2024-11-21 04:51:13.889 UTC [21313][client backend] [pg_regress/plperl_transaction][:0] LOG: disconnection: session time: 0:00:00.196 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:13.953 UTC [21332][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:13.954 UTC [21332][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:13.954 UTC [21332][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_env 2024-11-21 04:51:14.005 UTC [21332][client backend] [pg_regress/plperl_env][16/4:0] WARNING: attempted alteration of $ENV{TEST_PLPERL_ENV_FOO} at line 12. 2024-11-21 04:51:14.005 UTC [21332][client backend] [pg_regress/plperl_env][16/4:0] CONTEXT: PL/Perl anonymous code block 2024-11-21 04:51:14.038 UTC [21332][client backend] [pg_regress/plperl_env][:0] LOG: disconnection: session time: 0:00:00.086 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:14.108 UTC [21350][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:51:14.110 UTC [21350][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plperl/tmp_check/data/pg_hba.conf:117) 2024-11-21 04:51:14.110 UTC [21350][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plperl_plperlu 2024-11-21 04:51:14.177 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/4:0] ERROR: syntax error at or near "invalid" at line 4. 2024-11-21 04:51:14.177 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/4:0] CONTEXT: PL/Perl function "bar" 2024-11-21 04:51:14.177 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/4:0] STATEMENT: SELECT * FROM bar(); 2024-11-21 04:51:14.181 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/5:0] ERROR: syntax error at or near "invalid" at line 4. at line 2. 2024-11-21 04:51:14.181 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/5:0] CONTEXT: PL/Perl function "foo" 2024-11-21 04:51:14.181 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/5:0] STATEMENT: SELECT * FROM foo(); 2024-11-21 04:51:14.207 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/19:1056] ERROR: Unable to load Errno.pm into plperl at line 2. BEGIN failed--compilation aborted at line 2. 2024-11-21 04:51:14.207 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/19:1056] CONTEXT: compilation of PL/Perl function "use_plperl" 2024-11-21 04:51:14.207 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/19:1056] STATEMENT: CREATE OR REPLACE FUNCTION use_plperl() RETURNS void LANGUAGE plperl AS $$ use Errno; $$; 2024-11-21 04:51:14.208 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/21:1057] ERROR: Unable to load Errno.pm into plperl at line 2. BEGIN failed--compilation aborted at line 2. 2024-11-21 04:51:14.208 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/21:1057] CONTEXT: compilation of PL/Perl function "use_plperl" 2024-11-21 04:51:14.208 UTC [21350][client backend] [pg_regress/plperl_plperlu][17/21:1057] STATEMENT: CREATE OR REPLACE FUNCTION use_plperl() RETURNS void LANGUAGE plperl AS $$ use Errno; $$; 2024-11-21 04:51:14.212 UTC [21350][client backend] [pg_regress/plperl_plperlu][:0] LOG: disconnection: session time: 0:00:00.113 user=postgres database=pl_regression host=[local] 2024-11-21 04:51:14.249 UTC [20904][postmaster] LOG: received fast shutdown request 2024-11-21 04:51:14.250 UTC [20904][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "postmaster.c", Line: 2887, PID: 20904 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f4185851f31] postgres(ExceptionalCondition+0xe6)[0x55de0614cbe3] postgres(+0xc80d8d)[0x55de05c9ad8d] postgres(+0xc812c1)[0x55de05c9b2c1] postgres(+0xc823fc)[0x55de05c9c3fc] postgres(PostmasterMain+0x1b98)[0x55de05c9e6f3] postgres(main+0x28e)[0x55de05a44180] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f418484824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f4184848305] postgres(_start+0x21)[0x55de054363a1]