[18:20:05.090] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [18:20:05.450] dumping /tmp/cores/postgres.19556.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:05.581] [New LWP 101803] [18:20:05.682] Core was generated by `postgres: postgres regression_plpython [local] CREATE FUNCTION'. [18:20:05.682] Program terminated with signal SIGABRT, Aborted. [18:20:05.682] Sent by thr_kill() from pid 19556 and user 1003. [18:20:05.682] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:06.316] To enable execution of this file add [18:20:06.316] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:06.316] line to your configuration file "/.config/gdb/gdbinit". [18:20:06.316] To completely disable this security protection add [18:20:06.316] set auto-load safe-path / [18:20:06.316] line to your configuration file "/.config/gdb/gdbinit". [18:20:06.316] For more information about this security protection see the [18:20:06.316] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:06.316] info "(gdb)Auto-loading safe path" [18:20:06.316] [18:20:06.316] Thread 1 (LWP 101803): [18:20:06.316] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:06.316] No symbol table info available. [18:20:06.316] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:06.316] No symbol table info available. [18:20:06.316] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:06.316] No symbol table info available. [18:20:06.316] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x83fff7e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:06.316] No locals. [18:20:06.316] #4 0x0000000840001063 in PLy_generate_spi_exceptions (mod=0x844b69ad0, base=0x8352a0010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:06.316] dict = [18:20:06.316] found = true [18:20:06.316] sqlstate = [18:20:06.316] exc = 0x8352f8c10 [18:20:06.316] entry = 0x0 [18:20:06.316] i = 66 [18:20:06.316] #5 PLy_add_exceptions (plpy=0x8436d2c50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:06.316] hash_ctl = {num_partitions = 35490254192, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x84366cd40, match = 0x84366cd40, keycopy = 0x844b50f80, alloc = 0x8436ca070, hcxt = 0x842ca8ac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:06.316] excmod = 0x844b69ad0 [18:20:06.316] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:06.316] m = 0x8436d2c50 [18:20:06.316] #7 0x0000000842ab4f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #8 0x0000000842ab32e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #9 0x00000008429d3c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #10 0x0000000842a7dd9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #11 0x0000000842a80795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #12 0x000000084298190f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #13 0x0000000842981705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #14 0x0000000842aaf284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #15 0x0000000842a67996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #16 0x00000008429d3e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #17 0x0000000842980538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #18 0x0000000842980467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #19 0x0000000842aaeb30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #20 0x0000000842aafef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:06.316] No symbol table info available. [18:20:06.316] #21 0x0000000840000476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:06.316] inited = false [18:20:06.316] #22 0x00000008400003a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:06.316] funcoid = 16457 [18:20:06.316] tuple = [18:20:06.316] is_trigger = [18:20:06.316] procStruct = [18:20:06.316] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=16457) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:06.316] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000I@", '\000' } [18:20:06.316] fcinfo = 0x820d73298 [18:20:06.316] result = [18:20:06.316] __error = [18:20:06.316] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=16457) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:06.316] flinfo = {fn_addr = 0x840000370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:06.316] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832d29060 "stupid", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=25, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x832bd9fd8 "return \"zarkon\"", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c23bb0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:06.316] set_items = [18:20:06.316] save_nestlevel = 0 [18:20:06.316] myself = {classId = 1255, objectId = 16457, objectSubId = 0} [18:20:06.316] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:06.316] values = {16457, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 0, 0, 25, 35211328432, 0, 0, 0, 0, 0, 35211328504, 0, 0, 0, 0} [18:20:06.316] replaces = {true } [18:20:06.316] procname = {data = "stupid", '\000' } [18:20:06.316] referenced = {classId = 1247, objectId = 25, objectSubId = 0} [18:20:06.316] paramModes = [18:20:06.316] variadicType = [18:20:06.316] proacl = 0x0 [18:20:06.316] parameterCount = [18:20:06.316] allParamCount = 0 [18:20:06.316] allParams = 0x832c23bc8 [18:20:06.316] detailmsg = [18:20:06.316] i = [18:20:06.316] rel = 0x832d04048 [18:20:06.316] tupDesc = 0x832d04258 [18:20:06.316] oldtup = 0x0 [18:20:06.316] tup = 0x832c23948 [18:20:06.316] is_update = [18:20:06.316] retval = 16457 [18:20:06.316] addrs = [18:20:06.316] trfid = [18:20:06.316] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832be6500, stmt=, stmt@entry=0x832d29010) at ../src/backend/commands/functioncmds.c:1257 [18:20:06.316] funcname = 0x832d29060 "stupid" [18:20:06.316] parameterTypes = 0x832c23bb0 [18:20:06.316] parameterTypes_list = 0x0 [18:20:06.316] allParameterTypes = 0x0 [18:20:06.316] parameterModes = 0x0 [18:20:06.316] parameterNames = 0x0 [18:20:06.316] inParameterNames_list = 0x0 [18:20:06.316] parameterDefaults = 0x0 [18:20:06.316] variadicArgType = 0 [18:20:06.316] requiredResultType = 0 [18:20:06.316] transformDefElem = [18:20:06.316] trftypes_list = [18:20:06.316] namespaceId = 2200 [18:20:06.316] aclresult = [18:20:06.316] as_clause = [18:20:06.316] language = [18:20:06.316] isWindowFunc = false [18:20:06.316] isStrict = false [18:20:06.316] security = false [18:20:06.316] isLeakProof = [18:20:06.316] volatility = 118 'v' [18:20:06.316] proconfig = 0x0 [18:20:06.316] procost = 100 [18:20:06.316] prorows = 0 [18:20:06.316] prosupport = 0 [18:20:06.316] parallel = 117 'u' [18:20:06.316] languageTuple = [18:20:06.316] languageStruct = [18:20:06.316] languageOid = 16456 [18:20:06.316] languageValidator = 16455 [18:20:06.316] prorettype = 25 [18:20:06.316] returnsSet = false [18:20:06.316] trftypes = 0x0 [18:20:06.316] prosqlbody = 0x0 [18:20:06.316] probin_str = 0x0 [18:20:06.316] prosrc_str = 0x832bd9fd8 "return \"zarkon\"" [18:20:06.316] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832be6500, pstmt=pstmt@entry=0x832bd9b88, queryString=queryString@entry=0x832bd8100 "CREATE FUNCTION stupid() RETURNS text AS 'return \"zarkon\"' LANGUAGE plpython3u;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:06.316] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35211076864, 35212362623, 10, 0, 549755813888}}} [18:20:06.316] _save_exception_stack = 0x820d739b0 [18:20:06.316] _save_context_stack = 0x0 [18:20:06.316] _do_rethrow = false [18:20:06.316] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:06.316] parsetree = 0x832d29010 [18:20:06.316] commandCollected = false [18:20:06.316] needCleanup = false [18:20:06.316] address = [18:20:06.316] isTopLevel = [18:20:06.316] isCompleteQuery = [18:20:06.316] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832bd9b88, queryString=0x832bd8100 "CREATE FUNCTION stupid() RETURNS text AS 'return \"zarkon\"' LANGUAGE plpython3u;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832bd9f48, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:06.316] isAtomicContext = false [18:20:06.316] parsetree = 0x832d29010 [18:20:06.316] readonly_flags = [18:20:06.316] pstate = 0x832be6500 [18:20:06.316] isTopLevel = [18:20:06.316] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18dab, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832bd9f48, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:06.316] No locals. [18:20:06.316] #30 0x0000000000904073 in PortalRunUtility (portal=0x832cad100, pstmt=0x832bd9b88, isTopLevel=, setHoldSnapshot=, dest=0x832bd9f48, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:06.316] No locals. [18:20:06.316] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832cad100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832bd9f48, altdest=altdest@entry=0x832bd9f48, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:06.316] pstmt = 0x832bd9b88 [18:20:06.316] stmtlist_item__state = {l = 0x832d293e8, i = 0} [18:20:06.316] active_snapshot_set = false [18:20:06.316] stmtlist_item = 0x832d29400 [18:20:06.316] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832cad100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832bd9f48, altdest=altdest@entry=0x832bd9f48, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:06.316] _local_sigjmp_buf = {{_sjb = {9449293, 35211890944, 34910714280, 34910714512, 34910714288, 35211907072, 12106024, 12139336, 35211838335, 35211026168, 4294967984, 0}}} [18:20:06.316] _save_exception_stack = 0x820d73b80 [18:20:06.316] _save_context_stack = 0x0 [18:20:06.316] _do_rethrow = false [18:20:06.316] saveTopTransactionResourceOwner = 0x832cb9fd8 [18:20:06.316] saveTopTransactionContext = 0x832cb1000 [18:20:06.316] saveActivePortal = 0x0 [18:20:06.316] saveResourceOwner = 0x832cb9fd8 [18:20:06.316] savePortalContext = 0x0 [18:20:06.316] saveMemoryContext = 0x832cb1000 [18:20:06.316] result = [18:20:06.316] nprocessed = [18:20:06.316] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "CREATE FUNCTION stupid() RETURNS text AS 'return \"zarkon\"' LANGUAGE plpython3u;") at ../src/backend/tcop/postgres.c:1284 [18:20:06.316] cmdtaglen = 15 [18:20:06.316] snapshot_set = [18:20:06.316] per_parsetree_context = 0x0 [18:20:06.316] plantree_list = [18:20:06.316] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:06.316] format = 0 [18:20:06.316] parsetree = 0x832bd9750 [18:20:06.316] commandTag = [18:20:06.316] cmdtagname = [18:20:06.316] querytree_list = [18:20:06.316] portal = 0x832cad100 [18:20:06.316] receiver = 0x832bd9f48 [18:20:06.316] parsetree_item__state = {l = 0x832bd9b38, i = 0} [18:20:06.316] msec_str = "\000\000\000\000\b", '\000' , "\005\001\326f\000\000\000\000\\\222\245", [18:20:06.316] dest = DestRemote [18:20:06.316] was_logged = [18:20:06.316] oldcontext = 0x832cb1000 [18:20:06.316] parsetree_list = 0x832bd9b38 [18:20:06.316] use_implicit_block = false [18:20:06.316] parsetree_item = 0x832bd9b50 [18:20:06.316] save_log_statement_stats = [18:20:06.316] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:06.316] query_string = 0x832bd8100 "CREATE FUNCTION stupid() RETURNS text AS 'return \"zarkon\"' LANGUAGE plpython3u;" [18:20:06.316] input_message = {data = 0x832bd8100 "CREATE FUNCTION stupid() RETURNS text AS 'return \"zarkon\"' LANGUAGE plpython3u;", len = 80, maxlen = 1024, cursor = 80} [18:20:06.316] firstchar = [18:20:06.316] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:06.316] send_ready_for_query = false [18:20:06.316] idle_in_transaction_timeout_enabled = false [18:20:06.316] idle_session_timeout_enabled = false [18:20:06.316] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:06.316] bsdata = [18:20:06.316] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:06.316] pid = [18:20:06.316] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:06.316] startup_data = {canAcceptConnections = CAC_OK} [18:20:06.316] bn = 0x832be40d8 [18:20:06.316] pid = [18:20:06.316] __error = [18:20:06.316] save_errno = [18:20:06.316] __error = [18:20:06.316] __error = [18:20:06.316] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:06.316] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:06.316] i = 0 [18:20:06.316] now = [18:20:06.316] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:06.316] last_touch_time = 1725300997 [18:20:06.316] last_lockfile_recheck_time = 1725300997 [18:20:06.316] nevents = 1 [18:20:06.316] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:06.316] userDoption = [18:20:06.316] listen_addr_saved = [18:20:06.316] output_config_variable = [18:20:06.316] opt = [18:20:06.316] status = [18:20:06.316] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:06.316] do_check_root = [18:20:06.330] [18:20:06.330] [18:20:06.330] [18:20:06.401] dumping /tmp/cores/postgres.19930.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:06.523] [New LWP 101734] [18:20:06.603] Core was generated by `postgres: postgres regression_plpython [local] DO'. [18:20:06.603] Program terminated with signal SIGABRT, Aborted. [18:20:06.603] Sent by thr_kill() from pid 19930 and user 1003. [18:20:06.603] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:07.184] To enable execution of this file add [18:20:07.184] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:07.184] line to your configuration file "/.config/gdb/gdbinit". [18:20:07.184] To completely disable this security protection add [18:20:07.184] set auto-load safe-path / [18:20:07.184] line to your configuration file "/.config/gdb/gdbinit". [18:20:07.184] For more information about this security protection see the [18:20:07.184] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:07.184] info "(gdb)Auto-loading safe path" [18:20:07.184] [18:20:07.184] Thread 1 (LWP 101734): [18:20:07.184] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:07.184] No symbol table info available. [18:20:07.184] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:07.184] No symbol table info available. [18:20:07.184] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:07.184] No symbol table info available. [18:20:07.184] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x841f7ce44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:07.184] No locals. [18:20:07.184] #4 0x0000000841f86063 in PLy_generate_spi_exceptions (mod=0x845e4dad0, base=0x83537c010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:07.184] dict = [18:20:07.184] found = true [18:20:07.184] sqlstate = [18:20:07.184] exc = 0x83538cc10 [18:20:07.184] entry = 0x0 [18:20:07.184] i = 66 [18:20:07.184] #5 PLy_add_exceptions (plpy=0x845326c50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:07.184] hash_ctl = {num_partitions = 35519958384, ssize = 7, dsize = 2, max_dsize = 34910711248, keysize = 4, entrysize = 16, hash = 0x8452c0d40, match = 0x8452c0d40, keycopy = 0x845329000, alloc = 0x84531e0f0, hcxt = 0x84332dac0 <_PyRuntime+166184>, hctl = 0x820d72e20} [18:20:07.184] excmod = 0x845e4dad0 [18:20:07.184] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:07.184] m = 0x845326c50 [18:20:07.184] #7 0x0000000843139f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #8 0x00000008431382e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #9 0x0000000843058c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #10 0x0000000843102d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #11 0x0000000843105795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #12 0x000000084300690f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #13 0x0000000843006705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #14 0x0000000843134284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #15 0x00000008430ec996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #16 0x0000000843058e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #17 0x0000000843005538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #18 0x0000000843005467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #19 0x0000000843133b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #20 0x0000000843134ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:07.184] No symbol table info available. [18:20:07.184] #21 0x0000000841f85476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:07.184] inited = false [18:20:07.184] #22 0x0000000841f85880 in plpython3_inline_handler (fcinfo=0x18d66) at ../src/pl/plpython/plpy_main.c:272 [18:20:07.184] fake_fcinfodata = {fcinfo = {flinfo = 0x0, context = 0x0, resultinfo = 0x832ce8e80, fncollation = 4, isnull = false, nargs = 0, args = 0x820d73740}, fcinfo_data = '\000' , "\200\216\3162\b\000\000\000\004\000\000\000\000\000\000"} [18:20:07.184] flinfo = {fn_addr = 0x20, fn_oid = 10743648, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x832c77400, fn_expr = 0x0} [18:20:07.184] proc = {mcxt = 0x7e0, proname = 0x30 , pyname = 0x820d73620 "`6\327 \b", fn_xmin = 11050481, fn_tid = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 468}, fn_readonly = false, is_setof = false, is_procedure = false, is_trigger = false, result = {func = 0x20, typoid = 48, typmod = 0, typbyval = 42, typlen = 0, typalign = 0 '\000', mcxt = 0x820d73660, u = {scalar = {typfunc = {fn_addr = 0xa67fbc , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x832d32e90, fn_mcxt = 0x0, fn_expr = 0x832d32190}, typioparam = 852697488}, array = {elm = 0xa67fbc , elmbasetype = 0}, tuple = {recdesc = 0xa67fbc , typentry = 0x0, tupdescid = 35212435712, atts = 0x832d32e90, natts = 0, recinfunc = {fn_addr = 0x832d32190, fn_oid = 852697488, fn_nargs = 8, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xa6890e , fn_mcxt = 0x820d736a0, fn_expr = 0xa89df1 }}, domain = {base = 0xa67fbc , domain_info = 0x0}, transform = {typtransform = {fn_addr = 0xa67fbc , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x832d32e90, fn_mcxt = 0x0, fn_expr = 0x832d32190}}}}, result_in = {func = 0x1d4, typoid = 550975372, typmod = 8, typbyval = 160, typlen = 13011, typalign = 8 '\b', mcxt = 0x820d73718, u = {scalar = {typfunc = {fn_addr = 0x832d32100, fn_oid = 10910645, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x0, fn_mcxt = 0xb95dc0 , fn_expr = 0x832d94328}}, array = {elm = 0x832d32100}, tuple = {recdesc = 0x832d32100, typentry = 0xa67bb5 , tupdescid = 5401761888, atts = 0x0, natts = 12148160}, transform = {typtransform = {fn_addr = 0x832d32100, fn_oid = 10910645, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x0, fn_mcxt = 0xb95dc0 , fn_expr = 0x832d94328}}}}, src = 0x820d737d8 "`X\370A\b", argnames = 0x832d94328, args = 0x820d73700, nargs = 10744047, langid = 0, trftypes = 0x832d6e301, code = 0x4046, statics = 0x820d737c0, globals = 0xa618e3 , calldepth = -4563311449585221630, argstack = 0x800004000} [18:20:07.184] plerrcontext = {previous = 0x0, callback = 0x821062408, arg = 0x832c23380} [18:20:07.184] fake_fcinfo = 0x820d73720 [18:20:07.184] codeblock = 0x832be6610 [18:20:07.184] exec_ctx = [18:20:07.184] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d737d8, collation=0, arg1=35211077136) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:07.184] fcinfodata = {fcinfo = {flinfo = 0x820d737d8, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d73828}, fcinfo_data = "\3307\327 \b", '\000' , "\001\000\020f\2762\b\000\000\000\000e\2762\b\000\000"} [18:20:07.184] fcinfo = 0x820d73808 [18:20:07.184] result = [18:20:07.184] __error = [18:20:07.184] #24 OidFunctionCall1Coll (functionId=, collation=collation@entry=0, arg1=35211077136) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:07.184] flinfo = {fn_addr = 0x841f85860 , fn_oid = 16454, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:07.184] #25 0x00000000006befd4 in ExecuteDoStmt (pstate=0x832bd8100, pstate@entry=0x832be6500, stmt=stmt@entry=0x832c77248, atomic=8) at ../src/backend/commands/functioncmds.c:2156 [18:20:07.184] codeblock = 0x6 [18:20:07.184] as_item = 0x0 [18:20:07.184] language_item = [18:20:07.184] arg = [18:20:07.184] language = [18:20:07.184] languageTuple = [18:20:07.184] languageStruct = [18:20:07.184] laninline = 101734 [18:20:07.184] #26 0x0000000000904773 in standard_ProcessUtility (pstmt=0x832bd9e30, queryString=0x832bd8100 "DO $$ plpy.notice(\"This is plpython3u.\") $$ LANGUAGE plpython3u;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832bd9f40, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:707 [18:20:07.184] isAtomicContext = false [18:20:07.184] parsetree = 0x832c77248 [18:20:07.184] readonly_flags = [18:20:07.184] pstate = 0x832be6500 [18:20:07.184] isTopLevel = [18:20:07.184] #27 0x0000000000904538 in ProcessUtility (pstmt=0x18d66, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832bd9f40, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:07.184] No locals. [18:20:07.184] #28 0x0000000000904073 in PortalRunUtility (portal=0x832cad100, pstmt=0x832bd9e30, isTopLevel=, setHoldSnapshot=, dest=0x832bd9f40, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:07.184] No locals. [18:20:07.184] #29 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832cad100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832bd9f40, altdest=altdest@entry=0x832bd9f40, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:07.184] pstmt = 0x832bd9e30 [18:20:07.184] stmtlist_item__state = {l = 0x832c77490, i = 0} [18:20:07.184] active_snapshot_set = false [18:20:07.184] stmtlist_item = 0x832c774a8 [18:20:07.184] #30 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832cad100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832bd9f40, altdest=altdest@entry=0x832bd9f40, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:07.184] _local_sigjmp_buf = {{_sjb = {9449293, 35211890944, 34910714280, 34910714512, 34910714288, 35211956224, 12106024, 12139336, 35211838335, 35211024856, 4294967984, 0}}} [18:20:07.184] _save_exception_stack = 0x820d73b80 [18:20:07.184] _save_context_stack = 0x0 [18:20:07.184] _do_rethrow = false [18:20:07.184] saveTopTransactionResourceOwner = 0x832cb7a20 [18:20:07.184] saveTopTransactionContext = 0x832cbd000 [18:20:07.184] saveActivePortal = 0x0 [18:20:07.184] saveResourceOwner = 0x832cb7a20 [18:20:07.184] savePortalContext = 0x0 [18:20:07.184] saveMemoryContext = 0x832cbd000 [18:20:07.184] result = [18:20:07.184] nprocessed = [18:20:07.184] #31 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "DO $$ plpy.notice(\"This is plpython3u.\") $$ LANGUAGE plpython3u;") at ../src/backend/tcop/postgres.c:1284 [18:20:07.184] cmdtaglen = 2 [18:20:07.184] snapshot_set = [18:20:07.184] per_parsetree_context = 0x0 [18:20:07.184] plantree_list = [18:20:07.184] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:07.184] format = 0 [18:20:07.184] parsetree = 0x832bd93f0 [18:20:07.184] commandTag = [18:20:07.184] cmdtagname = [18:20:07.184] querytree_list = [18:20:07.184] portal = 0x832cad100 [18:20:07.184] receiver = 0x832bd9f40 [18:20:07.184] parsetree_item__state = {l = 0x832bd9618, i = 0} [18:20:07.184] msec_str = "\000\000\000\000\b", '\000' , "\a\001\326f\000\000\000\000*\201!Ot\260}^" [18:20:07.184] dest = DestRemote [18:20:07.184] was_logged = [18:20:07.184] oldcontext = 0x832cbd000 [18:20:07.184] parsetree_list = 0x832bd9618 [18:20:07.184] use_implicit_block = false [18:20:07.184] parsetree_item = 0x832bd9630 [18:20:07.184] save_log_statement_stats = [18:20:07.184] #32 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:07.184] query_string = 0x832bd8100 "DO $$ plpy.notice(\"This is plpython3u.\") $$ LANGUAGE plpython3u;" [18:20:07.184] input_message = {data = 0x832bd8100 "DO $$ plpy.notice(\"This is plpython3u.\") $$ LANGUAGE plpython3u;", len = 65, maxlen = 1024, cursor = 65} [18:20:07.184] firstchar = [18:20:07.184] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:07.184] send_ready_for_query = false [18:20:07.184] idle_in_transaction_timeout_enabled = false [18:20:07.184] idle_session_timeout_enabled = false [18:20:07.184] #33 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:07.184] bsdata = [18:20:07.184] #34 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:07.184] pid = [18:20:07.184] #35 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:07.184] startup_data = {canAcceptConnections = CAC_OK} [18:20:07.184] bn = 0x832bd9f00 [18:20:07.184] pid = [18:20:07.184] __error = [18:20:07.184] save_errno = [18:20:07.184] __error = [18:20:07.184] __error = [18:20:07.184] #36 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:07.184] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:07.184] i = 0 [18:20:07.184] now = [18:20:07.184] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:07.185] last_touch_time = 1725300997 [18:20:07.185] last_lockfile_recheck_time = 1725300997 [18:20:07.185] nevents = 1 [18:20:07.185] #37 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:07.185] userDoption = [18:20:07.185] listen_addr_saved = [18:20:07.185] output_config_variable = [18:20:07.185] opt = [18:20:07.185] status = [18:20:07.185] #38 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:07.185] do_check_root = [18:20:07.197] [18:20:07.197] [18:20:07.197] [18:20:07.265] dumping /tmp/cores/postgres.20119.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:07.390] [New LWP 100702] [18:20:07.468] Core was generated by `postgres: postgres regression_plpython [local] CREATE FUNCTION'. [18:20:07.468] Program terminated with signal SIGABRT, Aborted. [18:20:07.468] Sent by thr_kill() from pid 20119 and user 1003. [18:20:07.468] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:08.068] To enable execution of this file add [18:20:08.068] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:08.068] line to your configuration file "/.config/gdb/gdbinit". [18:20:08.068] To completely disable this security protection add [18:20:08.068] set auto-load safe-path / [18:20:08.068] line to your configuration file "/.config/gdb/gdbinit". [18:20:08.068] For more information about this security protection see the [18:20:08.068] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:08.068] info "(gdb)Auto-loading safe path" [18:20:08.068] [18:20:08.068] Thread 1 (LWP 100702): [18:20:08.068] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:08.068] No symbol table info available. [18:20:08.068] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:08.068] No symbol table info available. [18:20:08.068] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:08.068] No symbol table info available. [18:20:08.068] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x840b12e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:08.068] No locals. [18:20:08.068] #4 0x0000000840b1c063 in PLy_generate_spi_exceptions (mod=0x845ffdad0, base=0x8353b1010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:08.068] dict = [18:20:08.068] found = true [18:20:08.068] sqlstate = [18:20:08.068] exc = 0x835465c10 [18:20:08.068] entry = 0x0 [18:20:08.068] i = 66 [18:20:08.068] #5 PLy_add_exceptions (plpy=0x844146c50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:08.068] hash_ctl = {num_partitions = 35501215088, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x8440e0d40, match = 0x8440e0d40, keycopy = 0x845fe4f80, alloc = 0x84413e070, hcxt = 0x842edcac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:08.068] excmod = 0x845ffdad0 [18:20:08.068] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:08.068] m = 0x844146c50 [18:20:08.068] #7 0x0000000842ce8f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #8 0x0000000842ce72e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #9 0x0000000842c07c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #10 0x0000000842cb1d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #11 0x0000000842cb4795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #12 0x0000000842bb590f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #13 0x0000000842bb5705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #14 0x0000000842ce3284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #15 0x0000000842c9b996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #16 0x0000000842c07e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #17 0x0000000842bb4538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #18 0x0000000842bb4467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #19 0x0000000842ce2b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #20 0x0000000842ce3ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.068] No symbol table info available. [18:20:08.068] #21 0x0000000840b1b476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:08.068] inited = false [18:20:08.068] #22 0x0000000840b1b3a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:08.068] funcoid = 24576 [18:20:08.068] tuple = [18:20:08.068] is_trigger = [18:20:08.068] procStruct = [18:20:08.068] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=24576) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:08.068] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000\000`", '\000' } [18:20:08.068] fcinfo = 0x820d73298 [18:20:08.068] result = [18:20:08.068] __error = [18:20:08.068] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=24576) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:08.068] flinfo = {fn_addr = 0x840b1b370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:08.068] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832c780d8 "newline_lf", procNamespace=procNamespace@entry=2200, replace=true, returnsSet=, returnType=23, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x832c782e8 "x = 100\ny = 23\nreturn x + y\n", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c233b0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:08.068] set_items = [18:20:08.068] save_nestlevel = 0 [18:20:08.068] myself = {classId = 1255, objectId = 24576, objectSubId = 0} [18:20:08.068] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:08.068] values = {24576, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 0, 0, 23, 35211326384, 0, 0, 0, 0, 0, 35211326456, 0, 0, 0, 0} [18:20:08.068] replaces = {true } [18:20:08.068] procname = {data = "newline_lf", '\000' } [18:20:08.068] referenced = {classId = 1247, objectId = 23, objectSubId = 0} [18:20:08.068] paramModes = [18:20:08.068] variadicType = [18:20:08.068] proacl = 0x0 [18:20:08.068] parameterCount = [18:20:08.068] allParamCount = 0 [18:20:08.068] allParams = 0x832c233c8 [18:20:08.068] detailmsg = [18:20:08.068] i = [18:20:08.068] rel = 0x832d05058 [18:20:08.068] tupDesc = 0x832d05378 [18:20:08.068] oldtup = 0x0 [18:20:08.068] tup = 0x832c23258 [18:20:08.068] is_update = [18:20:08.068] retval = 24576 [18:20:08.068] addrs = [18:20:08.068] trfid = [18:20:08.068] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832be6500, stmt=, stmt@entry=0x832c78088) at ../src/backend/commands/functioncmds.c:1257 [18:20:08.068] funcname = 0x832c780d8 "newline_lf" [18:20:08.068] parameterTypes = 0x832c233b0 [18:20:08.068] parameterTypes_list = 0x0 [18:20:08.068] allParameterTypes = 0x0 [18:20:08.068] parameterModes = 0x0 [18:20:08.068] parameterNames = 0x0 [18:20:08.068] inParameterNames_list = 0x0 [18:20:08.068] parameterDefaults = 0x0 [18:20:08.068] variadicArgType = 0 [18:20:08.068] requiredResultType = 0 [18:20:08.068] transformDefElem = [18:20:08.068] trftypes_list = [18:20:08.068] namespaceId = 2200 [18:20:08.068] aclresult = [18:20:08.068] as_clause = [18:20:08.068] language = [18:20:08.068] isWindowFunc = false [18:20:08.068] isStrict = false [18:20:08.068] security = false [18:20:08.068] isLeakProof = [18:20:08.068] volatility = 118 'v' [18:20:08.068] proconfig = 0x0 [18:20:08.068] procost = 100 [18:20:08.068] prorows = 0 [18:20:08.068] prosupport = 0 [18:20:08.068] parallel = 117 'u' [18:20:08.068] languageTuple = [18:20:08.068] languageStruct = [18:20:08.068] languageOid = 16456 [18:20:08.068] languageValidator = 16455 [18:20:08.068] prorettype = 23 [18:20:08.068] returnsSet = false [18:20:08.068] trftypes = 0x0 [18:20:08.068] prosqlbody = 0x0 [18:20:08.068] probin_str = 0x0 [18:20:08.068] prosrc_str = 0x832c782e8 "x = 100\ny = 23\nreturn x + y\n" [18:20:08.068] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832be6500, pstmt=pstmt@entry=0x832bd9c68, queryString=queryString@entry=0x832bd8100 "CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS\nE'x = 100\\ny = 23\\nreturn x + y\\n'\nLANGUAGE plpython3u;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:08.068] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35211076864, 35211641727, 10, 0, 549755813888}}} [18:20:08.068] _save_exception_stack = 0x820d739b0 [18:20:08.068] _save_context_stack = 0x0 [18:20:08.068] _do_rethrow = false [18:20:08.068] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:08.068] parsetree = 0x832c78088 [18:20:08.068] commandCollected = false [18:20:08.068] needCleanup = false [18:20:08.068] address = [18:20:08.068] isTopLevel = [18:20:08.068] isCompleteQuery = [18:20:08.068] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832bd9c68, queryString=0x832bd8100 "CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS\nE'x = 100\\ny = 23\\nreturn x + y\\n'\nLANGUAGE plpython3u;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832c78548, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:08.068] isAtomicContext = false [18:20:08.068] parsetree = 0x832c78088 [18:20:08.068] readonly_flags = [18:20:08.068] pstate = 0x832be6500 [18:20:08.068] isTopLevel = [18:20:08.068] #29 0x0000000000904538 in ProcessUtility (pstmt=0x1895e, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832c78548, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:08.068] No locals. [18:20:08.068] #30 0x0000000000904073 in PortalRunUtility (portal=0x832cad100, pstmt=0x832bd9c68, isTopLevel=, setHoldSnapshot=, dest=0x832c78548, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:08.068] No locals. [18:20:08.068] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832cad100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832c78548, altdest=altdest@entry=0x832c78548, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:08.068] pstmt = 0x832bd9c68 [18:20:08.068] stmtlist_item__state = {l = 0x832c784f8, i = 0} [18:20:08.068] active_snapshot_set = false [18:20:08.068] stmtlist_item = 0x832c78510 [18:20:08.068] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832cad100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832c78548, altdest=altdest@entry=0x832c78548, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:08.068] _local_sigjmp_buf = {{_sjb = {9449293, 35211890944, 34910714280, 34910714512, 34910714288, 35211956224, 12106024, 12139336, 35211838335, 35211669560, 4294967984, 0}}} [18:20:08.068] _save_exception_stack = 0x820d73b80 [18:20:08.068] _save_context_stack = 0x0 [18:20:08.068] _do_rethrow = false [18:20:08.068] saveTopTransactionResourceOwner = 0x832cb9828 [18:20:08.068] saveTopTransactionContext = 0x832cbd000 [18:20:08.068] saveActivePortal = 0x0 [18:20:08.068] saveResourceOwner = 0x832cb9828 [18:20:08.068] savePortalContext = 0x0 [18:20:08.068] saveMemoryContext = 0x832cbd000 [18:20:08.068] result = [18:20:08.068] nprocessed = [18:20:08.068] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS\nE'x = 100\\ny = 23\\nreturn x + y\\n'\nLANGUAGE plpython3u;") at ../src/backend/tcop/postgres.c:1284 [18:20:08.068] cmdtaglen = 15 [18:20:08.068] snapshot_set = [18:20:08.068] per_parsetree_context = 0x0 [18:20:08.068] plantree_list = [18:20:08.068] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:08.068] format = 0 [18:20:08.068] parsetree = 0x832bd97c8 [18:20:08.068] commandTag = [18:20:08.068] cmdtagname = [18:20:08.068] querytree_list = [18:20:08.068] portal = 0x832cad100 [18:20:08.068] receiver = 0x832c78548 [18:20:08.068] parsetree_item__state = {l = 0x832bd9c18, i = 0} [18:20:08.068] msec_str = "\000\000\000\000\b", '\000' , "\n\001\326f\000\000\000\000\002\261i@\036\321#1" [18:20:08.068] dest = DestRemote [18:20:08.068] was_logged = [18:20:08.068] oldcontext = 0x832cbd000 [18:20:08.068] parsetree_list = 0x832bd9c18 [18:20:08.068] use_implicit_block = false [18:20:08.068] parsetree_item = 0x832bd9c30 [18:20:08.068] save_log_statement_stats = [18:20:08.068] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:08.068] query_string = 0x832bd8100 "CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS\nE'x = 100\\ny = 23\\nreturn x + y\\n'\nLANGUAGE plpython3u;" [18:20:08.068] input_message = {data = 0x832bd8100 "CREATE OR REPLACE FUNCTION newline_lf() RETURNS integer AS\nE'x = 100\\ny = 23\\nreturn x + y\\n'\nLANGUAGE plpython3u;", len = 115, maxlen = 1024, cursor = 115} [18:20:08.068] firstchar = [18:20:08.068] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:08.068] send_ready_for_query = false [18:20:08.068] idle_in_transaction_timeout_enabled = false [18:20:08.068] idle_session_timeout_enabled = false [18:20:08.068] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:08.068] bsdata = [18:20:08.068] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:08.068] pid = [18:20:08.068] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:08.068] startup_data = {canAcceptConnections = CAC_OK} [18:20:08.068] bn = 0x832bd9f00 [18:20:08.068] pid = [18:20:08.068] __error = [18:20:08.068] save_errno = [18:20:08.068] __error = [18:20:08.068] __error = [18:20:08.068] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:08.068] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:08.068] i = 0 [18:20:08.068] now = [18:20:08.068] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:08.068] last_touch_time = 1725300997 [18:20:08.068] last_lockfile_recheck_time = 1725300997 [18:20:08.068] nevents = 1 [18:20:08.068] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:08.068] userDoption = [18:20:08.068] listen_addr_saved = [18:20:08.068] output_config_variable = [18:20:08.068] opt = [18:20:08.068] status = [18:20:08.068] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:08.068] do_check_root = [18:20:08.080] [18:20:08.080] [18:20:08.080] [18:20:08.147] dumping /tmp/cores/postgres.20406.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:08.274] [New LWP 101802] [18:20:08.348] Core was generated by `postgres: postgres regression_plpython [local] CREATE FUNCTION'. [18:20:08.348] Program terminated with signal SIGABRT, Aborted. [18:20:08.348] Sent by thr_kill() from pid 20406 and user 1003. [18:20:08.348] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:08.942] To enable execution of this file add [18:20:08.942] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:08.942] line to your configuration file "/.config/gdb/gdbinit". [18:20:08.942] To completely disable this security protection add [18:20:08.942] set auto-load safe-path / [18:20:08.942] line to your configuration file "/.config/gdb/gdbinit". [18:20:08.942] For more information about this security protection see the [18:20:08.942] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:08.942] info "(gdb)Auto-loading safe path" [18:20:08.942] [18:20:08.942] Thread 1 (LWP 101802): [18:20:08.942] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:08.942] No symbol table info available. [18:20:08.942] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:08.942] No symbol table info available. [18:20:08.942] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:08.942] No symbol table info available. [18:20:08.942] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x841b06e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:08.942] No locals. [18:20:08.942] #4 0x0000000841b10063 in PLy_generate_spi_exceptions (mod=0x8458159e0, base=0x835535010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:08.942] dict = [18:20:08.942] found = true [18:20:08.942] sqlstate = [18:20:08.942] exc = 0x8355e9c10 [18:20:08.942] entry = 0x0 [18:20:08.942] i = 66 [18:20:08.942] #5 PLy_add_exceptions (plpy=0x84577ec00) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:08.942] hash_ctl = {num_partitions = 35524513136, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x845718d40, match = 0x845718d40, keycopy = 0x8457fd000, alloc = 0x8457760f0, hcxt = 0x843eb8ac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:08.942] excmod = 0x8458159e0 [18:20:08.942] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:08.942] m = 0x84577ec00 [18:20:08.942] #7 0x0000000843cc4f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #8 0x0000000843cc32e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #9 0x0000000843be3c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #10 0x0000000843c8dd9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #11 0x0000000843c90795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #12 0x0000000843b9190f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #13 0x0000000843b91705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #14 0x0000000843cbf284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #15 0x0000000843c77996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #16 0x0000000843be3e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #17 0x0000000843b90538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #18 0x0000000843b90467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #19 0x0000000843cbeb30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #20 0x0000000843cbfef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:08.942] No symbol table info available. [18:20:08.942] #21 0x0000000841b0f476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:08.942] inited = false [18:20:08.942] #22 0x0000000841b0f3a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:08.942] funcoid = 32768 [18:20:08.942] tuple = [18:20:08.942] is_trigger = [18:20:08.942] procStruct = [18:20:08.942] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=32768) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:08.942] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000\000\200", '\000' } [18:20:08.942] fcinfo = 0x820d73298 [18:20:08.942] result = [18:20:08.942] __error = [18:20:08.942] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=32768) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:08.942] flinfo = {fn_addr = 0x841b0f370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:08.942] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832c78978 "users_insert", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=2279, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x832c78b48 "if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fname\"][:1] + \"_\" + TD[\"new\"][\"lname\"]\n\trv = \"MODIFY\"\n"..., probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c233b0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:08.942] set_items = [18:20:08.942] save_nestlevel = 0 [18:20:08.942] myself = {classId = 1255, objectId = 32768, objectSubId = 0} [18:20:08.942] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:08.942] values = {32768, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 0, 0, 2279, 35211326384, 0, 0, 0, 0, 0, 35212681272, 0, 0, 0, 0} [18:20:08.942] replaces = {true } [18:20:08.942] procname = {data = "users_insert", '\000' } [18:20:08.942] referenced = {classId = 1247, objectId = 2279, objectSubId = 0} [18:20:08.942] paramModes = [18:20:08.942] variadicType = [18:20:08.942] proacl = 0x0 [18:20:08.942] parameterCount = [18:20:08.942] allParamCount = 0 [18:20:08.942] allParams = 0x832c233c8 [18:20:08.942] detailmsg = [18:20:08.942] i = [18:20:08.942] rel = 0x832d04918 [18:20:08.942] tupDesc = 0x832d04c38 [18:20:08.942] oldtup = 0x0 [18:20:08.942] tup = 0x832c233f8 [18:20:08.942] is_update = [18:20:08.942] retval = 32768 [18:20:08.942] addrs = [18:20:08.942] trfid = [18:20:08.942] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832be6500, stmt=, stmt@entry=0x832c78928) at ../src/backend/commands/functioncmds.c:1257 [18:20:08.942] funcname = 0x832c78978 "users_insert" [18:20:08.942] parameterTypes = 0x832c233b0 [18:20:08.942] parameterTypes_list = 0x0 [18:20:08.942] allParameterTypes = 0x0 [18:20:08.942] parameterModes = 0x0 [18:20:08.942] parameterNames = 0x0 [18:20:08.942] inParameterNames_list = 0x0 [18:20:08.942] parameterDefaults = 0x0 [18:20:08.942] variadicArgType = 0 [18:20:08.942] requiredResultType = 0 [18:20:08.942] transformDefElem = [18:20:08.942] trftypes_list = [18:20:08.942] namespaceId = 2200 [18:20:08.942] aclresult = [18:20:08.942] as_clause = [18:20:08.942] language = [18:20:08.942] isWindowFunc = false [18:20:08.942] isStrict = false [18:20:08.942] security = false [18:20:08.942] isLeakProof = [18:20:08.942] volatility = 118 'v' [18:20:08.942] proconfig = 0x0 [18:20:08.942] procost = 100 [18:20:08.942] prorows = 0 [18:20:08.942] prosupport = 0 [18:20:08.942] parallel = 117 'u' [18:20:08.942] languageTuple = [18:20:08.942] languageStruct = [18:20:08.942] languageOid = 16456 [18:20:08.942] languageValidator = 16455 [18:20:08.942] prorettype = 2279 [18:20:08.942] returnsSet = false [18:20:08.942] trftypes = 0x0 [18:20:08.942] prosqlbody = 0x0 [18:20:08.942] probin_str = 0x0 [18:20:08.942] prosrc_str = 0x832c78b48 "if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fname\"][:1] + \"_\" + TD[\"new\"][\"lname\"]\n\trv = \"MODIFY\"\n"... [18:20:08.942] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832be6500, pstmt=pstmt@entry=0x832c77398, queryString=queryString@entry=0x832bd8100 "CREATE FUNCTION users_insert() returns trigger\n\tAS\n'if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fn"..., context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:08.942] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35211076864, 35211641727, 10, 0, 549755813888}}} [18:20:08.942] _save_exception_stack = 0x820d739b0 [18:20:08.942] _save_context_stack = 0x0 [18:20:08.942] _do_rethrow = false [18:20:08.942] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:08.942] parsetree = 0x832c78928 [18:20:08.942] commandCollected = false [18:20:08.942] needCleanup = false [18:20:08.942] address = [18:20:08.942] isTopLevel = [18:20:08.942] isCompleteQuery = [18:20:08.942] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832c77398, queryString=0x832bd8100 "CREATE FUNCTION users_insert() returns trigger\n\tAS\n'if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fn"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832bd9f10, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:08.942] isAtomicContext = false [18:20:08.942] parsetree = 0x832c78928 [18:20:08.942] readonly_flags = [18:20:08.942] pstate = 0x832be6500 [18:20:08.942] isTopLevel = [18:20:08.942] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18daa, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832bd9f10, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:08.942] No locals. [18:20:08.942] #30 0x0000000000904073 in PortalRunUtility (portal=0x832cad100, pstmt=0x832c77398, isTopLevel=, setHoldSnapshot=, dest=0x832bd9f10, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:08.942] No locals. [18:20:08.942] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832cad100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832bd9f10, altdest=altdest@entry=0x832bd9f10, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:08.942] pstmt = 0x832c77398 [18:20:08.942] stmtlist_item__state = {l = 0x832c78f18, i = 0} [18:20:08.942] active_snapshot_set = false [18:20:08.942] stmtlist_item = 0x832c78f30 [18:20:08.942] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832cad100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832bd9f10, altdest=altdest@entry=0x832bd9f10, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:08.942] _local_sigjmp_buf = {{_sjb = {9449293, 35211890944, 34910714280, 34910714512, 34910714288, 35211956224, 12106024, 12139336, 35211838335, 35211671304, 4294967984, 0}}} [18:20:08.942] _save_exception_stack = 0x820d73b80 [18:20:08.942] _save_context_stack = 0x0 [18:20:08.942] _do_rethrow = false [18:20:08.942] saveTopTransactionResourceOwner = 0x832cba5d8 [18:20:08.942] saveTopTransactionContext = 0x832cbd000 [18:20:08.942] saveActivePortal = 0x0 [18:20:08.942] saveResourceOwner = 0x832cba5d8 [18:20:08.942] savePortalContext = 0x0 [18:20:08.942] saveMemoryContext = 0x832cbd000 [18:20:08.942] result = [18:20:08.942] nprocessed = [18:20:08.942] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "CREATE FUNCTION users_insert() returns trigger\n\tAS\n'if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fn"...) at ../src/backend/tcop/postgres.c:1284 [18:20:08.942] cmdtaglen = 15 [18:20:08.942] snapshot_set = [18:20:08.942] per_parsetree_context = 0x0 [18:20:08.942] plantree_list = [18:20:08.942] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:08.942] format = 0 [18:20:08.942] parsetree = 0x832bd9cc0 [18:20:08.942] commandTag = [18:20:08.942] cmdtagname = [18:20:08.942] querytree_list = [18:20:08.942] portal = 0x832cad100 [18:20:08.942] receiver = 0x832bd9f10 [18:20:08.942] parsetree_item__state = {l = 0x832c77348, i = 0} [18:20:08.942] msec_str = "\000\000\000\000\b", '\000' , "\v\001\326f\000\000\000\000\250\357\001Y`\2452\377" [18:20:08.942] dest = DestRemote [18:20:08.942] was_logged = [18:20:08.942] oldcontext = 0x832cbd000 [18:20:08.942] parsetree_list = 0x832c77348 [18:20:08.942] use_implicit_block = false [18:20:08.942] parsetree_item = 0x832c77360 [18:20:08.942] save_log_statement_stats = [18:20:08.942] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:08.942] query_string = 0x832bd8100 "CREATE FUNCTION users_insert() returns trigger\n\tAS\n'if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fn"... [18:20:08.942] input_message = {data = 0x832bd8100 "CREATE FUNCTION users_insert() returns trigger\n\tAS\n'if TD[\"new\"][\"fname\"] == None or TD[\"new\"][\"lname\"] == None:\n\treturn \"SKIP\"\nif TD[\"new\"][\"username\"] == None:\n\tTD[\"new\"][\"username\"] = TD[\"new\"][\"fn"..., len = 389, maxlen = 1024, cursor = 389} [18:20:08.942] firstchar = [18:20:08.942] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:08.942] send_ready_for_query = false [18:20:08.942] idle_in_transaction_timeout_enabled = false [18:20:08.942] idle_session_timeout_enabled = false [18:20:08.942] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:08.942] bsdata = [18:20:08.942] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:08.942] pid = [18:20:08.942] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:08.942] startup_data = {canAcceptConnections = CAC_OK} [18:20:08.942] bn = 0x832bd9f00 [18:20:08.942] pid = [18:20:08.942] __error = [18:20:08.942] save_errno = [18:20:08.942] __error = [18:20:08.942] __error = [18:20:08.942] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:08.942] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:08.942] i = 0 [18:20:08.942] now = [18:20:08.942] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:08.942] last_touch_time = 1725300997 [18:20:08.942] last_lockfile_recheck_time = 1725300997 [18:20:08.942] nevents = 1 [18:20:08.942] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:08.942] userDoption = [18:20:08.942] listen_addr_saved = [18:20:08.942] output_config_variable = [18:20:08.942] opt = [18:20:08.942] status = [18:20:08.942] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:08.942] do_check_root = [18:20:08.955] [18:20:08.955] [18:20:08.955] [18:20:09.026] dumping /tmp/cores/postgres.20598.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:09.149] [New LWP 100096] [18:20:09.228] Core was generated by `postgres: postgres regression_plpython [local] CREATE FUNCTION'. [18:20:09.228] Program terminated with signal SIGABRT, Aborted. [18:20:09.228] Sent by thr_kill() from pid 20598 and user 1003. [18:20:09.228] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:09.835] To enable execution of this file add [18:20:09.835] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:09.835] line to your configuration file "/.config/gdb/gdbinit". [18:20:09.835] To completely disable this security protection add [18:20:09.835] set auto-load safe-path / [18:20:09.835] line to your configuration file "/.config/gdb/gdbinit". [18:20:09.835] For more information about this security protection see the [18:20:09.835] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:09.835] info "(gdb)Auto-loading safe path" [18:20:09.835] [18:20:09.835] Thread 1 (LWP 100096): [18:20:09.835] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:09.835] No symbol table info available. [18:20:09.835] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:09.835] No symbol table info available. [18:20:09.835] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:09.835] No symbol table info available. [18:20:09.835] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x8417f5e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:09.835] No locals. [18:20:09.835] #4 0x00000008417ff063 in PLy_generate_spi_exceptions (mod=0x8444e9ad0, base=0x8351bf010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:09.835] dict = [18:20:09.835] found = true [18:20:09.835] sqlstate = [18:20:09.835] exc = 0x835277c10 [18:20:09.835] entry = 0x0 [18:20:09.835] i = 66 [18:20:09.835] #5 PLy_add_exceptions (plpy=0x843296c50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:09.835] hash_ctl = {num_partitions = 35485814128, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x843230d40, match = 0x843230d40, keycopy = 0x8444d1040, alloc = 0x84328e130, hcxt = 0x842699ac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:09.835] excmod = 0x8444e9ad0 [18:20:09.835] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:09.835] m = 0x843296c50 [18:20:09.835] #7 0x00000008424a5f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #8 0x00000008424a42e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #9 0x00000008423c4c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #10 0x000000084246ed9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #11 0x0000000842471795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #12 0x000000084237290f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #13 0x0000000842372705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #14 0x00000008424a0284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #15 0x0000000842458996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #16 0x00000008423c4e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #17 0x0000000842371538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #18 0x0000000842371467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #19 0x000000084249fb30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #20 0x00000008424a0ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:09.835] No symbol table info available. [18:20:09.835] #21 0x00000008417fe476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:09.835] inited = false [18:20:09.835] #22 0x00000008417fe3a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:09.835] funcoid = 40960 [18:20:09.835] tuple = [18:20:09.835] is_trigger = [18:20:09.835] procStruct = [18:20:09.835] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=40960) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:09.835] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000\000\240", '\000' } [18:20:09.835] fcinfo = 0x820d73298 [18:20:09.835] result = [18:20:09.835] __error = [18:20:09.835] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=40960) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:09.835] flinfo = {fn_addr = 0x8417fe370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:09.835] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832c78078 "python_syntax_error", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=25, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x832c78258 ".syntaxerror", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c233b0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:09.835] set_items = [18:20:09.835] save_nestlevel = 0 [18:20:09.835] myself = {classId = 1255, objectId = 40960, objectSubId = 0} [18:20:09.835] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:09.835] values = {40960, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 0, 0, 25, 35211326384, 0, 0, 0, 0, 0, 35212698328, 0, 0, 0, 0} [18:20:09.835] replaces = {true } [18:20:09.835] procname = {data = "python_syntax_error", '\000' } [18:20:09.835] referenced = {classId = 1247, objectId = 25, objectSubId = 0} [18:20:09.835] paramModes = [18:20:09.835] variadicType = [18:20:09.835] proacl = 0x0 [18:20:09.835] parameterCount = [18:20:09.835] allParamCount = 0 [18:20:09.835] allParams = 0x832c233c8 [18:20:09.835] detailmsg = [18:20:09.835] i = [18:20:09.835] rel = 0x832cff918 [18:20:09.835] tupDesc = 0x832cffc38 [18:20:09.835] oldtup = 0x0 [18:20:09.835] tup = 0x832c23258 [18:20:09.835] is_update = [18:20:09.835] retval = 40960 [18:20:09.835] addrs = [18:20:09.835] trfid = [18:20:09.835] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832be6500, stmt=, stmt@entry=0x832c78028) at ../src/backend/commands/functioncmds.c:1257 [18:20:09.835] funcname = 0x832c78078 "python_syntax_error" [18:20:09.835] parameterTypes = 0x832c233b0 [18:20:09.835] parameterTypes_list = 0x0 [18:20:09.835] allParameterTypes = 0x0 [18:20:09.835] parameterModes = 0x0 [18:20:09.835] parameterNames = 0x0 [18:20:09.835] inParameterNames_list = 0x0 [18:20:09.835] parameterDefaults = 0x0 [18:20:09.835] variadicArgType = 0 [18:20:09.835] requiredResultType = 0 [18:20:09.835] transformDefElem = [18:20:09.835] trftypes_list = [18:20:09.835] namespaceId = 2200 [18:20:09.835] aclresult = [18:20:09.835] as_clause = [18:20:09.835] language = [18:20:09.835] isWindowFunc = false [18:20:09.835] isStrict = false [18:20:09.835] security = false [18:20:09.835] isLeakProof = [18:20:09.835] volatility = 118 'v' [18:20:09.835] proconfig = 0x0 [18:20:09.835] procost = 100 [18:20:09.835] prorows = 0 [18:20:09.835] prosupport = 0 [18:20:09.835] parallel = 117 'u' [18:20:09.835] languageTuple = [18:20:09.835] languageStruct = [18:20:09.835] languageOid = 16456 [18:20:09.835] languageValidator = 16455 [18:20:09.835] prorettype = 25 [18:20:09.835] returnsSet = false [18:20:09.835] trftypes = 0x0 [18:20:09.835] prosqlbody = 0x0 [18:20:09.835] probin_str = 0x0 [18:20:09.835] prosrc_str = 0x832c78258 ".syntaxerror" [18:20:09.835] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832be6500, pstmt=pstmt@entry=0x832bd9c40, queryString=queryString@entry=0x832bd8100 "/* Flat out Python syntax error\n */\nCREATE FUNCTION python_syntax_error() RETURNS text\n AS\n'.syntaxerror'\n LANGUAGE plpython3u;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:09.835] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35211076864, 35211641727, 10, 0, 549755813888}}} [18:20:09.835] _save_exception_stack = 0x820d739b0 [18:20:09.835] _save_context_stack = 0x0 [18:20:09.835] _do_rethrow = false [18:20:09.835] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:09.835] parsetree = 0x832c78028 [18:20:09.835] commandCollected = false [18:20:09.835] needCleanup = false [18:20:09.835] address = [18:20:09.835] isTopLevel = [18:20:09.835] isCompleteQuery = [18:20:09.835] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832bd9c40, queryString=0x832bd8100 "/* Flat out Python syntax error\n */\nCREATE FUNCTION python_syntax_error() RETURNS text\n AS\n'.syntaxerror'\n LANGUAGE plpython3u;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832c78488, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:09.835] isAtomicContext = false [18:20:09.835] parsetree = 0x832c78028 [18:20:09.835] readonly_flags = [18:20:09.835] pstate = 0x832be6500 [18:20:09.835] isTopLevel = [18:20:09.835] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18700, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832c78488, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:09.835] No locals. [18:20:09.835] #30 0x0000000000904073 in PortalRunUtility (portal=0x832caf100, pstmt=0x832bd9c40, isTopLevel=, setHoldSnapshot=, dest=0x832c78488, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:09.835] No locals. [18:20:09.835] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832caf100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832c78488, altdest=altdest@entry=0x832c78488, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:09.835] pstmt = 0x832bd9c40 [18:20:09.835] stmtlist_item__state = {l = 0x832c78438, i = 0} [18:20:09.835] active_snapshot_set = false [18:20:09.835] stmtlist_item = 0x832c78450 [18:20:09.835] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832caf100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832c78488, altdest=altdest@entry=0x832c78488, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:09.835] _local_sigjmp_buf = {{_sjb = {9449293, 35211899136, 34910714280, 34910714512, 34910714288, 35212337152, 12106024, 12139336, 35211903871, 35211026352, 4294967984, 0}}} [18:20:09.835] _save_exception_stack = 0x820d73b80 [18:20:09.835] _save_context_stack = 0x0 [18:20:09.835] _do_rethrow = false [18:20:09.835] saveTopTransactionResourceOwner = 0x832d351f8 [18:20:09.835] saveTopTransactionContext = 0x832d1a000 [18:20:09.835] saveActivePortal = 0x0 [18:20:09.835] saveResourceOwner = 0x832d351f8 [18:20:09.835] savePortalContext = 0x0 [18:20:09.835] saveMemoryContext = 0x832d1a000 [18:20:09.835] result = [18:20:09.835] nprocessed = [18:20:09.835] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "/* Flat out Python syntax error\n */\nCREATE FUNCTION python_syntax_error() RETURNS text\n AS\n'.syntaxerror'\n LANGUAGE plpython3u;") at ../src/backend/tcop/postgres.c:1284 [18:20:09.835] cmdtaglen = 15 [18:20:09.835] snapshot_set = [18:20:09.835] per_parsetree_context = 0x0 [18:20:09.835] plantree_list = [18:20:09.835] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:09.835] format = 0 [18:20:09.835] parsetree = 0x832bd9800 [18:20:09.835] commandTag = [18:20:09.835] cmdtagname = [18:20:09.835] querytree_list = [18:20:09.835] portal = 0x832caf100 [18:20:09.835] receiver = 0x832c78488 [18:20:09.835] parsetree_item__state = {l = 0x832bd9bf0, i = 0} [18:20:09.835] msec_str = "\000\000\000\000\b", '\000' , "\r\001\326f\000\000\000\000\252\n\241\210F\244", [18:20:09.835] dest = DestRemote [18:20:09.835] was_logged = [18:20:09.835] oldcontext = 0x832d1a000 [18:20:09.835] parsetree_list = 0x832bd9bf0 [18:20:09.835] use_implicit_block = false [18:20:09.835] parsetree_item = 0x832bd9c08 [18:20:09.835] save_log_statement_stats = [18:20:09.835] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:09.835] query_string = 0x832bd8100 "/* Flat out Python syntax error\n */\nCREATE FUNCTION python_syntax_error() RETURNS text\n AS\n'.syntaxerror'\n LANGUAGE plpython3u;" [18:20:09.835] input_message = {data = 0x832bd8100 "/* Flat out Python syntax error\n */\nCREATE FUNCTION python_syntax_error() RETURNS text\n AS\n'.syntaxerror'\n LANGUAGE plpython3u;", len = 142, maxlen = 1024, cursor = 142} [18:20:09.835] firstchar = [18:20:09.835] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:09.835] send_ready_for_query = false [18:20:09.835] idle_in_transaction_timeout_enabled = false [18:20:09.835] idle_session_timeout_enabled = false [18:20:09.835] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:09.835] bsdata = [18:20:09.835] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:09.835] pid = [18:20:09.835] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:09.835] startup_data = {canAcceptConnections = CAC_OK} [18:20:09.835] bn = 0x832bd9f00 [18:20:09.835] pid = [18:20:09.835] __error = [18:20:09.835] save_errno = [18:20:09.835] __error = [18:20:09.835] __error = [18:20:09.835] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:09.835] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:09.835] i = 0 [18:20:09.835] now = [18:20:09.835] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:09.836] last_touch_time = 1725300997 [18:20:09.836] last_lockfile_recheck_time = 1725300997 [18:20:09.836] nevents = 1 [18:20:09.836] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:09.836] userDoption = [18:20:09.836] listen_addr_saved = [18:20:09.836] output_config_variable = [18:20:09.836] opt = [18:20:09.836] status = [18:20:09.836] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:09.836] do_check_root = [18:20:09.848] [18:20:09.848] [18:20:09.848] [18:20:09.914] dumping /tmp/cores/postgres.20808.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:10.042] [New LWP 101754] [18:20:10.119] Core was generated by `postgres: postgres regression_plpython [local] CREATE FUNCTION'. [18:20:10.119] Program terminated with signal SIGABRT, Aborted. [18:20:10.119] Sent by thr_kill() from pid 20808 and user 1003. [18:20:10.119] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:10.708] To enable execution of this file add [18:20:10.708] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:10.708] line to your configuration file "/.config/gdb/gdbinit". [18:20:10.708] To completely disable this security protection add [18:20:10.708] set auto-load safe-path / [18:20:10.708] line to your configuration file "/.config/gdb/gdbinit". [18:20:10.708] For more information about this security protection see the [18:20:10.708] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:10.708] info "(gdb)Auto-loading safe path" [18:20:10.708] [18:20:10.708] Thread 1 (LWP 101754): [18:20:10.708] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:10.708] No symbol table info available. [18:20:10.708] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:10.708] No symbol table info available. [18:20:10.708] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:10.708] No symbol table info available. [18:20:10.708] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x8356b9e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:10.708] No locals. [18:20:10.708] #4 0x00000008356c3063 in PLy_generate_spi_exceptions (mod=0x84518dad0, base=0x834c87010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:10.708] dict = [18:20:10.708] found = true [18:20:10.708] sqlstate = [18:20:10.708] exc = 0x834d44c10 [18:20:10.708] entry = 0x0 [18:20:10.708] i = 66 [18:20:10.708] #5 PLy_add_exceptions (plpy=0x84362ec50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:10.708] hash_ctl = {num_partitions = 35489582448, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x8435c8d40, match = 0x8435c8d40, keycopy = 0x845175040, alloc = 0x843626130, hcxt = 0x8429baac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:10.708] excmod = 0x84518dad0 [18:20:10.708] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:10.708] m = 0x84362ec50 [18:20:10.708] #7 0x00000008427c6f70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #8 0x00000008427c52e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #9 0x00000008426e5c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #10 0x000000084278fd9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #11 0x0000000842792795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #12 0x000000084269390f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #13 0x0000000842693705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #14 0x00000008427c1284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #15 0x0000000842779996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #16 0x00000008426e5e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #17 0x0000000842692538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #18 0x0000000842692467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #19 0x00000008427c0b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #20 0x00000008427c1ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:10.708] No symbol table info available. [18:20:10.708] #21 0x00000008356c2476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:10.708] inited = false [18:20:10.708] #22 0x00000008356c23a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:10.708] funcoid = 49152 [18:20:10.708] tuple = [18:20:10.708] is_trigger = [18:20:10.708] procStruct = [18:20:10.708] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=49152) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:10.708] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000\000\300", '\000' } [18:20:10.708] fcinfo = 0x820d73298 [18:20:10.708] result = [18:20:10.708] __error = [18:20:10.708] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=49152) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:10.708] flinfo = {fn_addr = 0x8356c2370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832be6400, fn_expr = 0x0} [18:20:10.708] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832c78fe8 "elog_test", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=2278, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x834bb9078 "\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the question', detail=42);\nplpy.info('This is message te"..., probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c233b0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:10.708] set_items = [18:20:10.708] save_nestlevel = 0 [18:20:10.708] myself = {classId = 1255, objectId = 49152, objectSubId = 0} [18:20:10.708] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:10.708] values = {49152, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 0, 0, 2278, 35211326384, 0, 0, 0, 0, 0, 35211326456, 0, 0, 0, 0} [18:20:10.708] replaces = {true } [18:20:10.708] procname = {data = "elog_test", '\000' } [18:20:10.708] referenced = {classId = 1247, objectId = 2278, objectSubId = 0} [18:20:10.708] paramModes = [18:20:10.708] variadicType = [18:20:10.708] proacl = 0x0 [18:20:10.708] parameterCount = [18:20:10.708] allParamCount = 0 [18:20:10.708] allParams = 0x832c233c8 [18:20:10.708] detailmsg = [18:20:10.708] i = [18:20:10.708] rel = 0x832d08418 [18:20:10.708] tupDesc = 0x832d08738 [18:20:10.708] oldtup = 0x0 [18:20:10.708] tup = 0x832c32068 [18:20:10.708] is_update = [18:20:10.708] retval = 49152 [18:20:10.708] addrs = [18:20:10.708] trfid = [18:20:10.708] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832be6500, stmt=, stmt@entry=0x832c78f98) at ../src/backend/commands/functioncmds.c:1257 [18:20:10.708] funcname = 0x832c78fe8 "elog_test" [18:20:10.708] parameterTypes = 0x832c233b0 [18:20:10.708] parameterTypes_list = 0x0 [18:20:10.708] allParameterTypes = 0x0 [18:20:10.708] parameterModes = 0x0 [18:20:10.708] parameterNames = 0x0 [18:20:10.708] inParameterNames_list = 0x0 [18:20:10.708] parameterDefaults = 0x0 [18:20:10.708] variadicArgType = 0 [18:20:10.708] requiredResultType = 0 [18:20:10.708] transformDefElem = [18:20:10.708] trftypes_list = [18:20:10.708] namespaceId = 2200 [18:20:10.708] aclresult = [18:20:10.708] as_clause = [18:20:10.708] language = [18:20:10.708] isWindowFunc = false [18:20:10.708] isStrict = false [18:20:10.708] security = false [18:20:10.708] isLeakProof = [18:20:10.708] volatility = 118 'v' [18:20:10.708] proconfig = 0x0 [18:20:10.708] procost = 100 [18:20:10.708] prorows = 0 [18:20:10.708] prosupport = 0 [18:20:10.708] parallel = 117 'u' [18:20:10.708] languageTuple = [18:20:10.708] languageStruct = [18:20:10.708] languageOid = 16456 [18:20:10.708] languageValidator = 16455 [18:20:10.708] prorettype = 2278 [18:20:10.708] returnsSet = false [18:20:10.708] trftypes = 0x0 [18:20:10.708] prosqlbody = 0x0 [18:20:10.708] probin_str = 0x0 [18:20:10.708] prosrc_str = 0x834bb9078 "\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the question', detail=42);\nplpy.info('This is message te"... [18:20:10.708] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832be6500, pstmt=pstmt@entry=0x832c78e88, queryString=queryString@entry=0x832bd8100 "CREATE FUNCTION elog_test() RETURNS void\nAS $$\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the questi"..., context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:10.708] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35211076864, 35211641727, 10, 0, 549755813888}}} [18:20:10.708] _save_exception_stack = 0x820d739b0 [18:20:10.708] _save_context_stack = 0x0 [18:20:10.708] _do_rethrow = false [18:20:10.708] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:10.708] parsetree = 0x832c78f98 [18:20:10.708] commandCollected = false [18:20:10.708] needCleanup = false [18:20:10.708] address = [18:20:10.708] isTopLevel = [18:20:10.708] isCompleteQuery = [18:20:10.708] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832c78e88, queryString=0x832bd8100 "CREATE FUNCTION elog_test() RETURNS void\nAS $$\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the questi"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834bb9848, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:10.708] isAtomicContext = false [18:20:10.708] parsetree = 0x832c78f98 [18:20:10.708] readonly_flags = [18:20:10.708] pstate = 0x832be6500 [18:20:10.708] isTopLevel = [18:20:10.708] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18d7a, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x834bb9848, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:10.708] No locals. [18:20:10.708] #30 0x0000000000904073 in PortalRunUtility (portal=0x832caf100, pstmt=0x832c78e88, isTopLevel=, setHoldSnapshot=, dest=0x834bb9848, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:10.708] No locals. [18:20:10.708] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832caf100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x834bb9848, altdest=altdest@entry=0x834bb9848, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:10.708] pstmt = 0x832c78e88 [18:20:10.708] stmtlist_item__state = {l = 0x834bb97f8, i = 0} [18:20:10.708] active_snapshot_set = false [18:20:10.708] stmtlist_item = 0x834bb9810 [18:20:10.708] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832caf100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x834bb9848, altdest=altdest@entry=0x834bb9848, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:10.708] _local_sigjmp_buf = {{_sjb = {9449293, 35211899136, 34910714280, 34910714512, 34910714288, 35212374016, 12106024, 12139336, 35211903871, 35211674232, 4294967984, 0}}} [18:20:10.708] _save_exception_stack = 0x820d73b80 [18:20:10.708] _save_context_stack = 0x0 [18:20:10.708] _do_rethrow = false [18:20:10.708] saveTopTransactionResourceOwner = 0x832cb7660 [18:20:10.708] saveTopTransactionContext = 0x832d23000 [18:20:10.708] saveActivePortal = 0x0 [18:20:10.708] saveResourceOwner = 0x832cb7660 [18:20:10.708] savePortalContext = 0x0 [18:20:10.708] saveMemoryContext = 0x832d23000 [18:20:10.708] result = [18:20:10.708] nprocessed = [18:20:10.708] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "CREATE FUNCTION elog_test() RETURNS void\nAS $$\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the questi"...) at ../src/backend/tcop/postgres.c:1284 [18:20:10.708] cmdtaglen = 15 [18:20:10.708] snapshot_set = [18:20:10.708] per_parsetree_context = 0x0 [18:20:10.708] plantree_list = [18:20:10.708] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:10.708] format = 0 [18:20:10.708] parsetree = 0x832c77c58 [18:20:10.708] commandTag = [18:20:10.708] cmdtagname = [18:20:10.708] querytree_list = [18:20:10.708] portal = 0x832caf100 [18:20:10.708] receiver = 0x834bb9848 [18:20:10.708] parsetree_item__state = {l = 0x832c77fc8, i = 0} [18:20:10.708] msec_str = "\000\000\000\000\b", '\000' , "\020\001\326f\000\000\000\000H\247\024\354\270u\332G" [18:20:10.708] dest = DestRemote [18:20:10.708] was_logged = [18:20:10.708] oldcontext = 0x832d23000 [18:20:10.708] parsetree_list = 0x832c77fc8 [18:20:10.708] use_implicit_block = false [18:20:10.708] parsetree_item = 0x832c77fe0 [18:20:10.708] save_log_statement_stats = [18:20:10.708] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:10.708] query_string = 0x832bd8100 "CREATE FUNCTION elog_test() RETURNS void\nAS $$\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the questi"... [18:20:10.708] input_message = {data = 0x832bd8100 "CREATE FUNCTION elog_test() RETURNS void\nAS $$\nplpy.debug('debug', detail='some detail')\nplpy.log('log', detail='some detail')\nplpy.info('info', detail='some detail')\nplpy.info()\nplpy.info('the questi"..., len = 784, maxlen = 1024, cursor = 784} [18:20:10.708] firstchar = [18:20:10.708] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:10.708] send_ready_for_query = false [18:20:10.708] idle_in_transaction_timeout_enabled = false [18:20:10.708] idle_session_timeout_enabled = false [18:20:10.708] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:10.708] bsdata = [18:20:10.708] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:10.708] pid = [18:20:10.708] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:10.708] startup_data = {canAcceptConnections = CAC_OK} [18:20:10.708] bn = 0x832bd9f00 [18:20:10.708] pid = [18:20:10.708] __error = [18:20:10.708] save_errno = [18:20:10.708] __error = [18:20:10.708] __error = [18:20:10.708] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:10.708] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:10.708] i = 0 [18:20:10.708] now = [18:20:10.708] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:10.708] last_touch_time = 1725300997 [18:20:10.708] last_lockfile_recheck_time = 1725300997 [18:20:10.708] nevents = 1 [18:20:10.708] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:10.708] userDoption = [18:20:10.708] listen_addr_saved = [18:20:10.708] output_config_variable = [18:20:10.708] opt = [18:20:10.708] status = [18:20:10.708] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:10.708] do_check_root = [18:20:10.720] [18:20:10.720] [18:20:10.720] [18:20:10.793] dumping /tmp/cores/postgres.20846.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:10.919] [New LWP 101858] [18:20:10.998] Core was generated by `postgres: postgres regression_hstore_plpython [local] CREATE FUNCTION'. [18:20:10.998] Program terminated with signal SIGABRT, Aborted. [18:20:10.998] Sent by thr_kill() from pid 20846 and user 1003. [18:20:10.998] #0 0x000000082dc0141a in thr_kill () from /lib/libc.so.7 [18:20:11.587] To enable execution of this file add [18:20:11.587] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:11.587] line to your configuration file "/.config/gdb/gdbinit". [18:20:11.587] To completely disable this security protection add [18:20:11.587] set auto-load safe-path / [18:20:11.587] line to your configuration file "/.config/gdb/gdbinit". [18:20:11.587] For more information about this security protection see the [18:20:11.587] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:11.587] info "(gdb)Auto-loading safe path" [18:20:11.587] [18:20:11.587] Thread 1 (LWP 101858): [18:20:11.587] #0 0x000000082dc0141a in thr_kill () from /lib/libc.so.7 [18:20:11.587] No symbol table info available. [18:20:11.587] #1 0x000000082db7ae64 in raise () from /lib/libc.so.7 [18:20:11.587] No symbol table info available. [18:20:11.587] #2 0x000000082dc2b6f9 in abort () from /lib/libc.so.7 [18:20:11.587] No symbol table info available. [18:20:11.587] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x844350e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:11.587] No locals. [18:20:11.587] #4 0x000000084435a063 in PLy_generate_spi_exceptions (mod=0x84aff9a80, base=0x843523010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:11.587] dict = [18:20:11.587] found = true [18:20:11.587] sqlstate = [18:20:11.587] exc = 0x843575c10 [18:20:11.587] entry = 0x0 [18:20:11.587] i = 66 [18:20:11.587] #5 PLy_add_exceptions (plpy=0x848f4ac00) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:11.587] hash_ctl = {num_partitions = 35583020400, ssize = 7, dsize = 2, max_dsize = 34923874240, keysize = 4, entrysize = 16, hash = 0x848ee4d40, match = 0x848ee4d40, keycopy = 0x848f4d000, alloc = 0x848f420f0, hcxt = 0x847d5eac0 <_PyRuntime+166184>, hctl = 0x821a00810} [18:20:11.587] excmod = 0x84aff9a80 [18:20:11.587] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:11.587] m = 0x848f4ac00 [18:20:11.587] #7 0x0000000847b6af70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #8 0x0000000847b692e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #9 0x0000000847a89c29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #10 0x0000000847b33d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #11 0x0000000847b36795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #12 0x0000000847a3790f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #13 0x0000000847a37705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #14 0x0000000847b65284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #15 0x0000000847b1d996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #16 0x0000000847a89e70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #17 0x0000000847a36538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #18 0x0000000847a36467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #19 0x0000000847b64b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #20 0x0000000847b65ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:11.587] No symbol table info available. [18:20:11.587] #21 0x0000000844359476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:11.587] inited = false [18:20:11.587] #22 0x00000008443593a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:11.587] funcoid = 16522 [18:20:11.587] tuple = [18:20:11.587] is_trigger = [18:20:11.587] procStruct = [18:20:11.587] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x821a00f98, collation=0, arg1=16522) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:11.587] fcinfodata = {fcinfo = {flinfo = 0x821a00f98, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x821a00fe8}, fcinfo_data = "\230\017\240!\b", '\000' , "\001\000\212@", '\000' } [18:20:11.587] fcinfo = 0x821a00fc8 [18:20:11.587] result = [18:20:11.587] __error = [18:20:11.587] #24 OidFunctionCall1Coll (functionId=functionId@entry=16516, collation=collation@entry=0, arg1=arg1@entry=16522) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:11.587] flinfo = {fn_addr = 0x844359370 , fn_oid = 16516, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x83784a400, fn_expr = 0x0} [18:20:11.587] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x83798df40 "test1", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=23, proowner=10, languageObjectId=16517, languageValidator=16516, prosrc=0x84343fe08 "\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x837887c18, allParameterTypes=0, parameterModes=0, parameterNames=35291429960, parameterDefaults=0x0, trftypes=35291430144, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:11.587] set_items = [18:20:11.587] save_nestlevel = 0 [18:20:11.587] myself = {classId = 1255, objectId = 16522, objectSubId = 0} [18:20:11.587] nulls = {false , true, true, false, true, false, false, true, true, true, true} [18:20:11.587] values = {16522, 34923876384, 2200, 10, 16517, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 1, 0, 23, 35291429912, 0, 0, 35291429960, 0, 35291430144, 35291178864, 0, 0, 0, 0} [18:20:11.587] replaces = {true } [18:20:11.587] procname = {data = "test1", '\000' } [18:20:11.587] referenced = {classId = 3576, objectId = 16521, objectSubId = 0} [18:20:11.587] paramModes = [18:20:11.587] variadicType = [18:20:11.587] proacl = 0x0 [18:20:11.587] parameterCount = [18:20:11.587] allParamCount = 1 [18:20:11.587] allParams = 0x837887c30 [18:20:11.587] detailmsg = [18:20:11.587] i = [18:20:11.587] rel = 0x837967cc8 [18:20:11.587] tupDesc = 0x837967ed8 [18:20:11.587] oldtup = 0x0 [18:20:11.587] tup = 0x8379d2838 [18:20:11.587] is_update = [18:20:11.587] retval = 16522 [18:20:11.587] addrs = [18:20:11.587] trfid = [18:20:11.587] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x83784a500, stmt=, stmt@entry=0x83798def0) at ../src/backend/commands/functioncmds.c:1257 [18:20:11.587] funcname = 0x83798df40 "test1" [18:20:11.587] parameterTypes = 0x837887c18 [18:20:11.587] parameterTypes_list = 0x8379d2ba8 [18:20:11.587] allParameterTypes = 0x0 [18:20:11.587] parameterModes = 0x0 [18:20:11.587] parameterNames = 0x837887c48 [18:20:11.587] inParameterNames_list = 0x837887bc8 [18:20:11.587] parameterDefaults = 0x0 [18:20:11.587] variadicArgType = 0 [18:20:11.587] requiredResultType = 0 [18:20:11.587] transformDefElem = [18:20:11.587] trftypes_list = [18:20:11.587] namespaceId = 2200 [18:20:11.587] aclresult = [18:20:11.587] as_clause = [18:20:11.587] language = [18:20:11.587] isWindowFunc = false [18:20:11.587] isStrict = false [18:20:11.587] security = false [18:20:11.587] isLeakProof = [18:20:11.587] volatility = 118 'v' [18:20:11.587] proconfig = 0x0 [18:20:11.587] procost = 100 [18:20:11.587] prorows = 0 [18:20:11.587] prosupport = 0 [18:20:11.587] parallel = 117 'u' [18:20:11.587] languageTuple = [18:20:11.587] languageStruct = [18:20:11.587] languageOid = 16517 [18:20:11.587] languageValidator = 16516 [18:20:11.587] prorettype = 23 [18:20:11.587] returnsSet = false [18:20:11.587] trftypes = 0x837887d00 [18:20:11.587] prosqlbody = 0x0 [18:20:11.587] probin_str = 0x0 [18:20:11.587] prosrc_str = 0x84343fe08 "\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n" [18:20:11.587] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x83784a500, pstmt=pstmt@entry=0x83798c780, queryString=queryString@entry=0x83783c100 "CREATE FUNCTION test1(val hstore) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE hstore\nAS $$\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n$$;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821a017e0) at ../src/backend/tcop/utility.c:1655 [18:20:11.587] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34923877384, 34923877760, 34923877392, 12139336, 0, 35291178240, 35292447615, 10, 0, 549755813888}}} [18:20:11.587] _save_exception_stack = 0x821a016e0 [18:20:11.587] _save_context_stack = 0x0 [18:20:11.587] _do_rethrow = false [18:20:11.587] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:11.587] parsetree = 0x83798def0 [18:20:11.587] commandCollected = false [18:20:11.587] needCleanup = false [18:20:11.587] address = [18:20:11.587] isTopLevel = [18:20:11.587] isCompleteQuery = [18:20:11.587] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x83798c780, queryString=0x83783c100 "CREATE FUNCTION test1(val hstore) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE hstore\nAS $$\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n$$;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x84343ffa8, qc=0x821a017e0) at ../src/backend/tcop/utility.c:1030 [18:20:11.587] isAtomicContext = false [18:20:11.587] parsetree = 0x83798def0 [18:20:11.587] readonly_flags = [18:20:11.587] pstate = 0x83784a500 [18:20:11.587] isTopLevel = [18:20:11.587] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18de2, queryString=0x6 , readOnlyTree=, context=767562746, params=0x0, queryEnv=0x0, dest=0x84343ffa8, qc=0x821a017e0) at ../src/backend/tcop/utility.c:523 [18:20:11.587] No locals. [18:20:11.587] #30 0x0000000000904073 in PortalRunUtility (portal=0x837911100, pstmt=0x83798c780, isTopLevel=, setHoldSnapshot=, dest=0x84343ffa8, qc=0x821a017e0) at ../src/backend/tcop/pquery.c:1158 [18:20:11.587] No locals. [18:20:11.587] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x837911100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x84343ffa8, altdest=altdest@entry=0x84343ffa8, qc=0x821a017e0) at ../src/backend/tcop/pquery.c:1323 [18:20:11.587] pstmt = 0x83798c780 [18:20:11.587] stmtlist_item__state = {l = 0x84343ff58, i = 0} [18:20:11.587] active_snapshot_set = false [18:20:11.587] stmtlist_item = 0x84343ff70 [18:20:11.587] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x837911100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x84343ffa8, altdest=altdest@entry=0x84343ffa8, qc=0x821a017e0) at ../src/backend/tcop/pquery.c:791 [18:20:11.587] _local_sigjmp_buf = {{_sjb = {9449293, 35291992320, 34923878104, 34923878336, 34923878112, 35292008448, 12106024, 12139336, 35291988863, 35292498672, 4294967984, 0}}} [18:20:11.587] _save_exception_stack = 0x821a018b0 [18:20:11.587] _save_context_stack = 0x0 [18:20:11.587] _do_rethrow = false [18:20:11.587] saveTopTransactionResourceOwner = 0x83791dcd8 [18:20:11.587] saveTopTransactionContext = 0x837915000 [18:20:11.587] saveActivePortal = 0x0 [18:20:11.587] saveResourceOwner = 0x83791dcd8 [18:20:11.587] savePortalContext = 0x0 [18:20:11.587] saveMemoryContext = 0x837915000 [18:20:11.587] result = [18:20:11.587] nprocessed = [18:20:11.587] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x83783c100 "CREATE FUNCTION test1(val hstore) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE hstore\nAS $$\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n$$;") at ../src/backend/tcop/postgres.c:1284 [18:20:11.587] cmdtaglen = 15 [18:20:11.587] snapshot_set = [18:20:11.587] per_parsetree_context = 0x0 [18:20:11.587] plantree_list = [18:20:11.587] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:11.587] format = 0 [18:20:11.587] parsetree = 0x83783df28 [18:20:11.587] commandTag = [18:20:11.587] cmdtagname = [18:20:11.587] querytree_list = [18:20:11.587] portal = 0x837911100 [18:20:11.587] receiver = 0x84343ffa8 [18:20:11.587] parsetree_item__state = {l = 0x83798c730, i = 0} [18:20:11.587] msec_str = "\000\000\000\000\b", '\000' , "\021\001\326f\000\000\000\000\000\033P\317\316u\\\037" [18:20:11.587] dest = DestRemote [18:20:11.587] was_logged = [18:20:11.587] oldcontext = 0x837915000 [18:20:11.587] parsetree_list = 0x83798c730 [18:20:11.587] use_implicit_block = false [18:20:11.587] parsetree_item = 0x83798c748 [18:20:11.587] save_log_statement_stats = [18:20:11.587] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:11.587] query_string = 0x83783c100 "CREATE FUNCTION test1(val hstore) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE hstore\nAS $$\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n$$;" [18:20:11.587] input_message = {data = 0x83783c100 "CREATE FUNCTION test1(val hstore) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE hstore\nAS $$\nassert isinstance(val, dict)\nplpy.info(sorted(val.items()))\nreturn len(val)\n$$;", len = 178, maxlen = 1024, cursor = 178} [18:20:11.587] firstchar = [18:20:11.587] local_sigjmp_buf = {{_sjb = {9433206, 34923878576, 34923878536, 34923879120, 12148072, 1, 8192, 8388608, 34923873151, 0, 0, 1}}} [18:20:11.587] send_ready_for_query = false [18:20:11.587] idle_in_transaction_timeout_enabled = false [18:20:11.587] idle_session_timeout_enabled = false [18:20:11.587] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:11.587] bsdata = [18:20:11.587] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a025f4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a02530) at ../src/backend/postmaster/launch_backend.c:274 [18:20:11.587] pid = [18:20:11.587] #37 0x0000000000858958 in BackendStartup (client_sock=0x821a02530) at ../src/backend/postmaster/postmaster.c:3414 [18:20:11.587] startup_data = {canAcceptConnections = CAC_OK} [18:20:11.587] bn = 0x837848088 [18:20:11.587] pid = [18:20:11.587] __error = [18:20:11.587] save_errno = [18:20:11.587] __error = [18:20:11.587] __error = [18:20:11.587] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:11.587] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000߃7\b", '\000' , "\220%\240!\b\000\000\000h\325\024+\b\000\000\000\v\000\000\000\000\000\000\000^_\025+\b", '\000' , "\320%\240!\b\000\000\000DC\205\000\000\000\000\000\340%\240!\b", '\000' }, salen = 16}} [18:20:11.587] i = 0 [18:20:11.587] now = [18:20:11.587] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 767188098, events = 8, fd = 0, user_data = 0x821a024e0}, {pos = 931751384, events = 8, fd = 564142960, user_data = 0x0}, {pos = 0, events = 0, fd = -213216230, user_data = 0x134a1958130a}, {pos = 766355360, events = 8, fd = 766426488, user_data = 0x821a01ff8}, {pos = 564142192, events = 8, fd = 564142072, user_data = 0x134a1958130a}, {pos = 766333832, events = 8, fd = 766426488, user_data = 0x821a02028}, {pos = 564142240, events = 8, fd = 564142120, user_data = 0x82dae4194}, {pos = 575927304, events = 8, fd = 766394772, user_data = 0x821a02090}, {pos = 425182266, events = 4938, fd = 768217136, user_data = 0x1}, {pos = 564142272, events = 8, fd = 425202442, user_data = 0x82dacd858}, {pos = 766426488, events = 8, fd = 564142232, user_data = 0x821a02110}, {pos = 564142232, events = 8, fd = 766389516, user_data = 0x82253f408}, {pos = 766389516, events = 8, fd = 564142336, user_data = 0x134a1957c43a}, {pos = 564142376, events = 8, fd = 564142824, user_data = 0x821a02110}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 3915211650, fd = 575950904, user_data = 0x800000001}, {pos = 575927304, events = 8, fd = 766333832, user_data = 0x822544288}, {pos = 766302296, events = 8, fd = 575927304, user_data = 0x821a02198}, {pos = 564142936, events = 8, fd = 564142464, user_data = 0x134a19580ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 575950904, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564143192, user_data = 0x2253f408}, {pos = 564143008, events = 8, fd = 564142608, user_data = 0x1}, {pos = 564142936, events = 8, fd = 32, user_data = 0x821a02200}, {pos = 425200243, events = 4938, fd = 564142880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x822545038}, {pos = 1, events = 8, fd = 575927304, user_data = 0x82dacd858}, {pos = 564143192, events = 8, fd = 564143008, user_data = 0x821a02210}, {pos = 0, events = 0, fd = 575897608, user_data = 0x20}, {pos = 564142992, events = 8, fd = 425175783, user_data = 0x822538008}, {pos = 575898632, events = 8, fd = 575899656, user_data = 0x822538c08}, {pos = 575913992, events = 8, fd = 575915016, user_data = 0x82253c808}, {pos = 575917064, events = 8, fd = 575918088, user_data = 0x82253d408}, {pos = 575920136, events = 8, fd = 575921160, user_data = 0x82253e008}, {pos = 575923208, events = 8, fd = 575924232, user_data = 0x82253ec08}, {pos = 575926280, events = 8, fd = 575927304, user_data = 0x82253f808}, {pos = 575929352, events = 8, fd = 575930376, user_data = 0x822540408}, {pos = 575932424, events = 8, fd = 575933448, user_data = 0x822541008}, {pos = 575935496, events = 8, fd = 575936520, user_data = 0x822541c08}, {pos = 575942664, events = 8, fd = 575943688, user_data = 0x822543808}, {pos = 575945736, events = 8, fd = 575897608, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x822545038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564143192, events = 8, fd = 564142608, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 575950904, user_data = 0x1}, {pos = 575897608, events = 8, fd = 313, user_data = 0x821a02440}, {pos = 425174511, events = 4938, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 575950904, user_data = 0x1}, {pos = 575927304, events = 8, fd = 931315712, user_data = 0x1}, {pos = 931316116, events = 8, fd = 0, user_data = 0x821a02410}, {pos = 722818412, events = 8, fd = 1, user_data = 0x83782c000}, {pos = 564143168, events = 8, fd = 722814722, user_data = 0x82dbff170 }, {pos = 12073120, events = 0, fd = 767553904, user_data = 0x82253f408}, {pos = 564143392, events = 8, fd = 425173982, user_data = 0x83784a800}, {pos = 1, events = 0, fd = 425173598, user_data = 0x822538008}, {pos = 564143176, events = 8, fd = 564143392, user_data = 0x1c20}, {pos = 931389184, events = 8, fd = 425253264, user_data = 0x0}, {pos = 564134783, events = 8, fd = 7886519, user_data = 0x821a024d0}, {pos = 722777104, events = 8, fd = 768217136, user_data = 0x82dca3310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a02500}, {pos = 722819997, events = 8, fd = 931315712, user_data = 0x5160}, {pos = 564143456, events = 8, fd = 722786554, user_data = 0x0}, {pos = 0, events = 0, fd = -213216230, user_data = 0x0}} [18:20:11.587] last_touch_time = 1725301008 [18:20:11.587] last_lockfile_recheck_time = 1725301008 [18:20:11.587] nevents = 1 [18:20:11.587] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a02b40) at ../src/backend/postmaster/postmaster.c:1346 [18:20:11.587] userDoption = [18:20:11.587] listen_addr_saved = [18:20:11.587] output_config_variable = [18:20:11.587] opt = [18:20:11.587] status = [18:20:11.587] #40 0x000000000079239c in main (argc=8, argv=0x821a02b40) at ../src/backend/main/main.c:197 [18:20:11.587] do_check_root = [18:20:11.599] [18:20:11.599] [18:20:11.599] [18:20:11.665] dumping /tmp/cores/postgres.20912.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:11.785] [New LWP 101811] [18:20:11.864] Core was generated by `postgres: postgres regression_jsonb_plpython [local] CREATE FUNCTION'. [18:20:11.864] Program terminated with signal SIGABRT, Aborted. [18:20:11.864] Sent by thr_kill() from pid 20912 and user 1003. [18:20:11.864] #0 0x00000008297ed41a in thr_kill () from /lib/libc.so.7 [18:20:12.452] To enable execution of this file add [18:20:12.452] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:12.452] line to your configuration file "/.config/gdb/gdbinit". [18:20:12.452] To completely disable this security protection add [18:20:12.452] set auto-load safe-path / [18:20:12.452] line to your configuration file "/.config/gdb/gdbinit". [18:20:12.452] For more information about this security protection see the [18:20:12.452] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:12.452] info "(gdb)Auto-loading safe path" [18:20:12.452] [18:20:12.452] Thread 1 (LWP 101811): [18:20:12.452] #0 0x00000008297ed41a in thr_kill () from /lib/libc.so.7 [18:20:12.452] No symbol table info available. [18:20:12.452] #1 0x0000000829766e64 in raise () from /lib/libc.so.7 [18:20:12.452] No symbol table info available. [18:20:12.452] #2 0x00000008298176f9 in abort () from /lib/libc.so.7 [18:20:12.452] No symbol table info available. [18:20:12.452] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x836d45e44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:12.452] No locals. [18:20:12.452] #4 0x0000000836d4f063 in PLy_generate_spi_exceptions (mod=0x844d21a30, base=0x836122010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:12.452] dict = [18:20:12.452] found = true [18:20:12.452] sqlstate = [18:20:12.452] exc = 0x836174c10 [18:20:12.452] entry = 0x0 [18:20:12.452] i = 66 [18:20:12.452] #5 PLy_add_exceptions (plpy=0x843e86bb0) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:12.452] hash_ctl = {num_partitions = 35498331504, ssize = 7, dsize = 2, max_dsize = 34910391680, keysize = 4, entrysize = 16, hash = 0x843e20d40, match = 0x843e20d40, keycopy = 0x844d09040, alloc = 0x843e7e130, hcxt = 0x842271ac0 <_PyRuntime+166184>, hctl = 0x820d24dd0} [18:20:12.452] excmod = 0x844d21a30 [18:20:12.452] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:12.452] m = 0x843e86bb0 [18:20:12.452] #7 0x000000084207df70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #8 0x000000084207c2e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #9 0x0000000841f9cc29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #10 0x0000000842046d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #11 0x0000000842049795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #12 0x0000000841f4a90f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #13 0x0000000841f4a705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #14 0x0000000842078284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #15 0x0000000842030996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #16 0x0000000841f9ce70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #17 0x0000000841f49538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #18 0x0000000841f49467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #19 0x0000000842077b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #20 0x0000000842078ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:12.452] No symbol table info available. [18:20:12.452] #21 0x0000000836d4e476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:12.452] inited = false [18:20:12.452] #22 0x0000000836d4e3a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:12.452] funcoid = 16394 [18:20:12.452] tuple = [18:20:12.452] is_trigger = [18:20:12.452] procStruct = [18:20:12.452] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d25558, collation=0, arg1=16394) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:12.452] fcinfodata = {fcinfo = {flinfo = 0x820d25558, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d255a8}, fcinfo_data = "XU\322 \b", '\000' , "\001\000\n@", '\000' } [18:20:12.452] fcinfo = 0x820d25588 [18:20:12.452] result = [18:20:12.452] __error = [18:20:12.452] #24 OidFunctionCall1Coll (functionId=functionId@entry=16388, collation=collation@entry=0, arg1=arg1@entry=16394) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:12.452] flinfo = {fn_addr = 0x836d4e370 , fn_oid = 16388, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x833b3d400, fn_expr = 0x0} [18:20:12.452] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x833c80f40 "test1", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=23, proowner=10, languageObjectId=16389, languageValidator=16388, prosrc=0x836040188 "\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x833b7ac18, allParameterTypes=0, parameterModes=0, parameterNames=35227413576, parameterDefaults=0x0, trftypes=35227413760, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:12.452] set_items = [18:20:12.452] save_nestlevel = 0 [18:20:12.452] myself = {classId = 1255, objectId = 16394, objectSubId = 0} [18:20:12.452] nulls = {false , true, true, false, true, false, false, true, true, true, true} [18:20:12.452] values = {16394, 34910393824, 2200, 10, 16389, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 1, 0, 23, 35227413528, 0, 0, 35227413576, 0, 35227413760, 35227162480, 0, 0, 0, 0} [18:20:12.452] replaces = {true } [18:20:12.452] procname = {data = "test1", '\000' } [18:20:12.452] referenced = {classId = 3576, objectId = 16393, objectSubId = 0} [18:20:12.452] paramModes = [18:20:12.452] variadicType = [18:20:12.452] proacl = 0x0 [18:20:12.452] parameterCount = [18:20:12.452] allParamCount = 1 [18:20:12.452] allParams = 0x833b7ac30 [18:20:12.452] detailmsg = [18:20:12.452] i = [18:20:12.452] rel = 0x833c5a718 [18:20:12.452] tupDesc = 0x833c5aa38 [18:20:12.452] oldtup = 0x0 [18:20:12.452] tup = 0x833cc5c38 [18:20:12.452] is_update = [18:20:12.452] retval = 16394 [18:20:12.452] addrs = [18:20:12.452] trfid = [18:20:12.452] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x833b3d500, stmt=, stmt@entry=0x833c80ef0) at ../src/backend/commands/functioncmds.c:1257 [18:20:12.452] funcname = 0x833c80f40 "test1" [18:20:12.452] parameterTypes = 0x833b7ac18 [18:20:12.452] parameterTypes_list = 0x833cc5fa8 [18:20:12.452] allParameterTypes = 0x0 [18:20:12.452] parameterModes = 0x0 [18:20:12.452] parameterNames = 0x833b7ac48 [18:20:12.452] inParameterNames_list = 0x833b7abc8 [18:20:12.452] parameterDefaults = 0x0 [18:20:12.452] variadicArgType = 0 [18:20:12.452] requiredResultType = 0 [18:20:12.452] transformDefElem = [18:20:12.452] trftypes_list = [18:20:12.452] namespaceId = 2200 [18:20:12.452] aclresult = [18:20:12.452] as_clause = [18:20:12.452] language = [18:20:12.452] isWindowFunc = false [18:20:12.452] isStrict = false [18:20:12.452] security = false [18:20:12.452] isLeakProof = [18:20:12.452] volatility = 118 'v' [18:20:12.452] proconfig = 0x0 [18:20:12.452] procost = 100 [18:20:12.452] prorows = 0 [18:20:12.452] prosupport = 0 [18:20:12.452] parallel = 117 'u' [18:20:12.452] languageTuple = [18:20:12.452] languageStruct = [18:20:12.452] languageOid = 16389 [18:20:12.452] languageValidator = 16388 [18:20:12.452] prorettype = 23 [18:20:12.452] returnsSet = false [18:20:12.452] trftypes = 0x833b7ad00 [18:20:12.452] prosqlbody = 0x0 [18:20:12.452] probin_str = 0x0 [18:20:12.452] prosrc_str = 0x836040188 "\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n" [18:20:12.452] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x833b3d500, pstmt=pstmt@entry=0x833c7f780, queryString=queryString@entry=0x833b2f100 "CREATE FUNCTION test1(val jsonb) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE jsonb\nAS $$\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n$$;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d25da0) at ../src/backend/tcop/utility.c:1655 [18:20:12.452] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910394824, 34910395200, 34910394832, 12139336, 0, 35227161856, 35228484479, 10, 0, 549755813888}}} [18:20:12.452] _save_exception_stack = 0x820d25ca0 [18:20:12.452] _save_context_stack = 0x0 [18:20:12.452] _do_rethrow = false [18:20:12.452] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:12.452] parsetree = 0x833c80ef0 [18:20:12.452] commandCollected = false [18:20:12.452] needCleanup = false [18:20:12.452] address = [18:20:12.452] isTopLevel = [18:20:12.452] isCompleteQuery = [18:20:12.452] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x833c7f780, queryString=0x833b2f100 "CREATE FUNCTION test1(val jsonb) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE jsonb\nAS $$\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n$$;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x836040328, qc=0x820d25da0) at ../src/backend/tcop/utility.c:1030 [18:20:12.452] isAtomicContext = false [18:20:12.452] parsetree = 0x833c80ef0 [18:20:12.452] readonly_flags = [18:20:12.452] pstate = 0x833b3d500 [18:20:12.452] isTopLevel = [18:20:12.452] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18db3, queryString=0x6 , readOnlyTree=, context=696177658, params=0x0, queryEnv=0x0, dest=0x836040328, qc=0x820d25da0) at ../src/backend/tcop/utility.c:523 [18:20:12.452] No locals. [18:20:12.452] #30 0x0000000000904073 in PortalRunUtility (portal=0x833c04100, pstmt=0x833c7f780, isTopLevel=, setHoldSnapshot=, dest=0x836040328, qc=0x820d25da0) at ../src/backend/tcop/pquery.c:1158 [18:20:12.452] No locals. [18:20:12.452] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x833c04100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x836040328, altdest=altdest@entry=0x836040328, qc=0x820d25da0) at ../src/backend/tcop/pquery.c:1323 [18:20:12.452] pstmt = 0x833c7f780 [18:20:12.452] stmtlist_item__state = {l = 0x8360402d8, i = 0} [18:20:12.452] active_snapshot_set = false [18:20:12.452] stmtlist_item = 0x8360402f0 [18:20:12.452] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x833c04100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x836040328, altdest=altdest@entry=0x836040328, qc=0x820d25da0) at ../src/backend/tcop/pquery.c:791 [18:20:12.452] _local_sigjmp_buf = {{_sjb = {9449293, 35227975936, 34910395544, 34910395776, 34910395552, 35227992064, 12106024, 12139336, 35227960191, 35228482288, 4294967984, 0}}} [18:20:12.452] _save_exception_stack = 0x820d25e70 [18:20:12.452] _save_context_stack = 0x0 [18:20:12.452] _do_rethrow = false [18:20:12.452] saveTopTransactionResourceOwner = 0x833c10f18 [18:20:12.452] saveTopTransactionContext = 0x833c08000 [18:20:12.452] saveActivePortal = 0x0 [18:20:12.452] saveResourceOwner = 0x833c10f18 [18:20:12.452] savePortalContext = 0x0 [18:20:12.452] saveMemoryContext = 0x833c08000 [18:20:12.452] result = [18:20:12.452] nprocessed = [18:20:12.452] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x833b2f100 "CREATE FUNCTION test1(val jsonb) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE jsonb\nAS $$\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n$$;") at ../src/backend/tcop/postgres.c:1284 [18:20:12.452] cmdtaglen = 15 [18:20:12.452] snapshot_set = [18:20:12.452] per_parsetree_context = 0x0 [18:20:12.452] plantree_list = [18:20:12.452] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:12.452] format = 0 [18:20:12.452] parsetree = 0x833b30f28 [18:20:12.452] commandTag = [18:20:12.452] cmdtagname = [18:20:12.452] querytree_list = [18:20:12.452] portal = 0x833c04100 [18:20:12.452] receiver = 0x836040328 [18:20:12.452] parsetree_item__state = {l = 0x833c7f730, i = 0} [18:20:12.452] msec_str = "\000\000\000\000\b", '\000' , "\022\001\326f\000\000\000\0006\231\321\371\241\205 h" [18:20:12.452] dest = DestRemote [18:20:12.452] was_logged = [18:20:12.452] oldcontext = 0x833c08000 [18:20:12.452] parsetree_list = 0x833c7f730 [18:20:12.452] use_implicit_block = false [18:20:12.452] parsetree_item = 0x833c7f748 [18:20:12.452] save_log_statement_stats = [18:20:12.452] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:12.452] query_string = 0x833b2f100 "CREATE FUNCTION test1(val jsonb) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE jsonb\nAS $$\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n$$;" [18:20:12.452] input_message = {data = 0x833b2f100 "CREATE FUNCTION test1(val jsonb) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE jsonb\nAS $$\nassert isinstance(val, dict)\nassert(val == {'a': 1, 'c': 'NULL'})\nreturn len(val)\n$$;", len = 182, maxlen = 1024, cursor = 182} [18:20:12.452] firstchar = [18:20:12.452] local_sigjmp_buf = {{_sjb = {9433206, 34910396016, 34910395976, 34910396560, 12148072, 1, 8192, 8388608, 34910372735, 0, 0, 1}}} [18:20:12.452] send_ready_for_query = false [18:20:12.452] idle_in_transaction_timeout_enabled = false [18:20:12.452] idle_session_timeout_enabled = false [18:20:12.452] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:12.452] bsdata = [18:20:12.452] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d26bb4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d26af0) at ../src/backend/postmaster/launch_backend.c:274 [18:20:12.452] pid = [18:20:12.452] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d26af0) at ../src/backend/postmaster/postmaster.c:3414 [18:20:12.452] startup_data = {canAcceptConnections = CAC_OK} [18:20:12.452] bn = 0x833b3b088 [18:20:12.452] pid = [18:20:12.452] __error = [18:20:12.452] save_errno = [18:20:12.452] __error = [18:20:12.452] __error = [18:20:12.452] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:12.452] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\017\2633\b", '\000' , "Pk\322 \b\000\000\000hu\253(\b\000\000\000\v\000\000\000\000\000\000\000^\377\253(\b", '\000' , "\220k\322 \b\000\000\000DC\205\000\000\000\000\000\240k\322 \b", '\000' }, salen = 16}} [18:20:12.452] i = 0 [18:20:12.452] now = [18:20:12.452] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 695803010, events = 8, fd = 0, user_data = 0x820d26aa0}, {pos = 867735000, events = 8, fd = 550660400, user_data = 0x0}, {pos = 0, events = 0, fd = 820786251, user_data = 0x3c0069e230a}, {pos = 694970272, events = 8, fd = 695041400, user_data = 0x820d265b8}, {pos = 550659632, events = 8, fd = 550659512, user_data = 0x3c0069e230a}, {pos = 694948744, events = 8, fd = 695041400, user_data = 0x820d265e8}, {pos = 550659680, events = 8, fd = 550659560, user_data = 0x8296d0194}, {pos = 565748744, events = 8, fd = 695009684, user_data = 0x820d26650}, {pos = 111006778, events = 960, fd = 696832048, user_data = 0x1}, {pos = 550659712, events = 8, fd = 111026954, user_data = 0x8296b9858}, {pos = 695041400, events = 8, fd = 550659672, user_data = 0x820d266d0}, {pos = 550659672, events = 8, fd = 695004428, user_data = 0x821b8a408}, {pos = 695004428, events = 8, fd = 550659776, user_data = 0x3c0069dd43a}, {pos = 550659816, events = 8, fd = 550660264, user_data = 0x820d266d0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1801671119, fd = 565772344, user_data = 0x800000001}, {pos = 565748744, events = 8, fd = 694948744, user_data = 0x821b8f288}, {pos = 694917208, events = 8, fd = 565748744, user_data = 0x820d26758}, {pos = 550660376, events = 8, fd = 550659904, user_data = 0x3c0069e1ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 565772344, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550660632, user_data = 0x21b8a408}, {pos = 550660448, events = 8, fd = 550660048, user_data = 0x1}, {pos = 550660376, events = 8, fd = 32, user_data = 0x820d267c0}, {pos = 111024755, events = 960, fd = 550660320, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821b90038}, {pos = 1, events = 8, fd = 565748744, user_data = 0x8296b9858}, {pos = 550660632, events = 8, fd = 550660448, user_data = 0x820d267d0}, {pos = 0, events = 0, fd = 565719048, user_data = 0x20}, {pos = 550660432, events = 8, fd = 111000295, user_data = 0x821b83008}, {pos = 565720072, events = 8, fd = 565721096, user_data = 0x821b83c08}, {pos = 565735432, events = 8, fd = 565736456, user_data = 0x821b87808}, {pos = 565738504, events = 8, fd = 565739528, user_data = 0x821b88408}, {pos = 565741576, events = 8, fd = 565742600, user_data = 0x821b89008}, {pos = 565744648, events = 8, fd = 565745672, user_data = 0x821b89c08}, {pos = 565747720, events = 8, fd = 565748744, user_data = 0x821b8a808}, {pos = 565750792, events = 8, fd = 565751816, user_data = 0x821b8b408}, {pos = 565753864, events = 8, fd = 565754888, user_data = 0x821b8c008}, {pos = 565756936, events = 8, fd = 565757960, user_data = 0x821b8cc08}, {pos = 565764104, events = 8, fd = 565765128, user_data = 0x821b8e808}, {pos = 565767176, events = 8, fd = 565719048, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821b90038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550660632, events = 8, fd = 550660048, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 565772344, user_data = 0x1}, {pos = 565719048, events = 8, fd = 313, user_data = 0x820d26a00}, {pos = 110999023, events = 960, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 565772344, user_data = 0x1}, {pos = 565748744, events = 8, fd = 867299328, user_data = 0x1}, {pos = 867299732, events = 8, fd = 0, user_data = 0x820d269d0}, {pos = 682358124, events = 8, fd = 1, user_data = 0x833b1f000}, {pos = 550660608, events = 8, fd = 682354434, user_data = 0x8297eb170 }, {pos = 12073120, events = 0, fd = 696168816, user_data = 0x821b8a408}, {pos = 550660832, events = 8, fd = 110998494, user_data = 0x833b3d800}, {pos = 1, events = 0, fd = 110998110, user_data = 0x821b83008}, {pos = 550660616, events = 8, fd = 550660832, user_data = 0x1c20}, {pos = 867372800, events = 8, fd = 111077776, user_data = 0x0}, {pos = 550634367, events = 8, fd = 7886519, user_data = 0x820d26a90}, {pos = 682316816, events = 8, fd = 696832048, user_data = 0x82988f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d26ac0}, {pos = 682359709, events = 8, fd = 867299328, user_data = 0x51a2}, {pos = 550660896, events = 8, fd = 682326266, user_data = 0x0}, {pos = 0, events = 0, fd = 820786251, user_data = 0x0}} [18:20:12.452] last_touch_time = 1725301010 [18:20:12.452] last_lockfile_recheck_time = 1725301010 [18:20:12.452] nevents = 1 [18:20:12.452] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d27108) at ../src/backend/postmaster/postmaster.c:1346 [18:20:12.452] userDoption = [18:20:12.452] listen_addr_saved = [18:20:12.452] output_config_variable = [18:20:12.452] opt = [18:20:12.452] status = [18:20:12.452] #40 0x000000000079239c in main (argc=8, argv=0x820d27108) at ../src/backend/main/main.c:197 [18:20:12.452] do_check_root = [18:20:12.467] [18:20:12.467] [18:20:12.467] [18:20:12.537] dumping /tmp/cores/postgres.20982.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:12.663] [New LWP 101750] [18:20:12.740] Core was generated by `postgres: postgres regression_plpython [local] CREATE PROCEDURE'. [18:20:12.740] Program terminated with signal SIGABRT, Aborted. [18:20:12.740] Sent by thr_kill() from pid 20982 and user 1003. [18:20:12.740] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:13.327] To enable execution of this file add [18:20:13.327] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:13.327] line to your configuration file "/.config/gdb/gdbinit". [18:20:13.327] To completely disable this security protection add [18:20:13.327] set auto-load safe-path / [18:20:13.327] line to your configuration file "/.config/gdb/gdbinit". [18:20:13.327] For more information about this security protection see the [18:20:13.327] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:13.327] info "(gdb)Auto-loading safe path" [18:20:13.327] [18:20:13.327] Thread 1 (LWP 101750): [18:20:13.327] #0 0x000000082a8ed41a in thr_kill () from /lib/libc.so.7 [18:20:13.327] No symbol table info available. [18:20:13.327] #1 0x000000082a866e64 in raise () from /lib/libc.so.7 [18:20:13.327] No symbol table info available. [18:20:13.327] #2 0x000000082a9176f9 in abort () from /lib/libc.so.7 [18:20:13.327] No symbol table info available. [18:20:13.327] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x8358fbe44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:13.327] No locals. [18:20:13.327] #4 0x0000000835905063 in PLy_generate_spi_exceptions (mod=0x8450bdad0, base=0x8348e4010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:13.327] dict = [18:20:13.327] found = true [18:20:13.327] sqlstate = [18:20:13.327] exc = 0x8348f4c10 [18:20:13.327] entry = 0x0 [18:20:13.327] i = 66 [18:20:13.327] #5 PLy_add_exceptions (plpy=0x844692c50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:13.327] hash_ctl = {num_partitions = 35506769264, ssize = 7, dsize = 2, max_dsize = 34910710416, keysize = 4, entrysize = 16, hash = 0x84462cd40, match = 0x84462cd40, keycopy = 0x8450a5000, alloc = 0x84468a0f0, hcxt = 0x840911ac0 <_PyRuntime+166184>, hctl = 0x820d72ae0} [18:20:13.327] excmod = 0x8450bdad0 [18:20:13.327] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:13.327] m = 0x844692c50 [18:20:13.327] #7 0x000000084071df70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #8 0x000000084071c2e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #9 0x000000084063cc29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #10 0x00000008406e6d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #11 0x00000008406e9795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #12 0x00000008405ea90f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #13 0x00000008405ea705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #14 0x0000000840718284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #15 0x00000008406d0996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #16 0x000000084063ce70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #17 0x00000008405e9538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #18 0x00000008405e9467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #19 0x0000000840717b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #20 0x0000000840718ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:13.327] No symbol table info available. [18:20:13.327] #21 0x0000000835904476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:13.327] inited = false [18:20:13.327] #22 0x00000008359043a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:13.327] funcoid = 57349 [18:20:13.327] tuple = [18:20:13.327] is_trigger = [18:20:13.327] procStruct = [18:20:13.327] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x820d73268, collation=0, arg1=57349) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:13.327] fcinfodata = {fcinfo = {flinfo = 0x820d73268, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x820d732b8}, fcinfo_data = "h2\327 \b", '\000' , "\001\000\005\340", '\000' } [18:20:13.327] fcinfo = 0x820d73298 [18:20:13.327] result = [18:20:13.327] __error = [18:20:13.327] #24 OidFunctionCall1Coll (functionId=functionId@entry=16455, collation=collation@entry=0, arg1=arg1@entry=57349) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:13.327] flinfo = {fn_addr = 0x835904370 , fn_oid = 16455, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x832d71800, fn_expr = 0x0} [18:20:13.327] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x832c77fb8 "transaction_test1", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=2278, proowner=10, languageObjectId=16456, languageValidator=16455, prosrc=0x832c781c0 "\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n plpy.rollback()\n", probin=0x0, prosqlbody=0x0, prokind=112 'p', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x832c233b0, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, trftypes=0, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:13.327] set_items = [18:20:13.327] save_nestlevel = 0 [18:20:13.327] myself = {classId = 1255, objectId = 57349, objectSubId = 0} [18:20:13.327] nulls = {false , true, true, true, true, true, false, true, true, true, true} [18:20:13.327] values = {57349, 34910712560, 2200, 10, 16456, 1120403456, 0, 0, 0, 112, 0, 0, 0, 0, 118, 117, 0, 0, 2278, 35211326384, 0, 0, 0, 0, 0, 35211325496, 0, 0, 0, 0} [18:20:13.327] replaces = {true } [18:20:13.327] procname = {data = "transaction_test1", '\000' } [18:20:13.327] referenced = {classId = 1247, objectId = 2278, objectSubId = 0} [18:20:13.327] paramModes = [18:20:13.327] variadicType = [18:20:13.327] proacl = 0x0 [18:20:13.327] parameterCount = [18:20:13.327] allParamCount = 0 [18:20:13.327] allParams = 0x832c233c8 [18:20:13.327] detailmsg = [18:20:13.327] i = [18:20:13.327] rel = 0x832d088d8 [18:20:13.327] tupDesc = 0x832d08bf8 [18:20:13.327] oldtup = 0x0 [18:20:13.327] tup = 0x832d72c38 [18:20:13.327] is_update = [18:20:13.327] retval = 57349 [18:20:13.327] addrs = [18:20:13.327] trfid = [18:20:13.327] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x832d71900, stmt=, stmt@entry=0x832c77f68) at ../src/backend/commands/functioncmds.c:1257 [18:20:13.327] funcname = 0x832c77fb8 "transaction_test1" [18:20:13.327] parameterTypes = 0x832c233b0 [18:20:13.327] parameterTypes_list = 0x0 [18:20:13.327] allParameterTypes = 0x0 [18:20:13.327] parameterModes = 0x0 [18:20:13.327] parameterNames = 0x0 [18:20:13.327] inParameterNames_list = 0x0 [18:20:13.327] parameterDefaults = 0x0 [18:20:13.327] variadicArgType = 0 [18:20:13.327] requiredResultType = 0 [18:20:13.327] transformDefElem = [18:20:13.327] trftypes_list = [18:20:13.327] namespaceId = 2200 [18:20:13.327] aclresult = [18:20:13.327] as_clause = [18:20:13.327] language = [18:20:13.327] isWindowFunc = false [18:20:13.327] isStrict = false [18:20:13.327] security = false [18:20:13.327] isLeakProof = [18:20:13.327] volatility = 118 'v' [18:20:13.327] proconfig = 0x0 [18:20:13.327] procost = 100 [18:20:13.327] prorows = 0 [18:20:13.327] prosupport = 0 [18:20:13.327] parallel = 117 'u' [18:20:13.327] languageTuple = [18:20:13.327] languageStruct = [18:20:13.327] languageOid = 16456 [18:20:13.327] languageValidator = 16455 [18:20:13.327] prorettype = 2278 [18:20:13.327] returnsSet = false [18:20:13.327] trftypes = 0x0 [18:20:13.327] prosqlbody = 0x0 [18:20:13.327] probin_str = 0x0 [18:20:13.327] prosrc_str = 0x832c781c0 "\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n plpy.rollback()\n" [18:20:13.327] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x832d71900, pstmt=pstmt@entry=0x832c78390, queryString=queryString@entry=0x832bd8100 "CREATE PROCEDURE transaction_test1()\nLANGUAGE plpython3u\nAS $$\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n "..., context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1655 [18:20:13.327] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34910713560, 34910713936, 34910713568, 12139336, 0, 35212695808, 35211641727, 10, 0, 549755813888}}} [18:20:13.327] _save_exception_stack = 0x820d739b0 [18:20:13.327] _save_context_stack = 0x0 [18:20:13.327] _do_rethrow = false [18:20:13.327] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:13.327] parsetree = 0x832c77f68 [18:20:13.327] commandCollected = false [18:20:13.327] needCleanup = false [18:20:13.327] address = [18:20:13.327] isTopLevel = [18:20:13.327] isCompleteQuery = [18:20:13.327] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x832c78390, queryString=0x832bd8100 "CREATE PROCEDURE transaction_test1()\nLANGUAGE plpython3u\nAS $$\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n "..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x832c784f0, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:1030 [18:20:13.327] isAtomicContext = false [18:20:13.327] parsetree = 0x832c77f68 [18:20:13.327] readonly_flags = [18:20:13.327] pstate = 0x832d71900 [18:20:13.327] isTopLevel = [18:20:13.327] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18d76, queryString=0x6 , readOnlyTree=, context=714003450, params=0x0, queryEnv=0x0, dest=0x832c784f0, qc=0x820d73ab0) at ../src/backend/tcop/utility.c:523 [18:20:13.327] No locals. [18:20:13.327] #30 0x0000000000904073 in PortalRunUtility (portal=0x832caf100, pstmt=0x832c78390, isTopLevel=, setHoldSnapshot=, dest=0x832c784f0, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1158 [18:20:13.327] No locals. [18:20:13.327] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x832caf100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x832c784f0, altdest=altdest@entry=0x832c784f0, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:1323 [18:20:13.327] pstmt = 0x832c78390 [18:20:13.327] stmtlist_item__state = {l = 0x832c784a0, i = 0} [18:20:13.327] active_snapshot_set = false [18:20:13.327] stmtlist_item = 0x832c784b8 [18:20:13.327] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x832caf100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x832c784f0, altdest=altdest@entry=0x832c784f0, qc=0x820d73ab0) at ../src/backend/tcop/pquery.c:791 [18:20:13.327] _local_sigjmp_buf = {{_sjb = {9449293, 35211899136, 34910714280, 34910714512, 34910714288, 35212374016, 12106024, 12139336, 35211903871, 35211669560, 4294967984, 0}}} [18:20:13.327] _save_exception_stack = 0x820d73b80 [18:20:13.327] _save_context_stack = 0x0 [18:20:13.327] _do_rethrow = false [18:20:13.327] saveTopTransactionResourceOwner = 0x832cc1948 [18:20:13.327] saveTopTransactionContext = 0x832d23000 [18:20:13.327] saveActivePortal = 0x0 [18:20:13.327] saveResourceOwner = 0x832cc1948 [18:20:13.327] savePortalContext = 0x0 [18:20:13.327] saveMemoryContext = 0x832d23000 [18:20:13.327] result = [18:20:13.327] nprocessed = [18:20:13.327] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x832bd8100 "CREATE PROCEDURE transaction_test1()\nLANGUAGE plpython3u\nAS $$\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n "...) at ../src/backend/tcop/postgres.c:1284 [18:20:13.327] cmdtaglen = 16 [18:20:13.327] snapshot_set = [18:20:13.327] per_parsetree_context = 0x0 [18:20:13.327] plantree_list = [18:20:13.327] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:13.327] format = 0 [18:20:13.327] parsetree = 0x832bd9830 [18:20:13.327] commandTag = [18:20:13.327] cmdtagname = [18:20:13.327] querytree_list = [18:20:13.327] portal = 0x832caf100 [18:20:13.327] receiver = 0x832c784f0 [18:20:13.327] parsetree_item__state = {l = 0x832bd9c38, i = 0} [18:20:13.327] msec_str = "\000\000\000\000\b", '\000' , "\023\001\326f\000\000\000\000HU^\304\371\224}\266" [18:20:13.327] dest = DestRemote [18:20:13.327] was_logged = [18:20:13.327] oldcontext = 0x832d23000 [18:20:13.327] parsetree_list = 0x832bd9c38 [18:20:13.327] use_implicit_block = false [18:20:13.327] parsetree_item = 0x832bd9c50 [18:20:13.327] save_log_statement_stats = [18:20:13.327] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:13.327] query_string = 0x832bd8100 "CREATE PROCEDURE transaction_test1()\nLANGUAGE plpython3u\nAS $$\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n "... [18:20:13.327] input_message = {data = 0x832bd8100 "CREATE PROCEDURE transaction_test1()\nLANGUAGE plpython3u\nAS $$\nfor i in range(0, 10):\n plpy.execute(\"INSERT INTO test1 (a) VALUES (%d)\" % i)\n if i % 2 == 0:\n plpy.commit()\n else:\n "..., len = 223, maxlen = 1024, cursor = 223} [18:20:13.327] firstchar = [18:20:13.327] local_sigjmp_buf = {{_sjb = {9433206, 34910714752, 34910714712, 34910715296, 12148072, 1, 8192, 8388608, 34910700415, 0, 0, 1}}} [18:20:13.327] send_ready_for_query = false [18:20:13.327] idle_in_transaction_timeout_enabled = false [18:20:13.327] idle_session_timeout_enabled = false [18:20:13.327] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:13.327] bsdata = [18:20:13.327] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820d748c4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820d74800) at ../src/backend/postmaster/launch_backend.c:274 [18:20:13.327] pid = [18:20:13.327] #37 0x0000000000858958 in BackendStartup (client_sock=0x820d74800) at ../src/backend/postmaster/postmaster.c:3414 [18:20:13.327] startup_data = {canAcceptConnections = CAC_OK} [18:20:13.327] bn = 0x832bd9f00 [18:20:13.327] pid = [18:20:13.327] __error = [18:20:13.327] save_errno = [18:20:13.327] __error = [18:20:13.327] __error = [18:20:13.327] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:13.327] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\237\2752\b", '\000' , "`H\327 \b\000\000\000he2(\b\000\000\000\v\000\000\000\000\000\000\000^\3572(\b", '\000' , "\240H\327 \b\000\000\000DC\205\000\000\000\000\000\260H\327 \b", '\000' }, salen = 16}} [18:20:13.327] i = 0 [18:20:13.327] now = [18:20:13.327] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713628802, events = 8, fd = 0, user_data = 0x820d747b0}, {pos = 851650008, events = 8, fd = 550979136, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x19c15bb8730a}, {pos = 712796064, events = 8, fd = 712867192, user_data = 0x820d742c8}, {pos = 550978368, events = 8, fd = 550978248, user_data = 0x19c15bb8730a}, {pos = 712774536, events = 8, fd = 712867192, user_data = 0x820d742f8}, {pos = 550978416, events = 8, fd = 550978296, user_data = 0x82a7d0194}, {pos = 554021896, events = 8, fd = 712835476, user_data = 0x820d74360}, {pos = 1538794554, events = 6593, fd = 714657840, user_data = 0x1}, {pos = 550978448, events = 8, fd = 1538814730, user_data = 0x82a7b9858}, {pos = 712867192, events = 8, fd = 550978408, user_data = 0x820d743e0}, {pos = 550978408, events = 8, fd = 712830220, user_data = 0x82105b408}, {pos = 712830220, events = 8, fd = 550978512, user_data = 0x19c15bb8243a}, {pos = 550978552, events = 8, fd = 550979000, user_data = 0x820d743e0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 1261080877, fd = 554045496, user_data = 0x800000001}, {pos = 554021896, events = 8, fd = 712774536, user_data = 0x821060288}, {pos = 712743000, events = 8, fd = 554021896, user_data = 0x820d74468}, {pos = 550979112, events = 8, fd = 550978640, user_data = 0x19c15bb86ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 554045496, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 550979368, user_data = 0x2105b408}, {pos = 550979184, events = 8, fd = 550978784, user_data = 0x1}, {pos = 550979112, events = 8, fd = 32, user_data = 0x820d744d0}, {pos = 1538812531, events = 6593, fd = 550979056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821061038}, {pos = 1, events = 8, fd = 554021896, user_data = 0x82a7b9858}, {pos = 550979368, events = 8, fd = 550979184, user_data = 0x820d744e0}, {pos = 0, events = 0, fd = 553992200, user_data = 0x20}, {pos = 550979168, events = 8, fd = 1538788071, user_data = 0x821054008}, {pos = 553993224, events = 8, fd = 553994248, user_data = 0x821054c08}, {pos = 554008584, events = 8, fd = 554009608, user_data = 0x821058808}, {pos = 554011656, events = 8, fd = 554012680, user_data = 0x821059408}, {pos = 554014728, events = 8, fd = 554015752, user_data = 0x82105a008}, {pos = 554017800, events = 8, fd = 554018824, user_data = 0x82105ac08}, {pos = 554020872, events = 8, fd = 554021896, user_data = 0x82105b808}, {pos = 554023944, events = 8, fd = 554024968, user_data = 0x82105c408}, {pos = 554027016, events = 8, fd = 554028040, user_data = 0x82105d008}, {pos = 554030088, events = 8, fd = 554031112, user_data = 0x82105dc08}, {pos = 554037256, events = 8, fd = 554038280, user_data = 0x82105f808}, {pos = 554040328, events = 8, fd = 553992200, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821061038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550979368, events = 8, fd = 550978784, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 554045496, user_data = 0x1}, {pos = 553992200, events = 8, fd = 313, user_data = 0x820d74710}, {pos = 1538786799, events = 6593, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 554045496, user_data = 0x1}, {pos = 554021896, events = 8, fd = 851214336, user_data = 0x1}, {pos = 851214740, events = 8, fd = 0, user_data = 0x820d746e0}, {pos = 674424172, events = 8, fd = 1, user_data = 0x832bc8000}, {pos = 550979344, events = 8, fd = 674420482, user_data = 0x82a8eb170 }, {pos = 12073120, events = 0, fd = 713994608, user_data = 0x82105b408}, {pos = 550979568, events = 8, fd = 1538786270, user_data = 0x832be6800}, {pos = 1, events = 0, fd = 1538785886, user_data = 0x821054008}, {pos = 550979352, events = 8, fd = 550979568, user_data = 0x1c20}, {pos = 851287808, events = 8, fd = 1538865552, user_data = 0x0}, {pos = 550962047, events = 8, fd = 7886519, user_data = 0x820d747a0}, {pos = 674382864, events = 8, fd = 714657840, user_data = 0x82a98f310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820d747d0}, {pos = 674425757, events = 8, fd = 851214336, user_data = 0x4c21}, {pos = 550979632, events = 8, fd = 674392314, user_data = 0x0}, {pos = 0, events = 0, fd = 401122155, user_data = 0x0}} [18:20:13.327] last_touch_time = 1725300997 [18:20:13.327] last_lockfile_recheck_time = 1725300997 [18:20:13.327] nevents = 1 [18:20:13.327] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d74e18) at ../src/backend/postmaster/postmaster.c:1346 [18:20:13.327] userDoption = [18:20:13.327] listen_addr_saved = [18:20:13.327] output_config_variable = [18:20:13.327] opt = [18:20:13.327] status = [18:20:13.327] #40 0x000000000079239c in main (argc=8, argv=0x820d74e18) at ../src/backend/main/main.c:197 [18:20:13.327] do_check_root = [18:20:13.341] [18:20:13.341] [18:20:13.341] [18:20:13.409] dumping /tmp/cores/postgres.21029.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:13.534] [New LWP 101717] [18:20:13.611] Core was generated by `postgres: postgres regression_ltree_plpython [local] CREATE FUNCTION'. [18:20:13.611] Program terminated with signal SIGABRT, Aborted. [18:20:13.611] Sent by thr_kill() from pid 21029 and user 1003. [18:20:13.611] #0 0x000000082b70641a in thr_kill () from /lib/libc.so.7 [18:20:14.201] To enable execution of this file add [18:20:14.201] add-auto-load-safe-path /usr/local/lib/libpython3.11.so.1.0-gdb.py [18:20:14.201] line to your configuration file "/.config/gdb/gdbinit". [18:20:14.201] To completely disable this security protection add [18:20:14.201] set auto-load safe-path / [18:20:14.201] line to your configuration file "/.config/gdb/gdbinit". [18:20:14.201] For more information about this security protection see the [18:20:14.201] "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: [18:20:14.201] info "(gdb)Auto-loading safe path" [18:20:14.201] [18:20:14.201] Thread 1 (LWP 101717): [18:20:14.201] #0 0x000000082b70641a in thr_kill () from /lib/libc.so.7 [18:20:14.201] No symbol table info available. [18:20:14.201] #1 0x000000082b67fe64 in raise () from /lib/libc.so.7 [18:20:14.201] No symbol table info available. [18:20:14.201] #2 0x000000082b7306f9 in abort () from /lib/libc.so.7 [18:20:14.201] No symbol table info available. [18:20:14.201] #3 0x0000000000a59255 in ExceptionalCondition (conditionName=0x84672fe44 "!found", fileName=, lineNumber=lineNumber@entry=267) at ../src/backend/utils/error/assert.c:66 [18:20:14.201] No locals. [18:20:14.201] #4 0x0000000846739063 in PLy_generate_spi_exceptions (mod=0x84b465ad0, base=0x842c32010) at ../src/pl/plpython/plpy_plpymodule.c:267 [18:20:14.201] dict = [18:20:14.201] found = true [18:20:14.201] sqlstate = [18:20:14.201] exc = 0x842c8ac10 [18:20:14.201] entry = 0x0 [18:20:14.201] i = 66 [18:20:14.201] #5 PLy_add_exceptions (plpy=0x849edec50) at ../src/pl/plpython/plpy_plpymodule.c:204 [18:20:14.201] hash_ctl = {num_partitions = 35599355248, ssize = 7, dsize = 2, max_dsize = 34923952640, keysize = 4, entrysize = 16, hash = 0x849e78d40, match = 0x849e78d40, keycopy = 0x84b44d000, alloc = 0x849ed60f0, hcxt = 0x848f5fac0 <_PyRuntime+166184>, hctl = 0x821a13a50} [18:20:14.201] excmod = 0x84b465ad0 [18:20:14.201] #6 PyInit_plpy () at ../src/pl/plpython/plpy_plpymodule.c:137 [18:20:14.201] m = 0x849edec50 [18:20:14.201] #7 0x0000000848d6bf70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #8 0x0000000848d6a2e0 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #9 0x0000000848c8ac29 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #10 0x0000000848d34d9c in _PyEval_EvalFrameDefault () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #11 0x0000000848d37795 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #12 0x0000000848c3890f in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #13 0x0000000848c38705 in PyObject_CallMethodObjArgs () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #14 0x0000000848d66284 in PyImport_ImportModuleLevelObject () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #15 0x0000000848d1e996 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #16 0x0000000848c8ae70 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #17 0x0000000848c37538 in ?? () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #18 0x0000000848c37467 in PyObject_CallFunction () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #19 0x0000000848d65b30 in PyImport_Import () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #20 0x0000000848d66ef8 in PyImport_ImportModule () from /usr/local/lib/libpython3.11.so.1.0 [18:20:14.201] No symbol table info available. [18:20:14.201] #21 0x0000000846738476 in PLy_initialize () at ../src/pl/plpython/plpy_main.c:118 [18:20:14.201] inited = false [18:20:14.201] #22 0x00000008467383a0 in plpython3_validator (fcinfo=) at ../src/pl/plpython/plpy_main.c:172 [18:20:14.201] funcoid = 16585 [18:20:14.201] tuple = [18:20:14.201] is_trigger = [18:20:14.201] procStruct = [18:20:14.201] #23 0x0000000000a63183 in FunctionCall1Coll (flinfo=0x821a141d8, collation=0, arg1=16585) at ../src/backend/utils/fmgr/fmgr.c:1139 [18:20:14.201] fcinfodata = {fcinfo = {flinfo = 0x821a141d8, context = 0x0, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 1, args = 0x821a14228}, fcinfo_data = "\330A\241!\b", '\000' , "\001\000\311@", '\000' } [18:20:14.201] fcinfo = 0x821a14208 [18:20:14.201] result = [18:20:14.201] __error = [18:20:14.201] #24 OidFunctionCall1Coll (functionId=functionId@entry=16580, collation=collation@entry=0, arg1=arg1@entry=16585) at ../src/backend/utils/fmgr/fmgr.c:1417 [18:20:14.201] flinfo = {fn_addr = 0x846738370 , fn_oid = 16580, fn_nargs = 1, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x8351c7400, fn_expr = 0x0} [18:20:14.201] #25 0x000000000067e55d in ProcedureCreate (procedureName=procedureName@entry=0x83530ae20 "test1", procNamespace=procNamespace@entry=2200, replace=false, returnsSet=, returnType=23, proowner=10, languageObjectId=16581, languageValidator=16580, prosrc=0x842b4b580 "\nplpy.info(repr(val))\nreturn len(val)\n", probin=0x0, prosqlbody=0x0, prokind=102 'f', security_definer=, isLeakProof=, isStrict=, volatility=118 'v', parallel=117 'u', parameterTypes=0x835204c18, allParameterTypes=0, parameterModes=0, parameterNames=35251047496, parameterDefaults=0x0, trftypes=35251047680, proconfig=0, prosupport=0, procost=procost@entry=100, prorows=prorows@entry=0) at ../src/backend/catalog/pg_proc.c:703 [18:20:14.201] set_items = [18:20:14.201] save_nestlevel = 0 [18:20:14.201] myself = {classId = 1255, objectId = 16585, objectSubId = 0} [18:20:14.201] nulls = {false , true, true, false, true, false, false, true, true, true, true} [18:20:14.201] values = {16585, 34923954784, 2200, 10, 16581, 1120403456, 0, 0, 0, 102, 0, 0, 0, 0, 118, 117, 1, 0, 23, 35251047448, 0, 0, 35251047496, 0, 35251047680, 35251047544, 0, 0, 0, 0} [18:20:14.201] replaces = {true } [18:20:14.201] procname = {data = "test1", '\000' } [18:20:14.201] referenced = {classId = 3576, objectId = 16584, objectSubId = 0} [18:20:14.201] paramModes = [18:20:14.201] variadicType = [18:20:14.201] proacl = 0x0 [18:20:14.201] parameterCount = [18:20:14.201] allParamCount = 1 [18:20:14.201] allParams = 0x835204c30 [18:20:14.201] detailmsg = [18:20:14.201] i = [18:20:14.201] rel = 0x8352e4b08 [18:20:14.201] tupDesc = 0x8352e4d18 [18:20:14.201] oldtup = 0x0 [18:20:14.201] tup = 0x83534f838 [18:20:14.201] is_update = [18:20:14.201] retval = 16585 [18:20:14.201] addrs = [18:20:14.201] trfid = [18:20:14.201] #26 0x00000000006bc7e9 in CreateFunction (pstate=pstate@entry=0x8351c7500, stmt=, stmt@entry=0x83530add0) at ../src/backend/commands/functioncmds.c:1257 [18:20:14.201] funcname = 0x83530ae20 "test1" [18:20:14.201] parameterTypes = 0x835204c18 [18:20:14.201] parameterTypes_list = 0x83534fba8 [18:20:14.201] allParameterTypes = 0x0 [18:20:14.201] parameterModes = 0x0 [18:20:14.201] parameterNames = 0x835204c48 [18:20:14.201] inParameterNames_list = 0x835204bc8 [18:20:14.201] parameterDefaults = 0x0 [18:20:14.201] variadicArgType = 0 [18:20:14.201] requiredResultType = 0 [18:20:14.201] transformDefElem = [18:20:14.201] trftypes_list = [18:20:14.201] namespaceId = 2200 [18:20:14.201] aclresult = [18:20:14.201] as_clause = [18:20:14.201] language = [18:20:14.201] isWindowFunc = false [18:20:14.201] isStrict = false [18:20:14.201] security = false [18:20:14.201] isLeakProof = [18:20:14.201] volatility = 118 'v' [18:20:14.201] proconfig = 0x0 [18:20:14.201] procost = 100 [18:20:14.201] prorows = 0 [18:20:14.201] prosupport = 0 [18:20:14.201] parallel = 117 'u' [18:20:14.201] languageTuple = [18:20:14.201] languageStruct = [18:20:14.201] languageOid = 16581 [18:20:14.201] languageValidator = 16580 [18:20:14.201] prorettype = 23 [18:20:14.201] returnsSet = false [18:20:14.201] trftypes = 0x835204d00 [18:20:14.201] prosqlbody = 0x0 [18:20:14.201] probin_str = 0x0 [18:20:14.201] prosrc_str = 0x842b4b580 "\nplpy.info(repr(val))\nreturn len(val)\n" [18:20:14.201] #27 0x0000000000906088 in ProcessUtilitySlow (pstate=pstate@entry=0x8351c7500, pstmt=pstmt@entry=0x8353096a0, queryString=queryString@entry=0x8351b9100 "CREATE FUNCTION test1(val ltree) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE ltree\nAS $$\nplpy.info(repr(val))\nreturn len(val)\n$$;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821a14a20) at ../src/backend/tcop/utility.c:1655 [18:20:14.201] _local_sigjmp_buf = {{_sjb = {9460057, 0, 34923955784, 34923956160, 34923955792, 12139336, 0, 35250795776, 35252077439, 10, 0, 549755813888}}} [18:20:14.201] _save_exception_stack = 0x821a14920 [18:20:14.201] _save_context_stack = 0x0 [18:20:14.201] _do_rethrow = false [18:20:14.201] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [18:20:14.201] parsetree = 0x83530add0 [18:20:14.201] commandCollected = false [18:20:14.201] needCleanup = false [18:20:14.201] address = [18:20:14.201] isTopLevel = [18:20:14.201] isCompleteQuery = [18:20:14.201] #28 0x0000000000904aa8 in standard_ProcessUtility (pstmt=0x8353096a0, queryString=0x8351b9100 "CREATE FUNCTION test1(val ltree) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE ltree\nAS $$\nplpy.info(repr(val))\nreturn len(val)\n$$;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x842b4b6e0, qc=0x821a14a20) at ../src/backend/tcop/utility.c:1030 [18:20:14.201] isAtomicContext = false [18:20:14.201] parsetree = 0x83530add0 [18:20:14.201] readonly_flags = [18:20:14.201] pstate = 0x8351c7500 [18:20:14.201] isTopLevel = [18:20:14.201] #29 0x0000000000904538 in ProcessUtility (pstmt=0x18d55, queryString=0x6 , readOnlyTree=, context=728785914, params=0x0, queryEnv=0x0, dest=0x842b4b6e0, qc=0x821a14a20) at ../src/backend/tcop/utility.c:523 [18:20:14.201] No locals. [18:20:14.201] #30 0x0000000000904073 in PortalRunUtility (portal=0x83528e100, pstmt=0x8353096a0, isTopLevel=, setHoldSnapshot=, dest=0x842b4b6e0, qc=0x821a14a20) at ../src/backend/tcop/pquery.c:1158 [18:20:14.201] No locals. [18:20:14.201] #31 0x0000000000903704 in PortalRunMulti (portal=portal@entry=0x83528e100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x842b4b6e0, altdest=altdest@entry=0x842b4b6e0, qc=0x821a14a20) at ../src/backend/tcop/pquery.c:1323 [18:20:14.201] pstmt = 0x8353096a0 [18:20:14.201] stmtlist_item__state = {l = 0x842b4b690, i = 0} [18:20:14.201] active_snapshot_set = false [18:20:14.201] stmtlist_item = 0x842b4b6a8 [18:20:14.201] #32 0x0000000000902fd3 in PortalRun (portal=portal@entry=0x83528e100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x842b4b6e0, altdest=altdest@entry=0x842b4b6e0, qc=0x821a14a20) at ../src/backend/tcop/pquery.c:791 [18:20:14.201] _local_sigjmp_buf = {{_sjb = {9449293, 35251609856, 34923956504, 34923956736, 34923956512, 35251625984, 12106024, 12139336, 35251618687, 35252115984, 4294967984, 0}}} [18:20:14.201] _save_exception_stack = 0x821a14af0 [18:20:14.201] _save_context_stack = 0x0 [18:20:14.201] _do_rethrow = false [18:20:14.201] saveTopTransactionResourceOwner = 0x83529ac18 [18:20:14.201] saveTopTransactionContext = 0x835292000 [18:20:14.201] saveActivePortal = 0x0 [18:20:14.201] saveResourceOwner = 0x83529ac18 [18:20:14.201] savePortalContext = 0x0 [18:20:14.201] saveMemoryContext = 0x835292000 [18:20:14.201] result = [18:20:14.201] nprocessed = [18:20:14.201] #33 0x0000000000901e72 in exec_simple_query (query_string=query_string@entry=0x8351b9100 "CREATE FUNCTION test1(val ltree) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE ltree\nAS $$\nplpy.info(repr(val))\nreturn len(val)\n$$;") at ../src/backend/tcop/postgres.c:1284 [18:20:14.201] cmdtaglen = 15 [18:20:14.201] snapshot_set = [18:20:14.201] per_parsetree_context = 0x0 [18:20:14.201] plantree_list = [18:20:14.201] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:14.201] format = 0 [18:20:14.201] parsetree = 0x8351baea8 [18:20:14.201] commandTag = [18:20:14.201] cmdtagname = [18:20:14.201] querytree_list = [18:20:14.201] portal = 0x83528e100 [18:20:14.201] receiver = 0x842b4b6e0 [18:20:14.201] parsetree_item__state = {l = 0x835309650, i = 0} [18:20:14.201] msec_str = "\000\000\000\000\b", '\000' , "\024\001\326f\000\000\000\000\2661\322\f,\270Ĝ" [18:20:14.201] dest = DestRemote [18:20:14.201] was_logged = [18:20:14.201] oldcontext = 0x835292000 [18:20:14.201] parsetree_list = 0x835309650 [18:20:14.201] use_implicit_block = false [18:20:14.201] parsetree_item = 0x835309668 [18:20:14.201] save_log_statement_stats = [18:20:14.201] #34 0x00000000008ffbe0 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [18:20:14.201] query_string = 0x8351b9100 "CREATE FUNCTION test1(val ltree) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE ltree\nAS $$\nplpy.info(repr(val))\nreturn len(val)\n$$;" [18:20:14.201] input_message = {data = 0x8351b9100 "CREATE FUNCTION test1(val ltree) RETURNS int\nLANGUAGE plpython3u\nTRANSFORM FOR TYPE ltree\nAS $$\nplpy.info(repr(val))\nreturn len(val)\n$$;", len = 137, maxlen = 1024, cursor = 137} [18:20:14.201] firstchar = [18:20:14.201] local_sigjmp_buf = {{_sjb = {9433206, 34923956976, 34923956936, 34923957520, 12148072, 1, 8192, 8388608, 34923938687, 0, 0, 1}}} [18:20:14.201] send_ready_for_query = false [18:20:14.201] idle_in_transaction_timeout_enabled = false [18:20:14.201] idle_session_timeout_enabled = false [18:20:14.201] #35 0x00000000008fa3b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:20:14.201] bsdata = [18:20:14.201] #36 0x0000000000854597 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a15834 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a15770) at ../src/backend/postmaster/launch_backend.c:274 [18:20:14.201] pid = [18:20:14.201] #37 0x0000000000858958 in BackendStartup (client_sock=0x821a15770) at ../src/backend/postmaster/postmaster.c:3414 [18:20:14.201] startup_data = {canAcceptConnections = CAC_OK} [18:20:14.201] bn = 0x8351c5088 [18:20:14.201] pid = [18:20:14.201] __error = [18:20:14.201] save_errno = [18:20:14.201] __error = [18:20:14.201] __error = [18:20:14.201] #38 ServerLoop () at ../src/backend/postmaster/postmaster.c:1648 [18:20:14.201] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\000\257\0335\b", '\000' , "\320W\241!\b\000\000\000h5l*\b\000\000\000\v\000\000\000\000\000\000\000^\277l*\b", '\000' , "\020X\241!\b\000\000\000DC\205\000\000\000\000\000 X\241!\b", '\000' }, salen = 16}} [18:20:14.201] i = 0 [18:20:14.201] now = [18:20:14.201] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 728411266, events = 8, fd = 0, user_data = 0x821a15720}, {pos = 891368920, events = 8, fd = 564221360, user_data = 0x0}, {pos = 0, events = 0, fd = 1792557157, user_data = 0x24648848430a}, {pos = 727578528, events = 8, fd = 727649656, user_data = 0x821a15238}, {pos = 564220592, events = 8, fd = 564220472, user_data = 0x24648848430a}, {pos = 727557000, events = 8, fd = 727649656, user_data = 0x821a15268}, {pos = 564220640, events = 8, fd = 564220520, user_data = 0x82b5e9194}, {pos = 567817224, events = 8, fd = 727617940, user_data = 0x821a152d0}, {pos = -2008550342, events = 9316, fd = 729440304, user_data = 0x1}, {pos = 564220672, events = 8, fd = -2008530166, user_data = 0x82b5d2858}, {pos = 727649656, events = 8, fd = 564220632, user_data = 0x821a15350}, {pos = 564220632, events = 8, fd = 727612684, user_data = 0x821d83408}, {pos = 727612684, events = 8, fd = 564220736, user_data = 0x24648847f43a}, {pos = 564220776, events = 8, fd = 564221224, user_data = 0x821a15350}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1382427086, events = 4004124822, fd = 567840824, user_data = 0x800000001}, {pos = 567817224, events = 8, fd = 727557000, user_data = 0x821d88288}, {pos = 727525464, events = 8, fd = 567817224, user_data = 0x821a153d8}, {pos = 564221336, events = 8, fd = 564220864, user_data = 0x246488483ca2}, {pos = 2699697, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 567840824, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564221592, user_data = 0x21d83408}, {pos = 564221408, events = 8, fd = 564221008, user_data = 0x1}, {pos = 564221336, events = 8, fd = 32, user_data = 0x821a15440}, {pos = -2008532365, events = 9316, fd = 564221280, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821d89038}, {pos = 1, events = 8, fd = 567817224, user_data = 0x82b5d2858}, {pos = 564221592, events = 8, fd = 564221408, user_data = 0x821a15450}, {pos = 0, events = 0, fd = 567787528, user_data = 0x20}, {pos = 564221392, events = 8, fd = -2008556825, user_data = 0x821d7c008}, {pos = 567788552, events = 8, fd = 567789576, user_data = 0x821d7cc08}, {pos = 567803912, events = 8, fd = 567804936, user_data = 0x821d80808}, {pos = 567806984, events = 8, fd = 567808008, user_data = 0x821d81408}, {pos = 567810056, events = 8, fd = 567811080, user_data = 0x821d82008}, {pos = 567813128, events = 8, fd = 567814152, user_data = 0x821d82c08}, {pos = 567816200, events = 8, fd = 567817224, user_data = 0x821d83808}, {pos = 567819272, events = 8, fd = 567820296, user_data = 0x821d84408}, {pos = 567822344, events = 8, fd = 567823368, user_data = 0x821d85008}, {pos = 567825416, events = 8, fd = 567826440, user_data = 0x821d85c08}, {pos = 567832584, events = 8, fd = 567833608, user_data = 0x821d87808}, {pos = 567835656, events = 8, fd = 567787528, user_data = 0x2931b1}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821d89038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 564221592, events = 8, fd = 564221008, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 567840824, user_data = 0x1}, {pos = 567787528, events = 8, fd = 313, user_data = 0x821a15680}, {pos = -2008558097, events = 9316, fd = 2699697, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 567840824, user_data = 0x1}, {pos = 567817224, events = 8, fd = 890933248, user_data = 0x1}, {pos = 890933652, events = 8, fd = 0, user_data = 0x821a15650}, {pos = 711767404, events = 8, fd = 1, user_data = 0x8351a9000}, {pos = 564221568, events = 8, fd = 711763714, user_data = 0x82b704170 }, {pos = 12073120, events = 0, fd = 728777072, user_data = 0x821d83408}, {pos = 564221792, events = 8, fd = -2008558626, user_data = 0x8351c7800}, {pos = 1, events = 0, fd = -2008559010, user_data = 0x821d7c008}, {pos = 564221576, events = 8, fd = 564221792, user_data = 0x1c20}, {pos = 891006720, events = 8, fd = -2008479344, user_data = 0x0}, {pos = 564200319, events = 8, fd = 7886519, user_data = 0x821a15710}, {pos = 711726096, events = 8, fd = 729440304, user_data = 0x82b7a8310}, {pos = 0, events = 0, fd = 8128, user_data = 0x821a15740}, {pos = 711768989, events = 8, fd = 890933248, user_data = 0x5211}, {pos = 564221856, events = 8, fd = 711735546, user_data = 0x0}, {pos = 0, events = 0, fd = 1792557157, user_data = 0x0}} [18:20:14.201] last_touch_time = 1725301012 [18:20:14.201] last_lockfile_recheck_time = 1725301012 [18:20:14.201] nevents = 1 [18:20:14.201] #39 0x0000000000856775 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821a15d88) at ../src/backend/postmaster/postmaster.c:1346 [18:20:14.201] userDoption = [18:20:14.201] listen_addr_saved = [18:20:14.201] output_config_variable = [18:20:14.201] opt = [18:20:14.201] status = [18:20:14.201] #40 0x000000000079239c in main (argc=8, argv=0x821a15d88) at ../src/backend/main/main.c:197 [18:20:14.201] do_check_root =