2025-03-05 13:38:21.678 UTC [21678][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:38:21.678 UTC [21678][postmaster] LOG: listening on Unix socket "/tmp/pg_regress-xGwaF7/.s.PGSQL.65312" 2025-03-05 13:38:21.698 UTC [21686][startup] LOG: database system was shut down at 2025-03-05 13:38:14 UTC 2025-03-05 13:38:21.723 UTC [21678][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:38:21.730 UTC [21690][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:21.730 UTC [21690][client backend] [[unknown]][:0] FATAL: the database system is starting up 2025-03-05 13:38:21.786 UTC [21705][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:21.787 UTC [21705][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:21.788 UTC [21705][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2025-03-05 13:38:21.863 UTC [21705][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.078 user=postgres database=postgres host=[local] 2025-03-05 13:38:21.892 UTC [21722][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:21.894 UTC [21722][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:21.894 UTC [21722][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=pg_regress 2025-03-05 13:38:22.004 UTC [21722][client backend] [pg_regress][:0] LOG: disconnection: session time: 0:00:00.111 user=postgres database=postgres host=[local] 2025-03-05 13:38:22.050 UTC [21738][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.051 UTC [21738][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.051 UTC [21738][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_schema 2025-03-05 13:38:22.185 UTC [21738][client backend] [pg_regress/plpython_schema][:0] LOG: disconnection: session time: 0:00:00.135 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:22.230 UTC [21784][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.231 UTC [21784][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.231 UTC [21784][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_populate 2025-03-05 13:38:22.307 UTC [21784][client backend] [pg_regress/plpython_populate][:0] LOG: disconnection: session time: 0:00:00.078 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:22.368 UTC [21811][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.370 UTC [21811][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.370 UTC [21811][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_test 2025-03-05 13:38:22.495 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] LOG: log 2025-03-05 13:38:22.495 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT: PL/Python function "elog_test_basic" 2025-03-05 13:38:22.495 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] STATEMENT: SELECT elog_test_basic(); 2025-03-05 13:38:22.527 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] WARNING: warning 2025-03-05 13:38:22.527 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT: PL/Python function "elog_test_basic" 2025-03-05 13:38:22.528 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] ERROR: plpy.Error: error 2025-03-05 13:38:22.528 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT: Traceback (most recent call last): PL/Python function "elog_test_basic", line 10, in plpy.error('error') PL/Python function "elog_test_basic" 2025-03-05 13:38:22.528 UTC [21811][client backend] [pg_regress/plpython_test][4/12:0] STATEMENT: SELECT elog_test_basic(); 2025-03-05 13:38:22.531 UTC [21811][client backend] [pg_regress/plpython_test][:0] LOG: disconnection: session time: 0:00:00.164 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:22.592 UTC [21838][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.596 UTC [21838][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.596 UTC [21838][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_do 2025-03-05 13:38:22.622 UTC [21838][client backend] [pg_regress/plpython_do][5/3:0] ERROR: Exception: error test 2025-03-05 13:38:22.622 UTC [21838][client backend] [pg_regress/plpython_do][5/3:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 1, in raise Exception("error test") PL/Python anonymous code block 2025-03-05 13:38:22.622 UTC [21838][client backend] [pg_regress/plpython_do][5/3:0] STATEMENT: DO $$ raise Exception("error test") $$ LANGUAGE plpython3u; 2025-03-05 13:38:22.626 UTC [21838][client backend] [pg_regress/plpython_do][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:22.689 UTC [21851][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.693 UTC [21851][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.693 UTC [21851][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_global 2025-03-05 13:38:22.751 UTC [21851][client backend] [pg_regress/plpython_global][:0] LOG: disconnection: session time: 0:00:00.063 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:22.817 UTC [21864][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:22.818 UTC [21864][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:22.818 UTC [21864][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_import 2025-03-05 13:38:22.925 UTC [21864][client backend] [pg_regress/plpython_import][:0] LOG: disconnection: session time: 0:00:00.111 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.041 UTC [21886][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.042 UTC [21886][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.042 UTC [21886][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_spi 2025-03-05 13:38:23.170 UTC [21886][client backend] [pg_regress/plpython_spi][8/20:802] ERROR: plpy.Error: command did not produce a result set 2025-03-05 13:38:23.170 UTC [21886][client backend] [pg_regress/plpython_spi][8/20:802] CONTEXT: Traceback (most recent call last): PL/Python function "result_metadata_test", line 6, in plpy.info(result.colnames()) PL/Python function "result_metadata_test" 2025-03-05 13:38:23.170 UTC [21886][client backend] [pg_regress/plpython_spi][8/20:802] STATEMENT: SELECT result_metadata_test($$CREATE TEMPORARY TABLE foo1 (a int, b text)$$); 2025-03-05 13:38:23.264 UTC [21886][client backend] [pg_regress/plpython_spi][8/57:0] ERROR: TypeError: Expected sequence of 1 argument, got 2: ['a', 'b'] 2025-03-05 13:38:23.264 UTC [21886][client backend] [pg_regress/plpython_spi][8/57:0] CONTEXT: Traceback (most recent call last): PL/Python function "cursor_plan_wrong_args", line 4, in c = plpy.cursor(plan, ["a", "b"]) PL/Python function "cursor_plan_wrong_args" 2025-03-05 13:38:23.264 UTC [21886][client backend] [pg_regress/plpython_spi][8/57:0] STATEMENT: SELECT cursor_plan_wrong_args(); 2025-03-05 13:38:23.303 UTC [21886][client backend] [pg_regress/plpython_spi][:0] LOG: disconnection: session time: 0:00:00.264 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.350 UTC [21915][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.351 UTC [21915][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.351 UTC [21915][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_newline 2025-03-05 13:38:23.402 UTC [21915][client backend] [pg_regress/plpython_newline][:0] LOG: disconnection: session time: 0:00:00.053 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.475 UTC [21932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.477 UTC [21932][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.477 UTC [21932][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_void 2025-03-05 13:38:23.515 UTC [21932][client backend] [pg_regress/plpython_void][10/6:0] ERROR: PL/Python function with return type "void" did not return None 2025-03-05 13:38:23.515 UTC [21932][client backend] [pg_regress/plpython_void][10/6:0] CONTEXT: while creating return value PL/Python function "test_void_func2" 2025-03-05 13:38:23.515 UTC [21932][client backend] [pg_regress/plpython_void][10/6:0] STATEMENT: SELECT test_void_func2(); 2025-03-05 13:38:23.519 UTC [21932][client backend] [pg_regress/plpython_void][:0] LOG: disconnection: session time: 0:00:00.045 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.589 UTC [21949][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.590 UTC [21949][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.590 UTC [21949][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_call 2025-03-05 13:38:23.646 UTC [21949][client backend] [pg_regress/plpython_call][11/5:0] ERROR: PL/Python procedure did not return None 2025-03-05 13:38:23.646 UTC [21949][client backend] [pg_regress/plpython_call][11/5:0] CONTEXT: PL/Python procedure "test_proc2" 2025-03-05 13:38:23.646 UTC [21949][client backend] [pg_regress/plpython_call][11/5:0] STATEMENT: CALL test_proc2(); 2025-03-05 13:38:23.677 UTC [21949][client backend] [pg_regress/plpython_call][:0] LOG: disconnection: session time: 0:00:00.090 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.779 UTC [21975][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.780 UTC [21975][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.780 UTC [21975][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_params 2025-03-05 13:38:23.840 UTC [21975][client backend] [pg_regress/plpython_params][:0] LOG: disconnection: session time: 0:00:00.062 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:23.937 UTC [21986][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:23.938 UTC [21986][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:23.938 UTC [21986][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_setof 2025-03-05 13:38:23.993 UTC [21986][client backend] [pg_regress/plpython_setof][13/3:0] ERROR: returned object cannot be iterated 2025-03-05 13:38:23.993 UTC [21986][client backend] [pg_regress/plpython_setof][13/3:0] DETAIL: PL/Python set-returning functions must return an iterable object. 2025-03-05 13:38:23.993 UTC [21986][client backend] [pg_regress/plpython_setof][13/3:0] CONTEXT: PL/Python function "test_setof_error" 2025-03-05 13:38:23.993 UTC [21986][client backend] [pg_regress/plpython_setof][13/3:0] STATEMENT: SELECT test_setof_error(); 2025-03-05 13:38:24.028 UTC [21986][client backend] [pg_regress/plpython_setof][:0] LOG: disconnection: session time: 0:00:00.099 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:24.088 UTC [22000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:24.096 UTC [22000][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:24.096 UTC [22000][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_record 2025-03-05 13:38:24.175 UTC [22000][client backend] [pg_regress/plpython_record][14/64:0] ERROR: key "second" not found in mapping 2025-03-05 13:38:24.175 UTC [22000][client backend] [pg_regress/plpython_record][14/64:0] HINT: To return null in a column, add the value None to the mapping with the key named after the column. 2025-03-05 13:38:24.175 UTC [22000][client backend] [pg_regress/plpython_record][14/64:0] CONTEXT: while creating return value PL/Python function "test_type_record_error1" 2025-03-05 13:38:24.175 UTC [22000][client backend] [pg_regress/plpython_record][14/64:0] STATEMENT: SELECT * FROM test_type_record_error1(); 2025-03-05 13:38:24.176 UTC [22000][client backend] [pg_regress/plpython_record][14/66:0] ERROR: length of returned sequence did not match number of columns in row 2025-03-05 13:38:24.176 UTC [22000][client backend] [pg_regress/plpython_record][14/66:0] CONTEXT: while creating return value PL/Python function "test_type_record_error2" 2025-03-05 13:38:24.176 UTC [22000][client backend] [pg_regress/plpython_record][14/66:0] STATEMENT: SELECT * FROM test_type_record_error2(); 2025-03-05 13:38:24.177 UTC [22000][client backend] [pg_regress/plpython_record][14/68:0] ERROR: attribute "second" does not exist in Python object 2025-03-05 13:38:24.177 UTC [22000][client backend] [pg_regress/plpython_record][14/68:0] HINT: To return null in a column, let the returned object have an attribute named after column with value None. 2025-03-05 13:38:24.177 UTC [22000][client backend] [pg_regress/plpython_record][14/68:0] CONTEXT: while creating return value PL/Python function "test_type_record_error3" 2025-03-05 13:38:24.177 UTC [22000][client backend] [pg_regress/plpython_record][14/68:0] STATEMENT: SELECT * FROM test_type_record_error3(); 2025-03-05 13:38:24.178 UTC [22000][client backend] [pg_regress/plpython_record][14/70:0] ERROR: malformed record literal: "foo" 2025-03-05 13:38:24.178 UTC [22000][client backend] [pg_regress/plpython_record][14/70:0] DETAIL: Missing left parenthesis. 2025-03-05 13:38:24.178 UTC [22000][client backend] [pg_regress/plpython_record][14/70:0] CONTEXT: while creating return value PL/Python function "test_type_record_error4" 2025-03-05 13:38:24.178 UTC [22000][client backend] [pg_regress/plpython_record][14/70:0] STATEMENT: SELECT * FROM test_type_record_error4(); 2025-03-05 13:38:24.181 UTC [22000][client backend] [pg_regress/plpython_record][:0] LOG: disconnection: session time: 0:00:00.093 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:24.250 UTC [22014][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:24.251 UTC [22014][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:24.251 UTC [22014][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_trigger 2025-03-05 13:38:24.332 UTC [22014][client backend] [pg_regress/plpython_trigger][15/45:0] ERROR: unexpected return value from trigger procedure 2025-03-05 13:38:24.332 UTC [22014][client backend] [pg_regress/plpython_trigger][15/45:0] DETAIL: Expected None or a string. 2025-03-05 13:38:24.332 UTC [22014][client backend] [pg_regress/plpython_trigger][15/45:0] CONTEXT: PL/Python function "stupid1" 2025-03-05 13:38:24.332 UTC [22014][client backend] [pg_regress/plpython_trigger][15/45:0] STATEMENT: INSERT INTO trigger_test VALUES (1, 'one'); 2025-03-05 13:38:24.334 UTC [22014][client backend] [pg_regress/plpython_trigger][15/49:926] WARNING: PL/Python trigger function returned "MODIFY" in a DELETE trigger -- ignored 2025-03-05 13:38:24.334 UTC [22014][client backend] [pg_regress/plpython_trigger][15/49:926] CONTEXT: PL/Python function "stupid2" 2025-03-05 13:38:24.336 UTC [22014][client backend] [pg_regress/plpython_trigger][15/54:931] ERROR: unexpected return value from trigger procedure 2025-03-05 13:38:24.336 UTC [22014][client backend] [pg_regress/plpython_trigger][15/54:931] DETAIL: Expected None, "OK", "SKIP", or "MODIFY". 2025-03-05 13:38:24.336 UTC [22014][client backend] [pg_regress/plpython_trigger][15/54:931] CONTEXT: PL/Python function "stupid3" 2025-03-05 13:38:24.336 UTC [22014][client backend] [pg_regress/plpython_trigger][15/54:931] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.345 UTC [22014][client backend] [pg_regress/plpython_trigger][15/58:935] ERROR: unexpected return value from trigger procedure 2025-03-05 13:38:24.345 UTC [22014][client backend] [pg_regress/plpython_trigger][15/58:935] DETAIL: Expected None, "OK", "SKIP", or "MODIFY". 2025-03-05 13:38:24.345 UTC [22014][client backend] [pg_regress/plpython_trigger][15/58:935] CONTEXT: PL/Python function "stupid3u" 2025-03-05 13:38:24.345 UTC [22014][client backend] [pg_regress/plpython_trigger][15/58:935] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.348 UTC [22014][client backend] [pg_regress/plpython_trigger][15/62:939] ERROR: TD["new"] deleted, cannot modify row 2025-03-05 13:38:24.348 UTC [22014][client backend] [pg_regress/plpython_trigger][15/62:939] CONTEXT: while modifying trigger row PL/Python function "stupid4" 2025-03-05 13:38:24.348 UTC [22014][client backend] [pg_regress/plpython_trigger][15/62:939] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.350 UTC [22014][client backend] [pg_regress/plpython_trigger][15/66:943] ERROR: TD["new"] is not a dictionary 2025-03-05 13:38:24.350 UTC [22014][client backend] [pg_regress/plpython_trigger][15/66:943] CONTEXT: while modifying trigger row PL/Python function "stupid5" 2025-03-05 13:38:24.350 UTC [22014][client backend] [pg_regress/plpython_trigger][15/66:943] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.352 UTC [22014][client backend] [pg_regress/plpython_trigger][15/70:947] ERROR: TD["new"] dictionary key at ordinal position 0 is not a string 2025-03-05 13:38:24.352 UTC [22014][client backend] [pg_regress/plpython_trigger][15/70:947] CONTEXT: while modifying trigger row PL/Python function "stupid6" 2025-03-05 13:38:24.352 UTC [22014][client backend] [pg_regress/plpython_trigger][15/70:947] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.354 UTC [22014][client backend] [pg_regress/plpython_trigger][15/74:951] ERROR: key "a" found in TD["new"] does not exist as a column in the triggering row 2025-03-05 13:38:24.354 UTC [22014][client backend] [pg_regress/plpython_trigger][15/74:951] CONTEXT: while modifying trigger row PL/Python function "stupid7" 2025-03-05 13:38:24.354 UTC [22014][client backend] [pg_regress/plpython_trigger][15/74:951] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.356 UTC [22014][client backend] [pg_regress/plpython_trigger][15/78:955] ERROR: key "a" found in TD["new"] does not exist as a column in the triggering row 2025-03-05 13:38:24.356 UTC [22014][client backend] [pg_regress/plpython_trigger][15/78:955] CONTEXT: while modifying trigger row PL/Python function "stupid7u" 2025-03-05 13:38:24.356 UTC [22014][client backend] [pg_regress/plpython_trigger][15/78:955] STATEMENT: UPDATE trigger_test SET v = 'null' WHERE i = 0; 2025-03-05 13:38:24.357 UTC [22014][client backend] [pg_regress/plpython_trigger][15/80:0] ERROR: trigger functions can only be called as triggers 2025-03-05 13:38:24.357 UTC [22014][client backend] [pg_regress/plpython_trigger][15/80:0] STATEMENT: SELECT stupid7(); 2025-03-05 13:38:24.410 UTC [22014][client backend] [pg_regress/plpython_trigger][15/137:0] ERROR: cannot set generated column "j" 2025-03-05 13:38:24.410 UTC [22014][client backend] [pg_regress/plpython_trigger][15/137:0] CONTEXT: while modifying trigger row PL/Python function "generated_test_func1" 2025-03-05 13:38:24.410 UTC [22014][client backend] [pg_regress/plpython_trigger][15/137:0] STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2025-03-05 13:38:24.418 UTC [22014][client backend] [pg_regress/plpython_trigger][:0] LOG: disconnection: session time: 0:00:00.170 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:24.494 UTC [22028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:24.495 UTC [22028][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:24.495 UTC [22028][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_types 2025-03-05 13:38:24.634 UTC [22028][client backend] [pg_regress/plpython_types][16/66:0] ERROR: value for domain booltrue violates check constraint "booltrue_check" 2025-03-05 13:38:24.634 UTC [22028][client backend] [pg_regress/plpython_types][16/66:0] STATEMENT: SELECT * FROM test_type_conversion_booltrue(false, true); 2025-03-05 13:38:24.634 UTC [22028][client backend] [pg_regress/plpython_types][16/67:0] ERROR: value for domain booltrue violates check constraint "booltrue_check" 2025-03-05 13:38:24.634 UTC [22028][client backend] [pg_regress/plpython_types][16/67:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_booltrue" 2025-03-05 13:38:24.634 UTC [22028][client backend] [pg_regress/plpython_types][16/67:0] STATEMENT: SELECT * FROM test_type_conversion_booltrue(true, false); 2025-03-05 13:38:24.636 UTC [22028][client backend] [pg_regress/plpython_types][16/71:0] ERROR: value for domain uint2 violates check constraint "uint2_check" 2025-03-05 13:38:24.636 UTC [22028][client backend] [pg_regress/plpython_types][16/71:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_uint2" 2025-03-05 13:38:24.636 UTC [22028][client backend] [pg_regress/plpython_types][16/71:0] STATEMENT: SELECT * FROM test_type_conversion_uint2(100::uint2, -50); 2025-03-05 13:38:24.638 UTC [22028][client backend] [pg_regress/plpython_types][16/76:0] ERROR: value for domain nnint violates check constraint "nnint_check" 2025-03-05 13:38:24.638 UTC [22028][client backend] [pg_regress/plpython_types][16/76:0] STATEMENT: SELECT * FROM test_type_conversion_nnint(null, 20); 2025-03-05 13:38:24.638 UTC [22028][client backend] [pg_regress/plpython_types][16/77:0] ERROR: value for domain nnint violates check constraint "nnint_check" 2025-03-05 13:38:24.638 UTC [22028][client backend] [pg_regress/plpython_types][16/77:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_nnint" 2025-03-05 13:38:24.638 UTC [22028][client backend] [pg_regress/plpython_types][16/77:0] STATEMENT: SELECT * FROM test_type_conversion_nnint(10, null); 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/81:0] ERROR: value for domain bytea10 violates check constraint "bytea10_check" 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/81:0] STATEMENT: SELECT * FROM test_type_conversion_bytea10('hello world', 'hello wold'); 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/82:0] ERROR: value for domain bytea10 violates check constraint "bytea10_check" 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/82:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_bytea10" 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/82:0] STATEMENT: SELECT * FROM test_type_conversion_bytea10('hello word', 'hello world'); 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/83:0] ERROR: value for domain bytea10 violates check constraint "bytea10_check" 2025-03-05 13:38:24.641 UTC [22028][client backend] [pg_regress/plpython_types][16/83:0] STATEMENT: SELECT * FROM test_type_conversion_bytea10(null, 'hello word'); 2025-03-05 13:38:24.642 UTC [22028][client backend] [pg_regress/plpython_types][16/84:0] ERROR: value for domain bytea10 violates check constraint "bytea10_check" 2025-03-05 13:38:24.642 UTC [22028][client backend] [pg_regress/plpython_types][16/84:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_bytea10" 2025-03-05 13:38:24.642 UTC [22028][client backend] [pg_regress/plpython_types][16/84:0] STATEMENT: SELECT * FROM test_type_conversion_bytea10('hello word', null); 2025-03-05 13:38:24.689 UTC [22028][client backend] [pg_regress/plpython_types][16/116:0] ERROR: invalid input syntax for type integer: "abc" 2025-03-05 13:38:24.689 UTC [22028][client backend] [pg_regress/plpython_types][16/116:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_array_mixed2" 2025-03-05 13:38:24.689 UTC [22028][client backend] [pg_regress/plpython_types][16/116:0] STATEMENT: SELECT * FROM test_type_conversion_array_mixed2(); 2025-03-05 13:38:24.692 UTC [22028][client backend] [pg_regress/plpython_types][16/122:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.692 UTC [22028][client backend] [pg_regress/plpython_types][16/122:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_md_array_out" 2025-03-05 13:38:24.692 UTC [22028][client backend] [pg_regress/plpython_types][16/122:0] STATEMENT: select test_type_conversion_md_array_out(); 2025-03-05 13:38:24.693 UTC [22028][client backend] [pg_regress/plpython_types][16/124:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.693 UTC [22028][client backend] [pg_regress/plpython_types][16/124:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_md_array_out" 2025-03-05 13:38:24.693 UTC [22028][client backend] [pg_regress/plpython_types][16/124:0] STATEMENT: select test_type_conversion_md_array_out(); 2025-03-05 13:38:24.694 UTC [22028][client backend] [pg_regress/plpython_types][16/126:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.694 UTC [22028][client backend] [pg_regress/plpython_types][16/126:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_md_array_out" 2025-03-05 13:38:24.694 UTC [22028][client backend] [pg_regress/plpython_types][16/126:0] STATEMENT: select test_type_conversion_md_array_out(); 2025-03-05 13:38:24.695 UTC [22028][client backend] [pg_regress/plpython_types][16/128:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.695 UTC [22028][client backend] [pg_regress/plpython_types][16/128:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_md_array_out" 2025-03-05 13:38:24.695 UTC [22028][client backend] [pg_regress/plpython_types][16/128:0] STATEMENT: select test_type_conversion_md_array_out(); 2025-03-05 13:38:24.696 UTC [22028][client backend] [pg_regress/plpython_types][16/130:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.696 UTC [22028][client backend] [pg_regress/plpython_types][16/130:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed" 2025-03-05 13:38:24.696 UTC [22028][client backend] [pg_regress/plpython_types][16/130:0] STATEMENT: SELECT * FROM test_type_conversion_mdarray_malformed(); 2025-03-05 13:38:24.697 UTC [22028][client backend] [pg_regress/plpython_types][16/132:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.697 UTC [22028][client backend] [pg_regress/plpython_types][16/132:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed2" 2025-03-05 13:38:24.697 UTC [22028][client backend] [pg_regress/plpython_types][16/132:0] STATEMENT: SELECT * FROM test_type_conversion_mdarray_malformed2(); 2025-03-05 13:38:24.698 UTC [22028][client backend] [pg_regress/plpython_types][16/134:0] ERROR: multidimensional arrays must have array expressions with matching dimensions 2025-03-05 13:38:24.698 UTC [22028][client backend] [pg_regress/plpython_types][16/134:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed3" 2025-03-05 13:38:24.698 UTC [22028][client backend] [pg_regress/plpython_types][16/134:0] STATEMENT: SELECT * FROM test_type_conversion_mdarray_malformed3(); 2025-03-05 13:38:24.701 UTC [22028][client backend] [pg_regress/plpython_types][16/136:0] ERROR: number of array dimensions exceeds the maximum allowed (6) 2025-03-05 13:38:24.701 UTC [22028][client backend] [pg_regress/plpython_types][16/136:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_toodeep" 2025-03-05 13:38:24.701 UTC [22028][client backend] [pg_regress/plpython_types][16/136:0] STATEMENT: SELECT * FROM test_type_conversion_mdarray_toodeep(); 2025-03-05 13:38:24.707 UTC [22028][client backend] [pg_regress/plpython_types][16/144:0] ERROR: return value of function with array return type is not a Python sequence 2025-03-05 13:38:24.707 UTC [22028][client backend] [pg_regress/plpython_types][16/144:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_array_error" 2025-03-05 13:38:24.707 UTC [22028][client backend] [pg_regress/plpython_types][16/144:0] STATEMENT: SELECT * FROM test_type_conversion_array_error(); 2025-03-05 13:38:24.714 UTC [22028][client backend] [pg_regress/plpython_types][16/150:0] ERROR: value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check" 2025-03-05 13:38:24.714 UTC [22028][client backend] [pg_regress/plpython_types][16/150:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_array_domain_check_violation" 2025-03-05 13:38:24.714 UTC [22028][client backend] [pg_regress/plpython_types][16/150:0] STATEMENT: SELECT * FROM test_type_conversion_array_domain_check_violation(); 2025-03-05 13:38:24.717 UTC [22028][client backend] [pg_regress/plpython_types][16/155:0] ERROR: value for domain uint2 violates check constraint "uint2_check" 2025-03-05 13:38:24.717 UTC [22028][client backend] [pg_regress/plpython_types][16/155:0] CONTEXT: while creating return value PL/Python function "test_build_uint2_array" 2025-03-05 13:38:24.717 UTC [22028][client backend] [pg_regress/plpython_types][16/155:0] STATEMENT: select test_build_uint2_array(-1::int2); 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/157:0] ERROR: return value of function with array return type is not a Python sequence 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/157:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_domain_array" 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/157:0] STATEMENT: select test_type_conversion_domain_array(array[2,4]); 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/158:0] ERROR: return value of function with array return type is not a Python sequence 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/158:0] CONTEXT: while creating return value PL/Python function "test_type_conversion_domain_array" 2025-03-05 13:38:24.719 UTC [22028][client backend] [pg_regress/plpython_types][16/158:0] STATEMENT: select test_type_conversion_domain_array(array[4,2]); 2025-03-05 13:38:24.721 UTC [22028][client backend] [pg_regress/plpython_types][16/161:0] ERROR: value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check" 2025-03-05 13:38:24.721 UTC [22028][client backend] [pg_regress/plpython_types][16/161:0] STATEMENT: select test_type_conversion_domain_array2(array[4,2]); 2025-03-05 13:38:24.738 UTC [22028][client backend] [pg_regress/plpython_types][16/169:0] ERROR: KeyError: 'bonus' 2025-03-05 13:38:24.738 UTC [22028][client backend] [pg_regress/plpython_types][16/169:0] CONTEXT: Traceback (most recent call last): PL/Python function "test_composite_table_input", line 2, in return e['basesalary'] + e['bonus'] PL/Python function "test_composite_table_input" 2025-03-05 13:38:24.738 UTC [22028][client backend] [pg_regress/plpython_types][16/169:0] STATEMENT: SELECT name, test_composite_table_input(employee.*) FROM employee; 2025-03-05 13:38:24.751 UTC [22028][client backend] [pg_regress/plpython_types][16/181:0] ERROR: value for domain nnint violates check constraint "nnint_check" 2025-03-05 13:38:24.751 UTC [22028][client backend] [pg_regress/plpython_types][16/181:0] CONTEXT: while creating return value PL/Python function "nnint_test" 2025-03-05 13:38:24.751 UTC [22028][client backend] [pg_regress/plpython_types][16/181:0] STATEMENT: SELECT nnint_test(3, null); 2025-03-05 13:38:24.758 UTC [22028][client backend] [pg_regress/plpython_types][16/185:0] ERROR: value for domain ordered_named_pair violates check constraint "ordered_named_pair_check" 2025-03-05 13:38:24.758 UTC [22028][client backend] [pg_regress/plpython_types][16/185:0] STATEMENT: SELECT read_ordered_named_pair(row(2, 1)); 2025-03-05 13:38:24.759 UTC [22028][client backend] [pg_regress/plpython_types][16/188:0] ERROR: value for domain ordered_named_pair violates check constraint "ordered_named_pair_check" 2025-03-05 13:38:24.759 UTC [22028][client backend] [pg_regress/plpython_types][16/188:0] CONTEXT: while creating return value PL/Python function "build_ordered_named_pair" 2025-03-05 13:38:24.759 UTC [22028][client backend] [pg_regress/plpython_types][16/188:0] STATEMENT: SELECT build_ordered_named_pair(2,1); 2025-03-05 13:38:24.761 UTC [22028][client backend] [pg_regress/plpython_types][16/191:0] ERROR: value for domain ordered_named_pair violates check constraint "ordered_named_pair_check" 2025-03-05 13:38:24.761 UTC [22028][client backend] [pg_regress/plpython_types][16/191:0] CONTEXT: while creating return value PL/Python function "build_ordered_named_pairs" 2025-03-05 13:38:24.761 UTC [22028][client backend] [pg_regress/plpython_types][16/191:0] STATEMENT: SELECT build_ordered_named_pairs(2,1); 2025-03-05 13:38:24.776 UTC [22028][client backend] [pg_regress/plpython_types][:0] LOG: disconnection: session time: 0:00:00.285 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:24.850 UTC [22072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:24.851 UTC [22072][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:24.851 UTC [22072][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_error 2025-03-05 13:38:24.921 UTC [22072][client backend] [pg_regress/plpython_error][17/2:1084] ERROR: could not compile PL/Python function "python_syntax_error" 2025-03-05 13:38:24.921 UTC [22072][client backend] [pg_regress/plpython_error][17/2:1084] DETAIL: SyntaxError: invalid syntax (, line 2) 2025-03-05 13:38:24.921 UTC [22072][client backend] [pg_regress/plpython_error][17/2:1084] STATEMENT: /* Flat out Python syntax error */ CREATE FUNCTION python_syntax_error() RETURNS text AS '.syntaxerror' LANGUAGE plpython3u; 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/5:0] ERROR: could not compile PL/Python function "python_syntax_error" 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/5:0] DETAIL: SyntaxError: invalid syntax (, line 2) 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/5:0] STATEMENT: SELECT python_syntax_error(); 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/6:0] ERROR: could not compile PL/Python function "python_syntax_error" 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/6:0] DETAIL: SyntaxError: invalid syntax (, line 2) 2025-03-05 13:38:24.926 UTC [22072][client backend] [pg_regress/plpython_error][17/6:0] STATEMENT: /* Run the function twice to check if the hashtable entry gets cleaned up */ SELECT python_syntax_error(); 2025-03-05 13:38:24.928 UTC [22072][client backend] [pg_regress/plpython_error][17/9:0] ERROR: spiexceptions.SyntaxError: syntax error at or near "syntax" at character 1 2025-03-05 13:38:24.928 UTC [22072][client backend] [pg_regress/plpython_error][17/9:0] QUERY: syntax error 2025-03-05 13:38:24.928 UTC [22072][client backend] [pg_regress/plpython_error][17/9:0] CONTEXT: Traceback (most recent call last): PL/Python function "sql_syntax_error", line 1, in plpy.execute("syntax error") PL/Python function "sql_syntax_error" 2025-03-05 13:38:24.928 UTC [22072][client backend] [pg_regress/plpython_error][17/9:0] STATEMENT: SELECT sql_syntax_error(); 2025-03-05 13:38:24.929 UTC [22072][client backend] [pg_regress/plpython_error][17/11:0] ERROR: IndexError: list index out of range 2025-03-05 13:38:24.929 UTC [22072][client backend] [pg_regress/plpython_error][17/11:0] CONTEXT: Traceback (most recent call last): PL/Python function "exception_index_invalid", line 1, in return args[1] PL/Python function "exception_index_invalid" 2025-03-05 13:38:24.929 UTC [22072][client backend] [pg_regress/plpython_error][17/11:0] STATEMENT: SELECT exception_index_invalid('test'); 2025-03-05 13:38:24.932 UTC [22072][client backend] [pg_regress/plpython_error][17/13:0] ERROR: spiexceptions.UndefinedFunction: function test5(unknown) does not exist at character 8 2025-03-05 13:38:24.932 UTC [22072][client backend] [pg_regress/plpython_error][17/13:0] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2025-03-05 13:38:24.932 UTC [22072][client backend] [pg_regress/plpython_error][17/13:0] QUERY: SELECT test5('foo') 2025-03-05 13:38:24.932 UTC [22072][client backend] [pg_regress/plpython_error][17/13:0] CONTEXT: Traceback (most recent call last): PL/Python function "exception_index_invalid_nested", line 1, in rv = plpy.execute("SELECT test5('foo')") PL/Python function "exception_index_invalid_nested" 2025-03-05 13:38:24.932 UTC [22072][client backend] [pg_regress/plpython_error][17/13:0] STATEMENT: SELECT exception_index_invalid_nested(); 2025-03-05 13:38:24.938 UTC [22072][client backend] [pg_regress/plpython_error][17/15:0] ERROR: spiexceptions.UndefinedObject: type "test" does not exist 2025-03-05 13:38:24.938 UTC [22072][client backend] [pg_regress/plpython_error][17/15:0] CONTEXT: Traceback (most recent call last): PL/Python function "invalid_type_uncaught", line 3, in SD["plan"] = plpy.prepare(q, [ "test" ]) PL/Python function "invalid_type_uncaught" 2025-03-05 13:38:24.938 UTC [22072][client backend] [pg_regress/plpython_error][17/15:0] STATEMENT: SELECT invalid_type_uncaught('rick'); 2025-03-05 13:38:24.943 UTC [22072][client backend] [pg_regress/plpython_error][17/19:0] ERROR: plpy.Error: type "test" does not exist 2025-03-05 13:38:24.943 UTC [22072][client backend] [pg_regress/plpython_error][17/19:0] CONTEXT: Traceback (most recent call last): PL/Python function "invalid_type_reraised", line 6, in plpy.error(str(ex)) PL/Python function "invalid_type_reraised" 2025-03-05 13:38:24.943 UTC [22072][client backend] [pg_regress/plpython_error][17/19:0] STATEMENT: SELECT invalid_type_reraised('rick'); 2025-03-05 13:38:24.960 UTC [22072][client backend] [pg_regress/plpython_error][17/23:0] ERROR: plpy.Error: boom 2025-03-05 13:38:24.960 UTC [22072][client backend] [pg_regress/plpython_error][17/23:0] CONTEXT: Traceback (most recent call last): PL/Python function "nested_error", line 10, in fun3() PL/Python function "nested_error", line 8, in fun3 fun2() PL/Python function "nested_error", line 5, in fun2 fun1() PL/Python function "nested_error", line 2, in fun1 plpy.error("boom") PL/Python function "nested_error" 2025-03-05 13:38:24.960 UTC [22072][client backend] [pg_regress/plpython_error][17/23:0] STATEMENT: SELECT nested_error(); 2025-03-05 13:38:24.965 UTC [22072][client backend] [pg_regress/plpython_error][17/25:0] ERROR: plpy.Error: boom 2025-03-05 13:38:24.965 UTC [22072][client backend] [pg_regress/plpython_error][17/25:0] CONTEXT: Traceback (most recent call last): PL/Python function "nested_error_raise", line 10, in fun3() PL/Python function "nested_error_raise", line 8, in fun3 fun2() PL/Python function "nested_error_raise", line 5, in fun2 fun1() PL/Python function "nested_error_raise", line 2, in fun1 raise plpy.Error("boom") PL/Python function "nested_error_raise" 2025-03-05 13:38:24.965 UTC [22072][client backend] [pg_regress/plpython_error][17/25:0] STATEMENT: SELECT nested_error_raise(); 2025-03-05 13:38:24.967 UTC [22072][client backend] [pg_regress/plpython_error][17/27:0] WARNING: boom 2025-03-05 13:38:24.967 UTC [22072][client backend] [pg_regress/plpython_error][17/27:0] CONTEXT: PL/Python function "nested_warning" 2025-03-05 13:38:24.969 UTC [22072][client backend] [pg_regress/plpython_error][17/29:0] ERROR: AttributeError: module 'plpy' has no attribute 'nonexistent' 2025-03-05 13:38:24.969 UTC [22072][client backend] [pg_regress/plpython_error][17/29:0] CONTEXT: Traceback (most recent call last): PL/Python function "toplevel_attribute_error", line 2, in plpy.nonexistent PL/Python function "toplevel_attribute_error" 2025-03-05 13:38:24.969 UTC [22072][client backend] [pg_regress/plpython_error][17/29:0] STATEMENT: SELECT toplevel_attribute_error(); 2025-03-05 13:38:24.981 UTC [22072][client backend] [pg_regress/plpython_error][17/34:0] ERROR: spiexceptions.DivisionByZero: division by zero 2025-03-05 13:38:24.981 UTC [22072][client backend] [pg_regress/plpython_error][17/34:0] CONTEXT: Traceback (most recent call last): PL/Python function "python_traceback", line 11, in first() PL/Python function "python_traceback", line 3, in first second() PL/Python function "python_traceback", line 6, in second third() PL/Python function "python_traceback", line 9, in third plpy.execute("select sql_error()") PL/Python function "python_traceback" 2025-03-05 13:38:24.981 UTC [22072][client backend] [pg_regress/plpython_error][17/34:0] STATEMENT: SELECT python_traceback(); 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/35:0] ERROR: division by zero 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/35:0] CONTEXT: SQL statement "select 1/0" PL/pgSQL function sql_error() line 3 at SQL statement 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/35:0] STATEMENT: SELECT sql_error(); 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/36:0] ERROR: spiexceptions.DivisionByZero: division by zero 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/36:0] CONTEXT: Traceback (most recent call last): PL/Python function "python_traceback", line 11, in first() PL/Python function "python_traceback", line 3, in first second() PL/Python function "python_traceback", line 6, in second third() PL/Python function "python_traceback", line 9, in third plpy.execute("select sql_error()") PL/Python function "python_traceback" SQL statement "select python_traceback()" PL/pgSQL function python_from_sql_error() line 3 at SQL statement 2025-03-05 13:38:24.988 UTC [22072][client backend] [pg_regress/plpython_error][17/36:0] STATEMENT: SELECT python_from_sql_error(); 2025-03-05 13:38:24.989 UTC [22072][client backend] [pg_regress/plpython_error][17/37:0] ERROR: spiexceptions.DivisionByZero: division by zero 2025-03-05 13:38:24.989 UTC [22072][client backend] [pg_regress/plpython_error][17/37:0] CONTEXT: Traceback (most recent call last): PL/Python function "sql_from_python_error", line 2, in plpy.execute("select sql_error()") PL/Python function "sql_from_python_error" 2025-03-05 13:38:24.989 UTC [22072][client backend] [pg_regress/plpython_error][17/37:0] STATEMENT: SELECT sql_from_python_error(); 2025-03-05 13:38:25.020 UTC [22072][client backend] [pg_regress/plpython_error][17/47:0] ERROR: plpy.SPIError: SPI_execute failed: SPI_ERROR_TRANSACTION 2025-03-05 13:38:25.020 UTC [22072][client backend] [pg_regress/plpython_error][17/47:0] CONTEXT: Traceback (most recent call last): PL/Python function "manual_subxact", line 2, in plpy.execute("savepoint save") PL/Python function "manual_subxact" 2025-03-05 13:38:25.020 UTC [22072][client backend] [pg_regress/plpython_error][17/47:0] STATEMENT: SELECT manual_subxact(); 2025-03-05 13:38:25.028 UTC [22072][client backend] [pg_regress/plpython_error][17/49:0] ERROR: plpy.SPIError: SPI_execute_plan failed: SPI_ERROR_TRANSACTION 2025-03-05 13:38:25.028 UTC [22072][client backend] [pg_regress/plpython_error][17/49:0] CONTEXT: Traceback (most recent call last): PL/Python function "manual_subxact_prepared", line 4, in plpy.execute(save) PL/Python function "manual_subxact_prepared" 2025-03-05 13:38:25.028 UTC [22072][client backend] [pg_regress/plpython_error][17/49:0] STATEMENT: SELECT manual_subxact_prepared(); 2025-03-05 13:38:25.041 UTC [22072][client backend] [pg_regress/plpython_error][17/58:0] ERROR: error fetching next item from iterator 2025-03-05 13:38:25.041 UTC [22072][client backend] [pg_regress/plpython_error][17/58:0] DETAIL: spiexceptions.InvalidDatetimeFormat: invalid value "xy" for "DD" 2025-03-05 13:38:25.041 UTC [22072][client backend] [pg_regress/plpython_error][17/58:0] CONTEXT: Traceback (most recent call last): PL/Python function "python_error_detail" 2025-03-05 13:38:25.041 UTC [22072][client backend] [pg_regress/plpython_error][17/58:0] STATEMENT: SELECT python_error_detail(); 2025-03-05 13:38:25.044 UTC [22072][client backend] [pg_regress/plpython_error][:0] LOG: disconnection: session time: 0:00:00.195 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:25.196 UTC [22097][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:25.198 UTC [22097][client backend] [[unknown]][18/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:25.198 UTC [22097][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_ereport 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] LOG: log 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL: some detail 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT: PL/Python function "elog_test" 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] STATEMENT: SELECT elog_test(); 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] WARNING: warning 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL: some detail 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT: PL/Python function "elog_test" 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] ERROR: plpy.Error: stop on error 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL: some detail 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] HINT: some hint 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT: Traceback (most recent call last): PL/Python function "elog_test", line 18, in plpy.error('stop on error', detail='some detail', hint='some hint') PL/Python function "elog_test" 2025-03-05 13:38:25.264 UTC [22097][client backend] [pg_regress/plpython_ereport][18/3:0] STATEMENT: SELECT elog_test(); 2025-03-05 13:38:25.281 UTC [22097][client backend] [pg_regress/plpython_ereport][18/7:0] ERROR: ValueError: invalid SQLSTATE code 2025-03-05 13:38:25.281 UTC [22097][client backend] [pg_regress/plpython_ereport][18/7:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 1, in plpy.info('wrong sqlstate', sqlstate='54444A') PL/Python anonymous code block 2025-03-05 13:38:25.281 UTC [22097][client backend] [pg_regress/plpython_ereport][18/7:0] STATEMENT: DO $$ plpy.info('wrong sqlstate', sqlstate='54444A') $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/8:0] ERROR: TypeError: 'blabla' is an invalid keyword argument for this function 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/8:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 1, in plpy.info('unsupported argument', blabla='fooboo') PL/Python anonymous code block 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/8:0] STATEMENT: DO $$ plpy.info('unsupported argument', blabla='fooboo') $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/9:0] ERROR: TypeError: argument 'message' given by name and position 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/9:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 1, in plpy.info('first message', message='second message') PL/Python anonymous code block 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/9:0] STATEMENT: DO $$ plpy.info('first message', message='second message') $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/10:0] ERROR: TypeError: argument 'message' given by name and position 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/10:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 1, in plpy.info('first message', 'second message', message='third message') PL/Python anonymous code block 2025-03-05 13:38:25.282 UTC [22097][client backend] [pg_regress/plpython_ereport][18/10:0] STATEMENT: DO $$ plpy.info('first message', 'second message', message='third message') $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.284 UTC [22097][client backend] [pg_regress/plpython_ereport][18/12:0] ERROR: plpy.Error: hello 2025-03-05 13:38:25.284 UTC [22097][client backend] [pg_regress/plpython_ereport][18/12:0] DETAIL: world 2025-03-05 13:38:25.284 UTC [22097][client backend] [pg_regress/plpython_ereport][18/12:0] CONTEXT: Traceback (most recent call last): PL/Python function "raise_exception", line 9, in plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v)) PL/Python function "raise_exception" 2025-03-05 13:38:25.284 UTC [22097][client backend] [pg_regress/plpython_ereport][18/12:0] STATEMENT: SELECT raise_exception('hello', 'world'); 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/13:0] ERROR: plpy.Error: message text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/13:0] DETAIL: detail text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/13:0] CONTEXT: Traceback (most recent call last): PL/Python function "raise_exception", line 9, in plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v)) PL/Python function "raise_exception" 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/13:0] STATEMENT: SELECT raise_exception('message text', 'detail text', _sqlstate => 'YY333'); 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/14:0] ERROR: plpy.Error: message text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/14:0] DETAIL: detail text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/14:0] HINT: hint text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/14:0] CONTEXT: Traceback (most recent call last): PL/Python function "raise_exception", line 9, in plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v)) PL/Python function "raise_exception" 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/14:0] STATEMENT: SELECT raise_exception(_message => 'message text', _detail => 'detail text', _hint => 'hint text', _sqlstate => 'XX555', _schema_name => 'schema text', _table_name => 'table text', _column_name => 'column text', _datatype_name => 'datatype text', _constraint_name => 'constraint text'); 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/15:0] ERROR: plpy.Error: message text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/15:0] HINT: hint text 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/15:0] CONTEXT: Traceback (most recent call last): PL/Python function "raise_exception", line 9, in plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v)) PL/Python function "raise_exception" 2025-03-05 13:38:25.293 UTC [22097][client backend] [pg_regress/plpython_ereport][18/15:0] STATEMENT: SELECT raise_exception(_message => 'message text', _hint => 'hint text', _schema_name => 'schema text', _column_name => 'column text', _constraint_name => 'constraint text'); 2025-03-05 13:38:25.309 UTC [22097][client backend] [pg_regress/plpython_ereport][18/17:0] ERROR: plpy.SPIError: plpy.Error: my message 2025-03-05 13:38:25.309 UTC [22097][client backend] [pg_regress/plpython_ereport][18/17:0] HINT: some hint 2025-03-05 13:38:25.309 UTC [22097][client backend] [pg_regress/plpython_ereport][18/17:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 6, in raise e PL/Python anonymous code block, line 3, in __plpython_inline_block plpy.execute("select raise_exception(_message => 'my message', _sqlstate => 'XX987', _hint => 'some hint', _table_name => 'users_tab', _datatype_name => 'user_type')") PL/Python anonymous code block 2025-03-05 13:38:25.309 UTC [22097][client backend] [pg_regress/plpython_ereport][18/17:0] STATEMENT: DO $$ try: plpy.execute("select raise_exception(_message => 'my message', _sqlstate => 'XX987', _hint => 'some hint', _table_name => 'users_tab', _datatype_name => 'user_type')") except Exception as e: plpy.info(e.spidata) raise e $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.310 UTC [22097][client backend] [pg_regress/plpython_ereport][18/18:0] ERROR: plpy.Error: my message 2025-03-05 13:38:25.310 UTC [22097][client backend] [pg_regress/plpython_ereport][18/18:0] HINT: some hint 2025-03-05 13:38:25.310 UTC [22097][client backend] [pg_regress/plpython_ereport][18/18:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 6, in raise e PL/Python anonymous code block, line 3, in __plpython_inline_block plpy.error(message = 'my message', sqlstate = 'XX987', hint = 'some hint', table_name = 'users_tab', datatype_name = 'user_type') PL/Python anonymous code block 2025-03-05 13:38:25.310 UTC [22097][client backend] [pg_regress/plpython_ereport][18/18:0] STATEMENT: DO $$ try: plpy.error(message = 'my message', sqlstate = 'XX987', hint = 'some hint', table_name = 'users_tab', datatype_name = 'user_type') except Exception as e: plpy.info('sqlstate: %s, hint: %s, table_name: %s, datatype_name: %s' % (e.sqlstate, e.hint, e.table_name, e.datatype_name)) raise e $$ LANGUAGE plpython3u; 2025-03-05 13:38:25.313 UTC [22097][client backend] [pg_regress/plpython_ereport][:0] LOG: disconnection: session time: 0:00:00.124 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:25.403 UTC [22116][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:25.404 UTC [22116][client backend] [[unknown]][19/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:25.404 UTC [22116][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_unicode 2025-03-05 13:38:25.498 UTC [22116][client backend] [pg_regress/plpython_unicode][:0] LOG: disconnection: session time: 0:00:00.096 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:25.611 UTC [22134][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:25.613 UTC [22134][client backend] [[unknown]][20/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:25.613 UTC [22134][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_quote 2025-03-05 13:38:25.687 UTC [22134][client backend] [pg_regress/plpython_quote][:0] LOG: disconnection: session time: 0:00:00.078 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:25.750 UTC [22146][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:25.751 UTC [22146][client backend] [[unknown]][21/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:25.751 UTC [22146][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_composite 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/68:0] ERROR: length of returned sequence did not match number of columns in row 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/68:0] CONTEXT: while creating return value PL/Python function "changing_test" 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/68:0] STATEMENT: SELECT * FROM changing_test(); 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/69:0] ERROR: length of returned sequence did not match number of columns in row 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/69:0] CONTEXT: while creating return value PL/Python function "changing_test" 2025-03-05 13:38:25.835 UTC [22146][client backend] [pg_regress/plpython_composite][21/69:0] STATEMENT: SELECT * FROM changing_test(); 2025-03-05 13:38:25.842 UTC [22146][client backend] [pg_regress/plpython_composite][21/86:0] ERROR: key "v3" not found in mapping 2025-03-05 13:38:25.842 UTC [22146][client backend] [pg_regress/plpython_composite][21/86:0] HINT: To return null in a column, add the value None to the mapping with the key named after the column. 2025-03-05 13:38:25.842 UTC [22146][client backend] [pg_regress/plpython_composite][21/86:0] CONTEXT: while creating return value PL/Python function "return_record_2" 2025-03-05 13:38:25.842 UTC [22146][client backend] [pg_regress/plpython_composite][21/86:0] STATEMENT: SELECT * FROM return_record_2('v4') AS (v1 int, v3 int, v2 int); 2025-03-05 13:38:25.846 UTC [22146][client backend] [pg_regress/plpython_composite][21/94:0] ERROR: malformed record literal: "first" 2025-03-05 13:38:25.846 UTC [22146][client backend] [pg_regress/plpython_composite][21/94:0] DETAIL: Missing left parenthesis. 2025-03-05 13:38:25.846 UTC [22146][client backend] [pg_regress/plpython_composite][21/94:0] HINT: To return a composite type in an array, return the composite type as a Python tuple, e.g., "[('foo',)]". 2025-03-05 13:38:25.846 UTC [22146][client backend] [pg_regress/plpython_composite][21/94:0] CONTEXT: while creating return value PL/Python function "composite_type_as_list_broken" 2025-03-05 13:38:25.846 UTC [22146][client backend] [pg_regress/plpython_composite][21/94:0] STATEMENT: SELECT * FROM composite_type_as_list_broken(); 2025-03-05 13:38:25.850 UTC [22146][client backend] [pg_regress/plpython_composite][:0] LOG: disconnection: session time: 0:00:00.101 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:25.922 UTC [22161][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:25.923 UTC [22161][client backend] [[unknown]][22/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:25.923 UTC [22161][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_subtransaction 2025-03-05 13:38:25.951 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/7:1157] ERROR: spiexceptions.InvalidTextRepresentation: invalid input syntax for type integer: "oops" at character 40 2025-03-05 13:38:25.951 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/7:1157] QUERY: INSERT INTO subtransaction_tbl VALUES ('oops') 2025-03-05 13:38:25.951 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/7:1157] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_ctx_test", line 6, in plpy.execute("INSERT INTO subtransaction_tbl VALUES ('oops')") PL/Python function "subtransaction_ctx_test" 2025-03-05 13:38:25.951 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/7:1157] STATEMENT: SELECT subtransaction_ctx_test('SPI'); 2025-03-05 13:38:25.952 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/10:1162] ERROR: Exception: Python exception 2025-03-05 13:38:25.952 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/10:1162] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_ctx_test", line 8, in raise Exception("Python exception") PL/Python function "subtransaction_ctx_test" 2025-03-05 13:38:25.952 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/10:1162] STATEMENT: SELECT subtransaction_ctx_test('Python'); 2025-03-05 13:38:25.955 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/14:1168] ERROR: spiexceptions.SyntaxError: syntax error at or near "error" at character 1 2025-03-05 13:38:25.955 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/14:1168] QUERY: error 2025-03-05 13:38:25.955 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/14:1168] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_nested_test", line 8, in plpy.execute("error") PL/Python function "subtransaction_nested_test" 2025-03-05 13:38:25.955 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/14:1168] STATEMENT: SELECT subtransaction_nested_test(); 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/32:0] ERROR: ValueError: this subtransaction has not been entered 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/32:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_exit_without_enter", line 2, in plpy.subtransaction().__exit__(None, None, None) PL/Python function "subtransaction_exit_without_enter" 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/32:0] STATEMENT: SELECT subtransaction_exit_without_enter(); 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/33:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/33:0] CONTEXT: PL/Python function "subtransaction_enter_without_exit" 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/34:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/34:0] CONTEXT: PL/Python function "subtransaction_exit_twice" 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/34:0] ERROR: ValueError: this subtransaction has not been entered 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/34:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_exit_twice", line 3, in plpy.subtransaction().__exit__(None, None, None) PL/Python function "subtransaction_exit_twice" 2025-03-05 13:38:25.965 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/34:0] STATEMENT: SELECT subtransaction_exit_twice(); 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/35:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/35:0] CONTEXT: PL/Python function "subtransaction_enter_twice" 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/35:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/35:0] CONTEXT: PL/Python function "subtransaction_enter_twice" 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/36:0] ERROR: ValueError: this subtransaction has already been exited 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/36:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_exit_same_subtransaction_twice", line 5, in s.__exit__(None, None, None) PL/Python function "subtransaction_exit_same_subtransaction_twice" 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/36:0] STATEMENT: SELECT subtransaction_exit_same_subtransaction_twice(); 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/37:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/37:0] CONTEXT: PL/Python function "subtransaction_enter_same_subtransaction_twice" 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/37:0] ERROR: ValueError: this subtransaction has already been entered 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/37:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_enter_same_subtransaction_twice", line 4, in s.__enter__() PL/Python function "subtransaction_enter_same_subtransaction_twice" 2025-03-05 13:38:25.966 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/37:0] STATEMENT: SELECT subtransaction_enter_same_subtransaction_twice(); 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/38:0] ERROR: ValueError: this subtransaction has already been entered 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/38:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_enter_subtransaction_in_with", line 3, in s.__enter__() PL/Python function "subtransaction_enter_subtransaction_in_with" 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/38:0] STATEMENT: SELECT subtransaction_enter_subtransaction_in_with(); 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/39:0] ERROR: ValueError: this subtransaction has already been exited 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/39:0] CONTEXT: Traceback (most recent call last): PL/Python function "subtransaction_exit_subtransaction_in_with", line 6, in raise ValueError(e) PL/Python function "subtransaction_exit_subtransaction_in_with" 2025-03-05 13:38:25.967 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/39:0] STATEMENT: SELECT subtransaction_exit_subtransaction_in_with(); 2025-03-05 13:38:25.969 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/42:1203] WARNING: Caught a SPI error from an explicit subtransaction 2025-03-05 13:38:25.969 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/42:1203] CONTEXT: PL/Python function "subtransaction_mix_explicit_and_implicit" 2025-03-05 13:38:25.969 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/42:1203] WARNING: Caught a SPI error 2025-03-05 13:38:25.969 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/42:1203] CONTEXT: PL/Python function "subtransaction_mix_explicit_and_implicit" 2025-03-05 13:38:25.988 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/61:0] ERROR: ValueError: iterating a cursor in an aborted subtransaction 2025-03-05 13:38:25.988 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/61:0] CONTEXT: Traceback (most recent call last): PL/Python function "cursor_aborted_subxact", line 8, in fetched = cur.fetch(10) PL/Python function "cursor_aborted_subxact" 2025-03-05 13:38:25.988 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/61:0] STATEMENT: SELECT cursor_aborted_subxact(); 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/62:1227] ERROR: ValueError: iterating a cursor in an aborted subtransaction 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/62:1227] CONTEXT: Traceback (most recent call last): PL/Python function "cursor_plan_aborted_subxact", line 10, in fetched = cur.fetch(5) PL/Python function "cursor_plan_aborted_subxact" 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/62:1227] STATEMENT: SELECT cursor_plan_aborted_subxact(); 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/63:0] ERROR: ValueError: closing a cursor in an aborted subtransaction 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/63:0] CONTEXT: Traceback (most recent call last): PL/Python function "cursor_close_aborted_subxact", line 7, in cur.close() PL/Python function "cursor_close_aborted_subxact" 2025-03-05 13:38:25.990 UTC [22161][client backend] [pg_regress/plpython_subtransaction][22/63:0] STATEMENT: SELECT cursor_close_aborted_subxact(); 2025-03-05 13:38:25.993 UTC [22161][client backend] [pg_regress/plpython_subtransaction][:0] LOG: disconnection: session time: 0:00:00.071 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:26.040 UTC [22167][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:26.042 UTC [22167][client backend] [[unknown]][23/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:26.042 UTC [22167][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_transaction 2025-03-05 13:38:26.092 UTC [22167][client backend] [pg_regress/plpython_transaction][23/31:1275] ERROR: spiexceptions.InvalidTransactionTermination: invalid transaction termination 2025-03-05 13:38:26.092 UTC [22167][client backend] [pg_regress/plpython_transaction][23/31:1275] CONTEXT: Traceback (most recent call last): PL/Python function "transaction_test2", line 5, in plpy.commit() PL/Python function "transaction_test2" 2025-03-05 13:38:26.092 UTC [22167][client backend] [pg_regress/plpython_transaction][23/31:1275] STATEMENT: SELECT transaction_test2(); 2025-03-05 13:38:26.093 UTC [22167][client backend] [pg_regress/plpython_transaction][23/34:1278] ERROR: spiexceptions.InvalidTransactionTermination: spiexceptions.InvalidTransactionTermination: invalid transaction termination 2025-03-05 13:38:26.093 UTC [22167][client backend] [pg_regress/plpython_transaction][23/34:1278] CONTEXT: Traceback (most recent call last): PL/Python function "transaction_test3", line 2, in plpy.execute("CALL transaction_test1()") PL/Python function "transaction_test3" 2025-03-05 13:38:26.093 UTC [22167][client backend] [pg_regress/plpython_transaction][23/34:1278] STATEMENT: SELECT transaction_test3(); 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/37:0] ERROR: spiexceptions.InvalidTransactionTermination: spiexceptions.InvalidTransactionTermination: invalid transaction termination 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/37:0] CONTEXT: Traceback (most recent call last): PL/Python function "transaction_test4", line 2, in plpy.execute("DO LANGUAGE plpython3u $x$ plpy.commit() $x$") PL/Python function "transaction_test4" 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/37:0] STATEMENT: SELECT transaction_test4(); 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/38:0] WARNING: forcibly aborting a subtransaction that has not been exited 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/38:0] CONTEXT: PL/Python anonymous code block 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/38:0] ERROR: spiexceptions.InvalidTransactionTermination: cannot commit while a subtransaction is active 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/38:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 4, in plpy.commit() PL/Python anonymous code block 2025-03-05 13:38:26.095 UTC [22167][client backend] [pg_regress/plpython_transaction][23/38:0] STATEMENT: DO LANGUAGE plpython3u $$ s = plpy.subtransaction() s.enter() plpy.commit() $$; 2025-03-05 13:38:26.113 UTC [22167][client backend] [pg_regress/plpython_transaction][23/53:0] ERROR: spiexceptions.DivisionByZero: division by zero 2025-03-05 13:38:26.113 UTC [22167][client backend] [pg_regress/plpython_transaction][23/53:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 3, in plpy.execute("INSERT INTO test1 (a) VALUES (12/(%s-2))" % row['x']) PL/Python anonymous code block 2025-03-05 13:38:26.113 UTC [22167][client backend] [pg_regress/plpython_transaction][23/53:0] STATEMENT: DO LANGUAGE plpython3u $$ for row in plpy.cursor("SELECT * FROM test2 ORDER BY x"): plpy.execute("INSERT INTO test1 (a) VALUES (12/(%s-2))" % row['x']) plpy.commit() $$; 2025-03-05 13:38:26.135 UTC [22167][client backend] [pg_regress/plpython_transaction][23/77:0] ERROR: spiexceptions.ForeignKeyViolation: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" 2025-03-05 13:38:26.135 UTC [22167][client backend] [pg_regress/plpython_transaction][23/77:0] DETAIL: Key (f1)=(0) is not present in table "testpk". 2025-03-05 13:38:26.135 UTC [22167][client backend] [pg_regress/plpython_transaction][23/77:0] CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 4, in plpy.commit() PL/Python anonymous code block 2025-03-05 13:38:26.135 UTC [22167][client backend] [pg_regress/plpython_transaction][23/77:0] STATEMENT: DO LANGUAGE plpython3u $$ # this insert will fail during commit: plpy.execute("INSERT INTO testfk VALUES (0)") plpy.commit() plpy.warning('should not get here') $$; 2025-03-05 13:38:26.148 UTC [22167][client backend] [pg_regress/plpython_transaction][:0] LOG: disconnection: session time: 0:00:00.108 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:26.204 UTC [22180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:38:26.212 UTC [22180][client backend] [[unknown]][24/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/pl/plpython/tmp_check/data/pg_hba.conf:117) 2025-03-05 13:38:26.212 UTC [22180][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_drop 2025-03-05 13:38:26.335 UTC [22180][client backend] [pg_regress/plpython_drop][:0] LOG: disconnection: session time: 0:00:00.131 user=postgres database=pl_regression host=[local] 2025-03-05 13:38:26.367 UTC [21678][postmaster] LOG: received fast shutdown request 2025-03-05 13:38:26.367 UTC [21678][postmaster] LOG: aborting any active transactions 2025-03-05 13:38:26.375 UTC [21678][postmaster] LOG: background worker "logical replication launcher" (PID 21694) exited with exit code 1 2025-03-05 13:38:26.389 UTC [21684][checkpointer] LOG: shutting down 2025-03-05 13:38:26.389 UTC [21684][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:38:26.426 UTC [21684][checkpointer] LOG: checkpoint complete: wrote 1059 buffers (6.5%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.022 s, sync=0.001 s, total=0.037 s; sync files=0, longest=0.000 s, average=0.000 s; distance=5295 kB, estimate=5295 kB; lsn=0/1CB6368, redo lsn=0/1CB6368 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 21684 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f7c2e851f31] postgres: checkpointer (ExceptionalCondition+0xe6)[0x55c8b8cc4ac5] postgres: checkpointer (pgstat_report_stat+0x17e)[0x55c8b89e3c2c] postgres: checkpointer (+0xe96ed6)[0x55c8b89e3ed6] postgres: checkpointer (shmem_exit+0x6b)[0x55c8b8931a89] postgres: checkpointer (+0xde4d27)[0x55c8b8931d27] postgres: checkpointer (proc_exit+0x3d)[0x55c8b8931e53] postgres: checkpointer (CheckpointWriteDelay+0x0)[0x55c8b87f5196] postgres: checkpointer (postmaster_child_launch+0x1f1)[0x55c8b87f5a53] postgres: checkpointer (+0xcaed1d)[0x55c8b87fbd1d] postgres: checkpointer (PostmasterMain+0x1e36)[0x55c8b880087f] postgres: checkpointer (main+0x2a2)[0x55c8b859c0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f7c2d64824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f7c2d648305] postgres: checkpointer (_start+0x21)[0x55c8b7f713a1] 2025-03-05 13:38:28.693 UTC [21678][postmaster] LOG: checkpointer process (PID 21684) was terminated by signal 6: Aborted 2025-03-05 13:38:28.693 UTC [21678][postmaster] LOG: terminating any other active server processes 2025-03-05 13:38:28.693 UTC [21678][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:38:28.728 UTC [21678][postmaster] LOG: database system is shut down