[08:18:04.813] src/tools/ci/cores_backtrace.sh linux /tmp/cores [08:18:05.005] dumping /tmp/cores/postgres-6-27662.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:18:05.249] [New LWP 27662] [08:18:05.249] [08:18:05.249] This GDB supports auto-downloading debuginfo from the following URLs: [08:18:05.249] [08:18:05.249] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:18:05.249] Debuginfod has been disabled. [08:18:05.249] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:18:05.373] [Thread debugging using libthread_db enabled] [08:18:05.373] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:18:05.373] Core was generated by `postgres: postgres regression [local] SELECT '. [08:18:05.373] Program terminated with signal SIGABRT, Aborted. [08:18:05.373] #0 0x00007f8f138a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:05.515] [08:18:05.515] Thread 1 (Thread 0x7f8f11839040 (LWP 27662)): [08:18:05.515] #0 0x00007f8f138a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:05.515] No symbol table info available. [08:18:05.515] #1 0x00007f8f1385afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:05.515] No symbol table info available. [08:18:05.515] #2 0x00007f8f13845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:05.515] No symbol table info available. [08:18:05.515] #3 0x000055b6156ab316 in ExceptionalCondition (conditionName=conditionName@entry=0x55b6158eace0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x55b6158ea808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [08:18:05.515] No locals. [08:18:05.515] #4 0x000055b614d87d59 in _bt_checkkeys (scan=scan@entry=0x55b6494459d8, pstate=pstate@entry=0x7fff029bdc80, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7f8f0a8a6fe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [08:18:05.515] tupdesc = 0x7f8f073d2538 [08:18:05.515] so = [08:18:05.515] dir = BackwardScanDirection [08:18:05.515] ikey = 0 [08:18:05.515] res = [08:18:05.515] #5 0x000055b614d74fea in _bt_readpage (scan=scan@entry=0x55b6494459d8, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [08:18:05.515] iid = 0x7f8f0a8a5018 [08:18:05.515] itup = 0x7f8f0a8a6fe0 [08:18:05.515] tuple_alive = true [08:18:05.515] passes_quals = [08:18:05.515] rel = [08:18:05.515] so = 0x55b6494a0938 [08:18:05.515] page = [08:18:05.515] opaque = [08:18:05.515] minoff = 1 [08:18:05.515] maxoff = [08:18:05.515] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7f8f0a8a6fe0, page = 0x7f8f0a8a5000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [08:18:05.515] arrayKeys = true [08:18:05.515] itemIndex = 1357 [08:18:05.515] indnatts = 2 [08:18:05.515] #6 0x000055b614d75eb6 in _bt_readfirstpage (scan=scan@entry=0x55b6494459d8, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [08:18:05.515] so = 0x55b6494a0938 [08:18:05.515] #7 0x000055b614d796dd in _bt_first (scan=scan@entry=0x55b6494459d8, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [08:18:05.515] rel = 0x7f8f073d18b8 [08:18:05.515] so = 0x55b6494a0938 [08:18:05.515] stack = [08:18:05.515] offnum = [08:18:05.515] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = true, backward = true, scantid = 0x0, keysz = 2, scankeys = {{sk_flags = 458849, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b614d513fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55b6494580d0, fn_expr = 0x55b64949eb28}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x55b614d513fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55b6494580d0, fn_expr = 0x55b64949eb78}, sk_argument = 500}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 43772000, sk_collation = 32767, sk_func = {fn_addr = 0x55b649475b18, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b6494ca278, fn_mcxt = 0x55b6151159c1 , fn_expr = 0x55b6494ca278}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 359261063, sk_collation = 21942, sk_func = {fn_addr = 0x55b6494ca958, fn_oid = 358603823, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94241401821976}, {sk_flags = 43772368, sk_attno = 32767, sk_strategy = 0, sk_subtype = 0, sk_collation = 1083140096, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = 20, fn_retset = 64, fn_stats = 218 '\332', fn_extra = 0x55b6494ca278, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x4034000000000000}, sk_argument = 4572414629676717179}, {sk_flags = 43772320, sk_attno = 32767, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x55b649475618, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x4069000000000000, fn_mcxt = 0x55b6494c9858, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 358609882, sk_attno = 21942, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x55b649475708}, sk_argument = 94241402167928}, {sk_flags = 0, sk_attno = 0, sk_strategy = 257, sk_subtype = 359414906, sk_collation = 21942, sk_func = {fn_addr = 0x7fff029bea0c, fn_oid = 328667680, fn_nargs = 32655, fn_strict = false, fn_retset = false, fn_stats = 224 '\340', fn_extra = 0x0, fn_mcxt = 0x7fff029bead0, fn_expr = 0x55b649398190}, sk_argument = 1437}, {sk_flags = 1228502208, sk_attno = 21942, sk_strategy = 0, sk_subtype = 43772428, sk_collation = 32767, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x156, fn_mcxt = 0x55b6156c41fd , fn_expr = 0x3fd199999999999a}, sk_argument = 140733237160648}, {sk_flags = 43772608, sk_attno = 32767, sk_strategy = 0, sk_subtype = 1229756504, sk_collation = 21942, sk_func = {fn_addr = 0x55b6494ca278, fn_oid = 359261063, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x67f00000000, fn_mcxt = 0x55b649475708, fn_expr = 0x55b6494c9748}, sk_argument = 140733237160648}, {sk_flags = 43772608, sk_attno = 32767, sk_strategy = 0, sk_subtype = 1229756504, sk_collation = 21942, sk_func = {fn_addr = 0x55b61569e4ee , fn_oid = 342, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x55b6494c9c98, fn_mcxt = 0x55b6151187e6 , fn_expr = 0x55b6494cae70}, sk_argument = 4607182418800017408}, {sk_flags = 0, sk_attno = 0, sk_strategy = 49136, sk_subtype = 0, sk_collation = 1075052544, sk_func = {fn_addr = 0x4030000000000000, fn_oid = 2576980378, fn_nargs = -26215, fn_strict = 209, fn_retset = 63, fn_stats = 154 '\232', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x4014000000000000}, sk_argument = 0}, {sk_flags = 1229756232, sk_attno = 21942, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x55b6156eebd7 , fn_oid = 1227442352, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 122 'z', fn_extra = 0x7fff029beb8c, fn_mcxt = 0x7f8f13971220, fn_expr = 0x494ca278}, sk_argument = 0}, {sk_flags = 1229756504, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1228505488, sk_collation = 21942, sk_func = {fn_addr = 0x0, fn_oid = 1228502208, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 140 '\214', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 4620693217682128896}, {sk_flags = 359416317, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229757592, sk_collation = 21942, sk_func = {fn_addr = 0x7fff029bec10, fn_oid = 43772936, fn_nargs = 32767, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b6494ca278, fn_mcxt = 0x55b61569e387 , fn_expr = 0x400e79e79e79e79e}, sk_argument = 7142530613248}, {sk_flags = 1202590843, sk_attno = 31457, sk_strategy = 16244, sk_subtype = 3951369912, sk_collation = 1077661777, sk_func = {fn_addr = 0x7fff029bec10, fn_oid = 43772936, fn_nargs = 32767, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b61569e4ee , fn_mcxt = 0x55b6494ca278, fn_expr = 0x55b6494cb550}, sk_argument = 94241402166424}, {sk_flags = 353498278, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229413464, sk_collation = 21942, sk_func = {fn_addr = 0x3fb0000000000000, fn_oid = 3951369912, fn_nargs = -12207, fn_strict = 59, fn_retset = 64, fn_stats = 76 'L', fn_extra = 0x0, fn_mcxt = 0x4010000000000000, fn_expr = 0x3ff0000000000000}, sk_argument = 4617315517961601024}, {sk_flags = 1229757592, sk_attno = 21942, sk_strategy = 0, sk_subtype = 353497411, sk_collation = 21942, sk_func = {fn_addr = 0x55b6494c9c98, fn_oid = 0, fn_nargs = 0, fn_strict = 16, fn_retset = 64, fn_stats = 158 '\236', fn_extra = 0x3ff0000000000000, fn_mcxt = 0x400e79e79e79e79e, fn_expr = 0x40f0000000000000}, sk_argument = 4572414629676717179}, {sk_flags = -343597384, sk_attno = -12207, sk_strategy = 16443, sk_subtype = 0, sk_collation = 16777216, sk_func = {fn_addr = 0x55b6494c9c98, fn_oid = 1229759096, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x1, fn_mcxt = 0x55b6494ca278, fn_expr = 0x55b6494c9c98}, sk_argument = 94240525826941}, {sk_flags = 1227450248, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229762320, sk_collation = 21942, sk_func = {fn_addr = 0x1, fn_oid = 353594356, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x55b6494ca278, fn_mcxt = 0x55b6494ca278, fn_expr = 0x7fff029bedc8}, sk_argument = 94241402169448}, {sk_flags = 354194116, sk_attno = 21942, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b6156eebd7 , fn_mcxt = 0x55b6494580d0, fn_expr = 0x400}, sk_argument = 7}, {sk_flags = 359595288, sk_attno = 21942, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x7fff029beea0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94241401705872}, {sk_flags = 1229297032, sk_attno = 21942, sk_strategy = 0, sk_subtype = 359682082, sk_collation = 21942, sk_func = {fn_addr = 0x0, fn_oid = 352072390, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b649459488, fn_mcxt = 0x55b649459568, fn_expr = 0x55b614fc4562 }, sk_argument = 0}, {sk_flags = 1229419008, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229297032, sk_collation = 21942, sk_func = {fn_addr = 0x55b649459590, fn_oid = 6, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b6156eebd7 , fn_mcxt = 0x55b6494580d0, fn_expr = 0x40}, sk_argument = 9}, {sk_flags = 359058580, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229297040, sk_collation = 21942, sk_func = {fn_addr = 0x55b61566c6bb , fn_oid = 124250856, fn_nargs = 32655, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x7f8f0767eac0, fn_mcxt = 0x55b6492f9420, fn_expr = 0x55b6492f8d00}, sk_argument = 94240531482561}, {sk_flags = 1229297000, sk_attno = 21942, sk_strategy = 0, sk_subtype = 96, sk_collation = 0, sk_func = {fn_addr = 0x73, fn_oid = 1976, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x32029bf03f, fn_mcxt = 0x60, fn_expr = 0x73}, sk_argument = 140252281301760}, {sk_flags = 327905079, sk_attno = 32655, sk_strategy = 0, sk_subtype = 1229291728, sk_collation = 21942, sk_func = {fn_addr = 0x11030, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x0, fn_mcxt = 0x7f8f138b6f37, fn_expr = 0x6b0}, sk_argument = 8112}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 0, sk_func = {fn_addr = 0x55b64932ed00, fn_oid = 329194592, fn_nargs = 32655, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 94241401700816}, {sk_flags = 327908026, sk_attno = 32655, sk_strategy = 0, sk_subtype = 1229291728, sk_collation = 21942, sk_func = {fn_addr = 0x55b6156eebd7 , fn_oid = 1229291728, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x55b6156eedc2 , fn_expr = 0x55b6494580d0}, sk_argument = 16384}, {sk_flags = 1229298200, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229215120, sk_collation = 21942, sk_func = {fn_addr = 0x55b649459af8, fn_oid = 359594836, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x55b6156efd18 , fn_mcxt = 0x4932ed00, fn_expr = 0x55b6494a0938}, sk_argument = 94241401625048}}} [08:18:05.515] startKeys = {0x55b649445c28, 0x55b649445c70, 0x55b6492948b0, 0x8, 0x0, 0x55b6156efd18 , 0x29be760, 0x0, 0x0, 0x55b64929533e, 0x55b6492951d0, 0x55b649295337, 0x55b6492951d0, 0x7fff029bf338, 0x0, 0x55b6156eebd7 , 0x55b6492948b0, 0x40, 0x3, 0x55b6156e6bc2 , 0x55b6159af388, 0x55b64929534a, 0x55b6492951d0, 0x55b61584e3bb , 0x55b64929534d, 0x55b6492951d0, 0x55b64929534c, 0x0, 0x7fff029bf338, 0x55b615854b34 , 0x2, 0x3} [08:18:05.515] notnullkeys = {{sk_flags = 2, sk_attno = 21942, sk_strategy = 0, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 349510181, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 100 'd', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x55b64946ae10}, sk_argument = 94241400592560}, {sk_flags = 20151, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 349508210, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x55b64946ae10}, sk_argument = 94241400593768}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 349510181, sk_collation = 21942, sk_func = {fn_addr = 0x1000200000164, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b64946ae10, fn_mcxt = 0x550000000101, fn_expr = 0x0}, sk_argument = 281483566645249}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x55b614d51a25 , fn_oid = 1229763672, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x55b6494cb4e8, fn_mcxt = 0x55b64946ae10, fn_expr = 0x55b64934d008}, sk_argument = 20154}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b64946ae10, fn_oid = 1228314152, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x300030000, fn_mcxt = 0x3b600000000, fn_expr = 0x55b614d51156 }, sk_argument = 281483566646941}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b64946ae10, fn_oid = 1228314232, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3, fn_mcxt = 0x55b615447040 , fn_expr = 0x1}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 356806972, sk_collation = 21942, sk_func = {fn_addr = 0x0, fn_oid = 356001508, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0x55b64949eaa0, fn_mcxt = 0x1, fn_expr = 0x55b615447040 }, sk_argument = 257}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3, sk_collation = 0, sk_func = {fn_addr = 0x100030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 94241399851184}, {sk_flags = 1228224328, sk_attno = 21942, sk_strategy = 0, sk_subtype = 521, sk_collation = 0, sk_func = {fn_addr = 0x200030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 121 'y', fn_extra = 0x1000200000166, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 94241399851184}, {sk_flags = 1228224488, sk_attno = 21942, sk_strategy = 0, sk_subtype = 115, sk_collation = 0, sk_func = {fn_addr = 0x300030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 94241399851184}, {sk_flags = 1228224568, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1976, sk_collation = 0, sk_func = {fn_addr = 0x55b649296378, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 25 '\031', fn_extra = 0x2b000000000000, fn_mcxt = 0xff2009010022000f, fn_expr = 0x7fffff}, sk_argument = 7738712957726510775}, {sk_flags = 1953068895, sk_attno = 24424, sk_strategy = 30062, sk_subtype = 27756, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x89800000000}, sk_argument = 20153}, {sk_flags = 10, sk_attno = 2, sk_strategy = 0, sk_subtype = 20151, sk_collation = 0, sk_func = {fn_addr = 0x447b400000000008, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2, fn_mcxt = 0x55b649295ef8, fn_expr = 0x55b649295f40}, sk_argument = 15496242007575}, {sk_flags = 2, sk_attno = 0, sk_strategy = 43, sk_subtype = 539099150, sk_collation = 4280287489, sk_func = {fn_addr = 0x7fffff, fn_oid = 20148, fn_nargs = 31091, fn_strict = 115, fn_retset = 99, fn_stats = 111 'o', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x101}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 357849806, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x55b6492948b0}, sk_argument = 94241400604136}, {sk_flags = 1227445144, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1229763920, sk_collation = 21942, sk_func = {fn_addr = 0x100000e17, fn_oid = 3604, fn_nargs = 3606, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xff2001012022000d, fn_mcxt = 0x7fffff, fn_expr = 0x5f69776300004eb2}, sk_argument = 431349456737}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x55b614d51a25 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b6492948b0, fn_oid = 1228183728, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 186 '\272', fn_extra = 0x200030000, fn_mcxt = 0x3b600000000, fn_expr = 0x55b614d51272 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b6492948b0, fn_oid = 1228184936, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x55b614d51a25 , fn_mcxt = 0x1000000000101, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x55b614d51a25 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55b6492948b0, fn_expr = 0x55b649353748}, sk_argument = 521}, {sk_flags = 6553856, sk_attno = 0, sk_strategy = 0, sk_subtype = 3603, sk_collation = 1, sk_func = {fn_addr = 0xe1200000e10, fn_oid = 0, fn_nargs = 0, fn_strict = 43, fn_retset = false, fn_stats = 120 'x', fn_extra = 0x55b6494c9ac0, fn_mcxt = 0x55b6494c9b08, fn_expr = 0x695f615f74736574}, sk_argument = 30820}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 167 '\247', fn_extra = 0x89800000000, fn_mcxt = 0xe08, fn_expr = 0xe1c}, sk_argument = 94240528569411}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 372528944, sk_collation = 21942, sk_func = {fn_addr = 0x55b6494ca6b0, fn_oid = 356471301, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b614d3d636 , fn_mcxt = 0xe1200000e0f, fn_expr = 0x2b000000000003}, sk_argument = 18383699181318569994}, {sk_flags = 8388607, sk_attno = 0, sk_strategy = 0, sk_subtype = 20138, sk_collation = 1600747363, sk_func = {fn_addr = 0x55b615447040 , fn_oid = 1229760464, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2, fn_mcxt = 0x100030000, fn_expr = 0x3b600000000}, sk_argument = 94240530258638}, {sk_flags = 257, sk_attno = 0, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55b600000003, fn_oid = 196608, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b615545ace , fn_mcxt = 0x1000200000167, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1227442352, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1228270792, sk_collation = 21942, sk_func = {fn_addr = 0x55b61590ad51, fn_oid = 196608, fn_nargs = 2, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b614d51a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1227442352, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1227834600, sk_collation = 21942, sk_func = {fn_addr = 0x17, fn_oid = 196608, fn_nargs = 3, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55b614d51a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1227442352, sk_attno = 21942, sk_strategy = 0, sk_subtype = 1227834680, sk_collation = 21942, sk_func = {fn_addr = 0x17, fn_oid = 1229758408, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0x55b6159edf90, fn_mcxt = 0x55b61544e8e4 , fn_expr = 0x7fff029be5af}, sk_argument = 15876594137219203136}, {sk_flags = 2, sk_attno = 16384, sk_strategy = 0, sk_subtype = 2602, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 1227652336, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 175 '\257', fn_extra = 0x1, fn_mcxt = 0x2, fn_expr = 0x7f8f07866938}, sk_argument = 0}, {sk_flags = 356838185, sk_attno = 21942, sk_strategy = 0, sk_subtype = 2, sk_collation = 16384, sk_func = {fn_addr = 0xa2a, fn_oid = 362476424, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 91 '[', fn_extra = 0x55b6494cb018, fn_mcxt = 0x55b614d3d53b , fn_expr = 0x26eb806dd258a7e}, sk_argument = 94240532003752}, {sk_flags = -1408237226, sk_attno = 0, sk_strategy = 0, sk_subtype = 5, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 356806720, fn_nargs = 21942, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x55b61544713c }, sk_argument = 257}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x100030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 94241399851184}} [08:18:05.515] keysz = 2 [08:18:05.515] strat_total = 3 [08:18:05.515] blkno = 4294967295 [08:18:05.515] lastcurrblkno = 0 [08:18:05.515] __func__ = "_bt_first" [08:18:05.515] #8 0x000055b614d6fa8c in btgettuple (scan=0x55b6494459d8, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [08:18:05.515] so = 0x55b6494a0938 [08:18:05.515] res = [08:18:05.515] #9 0x000055b614d4f118 in index_getnext_tid (scan=scan@entry=0x55b6494459d8, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [08:18:05.515] found = [08:18:05.515] __func__ = "index_getnext_tid" [08:18:05.515] #10 0x000055b6150586b1 in IndexOnlyNext (node=node@entry=0x55b6494587a8) at ../src/backend/executor/nodeIndexonlyscan.c:121 [08:18:05.515] estate = 0x55b6494581d0 [08:18:05.515] econtext = 0x55b6494589b8 [08:18:05.515] direction = BackwardScanDirection [08:18:05.515] scandesc = 0x55b6494459d8 [08:18:05.515] slot = 0x55b649458bd8 [08:18:05.515] tid = [08:18:05.515] __func__ = "IndexOnlyNext" [08:18:05.515] #11 0x000055b61501104d in ExecScanFetch (recheckMtd=0x55b615057dfe , accessMtd=0x55b6150585e2 , epqstate=0x0, node=0x55b6494587a8) at ../src/include/executor/execScan.h:126 [08:18:05.515] No locals. [08:18:05.515] #12 ExecScanExtended (projInfo=0x55b649458f68, qual=0x0, epqstate=0x0, recheckMtd=0x55b615057dfe , accessMtd=0x55b6150585e2 , node=0x55b6494587a8) at ../src/include/executor/execScan.h:187 [08:18:05.515] slot = [08:18:05.515] econtext = 0x55b6494589b8 [08:18:05.515] econtext = [08:18:05.515] slot = [08:18:05.515] #13 ExecScan (node=node@entry=0x55b6494587a8, accessMtd=accessMtd@entry=0x55b6150585e2 , recheckMtd=recheckMtd@entry=0x55b615057dfe ) at ../src/backend/executor/execScan.c:59 [08:18:05.515] epqstate = 0x0 [08:18:05.515] qual = 0x0 [08:18:05.515] projInfo = 0x55b649458f68 [08:18:05.515] #14 0x000055b615058247 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [08:18:05.515] node = 0x55b6494587a8 [08:18:05.515] #15 0x000055b6150098a2 in ExecProcNodeFirst (node=0x55b6494587a8) at ../src/backend/executor/execProcnode.c:469 [08:18:05.515] No locals. [08:18:05.515] #16 0x000055b615060fa6 in ExecProcNode (node=node@entry=0x55b6494587a8) at ../src/include/executor/executor.h:341 [08:18:05.515] No locals. [08:18:05.515] #17 0x000055b6150618a0 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [08:18:05.515] node = 0x55b649458438 [08:18:05.515] econtext = 0x55b649458648 [08:18:05.515] direction = [08:18:05.515] slot = [08:18:05.515] outerPlan = 0x55b6494587a8 [08:18:05.515] __func__ = "ExecLimit" [08:18:05.515] #18 0x000055b6150098a2 in ExecProcNodeFirst (node=0x55b649458438) at ../src/backend/executor/execProcnode.c:469 [08:18:05.515] No locals. [08:18:05.515] #19 0x000055b614ff337c in ExecProcNode (node=node@entry=0x55b649458438) at ../src/include/executor/executor.h:341 [08:18:05.515] No locals. [08:18:05.515] #20 0x000055b614ff3ecc in ExecutePlan (queryDesc=queryDesc@entry=0x55b64946af10, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55b6494765e0) at ../src/backend/executor/execMain.c:1783 [08:18:05.515] estate = 0x55b6494581d0 [08:18:05.515] planstate = 0x55b649458438 [08:18:05.515] use_parallel_mode = false [08:18:05.515] slot = [08:18:05.515] current_tuple_count = 0 [08:18:05.515] #21 0x000055b614ff5587 in standard_ExecutorRun (queryDesc=0x55b64946af10, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:435 [08:18:05.515] estate = 0x55b6494581d0 [08:18:05.515] operation = CMD_SELECT [08:18:05.515] dest = 0x55b6494765e0 [08:18:05.515] sendTuples = [08:18:05.515] oldcontext = 0x55b64946ae10 [08:18:05.515] #22 0x000055b614ff55e7 in ExecutorRun (queryDesc=queryDesc@entry=0x55b64946af10, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:371 [08:18:05.515] No locals. [08:18:05.515] #23 0x000055b61540d759 in PortalRunSelect (portal=portal@entry=0x55b649319f20, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55b6494765e0) at ../src/backend/tcop/pquery.c:953 [08:18:05.515] queryDesc = 0x55b64946af10 [08:18:05.515] direction = [08:18:05.515] nprocessed = [08:18:05.515] __func__ = "PortalRunSelect" [08:18:05.515] #24 0x000055b615410dad in PortalRun (portal=portal@entry=0x55b649319f20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55b6494765e0, altdest=altdest@entry=0x55b6494765e0, qc=qc@entry=0x7fff029bf490) at ../src/backend/tcop/pquery.c:797 [08:18:05.515] _save_exception_stack = 0x7fff029bf540 [08:18:05.515] _save_context_stack = 0x0 [08:18:05.515] _local_sigjmp_buf = {{__jmpbuf = {0, -6449452595502771701, 94241400397600, 94241399856344, 94241399856320, 94241399856272, -942265308065426933, -6449637334200741365}, __mask_was_saved = 0, __saved_mask = {__val = {94240532003752, 43775007, 4, 94241399856272, 112, 179, 94241400397600, 94241399856344, 94241399856320, 94241399856272, 94240532091323, 179, 2, 179, 94240521141219, 0}}}} [08:18:05.515] _do_rethrow = [08:18:05.515] result = [08:18:05.515] nprocessed = [08:18:05.515] saveTopTransactionResourceOwner = 0x55b6492d7ce8 [08:18:05.515] saveTopTransactionContext = 0x55b64932ebd0 [08:18:05.515] saveActivePortal = 0x0 [08:18:05.515] saveResourceOwner = 0x55b6492d7ce8 [08:18:05.515] savePortalContext = 0x0 [08:18:05.515] saveMemoryContext = 0x55b64932ebd0 [08:18:05.515] __func__ = "PortalRun" [08:18:05.515] #25 0x000055b615409956 in exec_simple_query (query_string=query_string@entry=0x55b6492949b0 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;") at ../src/backend/tcop/postgres.c:1274 [08:18:05.515] cmdtaglen = 6 [08:18:05.515] snapshot_set = [08:18:05.515] per_parsetree_context = 0x0 [08:18:05.515] plantree_list = 0x55b649476fd0 [08:18:05.515] parsetree = 0x55b649295c90 [08:18:05.515] commandTag = [08:18:05.515] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:18:05.515] querytree_list = [08:18:05.515] portal = 0x55b649319f20 [08:18:05.515] receiver = 0x55b6494765e0 [08:18:05.515] format = 0 [08:18:05.515] cmdtagname = [08:18:05.515] parsetree_item__state = [08:18:05.515] dest = DestRemote [08:18:05.515] oldcontext = 0x55b64932ebd0 [08:18:05.515] parsetree_list = 0x55b649295cc0 [08:18:05.515] parsetree_item = 0x55b649295cd8 [08:18:05.515] save_log_statement_stats = false [08:18:05.515] was_logged = false [08:18:05.515] use_implicit_block = false [08:18:05.515] msec_str = "`\036\a\026\266U\000\000#\027m\025\266U\000\000 \365\233\002\377\177\000\000m\000\000\000\000\000\000" [08:18:05.515] __func__ = "exec_simple_query" [08:18:05.515] #26 0x000055b61540cb7a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4759 [08:18:05.515] query_string = 0x55b6492949b0 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [08:18:05.515] firstchar = [08:18:05.515] input_message = {data = 0x55b6492949b0 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [08:18:05.515] local_sigjmp_buf = {{__jmpbuf = {94240545030360, -6449629734013365749, 140733237163792, 94240541974112, 24, 4, -942265307998318069, -6449637318981578229}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94241399580896, 17408, 94240545024416, 94241400116368, 24, 94240532003668, 0, 10, 2, 94240545030368, 94241399580896, 94240545024416, 94240541974112, 24, 4}}}} [08:18:05.515] send_ready_for_query = false [08:18:05.515] idle_in_transaction_timeout_enabled = false [08:18:05.515] idle_session_timeout_enabled = false [08:18:05.515] __func__ = "PostgresMain" [08:18:05.515] #27 0x000055b615402511 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [08:18:05.515] bsdata = [08:18:05.515] #28 0x000055b6152a2c8c in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x7fff029bf6a0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff029bf710) at ../src/backend/postmaster/launch_backend.c:290 [08:18:05.515] pid = [08:18:05.515] #29 0x000055b6152a8249 in BackendStartup (client_sock=client_sock@entry=0x7fff029bf710) at ../src/backend/postmaster/postmaster.c:3580 [08:18:05.515] bn = 0x55b6492bcfb8 [08:18:05.515] pid = [08:18:05.515] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796723848406274, fork_started = 796723848406282} [08:18:05.515] cac = [08:18:05.515] __func__ = "BackendStartup" [08:18:05.515] #30 0x000055b6152aa734 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [08:18:05.515] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\203\023\217\177\000\000\320d\331\024\217\177\000\000\270\367\233\002\377\177\000\000\264\367\233\002\377\177", '\000' , "\351`>\024\266U\000\000\320+:\024\266U\000\000\200\370\233\002\377\177\000\000x\370\233\002\377\177\000\000\225[\362\001\000\000\000\000\250\304\322\024\217\177\000\000,", '\000' , "\266U\000\000\367_>\024\266U\000", __ss_align = 140252511106664}, salen = 2}} [08:18:05.515] i = 0 [08:18:05.515] now = [08:18:05.515] last_lockfile_recheck_time = 1743408640 [08:18:05.515] last_touch_time = 1743408640 [08:18:05.515] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 149, user_data = 0x0}, {pos = 354055784, events = 32655, fd = 349357632, user_data = 0x7f8f151a72e0}, {pos = 2090263927, events = 0, fd = 43776256, user_data = 0x7f8f1517ca48}, {pos = 16, events = 0, fd = 349357632, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f8f151a72e0}, {pos = 43776120, events = 32767, fd = 43776128, user_data = 0x7f8f151a7668}, {pos = 0, events = 0, fd = 32768, user_data = 0x96}, {pos = 1227450016, events = 21942, fd = 1, user_data = 0x7fff029bfda3}, {pos = -1, events = 0, fd = 327344160, user_data = 0x7f8f14d964d0}, {pos = 1227630840, events = 21942, fd = 1227630552, user_data = 0x55b6492c25b1}, {pos = 353906366, events = 32655, fd = 1, user_data = 0x7f8f151a72e0}, {pos = 430, events = 0, fd = 365362544, user_data = 0x0}, {pos = 0, events = 0, fd = 249, user_data = 0x7f8f15182ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8f1382e020}, {pos = 328150656, events = 32655, fd = 16, user_data = 0x7fff029bfcc0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 353915578, events = 32655, fd = 0, user_data = 0x7f8f138aedd4 }, {pos = 0, events = 0, fd = 372516736, user_data = 0x2}, {pos = 0, events = 0, fd = 1227188608, user_data = 0x55b61539e10c }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 1227442800, user_data = 0x7f8f15182ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8f138364c8}, {pos = 327905437, events = 32655, fd = 372613056, user_data = 0x55b6492c73d0}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 329194592, events = 32655, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a5852}, {pos = 822763892, events = 875770935, fd = 875968560, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f8f138b58ee}, {pos = 329177568, events = 32655, fd = 327815534, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1227631072, user_data = 0xadbf3a37e652a200}, {pos = 329180640, events = 32655, fd = -328, user_data = 0x0}, {pos = 1227630232, events = 21942, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x65ec}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = 328151187, events = 32655, fd = 1227630032, user_data = 0x1}, {pos = 1227630232, events = 21942, fd = 1024, user_data = 0x7fff029bfd98}, {pos = 359674187, events = 21942, fd = 372621456, user_data = 0x55b6156f1c08 }, {pos = 1227630032, events = 21942, fd = 1227442352, user_data = 0x55b6492c25d0}, {pos = 327899374, events = 32655, fd = 0, user_data = 0x55b615703872 }, {pos = 1227630032, events = 1, fd = 359676347, user_data = 0x55b6492948b0}, {pos = 327822001, events = 32655, fd = 327816432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -430792192, events = 2914990647, fd = 1227188608, user_data = 0xadbf3a37e652a200}, {pos = 13, events = 0, fd = -430792192, user_data = 0x0}, {pos = 327529017, events = 32655, fd = 0, user_data = 0x55b6152a2972 }, {pos = 4194304, events = 0, fd = 1227276256, user_data = 0x1}, {pos = 0, events = 0, fd = 1227188608, user_data = 0x55b6156f1a9c }, {pos = 1227276256, events = 21942, fd = 1227442352, user_data = 0x55b64926bfe0}, {pos = 1, events = 0, fd = 0, user_data = 0x55b6156afc9c }, {pos = 13, events = 0, fd = 1227621368, user_data = 0x55b6492c03d8}, {pos = 372518168, events = 21942, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 355085100, user_data = 0x55b6492948b0}, {pos = 355102001, events = 21942, fd = 368831600, user_data = 0x55b649295288}} [08:18:05.515] nevents = 1 [08:18:05.515] __func__ = "ServerLoop" [08:18:05.515] #31 0x000055b6152abf98 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55b649252840) at ../src/backend/postmaster/postmaster.c:1399 [08:18:05.515] opt = [08:18:05.515] status = [08:18:05.515] userDoption = [08:18:05.515] listen_addr_saved = false [08:18:05.515] output_config_variable = [08:18:05.515] __func__ = "PostmasterMain" [08:18:05.515] #32 0x000055b6150daf89 in main (argc=8, argv=0x55b649252840) at ../src/backend/main/main.c:227 [08:18:05.515] do_check_root = [08:18:05.515] dispatch_option = [08:18:05.535] -e [08:18:05.535] [08:18:05.535] [08:18:05.625] dumping /tmp/cores/postgres-6-37750.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:18:05.873] [New LWP 37750] [08:18:05.873] [08:18:05.873] This GDB supports auto-downloading debuginfo from the following URLs: [08:18:05.873] [08:18:05.873] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:18:05.873] Debuginfod has been disabled. [08:18:05.873] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:18:05.979] [Thread debugging using libthread_db enabled] [08:18:05.979] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:18:05.979] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [08:18:05.979] Program terminated with signal SIGABRT, Aborted. [08:18:05.979] #0 0x00007f5f5e4a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.125] [08:18:06.125] Thread 1 (Thread 0x7f5f5e3d4040 (LWP 37750)): [08:18:06.125] #0 0x00007f5f5e4a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.125] No symbol table info available. [08:18:06.125] #1 0x00007f5f5e45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.125] No symbol table info available. [08:18:06.125] #2 0x00007f5f5e445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.125] No symbol table info available. [08:18:06.125] #3 0x00005609f30be316 in ExceptionalCondition (conditionName=conditionName@entry=0x5609f32fdce0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x5609f32fd808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [08:18:06.125] No locals. [08:18:06.125] #4 0x00005609f279ad59 in _bt_checkkeys (scan=scan@entry=0x560a2f523088, pstate=pstate@entry=0x7ffdbbf15510, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7f5f5a08dfe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [08:18:06.125] tupdesc = 0x7f5f59a3b738 [08:18:06.125] so = [08:18:06.125] dir = BackwardScanDirection [08:18:06.125] ikey = 0 [08:18:06.125] res = [08:18:06.125] #5 0x00005609f2787fea in _bt_readpage (scan=scan@entry=0x560a2f523088, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [08:18:06.125] iid = 0x7f5f5a08c018 [08:18:06.125] itup = 0x7f5f5a08dfe0 [08:18:06.125] tuple_alive = true [08:18:06.125] passes_quals = [08:18:06.125] rel = [08:18:06.125] so = 0x560a2f544638 [08:18:06.125] page = [08:18:06.125] opaque = [08:18:06.125] minoff = 1 [08:18:06.125] maxoff = [08:18:06.125] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7f5f5a08dfe0, page = 0x7f5f5a08c000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [08:18:06.125] arrayKeys = true [08:18:06.125] itemIndex = 1357 [08:18:06.125] indnatts = 2 [08:18:06.125] #6 0x00005609f2788eb6 in _bt_readfirstpage (scan=scan@entry=0x560a2f523088, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [08:18:06.125] so = 0x560a2f544638 [08:18:06.125] #7 0x00005609f278c6dd in _bt_first (scan=scan@entry=0x560a2f523088, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [08:18:06.125] rel = 0x7f5f59a3aab8 [08:18:06.125] so = 0x560a2f544638 [08:18:06.125] stack = [08:18:06.125] offnum = [08:18:06.125] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = true, backward = true, scantid = 0x0, keysz = 2, scankeys = {{sk_flags = 458849, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5609f27643fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x560a2f5a1540, fn_expr = 0x560a2f542828}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x5609f27643fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x560a2f5a1540, fn_expr = 0x560a2f542878}, sk_argument = 500}, {sk_flags = 793903672, sk_attno = 22026, sk_strategy = 0, sk_subtype = 3153158440, sk_collation = 32765, sk_func = {fn_addr = 0x7ffdbbf16120, fn_oid = 793911304, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 238 '\356', fn_extra = 0x156, fn_mcxt = 0x560a2f520238, fn_expr = 0x560a2f536ea8}, sk_argument = 94600726493158}, {sk_flags = 793998104, sk_attno = 22026, sk_strategy = 0, sk_subtype = 0, sk_collation = 1072693248, sk_func = {fn_addr = 0xbff0000000000000, fn_oid = 0, fn_nargs = 0, fn_strict = 20, fn_retset = 64, fn_stats = 0 '\000', fn_extra = 0x3fd199999999999a, fn_mcxt = 0x403b89999999999a, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 16404, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x560a2f520238, fn_oid = 0, fn_nargs = 0, fn_strict = 16, fn_retset = 64, fn_stats = 215 '\327', fn_extra = 0x560a2f359520, fn_mcxt = 0x5609f30d6c7a , fn_expr = 0x7ffdbbf161ec}, sk_argument = 140047581385248}, {sk_flags = 793908920, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x560a2f522008, fn_oid = 793099488, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x560a2f45b010, fn_mcxt = 0x7ffdbbf161ec, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 1075052544, sk_func = {fn_addr = 0x5609f30d71fd , fn_oid = 793996968, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 112 'p', fn_extra = 0x7ffdbbf16268, fn_mcxt = 0x0, fn_expr = 0x560a2f5216b8}, sk_argument = 94600732283783}, {sk_flags = -1431655765, sk_attno = -21846, sk_strategy = 16394, sk_subtype = 0, sk_collation = 1663, sk_func = {fn_addr = 0x3f747ae147ae147b, fn_oid = 3951369912, fn_nargs = -12207, fn_strict = 59, fn_retset = 64, fn_stats = 112 'p', fn_extra = 0x7ffdbbf16268, fn_mcxt = 0x0, fn_expr = 0x5609f30b14ee }, sk_argument = 94601743570616}, {sk_flags = 793999864, sk_attno = 22026, sk_strategy = 0, sk_subtype = 793996968, sk_collation = 22026, sk_func = {fn_addr = 0x5609f2b324a6 , fn_oid = 794002568, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x403bd051eb851eb8, fn_mcxt = 0x4015114757601b3a, fn_expr = 0x0}, sk_argument = 4616189618054758400}, {sk_flags = 0, sk_attno = 0, sk_strategy = 16368, sk_subtype = 0, sk_collation = 1075052544, sk_func = {fn_addr = 0x560a2f536ea8, fn_oid = 4071825731, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 168 '\250', fn_extra = 0x4010000000000000, fn_mcxt = 0x400aaaaaaaaaaaab, fn_expr = 0x3ff0000000000000}, sk_argument = 4614688418178968235}, {sk_flags = 0, sk_attno = 0, sk_strategy = 16624, sk_subtype = 1202590843, sk_collation = 1064598241, sk_func = {fn_addr = 0x403bd051eb851eb8, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = true, fn_stats = 168 '\250', fn_extra = 0x560a2f5216b8, fn_mcxt = 0x560a2f35b3f8, fn_expr = 0x1}, sk_argument = 94601743570616}, {sk_flags = 793996968, sk_attno = 22026, sk_strategy = 0, sk_subtype = 4071746429, sk_collation = 22025, sk_func = {fn_addr = 0x560a2f35b3f8, fn_oid = 793998264, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5609f2b49bf4 , fn_mcxt = 0x7ffdbbf16430, fn_expr = 0x560a2f5216b8}, sk_argument = 94601743570616}, {sk_flags = -1141808088, sk_attno = 32765, sk_strategy = 0, sk_subtype = 793910440, sk_collation = 22026, sk_func = {fn_addr = 0x5609f2bdc2c4 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -223178272, sk_attno = 22025, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4077919191, sk_collation = 22025, sk_func = {fn_addr = 0x560a2f359520, fn_oid = 56, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x5609f3101bd7 , fn_mcxt = 0x560a2f359520, fn_expr = 0x28}, sk_argument = 3}, {sk_flags = -217043688, sk_attno = 22025, sk_strategy = 0, sk_subtype = 792040736, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 3, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x560a2f521d48, fn_mcxt = 0x5609f2ba8e2c , fn_expr = 0x7ffdbbf16770}, sk_argument = 94600732597156}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4071617202, sk_collation = 22025, sk_func = {fn_addr = 0x7ffdbbf16770, fn_oid = 4071626943, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x560a2f5391b0, fn_mcxt = 0x7ffdbbf16780, fn_expr = 0x7ffdbbf16780}, sk_argument = 1}, {sk_flags = -217064540, sk_attno = 22025, sk_strategy = 0, sk_subtype = 793908920, sk_collation = 22026, sk_func = {fn_addr = 0x5609f2aff2b2 , fn_oid = 792040736, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x5609f2ba99e8 , fn_mcxt = 0x560a2f537318, fn_expr = 0x7ffdbbf16780}, sk_argument = 140727756613504}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x560a2f5216b8, fn_oid = 4072315473, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x560a2f537368, fn_mcxt = 0x5609f2ba99e8 , fn_expr = 0x5609f2b001d8 }, sk_argument = 94601743667472}, {sk_flags = -222656052, sk_attno = 22025, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x560a2f537368, fn_oid = 3153160064, fn_nargs = 32765, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x1, fn_mcxt = 0x5609f3101bd7 , fn_expr = 0x560a2f5a1540}, sk_argument = 1024}, {sk_flags = 7, sk_attno = 0, sk_strategy = 0, sk_subtype = 4077923608, sk_collation = 22025, sk_func = {fn_addr = 0xf2ba99e8, fn_oid = 7, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x560a2f5a28f8, fn_mcxt = 0x7ffdbbf16810, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 794438144, sk_attno = 22026, sk_strategy = 0, sk_subtype = 794438136, sk_collation = 22026, sk_func = {fn_addr = 0x5609f3118022 , fn_oid = 793908920, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 198 '\306', fn_extra = 0x2, fn_mcxt = 0x560a2f5a28f8, fn_expr = 0x560a2f5a29d8}, sk_argument = 94600725099874}, {sk_flags = 793903672, sk_attno = 22026, sk_strategy = 0, sk_subtype = 794008112, sk_collation = 22026, sk_func = {fn_addr = 0x560a2f5a29f8, fn_oid = 794438144, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 6 '\006', fn_extra = 0x5609f2ba9e65 , fn_mcxt = 0x3, fn_expr = 0x560a2f5392a0}, sk_argument = 94601743570616}, {sk_flags = 1582001975, sk_attno = 32607, sk_strategy = 0, sk_subtype = 793908920, sk_collation = 22026, sk_func = {fn_addr = 0x42270, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x560a2f5374e8, fn_mcxt = 0x7f5f5e4b6f37, fn_expr = 0x6b0}, sk_argument = 8128}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 0, sk_func = {fn_addr = 0x560a2f3f1240, fn_oid = 1583291488, fn_nargs = 32607, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 94601744094784}, {sk_flags = 1582004922, sk_attno = 32607, sk_strategy = 0, sk_subtype = 794432832, sk_collation = 22026, sk_func = {fn_addr = 0x5609f3101bd7 , fn_oid = 794432832, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x5609f3101dc2 , fn_expr = 0x560a2f5a1540}, sk_argument = 16384}, {sk_flags = 794439304, sk_attno = 22026, sk_strategy = 0, sk_subtype = 793913904, sk_collation = 22026, sk_func = {fn_addr = 0x560a2f5a2f68, fn_oid = 4077923156, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5609f3102d18 , fn_mcxt = 0x2f3f1240, fn_expr = 0x560a2f544638}, sk_argument = 94601743577224}}} [08:18:06.125] startKeys = {0x560a2f5232d8, 0x560a2f523320, 0x408f680000000000, 0x0, 0x4014000000000000, 0x5609f30113da , 0x560a2f5216b8, 0x3ff0000000000000, 0x4034000000000000, 0x3f747ae147ae147b, 0x7ffdbbf16000, 0x4010000000000000, 0x560a2f537e48, 0x0, 0x560a2f537e48, 0x4069000000000000, 0x560a2f522008, 0x0, 0x0, 0x5609f30123da , 0x0, 0x3ff0000000000000, 0x5a156000, 0x0, 0x0, 0x3ff0000000000000, 0x560a2f537f38, 0x560a2f5216b8, 0x101000000000000, 0x5609f30d6c7a , 0x7ffdbbf1606c, 0x7f5f5e571220} [08:18:06.125] notnullkeys = {{sk_flags = 1510563840, sk_attno = 32607, sk_strategy = 0, sk_subtype = 1514512128, sk_collation = 32607, sk_func = {fn_addr = 0x0, fn_oid = 4074345380, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x100000040, fn_mcxt = 0x7f5f5a4519c8, fn_expr = 0x5609f30c2c9c }, sk_argument = 140047513098576}, {sk_flags = -211361568, sk_attno = 22025, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x2, fn_oid = 4083553856, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 138 '\212', fn_extra = 0x7f5f00000008, fn_mcxt = 0x100000040, fn_expr = 0x0}, sk_argument = 94600732355740}, {sk_flags = 1514477904, sk_attno = 32607, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 127, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 16 '\020', fn_extra = 0x5609f2d882cb , fn_mcxt = 0x40000000067f, fn_expr = 0x7f5f5a451950}, sk_argument = 4294967360}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 127, sk_collation = 0, sk_func = {fn_addr = 0x560a2f37f410, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 165 '\245', fn_extra = 0x560a2f37f410, fn_mcxt = 0x5609f2d882cb , fn_expr = 0x560a2f37f410}, sk_argument = 140047513098576}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f, fn_oid = 792196112, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5609f2d8a79f , fn_mcxt = 0x7f5f5a451950, fn_expr = 0x5609f2d8d0f5 }, sk_argument = 140047513098576}, {sk_flags = -220684761, sk_attno = 22025, sk_strategy = 0, sk_subtype = 3153156063, sk_collation = 32765, sk_func = {fn_addr = 0x7f5f5a451950, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x7f, fn_mcxt = 0x5609f2e5a040 , fn_expr = 0x1}, sk_argument = 6}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4075135292, sk_collation = 22025, sk_func = {fn_addr = 0x7f5f5a451950, fn_oid = 6, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x0, fn_mcxt = 0x1, fn_expr = 0x5609f2e55ad5 }, sk_argument = 3}, {sk_flags = 6, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x2000, fn_oid = 793999864, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 250 '\372', fn_extra = 0x6, fn_mcxt = 0x0, fn_expr = 0x3}, sk_argument = 140727756611004}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 4075139229, sk_collation = 22025, sk_func = {fn_addr = 0x8, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x1, fn_mcxt = 0x7ffdbbf15dbc, fn_expr = 0x1}, sk_argument = 12706032393838670529}, {sk_flags = 1950205305, sk_attno = -31941, sk_strategy = 25128, sk_subtype = 21013165, sk_collation = 596646893, sk_func = {fn_addr = 0x6528ff8b23ae87d1, fn_oid = 1962940028, fn_nargs = 16786, fn_strict = 130, fn_retset = 34, fn_stats = 82 'R', fn_extra = 0x502d2f20b9db7711, fn_mcxt = 0x2b9f41eabf38558d, fn_expr = 0xca8f4dd141f6dff9}, sk_argument = 15989587488548619182}, {sk_flags = -504642135, sk_attno = 1003, sk_strategy = 8515, sk_subtype = 4074342592, sk_collation = 22025, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 25139, fn_strict = 128, fn_retset = 237, fn_stats = 200 '\310', fn_extra = 0x5609f2dd76b3 , fn_mcxt = 0x7f5f5a052a40, fn_expr = 0x83440001}, sk_argument = 1}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 16777216, sk_collation = 0, sk_func = {fn_addr = 0x5609f2d99179 , fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x7f5f5a0b6000}, sk_argument = 140047513132800}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4074345380, sk_collation = 22025, sk_func = {fn_addr = 0x800000000000000, fn_oid = 64, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 200 '\310', fn_extra = 0x5609f30c2c9c , fn_mcxt = 0x7f5f5a451950, fn_expr = 0x5609f366e0e0 }, sk_argument = 0}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 4083553856, sk_collation = 22025, sk_func = {fn_addr = 0x5609f2d8bd8a , fn_oid = 8, fn_nargs = 32607, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x8000, fn_mcxt = 0x5609f30c2c9c , fn_expr = 0x7f5f5a451950}, sk_argument = 0}, {sk_flags = 32768, sk_attno = 0, sk_strategy = 0, sk_subtype = 127, sk_collation = 0, sk_func = {fn_addr = 0x560a2f37f410, fn_oid = 4074275531, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 127 '\177', fn_extra = 0x7f5f5a451950, fn_mcxt = 0x100000040, fn_expr = 0x8000}, sk_argument = 127}, {sk_flags = 792196112, sk_attno = 22026, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x5609f2d885a5 , fn_oid = 792196112, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 203 '\313', fn_extra = 0x560a2f37f410, fn_mcxt = 0x7f5f5a451950, fn_expr = 0x1}, sk_argument = 32768}, {sk_flags = 127, sk_attno = 0, sk_strategy = 0, sk_subtype = 792196112, sk_collation = 22026, sk_func = {fn_addr = 0x1, fn_oid = 4074284959, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x5609f2d8d0f5 , fn_mcxt = 0x7f5f5a451950, fn_expr = 0x5609f2d89e27 }, sk_argument = 140727756610351}, {sk_flags = 1514477904, sk_attno = 32607, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x8000, fn_oid = 127, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x1, fn_mcxt = 0x6, fn_expr = 0x0}, sk_argument = 94600729829692}, {sk_flags = 1514477904, sk_attno = 32607, sk_strategy = 0, sk_subtype = 6, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5609f2e55ad5 , fn_mcxt = 0x3, fn_expr = 0x6}, sk_argument = 0}, {sk_flags = 8192, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x5609f2e5aefa , fn_oid = 6, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3, fn_mcxt = 0x7ffdbbf1610c, fn_expr = 0x1}, sk_argument = 94600729833629}, {sk_flags = 8, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x8, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 12 '\f', fn_extra = 0x1, fn_mcxt = 0x1, fn_expr = 0x5609f2d9a9a7 }, sk_argument = 140727756611852}, {sk_flags = -1141808880, sk_attno = 32765, sk_strategy = 0, sk_subtype = 1514477904, sk_collation = 32607, sk_func = {fn_addr = 0x7ffdbbf1609c, fn_oid = 1879048192, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0x400000000, fn_mcxt = 0x800000000, fn_expr = 0x7f5f5a0b6000}, sk_argument = 94600722449723}, {sk_flags = 1509258112, sk_attno = 32607, sk_strategy = 0, sk_subtype = 4074693353, sk_collation = 22025, sk_func = {fn_addr = 0x7f5f5a052658, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 28 '\034', fn_extra = 0x560a2f318350, fn_mcxt = 0x7f5f5a156000, fn_expr = 0x1}, sk_argument = 20}, {sk_flags = -217223139, sk_attno = 22025, sk_strategy = 0, sk_subtype = 3153157424, sk_collation = 32765, sk_func = {fn_addr = 0x5609f2d956e4 , fn_oid = 34, fn_nargs = 28, fn_strict = false, fn_retset = false, fn_stats = 207 '\317', fn_extra = 0x7f5f5a052640, fn_mcxt = 0x7f5f5a159e70, fn_expr = 0xb581a9bd4c6a693f}, sk_argument = 34}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4074330502, sk_collation = 22025, sk_func = {fn_addr = 0x560a2f520568, fn_oid = 793904560, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x5609f2d956e4 , fn_mcxt = 0x1, fn_expr = 0x2200000008}, sk_argument = 140727756611008}, {sk_flags = -220590941, sk_attno = 22025, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x22, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 134 '\206', fn_extra = 0x22, fn_mcxt = 0x5609f2d97a8a , fn_expr = 0x7f5f5a052640}, sk_argument = 94600729034029}, {sk_flags = -1141809728, sk_attno = 32765, sk_strategy = 0, sk_subtype = 3153157620, sk_collation = 32765, sk_func = {fn_addr = 0x7ffdbbf15e00, fn_oid = 4077886402, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x1bbf15e6f, fn_mcxt = 0x9e652096, fn_expr = 0x5609f307fc94 }, sk_argument = 0}, {sk_flags = -217581893, sk_attno = 22025, sk_strategy = 0, sk_subtype = 1507558864, sk_collation = 32607, sk_func = {fn_addr = 0x7f5f59db85d0, fn_oid = 1507558824, fn_nargs = 32607, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x560a2f3caf00, fn_mcxt = 0x5609f30837c1 , fn_expr = 0x7f0000000101}, sk_argument = 94600732597156}, {sk_flags = 3, sk_attno = 22026, sk_strategy = 0, sk_subtype = 4071617202, sk_collation = 22025, sk_func = {fn_addr = 0x3b600000000, fn_oid = 4076178126, fn_nargs = 22025, fn_strict = false, fn_retset = false, fn_stats = 103 'g', fn_extra = 0x560a2f521d48, fn_mcxt = 0x7ffdbbf15e80, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 793908920, sk_attno = 22026, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5609f2b291e0 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x53d90092, fn_mcxt = 0x560a2f45bce0, fn_expr = 0x1}, sk_argument = 94601742757904}, {sk_flags = -1141809492, sk_attno = 32765, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7ffdbbf15ec0, fn_oid = 794002248, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x560a2f5216b8, fn_expr = 0x5609f2b289c1 }, sk_argument = 94601743570616}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5609f30b1387 , fn_oid = 793910680, fn_nargs = 22026, fn_strict = false, fn_retset = false, fn_stats = 47 '/', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [08:18:06.125] keysz = 2 [08:18:06.125] strat_total = 3 [08:18:06.125] blkno = 4294967295 [08:18:06.125] lastcurrblkno = 0 [08:18:06.125] __func__ = "_bt_first" [08:18:06.125] #8 0x00005609f2782a8c in btgettuple (scan=0x560a2f523088, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [08:18:06.125] so = 0x560a2f544638 [08:18:06.125] res = [08:18:06.125] #9 0x00005609f2762118 in index_getnext_tid (scan=scan@entry=0x560a2f523088, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [08:18:06.125] found = [08:18:06.125] __func__ = "index_getnext_tid" [08:18:06.125] #10 0x00005609f2a6b6b1 in IndexOnlyNext (node=node@entry=0x560a2f5a1c18) at ../src/backend/executor/nodeIndexonlyscan.c:121 [08:18:06.125] estate = 0x560a2f5a1640 [08:18:06.125] econtext = 0x560a2f5a1e28 [08:18:06.125] direction = BackwardScanDirection [08:18:06.125] scandesc = 0x560a2f523088 [08:18:06.125] slot = 0x560a2f5a2048 [08:18:06.125] tid = [08:18:06.125] __func__ = "IndexOnlyNext" [08:18:06.125] #11 0x00005609f2a2404d in ExecScanFetch (recheckMtd=0x5609f2a6adfe , accessMtd=0x5609f2a6b5e2 , epqstate=0x0, node=0x560a2f5a1c18) at ../src/include/executor/execScan.h:126 [08:18:06.125] No locals. [08:18:06.125] #12 ExecScanExtended (projInfo=0x560a2f5a23d8, qual=0x0, epqstate=0x0, recheckMtd=0x5609f2a6adfe , accessMtd=0x5609f2a6b5e2 , node=0x560a2f5a1c18) at ../src/include/executor/execScan.h:187 [08:18:06.125] slot = [08:18:06.125] econtext = 0x560a2f5a1e28 [08:18:06.125] econtext = [08:18:06.125] slot = [08:18:06.125] #13 ExecScan (node=node@entry=0x560a2f5a1c18, accessMtd=accessMtd@entry=0x5609f2a6b5e2 , recheckMtd=recheckMtd@entry=0x5609f2a6adfe ) at ../src/backend/executor/execScan.c:59 [08:18:06.125] epqstate = 0x0 [08:18:06.125] qual = 0x0 [08:18:06.125] projInfo = 0x560a2f5a23d8 [08:18:06.125] #14 0x00005609f2a6b247 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [08:18:06.125] node = 0x560a2f5a1c18 [08:18:06.125] #15 0x00005609f2a1c8a2 in ExecProcNodeFirst (node=0x560a2f5a1c18) at ../src/backend/executor/execProcnode.c:469 [08:18:06.125] No locals. [08:18:06.125] #16 0x00005609f2a73fa6 in ExecProcNode (node=node@entry=0x560a2f5a1c18) at ../src/include/executor/executor.h:341 [08:18:06.125] No locals. [08:18:06.125] #17 0x00005609f2a748a0 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [08:18:06.125] node = 0x560a2f5a18a8 [08:18:06.125] econtext = 0x560a2f5a1ab8 [08:18:06.125] direction = [08:18:06.125] slot = [08:18:06.125] outerPlan = 0x560a2f5a1c18 [08:18:06.125] __func__ = "ExecLimit" [08:18:06.125] #18 0x00005609f2a1c8a2 in ExecProcNodeFirst (node=0x560a2f5a18a8) at ../src/backend/executor/execProcnode.c:469 [08:18:06.125] No locals. [08:18:06.125] #19 0x00005609f2a0637c in ExecProcNode (node=node@entry=0x560a2f5a18a8) at ../src/include/executor/executor.h:341 [08:18:06.125] No locals. [08:18:06.125] #20 0x00005609f2a06ecc in ExecutePlan (queryDesc=queryDesc@entry=0x560a2f522310, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x560a2f538e10) at ../src/backend/executor/execMain.c:1783 [08:18:06.125] estate = 0x560a2f5a1640 [08:18:06.125] planstate = 0x560a2f5a18a8 [08:18:06.125] use_parallel_mode = false [08:18:06.125] slot = [08:18:06.125] current_tuple_count = 0 [08:18:06.125] #21 0x00005609f2a08587 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x560a2f522310, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:435 [08:18:06.125] estate = 0x560a2f5a1640 [08:18:06.125] operation = CMD_SELECT [08:18:06.125] dest = 0x560a2f538e10 [08:18:06.125] sendTuples = [08:18:06.125] oldcontext = 0x560a2f522210 [08:18:06.125] #22 0x00007f5f5bb38805 in pgss_ExecutorRun (queryDesc=0x560a2f522310, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1043 [08:18:06.125] _save_exception_stack = 0x7ffdbbf16d10 [08:18:06.125] _save_context_stack = 0x0 [08:18:06.125] _local_sigjmp_buf = {{__jmpbuf = {94601742238816, -4828720047208666150, 0, 1, 94601741707568, 94601741707520, -1219391423723213862, -1272801875121148966}, __mask_was_saved = 0, __saved_mask = {__val = {94600732613109, 94601743573520, 94600732617640, 0, 2, 0, 94601742324288, 94601742324288, 1, 1, 94601741707568, 94601741707520, 94600732703024, 94601742324240, 94600732858419, 94601742324288}}}} [08:18:06.125] _do_rethrow = false [08:18:06.125] #23 0x00005609f2a085dd in ExecutorRun (queryDesc=queryDesc@entry=0x560a2f522310, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:369 [08:18:06.125] No locals. [08:18:06.125] #24 0x00005609f2e20759 in PortalRunSelect (portal=portal@entry=0x560a2f3dc460, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x560a2f538e10) at ../src/backend/tcop/pquery.c:953 [08:18:06.125] queryDesc = 0x560a2f522310 [08:18:06.125] direction = [08:18:06.125] nprocessed = [08:18:06.125] __func__ = "PortalRunSelect" [08:18:06.125] #25 0x00005609f2e23dad in PortalRun (portal=portal@entry=0x560a2f3dc460, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x560a2f538e10, altdest=altdest@entry=0x560a2f538e10, qc=qc@entry=0x7ffdbbf16e30) at ../src/backend/tcop/pquery.c:797 [08:18:06.125] _save_exception_stack = 0x7ffdbbf16ee0 [08:18:06.125] _save_context_stack = 0x0 [08:18:06.125] _local_sigjmp_buf = {{__jmpbuf = {0, -4828720060798211110, 94601742238816, 94601741707592, 94601741707568, 94601741707520, -1219391423549150246, -4829182804435014694}, __mask_was_saved = 0, __saved_mask = {__val = {94600732617640, 3153161663, 4, 94601741707520, 112, 179, 94601742238816, 94601741707592, 94601741707568, 94601741707520, 94600732705211, 179, 2, 179, 94600721755107, 0}}}} [08:18:06.125] _do_rethrow = [08:18:06.125] result = [08:18:06.125] nprocessed = [08:18:06.125] saveTopTransactionResourceOwner = 0x560a2f39de68 [08:18:06.125] saveTopTransactionContext = 0x560a2f3f1110 [08:18:06.125] saveActivePortal = 0x0 [08:18:06.125] saveResourceOwner = 0x560a2f39de68 [08:18:06.125] savePortalContext = 0x0 [08:18:06.125] saveMemoryContext = 0x560a2f3f1110 [08:18:06.125] __func__ = "PortalRun" [08:18:06.125] #26 0x00005609f2e1c956 in exec_simple_query (query_string=query_string@entry=0x560a2f359620 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;") at ../src/backend/tcop/postgres.c:1274 [08:18:06.125] cmdtaglen = 6 [08:18:06.125] snapshot_set = [08:18:06.125] per_parsetree_context = 0x0 [08:18:06.125] plantree_list = 0x560a2f539800 [08:18:06.125] parsetree = 0x560a2f35a900 [08:18:06.125] commandTag = [08:18:06.125] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:18:06.125] querytree_list = [08:18:06.125] portal = 0x560a2f3dc460 [08:18:06.125] receiver = 0x560a2f538e10 [08:18:06.125] format = 0 [08:18:06.125] cmdtagname = [08:18:06.125] parsetree_item__state = [08:18:06.125] dest = DestRemote [08:18:06.125] oldcontext = 0x560a2f3f1110 [08:18:06.125] parsetree_list = 0x560a2f35a930 [08:18:06.125] parsetree_item = 0x560a2f35a948 [08:18:06.125] save_log_statement_stats = false [08:18:06.125] was_logged = true [08:18:06.125] use_implicit_block = false [08:18:06.125] msec_str = "`N\250\363\tV\000\000#G\016\363\tV\000\000\300n\361\273\375\177\000\000m\000\000\000\000\000\000" [08:18:06.125] __func__ = "exec_simple_query" [08:18:06.125] #27 0x00005609f2e1fb7a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4759 [08:18:06.125] query_string = 0x560a2f359620 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [08:18:06.125] firstchar = [08:18:06.125] input_message = {data = 0x560a2f359620 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [08:18:06.125] local_sigjmp_buf = {{__jmpbuf = {94600745644248, -4829185108895208486, 140727756615856, 94600742588000, 24, 10, -1219391423616259110, -4829182798182487078}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94601741958672, 0, 168, 94600732618110, 0, 10, 2, 94600745644256, 94601741433184, 94600745638304, 94600742588000, 24, 10}}}} [08:18:06.125] send_ready_for_query = false [08:18:06.125] idle_in_transaction_timeout_enabled = false [08:18:06.125] idle_session_timeout_enabled = false [08:18:06.125] __func__ = "PostgresMain" [08:18:06.125] #28 0x00005609f2e15511 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [08:18:06.125] bsdata = [08:18:06.125] #29 0x00005609f2cb5c8c in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7ffdbbf17040, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffdbbf170b0) at ../src/backend/postmaster/launch_backend.c:290 [08:18:06.125] pid = [08:18:06.125] #30 0x00005609f2cbb249 in BackendStartup (client_sock=client_sock@entry=0x7ffdbbf170b0) at ../src/backend/postmaster/postmaster.c:3580 [08:18:06.125] bn = 0x560a2f384e98 [08:18:06.125] pid = [08:18:06.125] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796723904564843, fork_started = 796723904564846} [08:18:06.125] cac = [08:18:06.125] __func__ = "BackendStartup" [08:18:06.125] #31 0x00005609f2cbd734 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [08:18:06.125] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\351\220\337\361\tV\000\000\320[\333\361\tV\000\000\000r\361\273\375\177\000\000\370q\361\273\375\177\000\000\225[\362\001\000\000\000\000\360A8/\nV\000\000-", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\306\324__\177\000\000@\266\222__\177\000\000\340\302\324__\177\000\000\316)fR\000\000\000", __ss_align = 3153162816}, salen = 2}} [08:18:06.125] i = 0 [08:18:06.125] now = [08:18:06.125] last_lockfile_recheck_time = 1743408695 [08:18:06.125] last_touch_time = 1743408695 [08:18:06.125] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = 1607779040, user_data = 0x0}, {pos = -1141804416, events = 32765, fd = 1607604808, user_data = 0x10}, {pos = 1603450432, events = 32607, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1607779040, user_data = 0x7ffdbbf171f8}, {pos = -1141804544, events = 32765, fd = 1607779944, user_data = 0x0}, {pos = 792227064, events = 22026, fd = 1582004922, user_data = 0x560a2f386cf8}, {pos = 1, events = 22025, fd = 32768, user_data = 0xffffffff}, {pos = 1581441056, events = 32607, fd = 1603515600, user_data = 0x560a2f38f418}, {pos = 792261368, events = 22026, fd = 792237905, user_data = 0x7f5f5fd27ebe}, {pos = 1, events = 0, fd = 1607779040, user_data = 0x1ae}, {pos = -211276432, events = 22025, fd = 0, user_data = 0x0}, {pos = 86, events = 0, fd = 1607630526, user_data = 0x1}, {pos = 0, events = 0, fd = 1581441056, user_data = 0x7f5f5e4f2e80 }, {pos = 16, events = 0, fd = -1141803424, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f5f5fd2a2ba}, {pos = 0, events = 0, fd = 1581968852, user_data = 0x0}, {pos = -204122240, events = 22025, fd = 2, user_data = 0x0}, {pos = 791788032, events = 22026, fd = -220543977, user_data = 0x560a2f38e0e0}, {pos = -220540180, events = 22025, fd = 792256827, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1581475016, user_data = 0x7f5f5e49c880 }, {pos = 1581072120, events = 32607, fd = -1141803216, user_data = 0x100007f00000002}, {pos = 1582001975, events = 32607, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1583291488, events = 32607, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 170991648, events = 842413615, fd = 1634623754, user_data = 0x0}, {pos = 0, events = 0, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f5f5f92c540}, {pos = 1603455616, events = 32607, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 792268048, events = 22026, fd = 1080, user_data = 0x560a2f38f0f0}, {pos = -217045929, events = 22025, fd = 1024, user_data = 0x7f5f5e4b579b}, {pos = 1583274464, events = 32607, fd = 1581912430, user_data = 0x100000400}, {pos = 7, events = 0, fd = 792256736, user_data = 0x6e2ae901ac032000}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x560a2f38f0f0}, {pos = 3, events = 0, fd = 0, user_data = 0x8cf9}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x77}, {pos = 1582248083, events = 32607, fd = 792260848, user_data = 0x1}, {pos = 792261048, events = 22026, fd = 1024, user_data = 0x7ffdbbf17738}, {pos = -216964789, events = 22025, fd = -204017520, user_data = 0x5609f3104c08 }, {pos = 792260848, events = 22026, fd = 792040736, user_data = 0x560a2f38f0f0}, {pos = 1581995931, events = 32607, fd = 0, user_data = 0x5609f3116872 }, {pos = 792260848, events = 1, fd = -216962629, user_data = 0x560a2f359520}, {pos = 1581918897, events = 32607, fd = 1581913328, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1409081344, events = 1848305921, fd = 791788032, user_data = 0x6e2ae901ac032000}, {pos = 13, events = 0, fd = -1409081344, user_data = 0x0}, {pos = 1581625913, events = 32607, fd = 0, user_data = 0x5609f2cb5972 }, {pos = 4194304, events = 0, fd = 791874640, user_data = 0x1}, {pos = 0, events = 0, fd = 791788032, user_data = 0x5609f3104a9c }, {pos = 791874640, events = 22026, fd = 792040736, user_data = 0x560a2f330c50}, {pos = 1, events = 0, fd = 0, user_data = 0x5609f30c2c9c }, {pos = 13, events = 0, fd = 792224552, user_data = 0x560a2f386308}, {pos = -204120808, events = 22025, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -221553876, user_data = 0x560a2f359520}, {pos = -221536975, events = 22025, fd = -207807376, user_data = 0x560a2f359ed8}} [08:18:06.126] nevents = 1 [08:18:06.126] __func__ = "ServerLoop" [08:18:06.126] #32 0x00005609f2cbef98 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560a2f317860) at ../src/backend/postmaster/postmaster.c:1399 [08:18:06.126] opt = [08:18:06.126] status = [08:18:06.126] userDoption = [08:18:06.126] listen_addr_saved = false [08:18:06.126] output_config_variable = [08:18:06.126] __func__ = "PostmasterMain" [08:18:06.126] #33 0x00005609f2aedf89 in main (argc=4, argv=0x560a2f317860) at ../src/backend/main/main.c:227 [08:18:06.126] do_check_root = [08:18:06.126] dispatch_option = [08:18:06.148] -e [08:18:06.148] [08:18:06.148] [08:18:06.212] dumping /tmp/cores/postgres-6-27766.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:18:06.477] [New LWP 27766] [08:18:06.477] [08:18:06.477] This GDB supports auto-downloading debuginfo from the following URLs: [08:18:06.477] [08:18:06.477] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:18:06.477] Debuginfod has been disabled. [08:18:06.477] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:18:06.581] [Thread debugging using libthread_db enabled] [08:18:06.581] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:18:06.581] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [08:18:06.581] Program terminated with signal SIGABRT, Aborted. [08:18:06.581] #0 0x00007f08b06a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.693] [08:18:06.693] Thread 1 (Thread 0x7f08ae62e040 (LWP 27766)): [08:18:06.693] #0 0x00007f08b06a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.693] No symbol table info available. [08:18:06.693] #1 0x00007f08b065afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.693] No symbol table info available. [08:18:06.693] #2 0x00007f08b0645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:18:06.693] No symbol table info available. [08:18:06.693] #3 0x00005567d2c19316 in ExceptionalCondition (conditionName=conditionName@entry=0x5567d2e58ce0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x5567d2e58808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [08:18:06.693] No locals. [08:18:06.693] #4 0x00005567d22f5d59 in _bt_checkkeys (scan=scan@entry=0x5567de007208, pstate=pstate@entry=0x7ffc3e9493d0, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7f08a8f0cfe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [08:18:06.693] tupdesc = 0x7f08a45de738 [08:18:06.693] so = [08:18:06.693] dir = BackwardScanDirection [08:18:06.693] ikey = 0 [08:18:06.693] res = [08:18:06.693] #5 0x00005567d22e2fea in _bt_readpage (scan=scan@entry=0x5567de007208, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [08:18:06.693] iid = 0x7f08a8f0b018 [08:18:06.693] itup = 0x7f08a8f0cfe0 [08:18:06.693] tuple_alive = true [08:18:06.693] passes_quals = [08:18:06.693] rel = [08:18:06.693] so = 0x5567de031008 [08:18:06.693] page = [08:18:06.693] opaque = [08:18:06.693] minoff = 1 [08:18:06.693] maxoff = [08:18:06.693] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7f08a8f0cfe0, page = 0x7f08a8f0b000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [08:18:06.693] arrayKeys = true [08:18:06.693] itemIndex = 1357 [08:18:06.693] indnatts = 2 [08:18:06.693] #6 0x00005567d22e3eb6 in _bt_readfirstpage (scan=scan@entry=0x5567de007208, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [08:18:06.693] so = 0x5567de031008 [08:18:06.693] #7 0x00005567d22e76dd in _bt_first (scan=scan@entry=0x5567de007208, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [08:18:06.693] rel = 0x7f08a48d7c78 [08:18:06.693] so = 0x5567de031008 [08:18:06.693] stack = [08:18:06.693] offnum = [08:18:06.693] inskey = {heapkeyspace = true, allequalimage = true, anynullkeys = false, nextkey = true, backward = true, scantid = 0x0, keysz = 2, scankeys = {{sk_flags = 458849, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567d22bf3fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5567ddf90e40, fn_expr = 0x5567de01ea48}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x5567d22bf3fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5567ddf90e40, fn_expr = 0x5567de01ea98}, sk_argument = 500}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1049927600, sk_collation = 32764, sk_func = {fn_addr = 0x5567ddffb1e8, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567ddff8d58, fn_mcxt = 0x5567d26839c1 , fn_expr = 0x5567ddff8d58}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3535848327, sk_collation = 21863, sk_func = {fn_addr = 0x5567ddff9438, fn_oid = 3535191087, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 93904594514408}, {sk_flags = 1049927968, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 1083140096, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = 20, fn_retset = 64, fn_stats = 218 '\332', fn_extra = 0x5567ddff8d58, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x4034000000000000}, sk_argument = 4572414629676717179}, {sk_flags = 1049927920, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x5567ddfface8, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x4069000000000000, fn_mcxt = 0x5567ddff8338, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -759770150, sk_attno = 21863, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x5567ddffadd8}, sk_argument = 93904594505048}, {sk_flags = 0, sk_attno = 0, sk_strategy = 257, sk_subtype = 3536002170, sk_collation = 21863, sk_func = {fn_addr = 0x7ffc3e94a15c, fn_oid = 2960593440, fn_nargs = 32520, fn_strict = false, fn_retset = false, fn_stats = 48 '0', fn_extra = 0x0, fn_mcxt = 0x7ffc3e94a220, fn_expr = 0x5567ddf2aa20}, sk_argument = 5295}, {sk_flags = -571302576, sk_attno = 21863, sk_strategy = 0, sk_subtype = 1049928028, sk_collation = 32764, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x156, fn_mcxt = 0x5567d2c321fd , fn_expr = 0x3fd199999999999a}, sk_argument = 140721358414360}, {sk_flags = 1049928208, sk_attno = 32764, sk_strategy = 0, sk_subtype = 3724510008, sk_collation = 21863, sk_func = {fn_addr = 0x5567ddff8d58, fn_oid = 3535848327, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x67f00000000, fn_mcxt = 0x5567ddffadd8, fn_expr = 0x5567ddff8228}, sk_argument = 140721358414360}, {sk_flags = 1049928208, sk_attno = 32764, sk_strategy = 0, sk_subtype = 3724510008, sk_collation = 21863, sk_func = {fn_addr = 0x5567d2c0c4ee , fn_oid = 342, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x5567ddff8778, fn_mcxt = 0x5567d26867e6 , fn_expr = 0x5567ddff9950}, sk_argument = 4607182418800017408}, {sk_flags = 0, sk_attno = 0, sk_strategy = 49136, sk_subtype = 0, sk_collation = 1075052544, sk_func = {fn_addr = 0x4030000000000000, fn_oid = 2576980378, fn_nargs = -26215, fn_strict = 209, fn_retset = 63, fn_stats = 154 '\232', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x4014000000000000}, sk_argument = 0}, {sk_flags = -570457560, sk_attno = 21863, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x5567d2c5cbd7 , fn_oid = 3722601728, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 122 'z', fn_extra = 0x7ffc3e94a2dc, fn_mcxt = 0x7f08b0771220, fn_expr = 0xddff8d58}, sk_argument = 0}, {sk_flags = -570457288, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3723668000, sk_collation = 21863, sk_func = {fn_addr = 0x0, fn_oid = 3723664720, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 220 '\334', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 4620693217682128896}, {sk_flags = -758963715, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724511096, sk_collation = 21863, sk_func = {fn_addr = 0x7ffc3e94a360, fn_oid = 1049928536, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567ddff8d58, fn_mcxt = 0x5567d2c0c387 , fn_expr = 0x400e79e79e79e79e}, sk_argument = 7142530613248}, {sk_flags = 1202590843, sk_attno = 31457, sk_strategy = 16244, sk_subtype = 3951369912, sk_collation = 1077661777, sk_func = {fn_addr = 0x7ffc3e94a360, fn_oid = 1049928536, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d2c0c4ee , fn_mcxt = 0x5567ddff8d58, fn_expr = 0x5567ddffa030}, sk_argument = 93904594503544}, {sk_flags = -764881754, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724522280, sk_collation = 21863, sk_func = {fn_addr = 0x3fb0000000000000, fn_oid = 3951369912, fn_nargs = -12207, fn_strict = 59, fn_retset = 64, fn_stats = 76 'L', fn_extra = 0x0, fn_mcxt = 0x4010000000000000, fn_expr = 0x3ff0000000000000}, sk_argument = 4617315517961601024}, {sk_flags = -570456200, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3530084675, sk_collation = 21863, sk_func = {fn_addr = 0x5567ddff8778, fn_oid = 0, fn_nargs = 0, fn_strict = 16, fn_retset = 64, fn_stats = 158 '\236', fn_extra = 0x3ff0000000000000, fn_mcxt = 0x400e79e79e79e79e, fn_expr = 0x40f0000000000000}, sk_argument = 4572414629676717179}, {sk_flags = -343597384, sk_attno = -12207, sk_strategy = 16443, sk_subtype = 0, sk_collation = 16777216, sk_func = {fn_addr = 0x5567ddff8778, fn_oid = 3724512600, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x1, fn_mcxt = 0x5567ddff8d58, fn_expr = 0x5567ddff8778}, sk_argument = 93904399997821}, {sk_flags = -572357672, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724515824, sk_collation = 21863, sk_func = {fn_addr = 0x1, fn_oid = 3530181620, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x5567ddff8d58, fn_mcxt = 0x5567ddff8d58, fn_expr = 0x7ffc3e94a518}, sk_argument = 93904594506568}, {sk_flags = -764185916, sk_attno = 21863, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d2c5cbd7 , fn_mcxt = 0x5567ddf90e40, fn_expr = 0x400}, sk_argument = 7}, {sk_flags = -758784744, sk_attno = 21863, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x7ffc3e94a5f0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 93904594084608}, {sk_flags = -570875144, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3536269346, sk_collation = 21863, sk_func = {fn_addr = 0x0, fn_oid = 3528659654, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567ddf921f8, fn_mcxt = 0x5567ddf922d8, fn_expr = 0x5567d2532562 }, sk_argument = 0}, {sk_flags = -570439472, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724092152, sk_collation = 21863, sk_func = {fn_addr = 0x5567ddf92300, fn_oid = 6, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d2c5cbd7 , fn_mcxt = 0x5567ddf90e40, fn_expr = 0x40}, sk_argument = 9}, {sk_flags = -759321452, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724092160, sk_collation = 21863, sk_func = {fn_addr = 0x5567d2bda6bb , fn_oid = 2760420072, fn_nargs = 32520, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x7f08a488aac0, fn_mcxt = 0x5567dde8aa90, fn_expr = 0x5567dde8a380}, sk_argument = 93904405653441}, {sk_flags = -570875176, sk_attno = 21863, sk_strategy = 0, sk_subtype = 96, sk_collation = 0, sk_func = {fn_addr = 0x73, fn_oid = 1976, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x323e94a78f, fn_mcxt = 0x60, fn_expr = 0x73}, sk_argument = 139675096886016}, {sk_flags = -1335136457, sk_attno = 32520, sk_strategy = 0, sk_subtype = 3724086848, sk_collation = 21863, sk_func = {fn_addr = 0x11270, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x0, fn_mcxt = 0x7f08b06b6f37, fn_expr = 0x6b0}, sk_argument = 8112}, {sk_flags = 1027, sk_attno = 0, sk_strategy = 0, sk_subtype = 114, sk_collation = 0, sk_func = {fn_addr = 0x5567ddec0370, fn_oid = 2961120352, fn_nargs = 32520, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 93904594079552}, {sk_flags = -1335133510, sk_attno = 32520, sk_strategy = 0, sk_subtype = 3724086848, sk_collation = 21863, sk_func = {fn_addr = 0x5567d2c5cbd7 , fn_oid = 3724086848, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x5567d2c5cdc2 , fn_expr = 0x5567ddf90e40}, sk_argument = 16384}, {sk_flags = -570873976, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724570048, sk_collation = 21863, sk_func = {fn_addr = 0x5567ddf92868, fn_oid = 3536182100, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x5567d2c5dd18 , fn_mcxt = 0xddec0370, fn_expr = 0x5567de031008}, sk_argument = 93904594563592}}} [08:18:06.693] startKeys = {0x5567de007458, 0x5567de0074a0, 0x5567dde26500, 0x8, 0x0, 0x5567d2c5dd18 , 0x3e949eb0, 0x0, 0x5567ddfdf6a0, 0x5567dde26f8e, 0x5567dde26e20, 0x5567dde26f87, 0x5567dde26e20, 0x7ffc3e94aa88, 0x0, 0x5567d2c5cbd7 , 0x5567dde26500, 0x40, 0x3, 0x5567d2c54bc2 , 0x5567d2f1d388, 0x5567dde26f9a, 0x5567dde26e20, 0x5567d2dbc3bb , 0x5567dde26f9d, 0x5567dde26e20, 0x5567dde26f9c, 0x0, 0x7ffc3e94aa88, 0x5567d2dc2b34 , 0x2, 0x3} [08:18:06.693] notnullkeys = {{sk_flags = 2, sk_attno = 21863, sk_strategy = 0, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 3526097445, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 100 'd', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x5567ddffa200}, sk_argument = 93904593333536}, {sk_flags = 20162, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 3526095474, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x5567ddffa200}, sk_argument = 93904593334744}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3526097445, sk_collation = 21863, sk_func = {fn_addr = 0x1000200000164, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567ddffa200, fn_mcxt = 0x550000000101, fn_expr = 0x0}, sk_argument = 281483566645249}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5567d22bfa25 , fn_oid = 3724517176, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 128 '\200', fn_extra = 0x5567ddff9fc8, fn_mcxt = 0x5567ddffa200, fn_expr = 0x5567ddede478}, sk_argument = 20165}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567ddffa200, fn_oid = 3723471512, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x300030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5567d22bf156 }, sk_argument = 281483566646941}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567ddffa200, fn_oid = 3723471592, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe00, fn_mcxt = 0x2c000000000000, fn_expr = 0xff20080100220065}, sk_argument = 8388607}, {sk_flags = 20165, sk_attno = 28271, sk_strategy = 27493, sk_subtype = 1819635295, sk_collation = 1936028780, sk_func = {fn_addr = 0x74, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 8796093022465}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3, sk_collation = 403, sk_func = {fn_addr = 0x100030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 93904592594176}, {sk_flags = -571585608, sk_attno = 21863, sk_strategy = 0, sk_subtype = 521, sk_collation = 0, sk_func = {fn_addr = 0x200030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 121 'y', fn_extra = 0x1000200000166, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 93904592594176}, {sk_flags = -571585448, sk_attno = 21863, sk_strategy = 0, sk_subtype = 115, sk_collation = 0, sk_func = {fn_addr = 0x300030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 93904592594176}, {sk_flags = -571585368, sk_attno = 21863, sk_strategy = 0, sk_subtype = 1976, sk_collation = 0, sk_func = {fn_addr = 0x5567dde27fc8, fn_oid = 3582, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 252 '\374', fn_extra = 0x2c000000000002, fn_mcxt = 0xff20010120220063, fn_expr = 0x7fffff}, sk_argument = 7166204966904811199}, {sk_flags = 1952410735, sk_attno = 25185, sk_strategy = 25964, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x89800000000}, sk_argument = 20161}, {sk_flags = 10, sk_attno = 2, sk_strategy = 0, sk_subtype = 20159, sk_collation = 0, sk_func = {fn_addr = 0xbf80000000000000, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x5567dde27b48, fn_expr = 0x5567dde27b90}, sk_argument = 15371687955961}, {sk_flags = 0, sk_attno = 0, sk_strategy = 44, sk_subtype = 539099234, sk_collation = 4280287489, sk_func = {fn_addr = 0x7fffff, fn_oid = 20157, fn_nargs = 30563, fn_strict = 105, fn_retset = 95, fn_stats = 97 'a', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x101}, sk_argument = 0}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 3534437070, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x5567dde26500}, sk_argument = 93904593345112}, {sk_flags = -572362776, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3724517424, sk_collation = 21863, sk_func = {fn_addr = 0x0, fn_oid = 3576, fn_nargs = 3579, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xff20010120220061, fn_mcxt = 0x7fffff, fn_expr = 0x5f69776300004eba}, sk_argument = 1953719668}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5567d22bfa25 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567dde26500, fn_oid = 3723341088, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 197 '\305', fn_extra = 0x200030000, fn_mcxt = 0x3b600000000, fn_expr = 0x5567d22bf272 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567dde26500, fn_oid = 3723342296, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x5567d22bfa25 , fn_mcxt = 0x1000000000101, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 196608, sk_attno = 1, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x5567d22bfa25 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5567dde26500, fn_expr = 0x5567ddee4bb8}, sk_argument = 521}, {sk_flags = 7209216, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0xdf700000df4, fn_oid = 3, fn_nargs = 0, fn_strict = 44, fn_retset = false, fn_stats = 88 'X', fn_extra = 0x5567ddff85a0, fn_mcxt = 0x5567ddff85e8, fn_expr = 0x74736574}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x89800000000, fn_mcxt = 0x4eb7, fn_expr = 0xa}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 49024, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5567ddff9190, fn_oid = 3525994843, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 88 'X', fn_extra = 0x5567d22ab53b , fn_mcxt = 0xdf300000df2, fn_expr = 0x2c000000000000}, sk_argument = 18383694783272058966}, {sk_flags = 8388607, sk_attno = 0, sk_strategy = 0, sk_subtype = 20148, sk_collation = 1600747363, sk_func = {fn_addr = 0x5567d29b5040 , fn_oid = 3724513968, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2, fn_mcxt = 0x100030000, fn_expr = 0x3b600000000}, sk_argument = 93904404429518}, {sk_flags = 257, sk_attno = 0, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x556700000003, fn_oid = 196608, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d2ab3ace , fn_mcxt = 0x1000200000167, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -572365568, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3723428152, sk_collation = 21863, sk_func = {fn_addr = 0x5567d2e78d51, fn_oid = 196608, fn_nargs = 2, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d22bfa25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -572365568, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3723642664, sk_collation = 21863, sk_func = {fn_addr = 0x17, fn_oid = 196608, fn_nargs = 3, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x5567d22bfa25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = -572365568, sk_attno = 21863, sk_strategy = 0, sk_subtype = 3723642744, sk_collation = 21863, sk_func = {fn_addr = 0x17, fn_oid = 3724511912, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x5567d2f5bf90, fn_mcxt = 0x7ffc3e949f28, fn_expr = 0x5567d2f5bf88}, sk_argument = 93904406496008}, {sk_flags = -571432064, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x5567dde26500}, sk_argument = 93904592781712}, {sk_flags = 20162, sk_attno = 0, sk_strategy = 0, sk_subtype = 356, sk_collation = 65538, sk_func = {fn_addr = 0x5567d2c54bc2 , fn_oid = 3539063688, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 91 '[', fn_extra = 0x5567ddff9af8, fn_mcxt = 0x5567d22ab53b , fn_expr = 0x200020000}, sk_argument = 4080218931200}, {sk_flags = -768871822, sk_attno = 21863, sk_strategy = 0, sk_subtype = 350, sk_collation = 65538, sk_func = {fn_addr = 0x101, fn_oid = 3533393984, fn_nargs = 21863, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x5567d29b513c }, sk_argument = 281474976710913}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x100030000, fn_oid = 0, fn_nargs = 950, fn_strict = false, fn_retset = false, fn_stats = 37 '%', fn_extra = 0x1000200000164, fn_mcxt = 0x2, fn_expr = 0x0}, sk_argument = 93904592594176}} [08:18:06.693] keysz = 2 [08:18:06.693] strat_total = 3 [08:18:06.693] blkno = 4294967295 [08:18:06.693] lastcurrblkno = 0 [08:18:06.693] __func__ = "_bt_first" [08:18:06.693] #8 0x00005567d22dda8c in btgettuple (scan=0x5567de007208, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [08:18:06.693] so = 0x5567de031008 [08:18:06.693] res = [08:18:06.693] #9 0x00005567d22bd118 in index_getnext_tid (scan=scan@entry=0x5567de007208, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [08:18:06.693] found = [08:18:06.693] __func__ = "index_getnext_tid" [08:18:06.693] #10 0x00005567d25c66b1 in IndexOnlyNext (node=node@entry=0x5567ddf91518) at ../src/backend/executor/nodeIndexonlyscan.c:121 [08:18:06.693] estate = 0x5567ddf90f40 [08:18:06.693] econtext = 0x5567ddf91728 [08:18:06.693] direction = BackwardScanDirection [08:18:06.693] scandesc = 0x5567de007208 [08:18:06.693] slot = 0x5567ddf91948 [08:18:06.693] tid = [08:18:06.693] __func__ = "IndexOnlyNext" [08:18:06.693] #11 0x00005567d257f04d in ExecScanFetch (recheckMtd=0x5567d25c5dfe , accessMtd=0x5567d25c65e2 , epqstate=0x0, node=0x5567ddf91518) at ../src/include/executor/execScan.h:126 [08:18:06.693] No locals. [08:18:06.693] #12 ExecScanExtended (projInfo=0x5567ddf91cd8, qual=0x0, epqstate=0x0, recheckMtd=0x5567d25c5dfe , accessMtd=0x5567d25c65e2 , node=0x5567ddf91518) at ../src/include/executor/execScan.h:187 [08:18:06.693] slot = [08:18:06.693] econtext = 0x5567ddf91728 [08:18:06.693] econtext = [08:18:06.693] slot = [08:18:06.693] #13 ExecScan (node=node@entry=0x5567ddf91518, accessMtd=accessMtd@entry=0x5567d25c65e2 , recheckMtd=recheckMtd@entry=0x5567d25c5dfe ) at ../src/backend/executor/execScan.c:59 [08:18:06.693] epqstate = 0x0 [08:18:06.693] qual = 0x0 [08:18:06.693] projInfo = 0x5567ddf91cd8 [08:18:06.693] #14 0x00005567d25c6247 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [08:18:06.693] node = 0x5567ddf91518 [08:18:06.693] #15 0x00005567d25778a2 in ExecProcNodeFirst (node=0x5567ddf91518) at ../src/backend/executor/execProcnode.c:469 [08:18:06.693] No locals. [08:18:06.693] #16 0x00005567d25cefa6 in ExecProcNode (node=node@entry=0x5567ddf91518) at ../src/include/executor/executor.h:341 [08:18:06.693] No locals. [08:18:06.693] #17 0x00005567d25cf8a0 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [08:18:06.693] node = 0x5567ddf911a8 [08:18:06.693] econtext = 0x5567ddf913b8 [08:18:06.693] direction = [08:18:06.693] slot = [08:18:06.693] outerPlan = 0x5567ddf91518 [08:18:06.693] __func__ = "ExecLimit" [08:18:06.693] #18 0x00005567d25778a2 in ExecProcNodeFirst (node=0x5567ddf911a8) at ../src/backend/executor/execProcnode.c:469 [08:18:06.693] No locals. [08:18:06.693] #19 0x00005567d256137c in ExecProcNode (node=node@entry=0x5567ddf911a8) at ../src/include/executor/executor.h:341 [08:18:06.693] No locals. [08:18:06.693] #20 0x00005567d2561ecc in ExecutePlan (queryDesc=queryDesc@entry=0x5567ddffa300, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5567ddffbcb0) at ../src/backend/executor/execMain.c:1783 [08:18:06.693] estate = 0x5567ddf90f40 [08:18:06.693] planstate = 0x5567ddf911a8 [08:18:06.693] use_parallel_mode = false [08:18:06.693] slot = [08:18:06.693] current_tuple_count = 0 [08:18:06.693] #21 0x00005567d2563587 in standard_ExecutorRun (queryDesc=0x5567ddffa300, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:435 [08:18:06.693] estate = 0x5567ddf90f40 [08:18:06.693] operation = CMD_SELECT [08:18:06.693] dest = 0x5567ddffbcb0 [08:18:06.693] sendTuples = [08:18:06.693] oldcontext = 0x5567ddffa200 [08:18:06.693] #22 0x00005567d25635e7 in ExecutorRun (queryDesc=queryDesc@entry=0x5567ddffa300, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:371 [08:18:06.693] No locals. [08:18:06.693] #23 0x00005567d297b759 in PortalRunSelect (portal=portal@entry=0x5567ddeab590, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5567ddffbcb0) at ../src/backend/tcop/pquery.c:953 [08:18:06.693] queryDesc = 0x5567ddffa300 [08:18:06.693] direction = [08:18:06.693] nprocessed = [08:18:06.693] __func__ = "PortalRunSelect" [08:18:06.693] #24 0x00005567d297edad in PortalRun (portal=portal@entry=0x5567ddeab590, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5567ddffbcb0, altdest=altdest@entry=0x5567ddffbcb0, qc=qc@entry=0x7ffc3e94abe0) at ../src/backend/tcop/pquery.c:797 [08:18:06.693] _save_exception_stack = 0x7ffc3e94ac90 [08:18:06.693] _save_context_stack = 0x0 [08:18:06.693] _local_sigjmp_buf = {{__jmpbuf = {0, -9083413221281926808, 93904593139088, 93904592599336, 93904592599312, 93904592599264, -3114523799057895064, -9083438163953749656}, __mask_was_saved = 0, __saved_mask = {__val = {93904406174632, 1049930607, 4, 93904592599264, 112, 179, 93904593139088, 93904592599336, 93904592599312, 93904592599264, 93904406262203, 179, 2, 179, 93904395312099, 0}}}} [08:18:06.693] _do_rethrow = [08:18:06.693] result = [08:18:06.693] nprocessed = [08:18:06.693] saveTopTransactionResourceOwner = 0x5567dde68048 [08:18:06.693] saveTopTransactionContext = 0x5567ddec0240 [08:18:06.693] saveActivePortal = 0x0 [08:18:06.693] saveResourceOwner = 0x5567dde68048 [08:18:06.693] savePortalContext = 0x0 [08:18:06.693] saveMemoryContext = 0x5567ddec0240 [08:18:06.693] __func__ = "PortalRun" [08:18:06.693] #25 0x00005567d2977956 in exec_simple_query (query_string=query_string@entry=0x5567dde26600 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;") at ../src/backend/tcop/postgres.c:1274 [08:18:06.693] cmdtaglen = 6 [08:18:06.693] snapshot_set = [08:18:06.693] per_parsetree_context = 0x0 [08:18:06.693] plantree_list = 0x5567ddffc6a0 [08:18:06.693] parsetree = 0x5567dde278e0 [08:18:06.693] commandTag = [08:18:06.693] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:18:06.693] querytree_list = [08:18:06.693] portal = 0x5567ddeab590 [08:18:06.693] receiver = 0x5567ddffbcb0 [08:18:06.693] format = 0 [08:18:06.693] cmdtagname = [08:18:06.693] parsetree_item__state = [08:18:06.693] dest = DestRemote [08:18:06.693] oldcontext = 0x5567ddec0240 [08:18:06.693] parsetree_list = 0x5567dde27910 [08:18:06.693] parsetree_item = 0x5567dde27928 [08:18:06.693] save_log_statement_stats = false [08:18:06.693] was_logged = true [08:18:06.693] use_implicit_block = false [08:18:06.693] msec_str = "`\376]\323gU\000\000#\367\303\322gU\000\000p\254\224>\374\177\000\000m\000\000\000\000\000\000" [08:18:06.693] __func__ = "exec_simple_query" [08:18:06.693] #26 0x00005567d297ab7a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4759 [08:18:06.693] query_string = 0x5567dde26600 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [08:18:06.693] firstchar = [08:18:06.693] input_message = {data = 0x5567dde26600 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [08:18:06.693] local_sigjmp_buf = {{__jmpbuf = {93904419201240, -9083435907158675096, 140721358417504, 93904416144992, 24, 14, -3114523798856568472, -9083438166298234520}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93904592324896, 16128, 93904419195296, 93904592859136, 24, 93904406174548, 0, 9, 2, 93904419201248, 93904592324896, 93904419195296, 93904416144992, 24, 14}}}} [08:18:06.693] send_ready_for_query = false [08:18:06.693] idle_in_transaction_timeout_enabled = false [08:18:06.693] idle_session_timeout_enabled = false [08:18:06.693] __func__ = "PostgresMain" [08:18:06.693] #27 0x00005567d2970511 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [08:18:06.693] bsdata = [08:18:06.693] #28 0x00005567d2810c8c in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffc3e94adf0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffc3e94ae60) at ../src/backend/postmaster/launch_backend.c:290 [08:18:06.693] pid = [08:18:06.693] #29 0x00005567d2816249 in BackendStartup (client_sock=client_sock@entry=0x7ffc3e94ae60) at ../src/backend/postmaster/postmaster.c:3580 [08:18:06.693] bn = 0x5567dde4ed68 [08:18:06.693] pid = [08:18:06.693] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796723849410915, fork_started = 796723849410917} [08:18:06.693] cac = [08:18:06.693] __func__ = "BackendStartup" [08:18:06.693] #30 0x00005567d2818734 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [08:18:06.693] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "\224>\374\177\000\000\364\256\224>\374\177", '\000' , "\351@\225\321gU\000\000\320\v\221\321gU\000\000\300\257\224>\374\177\000\000\270\257\224>\374\177\000\000\225[\362\001\000\000\000\000\250tH\261\b\177\000\000,", '\000' , "\367?\225\321gU\000\000h\006\003\262\b\177\000\000@vH\261\b\177\000", __ss_align = 139675323007712}, salen = 2}} [08:18:06.693] i = 0 [08:18:06.693] now = [08:18:06.693] last_lockfile_recheck_time = 1743408640 [08:18:06.693] last_touch_time = 1743408640 [08:18:06.693] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 138, user_data = 0x0}, {pos = -1308425504, events = 32520, fd = 2090263927, user_data = 0x7ffc3e94b040}, {pos = -1308599736, events = 32520, fd = 16, user_data = 0x7f08b1487640}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1308425504, events = 32520, fd = 1049931704, user_data = 0x7ffc3e94afc0}, {pos = -1308424600, events = 32520, fd = 0, user_data = 0x5567dde26618}, {pos = -758459978, events = 21863, fd = 32768, user_data = 0x1}, {pos = -572357968, events = 21863, fd = -1, user_data = 0x7f08b062e020}, {pos = -1313381168, events = 32520, fd = -572178168, user_data = 0x5567dde53fe8}, {pos = -572179007, events = 21863, fd = -1308574018, user_data = 0x1}, {pos = -1308425504, events = 32520, fd = 430, user_data = 0x5567d31ddd70 }, {pos = 0, events = 0, fd = 0, user_data = 0xe5}, {pos = -1308574018, events = 32520, fd = 1, user_data = 0x0}, {pos = -1335697376, events = 32520, fd = -1334890880, user_data = 0x10}, {pos = 1049932816, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1308564806, user_data = 0x0}, {pos = -1335169580, events = 32520, fd = 0, user_data = 0x5567d38b0780 }, {pos = 2, events = 0, fd = 0, user_data = 0x5567ddde89c0}, {pos = -762281236, events = 21863, fd = -572157957, user_data = 0x5567d290c10c }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5567dde26618}, {pos = -1308574018, events = 32520, fd = 1, user_data = 0x0}, {pos = -1335663416, events = 32520, fd = -1335244672, user_data = 0x44d}, {pos = -1335136099, events = 32520, fd = 2, user_data = 0x5567dde58fa0}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1333846944, events = 32520, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5567dde53de0}, {pos = -758786985, events = 21863, fd = 1024, user_data = 0x7f08b06b58ee}, {pos = -1333863968, events = 32520, fd = -1335226002, user_data = 0x100000400}, {pos = 7, events = 0, fd = -572177936, user_data = 0xb0eeca03aa482b00}, {pos = -1333860896, events = 32520, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x65fb}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x106}, {pos = -1334890349, events = 32520, fd = -572178976, user_data = 0x1}, {pos = -572178776, events = 21863, fd = 1024, user_data = 0x7ffc3e94b4e8}, {pos = -758705845, events = 21863, fd = -745758576, user_data = 0x5567d2c5fc08 }, {pos = -572178976, events = 21863, fd = -572365568, user_data = 0x5567dde53de0}, {pos = -1335142162, events = 32520, fd = 0, user_data = 0x5567d2c71872 }, {pos = -572178976, events = 1, fd = -758703685, user_data = 0x5567dde26500}, {pos = -1335219535, events = 32520, fd = -1335225104, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1438110976, events = 2968439299, fd = -572618304, user_data = 0xb0eeca03aa482b00}, {pos = 13, events = 0, fd = -1438110976, user_data = 0x0}, {pos = -1335512519, events = 32520, fd = 0, user_data = 0x5567d2810972 }, {pos = 4194304, events = 0, fd = -572531664, user_data = 0x1}, {pos = 0, events = 0, fd = -572618304, user_data = 0x5567d2c5fa9c }, {pos = -572531664, events = 21863, fd = -572365568, user_data = 0x5567dddfdc30}, {pos = 1, events = 0, fd = 0, user_data = 0x5567d2c1dc9c }, {pos = 13, events = 0, fd = -572187640, user_data = 0x5567dde51be8}, {pos = -745861864, events = 21863, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -763294932, user_data = 0x5567dde26500}, {pos = -763278031, events = 21863, fd = -749548432, user_data = 0x5567dde26ea8}} [08:18:06.693] nevents = 1 [08:18:06.693] __func__ = "ServerLoop" [08:18:06.693] #31 0x00005567d2819f98 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5567ddde4830) at ../src/backend/postmaster/postmaster.c:1399 [08:18:06.693] opt = [08:18:06.693] status = [08:18:06.693] userDoption = [08:18:06.693] listen_addr_saved = false [08:18:06.693] output_config_variable = [08:18:06.693] __func__ = "PostmasterMain" [08:18:06.693] #32 0x00005567d2648f89 in main (argc=4, argv=0x5567ddde4830) at ../src/backend/main/main.c:227 [08:18:06.693] do_check_root = [08:18:06.693] dispatch_option =