2025-01-28 23:34:12.526 UTC [22225][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-01-28 23:34:12.526 UTC [22225][postmaster] LOG:  listening on Unix socket "/tmp/pg_regress-eIL574/.s.PGSQL.65312"
2025-01-28 23:34:12.564 UTC [22247][startup] LOG:  database system was shut down at 2025-01-28 23:33:59 UTC
2025-01-28 23:34:12.583 UTC [22225][postmaster] LOG:  database system is ready to accept connections
2025-01-28 23:34:12.613 UTC [22258][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:12.613 UTC [22258][client backend] [[unknown]][:0] FATAL:  the database system is starting up
2025-01-28 23:34:12.687 UTC [22275][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:12.689 UTC [22275][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-01-28 23:34:12.689 UTC [22275][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-01-28 23:34:12.824 UTC [22275][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.138 user=postgres database=postgres host=[local]
2025-01-28 23:34:12.897 UTC [22283][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:12.899 UTC [22283][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-01-28 23:34:12.899 UTC [22283][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=pg_regress
2025-01-28 23:34:13.082 UTC [22283][client backend] [pg_regress][:0] LOG:  disconnection: session time: 0:00:00.186 user=postgres database=postgres host=[local]
2025-01-28 23:34:13.138 UTC [22286][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:13.140 UTC [22286][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-01-28 23:34:13.140 UTC [22286][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_schema
2025-01-28 23:34:13.333 UTC [22286][client backend] [pg_regress/plpython_schema][:0] LOG:  disconnection: session time: 0:00:00.196 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:13.430 UTC [22294][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:13.434 UTC [22294][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-01-28 23:34:13.434 UTC [22294][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_populate
2025-01-28 23:34:13.493 UTC [22294][client backend] [pg_regress/plpython_populate][:0] LOG:  disconnection: session time: 0:00:00.064 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:13.560 UTC [22299][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:13.562 UTC [22299][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-01-28 23:34:13.562 UTC [22299][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_test
2025-01-28 23:34:13.674 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] LOG:  log
2025-01-28 23:34:13.674 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT:  PL/Python function "elog_test_basic"
2025-01-28 23:34:13.674 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] STATEMENT:  SELECT elog_test_basic();
2025-01-28 23:34:13.675 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] WARNING:  warning
2025-01-28 23:34:13.675 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT:  PL/Python function "elog_test_basic"
2025-01-28 23:34:13.675 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] ERROR:  plpy.Error: error
2025-01-28 23:34:13.675 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "elog_test_basic", line 10, in <module>
	    plpy.error('error')
	PL/Python function "elog_test_basic"
2025-01-28 23:34:13.675 UTC [22299][client backend] [pg_regress/plpython_test][4/12:0] STATEMENT:  SELECT elog_test_basic();
2025-01-28 23:34:13.678 UTC [22299][client backend] [pg_regress/plpython_test][:0] LOG:  disconnection: session time: 0:00:00.121 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:13.804 UTC [22308][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:13.806 UTC [22308][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-01-28 23:34:13.806 UTC [22308][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_do
2025-01-28 23:34:13.868 UTC [22308][client backend] [pg_regress/plpython_do][5/3:0] ERROR:  Exception: error test
2025-01-28 23:34:13.868 UTC [22308][client backend] [pg_regress/plpython_do][5/3:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 1, in <module>
	    raise Exception("error test") 
	PL/Python anonymous code block
2025-01-28 23:34:13.868 UTC [22308][client backend] [pg_regress/plpython_do][5/3:0] STATEMENT:  DO $$ raise Exception("error test") $$ LANGUAGE plpython3u;
2025-01-28 23:34:13.876 UTC [22308][client backend] [pg_regress/plpython_do][:0] LOG:  disconnection: session time: 0:00:00.080 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:13.968 UTC [22314][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:13.970 UTC [22314][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-01-28 23:34:13.970 UTC [22314][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_global
2025-01-28 23:34:14.047 UTC [22314][client backend] [pg_regress/plpython_global][:0] LOG:  disconnection: session time: 0:00:00.083 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.123 UTC [22324][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.124 UTC [22324][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-01-28 23:34:14.124 UTC [22324][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_import
2025-01-28 23:34:14.207 UTC [22324][client backend] [pg_regress/plpython_import][:0] LOG:  disconnection: session time: 0:00:00.086 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.277 UTC [22330][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.278 UTC [22330][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-01-28 23:34:14.278 UTC [22330][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_spi
2025-01-28 23:34:14.414 UTC [22330][client backend] [pg_regress/plpython_spi][8/20:802] ERROR:  plpy.Error: command did not produce a result set
2025-01-28 23:34:14.414 UTC [22330][client backend] [pg_regress/plpython_spi][8/20:802] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "result_metadata_test", line 6, in <module>
	    plpy.info(result.colnames())
	PL/Python function "result_metadata_test"
2025-01-28 23:34:14.414 UTC [22330][client backend] [pg_regress/plpython_spi][8/20:802] STATEMENT:  SELECT result_metadata_test($$CREATE TEMPORARY TABLE foo1 (a int, b text)$$);
2025-01-28 23:34:14.480 UTC [22330][client backend] [pg_regress/plpython_spi][8/57:0] ERROR:  TypeError: Expected sequence of 1 argument, got 2: ['a', 'b']
2025-01-28 23:34:14.480 UTC [22330][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 <module>
	    c = plpy.cursor(plan, ["a", "b"])
	PL/Python function "cursor_plan_wrong_args"
2025-01-28 23:34:14.480 UTC [22330][client backend] [pg_regress/plpython_spi][8/57:0] STATEMENT:  SELECT cursor_plan_wrong_args();
2025-01-28 23:34:14.504 UTC [22330][client backend] [pg_regress/plpython_spi][:0] LOG:  disconnection: session time: 0:00:00.230 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.563 UTC [22340][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.565 UTC [22340][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-01-28 23:34:14.565 UTC [22340][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_newline
2025-01-28 23:34:14.619 UTC [22340][client backend] [pg_regress/plpython_newline][:0] LOG:  disconnection: session time: 0:00:00.060 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.691 UTC [22345][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.692 UTC [22345][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-01-28 23:34:14.692 UTC [22345][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_void
2025-01-28 23:34:14.742 UTC [22345][client backend] [pg_regress/plpython_void][10/6:0] ERROR:  PL/Python function with return type "void" did not return None
2025-01-28 23:34:14.742 UTC [22345][client backend] [pg_regress/plpython_void][10/6:0] CONTEXT:  while creating return value
	PL/Python function "test_void_func2"
2025-01-28 23:34:14.742 UTC [22345][client backend] [pg_regress/plpython_void][10/6:0] STATEMENT:  SELECT test_void_func2();
2025-01-28 23:34:14.746 UTC [22345][client backend] [pg_regress/plpython_void][:0] LOG:  disconnection: session time: 0:00:00.057 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.807 UTC [22356][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.810 UTC [22356][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-01-28 23:34:14.810 UTC [22356][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_call
2025-01-28 23:34:14.857 UTC [22356][client backend] [pg_regress/plpython_call][11/5:0] ERROR:  PL/Python procedure did not return None
2025-01-28 23:34:14.857 UTC [22356][client backend] [pg_regress/plpython_call][11/5:0] CONTEXT:  PL/Python procedure "test_proc2"
2025-01-28 23:34:14.857 UTC [22356][client backend] [pg_regress/plpython_call][11/5:0] STATEMENT:  CALL test_proc2();
2025-01-28 23:34:14.885 UTC [22356][client backend] [pg_regress/plpython_call][:0] LOG:  disconnection: session time: 0:00:00.078 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:14.952 UTC [22368][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:14.954 UTC [22368][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-01-28 23:34:14.954 UTC [22368][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_params
2025-01-28 23:34:15.014 UTC [22368][client backend] [pg_regress/plpython_params][:0] LOG:  disconnection: session time: 0:00:00.063 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:15.087 UTC [22374][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:15.091 UTC [22374][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-01-28 23:34:15.091 UTC [22374][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_setof
2025-01-28 23:34:15.164 UTC [22374][client backend] [pg_regress/plpython_setof][13/3:0] ERROR:  returned object cannot be iterated
2025-01-28 23:34:15.164 UTC [22374][client backend] [pg_regress/plpython_setof][13/3:0] DETAIL:  PL/Python set-returning functions must return an iterable object.
2025-01-28 23:34:15.164 UTC [22374][client backend] [pg_regress/plpython_setof][13/3:0] CONTEXT:  PL/Python function "test_setof_error"
2025-01-28 23:34:15.164 UTC [22374][client backend] [pg_regress/plpython_setof][13/3:0] STATEMENT:  SELECT test_setof_error();
2025-01-28 23:34:15.195 UTC [22374][client backend] [pg_regress/plpython_setof][:0] LOG:  disconnection: session time: 0:00:00.109 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:15.268 UTC [22385][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:15.269 UTC [22385][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-01-28 23:34:15.269 UTC [22385][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_record
2025-01-28 23:34:15.321 UTC [22385][client backend] [pg_regress/plpython_record][14/64:0] ERROR:  key "second" not found in mapping
2025-01-28 23:34:15.321 UTC [22385][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-01-28 23:34:15.321 UTC [22385][client backend] [pg_regress/plpython_record][14/64:0] CONTEXT:  while creating return value
	PL/Python function "test_type_record_error1"
2025-01-28 23:34:15.321 UTC [22385][client backend] [pg_regress/plpython_record][14/64:0] STATEMENT:  SELECT * FROM test_type_record_error1();
2025-01-28 23:34:15.322 UTC [22385][client backend] [pg_regress/plpython_record][14/66:0] ERROR:  length of returned sequence did not match number of columns in row
2025-01-28 23:34:15.322 UTC [22385][client backend] [pg_regress/plpython_record][14/66:0] CONTEXT:  while creating return value
	PL/Python function "test_type_record_error2"
2025-01-28 23:34:15.322 UTC [22385][client backend] [pg_regress/plpython_record][14/66:0] STATEMENT:  SELECT * FROM test_type_record_error2();
2025-01-28 23:34:15.323 UTC [22385][client backend] [pg_regress/plpython_record][14/68:0] ERROR:  attribute "second" does not exist in Python object
2025-01-28 23:34:15.323 UTC [22385][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-01-28 23:34:15.323 UTC [22385][client backend] [pg_regress/plpython_record][14/68:0] CONTEXT:  while creating return value
	PL/Python function "test_type_record_error3"
2025-01-28 23:34:15.323 UTC [22385][client backend] [pg_regress/plpython_record][14/68:0] STATEMENT:  SELECT * FROM test_type_record_error3();
2025-01-28 23:34:15.324 UTC [22385][client backend] [pg_regress/plpython_record][14/70:0] ERROR:  malformed record literal: "foo"
2025-01-28 23:34:15.324 UTC [22385][client backend] [pg_regress/plpython_record][14/70:0] DETAIL:  Missing left parenthesis.
2025-01-28 23:34:15.324 UTC [22385][client backend] [pg_regress/plpython_record][14/70:0] CONTEXT:  while creating return value
	PL/Python function "test_type_record_error4"
2025-01-28 23:34:15.324 UTC [22385][client backend] [pg_regress/plpython_record][14/70:0] STATEMENT:  SELECT * FROM test_type_record_error4();
2025-01-28 23:34:15.327 UTC [22385][client backend] [pg_regress/plpython_record][:0] LOG:  disconnection: session time: 0:00:00.059 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:15.392 UTC [22392][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:15.396 UTC [22392][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-01-28 23:34:15.396 UTC [22392][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_trigger
2025-01-28 23:34:15.525 UTC [22392][client backend] [pg_regress/plpython_trigger][15/45:0] ERROR:  unexpected return value from trigger procedure
2025-01-28 23:34:15.525 UTC [22392][client backend] [pg_regress/plpython_trigger][15/45:0] DETAIL:  Expected None or a string.
2025-01-28 23:34:15.525 UTC [22392][client backend] [pg_regress/plpython_trigger][15/45:0] CONTEXT:  PL/Python function "stupid1"
2025-01-28 23:34:15.525 UTC [22392][client backend] [pg_regress/plpython_trigger][15/45:0] STATEMENT:  INSERT INTO trigger_test VALUES (1, 'one');
2025-01-28 23:34:15.529 UTC [22392][client backend] [pg_regress/plpython_trigger][15/49:926] WARNING:  PL/Python trigger function returned "MODIFY" in a DELETE trigger -- ignored
2025-01-28 23:34:15.529 UTC [22392][client backend] [pg_regress/plpython_trigger][15/49:926] CONTEXT:  PL/Python function "stupid2"
2025-01-28 23:34:15.533 UTC [22392][client backend] [pg_regress/plpython_trigger][15/54:931] ERROR:  unexpected return value from trigger procedure
2025-01-28 23:34:15.533 UTC [22392][client backend] [pg_regress/plpython_trigger][15/54:931] DETAIL:  Expected None, "OK", "SKIP", or "MODIFY".
2025-01-28 23:34:15.533 UTC [22392][client backend] [pg_regress/plpython_trigger][15/54:931] CONTEXT:  PL/Python function "stupid3"
2025-01-28 23:34:15.533 UTC [22392][client backend] [pg_regress/plpython_trigger][15/54:931] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.542 UTC [22392][client backend] [pg_regress/plpython_trigger][15/58:935] ERROR:  unexpected return value from trigger procedure
2025-01-28 23:34:15.542 UTC [22392][client backend] [pg_regress/plpython_trigger][15/58:935] DETAIL:  Expected None, "OK", "SKIP", or "MODIFY".
2025-01-28 23:34:15.542 UTC [22392][client backend] [pg_regress/plpython_trigger][15/58:935] CONTEXT:  PL/Python function "stupid3u"
2025-01-28 23:34:15.542 UTC [22392][client backend] [pg_regress/plpython_trigger][15/58:935] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.548 UTC [22392][client backend] [pg_regress/plpython_trigger][15/62:939] ERROR:  TD["new"] deleted, cannot modify row
2025-01-28 23:34:15.548 UTC [22392][client backend] [pg_regress/plpython_trigger][15/62:939] CONTEXT:  while modifying trigger row
	PL/Python function "stupid4"
2025-01-28 23:34:15.548 UTC [22392][client backend] [pg_regress/plpython_trigger][15/62:939] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.550 UTC [22392][client backend] [pg_regress/plpython_trigger][15/66:943] ERROR:  TD["new"] is not a dictionary
2025-01-28 23:34:15.550 UTC [22392][client backend] [pg_regress/plpython_trigger][15/66:943] CONTEXT:  while modifying trigger row
	PL/Python function "stupid5"
2025-01-28 23:34:15.550 UTC [22392][client backend] [pg_regress/plpython_trigger][15/66:943] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.554 UTC [22392][client backend] [pg_regress/plpython_trigger][15/70:947] ERROR:  TD["new"] dictionary key at ordinal position 0 is not a string
2025-01-28 23:34:15.554 UTC [22392][client backend] [pg_regress/plpython_trigger][15/70:947] CONTEXT:  while modifying trigger row
	PL/Python function "stupid6"
2025-01-28 23:34:15.554 UTC [22392][client backend] [pg_regress/plpython_trigger][15/70:947] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.559 UTC [22392][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-01-28 23:34:15.559 UTC [22392][client backend] [pg_regress/plpython_trigger][15/74:951] CONTEXT:  while modifying trigger row
	PL/Python function "stupid7"
2025-01-28 23:34:15.559 UTC [22392][client backend] [pg_regress/plpython_trigger][15/74:951] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.563 UTC [22392][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-01-28 23:34:15.563 UTC [22392][client backend] [pg_regress/plpython_trigger][15/78:955] CONTEXT:  while modifying trigger row
	PL/Python function "stupid7u"
2025-01-28 23:34:15.563 UTC [22392][client backend] [pg_regress/plpython_trigger][15/78:955] STATEMENT:  UPDATE trigger_test SET v = 'null' WHERE i = 0;
2025-01-28 23:34:15.566 UTC [22392][client backend] [pg_regress/plpython_trigger][15/80:0] ERROR:  trigger functions can only be called as triggers
2025-01-28 23:34:15.566 UTC [22392][client backend] [pg_regress/plpython_trigger][15/80:0] STATEMENT:  SELECT stupid7();
2025-01-28 23:34:15.638 UTC [22392][client backend] [pg_regress/plpython_trigger][15/137:0] ERROR:  cannot set generated column "j"
2025-01-28 23:34:15.638 UTC [22392][client backend] [pg_regress/plpython_trigger][15/137:0] CONTEXT:  while modifying trigger row
	PL/Python function "generated_test_func1"
2025-01-28 23:34:15.638 UTC [22392][client backend] [pg_regress/plpython_trigger][15/137:0] STATEMENT:  INSERT INTO trigger_test_generated (i) VALUES (1);
2025-01-28 23:34:15.646 UTC [22392][client backend] [pg_regress/plpython_trigger][:0] LOG:  disconnection: session time: 0:00:00.253 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:15.682 UTC [22412][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:15.683 UTC [22412][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-01-28 23:34:15.683 UTC [22412][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_types
2025-01-28 23:34:15.754 UTC [22412][client backend] [pg_regress/plpython_types][16/66:0] ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2025-01-28 23:34:15.754 UTC [22412][client backend] [pg_regress/plpython_types][16/66:0] STATEMENT:  SELECT * FROM test_type_conversion_booltrue(false, true);
2025-01-28 23:34:15.754 UTC [22412][client backend] [pg_regress/plpython_types][16/67:0] ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2025-01-28 23:34:15.754 UTC [22412][client backend] [pg_regress/plpython_types][16/67:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_booltrue"
2025-01-28 23:34:15.754 UTC [22412][client backend] [pg_regress/plpython_types][16/67:0] STATEMENT:  SELECT * FROM test_type_conversion_booltrue(true, false);
2025-01-28 23:34:15.756 UTC [22412][client backend] [pg_regress/plpython_types][16/71:0] ERROR:  value for domain uint2 violates check constraint "uint2_check"
2025-01-28 23:34:15.756 UTC [22412][client backend] [pg_regress/plpython_types][16/71:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_uint2"
2025-01-28 23:34:15.756 UTC [22412][client backend] [pg_regress/plpython_types][16/71:0] STATEMENT:  SELECT * FROM test_type_conversion_uint2(100::uint2, -50);
2025-01-28 23:34:15.758 UTC [22412][client backend] [pg_regress/plpython_types][16/76:0] ERROR:  value for domain nnint violates check constraint "nnint_check"
2025-01-28 23:34:15.758 UTC [22412][client backend] [pg_regress/plpython_types][16/76:0] STATEMENT:  SELECT * FROM test_type_conversion_nnint(null, 20);
2025-01-28 23:34:15.759 UTC [22412][client backend] [pg_regress/plpython_types][16/77:0] ERROR:  value for domain nnint violates check constraint "nnint_check"
2025-01-28 23:34:15.759 UTC [22412][client backend] [pg_regress/plpython_types][16/77:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_nnint"
2025-01-28 23:34:15.759 UTC [22412][client backend] [pg_regress/plpython_types][16/77:0] STATEMENT:  SELECT * FROM test_type_conversion_nnint(10, null);
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/81:0] ERROR:  value for domain bytea10 violates check constraint "bytea10_check"
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/81:0] STATEMENT:  SELECT * FROM test_type_conversion_bytea10('hello world', 'hello wold');
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/82:0] ERROR:  value for domain bytea10 violates check constraint "bytea10_check"
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/82:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_bytea10"
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/82:0] STATEMENT:  SELECT * FROM test_type_conversion_bytea10('hello word', 'hello world');
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/83:0] ERROR:  value for domain bytea10 violates check constraint "bytea10_check"
2025-01-28 23:34:15.761 UTC [22412][client backend] [pg_regress/plpython_types][16/83:0] STATEMENT:  SELECT * FROM test_type_conversion_bytea10(null, 'hello word');
2025-01-28 23:34:15.762 UTC [22412][client backend] [pg_regress/plpython_types][16/84:0] ERROR:  value for domain bytea10 violates check constraint "bytea10_check"
2025-01-28 23:34:15.762 UTC [22412][client backend] [pg_regress/plpython_types][16/84:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_bytea10"
2025-01-28 23:34:15.762 UTC [22412][client backend] [pg_regress/plpython_types][16/84:0] STATEMENT:  SELECT * FROM test_type_conversion_bytea10('hello word', null);
2025-01-28 23:34:15.783 UTC [22412][client backend] [pg_regress/plpython_types][16/116:0] ERROR:  invalid input syntax for type integer: "abc"
2025-01-28 23:34:15.783 UTC [22412][client backend] [pg_regress/plpython_types][16/116:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_array_mixed2"
2025-01-28 23:34:15.783 UTC [22412][client backend] [pg_regress/plpython_types][16/116:0] STATEMENT:  SELECT * FROM test_type_conversion_array_mixed2();
2025-01-28 23:34:15.788 UTC [22412][client backend] [pg_regress/plpython_types][16/122:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.788 UTC [22412][client backend] [pg_regress/plpython_types][16/122:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_md_array_out"
2025-01-28 23:34:15.788 UTC [22412][client backend] [pg_regress/plpython_types][16/122:0] STATEMENT:  select test_type_conversion_md_array_out();
2025-01-28 23:34:15.789 UTC [22412][client backend] [pg_regress/plpython_types][16/124:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.789 UTC [22412][client backend] [pg_regress/plpython_types][16/124:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_md_array_out"
2025-01-28 23:34:15.789 UTC [22412][client backend] [pg_regress/plpython_types][16/124:0] STATEMENT:  select test_type_conversion_md_array_out();
2025-01-28 23:34:15.790 UTC [22412][client backend] [pg_regress/plpython_types][16/126:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.790 UTC [22412][client backend] [pg_regress/plpython_types][16/126:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_md_array_out"
2025-01-28 23:34:15.790 UTC [22412][client backend] [pg_regress/plpython_types][16/126:0] STATEMENT:  select test_type_conversion_md_array_out();
2025-01-28 23:34:15.796 UTC [22412][client backend] [pg_regress/plpython_types][16/128:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.796 UTC [22412][client backend] [pg_regress/plpython_types][16/128:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_md_array_out"
2025-01-28 23:34:15.796 UTC [22412][client backend] [pg_regress/plpython_types][16/128:0] STATEMENT:  select test_type_conversion_md_array_out();
2025-01-28 23:34:15.797 UTC [22412][client backend] [pg_regress/plpython_types][16/130:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.797 UTC [22412][client backend] [pg_regress/plpython_types][16/130:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_mdarray_malformed"
2025-01-28 23:34:15.797 UTC [22412][client backend] [pg_regress/plpython_types][16/130:0] STATEMENT:  SELECT * FROM test_type_conversion_mdarray_malformed();
2025-01-28 23:34:15.798 UTC [22412][client backend] [pg_regress/plpython_types][16/132:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.798 UTC [22412][client backend] [pg_regress/plpython_types][16/132:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_mdarray_malformed2"
2025-01-28 23:34:15.798 UTC [22412][client backend] [pg_regress/plpython_types][16/132:0] STATEMENT:  SELECT * FROM test_type_conversion_mdarray_malformed2();
2025-01-28 23:34:15.799 UTC [22412][client backend] [pg_regress/plpython_types][16/134:0] ERROR:  multidimensional arrays must have array expressions with matching dimensions
2025-01-28 23:34:15.799 UTC [22412][client backend] [pg_regress/plpython_types][16/134:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_mdarray_malformed3"
2025-01-28 23:34:15.799 UTC [22412][client backend] [pg_regress/plpython_types][16/134:0] STATEMENT:  SELECT * FROM test_type_conversion_mdarray_malformed3();
2025-01-28 23:34:15.800 UTC [22412][client backend] [pg_regress/plpython_types][16/136:0] ERROR:  number of array dimensions exceeds the maximum allowed (6)
2025-01-28 23:34:15.800 UTC [22412][client backend] [pg_regress/plpython_types][16/136:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_mdarray_toodeep"
2025-01-28 23:34:15.800 UTC [22412][client backend] [pg_regress/plpython_types][16/136:0] STATEMENT:  SELECT * FROM test_type_conversion_mdarray_toodeep();
2025-01-28 23:34:15.808 UTC [22412][client backend] [pg_regress/plpython_types][16/144:0] ERROR:  return value of function with array return type is not a Python sequence
2025-01-28 23:34:15.808 UTC [22412][client backend] [pg_regress/plpython_types][16/144:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_array_error"
2025-01-28 23:34:15.808 UTC [22412][client backend] [pg_regress/plpython_types][16/144:0] STATEMENT:  SELECT * FROM test_type_conversion_array_error();
2025-01-28 23:34:15.817 UTC [22412][client backend] [pg_regress/plpython_types][16/150:0] ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2025-01-28 23:34:15.817 UTC [22412][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-01-28 23:34:15.817 UTC [22412][client backend] [pg_regress/plpython_types][16/150:0] STATEMENT:  SELECT * FROM test_type_conversion_array_domain_check_violation();
2025-01-28 23:34:15.820 UTC [22412][client backend] [pg_regress/plpython_types][16/155:0] ERROR:  value for domain uint2 violates check constraint "uint2_check"
2025-01-28 23:34:15.820 UTC [22412][client backend] [pg_regress/plpython_types][16/155:0] CONTEXT:  while creating return value
	PL/Python function "test_build_uint2_array"
2025-01-28 23:34:15.820 UTC [22412][client backend] [pg_regress/plpython_types][16/155:0] STATEMENT:  select test_build_uint2_array(-1::int2);
2025-01-28 23:34:15.821 UTC [22412][client backend] [pg_regress/plpython_types][16/157:0] ERROR:  return value of function with array return type is not a Python sequence
2025-01-28 23:34:15.821 UTC [22412][client backend] [pg_regress/plpython_types][16/157:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_domain_array"
2025-01-28 23:34:15.821 UTC [22412][client backend] [pg_regress/plpython_types][16/157:0] STATEMENT:  select test_type_conversion_domain_array(array[2,4]);
2025-01-28 23:34:15.822 UTC [22412][client backend] [pg_regress/plpython_types][16/158:0] ERROR:  return value of function with array return type is not a Python sequence
2025-01-28 23:34:15.822 UTC [22412][client backend] [pg_regress/plpython_types][16/158:0] CONTEXT:  while creating return value
	PL/Python function "test_type_conversion_domain_array"
2025-01-28 23:34:15.822 UTC [22412][client backend] [pg_regress/plpython_types][16/158:0] STATEMENT:  select test_type_conversion_domain_array(array[4,2]);
2025-01-28 23:34:15.823 UTC [22412][client backend] [pg_regress/plpython_types][16/161:0] ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2025-01-28 23:34:15.823 UTC [22412][client backend] [pg_regress/plpython_types][16/161:0] STATEMENT:  select test_type_conversion_domain_array2(array[4,2]);
2025-01-28 23:34:15.842 UTC [22412][client backend] [pg_regress/plpython_types][16/169:0] ERROR:  KeyError: 'bonus'
2025-01-28 23:34:15.842 UTC [22412][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 <module>
	    return e['basesalary'] + e['bonus']
	PL/Python function "test_composite_table_input"
2025-01-28 23:34:15.842 UTC [22412][client backend] [pg_regress/plpython_types][16/169:0] STATEMENT:  SELECT name, test_composite_table_input(employee.*) FROM employee;
2025-01-28 23:34:15.856 UTC [22412][client backend] [pg_regress/plpython_types][16/181:0] ERROR:  value for domain nnint violates check constraint "nnint_check"
2025-01-28 23:34:15.856 UTC [22412][client backend] [pg_regress/plpython_types][16/181:0] CONTEXT:  while creating return value
	PL/Python function "nnint_test"
2025-01-28 23:34:15.856 UTC [22412][client backend] [pg_regress/plpython_types][16/181:0] STATEMENT:  SELECT nnint_test(3, null);
2025-01-28 23:34:15.864 UTC [22412][client backend] [pg_regress/plpython_types][16/185:0] ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2025-01-28 23:34:15.864 UTC [22412][client backend] [pg_regress/plpython_types][16/185:0] STATEMENT:  SELECT read_ordered_named_pair(row(2, 1));
2025-01-28 23:34:15.865 UTC [22412][client backend] [pg_regress/plpython_types][16/188:0] ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2025-01-28 23:34:15.865 UTC [22412][client backend] [pg_regress/plpython_types][16/188:0] CONTEXT:  while creating return value
	PL/Python function "build_ordered_named_pair"
2025-01-28 23:34:15.865 UTC [22412][client backend] [pg_regress/plpython_types][16/188:0] STATEMENT:  SELECT build_ordered_named_pair(2,1);
2025-01-28 23:34:15.867 UTC [22412][client backend] [pg_regress/plpython_types][16/191:0] ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2025-01-28 23:34:15.867 UTC [22412][client backend] [pg_regress/plpython_types][16/191:0] CONTEXT:  while creating return value
	PL/Python function "build_ordered_named_pairs"
2025-01-28 23:34:15.867 UTC [22412][client backend] [pg_regress/plpython_types][16/191:0] STATEMENT:  SELECT build_ordered_named_pairs(2,1);
2025-01-28 23:34:15.874 UTC [22412][client backend] [pg_regress/plpython_types][:0] LOG:  disconnection: session time: 0:00:00.193 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:15.944 UTC [22431][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:15.945 UTC [22431][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-01-28 23:34:15.946 UTC [22431][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_error
2025-01-28 23:34:15.986 UTC [22431][client backend] [pg_regress/plpython_error][17/2:1084] ERROR:  could not compile PL/Python function "python_syntax_error"
2025-01-28 23:34:15.986 UTC [22431][client backend] [pg_regress/plpython_error][17/2:1084] DETAIL:  SyntaxError: invalid syntax (<string>, line 2)
2025-01-28 23:34:15.986 UTC [22431][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-01-28 23:34:15.997 UTC [22431][client backend] [pg_regress/plpython_error][17/5:0] ERROR:  could not compile PL/Python function "python_syntax_error"
2025-01-28 23:34:15.997 UTC [22431][client backend] [pg_regress/plpython_error][17/5:0] DETAIL:  SyntaxError: invalid syntax (<string>, line 2)
2025-01-28 23:34:15.997 UTC [22431][client backend] [pg_regress/plpython_error][17/5:0] STATEMENT:  SELECT python_syntax_error();
2025-01-28 23:34:15.998 UTC [22431][client backend] [pg_regress/plpython_error][17/6:0] ERROR:  could not compile PL/Python function "python_syntax_error"
2025-01-28 23:34:15.998 UTC [22431][client backend] [pg_regress/plpython_error][17/6:0] DETAIL:  SyntaxError: invalid syntax (<string>, line 2)
2025-01-28 23:34:15.998 UTC [22431][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-01-28 23:34:15.999 UTC [22431][client backend] [pg_regress/plpython_error][17/9:0] ERROR:  spiexceptions.SyntaxError: syntax error at or near "syntax" at character 1
2025-01-28 23:34:15.999 UTC [22431][client backend] [pg_regress/plpython_error][17/9:0] QUERY:  syntax error
2025-01-28 23:34:15.999 UTC [22431][client backend] [pg_regress/plpython_error][17/9:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "sql_syntax_error", line 1, in <module>
	    plpy.execute("syntax error")
	PL/Python function "sql_syntax_error"
2025-01-28 23:34:15.999 UTC [22431][client backend] [pg_regress/plpython_error][17/9:0] STATEMENT:  SELECT sql_syntax_error();
2025-01-28 23:34:16.000 UTC [22431][client backend] [pg_regress/plpython_error][17/11:0] ERROR:  IndexError: list index out of range
2025-01-28 23:34:16.000 UTC [22431][client backend] [pg_regress/plpython_error][17/11:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "exception_index_invalid", line 1, in <module>
	    return args[1]
	PL/Python function "exception_index_invalid"
2025-01-28 23:34:16.000 UTC [22431][client backend] [pg_regress/plpython_error][17/11:0] STATEMENT:  SELECT exception_index_invalid('test');
2025-01-28 23:34:16.001 UTC [22431][client backend] [pg_regress/plpython_error][17/13:0] ERROR:  spiexceptions.UndefinedFunction: function test5(unknown) does not exist at character 8
2025-01-28 23:34:16.001 UTC [22431][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-01-28 23:34:16.001 UTC [22431][client backend] [pg_regress/plpython_error][17/13:0] QUERY:  SELECT test5('foo')
2025-01-28 23:34:16.001 UTC [22431][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 <module>
	    rv = plpy.execute("SELECT test5('foo')")
	PL/Python function "exception_index_invalid_nested"
2025-01-28 23:34:16.001 UTC [22431][client backend] [pg_regress/plpython_error][17/13:0] STATEMENT:  SELECT exception_index_invalid_nested();
2025-01-28 23:34:16.002 UTC [22431][client backend] [pg_regress/plpython_error][17/15:0] ERROR:  spiexceptions.UndefinedObject: type "test" does not exist
2025-01-28 23:34:16.002 UTC [22431][client backend] [pg_regress/plpython_error][17/15:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "invalid_type_uncaught", line 3, in <module>
	    SD["plan"] = plpy.prepare(q, [ "test" ])
	PL/Python function "invalid_type_uncaught"
2025-01-28 23:34:16.002 UTC [22431][client backend] [pg_regress/plpython_error][17/15:0] STATEMENT:  SELECT invalid_type_uncaught('rick');
2025-01-28 23:34:16.004 UTC [22431][client backend] [pg_regress/plpython_error][17/19:0] ERROR:  plpy.Error: type "test" does not exist
2025-01-28 23:34:16.004 UTC [22431][client backend] [pg_regress/plpython_error][17/19:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "invalid_type_reraised", line 6, in <module>
	    plpy.error(str(ex))
	PL/Python function "invalid_type_reraised"
2025-01-28 23:34:16.004 UTC [22431][client backend] [pg_regress/plpython_error][17/19:0] STATEMENT:  SELECT invalid_type_reraised('rick');
2025-01-28 23:34:16.022 UTC [22431][client backend] [pg_regress/plpython_error][17/23:0] ERROR:  plpy.Error: boom
2025-01-28 23:34:16.022 UTC [22431][client backend] [pg_regress/plpython_error][17/23:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "nested_error", line 10, in <module>
	    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-01-28 23:34:16.022 UTC [22431][client backend] [pg_regress/plpython_error][17/23:0] STATEMENT:  SELECT nested_error();
2025-01-28 23:34:16.023 UTC [22431][client backend] [pg_regress/plpython_error][17/25:0] ERROR:  plpy.Error: boom
2025-01-28 23:34:16.023 UTC [22431][client backend] [pg_regress/plpython_error][17/25:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "nested_error_raise", line 10, in <module>
	    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-01-28 23:34:16.023 UTC [22431][client backend] [pg_regress/plpython_error][17/25:0] STATEMENT:  SELECT nested_error_raise();
2025-01-28 23:34:16.024 UTC [22431][client backend] [pg_regress/plpython_error][17/27:0] WARNING:  boom
2025-01-28 23:34:16.024 UTC [22431][client backend] [pg_regress/plpython_error][17/27:0] CONTEXT:  PL/Python function "nested_warning"
2025-01-28 23:34:16.025 UTC [22431][client backend] [pg_regress/plpython_error][17/29:0] ERROR:  AttributeError: module 'plpy' has no attribute 'nonexistent'
2025-01-28 23:34:16.025 UTC [22431][client backend] [pg_regress/plpython_error][17/29:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "toplevel_attribute_error", line 2, in <module>
	    plpy.nonexistent
	PL/Python function "toplevel_attribute_error"
2025-01-28 23:34:16.025 UTC [22431][client backend] [pg_regress/plpython_error][17/29:0] STATEMENT:  SELECT toplevel_attribute_error();
2025-01-28 23:34:16.028 UTC [22431][client backend] [pg_regress/plpython_error][17/34:0] ERROR:  spiexceptions.DivisionByZero: division by zero
2025-01-28 23:34:16.028 UTC [22431][client backend] [pg_regress/plpython_error][17/34:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "python_traceback", line 11, in <module>
	    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-01-28 23:34:16.028 UTC [22431][client backend] [pg_regress/plpython_error][17/34:0] STATEMENT:  SELECT python_traceback();
2025-01-28 23:34:16.028 UTC [22431][client backend] [pg_regress/plpython_error][17/35:0] ERROR:  division by zero
2025-01-28 23:34:16.028 UTC [22431][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-01-28 23:34:16.028 UTC [22431][client backend] [pg_regress/plpython_error][17/35:0] STATEMENT:  SELECT sql_error();
2025-01-28 23:34:16.029 UTC [22431][client backend] [pg_regress/plpython_error][17/36:0] ERROR:  spiexceptions.DivisionByZero: division by zero
2025-01-28 23:34:16.029 UTC [22431][client backend] [pg_regress/plpython_error][17/36:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "python_traceback", line 11, in <module>
	    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-01-28 23:34:16.029 UTC [22431][client backend] [pg_regress/plpython_error][17/36:0] STATEMENT:  SELECT python_from_sql_error();
2025-01-28 23:34:16.029 UTC [22431][client backend] [pg_regress/plpython_error][17/37:0] ERROR:  spiexceptions.DivisionByZero: division by zero
2025-01-28 23:34:16.029 UTC [22431][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 <module>
	    plpy.execute("select sql_error()")
	PL/Python function "sql_from_python_error"
2025-01-28 23:34:16.029 UTC [22431][client backend] [pg_regress/plpython_error][17/37:0] STATEMENT:  SELECT sql_from_python_error();
2025-01-28 23:34:16.040 UTC [22431][client backend] [pg_regress/plpython_error][17/47:0] ERROR:  plpy.SPIError: SPI_execute failed: SPI_ERROR_TRANSACTION
2025-01-28 23:34:16.040 UTC [22431][client backend] [pg_regress/plpython_error][17/47:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "manual_subxact", line 2, in <module>
	    plpy.execute("savepoint save")
	PL/Python function "manual_subxact"
2025-01-28 23:34:16.040 UTC [22431][client backend] [pg_regress/plpython_error][17/47:0] STATEMENT:  SELECT manual_subxact();
2025-01-28 23:34:16.041 UTC [22431][client backend] [pg_regress/plpython_error][17/49:0] ERROR:  plpy.SPIError: SPI_execute_plan failed: SPI_ERROR_TRANSACTION
2025-01-28 23:34:16.041 UTC [22431][client backend] [pg_regress/plpython_error][17/49:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "manual_subxact_prepared", line 4, in <module>
	    plpy.execute(save)
	PL/Python function "manual_subxact_prepared"
2025-01-28 23:34:16.041 UTC [22431][client backend] [pg_regress/plpython_error][17/49:0] STATEMENT:  SELECT manual_subxact_prepared();
2025-01-28 23:34:16.046 UTC [22431][client backend] [pg_regress/plpython_error][17/58:0] ERROR:  error fetching next item from iterator
2025-01-28 23:34:16.046 UTC [22431][client backend] [pg_regress/plpython_error][17/58:0] DETAIL:  spiexceptions.InvalidDatetimeFormat: invalid value "xy" for "DD"
2025-01-28 23:34:16.046 UTC [22431][client backend] [pg_regress/plpython_error][17/58:0] CONTEXT:  Traceback (most recent call last):
	PL/Python function "python_error_detail"
2025-01-28 23:34:16.046 UTC [22431][client backend] [pg_regress/plpython_error][17/58:0] STATEMENT:  SELECT python_error_detail();
2025-01-28 23:34:16.049 UTC [22431][client backend] [pg_regress/plpython_error][:0] LOG:  disconnection: session time: 0:00:00.106 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.132 UTC [22452][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.133 UTC [22452][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-01-28 23:34:16.134 UTC [22452][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_ereport
2025-01-28 23:34:16.175 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] LOG:  log
2025-01-28 23:34:16.175 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL:  some detail
2025-01-28 23:34:16.175 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT:  PL/Python function "elog_test"
2025-01-28 23:34:16.175 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] STATEMENT:  SELECT elog_test();
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] WARNING:  warning
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL:  some detail
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT:  PL/Python function "elog_test"
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] ERROR:  plpy.Error: stop on error
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] DETAIL:  some detail
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] HINT:  some hint
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "elog_test", line 18, in <module>
	    plpy.error('stop on error', detail='some detail', hint='some hint')
	PL/Python function "elog_test"
2025-01-28 23:34:16.179 UTC [22452][client backend] [pg_regress/plpython_ereport][18/3:0] STATEMENT:  SELECT elog_test();
2025-01-28 23:34:16.187 UTC [22452][client backend] [pg_regress/plpython_ereport][18/7:0] ERROR:  ValueError: invalid SQLSTATE code
2025-01-28 23:34:16.187 UTC [22452][client backend] [pg_regress/plpython_ereport][18/7:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 1, in <module>
	    plpy.info('wrong sqlstate', sqlstate='54444A') 
	PL/Python anonymous code block
2025-01-28 23:34:16.187 UTC [22452][client backend] [pg_regress/plpython_ereport][18/7:0] STATEMENT:  DO $$ plpy.info('wrong sqlstate', sqlstate='54444A') $$ LANGUAGE plpython3u;
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/8:0] ERROR:  TypeError: 'blabla' is an invalid keyword argument for this function
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/8:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 1, in <module>
	    plpy.info('unsupported argument', blabla='fooboo') 
	PL/Python anonymous code block
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/8:0] STATEMENT:  DO $$ plpy.info('unsupported argument', blabla='fooboo') $$ LANGUAGE plpython3u;
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/9:0] ERROR:  TypeError: argument 'message' given by name and position
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/9:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 1, in <module>
	    plpy.info('first message', message='second message') 
	PL/Python anonymous code block
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/9:0] STATEMENT:  DO $$ plpy.info('first message', message='second message') $$ LANGUAGE plpython3u;
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/10:0] ERROR:  TypeError: argument 'message' given by name and position
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/10:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 1, in <module>
	    plpy.info('first message', 'second message', message='third message') 
	PL/Python anonymous code block
2025-01-28 23:34:16.190 UTC [22452][client backend] [pg_regress/plpython_ereport][18/10:0] STATEMENT:  DO $$ plpy.info('first message', 'second message', message='third message') $$ LANGUAGE plpython3u;
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/12:0] ERROR:  plpy.Error: hello
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/12:0] DETAIL:  world
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/12:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "raise_exception", line 9, in <module>
	    plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v))
	PL/Python function "raise_exception"
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/12:0] STATEMENT:  SELECT raise_exception('hello', 'world');
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/13:0] ERROR:  plpy.Error: message text
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/13:0] DETAIL:  detail text
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/13:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "raise_exception", line 9, in <module>
	    plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v))
	PL/Python function "raise_exception"
2025-01-28 23:34:16.193 UTC [22452][client backend] [pg_regress/plpython_ereport][18/13:0] STATEMENT:  SELECT raise_exception('message text', 'detail text', _sqlstate => 'YY333');
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/14:0] ERROR:  plpy.Error: message text
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/14:0] DETAIL:  detail text
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/14:0] HINT:  hint text
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/14:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "raise_exception", line 9, in <module>
	    plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v))
	PL/Python function "raise_exception"
2025-01-28 23:34:16.194 UTC [22452][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-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/15:0] ERROR:  plpy.Error: message text
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/15:0] HINT:  hint text
2025-01-28 23:34:16.194 UTC [22452][client backend] [pg_regress/plpython_ereport][18/15:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "raise_exception", line 9, in <module>
	    plpy.error(**dict((k, v) for k, v in iter(kwargs.items()) if v))
	PL/Python function "raise_exception"
2025-01-28 23:34:16.194 UTC [22452][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-01-28 23:34:16.199 UTC [22452][client backend] [pg_regress/plpython_ereport][18/17:0] ERROR:  plpy.SPIError: plpy.Error: my message
2025-01-28 23:34:16.199 UTC [22452][client backend] [pg_regress/plpython_ereport][18/17:0] HINT:  some hint
2025-01-28 23:34:16.199 UTC [22452][client backend] [pg_regress/plpython_ereport][18/17:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 6, in <module>
	    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-01-28 23:34:16.199 UTC [22452][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-01-28 23:34:16.201 UTC [22452][client backend] [pg_regress/plpython_ereport][18/18:0] ERROR:  plpy.Error: my message
2025-01-28 23:34:16.201 UTC [22452][client backend] [pg_regress/plpython_ereport][18/18:0] HINT:  some hint
2025-01-28 23:34:16.201 UTC [22452][client backend] [pg_regress/plpython_ereport][18/18:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 6, in <module>
	    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-01-28 23:34:16.201 UTC [22452][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-01-28 23:34:16.204 UTC [22452][client backend] [pg_regress/plpython_ereport][:0] LOG:  disconnection: session time: 0:00:00.075 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.226 UTC [22459][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.228 UTC [22459][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-01-28 23:34:16.228 UTC [22459][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_unicode
2025-01-28 23:34:16.265 UTC [22459][client backend] [pg_regress/plpython_unicode][:0] LOG:  disconnection: session time: 0:00:00.039 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.306 UTC [22466][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.312 UTC [22466][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-01-28 23:34:16.312 UTC [22466][client backend] [[unknown]][20/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_quote
2025-01-28 23:34:16.359 UTC [22466][client backend] [pg_regress/plpython_quote][:0] LOG:  disconnection: session time: 0:00:00.054 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.432 UTC [22474][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.433 UTC [22474][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-01-28 23:34:16.433 UTC [22474][client backend] [[unknown]][21/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_composite
2025-01-28 23:34:16.530 UTC [22474][client backend] [pg_regress/plpython_composite][21/68:0] ERROR:  length of returned sequence did not match number of columns in row
2025-01-28 23:34:16.530 UTC [22474][client backend] [pg_regress/plpython_composite][21/68:0] CONTEXT:  while creating return value
	PL/Python function "changing_test"
2025-01-28 23:34:16.530 UTC [22474][client backend] [pg_regress/plpython_composite][21/68:0] STATEMENT:  SELECT * FROM changing_test();
2025-01-28 23:34:16.531 UTC [22474][client backend] [pg_regress/plpython_composite][21/69:0] ERROR:  length of returned sequence did not match number of columns in row
2025-01-28 23:34:16.531 UTC [22474][client backend] [pg_regress/plpython_composite][21/69:0] CONTEXT:  while creating return value
	PL/Python function "changing_test"
2025-01-28 23:34:16.531 UTC [22474][client backend] [pg_regress/plpython_composite][21/69:0] STATEMENT:  SELECT * FROM changing_test();
2025-01-28 23:34:16.541 UTC [22474][client backend] [pg_regress/plpython_composite][21/86:0] ERROR:  key "v3" not found in mapping
2025-01-28 23:34:16.541 UTC [22474][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-01-28 23:34:16.541 UTC [22474][client backend] [pg_regress/plpython_composite][21/86:0] CONTEXT:  while creating return value
	PL/Python function "return_record_2"
2025-01-28 23:34:16.541 UTC [22474][client backend] [pg_regress/plpython_composite][21/86:0] STATEMENT:  SELECT * FROM return_record_2('v4') AS (v1 int, v3 int, v2 int);
2025-01-28 23:34:16.551 UTC [22474][client backend] [pg_regress/plpython_composite][21/94:0] ERROR:  malformed record literal: "first"
2025-01-28 23:34:16.551 UTC [22474][client backend] [pg_regress/plpython_composite][21/94:0] DETAIL:  Missing left parenthesis.
2025-01-28 23:34:16.551 UTC [22474][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-01-28 23:34:16.551 UTC [22474][client backend] [pg_regress/plpython_composite][21/94:0] CONTEXT:  while creating return value
	PL/Python function "composite_type_as_list_broken"
2025-01-28 23:34:16.551 UTC [22474][client backend] [pg_regress/plpython_composite][21/94:0] STATEMENT:  SELECT * FROM composite_type_as_list_broken();
2025-01-28 23:34:16.555 UTC [22474][client backend] [pg_regress/plpython_composite][:0] LOG:  disconnection: session time: 0:00:00.126 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.590 UTC [22491][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.591 UTC [22491][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-01-28 23:34:16.591 UTC [22491][client backend] [[unknown]][22/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_subtransaction
2025-01-28 23:34:16.618 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/7:1157] ERROR:  spiexceptions.InvalidTextRepresentation: invalid input syntax for type integer: "oops" at character 40
2025-01-28 23:34:16.618 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/7:1157] QUERY:  INSERT INTO subtransaction_tbl VALUES ('oops')
2025-01-28 23:34:16.618 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/7:1157] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "subtransaction_ctx_test", line 6, in <module>
	    plpy.execute("INSERT INTO subtransaction_tbl VALUES ('oops')")
	PL/Python function "subtransaction_ctx_test"
2025-01-28 23:34:16.618 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/7:1157] STATEMENT:  SELECT subtransaction_ctx_test('SPI');
2025-01-28 23:34:16.620 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/10:1162] ERROR:  Exception: Python exception
2025-01-28 23:34:16.620 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/10:1162] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "subtransaction_ctx_test", line 8, in <module>
	    raise Exception("Python exception")
	PL/Python function "subtransaction_ctx_test"
2025-01-28 23:34:16.620 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/10:1162] STATEMENT:  SELECT subtransaction_ctx_test('Python');
2025-01-28 23:34:16.623 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/14:1168] ERROR:  spiexceptions.SyntaxError: syntax error at or near "error" at character 1
2025-01-28 23:34:16.623 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/14:1168] QUERY:  error
2025-01-28 23:34:16.623 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/14:1168] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "subtransaction_nested_test", line 8, in <module>
	    plpy.execute("error")
	PL/Python function "subtransaction_nested_test"
2025-01-28 23:34:16.623 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/14:1168] STATEMENT:  SELECT subtransaction_nested_test();
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/32:0] ERROR:  ValueError: this subtransaction has not been entered
2025-01-28 23:34:16.633 UTC [22491][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 <module>
	    plpy.subtransaction().__exit__(None, None, None)
	PL/Python function "subtransaction_exit_without_enter"
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/32:0] STATEMENT:  SELECT subtransaction_exit_without_enter();
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/33:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/33:0] CONTEXT:  PL/Python function "subtransaction_enter_without_exit"
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/34:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/34:0] CONTEXT:  PL/Python function "subtransaction_exit_twice"
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/34:0] ERROR:  ValueError: this subtransaction has not been entered
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/34:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "subtransaction_exit_twice", line 3, in <module>
	    plpy.subtransaction().__exit__(None, None, None)
	PL/Python function "subtransaction_exit_twice"
2025-01-28 23:34:16.633 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/34:0] STATEMENT:  SELECT subtransaction_exit_twice();
2025-01-28 23:34:16.634 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/35:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.634 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/35:0] CONTEXT:  PL/Python function "subtransaction_enter_twice"
2025-01-28 23:34:16.634 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/35:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.634 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/35:0] CONTEXT:  PL/Python function "subtransaction_enter_twice"
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/36:0] ERROR:  ValueError: this subtransaction has already been exited
2025-01-28 23:34:16.636 UTC [22491][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 <module>
	    s.__exit__(None, None, None)
	PL/Python function "subtransaction_exit_same_subtransaction_twice"
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/36:0] STATEMENT:  SELECT subtransaction_exit_same_subtransaction_twice();
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/37:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/37:0] CONTEXT:  PL/Python function "subtransaction_enter_same_subtransaction_twice"
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/37:0] ERROR:  ValueError: this subtransaction has already been entered
2025-01-28 23:34:16.636 UTC [22491][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 <module>
	    s.__enter__()
	PL/Python function "subtransaction_enter_same_subtransaction_twice"
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/37:0] STATEMENT:  SELECT subtransaction_enter_same_subtransaction_twice();
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/38:0] ERROR:  ValueError: this subtransaction has already been entered
2025-01-28 23:34:16.636 UTC [22491][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 <module>
	    s.__enter__()
	PL/Python function "subtransaction_enter_subtransaction_in_with"
2025-01-28 23:34:16.636 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/38:0] STATEMENT:  SELECT subtransaction_enter_subtransaction_in_with();
2025-01-28 23:34:16.637 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/39:0] ERROR:  ValueError: this subtransaction has already been exited
2025-01-28 23:34:16.637 UTC [22491][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 <module>
	    raise ValueError(e)
	PL/Python function "subtransaction_exit_subtransaction_in_with"
2025-01-28 23:34:16.637 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/39:0] STATEMENT:  SELECT subtransaction_exit_subtransaction_in_with();
2025-01-28 23:34:16.639 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/42:1203] WARNING:  Caught a SPI error from an explicit subtransaction
2025-01-28 23:34:16.639 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/42:1203] CONTEXT:  PL/Python function "subtransaction_mix_explicit_and_implicit"
2025-01-28 23:34:16.639 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/42:1203] WARNING:  Caught a SPI error
2025-01-28 23:34:16.639 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/42:1203] CONTEXT:  PL/Python function "subtransaction_mix_explicit_and_implicit"
2025-01-28 23:34:16.670 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/61:0] ERROR:  ValueError: iterating a cursor in an aborted subtransaction
2025-01-28 23:34:16.670 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/61:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "cursor_aborted_subxact", line 8, in <module>
	    fetched = cur.fetch(10)
	PL/Python function "cursor_aborted_subxact"
2025-01-28 23:34:16.670 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/61:0] STATEMENT:  SELECT cursor_aborted_subxact();
2025-01-28 23:34:16.672 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/62:1227] ERROR:  ValueError: iterating a cursor in an aborted subtransaction
2025-01-28 23:34:16.672 UTC [22491][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 <module>
	    fetched = cur.fetch(5)
	PL/Python function "cursor_plan_aborted_subxact"
2025-01-28 23:34:16.672 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/62:1227] STATEMENT:  SELECT cursor_plan_aborted_subxact();
2025-01-28 23:34:16.673 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/63:0] ERROR:  ValueError: closing a cursor in an aborted subtransaction
2025-01-28 23:34:16.673 UTC [22491][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 <module>
	    cur.close()
	PL/Python function "cursor_close_aborted_subxact"
2025-01-28 23:34:16.673 UTC [22491][client backend] [pg_regress/plpython_subtransaction][22/63:0] STATEMENT:  SELECT cursor_close_aborted_subxact();
2025-01-28 23:34:16.676 UTC [22491][client backend] [pg_regress/plpython_subtransaction][:0] LOG:  disconnection: session time: 0:00:00.085 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.733 UTC [22507][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.735 UTC [22507][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-01-28 23:34:16.735 UTC [22507][client backend] [[unknown]][23/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_transaction
2025-01-28 23:34:16.779 UTC [22507][client backend] [pg_regress/plpython_transaction][23/31:1275] ERROR:  spiexceptions.InvalidTransactionTermination: invalid transaction termination
2025-01-28 23:34:16.779 UTC [22507][client backend] [pg_regress/plpython_transaction][23/31:1275] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "transaction_test2", line 5, in <module>
	    plpy.commit()
	PL/Python function "transaction_test2"
2025-01-28 23:34:16.779 UTC [22507][client backend] [pg_regress/plpython_transaction][23/31:1275] STATEMENT:  SELECT transaction_test2();
2025-01-28 23:34:16.781 UTC [22507][client backend] [pg_regress/plpython_transaction][23/34:1278] ERROR:  spiexceptions.InvalidTransactionTermination: spiexceptions.InvalidTransactionTermination: invalid transaction termination
2025-01-28 23:34:16.781 UTC [22507][client backend] [pg_regress/plpython_transaction][23/34:1278] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "transaction_test3", line 2, in <module>
	    plpy.execute("CALL transaction_test1()")
	PL/Python function "transaction_test3"
2025-01-28 23:34:16.781 UTC [22507][client backend] [pg_regress/plpython_transaction][23/34:1278] STATEMENT:  SELECT transaction_test3();
2025-01-28 23:34:16.782 UTC [22507][client backend] [pg_regress/plpython_transaction][23/37:0] ERROR:  spiexceptions.InvalidTransactionTermination: spiexceptions.InvalidTransactionTermination: invalid transaction termination
2025-01-28 23:34:16.782 UTC [22507][client backend] [pg_regress/plpython_transaction][23/37:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python function "transaction_test4", line 2, in <module>
	    plpy.execute("DO LANGUAGE plpython3u $x$ plpy.commit() $x$")
	PL/Python function "transaction_test4"
2025-01-28 23:34:16.782 UTC [22507][client backend] [pg_regress/plpython_transaction][23/37:0] STATEMENT:  SELECT transaction_test4();
2025-01-28 23:34:16.784 UTC [22507][client backend] [pg_regress/plpython_transaction][23/38:0] WARNING:  forcibly aborting a subtransaction that has not been exited
2025-01-28 23:34:16.784 UTC [22507][client backend] [pg_regress/plpython_transaction][23/38:0] CONTEXT:  PL/Python anonymous code block
2025-01-28 23:34:16.784 UTC [22507][client backend] [pg_regress/plpython_transaction][23/38:0] ERROR:  spiexceptions.InvalidTransactionTermination: cannot commit while a subtransaction is active
2025-01-28 23:34:16.784 UTC [22507][client backend] [pg_regress/plpython_transaction][23/38:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 4, in <module>
	    plpy.commit()
	PL/Python anonymous code block
2025-01-28 23:34:16.784 UTC [22507][client backend] [pg_regress/plpython_transaction][23/38:0] STATEMENT:  DO LANGUAGE plpython3u $$
	s = plpy.subtransaction()
	s.enter()
	plpy.commit()
	$$;
2025-01-28 23:34:16.794 UTC [22507][client backend] [pg_regress/plpython_transaction][23/53:0] ERROR:  spiexceptions.DivisionByZero: division by zero
2025-01-28 23:34:16.794 UTC [22507][client backend] [pg_regress/plpython_transaction][23/53:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 3, in <module>
	    plpy.execute("INSERT INTO test1 (a) VALUES (12/(%s-2))" % row['x'])
	PL/Python anonymous code block
2025-01-28 23:34:16.794 UTC [22507][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-01-28 23:34:16.811 UTC [22507][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-01-28 23:34:16.811 UTC [22507][client backend] [pg_regress/plpython_transaction][23/77:0] DETAIL:  Key (f1)=(0) is not present in table "testpk".
2025-01-28 23:34:16.811 UTC [22507][client backend] [pg_regress/plpython_transaction][23/77:0] CONTEXT:  Traceback (most recent call last):
	  PL/Python anonymous code block, line 4, in <module>
	    plpy.commit()
	PL/Python anonymous code block
2025-01-28 23:34:16.811 UTC [22507][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-01-28 23:34:16.835 UTC [22507][client backend] [pg_regress/plpython_transaction][:0] LOG:  disconnection: session time: 0:00:00.102 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:16.893 UTC [22523][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-28 23:34:16.894 UTC [22523][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-01-28 23:34:16.894 UTC [22523][client backend] [[unknown]][24/1:0] LOG:  connection authorized: user=postgres database=pl_regression application_name=pg_regress/plpython_drop
2025-01-28 23:34:16.992 UTC [22523][client backend] [pg_regress/plpython_drop][:0] LOG:  disconnection: session time: 0:00:00.100 user=postgres database=pl_regression host=[local]
2025-01-28 23:34:17.032 UTC [22225][postmaster] LOG:  received fast shutdown request
2025-01-28 23:34:17.032 UTC [22225][postmaster] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "postmaster.c", Line: 2951, PID: 22225
/lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f8bc4651f31]
postgres(ExceptionalCondition+0xe6)[0x559c26a5ccd1]
postgres(+0xc96fd7)[0x559c2659afd7]
postgres(+0xc9769e)[0x559c2659b69e]
postgres(+0xc98901)[0x559c2659c901]
postgres(PostmasterMain+0x1c3c)[0x559c2659ec41]
postgres(main+0x2a2)[0x559c2633d5fb]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f8bc364824a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f8bc3648305]
postgres(_start+0x21)[0x559c25d223a1]