[05:14:09.777] src/tools/ci/cores_backtrace.sh macos "${HOME}/cores" [05:14:14.350] (lldb) target create --core "/Users/admin/cores/core.26767" [05:15:07.561] Core file '/Users/admin/cores/core.26767' (arm64) was loaded. [05:15:07.561] (lldb) thread backtrace all [05:15:10.184] warning: could not execute support code to read Objective-C class data in the process. This may reduce the quality of type information available. [05:15:10.184] [05:15:10.199] * thread #1 [05:15:10.199] * frame #0: 0x0000000185a7a5d0 libsystem_kernel.dylib`__pthread_kill + 8 [05:15:10.199] frame #1: 0x0000000185ab2c20 libsystem_pthread.dylib`pthread_kill + 288 [05:15:10.199] frame #2: 0x00000001859bfa30 libsystem_c.dylib`abort + 180 [05:15:10.199] frame #3: 0x0000000100b58cac postgres`ExceptionalCondition(conditionName=, fileName=, lineNumber=1068) at assert.c:66:2 [05:15:10.199] frame #4: 0x000000010074ca4c postgres`_bt_swap_posting(newitem=, oposting=, postingoff=1) at nbtdedup.c:1068:2 [05:15:10.199] frame #5: 0x000000010074def8 postgres`_bt_insertonpg(rel=0x0000000150080138, heaprel=0x000000013008c178, itup_key=0x000000015803a3a8, buf=38, cbuf=0, stack=0x000000015803a438, itup=0x000000015803acb8, itemsz=16, newitemoff=3, postingoff=1, split_only_page=) at nbtinsert.c:1197:14 [05:15:10.199] frame #6: 0x000000010074d894 postgres`_bt_doinsert(rel=, itup=0x000000014e09c7f0, checkUnique=UNIQUE_CHECK_NO, indexUnchanged=false, heapRel=) at nbtinsert.c:261:3 [05:15:10.199] frame #7: 0x0000000100758b38 postgres`btinsert(rel=0x0000000150080138, values=, isnull=, ht_ctid=0x0000000158039f78, heapRel=, checkUnique=, indexUnchanged=, indexInfo=) at nbtree.c:215:11 [05:15:10.199] frame #8: 0x0000000100869a2c postgres`ExecInsertIndexTuples(resultRelInfo=0x000000014e09ae10, slot=, estate=, update=, noDupErr=, specConflict=, arbiterIndexes=, onlySummarizing=) at execIndexing.c:449:4 [05:15:10.199] frame #9: 0x000000010089bea4 postgres`ExecInsert(context=0x000000016f723e88, resultRelInfo=0x000000014e09ae10, slot=0x0000000158039f48, canSetTag=true, inserted_tuple=0x0000000000000000, insert_destrel=0x0000000000000000) at nodeModifyTable.c:1240:22 [05:15:10.199] frame #10: 0x000000010089a310 postgres`ExecModifyTable(pstate=0x000000014e09ac00) at nodeModifyTable.c:4468:12 [05:15:10.199] frame #11: 0x000000010086b124 postgres`standard_ExecutorRun [inlined] ExecProcNode(node=0x000000014e09ac00) at executor.h:315:9 [05:15:10.199] frame #12: 0x000000010086b108 postgres`standard_ExecutorRun [inlined] ExecutePlan(queryDesc=0x000000014e08e300, operation=CMD_INSERT, sendTuples=false, numberTuples=0, direction=, dest=0x000000014f00bf48) at execMain.c:1678:10 [05:15:10.199] frame #13: 0x000000010086b0b8 postgres`standard_ExecutorRun(queryDesc=0x000000014e08e300, direction=, count=0) at execMain.c:366:3 [05:15:10.199] frame #14: 0x00000001012cfd10 pg_stat_statements.dylib`pgss_ExecutorRun(queryDesc=0x000000014e08e300, direction=ForwardScanDirection, count=0) at pg_stat_statements.c:1042:4 [05:15:10.199] frame #15: 0x0000000100a23ff4 postgres`ProcessQuery(plan=0x0000000158033d18, sourceText="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;", params=0x0000000000000000, queryEnv=0x0000000000000000, dest=0x000000014f00bf48, qc=0x000000016f724378) at pquery.c:161:2 [05:15:10.199] frame #16: 0x0000000100a236e0 postgres`PortalRunMulti(portal=0x000000014e02eb00, isTopLevel=true, setHoldSnapshot=false, dest=0x000000014f00bf48, altdest=0x000000014f00bf48, qc=0x000000016f724378) at pquery.c:0 [05:15:10.199] frame #17: 0x0000000100a23064 postgres`PortalRun(portal=0x000000014e02eb00, count=9223372036854775807, isTopLevel=true, dest=0x000000014f00bf48, altdest=0x000000014f00bf48, qc=0x000000016f724378) at pquery.c:788:5 [05:15:10.199] frame #18: 0x0000000100a22014 postgres`exec_simple_query(query_string="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;") at postgres.c:1274:10 [05:15:10.199] frame #19: 0x0000000100a1f260 postgres`PostgresMain(dbname=, username=) at postgres.c:0:24 [05:15:10.199] frame #20: 0x0000000100a1ac84 postgres`BackendMain(startup_data=, startup_data_len=) at backend_startup.c:124:2 [05:15:10.199] frame #21: 0x0000000100976240 postgres`postmaster_child_launch(child_type=B_BACKEND, child_slot=13, startup_data=0x000000016f725220, startup_data_len=24, client_sock=0x000000016f724790) at launch_backend.c:290:3 [05:15:10.199] frame #22: 0x000000010097a504 postgres`ServerLoop [inlined] BackendStartup(client_sock=0x000000016f724790) at postmaster.c:3590:8 [05:15:10.199] frame #23: 0x000000010097a468 postgres`ServerLoop at postmaster.c:1705:6 [05:15:10.199] frame #24: 0x00000001009787f0 postgres`PostmasterMain(argc=, argv=) at postmaster.c:1403:11 [05:15:10.199] frame #25: 0x00000001008c56fc postgres`main(argc=4, argv=0x0000600001568810) at main.c:231:4 [05:15:10.199] frame #26: 0x0000000185727154 dyld`start + 2476 [05:15:10.199] (lldb) quit [05:15:10.244] -e [05:15:10.244] [05:15:10.244] [05:15:10.583] (lldb) target create --core "/Users/admin/cores/core.15168" [05:15:56.574] Core file '/Users/admin/cores/core.15168' (arm64) was loaded. [05:15:56.574] (lldb) thread backtrace all [05:15:58.752] warning: could not execute support code to read Objective-C class data in the process. This may reduce the quality of type information available. [05:15:58.752] [05:15:58.764] * thread #1 [05:15:58.764] * frame #0: 0x0000000185a7a5d0 libsystem_kernel.dylib`__pthread_kill + 8 [05:15:58.764] frame #1: 0x0000000185ab2c20 libsystem_pthread.dylib`pthread_kill + 288 [05:15:58.764] frame #2: 0x00000001859bfa30 libsystem_c.dylib`abort + 180 [05:15:58.764] frame #3: 0x00000001009b8cac postgres`ExceptionalCondition(conditionName=, fileName=, lineNumber=1068) at assert.c:66:2 [05:15:58.764] frame #4: 0x00000001005aca4c postgres`_bt_swap_posting(newitem=, oposting=, postingoff=1) at nbtdedup.c:1068:2 [05:15:58.764] frame #5: 0x00000001005adef8 postgres`_bt_insertonpg(rel=0x0000000110010138, heaprel=0x00000001200373d0, itup_key=0x000000013b84bdb8, buf=16272, cbuf=0, stack=0x000000013b84be68, itup=0x000000013b84c6b8, itemsz=16, newitemoff=3, postingoff=1, split_only_page=) at nbtinsert.c:1197:14 [05:15:58.764] frame #6: 0x00000001005ad894 postgres`_bt_doinsert(rel=, itup=0x000000013b84be48, checkUnique=UNIQUE_CHECK_NO, indexUnchanged=false, heapRel=) at nbtinsert.c:261:3 [05:15:58.764] frame #7: 0x00000001005b8b38 postgres`btinsert(rel=0x0000000110010138, values=, isnull=, ht_ctid=0x000000013b82ed20, heapRel=, checkUnique=, indexUnchanged=, indexInfo=) at nbtree.c:215:11 [05:15:58.764] frame #8: 0x00000001006c9a2c postgres`ExecInsertIndexTuples(resultRelInfo=0x000000013b82d410, slot=, estate=, update=, noDupErr=, specConflict=, arbiterIndexes=, onlySummarizing=) at execIndexing.c:449:4 [05:15:58.764] frame #9: 0x00000001006fbea4 postgres`ExecInsert(context=0x000000016f8c3fd8, resultRelInfo=0x000000013b82d410, slot=0x000000013b82ecf0, canSetTag=true, inserted_tuple=0x0000000000000000, insert_destrel=0x0000000000000000) at nodeModifyTable.c:1240:22 [05:15:58.764] frame #10: 0x00000001006fa310 postgres`ExecModifyTable(pstate=0x000000013b82d200) at nodeModifyTable.c:4468:12 [05:15:58.764] frame #11: 0x00000001006cb124 postgres`standard_ExecutorRun [inlined] ExecProcNode(node=0x000000013b82d200) at executor.h:315:9 [05:15:58.764] frame #12: 0x00000001006cb108 postgres`standard_ExecutorRun [inlined] ExecutePlan(queryDesc=0x000000013b81f300, operation=CMD_INSERT, sendTuples=false, numberTuples=0, direction=, dest=0x000000013b017948) at execMain.c:1678:10 [05:15:58.764] frame #13: 0x00000001006cb0b8 postgres`standard_ExecutorRun(queryDesc=0x000000013b81f300, direction=, count=0) at execMain.c:366:3 [05:15:58.764] frame #14: 0x00000001006caff4 postgres`ExecutorRun(queryDesc=, direction=, count=) at execMain.c:303:3 [artificial] [05:15:58.764] frame #15: 0x0000000100883ff4 postgres`ProcessQuery(plan=0x000000013b8474a8, sourceText="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;", params=0x0000000000000000, queryEnv=0x0000000000000000, dest=0x000000013b017948, qc=0x000000016f8c4398) at pquery.c:161:2 [05:15:58.764] frame #16: 0x00000001008836e0 postgres`PortalRunMulti(portal=0x000000013c048700, isTopLevel=true, setHoldSnapshot=false, dest=0x000000013b017948, altdest=0x000000013b017948, qc=0x000000016f8c4398) at pquery.c:0 [05:15:58.764] frame #17: 0x0000000100883064 postgres`PortalRun(portal=0x000000013c048700, count=9223372036854775807, isTopLevel=true, dest=0x000000013b017948, altdest=0x000000013b017948, qc=0x000000016f8c4398) at pquery.c:788:5 [05:15:58.764] frame #18: 0x0000000100882014 postgres`exec_simple_query(query_string="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;") at postgres.c:1274:10 [05:15:58.764] frame #19: 0x000000010087f260 postgres`PostgresMain(dbname=, username=) at postgres.c:0:24 [05:15:58.764] frame #20: 0x000000010087ac84 postgres`BackendMain(startup_data=, startup_data_len=) at backend_startup.c:124:2 [05:15:58.764] frame #21: 0x00000001007d6240 postgres`postmaster_child_launch(child_type=B_BACKEND, child_slot=2, startup_data=0x000000016f8c5240, startup_data_len=24, client_sock=0x000000016f8c47b0) at launch_backend.c:290:3 [05:15:58.764] frame #22: 0x00000001007da504 postgres`ServerLoop [inlined] BackendStartup(client_sock=0x000000016f8c47b0) at postmaster.c:3590:8 [05:15:58.764] frame #23: 0x00000001007da468 postgres`ServerLoop at postmaster.c:1705:6 [05:15:58.764] frame #24: 0x00000001007d87f0 postgres`PostmasterMain(argc=, argv=) at postmaster.c:1403:11 [05:15:58.764] frame #25: 0x00000001007256fc postgres`main(argc=4, argv=0x00006000013f0bd0) at main.c:231:4 [05:15:58.764] frame #26: 0x0000000185727154 dyld`start + 2476 [05:15:58.764] (lldb) quit [05:15:58.844] -e [05:15:58.844] [05:15:58.844] [05:15:59.213] (lldb) target create --core "/Users/admin/cores/core.15558" [05:16:45.445] Core file '/Users/admin/cores/core.15558' (arm64) was loaded. [05:16:45.445] (lldb) thread backtrace all [05:16:46.973] warning: could not execute support code to read Objective-C class data in the process. This may reduce the quality of type information available. [05:16:46.973] [05:16:46.982] * thread #1 [05:16:46.982] * frame #0: 0x0000000185a7a5d0 libsystem_kernel.dylib`__pthread_kill + 8 [05:16:46.982] frame #1: 0x0000000185ab2c20 libsystem_pthread.dylib`pthread_kill + 288 [05:16:46.982] frame #2: 0x00000001859bfa30 libsystem_c.dylib`abort + 180 [05:16:46.982] frame #3: 0x00000001048b8cac postgres`ExceptionalCondition(conditionName=, fileName=, lineNumber=1068) at assert.c:66:2 [05:16:46.982] frame #4: 0x00000001044aca4c postgres`_bt_swap_posting(newitem=, oposting=, postingoff=1) at nbtdedup.c:1068:2 [05:16:46.982] frame #5: 0x00000001044adef8 postgres`_bt_insertonpg(rel=0x0000000130110138, heaprel=0x000000013003c178, itup_key=0x00000001458305b8, buf=12593, cbuf=0, stack=0x0000000145830668, itup=0x0000000145830eb8, itemsz=16, newitemoff=3, postingoff=1, split_only_page=) at nbtinsert.c:1197:14 [05:16:46.982] frame #6: 0x00000001044ad894 postgres`_bt_doinsert(rel=, itup=0x0000000145830648, checkUnique=UNIQUE_CHECK_NO, indexUnchanged=false, heapRel=) at nbtinsert.c:261:3 [05:16:46.982] frame #7: 0x00000001044b8b38 postgres`btinsert(rel=0x0000000130110138, values=, isnull=, ht_ctid=0x0000000124053120, heapRel=, checkUnique=, indexUnchanged=, indexInfo=) at nbtree.c:215:11 [05:16:46.982] frame #8: 0x00000001045c9a2c postgres`ExecInsertIndexTuples(resultRelInfo=0x0000000124051810, slot=, estate=, update=, noDupErr=, specConflict=, arbiterIndexes=, onlySummarizing=) at execIndexing.c:449:4 [05:16:46.982] frame #9: 0x00000001045fbea4 postgres`ExecInsert(context=0x000000016b9c4048, resultRelInfo=0x0000000124051810, slot=0x00000001240530f0, canSetTag=true, inserted_tuple=0x0000000000000000, insert_destrel=0x0000000000000000) at nodeModifyTable.c:1240:22 [05:16:46.982] frame #10: 0x00000001045fa310 postgres`ExecModifyTable(pstate=0x0000000124051600) at nodeModifyTable.c:4468:12 [05:16:46.982] frame #11: 0x00000001045cb124 postgres`standard_ExecutorRun [inlined] ExecProcNode(node=0x0000000124051600) at executor.h:315:9 [05:16:46.982] frame #12: 0x00000001045cb108 postgres`standard_ExecutorRun [inlined] ExecutePlan(queryDesc=0x000000012404a300, operation=CMD_INSERT, sendTuples=false, numberTuples=0, direction=, dest=0x000000014580b548) at execMain.c:1678:10 [05:16:46.982] frame #13: 0x00000001045cb0b8 postgres`standard_ExecutorRun(queryDesc=0x000000012404a300, direction=, count=0) at execMain.c:366:3 [05:16:46.982] frame #14: 0x00000001045caff4 postgres`ExecutorRun(queryDesc=, direction=, count=) at execMain.c:303:3 [artificial] [05:16:46.982] frame #15: 0x0000000104783ff4 postgres`ProcessQuery(plan=0x0000000144839ca8, sourceText="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;", params=0x0000000000000000, queryEnv=0x0000000000000000, dest=0x000000014580b548, qc=0x000000016b9c4408) at pquery.c:161:2 [05:16:46.982] frame #16: 0x00000001047836e0 postgres`PortalRunMulti(portal=0x0000000144829700, isTopLevel=true, setHoldSnapshot=false, dest=0x000000014580b548, altdest=0x000000014580b548, qc=0x000000016b9c4408) at pquery.c:0 [05:16:46.982] frame #17: 0x0000000104783064 postgres`PortalRun(portal=0x0000000144829700, count=9223372036854775807, isTopLevel=true, dest=0x000000014580b548, altdest=0x000000014580b548, qc=0x000000016b9c4408) at pquery.c:788:5 [05:16:46.982] frame #18: 0x0000000104782014 postgres`exec_simple_query(query_string="INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;") at postgres.c:1274:10 [05:16:46.982] frame #19: 0x000000010477f260 postgres`PostgresMain(dbname=, username=) at postgres.c:0:24 [05:16:46.982] frame #20: 0x000000010477ac84 postgres`BackendMain(startup_data=, startup_data_len=) at backend_startup.c:124:2 [05:16:46.982] frame #21: 0x00000001046d6240 postgres`postmaster_child_launch(child_type=B_BACKEND, child_slot=1, startup_data=0x000000016b9c52b0, startup_data_len=24, client_sock=0x000000016b9c4820) at launch_backend.c:290:3 [05:16:46.982] frame #22: 0x00000001046da504 postgres`ServerLoop [inlined] BackendStartup(client_sock=0x000000016b9c4820) at postmaster.c:3590:8 [05:16:46.983] frame #23: 0x00000001046da468 postgres`ServerLoop at postmaster.c:1705:6 [05:16:46.983] frame #24: 0x00000001046d87f0 postgres`PostmasterMain(argc=, argv=) at postmaster.c:1403:11 [05:16:46.983] frame #25: 0x00000001046256fc postgres`main(argc=8, argv=0x0000600000394370) at main.c:231:4 [05:16:46.983] frame #26: 0x0000000185727154 dyld`start + 2476 [05:16:46.983] (lldb) quit [05:16:47.005] -e [05:16:47.005] [05:16:47.005] [05:16:47.360] (lldb) target create --core "/Users/admin/cores/core.14935" [05:17:30.029] Core file '/Users/admin/cores/core.14935' (arm64) was loaded. [05:17:30.029] (lldb) thread backtrace all [05:17:32.519] warning: could not execute support code to read Objective-C class data in the process. This may reduce the quality of type information available. [05:17:32.519] [05:17:32.530] * thread #1 [05:17:32.530] * frame #0: 0x0000000185a7a5d0 libsystem_kernel.dylib`__pthread_kill + 8 [05:17:32.530] frame #1: 0x0000000185ab2c20 libsystem_pthread.dylib`pthread_kill + 288 [05:17:32.530] frame #2: 0x00000001859bfa30 libsystem_c.dylib`abort + 180 [05:17:32.530] frame #3: 0x000000010093ccac postgres`ExceptionalCondition(conditionName=, fileName=, lineNumber=1068) at assert.c:66:2 [05:17:32.530] frame #4: 0x0000000100530a4c postgres`_bt_swap_posting(newitem=, oposting=, postingoff=172) at nbtdedup.c:1068:2 [05:17:32.530] frame #5: 0x0000000100531ef8 postgres`_bt_insertonpg(rel=0x000000016008fa78, heaprel=0x000000016008e748, itup_key=0x000000013900d628, buf=2241, cbuf=0, stack=0x000000013900d738, itup=0x000000013900d758, itemsz=24, newitemoff=3, postingoff=172, split_only_page=) at nbtinsert.c:1197:14 [05:17:32.530] frame #6: 0x0000000100531894 postgres`_bt_doinsert(rel=, itup=0x000000013900d5f8, checkUnique=UNIQUE_CHECK_NO, indexUnchanged=false, heapRel=) at nbtinsert.c:261:3 [05:17:32.530] frame #7: 0x000000010053cb38 postgres`btinsert(rel=0x000000016008fa78, values=, isnull=, ht_ctid=0x00000001390297dc, heapRel=, checkUnique=, indexUnchanged=, indexInfo=) at nbtree.c:215:11 [05:17:32.530] frame #8: 0x00000001005a7988 postgres`CatalogIndexInsert(indstate=0x000000013900d238, heapTuple=0x00000001390297d8, updateIndexes=TU_All) at indexing.c:170:3 [05:17:32.530] frame #9: 0x00000001005a7c34 postgres`CatalogTuplesMultiInsertWithInfo(heapRel=0x000000016008e748, slot=, ntuples=, indstate=0x000000013900d238) at indexing.c:294:3 [05:17:32.530] frame #10: 0x00000001005b8dac postgres`recordMultipleDependencies(depender=0x000000016f93faf0, referenced=, nreferenced=, behavior=) at pg_depend.c:157:3 [05:17:32.530] frame #11: 0x000000010059e5a8 postgres`record_object_address_dependencies(depender=, referenced=, behavior=) at dependency.c:2773:2 [artificial] [05:17:32.530] frame #12: 0x00000001005bd4b8 postgres`ProcedureCreate(procedureName="ctoast_large_val", procNamespace=2200, replace=, returnsSet=false, returnType=25, proowner=10, languageObjectId=14, languageValidator=2248, prosrc=" select string_agg(encode(sha256(g::text::bytea),'hex'), '')::text from generate_series(1, 133) g ", probin=0x0000000000000000, prosqlbody=0x0000000000000000, prokind=, security_definer=, isLeakProof=, isStrict=, volatility=, parallel=, parameterTypes=0x00000001390298e8, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0000000000000000, trftypes=0, trfoids=0x0000000000000000, proconfig=0, prosupport=0, procost=, prorows=) at pg_proc.c:661:2 [05:17:32.530] frame #13: 0x00000001005f1d00 postgres`CreateFunction(pstate=0x0000000159013100, stmt=0x000000013903fa30) at functioncmds.c:1274:9 [05:17:32.530] frame #14: 0x0000000100809a38 postgres`ProcessUtilitySlow(pstate=0x0000000159013100, pstmt=0x000000013903cf00, queryString="\n CREATE OR REPLACE FUNCTION blurt_and_lock_123(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_123() called for % in session %', $1, current_setting('spec.session')::int;\n\n\t-- depending on lock state, wait for lock 2 or 3\n IF pg_try_advisory_xact_lock(current_setting('spec.session')::int, 1) THEN\n RAISE NOTICE 'acquiring advisory lock on 2';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 2);\n ELSE\n RAISE NOTICE 'acquiring advisory lock on 3';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 3);\n END IF;\n RETURN $1;\n END;$$;\n\n CREATE OR REPLACE FUNCTION blurt_and_lock_4(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_4() called for % in session %', $1, current_setting('spec.session')::int;\n RAISE NOTICE 'acquiring advisory lock on 4';\n PERFORM pg_advisory_xact_lock(current_set"..., context=PROCESS_UTILITY_TOPLEVEL, params=0x0000000000000000, queryEnv=0x0000000000000000, dest=, qc=0x000000016f9403f8) at utility.c:1649:15 [05:17:32.530] frame #15: 0x00000001008086c8 postgres`standard_ProcessUtility(pstmt=0x000000013903cf00, queryString="\n CREATE OR REPLACE FUNCTION blurt_and_lock_123(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_123() called for % in session %', $1, current_setting('spec.session')::int;\n\n\t-- depending on lock state, wait for lock 2 or 3\n IF pg_try_advisory_xact_lock(current_setting('spec.session')::int, 1) THEN\n RAISE NOTICE 'acquiring advisory lock on 2';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 2);\n ELSE\n RAISE NOTICE 'acquiring advisory lock on 3';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 3);\n END IF;\n RETURN $1;\n END;$$;\n\n CREATE OR REPLACE FUNCTION blurt_and_lock_4(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_4() called for % in session %', $1, current_setting('spec.session')::int;\n RAISE NOTICE 'acquiring advisory lock on 4';\n PERFORM pg_advisory_xact_lock(current_set"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=0x0000000000000000, dest=0x000000013903d2c0, qc=) at utility.c:0 [05:17:32.530] frame #16: 0x0000000100808298 postgres`ProcessUtility(pstmt=, queryString=, readOnlyTree=, context=, params=, queryEnv=, dest=, qc=) at utility.c:523:3 [artificial] [05:17:32.530] frame #17: 0x0000000100807ef4 postgres`PortalRunUtility(portal=0x0000000139024b00, pstmt=0x000000013903cf00, isTopLevel=true, setHoldSnapshot=false, dest=0x000000013903d2c0, qc=0x000000016f9403f8) at pquery.c:1153:2 [05:17:32.530] frame #18: 0x0000000100807664 postgres`PortalRunMulti(portal=0x0000000139024b00, isTopLevel=true, setHoldSnapshot=false, dest=0x000000013903d2c0, altdest=0x000000013903d2c0, qc=0x000000016f9403f8) at pquery.c:0 [05:17:32.530] frame #19: 0x0000000100807064 postgres`PortalRun(portal=0x0000000139024b00, count=9223372036854775807, isTopLevel=true, dest=0x000000013903d2c0, altdest=0x000000013903d2c0, qc=0x000000016f9403f8) at pquery.c:788:5 [05:17:32.530] frame #20: 0x0000000100806014 postgres`exec_simple_query(query_string="\n CREATE OR REPLACE FUNCTION blurt_and_lock_123(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_123() called for % in session %', $1, current_setting('spec.session')::int;\n\n\t-- depending on lock state, wait for lock 2 or 3\n IF pg_try_advisory_xact_lock(current_setting('spec.session')::int, 1) THEN\n RAISE NOTICE 'acquiring advisory lock on 2';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 2);\n ELSE\n RAISE NOTICE 'acquiring advisory lock on 3';\n PERFORM pg_advisory_xact_lock(current_setting('spec.session')::int, 3);\n END IF;\n RETURN $1;\n END;$$;\n\n CREATE OR REPLACE FUNCTION blurt_and_lock_4(text) RETURNS text IMMUTABLE LANGUAGE plpgsql AS $$\n BEGIN\n RAISE NOTICE 'blurt_and_lock_4() called for % in session %', $1, current_setting('spec.session')::int;\n RAISE NOTICE 'acquiring advisory lock on 4';\n PERFORM pg_advisory_xact_lock(current_set"...) at postgres.c:1274:10 [05:17:32.530] frame #21: 0x0000000100803260 postgres`PostgresMain(dbname=, username=) at postgres.c:0:24 [05:17:32.530] frame #22: 0x00000001007fec84 postgres`BackendMain(startup_data=, startup_data_len=) at backend_startup.c:124:2 [05:17:32.530] frame #23: 0x000000010075a240 postgres`postmaster_child_launch(child_type=B_BACKEND, child_slot=6, startup_data=0x000000016f9412a0, startup_data_len=24, client_sock=0x000000016f940810) at launch_backend.c:290:3 [05:17:32.530] frame #24: 0x000000010075e504 postgres`ServerLoop [inlined] BackendStartup(client_sock=0x000000016f940810) at postmaster.c:3590:8 [05:17:32.530] frame #25: 0x000000010075e468 postgres`ServerLoop at postmaster.c:1705:6 [05:17:32.530] frame #26: 0x000000010075c7f0 postgres`PostmasterMain(argc=, argv=) at postmaster.c:1403:11 [05:17:32.530] frame #27: 0x00000001006a96fc postgres`main(argc=8, argv=0x0000600001f4c550) at main.c:231:4 [05:17:32.530] frame #28: 0x0000000185727154 dyld`start + 2476 [05:17:32.530] (lldb) quit