2024-09-05 03:04:09.860 GMT postmaster[5588] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30154, 64-bit 2024-09-05 03:04:09.862 GMT postmaster[5588] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40002" 2024-09-05 03:04:09.948 GMT startup[4600] LOG: database system was shut down at 2024-09-05 03:00:34 GMT 2024-09-05 03:04:09.950 GMT client backend[1956] [unknown] FATAL: the database system is starting up 2024-09-05 03:04:10.029 GMT client backend[6012] [unknown] FATAL: the database system is starting up 2024-09-05 03:04:10.031 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 2460 abort() has been called2024-09-05 03:04:21.077 GMT postmaster[5588] LOG: server process (PID 2460) was terminated by exception 0xC0000354 2024-09-05 03:04:21.077 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION stupid() RETURNS text AS 'return "zarkon"' LANGUAGE plpython3u; 2024-09-05 03:04:21.077 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:21.077 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:21.093 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:21.133 GMT startup[4592] LOG: database system was interrupted; last known up at 2024-09-05 03:04:10 GMT 2024-09-05 03:04:21.134 GMT startup[4592] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:21.150 GMT startup[4592] LOG: redo starts at 0/14FB8A8 2024-09-05 03:04:21.217 GMT startup[4592] LOG: invalid record length at 0/1953B90: expected at least 24, got 0 2024-09-05 03:04:21.217 GMT startup[4592] LOG: redo done at 0/1953A58 system usage: CPU: user: 0.04 s, system: 0.01 s, elapsed: 0.06 s 2024-09-05 03:04:21.220 GMT checkpointer[3332] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:21.269 GMT checkpointer[3332] LOG: checkpoint complete: wrote 985 buffers (6.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.047 s, sync=0.001 s, total=0.050 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4448 kB, estimate=4448 kB; lsn=0/1953B90, redo lsn=0/1953B90 2024-09-05 03:04:21.318 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 3240 abort() has been called2024-09-05 03:04:24.744 GMT postmaster[5588] LOG: server process (PID 3240) was terminated by exception 0xC0000354 2024-09-05 03:04:24.744 GMT postmaster[5588] DETAIL: Failed process was running: DO $$ plpy.notice("This is plpython3u.") $$ LANGUAGE plpython3u; 2024-09-05 03:04:24.744 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:24.744 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:24.792 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:24.833 GMT startup[6872] LOG: database system was interrupted; last known up at 2024-09-05 03:04:21 GMT 2024-09-05 03:04:24.834 GMT startup[6872] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:24.842 GMT startup[6872] LOG: invalid record length at 0/1953C08: expected at least 24, got 0 2024-09-05 03:04:24.842 GMT startup[6872] LOG: redo is not required 2024-09-05 03:04:24.846 GMT checkpointer[3344] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:24.850 GMT checkpointer[3344] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/1953C08, redo lsn=0/1953C08 2024-09-05 03:04:24.985 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 5852 abort() has been called2024-09-05 03:04:27.068 GMT postmaster[5588] LOG: server process (PID 5852) was terminated by exception 0xC0000354 2024-09-05 03:04:27.068 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION global_test_one() returns text AS 'if "global_test" not in SD: SD["global_test"] = "set by global_test_one" if "global_test" not in GD: GD["global_test"] = "set by global_test_one" return "SD: " + SD["global_test"] + ", GD: " + GD["global_test"]' LANGUAGE plpython3u; 2024-09-05 03:04:27.068 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:27.068 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:27.099 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:27.145 GMT startup[7160] LOG: database system was interrupted; last known up at 2024-09-05 03:04:24 GMT 2024-09-05 03:04:27.146 GMT startup[7160] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:27.148 GMT startup[7160] LOG: redo starts at 0/1953C80 2024-09-05 03:04:27.149 GMT startup[7160] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/195A000, offset 9805824 2024-09-05 03:04:27.150 GMT startup[7160] LOG: redo done at 0/1957D18 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:27.161 GMT checkpointer[6692] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:27.164 GMT checkpointer[6692] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=25 kB, estimate=25 kB; lsn=0/195A048, redo lsn=0/195A048 2024-09-05 03:04:27.294 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4268 abort() has been called2024-09-05 03:04:30.066 GMT postmaster[5588] LOG: server process (PID 4268) was terminated by exception 0xC0000354 2024-09-05 03:04:30.066 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION import_fail() returns text AS 'try: import foosocket except ImportError: return "failed as expected" return "succeeded, that wasn''t supposed to happen"' LANGUAGE plpython3u; 2024-09-05 03:04:30.066 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:30.066 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:30.095 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:30.127 GMT startup[5436] LOG: database system was interrupted; last known up at 2024-09-05 03:04:27 GMT 2024-09-05 03:04:30.128 GMT startup[5436] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:30.130 GMT startup[5436] LOG: redo starts at 0/195A0C0 2024-09-05 03:04:30.131 GMT startup[5436] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1962000, offset 9838592 2024-09-05 03:04:30.131 GMT startup[5436] LOG: redo done at 0/195EC28 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:30.150 GMT checkpointer[5056] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:30.153 GMT checkpointer[5056] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/1962048, redo lsn=0/1962048 2024-09-05 03:04:30.256 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 3972 abort() has been called2024-09-05 03:04:34.000 GMT postmaster[5588] LOG: server process (PID 3972) was terminated by exception 0xC0000354 2024-09-05 03:04:34.000 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION nested_call_one(a text) RETURNS text AS 'q = "SELECT nested_call_two(''%s'')" % a r = plpy.execute(q) return r[0]' LANGUAGE plpython3u ; 2024-09-05 03:04:34.000 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:34.000 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:34.066 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:34.204 GMT startup[1424] LOG: database system was interrupted; last known up at 2024-09-05 03:04:30 GMT 2024-09-05 03:04:34.205 GMT startup[1424] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:34.208 GMT startup[1424] LOG: redo starts at 0/19620C0 2024-09-05 03:04:34.210 GMT startup[1424] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/196A000, offset 9871360 2024-09-05 03:04:34.210 GMT startup[1424] LOG: redo done at 0/1966C10 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:34.214 GMT checkpointer[4796] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:34.220 GMT checkpointer[4796] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/196A048, redo lsn=0/196A048 2024-09-05 03:04:34.381 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 6472 abort() has been called2024-09-05 03:04:36.878 GMT postmaster[5588] LOG: server process (PID 6472) was terminated by exception 0xC0000354 2024-09-05 03:04:36.878 GMT postmaster[5588] DETAIL: Failed process was running: CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS E'x = 100\ny = 23\nreturn x + y\n' LANGUAGE plpython3u; 2024-09-05 03:04:36.878 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:36.878 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:36.917 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:36.960 GMT startup[4808] LOG: database system was interrupted; last known up at 2024-09-05 03:04:34 GMT 2024-09-05 03:04:36.961 GMT startup[4808] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:36.981 GMT startup[4808] LOG: redo starts at 0/196A0C0 2024-09-05 03:04:36.983 GMT startup[4808] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1972000, offset 9904128 2024-09-05 03:04:36.983 GMT startup[4808] LOG: redo done at 0/196ED78 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:37.005 GMT checkpointer[412] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:37.015 GMT checkpointer[412] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.015 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/1972048, redo lsn=0/1972048 2024-09-05 03:04:37.059 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 6592 abort() has been called2024-09-05 03:04:39.222 GMT postmaster[5588] LOG: server process (PID 6592) was terminated by exception 0xC0000354 2024-09-05 03:04:39.222 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION test_void_func1() RETURNS void AS $$ x = 10 $$ LANGUAGE plpython3u; 2024-09-05 03:04:39.222 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:39.223 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:39.265 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:39.313 GMT startup[5496] LOG: database system was interrupted; last known up at 2024-09-05 03:04:37 GMT 2024-09-05 03:04:39.313 GMT startup[5496] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:39.316 GMT startup[5496] LOG: redo starts at 0/19720C0 2024-09-05 03:04:39.317 GMT startup[5496] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1978000, offset 9928704 2024-09-05 03:04:39.317 GMT startup[5496] LOG: redo done at 0/1974EB8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:39.320 GMT checkpointer[7136] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:39.323 GMT checkpointer[7136] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/1978048, redo lsn=0/1978048 2024-09-05 03:04:39.339 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 6232 abort() has been called2024-09-05 03:04:44.051 GMT postmaster[5588] LOG: server process (PID 6232) was terminated by exception 0xC0000354 2024-09-05 03:04:44.051 GMT postmaster[5588] DETAIL: Failed process was running: CREATE PROCEDURE test_proc1() LANGUAGE plpython3u AS $$ pass $$; 2024-09-05 03:04:44.051 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:44.051 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:44.102 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:44.263 GMT startup[6512] LOG: database system was interrupted; last known up at 2024-09-05 03:04:39 GMT 2024-09-05 03:04:44.264 GMT startup[6512] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:44.266 GMT startup[6512] LOG: redo starts at 0/19780C0 2024-09-05 03:04:44.267 GMT startup[6512] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/197E000, offset 9953280 2024-09-05 03:04:44.267 GMT startup[6512] LOG: redo done at 0/197B070 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:44.300 GMT checkpointer[5836] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:44.303 GMT checkpointer[5836] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/197E048, redo lsn=0/197E048 2024-09-05 03:04:44.488 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 6472 abort() has been called2024-09-05 03:04:46.297 GMT postmaster[5588] LOG: server process (PID 6472) was terminated by exception 0xC0000354 2024-09-05 03:04:46.297 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION test_param_names0(integer, integer) RETURNS int AS $$ return args[0] + args[1] $$ LANGUAGE plpython3u; 2024-09-05 03:04:46.297 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:46.297 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:46.312 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:46.358 GMT startup[4080] LOG: database system was interrupted; last known up at 2024-09-05 03:04:44 GMT 2024-09-05 03:04:46.359 GMT startup[4080] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:46.362 GMT startup[4080] LOG: redo starts at 0/197E0C0 2024-09-05 03:04:46.363 GMT startup[4080] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1984000, offset 9977856 2024-09-05 03:04:46.363 GMT startup[4080] LOG: redo done at 0/1981210 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:46.370 GMT checkpointer[4204] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:46.374 GMT checkpointer[4204] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/1984048, redo lsn=0/1984048 2024-09-05 03:04:46.390 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 5528 abort() has been called2024-09-05 03:04:48.912 GMT postmaster[5588] LOG: server process (PID 5528) was terminated by exception 0xC0000354 2024-09-05 03:04:48.912 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION test_setof_error() RETURNS SETOF text AS $$ return 37 $$ LANGUAGE plpython3u; 2024-09-05 03:04:48.912 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:48.912 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:48.940 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:48.977 GMT startup[6220] LOG: database system was interrupted; last known up at 2024-09-05 03:04:46 GMT 2024-09-05 03:04:48.978 GMT startup[6220] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:48.983 GMT startup[6220] LOG: redo starts at 0/19840C0 2024-09-05 03:04:48.984 GMT startup[6220] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/198A000, offset 10002432 2024-09-05 03:04:48.984 GMT startup[6220] LOG: redo done at 0/1987398 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:48.997 GMT checkpointer[5336] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:49.010 GMT checkpointer[5336] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.001 s, total=0.014 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/198A048, redo lsn=0/198A048 2024-09-05 03:04:49.289 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4724 abort() has been called2024-09-05 03:04:51.987 GMT postmaster[5588] LOG: server process (PID 4724) was terminated by exception 0xC0000354 2024-09-05 03:04:51.987 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION test_table_record_as(typ text, first text, second integer, retnull boolean) RETURNS table_record AS $$ if retnull: return None if typ == 'dict': return { 'first': first, 'second': second, 'additionalfield': 'must not cause trouble' } elif typ == 'tuple': return ( first, second ) elif typ == 'list': return [ first, second ] elif typ == 'obj': class type_record: pass type_record.first = first type_record.second = second return type_record $$ LANGUAGE plpython3u; 2024-09-05 03:04:51.987 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:51.987 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:52.006 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:52.063 GMT startup[536] LOG: database system was interrupted; last known up at 2024-09-05 03:04:48 GMT 2024-09-05 03:04:52.064 GMT startup[536] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:52.068 GMT startup[536] LOG: redo starts at 0/198A0C0 2024-09-05 03:04:52.073 GMT startup[536] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19AE000, offset 10149888 2024-09-05 03:04:52.073 GMT startup[536] LOG: redo done at 0/19AC1B0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:52.087 GMT checkpointer[1480] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:52.098 GMT checkpointer[1480] LOG: checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.008 s, sync=0.001 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s; distance=144 kB, estimate=144 kB; lsn=0/19AE048, redo lsn=0/19AE048 2024-09-05 03:04:52.155 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 5940 abort() has been called2024-09-05 03:04:55.518 GMT postmaster[5588] LOG: server process (PID 5940) was terminated by exception 0xC0000354 2024-09-05 03:04:55.518 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION users_insert() returns trigger AS 'if TD["new"]["fname"] == None or TD["new"]["lname"] == None: return "SKIP" if TD["new"]["username"] == None: TD["new"]["username"] = TD["new"]["fname"][:1] + "_" + TD["new"]["lname"] rv = "MODIFY" else: rv = None if TD["new"]["fname"] == "william": TD["new"]["fname"] = TD["args"][0] rv = "MODIFY" return rv' LANGUAGE plpython3u; 2024-09-05 03:04:55.518 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:55.518 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:55.653 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:55.774 GMT startup[6188] LOG: database system was interrupted; last known up at 2024-09-05 03:04:52 GMT 2024-09-05 03:04:55.859 GMT startup[6188] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:55.864 GMT startup[6188] LOG: redo starts at 0/19AE0C0 2024-09-05 03:04:55.865 GMT startup[6188] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19B4000, offset 10174464 2024-09-05 03:04:55.865 GMT startup[6188] LOG: redo done at 0/19B19F0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:55.941 GMT checkpointer[680] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:55.944 GMT checkpointer[680] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/19B4048, redo lsn=0/19B4048 2024-09-05 03:04:56.028 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 5692 abort() has been called2024-09-05 03:04:59.127 GMT postmaster[5588] LOG: server process (PID 5692) was terminated by exception 0xC0000354 2024-09-05 03:04:59.127 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION test_type_conversion_bool(x bool) RETURNS bool AS $$ plpy.info(x, type(x)) return x $$ LANGUAGE plpython3u; 2024-09-05 03:04:59.127 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:04:59.127 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:04:59.151 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:04:59.189 GMT startup[3908] LOG: database system was interrupted; last known up at 2024-09-05 03:04:55 GMT 2024-09-05 03:04:59.197 GMT startup[3908] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:04:59.199 GMT startup[3908] LOG: redo starts at 0/19B40C0 2024-09-05 03:04:59.200 GMT startup[3908] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19BA000, offset 10199040 2024-09-05 03:04:59.200 GMT startup[3908] LOG: redo done at 0/19B7C68 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:04:59.222 GMT checkpointer[5300] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:04:59.225 GMT checkpointer[5300] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/19BA048, redo lsn=0/19BA048 2024-09-05 03:04:59.232 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 2364 abort() has been called2024-09-05 03:05:01.889 GMT postmaster[5588] LOG: server process (PID 2364) was terminated by exception 0xC0000354 2024-09-05 03:05:01.889 GMT postmaster[5588] DETAIL: Failed process was running: /* Flat out Python syntax error */ CREATE FUNCTION python_syntax_error() RETURNS text AS '.syntaxerror' LANGUAGE plpython3u; 2024-09-05 03:05:01.889 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:01.889 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:01.919 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:01.990 GMT startup[3240] LOG: database system was interrupted; last known up at 2024-09-05 03:04:59 GMT 2024-09-05 03:05:01.991 GMT startup[3240] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:01.994 GMT startup[3240] LOG: redo starts at 0/19BA0C0 2024-09-05 03:05:01.995 GMT startup[3240] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19C0000, offset 10223616 2024-09-05 03:05:01.995 GMT startup[3240] LOG: redo done at 0/19BDCB0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:05:02.009 GMT checkpointer[5492] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:02.013 GMT checkpointer[5492] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/19C0048, redo lsn=0/19C0048 2024-09-05 03:05:02.151 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4712 abort() has been called2024-09-05 03:05:04.358 GMT postmaster[5588] LOG: server process (PID 4712) was terminated by exception 0xC0000354 2024-09-05 03:05:04.358 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION elog_test() RETURNS void AS $$ plpy.debug('debug', detail='some detail') plpy.log('log', detail='some detail') plpy.info('info', detail='some detail') plpy.info() plpy.info('the question', detail=42); plpy.info('This is message text.', detail='This is detail text', hint='This is hint text.', sqlstate='XX000', schema_name='any info about schema', table_name='any info about table', column_name='any info about column', datatype_name='any info about datatype', constraint_name='any info about constraint') plpy.notice('notice', detail='some detail') plpy.warning('warning', detail='some detail') plpy.error('stop on error', detail='some detail', hint='some hint') $$ LANGUAGE plpython3u; 2024-09-05 03:05:04.358 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:04.358 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:04.388 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:04.433 GMT startup[6876] LOG: database system was interrupted; last known up at 2024-09-05 03:05:02 GMT 2024-09-05 03:05:04.434 GMT startup[6876] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:04.436 GMT startup[6876] LOG: redo starts at 0/19C00C0 2024-09-05 03:05:04.438 GMT startup[6876] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19C6000, offset 10248192 2024-09-05 03:05:04.438 GMT startup[6876] LOG: redo done at 0/19C4138 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:05:04.447 GMT checkpointer[5056] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:04.452 GMT checkpointer[5056] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=24 kB, estimate=24 kB; lsn=0/19C6048, redo lsn=0/19C6048 2024-09-05 03:05:04.491 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 620 abort() has been called2024-09-05 03:05:06.802 GMT postmaster[5588] LOG: server process (PID 620) was terminated by exception 0xC0000354 2024-09-05 03:05:06.802 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION unicode_return() RETURNS text AS E' return "\\xA0" ' LANGUAGE plpython3u; 2024-09-05 03:05:06.802 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:06.802 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:06.839 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:06.933 GMT startup[7124] LOG: database system was interrupted; last known up at 2024-09-05 03:05:04 GMT 2024-09-05 03:05:06.934 GMT startup[7124] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:06.938 GMT startup[7124] LOG: redo starts at 0/19C60C0 2024-09-05 03:05:06.942 GMT startup[7124] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19E4000, offset 10371072 2024-09-05 03:05:06.942 GMT startup[7124] LOG: redo done at 0/19E3568 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.00 s 2024-09-05 03:05:06.944 GMT checkpointer[6784] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:06.951 GMT checkpointer[6784] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=120 kB, estimate=120 kB; lsn=0/19E4048, redo lsn=0/19E4048 2024-09-05 03:05:07.003 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4724 abort() has been called2024-09-05 03:05:09.086 GMT postmaster[5588] LOG: server process (PID 4724) was terminated by exception 0xC0000354 2024-09-05 03:05:09.086 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION quote(t text, how text) RETURNS text AS $$ if how == "literal": return plpy.quote_literal(t) elif how == "nullable": return plpy.quote_nullable(t) elif how == "ident": return plpy.quote_ident(t) else: raise plpy.Error("unrecognized quote type %s" % how) $$ LANGUAGE plpython3u; 2024-09-05 03:05:09.086 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:09.086 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:09.129 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:09.188 GMT startup[5572] LOG: database system was interrupted; last known up at 2024-09-05 03:05:06 GMT 2024-09-05 03:05:09.188 GMT startup[5572] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:09.190 GMT startup[5572] LOG: redo starts at 0/19E40C0 2024-09-05 03:05:09.191 GMT startup[5572] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19EC000, offset 10403840 2024-09-05 03:05:09.191 GMT startup[5572] LOG: redo done at 0/19E85B0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:05:09.204 GMT checkpointer[6920] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:09.208 GMT checkpointer[6920] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/19EC048, redo lsn=0/19EC048 2024-09-05 03:05:09.238 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4232 abort() has been called2024-09-05 03:05:11.517 GMT postmaster[5588] LOG: server process (PID 4232) was terminated by exception 0xC0000354 2024-09-05 03:05:11.517 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION multiout_simple(OUT i integer, OUT j integer) AS $$ return (1, 2) $$ LANGUAGE plpython3u; 2024-09-05 03:05:11.517 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:11.517 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:11.588 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:11.734 GMT startup[6664] LOG: database system was interrupted; last known up at 2024-09-05 03:05:09 GMT 2024-09-05 03:05:11.735 GMT startup[6664] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:11.983 GMT startup[6664] LOG: redo starts at 0/19EC0C0 2024-09-05 03:05:11.985 GMT startup[6664] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/19F4000, offset 10436608 2024-09-05 03:05:11.985 GMT startup[6664] LOG: redo done at 0/19F0740 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:05:12.000 GMT checkpointer[1256] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:12.004 GMT checkpointer[1256] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/19F4048, redo lsn=0/19F4048 2024-09-05 03:05:12.058 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 7148 abort() has been called2024-09-05 03:05:14.840 GMT postmaster[5588] LOG: server process (PID 7148) was terminated by exception 0xC0000354 2024-09-05 03:05:14.840 GMT postmaster[5588] DETAIL: Failed process was running: CREATE FUNCTION subtransaction_ctx_test(what_error text = NULL) RETURNS text AS $$ with plpy.subtransaction(): plpy.execute("INSERT INTO subtransaction_tbl VALUES (1)") plpy.execute("INSERT INTO subtransaction_tbl VALUES (2)") if what_error == "SPI": plpy.execute("INSERT INTO subtransaction_tbl VALUES ('oops')") elif what_error == "Python": raise Exception("Python exception") $$ LANGUAGE plpython3u; 2024-09-05 03:05:14.840 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:14.840 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:14.861 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:14.972 GMT startup[836] LOG: database system was interrupted; last known up at 2024-09-05 03:05:12 GMT 2024-09-05 03:05:14.983 GMT startup[836] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:14.986 GMT startup[836] LOG: redo starts at 0/19F40C0 2024-09-05 03:05:14.991 GMT startup[836] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1A10000, offset 10551296 2024-09-05 03:05:14.991 GMT startup[836] LOG: redo done at 0/1A0E2E0 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.00 s 2024-09-05 03:05:15.009 GMT checkpointer[3332] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:15.021 GMT checkpointer[3332] LOG: checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.010 s, sync=0.001 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s; distance=112 kB, estimate=112 kB; lsn=0/1A10048, redo lsn=0/1A10048 2024-09-05 03:05:15.065 GMT postmaster[5588] LOG: database system is ready to accept connections TRAP: failed Assert("!found"), File: "../src/pl/plpython/plpy_plpymodule.c", Line: 267, PID: 4720 abort() has been called2024-09-05 03:05:18.134 GMT postmaster[5588] LOG: server process (PID 4720) was terminated by exception 0xC0000354 2024-09-05 03:05:18.134 GMT postmaster[5588] DETAIL: Failed process was running: CREATE PROCEDURE transaction_test1() LANGUAGE plpython3u AS $$ for i in range(0, 10): plpy.execute("INSERT INTO test1 (a) VALUES (%d)" % i) if i % 2 == 0: plpy.commit() else: plpy.rollback() $$; 2024-09-05 03:05:18.134 GMT postmaster[5588] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-09-05 03:05:18.134 GMT postmaster[5588] LOG: terminating any other active server processes 2024-09-05 03:05:18.258 GMT postmaster[5588] LOG: all server processes terminated; reinitializing 2024-09-05 03:05:18.454 GMT startup[1204] LOG: database system was interrupted; last known up at 2024-09-05 03:05:15 GMT 2024-09-05 03:05:18.455 GMT startup[1204] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-05 03:05:18.457 GMT startup[1204] LOG: redo starts at 0/1A100C0 2024-09-05 03:05:18.463 GMT startup[1204] LOG: invalid magic number 0000 in WAL segment 000000010000000000000001, LSN 0/1A30000, offset 10682368 2024-09-05 03:05:18.463 GMT startup[1204] LOG: redo done at 0/1A2E768 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-05 03:05:18.498 GMT checkpointer[6176] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-05 03:05:18.503 GMT checkpointer[6176] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=128 kB, estimate=128 kB; lsn=0/1A30048, redo lsn=0/1A30048 2024-09-05 03:05:18.611 GMT postmaster[5588] LOG: database system is ready to accept connections 2024-09-05 03:05:19.586 GMT postmaster[5588] LOG: received fast shutdown request 2024-09-05 03:05:19.587 GMT postmaster[5588] LOG: aborting any active transactions 2024-09-05 03:05:19.623 GMT checkpointer[6176] LOG: shutting down 2024-09-05 03:05:19.624 GMT checkpointer[6176] LOG: checkpoint starting: shutdown immediate 2024-09-05 03:05:19.627 GMT checkpointer[6176] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=28 kB, estimate=118 kB; lsn=0/1A37358, redo lsn=0/1A37358 2024-09-05 03:05:19.650 GMT postmaster[5588] LOG: database system is shut down