[22:35:21.624] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:35:21.843] dumping /tmp/cores/postgres-6-37106.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:35:22.082] [New LWP 37106] [22:35:22.082] [22:35:22.082] This GDB supports auto-downloading debuginfo from the following URLs: [22:35:22.082] [22:35:22.082] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:35:22.082] Debuginfod has been disabled. [22:35:22.082] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:35:22.199] [Thread debugging using libthread_db enabled] [22:35:22.199] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:35:22.199] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [22:35:22.199] Program terminated with signal SIGABRT, Aborted. [22:35:22.199] #0 0x00007f028cca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.371] [22:35:22.371] Thread 1 (Thread 0x7f028c9e5040 (LWP 37106)): [22:35:22.371] #0 0x00007f028cca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.371] No symbol table info available. [22:35:22.371] #1 0x00007f028cc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.371] No symbol table info available. [22:35:22.371] #2 0x00007f028cc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.371] No symbol table info available. [22:35:22.371] #3 0x000055a625275197 in ExceptionalCondition (conditionName=conditionName@entry=0x55a6254b4ce0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x55a6254b4808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [22:35:22.371] No locals. [22:35:22.371] #4 0x000055a624955d59 in _bt_checkkeys (scan=scan@entry=0x55a66464e238, pstate=pstate@entry=0x7ffcf517ed50, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7f02887f6fe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [22:35:22.371] tupdesc = 0x7f02881bf538 [22:35:22.371] so = [22:35:22.371] dir = BackwardScanDirection [22:35:22.371] ikey = 0 [22:35:22.371] res = [22:35:22.371] #5 0x000055a624942fea in _bt_readpage (scan=scan@entry=0x55a66464e238, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [22:35:22.371] iid = 0x7f02887f5018 [22:35:22.371] itup = 0x7f02887f6fe0 [22:35:22.371] tuple_alive = true [22:35:22.371] passes_quals = [22:35:22.371] rel = [22:35:22.371] so = 0x55a66465a108 [22:35:22.371] page = [22:35:22.371] opaque = [22:35:22.371] minoff = 1 [22:35:22.371] maxoff = [22:35:22.371] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7f02887f6fe0, page = 0x7f02887f5000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [22:35:22.371] arrayKeys = true [22:35:22.371] itemIndex = 1357 [22:35:22.371] indnatts = 2 [22:35:22.371] #6 0x000055a624943eb6 in _bt_readfirstpage (scan=scan@entry=0x55a66464e238, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [22:35:22.371] so = 0x55a66465a108 [22:35:22.371] #7 0x000055a6249476dd in _bt_first (scan=scan@entry=0x55a66464e238, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [22:35:22.371] rel = 0x7f02881be8b8 [22:35:22.371] so = 0x55a66465a108 [22:35:22.371] stack = [22:35:22.371] offnum = [22:35:22.371] 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 = 0x55a62491f3fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55a664613af0, fn_expr = 0x55a6646582f8}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x55a62491f3fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x55a664613af0, fn_expr = 0x55a664658348}, sk_argument = 500}, {sk_flags = 1684235000, sk_attno = 21926, sk_strategy = 0, sk_subtype = 4111989096, sk_collation = 32764, sk_func = {fn_addr = 0x7ffcf517f960, fn_oid = 1684242632, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 111 'o', fn_extra = 0x156, fn_mcxt = 0x55a6646362f8, fn_expr = 0x55a66458efa8}, sk_argument = 94172070438695}, {sk_flags = 1683551256, sk_attno = 21926, 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 = 0x55a6646362f8, fn_oid = 0, fn_nargs = 0, fn_strict = 16, fn_retset = 64, fn_stats = 217 '\331', fn_extra = 0x55a6643cd520, fn_mcxt = 0x55a62528d87c , fn_expr = 0x7ffcf517fa2c}, sk_argument = 139648929567264}, {sk_flags = 1684240248, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a6646380c8, fn_oid = 1682753952, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a6644cbcd0, fn_mcxt = 0x7ffcf517fa2c, 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 = 0x55a62528ddff , fn_oid = 1683550120, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x7ffcf517faa8, fn_mcxt = 0x0, fn_expr = 0x55a664637778}, sk_argument = 94172076212744}, {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 = 176 '\260', fn_extra = 0x7ffcf517faa8, fn_mcxt = 0x0, fn_expr = 0x55a62526836f }, sk_argument = 94173137172344}, {sk_flags = 1683553016, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1683550120, sk_collation = 21926, sk_func = {fn_addr = 0x55a624ced3e7 , fn_oid = 1683555720, fn_nargs = 21926, 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 = 0x55a66458efa8, fn_oid = 617533572, fn_nargs = 21926, 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 = 0x55a664637778, fn_mcxt = 0x55a6643cf3f8, fn_expr = 0x1}, sk_argument = 94173137172344}, {sk_flags = 1683550120, sk_attno = 21926, sk_strategy = 0, sk_subtype = 617454270, sk_collation = 21926, sk_func = {fn_addr = 0x55a6643cf3f8, fn_oid = 1683551416, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x55a624d04b35 , fn_mcxt = 0x7ffcf517fc70, fn_expr = 0x55a664637778}, sk_argument = 94173137172344}, {sk_flags = -182977432, sk_attno = 32764, sk_strategy = 0, sk_subtype = 1684241768, sk_collation = 21926, sk_func = {fn_addr = 0x55a624d97205 , 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 = 617496865, sk_attno = 21926, 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 = 623609817, sk_collation = 21926, sk_func = {fn_addr = 0x55a6643cd520, fn_oid = 56, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0x55a6252b87d9 , fn_mcxt = 0x55a6643cd520, fn_expr = 0x28}, sk_argument = 3}, {sk_flags = 623614234, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1681708320, sk_collation = 0, sk_func = {fn_addr = 0x3, fn_oid = 3, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 8 '\b', fn_extra = 0x55a664637e08, fn_mcxt = 0x55a624d63d6d , fn_expr = 0x7ffcf517ffb0}, sk_argument = 94172076525478}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 617325043, sk_collation = 21926, sk_func = {fn_addr = 0x7ffcf517ffb0, fn_oid = 617334784, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a6645912b0, fn_mcxt = 0x7ffcf517ffc0, fn_expr = 0x7ffcf517ffc0}, sk_argument = 1}, {sk_flags = 623593382, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1684240248, sk_collation = 21926, sk_func = {fn_addr = 0x55a624cba1f3 , fn_oid = 1681708320, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 96 '`', fn_extra = 0x55a624d64929 , fn_mcxt = 0x55a66458f418, fn_expr = 0x7ffcf517ffc0}, sk_argument = 140724420476864}, {sk_flags = 1, sk_attno = 0, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x55a664637778, fn_oid = 618023314, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a66458f468, fn_mcxt = 0x55a624d64929 , fn_expr = 0x55a624cbb119 }, sk_argument = 94173136491024}, {sk_flags = 618019085, sk_attno = 21926, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a66458f468, fn_oid = 4111990720, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x1, fn_mcxt = 0x55a6252b87d9 , fn_expr = 0x55a664613af0}, sk_argument = 1024}, {sk_flags = 7, sk_attno = 0, sk_strategy = 0, sk_subtype = 623614234, sk_collation = 21926, sk_func = {fn_addr = 0x24d64929, fn_oid = 7, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 152 '\230', fn_extra = 0x55a664614ea8, fn_mcxt = 0x7ffcf5180050, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 1684098992, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1684098984, sk_collation = 21926, sk_func = {fn_addr = 0x55a6252cec24 , fn_oid = 1684240248, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 18 '\022', fn_extra = 0x2, fn_mcxt = 0x55a664614ea8, fn_expr = 0x55a664614f88}, sk_argument = 94172069045422}, {sk_flags = 1684235000, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1683561264, sk_collation = 21926, sk_func = {fn_addr = 0x55a664614fa8, fn_oid = 1684098992, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 6 '\006', fn_extra = 0x55a624d64da6 , fn_mcxt = 0x3, fn_expr = 0x55a6645913a0}, sk_argument = 94173137172344}, {sk_flags = -1932824777, sk_attno = 32514, sk_strategy = 0, sk_subtype = 1684240248, sk_collation = 21926, sk_func = {fn_addr = 0x2d000, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x55a66458f5e8, fn_mcxt = 0x7f028ccb6f37, 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 = 0x55a664465240, fn_oid = 2363432032, fn_nargs = 32514, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 94173137026032}, {sk_flags = -1932821830, sk_attno = 32514, sk_strategy = 0, sk_subtype = 1684093680, sk_collation = 21926, sk_func = {fn_addr = 0x55a6252b87d9 , fn_oid = 1684093680, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x55a6252b89c4 , fn_expr = 0x55a664613af0}, sk_argument = 16384}, {sk_flags = 1684100152, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1684331488, sk_collation = 21926, sk_func = {fn_addr = 0x55a664615518, fn_oid = 623613782, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x55a6252b991a , fn_mcxt = 0x64465240, fn_expr = 0x55a66465a108}, sk_argument = 94173137265208}}} [22:35:22.371] startKeys = {0x55a66464e488, 0x55a66464e4d0, 0x408f680000000000, 0x0, 0x4014000000000000, 0x55a6251c825b , 0x55a664637778, 0x3ff0000000000000, 0x4034000000000000, 0x3f747ae147ae147b, 0x7ffcf517f840, 0x4010000000000000, 0x55a66458ff48, 0x0, 0x55a66458ff48, 0x4069000000000000, 0x55a6646380c8, 0x0, 0x0, 0x55a6251c925b , 0x0, 0x3ff0000000000000, 0x8876e418, 0x0, 0x0, 0x3ff0000000000000, 0x55a664590038, 0x55a664637778, 0x101000000000000, 0x55a62528d87c , 0x7ffcf517f8ac, 0x7f028cd71220} [22:35:22.371] notnullkeys = {{sk_flags = -1977763350, sk_attno = -18019, sk_strategy = 5726, sk_subtype = 1653676222, sk_collation = 1060410173, sk_func = {fn_addr = 0xc528628c70b0fe14, fn_oid = 436399102, fn_nargs = -3850, fn_strict = 152, fn_retset = 33, fn_stats = 118 'v', fn_extra = 0xf47833938c826460, fn_mcxt = 0x36a37d6b6fa93b6d, fn_expr = 0x55a624f5140e }, sk_argument = 0}, {sk_flags = 0, sk_attno = 7684, sk_strategy = 3213, sk_subtype = 626266216, sk_collation = 21926, sk_func = {fn_addr = 0x55a624f8f243 , fn_oid = 2289492544, fn_nargs = 32514, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x1000000, fn_mcxt = 0x0, fn_expr = 0x70}, sk_argument = 94172072973598}, {sk_flags = -2004807680, sk_attno = 32514, sk_strategy = 0, sk_subtype = 2290159616, sk_collation = 32514, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 64 '@', fn_extra = 0x55a624f52b05 , fn_mcxt = 0x3b600000000, fn_expr = 0x55a600000001}, sk_argument = 140724420474396}, {sk_flags = -182979040, sk_attno = 32764, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x3706382d0, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3b600000000, fn_mcxt = 0x55a62491fa25 , fn_expr = 0x1000200000164}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 620116281, sk_collation = 21926, sk_func = {fn_addr = 0x0, fn_oid = 620128580, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x1, fn_expr = 0x55a6643f3db8}, sk_argument = 32768}, {sk_flags = 8192, sk_attno = 0, sk_strategy = 0, sk_subtype = 4111989472, sk_collation = 32764, sk_func = {fn_addr = 0x55a624fc52e9 , fn_oid = 4, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x55a66459b958, fn_mcxt = 0x5, fn_expr = 0x52}, sk_argument = 8192}, {sk_flags = -5, sk_attno = -1, sk_strategy = 65535, sk_subtype = 614128293, sk_collation = 21926, sk_func = {fn_addr = 0x1, fn_oid = 3601, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x55a664637960, fn_expr = 0x100030000}, sk_argument = 4080218931200}, {sk_flags = 620116281, sk_attno = 21926, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a624f66944 , fn_oid = 1683553016, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x55a6643f33f8, fn_expr = 0x0}, sk_argument = 8192}, {sk_flags = -182977616, sk_attno = 32764, sk_strategy = 0, sk_subtype = 620516073, sk_collation = 21926, sk_func = {fn_addr = 0x7f028886d000, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 72 'H', fn_extra = 0x1, fn_mcxt = 0x7f028881b000, fn_expr = 0x2000}, sk_argument = 4080218931200}, {sk_flags = 613546533, sk_attno = 21926, sk_strategy = 0, sk_subtype = 356, sk_collation = 65538, sk_func = {fn_addr = 0x2, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x55a66447acb0, fn_mcxt = 0x4eb3, fn_expr = 0x200030000}, sk_argument = 4080218931200}, {sk_flags = 613544562, sk_attno = 21926, sk_strategy = 0, sk_subtype = 350, sk_collation = 65538, sk_func = {fn_addr = 0x2, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 32 ' ', fn_extra = 0x55a66447b168, fn_mcxt = 0x2, fn_expr = 0x55a62491fa25 }, sk_argument = 281474976710913}, {sk_flags = 620826301, sk_attno = 21926, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x6, fn_oid = 2338075329, fn_nargs = -6876, fn_strict = 84, fn_retset = 176, fn_stats = 121 'y', fn_extra = 0x23901bed0140a2ad, fn_mcxt = 0x6528ff8b23ae87d1, fn_expr = 0x228241927500167c}, sk_argument = 16458887114264932434}, {sk_flags = -1176799471, sk_attno = 12064, sk_strategy = 20525, sk_subtype = 3208140173, sk_collation = 731857386, sk_func = {fn_addr = 0xca8f4dd141f6dff9, fn_oid = 3086517166, fn_nargs = 27930, fn_strict = 230, fn_retset = 221, fn_stats = 169 '\251', fn_extra = 0x55a624f5140e , fn_mcxt = 0x0, fn_expr = 0xed80623300000000}, sk_argument = 94172079198312}, {sk_flags = 620294723, sk_attno = 21926, sk_strategy = 0, sk_subtype = 2289492992, sk_collation = 32514, sk_func = {fn_addr = 0x1, fn_oid = 16777216, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x70, fn_mcxt = 0x55a624f5151e , fn_expr = 0x7f028881f000}, sk_argument = 139648856879104}, {sk_flags = 4, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7f028876e400, fn_oid = 620047109, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x1, fn_mcxt = 0x7ffcf517f96c, fn_expr = 0x7ffcf517f970}, sk_argument = 17179869185}, {sk_flags = 1879048194, sk_attno = 3, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x400000000, fn_oid = 2290454528, fn_nargs = 32514, fn_strict = false, fn_retset = false, fn_stats = 165 '\245', fn_extra = 0x55a6646379f0, fn_mcxt = 0xe12, fn_expr = 0xe17}, sk_argument = 94172073115603}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 636535152, sk_collation = 21926, sk_func = {fn_addr = 0x7f0001000101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x55a62491fa25 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a6643cd520, fn_oid = 1682418864, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 179 '\263', fn_extra = 0x200000059, fn_mcxt = 0x3b600000000, fn_expr = 0x55a62491f272 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a6643cd520, fn_oid = 1682420072, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a62491fa25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 1681708320, sk_attno = 21926, sk_strategy = 0, sk_subtype = 257, sk_collation = 21760, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3b600000000, fn_mcxt = 0x55a62491fa25 , fn_expr = 0x1000200000164}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1681708320, sk_collation = 21926, sk_func = {fn_addr = 0x55a6644a7ae0, fn_oid = 20144, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a62491fa25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 623433852, sk_attno = 21926, sk_strategy = 0, sk_subtype = 4111987840, sk_collation = 32764, sk_func = {fn_addr = 0x7f028cd71220, fn_oid = 4111989580, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3200000001, fn_mcxt = 0x55a62490695b , fn_expr = 0x55a66458f5a8}, sk_argument = 94172066395451}, {sk_flags = 226426016, sk_attno = 0, sk_strategy = 0, sk_subtype = 2288449280, sk_collation = 32514, sk_func = {fn_addr = 0x1, fn_oid = 620380144, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x55a624fa5e79 , fn_mcxt = 0x7f028876e258, fn_expr = 0x0}, sk_argument = 3678937116}, {sk_flags = 1681441616, sk_attno = 21926, sk_strategy = 0, sk_subtype = 2290552832, sk_collation = 32514, sk_func = {fn_addr = 0x1, fn_oid = 20, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 31 '\037', fn_extra = 0x7ffcf517f590, fn_mcxt = 0x7f028cd71220, fn_expr = 0x1c00000052}, sk_argument = 140724420474159}, {sk_flags = -2005474752, sk_attno = 32514, sk_strategy = 0, sk_subtype = 2290568656, sk_collation = 32514, sk_func = {fn_addr = 0x55a664636628, fn_oid = 1684235888, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 184 '\270', fn_extra = 0x7f0200000000, fn_mcxt = 0x7f028881f000, fn_expr = 0x7ffc00001679}, sk_argument = 94172079201696}, {sk_flags = 620380144, sk_attno = 21926, sk_strategy = 0, sk_subtype = 2288448768, sk_collation = 32514, sk_func = {fn_addr = 0x55a624fa5e79 , fn_oid = 2289492544, fn_nargs = 32514, fn_strict = false, fn_retset = false, fn_stats = 219 '\333', fn_extra = 0xb662cf78, fn_mcxt = 0x7ffcf517f61c, fn_expr = 0x7ffcf517f61c}, sk_argument = 139648855110912}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 3, sk_func = {fn_addr = 0xffffffff, fn_oid = 623577028, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x7ffcf517f6af, fn_mcxt = 0x40000000067f, fn_expr = 0x55a625236b15 }, sk_argument = 94171452932096}, {sk_flags = 623076668, sk_attno = 21926, sk_strategy = 0, sk_subtype = 2287191504, sk_collation = 32514, sk_func = {fn_addr = 0x7f028853c5d0, fn_oid = 2287191464, fn_nargs = 32514, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x55a66443ef00, fn_mcxt = 0x55a62523a642 , fn_expr = 0x101}, sk_argument = 94172076525478}, {sk_flags = 3, sk_attno = 21926, sk_strategy = 0, sk_subtype = 617325043, sk_collation = 21926, sk_func = {fn_addr = 0x3b600000000, fn_oid = 621869391, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 103 'g', fn_extra = 0x55a664637e08, fn_mcxt = 0x7ffcf517f6c0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 1684240248, sk_attno = 21926, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a624ce4121 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x53d90092, fn_mcxt = 0x55a6644cc9a0, fn_expr = 0x1}, sk_argument = 94173135682768}, {sk_flags = -182978836, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x7ffcf517f700, fn_oid = 1683555400, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x55a664637778, fn_expr = 0x55a624ce3902 }, sk_argument = 94173137172344}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x55a625268208 , fn_oid = 1684242008, fn_nargs = 21926, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x1, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}} [22:35:22.371] keysz = 2 [22:35:22.371] strat_total = 3 [22:35:22.371] blkno = 4294967295 [22:35:22.371] lastcurrblkno = 1878802059 [22:35:22.371] __func__ = "_bt_first" [22:35:22.371] #8 0x000055a62493da8c in btgettuple (scan=0x55a66464e238, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [22:35:22.371] so = 0x55a66465a108 [22:35:22.371] res = [22:35:22.371] #9 0x000055a62491d118 in index_getnext_tid (scan=scan@entry=0x55a66464e238, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [22:35:22.371] found = [22:35:22.371] __func__ = "index_getnext_tid" [22:35:22.371] #10 0x000055a624c265f2 in IndexOnlyNext (node=node@entry=0x55a6646141c8) at ../src/backend/executor/nodeIndexonlyscan.c:121 [22:35:22.371] estate = 0x55a664613bf0 [22:35:22.371] econtext = 0x55a6646143d8 [22:35:22.371] direction = BackwardScanDirection [22:35:22.371] scandesc = 0x55a66464e238 [22:35:22.371] slot = 0x55a6646145f8 [22:35:22.371] tid = [22:35:22.371] __func__ = "IndexOnlyNext" [22:35:22.371] #11 0x000055a624bdef8e in ExecScanFetch (recheckMtd=0x55a624c25d3f , accessMtd=0x55a624c26523 , epqstate=0x0, node=0x55a6646141c8) at ../src/include/executor/execScan.h:126 [22:35:22.371] No locals. [22:35:22.371] #12 ExecScanExtended (projInfo=0x55a664614988, qual=0x0, epqstate=0x0, recheckMtd=0x55a624c25d3f , accessMtd=0x55a624c26523 , node=0x55a6646141c8) at ../src/include/executor/execScan.h:187 [22:35:22.371] slot = [22:35:22.371] econtext = 0x55a6646143d8 [22:35:22.371] econtext = [22:35:22.371] slot = [22:35:22.371] #13 ExecScan (node=node@entry=0x55a6646141c8, accessMtd=accessMtd@entry=0x55a624c26523 , recheckMtd=recheckMtd@entry=0x55a624c25d3f ) at ../src/backend/executor/execScan.c:59 [22:35:22.371] epqstate = 0x0 [22:35:22.371] qual = 0x0 [22:35:22.371] projInfo = 0x55a664614988 [22:35:22.371] #14 0x000055a624c26188 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [22:35:22.371] node = 0x55a6646141c8 [22:35:22.371] #15 0x000055a624bd77e3 in ExecProcNodeFirst (node=0x55a6646141c8) at ../src/backend/executor/execProcnode.c:469 [22:35:22.371] No locals. [22:35:22.371] #16 0x000055a624c2eee7 in ExecProcNode (node=node@entry=0x55a6646141c8) at ../src/include/executor/executor.h:341 [22:35:22.371] No locals. [22:35:22.371] #17 0x000055a624c2f7e1 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [22:35:22.371] node = 0x55a664613e58 [22:35:22.371] econtext = 0x55a664614068 [22:35:22.371] direction = [22:35:22.371] slot = [22:35:22.371] outerPlan = 0x55a6646141c8 [22:35:22.371] __func__ = "ExecLimit" [22:35:22.371] #18 0x000055a624bd77e3 in ExecProcNodeFirst (node=0x55a664613e58) at ../src/backend/executor/execProcnode.c:469 [22:35:22.371] No locals. [22:35:22.371] #19 0x000055a624bc12c8 in ExecProcNode (node=node@entry=0x55a664613e58) at ../src/include/executor/executor.h:341 [22:35:22.371] No locals. [22:35:22.371] #20 0x000055a624bc1e18 in ExecutePlan (queryDesc=queryDesc@entry=0x55a6646383d0, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55a664590f10) at ../src/backend/executor/execMain.c:1783 [22:35:22.371] estate = 0x55a664613bf0 [22:35:22.371] planstate = 0x55a664613e58 [22:35:22.371] use_parallel_mode = false [22:35:22.371] slot = [22:35:22.371] current_tuple_count = 0 [22:35:22.371] #21 0x000055a624bc34d3 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x55a6646383d0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:435 [22:35:22.371] estate = 0x55a664613bf0 [22:35:22.371] operation = CMD_SELECT [22:35:22.371] dest = 0x55a664590f10 [22:35:22.371] sendTuples = [22:35:22.371] oldcontext = 0x55a6646382d0 [22:35:22.371] #22 0x00007f028aa26805 in pgss_ExecutorRun (queryDesc=0x55a6646383d0, direction=ForwardScanDirection, count=0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1043 [22:35:22.371] _save_exception_stack = 0x7ffcf5180550 [22:35:22.371] _save_context_stack = 0x0 [22:35:22.371] _local_sigjmp_buf = {{__jmpbuf = {94173135176800, -3701993426905170969, 0, 1, 94173134645552, 94173134645504, -7481954110716216345, -7361629383366378521}, __mask_was_saved = 0, __saved_mask = {__val = {94172076541431, 94173137175248, 94172076545962, 0, 2, 0, 94173135262272, 94173135262272, 1, 1, 94173134645552, 94173134645504, 94172076631346, 94173135262224, 94172076786741, 94173135262272}}}} [22:35:22.371] _do_rethrow = false [22:35:22.371] #23 0x000055a624bc3529 in ExecutorRun (queryDesc=queryDesc@entry=0x55a6646383d0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:369 [22:35:22.371] No locals. [22:35:22.371] #24 0x000055a624fd7636 in PortalRunSelect (portal=portal@entry=0x55a664450460, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55a664590f10) at ../src/backend/tcop/pquery.c:953 [22:35:22.371] queryDesc = 0x55a6646383d0 [22:35:22.371] direction = [22:35:22.371] nprocessed = [22:35:22.371] __func__ = "PortalRunSelect" [22:35:22.371] #25 0x000055a624fdac8a in PortalRun (portal=portal@entry=0x55a664450460, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55a664590f10, altdest=altdest@entry=0x55a664590f10, qc=qc@entry=0x7ffcf5180670) at ../src/backend/tcop/pquery.c:797 [22:35:22.371] _save_exception_stack = 0x7ffcf5180720 [22:35:22.371] _save_context_stack = 0x0 [22:35:22.371] _local_sigjmp_buf = {{__jmpbuf = {0, -3701993105160111129, 94173135176800, 94173134645576, 94173134645552, 94173134645504, -7481954110898668569, -3702132978120492057}, __mask_was_saved = 0, __saved_mask = {__val = {94172076545962, 4111992319, 4, 94173134645504, 112, 179, 94173135176800, 94173134645576, 94173134645552, 94173134645504, 94172076633533, 179, 2, 179, 94172065700835, 0}}}} [22:35:22.371] _do_rethrow = [22:35:22.371] result = [22:35:22.371] nprocessed = [22:35:22.371] saveTopTransactionResourceOwner = 0x55a664411e68 [22:35:22.371] saveTopTransactionContext = 0x55a664465110 [22:35:22.371] saveActivePortal = 0x0 [22:35:22.371] saveResourceOwner = 0x55a664411e68 [22:35:22.371] savePortalContext = 0x0 [22:35:22.371] saveMemoryContext = 0x55a664465110 [22:35:22.371] __func__ = "PortalRun" [22:35:22.371] #26 0x000055a624fd3833 in exec_simple_query (query_string=query_string@entry=0x55a6643cd620 "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 [22:35:22.371] cmdtaglen = 6 [22:35:22.371] snapshot_set = [22:35:22.371] per_parsetree_context = 0x0 [22:35:22.371] plantree_list = 0x55a664591900 [22:35:22.371] parsetree = 0x55a6643ce900 [22:35:22.371] commandTag = [22:35:22.371] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:35:22.371] querytree_list = [22:35:22.371] portal = 0x55a664450460 [22:35:22.371] receiver = 0x55a664590f10 [22:35:22.371] format = 0 [22:35:22.371] cmdtagname = [22:35:22.371] parsetree_item__state = [22:35:22.371] dest = DestRemote [22:35:22.371] oldcontext = 0x55a664465110 [22:35:22.371] parsetree_list = 0x55a6643ce930 [22:35:22.371] parsetree_item = 0x55a6643ce948 [22:35:22.371] save_log_statement_stats = false [22:35:22.371] was_logged = true [22:35:22.371] use_implicit_block = false [22:35:22.371] msec_str = "@\211\303%\246U\000\000%\263)%\246U\000\000\000\a\030\365\374\177\000\000m\000\000\000\000\000\000" [22:35:22.371] __func__ = "exec_simple_query" [22:35:22.371] #27 0x000055a624fd6a57 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4759 [22:35:22.371] query_string = 0x55a6643cd620 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [22:35:22.371] firstchar = [22:35:22.371] input_message = {data = 0x55a6643cd620 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [22:35:22.371] local_sigjmp_buf = {{__jmpbuf = {94172089559832, -3702130740480410649, 140724420479216, 94172086503744, 24, 5, -7481954110831559705, -3702132984366990361}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94173134896656, 0, 168, 94172076546432, 0, 10, 2, 94172089559840, 94173134371168, 94172089553888, 94172086503744, 24, 5}}}} [22:35:22.371] send_ready_for_query = false [22:35:22.371] idle_in_transaction_timeout_enabled = false [22:35:22.371] idle_session_timeout_enabled = false [22:35:22.371] __func__ = "PostgresMain" [22:35:22.371] #28 0x000055a624fcc3ee in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [22:35:22.371] bsdata = [22:35:22.371] #29 0x000055a624e70bcd in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffcf5180880, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffcf51808f0) at ../src/backend/postmaster/launch_backend.c:290 [22:35:22.371] pid = [22:35:22.371] #30 0x000055a624e7618a in BackendStartup (client_sock=client_sock@entry=0x7ffcf51808f0) at ../src/backend/postmaster/postmaster.c:3580 [22:35:22.371] bn = 0x55a6643f8da8 [22:35:22.371] pid = [22:35:22.371] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796516165093956, fork_started = 796516165093964} [22:35:22.371] cac = [22:35:22.371] __func__ = "BackendStartup" [22:35:22.371] #31 0x000055a624e78675 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [22:35:22.371] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\t`\373#\246U\000\000\260+\367#\246U\000\000@\n\030\365\374\177\000\0008\n\030\365\374\177\000\000\225[\362\001\000\000\000\000\360\201?d\246U\000\000-", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\006M\216\002\177\000\000@\206\250\215\002\177\000\000\340\002M\216\002\177\000\000\316)fR\000\000\000", __ss_align = 4111993472}, salen = 2}} [22:35:22.371] i = 0 [22:35:22.371] now = [22:35:22.371] last_lockfile_recheck_time = 1743200957 [22:35:22.371] last_touch_time = 1743200957 [22:35:22.371] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = -1907555616, user_data = 0x0}, {pos = -182973760, events = 32764, fd = -1907729848, user_data = 0x10}, {pos = -1918335424, events = 32514, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1907555616, user_data = 0x7ffcf5180a38}, {pos = -182973888, events = 32764, fd = -1907554712, user_data = 0x0}, {pos = 1681894648, events = 21926, fd = -1932821830, user_data = 0x55a6643facf8}, {pos = 1, events = 21926, fd = 32768, user_data = 0xffffffff}, {pos = -1933385696, events = 32514, fd = -1911356208, user_data = 0x55a664403418}, {pos = 1681928952, events = 21926, fd = 1681905489, user_data = 0x7f028e4abebe}, {pos = 1, events = 0, fd = -1907555616, user_data = 0x1ae}, {pos = 629374320, events = 21926, fd = 0, user_data = 0x0}, {pos = 86, events = 0, fd = -1907704130, user_data = 0x1}, {pos = 0, events = 0, fd = -1933385696, user_data = 0x7f028ccf2e80 }, {pos = 16, events = 0, fd = -182972768, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f028e4ae2ba}, {pos = 0, events = 0, fd = -1932857900, user_data = 0x0}, {pos = 636522944, events = 21926, fd = 2, user_data = 0x0}, {pos = 1681455616, events = 21926, fd = 620118229, user_data = 0x55a6644020e0}, {pos = 620122218, events = 21926, fd = 1681924411, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1933351736, user_data = 0x7f028cc9c880 }, {pos = -1935782152, events = 32514, fd = -182972560, user_data = 0x100007f00000002}, {pos = -1932824777, events = 32514, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1931535264, events = 32514, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f028da89540}, {pos = -1918330240, events = 32514, 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 = 1681935632, events = 21926, fd = 1080, user_data = 0x55a6644030f0}, {pos = 623611993, events = 21926, fd = 1024, user_data = 0x7f028ccb579b}, {pos = -1931552288, events = 32514, fd = -1932914322, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1681924320, user_data = 0x2610dfc8533f2900}, {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 = 0x55a6644030f0}, {pos = 3, events = 0, fd = 0, user_data = 0x8b54}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -1932578669, events = 32514, fd = 1681928432, user_data = 0x1}, {pos = 1681928632, events = 21926, fd = 1024, user_data = 0x7ffcf5180f78}, {pos = 623693133, events = 21926, fd = 636627664, user_data = 0x55a6252bb80a }, {pos = 1681928432, events = 21926, fd = 1681708320, user_data = 0x55a6644030f0}, {pos = -1932830821, events = 32514, fd = 0, user_data = 0x55a6252cd474 }, {pos = 1681928432, events = 1, fd = 623695293, user_data = 0x55a6643cd520}, {pos = -1932907855, events = 32514, fd = -1932913424, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1396648192, events = 638640072, fd = 1681455616, user_data = 0x2610dfc8533f2900}, {pos = 13, events = 0, fd = 1396648192, user_data = 0x0}, {pos = -1933200839, events = 32514, fd = 0, user_data = 0x55a624e708b3 }, {pos = 4194304, events = 0, fd = 1681542224, user_data = 0x1}, {pos = 0, events = 0, fd = 1681455616, user_data = 0x55a6252bb69e }, {pos = 1681542224, events = 21926, fd = 1681708320, user_data = 0x55a6643a4c50}, {pos = 1, events = 0, fd = 0, user_data = 0x55a625279b1d }, {pos = 13, events = 0, fd = 1681892136, user_data = 0x55a6643fa308}, {pos = 636524376, events = 21926, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 619121261, user_data = 0x55a6643cd520}, {pos = 619138162, events = 21926, fd = 632843280, user_data = 0x55a6643cded8}} [22:35:22.371] nevents = 1 [22:35:22.371] __func__ = "ServerLoop" [22:35:22.371] #32 0x000055a624e79ed9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a66438b860) at ../src/backend/postmaster/postmaster.c:1399 [22:35:22.371] opt = [22:35:22.371] status = [22:35:22.371] userDoption = [22:35:22.371] listen_addr_saved = false [22:35:22.371] output_config_variable = [22:35:22.371] __func__ = "PostmasterMain" [22:35:22.371] #33 0x000055a624ca8eca in main (argc=4, argv=0x55a66438b860) at ../src/backend/main/main.c:227 [22:35:22.371] do_check_root = [22:35:22.371] dispatch_option = [22:35:22.391] -e [22:35:22.391] [22:35:22.391] [22:35:22.452] dumping /tmp/cores/postgres-6-27229.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:35:22.702] [New LWP 27229] [22:35:22.702] [22:35:22.702] This GDB supports auto-downloading debuginfo from the following URLs: [22:35:22.702] [22:35:22.702] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:35:22.702] Debuginfod has been disabled. [22:35:22.702] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:35:22.798] [Thread debugging using libthread_db enabled] [22:35:22.798] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:35:22.798] Core was generated by `postgres: postgres regression [local] SELECT '. [22:35:22.798] Program terminated with signal SIGABRT, Aborted. [22:35:22.798] #0 0x00007f319a8a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.903] [22:35:22.903] Thread 1 (Thread 0x7f319a7da040 (LWP 27229)): [22:35:22.903] #0 0x00007f319a8a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.903] No symbol table info available. [22:35:22.903] #1 0x00007f319a85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.903] No symbol table info available. [22:35:22.903] #2 0x00007f319a845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:22.903] No symbol table info available. [22:35:22.903] #3 0x0000563ff914a197 in ExceptionalCondition (conditionName=conditionName@entry=0x563ff9389ce0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x563ff9389808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [22:35:22.903] No locals. [22:35:22.903] #4 0x0000563ff882ad59 in _bt_checkkeys (scan=scan@entry=0x5640007155b8, pstate=pstate@entry=0x7ffe2828eb70, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7f31919b0fe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [22:35:22.903] tupdesc = 0x7f318e40b738 [22:35:22.903] so = [22:35:22.903] dir = BackwardScanDirection [22:35:22.903] ikey = 0 [22:35:22.903] res = [22:35:22.903] #5 0x0000563ff8817fea in _bt_readpage (scan=scan@entry=0x5640007155b8, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [22:35:22.903] iid = 0x7f31919af018 [22:35:22.903] itup = 0x7f31919b0fe0 [22:35:22.903] tuple_alive = true [22:35:22.903] passes_quals = [22:35:22.903] rel = [22:35:22.903] so = 0x5640007485f8 [22:35:22.903] page = [22:35:22.903] opaque = [22:35:22.903] minoff = 1 [22:35:22.903] maxoff = [22:35:22.903] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7f31919b0fe0, page = 0x7f31919af000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [22:35:22.903] arrayKeys = true [22:35:22.903] itemIndex = 1357 [22:35:22.903] indnatts = 2 [22:35:22.903] #6 0x0000563ff8818eb6 in _bt_readfirstpage (scan=scan@entry=0x5640007155b8, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [22:35:22.903] so = 0x5640007485f8 [22:35:22.903] #7 0x0000563ff881c6dd in _bt_first (scan=scan@entry=0x5640007155b8, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [22:35:22.903] rel = 0x7f318e40aab8 [22:35:22.903] so = 0x5640007485f8 [22:35:22.903] stack = [22:35:22.903] offnum = [22:35:22.903] 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 = 0x563ff87f43fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5640007809f0, fn_expr = 0x564000745878}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x563ff87f43fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5640007809f0, fn_expr = 0x5640007458c8}, sk_argument = 500}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 673773392, sk_collation = 32766, sk_func = {fn_addr = 0x564000711928, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56400077a5d8, fn_mcxt = 0x563ff8bb8902 , fn_expr = 0x56400077a5d8}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4178825736, sk_collation = 22079, sk_func = {fn_addr = 0x56400077acb8, fn_oid = 4178168496, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94832885307688}, {sk_flags = 673773760, sk_attno = 32766, 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 = 91 '[', fn_extra = 0x56400077a5d8, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x4034000000000000}, sk_argument = 4572414629676717179}, {sk_flags = 673773712, sk_attno = 32766, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x564000711428, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x4069000000000000, fn_mcxt = 0x564000779bb8, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = -116792741, sk_attno = 22079, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 2386598936, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x564000711518}, sk_argument = 94832885736920}, {sk_flags = 0, sk_attno = 0, sk_strategy = 257, sk_subtype = 4178978940, sk_collation = 22079, sk_func = {fn_addr = 0x7ffe2828f8fc, fn_oid = 2593591840, fn_nargs = 32561, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x0, fn_mcxt = 0x7ffe2828f9c0, fn_expr = 0x564000637190}, sk_argument = 3}, {sk_flags = 6513856, sk_attno = 22080, sk_strategy = 0, sk_subtype = 673773820, sk_collation = 32766, 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 = 0x563ff9162dff , fn_expr = 0x3fd199999999999a}, sk_argument = 140729572194744}, {sk_flags = 673774000, sk_attno = 32766, sk_strategy = 0, sk_subtype = 7838648, sk_collation = 22080, sk_func = {fn_addr = 0x56400077a5d8, fn_oid = 4178825736, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x67f00000000, fn_mcxt = 0x564000711518, fn_expr = 0x564000779aa8}, sk_argument = 140729572194744}, {sk_flags = 673774000, sk_attno = 32766, sk_strategy = 0, sk_subtype = 7838648, sk_collation = 22080, sk_func = {fn_addr = 0x563ff913d36f , fn_oid = 342, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 168 '\250', fn_extra = 0x564000779ff8, fn_mcxt = 0x563ff8bbb727 , fn_expr = 0x56400077b1d0}, 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 = 7838376, sk_attno = 22080, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x563ff918d7d9 , fn_oid = 5454000, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 124 '|', fn_extra = 0x7ffe2828fa7c, fn_mcxt = 0x7f319a971220, fn_expr = 0x77a5d8}, sk_argument = 0}, {sk_flags = 7838648, sk_attno = 22080, sk_strategy = 0, sk_subtype = 6517136, sk_collation = 22080, sk_func = {fn_addr = 0x0, fn_oid = 6513856, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 124 '|', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 4620693217682128896}, {sk_flags = -115986945, sk_attno = 22079, sk_strategy = 0, sk_subtype = 7839736, sk_collation = 22080, sk_func = {fn_addr = 0x7ffe2828fb00, fn_oid = 673774328, fn_nargs = 32766, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56400077a5d8, fn_mcxt = 0x563ff913d208 , 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 = 0x7ffe2828fb00, fn_oid = 673774328, fn_nargs = 32766, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563ff913d36f , fn_mcxt = 0x56400077a5d8, fn_expr = 0x56400077b8b0}, sk_argument = 94832885735416}, {sk_flags = -121887769, sk_attno = 22079, sk_strategy = 0, sk_subtype = 7412328, sk_collation = 22080, 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 = 7839736, sk_attno = 22080, sk_strategy = 0, sk_subtype = 4173078660, sk_collation = 22079, sk_func = {fn_addr = 0x564000779ff8, 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 = 0x564000779ff8, fn_oid = 7841240, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 136 '\210', fn_extra = 0x1, fn_mcxt = 0x56400077a5d8, fn_expr = 0x564000779ff8}, sk_argument = 94832755927742}, {sk_flags = 5461896, sk_attno = 22080, sk_strategy = 0, sk_subtype = 7844464, sk_collation = 22080, sk_func = {fn_addr = 0x1, fn_oid = 4173175605, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x56400077a5d8, fn_mcxt = 0x56400077a5d8, fn_expr = 0x7ffe2828fcb8}, sk_argument = 94832885738440}, {sk_flags = -121191931, sk_attno = 22079, 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 = 0x563ff918d7d9 , fn_mcxt = 0x5640007809f0, fn_expr = 0x400}, sk_argument = 7}, {sk_flags = -115807974, sk_attno = 22079, 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 = 168 '\250', fn_extra = 0x7ffe2828fd90, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94832885767856}, {sk_flags = 7872168, sk_attno = 22080, sk_strategy = 0, sk_subtype = 4179246116, sk_collation = 22079, sk_func = {fn_addr = 0x0, fn_oid = 4171653650, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x564000781da8, fn_mcxt = 0x564000781e88, fn_expr = 0x563ff8a674ae }, sk_argument = 0}, {sk_flags = 7417872, sk_attno = 22080, sk_strategy = 0, sk_subtype = 7872168, sk_collation = 22080, sk_func = {fn_addr = 0x564000781eb0, 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 = 0x563ff918d7d9 , fn_mcxt = 0x5640007809f0, fn_expr = 0x40}, sk_argument = 9}, {sk_flags = -116344043, sk_attno = 22079, sk_strategy = 0, sk_subtype = 7872176, sk_collation = 22080, sk_func = {fn_addr = 0x563ff910b53c , fn_oid = 2389408488, fn_nargs = 32561, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x7f318e6b7ac0, fn_mcxt = 0x564000598420, fn_expr = 0x564000597d00}, sk_argument = 94832761566786}, {sk_flags = 7872136, sk_attno = 22080, 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 = 0x322828ff2f, fn_mcxt = 0x60, fn_expr = 0x73}, sk_argument = 139850819533568}, {sk_flags = -1702138057, sk_attno = 32561, sk_strategy = 0, sk_subtype = 7866864, sk_collation = 22080, sk_func = {fn_addr = 0xf940, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x0, fn_mcxt = 0x7f319a8b6f37, 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 = 0x5640005cdd00, fn_oid = 2594118752, fn_nargs = 32561, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 94832885762800}, {sk_flags = -1702135110, sk_attno = 32561, sk_strategy = 0, sk_subtype = 7866864, sk_collation = 22080, sk_func = {fn_addr = 0x563ff918d7d9 , fn_oid = 7866864, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x563ff918d9c4 , fn_expr = 0x5640007809f0}, sk_argument = 16384}, {sk_flags = 7873336, sk_attno = 22080, sk_strategy = 0, sk_subtype = 7426416, sk_collation = 22080, sk_func = {fn_addr = 0x564000782418, fn_oid = 4179158870, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x563ff918e91a , fn_mcxt = 0x5cdd00, fn_expr = 0x5640007485f8}, sk_argument = 94832885323192}}} [22:35:22.903] startKeys = {0x564000715808, 0x564000715850, 0x5640005338b0, 0x8, 0x0, 0x563ff918e91a , 0x8ef23101, 0x0, 0x7f318e89f938, 0x56400053433e, 0x5640005341d0, 0x564000534337, 0x5640005341d0, 0x7ffe28290228, 0x0, 0x563ff918d7d9 , 0x5640005338b0, 0x40, 0x3, 0x563ff91857c4 , 0x563ff944d228, 0x56400053434a, 0x5640005341d0, 0x563ff92ecfbd , 0x56400053434d, 0x5640005341d0, 0x56400053434c, 0x0, 0x7ffe28290228, 0x563ff92f3736 , 0x2, 0x3} [22:35:22.903] notnullkeys = {{sk_flags = 2, sk_attno = 28271, sk_strategy = 27493, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 4169091621, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 100 'd', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x56400077ba80}, sk_argument = 94832884091056}, {sk_flags = 20143, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 4169089650, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x56400077ba80}, sk_argument = 94832884092264}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4169091621, sk_collation = 22079, sk_func = {fn_addr = 0x1000200000164, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56400077ba80, fn_mcxt = 0x560000000101, fn_expr = 0x0}, sk_argument = 1}, {sk_flags = 196608, sk_attno = 4, sk_strategy = 0, sk_subtype = 0, sk_collation = 950, sk_func = {fn_addr = 0x563ff87f4a25 , fn_oid = 7845816, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x56400077b848, fn_mcxt = 0x56400077ba80, fn_expr = 0x5640005ec008}, sk_argument = 20146}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 4175661369, sk_collation = 22079, sk_func = {fn_addr = 0x0, fn_oid = 4175673668, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 24 '\030', fn_extra = 0x0, fn_mcxt = 0x1, fn_expr = 0x564000559bd0}, sk_argument = 32768}, {sk_flags = 8192, sk_attno = 0, sk_strategy = 0, sk_subtype = 673773824, sk_collation = 32766, sk_func = {fn_addr = 0x563ff8e9a2e9 , fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x564000739398, fn_mcxt = 0x5, fn_expr = 0x7f31919af000}, sk_argument = 8192}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 8192, sk_collation = 0, sk_func = {fn_addr = 0x7ffe2828f950, fn_oid = 4176061161, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x564000739398, fn_expr = 0x1}, sk_argument = 139637976727809}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 3, sk_collation = 4280287489, 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 = 94832883349680}, {sk_flags = 6235976, sk_attno = 22080, 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 = 94832883349680}, {sk_flags = 6236136, sk_attno = 22080, 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 = 94832883349680}, {sk_flags = 6236216, sk_attno = 22080, sk_strategy = 0, sk_subtype = 1976, sk_collation = 0, sk_func = {fn_addr = 0x564000535378, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x89800000000, fn_expr = 0x4ea9}, sk_argument = 8589934602}, {sk_flags = 20135, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 3212836864, sk_func = {fn_addr = 0x0, fn_oid = 0, fn_nargs = 1, fn_strict = 112, fn_retset = 114, fn_stats = 2 '\002', fn_extra = 0x640100, fn_mcxt = 0x100000e14, fn_expr = 0xe1300000e11}, sk_argument = 11258999068426240}, {sk_flags = 539099242, sk_attno = 257, sk_strategy = 65312, sk_subtype = 8388607, sk_collation = 0, sk_func = {fn_addr = 0x5f69776300004ea5, fn_oid = 1953719668, fn_nargs = 24927, fn_strict = 95, fn_retset = 105, fn_stats = 100 'd', fn_extra = 0x0, fn_mcxt = 0x564000534ef8, fn_expr = 0x564000534f40}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 2200, sk_func = {fn_addr = 0x0, fn_oid = 10, fn_nargs = 403, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x4970000000000101}, 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 = 4177414479, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 160 '\240', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x5640005338b0}, sk_argument = 94832884102632}, {sk_flags = 5456792, sk_attno = 22080, sk_strategy = 0, sk_subtype = 7846064, sk_collation = 22080, 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 = 0x4ea4, 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 = 0x7070000000000101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x100030000, fn_mcxt = 0x3b600000000, fn_expr = 0x563ff87f4a25 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5640005338b0, fn_oid = 6195376, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 178 '\262', fn_extra = 0x200030000, fn_mcxt = 0x3b600000000, fn_expr = 0x563ff87f4272 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x5640005338b0, fn_oid = 6196584, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x563ff87f4a25 , 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 = 0x563ff87f4a25 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x5640005338b0, fn_expr = 0x5640005f2748}, sk_argument = 521}, {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 = 216 '\330', fn_extra = 0x564000779e20, fn_mcxt = 0x564000779e68, fn_expr = 0x4ea0}, sk_argument = 4629700416936869890}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 1768947712, sk_func = {fn_addr = 0x1, fn_oid = 7209216, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0xe0f00000e09, fn_mcxt = 0x28000000000002, fn_expr = 0xff20210120220064}, sk_argument = 8388607}, {sk_flags = 20126, sk_attno = 30563, sk_strategy = 24425, sk_subtype = 1819305330, sk_collation = 1684366177, sk_func = {fn_addr = 0x56400077aa10, fn_oid = 4168989019, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x563ff87e053b , fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 9448928051200}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 10, sk_collation = 403, sk_func = {fn_addr = 0x563ff8882aa5 , fn_oid = 7842608, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2, fn_mcxt = 0x100030000, fn_expr = 0x3b600000000}, sk_argument = 94832760342863}, {sk_flags = 257, sk_attno = 0, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x564000000003, fn_oid = 196608, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563ff8fe494f , fn_mcxt = 0x1000200000167, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 5454000, sk_attno = 22080, sk_strategy = 0, sk_subtype = 6282440, sk_collation = 22080, sk_func = {fn_addr = 0x563ff93a9d71, fn_oid = 196608, fn_nargs = 2, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563ff87f4a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 5454000, sk_attno = 22080, sk_strategy = 0, sk_subtype = 6409976, sk_collation = 22080, sk_func = {fn_addr = 0x17, fn_oid = 196608, fn_nargs = 3, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563ff87f4a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 5454000, sk_attno = 22080, sk_strategy = 0, sk_subtype = 6410056, sk_collation = 22080, sk_func = {fn_addr = 0x17, fn_oid = 7840552, fn_nargs = 22080, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x563ff948bf90, fn_mcxt = 0x7ffe2828f6c8, fn_expr = 0x563ff948bf88}, sk_argument = 94832762408714}, {sk_flags = 5701728, 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 = 0xb, fn_mcxt = 0x0, fn_expr = 0x5640005338b0}, sk_argument = 94832883538304}, {sk_flags = 20143, sk_attno = 0, sk_strategy = 0, sk_subtype = 356, sk_collation = 65538, sk_func = {fn_addr = 0x563ff91857c4 , fn_oid = 4182037032, fn_nargs = 22079, fn_strict = false, fn_retset = false, fn_stats = 91 '[', fn_extra = 0x56400077b378, fn_mcxt = 0x563ff87e053b , fn_expr = 0x200020000}, sk_argument = 4080218931200}, {sk_flags = -125877646, sk_attno = 22079, sk_strategy = 0, sk_subtype = 350, sk_collation = 65538, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x100030000, fn_mcxt = 0x5640007161b0, fn_expr = 0x563ff8ee5ebd }, 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 = 94832883349680}} [22:35:22.903] keysz = 2 [22:35:22.903] strat_total = 3 [22:35:22.903] blkno = 4294967295 [22:35:22.903] lastcurrblkno = 0 [22:35:22.903] __func__ = "_bt_first" [22:35:22.903] #8 0x0000563ff8812a8c in btgettuple (scan=0x5640007155b8, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [22:35:22.903] so = 0x5640007485f8 [22:35:22.903] res = [22:35:22.903] #9 0x0000563ff87f2118 in index_getnext_tid (scan=scan@entry=0x5640007155b8, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [22:35:22.903] found = [22:35:22.903] __func__ = "index_getnext_tid" [22:35:22.903] #10 0x0000563ff8afb5f2 in IndexOnlyNext (node=node@entry=0x5640007810c8) at ../src/backend/executor/nodeIndexonlyscan.c:121 [22:35:22.903] estate = 0x564000780af0 [22:35:22.903] econtext = 0x5640007812d8 [22:35:22.903] direction = BackwardScanDirection [22:35:22.903] scandesc = 0x5640007155b8 [22:35:22.903] slot = 0x5640007814f8 [22:35:22.903] tid = [22:35:22.903] __func__ = "IndexOnlyNext" [22:35:22.903] #11 0x0000563ff8ab3f8e in ExecScanFetch (recheckMtd=0x563ff8afad3f , accessMtd=0x563ff8afb523 , epqstate=0x0, node=0x5640007810c8) at ../src/include/executor/execScan.h:126 [22:35:22.903] No locals. [22:35:22.903] #12 ExecScanExtended (projInfo=0x564000781888, qual=0x0, epqstate=0x0, recheckMtd=0x563ff8afad3f , accessMtd=0x563ff8afb523 , node=0x5640007810c8) at ../src/include/executor/execScan.h:187 [22:35:22.903] slot = [22:35:22.903] econtext = 0x5640007812d8 [22:35:22.903] econtext = [22:35:22.903] slot = [22:35:22.903] #13 ExecScan (node=node@entry=0x5640007810c8, accessMtd=accessMtd@entry=0x563ff8afb523 , recheckMtd=recheckMtd@entry=0x563ff8afad3f ) at ../src/backend/executor/execScan.c:59 [22:35:22.903] epqstate = 0x0 [22:35:22.903] qual = 0x0 [22:35:22.903] projInfo = 0x564000781888 [22:35:22.903] #14 0x0000563ff8afb188 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [22:35:22.903] node = 0x5640007810c8 [22:35:22.903] #15 0x0000563ff8aac7e3 in ExecProcNodeFirst (node=0x5640007810c8) at ../src/backend/executor/execProcnode.c:469 [22:35:22.903] No locals. [22:35:22.903] #16 0x0000563ff8b03ee7 in ExecProcNode (node=node@entry=0x5640007810c8) at ../src/include/executor/executor.h:341 [22:35:22.903] No locals. [22:35:22.903] #17 0x0000563ff8b047e1 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [22:35:22.903] node = 0x564000780d58 [22:35:22.903] econtext = 0x564000780f68 [22:35:22.903] direction = [22:35:22.903] slot = [22:35:22.903] outerPlan = 0x5640007810c8 [22:35:22.903] __func__ = "ExecLimit" [22:35:22.903] #18 0x0000563ff8aac7e3 in ExecProcNodeFirst (node=0x564000780d58) at ../src/backend/executor/execProcnode.c:469 [22:35:22.903] No locals. [22:35:22.903] #19 0x0000563ff8a962c8 in ExecProcNode (node=node@entry=0x564000780d58) at ../src/include/executor/executor.h:341 [22:35:22.903] No locals. [22:35:22.903] #20 0x0000563ff8a96e18 in ExecutePlan (queryDesc=queryDesc@entry=0x56400077bb80, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5640007123f0) at ../src/backend/executor/execMain.c:1783 [22:35:22.903] estate = 0x564000780af0 [22:35:22.903] planstate = 0x564000780d58 [22:35:22.903] use_parallel_mode = false [22:35:22.903] slot = [22:35:22.903] current_tuple_count = 0 [22:35:22.903] #21 0x0000563ff8a984d3 in standard_ExecutorRun (queryDesc=0x56400077bb80, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:435 [22:35:22.903] estate = 0x564000780af0 [22:35:22.903] operation = CMD_SELECT [22:35:22.903] dest = 0x5640007123f0 [22:35:22.903] sendTuples = [22:35:22.903] oldcontext = 0x56400077ba80 [22:35:22.903] #22 0x0000563ff8a98533 in ExecutorRun (queryDesc=queryDesc@entry=0x56400077bb80, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:371 [22:35:22.903] No locals. [22:35:22.903] #23 0x0000563ff8eac636 in PortalRunSelect (portal=portal@entry=0x5640005b8f20, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5640007123f0) at ../src/backend/tcop/pquery.c:953 [22:35:22.903] queryDesc = 0x56400077bb80 [22:35:22.903] direction = [22:35:22.903] nprocessed = [22:35:22.903] __func__ = "PortalRunSelect" [22:35:22.903] #24 0x0000563ff8eafc8a in PortalRun (portal=portal@entry=0x5640005b8f20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5640007123f0, altdest=altdest@entry=0x5640007123f0, qc=qc@entry=0x7ffe28290380) at ../src/backend/tcop/pquery.c:797 [22:35:22.903] _save_exception_stack = 0x7ffe28290430 [22:35:22.903] _save_context_stack = 0x0 [22:35:22.903] _local_sigjmp_buf = {{__jmpbuf = {0, -6361712760966345684, 94832883896096, 94832883354840, 94832883354816, 94832883354768, -807561314489070548, -6392482793369498580}, __mask_was_saved = 0, __saved_mask = {__val = {94832762087338, 673776399, 4, 94832883354768, 112, 179, 94832883896096, 94832883354840, 94832883354816, 94832883354768, 94832762174909, 179, 2, 179, 94832751242211, 0}}}} [22:35:22.903] _do_rethrow = [22:35:22.903] result = [22:35:22.903] nprocessed = [22:35:22.903] saveTopTransactionResourceOwner = 0x564000576ce8 [22:35:22.903] saveTopTransactionContext = 0x5640005cdbd0 [22:35:22.903] saveActivePortal = 0x0 [22:35:22.903] saveResourceOwner = 0x564000576ce8 [22:35:22.903] savePortalContext = 0x0 [22:35:22.903] saveMemoryContext = 0x5640005cdbd0 [22:35:22.903] __func__ = "PortalRun" [22:35:22.903] #25 0x0000563ff8ea8833 in exec_simple_query (query_string=query_string@entry=0x5640005339b0 "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 [22:35:22.903] cmdtaglen = 6 [22:35:22.903] snapshot_set = [22:35:22.903] per_parsetree_context = 0x0 [22:35:22.903] plantree_list = 0x564000712de0 [22:35:22.903] parsetree = 0x564000534c90 [22:35:22.903] commandTag = [22:35:22.903] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:35:22.903] querytree_list = [22:35:22.903] portal = 0x5640005b8f20 [22:35:22.903] receiver = 0x5640007123f0 [22:35:22.903] format = 0 [22:35:22.903] cmdtagname = [22:35:22.903] parsetree_item__state = [22:35:22.903] dest = DestRemote [22:35:22.903] oldcontext = 0x5640005cdbd0 [22:35:22.903] parsetree_list = 0x564000534cc0 [22:35:22.903] parsetree_item = 0x564000534cd8 [22:35:22.903] save_log_statement_stats = false [22:35:22.903] was_logged = false [22:35:22.903] use_implicit_block = false [22:35:22.903] msec_str = "@ٰ\371?V\000\000%\003\027\371?V\000\000\020\004)(\376\177\000\000m\000\000\000\000\000\000" [22:35:22.903] __func__ = "exec_simple_query" [22:35:22.903] #26 0x0000563ff8eaba57 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4759 [22:35:22.903] query_string = 0x5640005339b0 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [22:35:22.903] firstchar = [22:35:22.903] input_message = {data = 0x5640005339b0 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [22:35:22.903] local_sigjmp_buf = {{__jmpbuf = {94832775101208, -6392485082557838292, 140729572197888, 94832772045120, 24, 17, -807561314421961684, -6392482795318932436}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94832883079392, 17408, 94832775095264, 94832883614864, 24, 94832762087254, 0, 10, 2, 94832775101216, 94832883079392, 94832775095264, 94832772045120, 24, 17}}}} [22:35:22.903] send_ready_for_query = false [22:35:22.903] idle_in_transaction_timeout_enabled = false [22:35:22.903] idle_session_timeout_enabled = false [22:35:22.903] __func__ = "PostgresMain" [22:35:22.903] #27 0x0000563ff8ea13ee in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [22:35:22.903] bsdata = [22:35:22.903] #28 0x0000563ff8d45bcd in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffe28290590, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffe28290600) at ../src/backend/postmaster/launch_backend.c:290 [22:35:22.903] pid = [22:35:22.903] #29 0x0000563ff8d4b18a in BackendStartup (client_sock=client_sock@entry=0x7ffe28290600) at ../src/backend/postmaster/postmaster.c:3580 [22:35:22.903] bn = 0x56400055c228 [22:35:22.903] pid = [22:35:22.903] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796516112131452, fork_started = 796516112131453} [22:35:22.903] cac = [22:35:22.903] __func__ = "BackendStartup" [22:35:22.903] #30 0x0000563ff8d4d675 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [22:35:22.903] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\350\367?V\000\000\260{\344\367?V\000\000@\a)(\376\177\000\0008\a)(\376\177\000\000\225[\362\001\000\000\000\000\250\244h\2331\177\000\000,", '\000' , "`\006)(\376\177\000\000\000\004\000\000\000\000\000\000x\a)(\376\177\000\000\000bGȲ4\223\000\200YO", '\000' , __ss_align = 67}, salen = 2}} [22:35:22.903] i = 0 [22:35:22.903] now = [22:35:22.903] last_lockfile_recheck_time = 1743200903 [22:35:22.903] last_touch_time = 1743200903 [22:35:22.903] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 149, user_data = 0x0}, {pos = 16, events = 0, fd = -1687640512, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f319c1b42e0}, {pos = 673777464, events = 32766, fd = 673777472, user_data = 0x7f319c1b4668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = 5454448, events = 22080, fd = 1, user_data = 0x564000533a70}, {pos = -1, events = 0, fd = -1702698976, user_data = 0x7f319bda34d0}, {pos = 5461664, events = 22080, fd = -1701909083, user_data = 0x7ffe28290c93}, {pos = 150, events = 0, fd = 673777536, user_data = 0x7f319c1b42e0}, {pos = 430, events = 0, fd = -110047888, user_data = 0x0}, {pos = 0, events = 0, fd = 249, user_data = 0x7f319c18febe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f319a82e020}, {pos = -1701892480, events = 32561, fd = 835520378, user_data = 0x7ffe28290bb0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1676074310, events = 32561, fd = 0, user_data = 0x7f319a8aedd4 }, {pos = 0, events = 0, fd = -102899264, user_data = 0x2}, {pos = 0, events = 0, fd = 5200256, user_data = 0x7f319a8eeedd }, {pos = 5462208, events = 22080, fd = -119303979, user_data = 0x5640005663d0}, {pos = 8096, events = 196607, fd = 5661739, user_data = 0x563ff8e3dca3 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x164}, {pos = -110048480, events = 22079, fd = 8, user_data = 0x1}, {pos = 5454448, events = 22080, fd = -1676083522, user_data = 0x1}, {pos = -1702137699, events = 32561, fd = -1702665016, user_data = 0x5640005663d0}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x362020200a0a4e55}, {pos = 822763892, events = 842216503, fd = 809054256, 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 = 5665744, user_data = 0x563ff918d7d9 }, {pos = 5637552, events = 22080, fd = 1080, user_data = 0x5640005615d0}, {pos = -115810215, events = 22079, fd = 1024, user_data = 0x7f319a8b58ee}, {pos = -1700865568, events = 32561, fd = -1702227602, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 673778824, events = 32766, fd = -1702133937, user_data = 0x5640005615d0}, {pos = 3, events = 0, fd = 0, user_data = 0x640f}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -1701891949, events = 32561, fd = 5641680, user_data = 0x1}, {pos = 5641880, events = 22080, fd = 1024, user_data = 0x7ffe28290c88}, {pos = -115729075, events = 22079, fd = -102794544, user_data = 0x563ff919080a }, {pos = 5641680, events = 22080, fd = 5454000, user_data = 0x5640005615d0}, {pos = -1702143762, events = 32561, fd = 0, user_data = 0x563ff91a2474 }, {pos = 5641680, events = 1, fd = -115726915, user_data = 0x5640005338b0}, {pos = -1702221135, events = 32561, fd = -1702226704, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -934845952, events = 9647282, fd = 5200256, user_data = 0x9334b2c8476200}, {pos = 13, events = 0, fd = -934845952, user_data = 0x0}, {pos = -1702514119, events = 32561, fd = 0, user_data = 0x563ff8d458b3 }, {pos = 4194304, events = 0, fd = 5287904, user_data = 0x1}, {pos = 0, events = 0, fd = 5200256, user_data = 0x563ff919069e }, {pos = 5287904, events = 22080, fd = 5454000, user_data = 0x56400050afe0}, {pos = 1, events = 0, fd = 0, user_data = 0x563ff914eb1d }, {pos = 13, events = 0, fd = 5633016, user_data = 0x56400055f3d8}, {pos = -102897832, events = 22079, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -120300947, user_data = 0x5640005338b0}, {pos = -120284046, events = 22079, fd = -106578928, user_data = 0x564000534288}} [22:35:22.903] nevents = 1 [22:35:22.903] __func__ = "ServerLoop" [22:35:22.903] #31 0x0000563ff8d4eed9 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5640004f1840) at ../src/backend/postmaster/postmaster.c:1399 [22:35:22.903] opt = [22:35:22.903] status = [22:35:22.903] userDoption = [22:35:22.903] listen_addr_saved = false [22:35:22.903] output_config_variable = [22:35:22.903] __func__ = "PostmasterMain" [22:35:22.903] #32 0x0000563ff8b7deca in main (argc=8, argv=0x5640004f1840) at ../src/backend/main/main.c:227 [22:35:22.903] do_check_root = [22:35:22.903] dispatch_option = [22:35:22.922] -e [22:35:22.922] [22:35:22.922] [22:35:22.982] dumping /tmp/cores/postgres-6-27394.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:35:23.214] [New LWP 27394] [22:35:23.214] [22:35:23.214] This GDB supports auto-downloading debuginfo from the following URLs: [22:35:23.214] [22:35:23.214] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:35:23.214] Debuginfod has been disabled. [22:35:23.214] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:35:23.308] [Thread debugging using libthread_db enabled] [22:35:23.308] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:35:23.308] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [22:35:23.308] Program terminated with signal SIGABRT, Aborted. [22:35:23.308] #0 0x00007fd0344a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:23.410] [22:35:23.410] Thread 1 (Thread 0x7fd035287040 (LWP 27394)): [22:35:23.410] #0 0x00007fd0344a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:23.410] No symbol table info available. [22:35:23.410] #1 0x00007fd03445afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:23.410] No symbol table info available. [22:35:23.410] #2 0x00007fd034445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:35:23.410] No symbol table info available. [22:35:23.410] #3 0x0000563c61b4a197 in ExceptionalCondition (conditionName=conditionName@entry=0x563c61d89ce0 "!so->needPrimScan && !so->scanBehind && !so->oppositeDirCheck", fileName=fileName@entry=0x563c61d89808 "../src/backend/access/nbtree/nbtutils.c", lineNumber=lineNumber@entry=2276) at ../src/backend/utils/error/assert.c:66 [22:35:23.410] No locals. [22:35:23.410] #4 0x0000563c6122ad59 in _bt_checkkeys (scan=scan@entry=0x563c798631d8, pstate=pstate@entry=0x7ffc03d1a260, arrayKeys=arrayKeys@entry=true, tuple=tuple@entry=0x7fd02d63cfe0, tupnatts=tupnatts@entry=2) at ../src/backend/access/nbtree/nbtutils.c:2276 [22:35:23.410] tupdesc = 0x7fd02841b658 [22:35:23.410] so = [22:35:23.410] dir = BackwardScanDirection [22:35:23.410] ikey = 0 [22:35:23.410] res = [22:35:23.410] #5 0x0000563c61217fea in _bt_readpage (scan=scan@entry=0x563c798631d8, dir=dir@entry=BackwardScanDirection, offnum=1, firstpage=firstpage@entry=true) at ../src/backend/access/nbtree/nbtsearch.c:1885 [22:35:23.410] iid = 0x7fd02d63b018 [22:35:23.410] itup = 0x7fd02d63cfe0 [22:35:23.410] tuple_alive = true [22:35:23.410] passes_quals = [22:35:23.410] rel = [22:35:23.410] so = 0x563c79870b18 [22:35:23.410] page = [22:35:23.410] opaque = [22:35:23.410] minoff = 1 [22:35:23.410] maxoff = [22:35:23.410] pstate = {minoff = 1, maxoff = 274, finaltup = 0x7fd02d63cfe0, page = 0x7fd02d63b000 "", firstpage = true, forcenonrequired = false, startikey = 0, offnum = 1, skip = 0, continuescan = true, rechecks = 0, targetdistance = 0, nskipadvances = 198} [22:35:23.410] arrayKeys = true [22:35:23.410] itemIndex = 1357 [22:35:23.410] indnatts = 2 [22:35:23.410] #6 0x0000563c61218eb6 in _bt_readfirstpage (scan=scan@entry=0x563c798631d8, offnum=, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:2217 [22:35:23.410] so = 0x563c79870b18 [22:35:23.410] #7 0x0000563c6121c6dd in _bt_first (scan=scan@entry=0x563c798631d8, dir=dir@entry=BackwardScanDirection) at ../src/backend/access/nbtree/nbtsearch.c:1519 [22:35:23.410] rel = 0x7fd02841a9d8 [22:35:23.410] so = 0x563c79870b18 [22:35:23.410] stack = [22:35:23.410] offnum = [22:35:23.410] 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 = 0x563c611f43fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x563c797d9e30, fn_expr = 0x563c7986ed08}, sk_argument = 0}, {sk_flags = 196608, sk_attno = 2, sk_strategy = 0, sk_subtype = 23, sk_collation = 0, sk_func = {fn_addr = 0x563c611f43fe , fn_oid = 351, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x563c797d9e30, fn_expr = 0x563c7986ed58}, sk_argument = 500}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 64073280, sk_collation = 32764, sk_func = {fn_addr = 0x563c7984f528, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c79841928, fn_mcxt = 0x563c615b8902 , fn_expr = 0x563c79841928}, sk_argument = 0}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1639174664, sk_collation = 22076, sk_func = {fn_addr = 0x563c79842008, fn_oid = 1638517424, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94817736783144}, {sk_flags = 64073648, 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 = 91 '[', fn_extra = 0x563c79841928, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x4034000000000000}, sk_argument = 4572414629676717179}, {sk_flags = 64073600, sk_attno = 32764, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x563c7984f028, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x4069000000000000, fn_mcxt = 0x563c79840f08, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 1638523483, sk_attno = 22076, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x3ff0000000000000, fn_oid = 675388216, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x3ff0000000000000, fn_expr = 0x563c7984f118}, sk_argument = 94817736726824}, {sk_flags = 0, sk_attno = 0, sk_strategy = 257, sk_subtype = 1639327868, sk_collation = 22076, sk_func = {fn_addr = 0x7ffc03d1afec, fn_oid = 878121504, fn_nargs = 32720, fn_strict = false, fn_retset = false, fn_stats = 192 '\300', fn_extra = 0x0, fn_mcxt = 0x7ffc03d1b0b0, fn_expr = 0x563c79776a10}, sk_argument = 3}, {sk_flags = 2037865792, sk_attno = 22076, sk_strategy = 0, sk_subtype = 64073708, 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 = 0x563c61b62dff , fn_expr = 0x3fd199999999999a}, sk_argument = 140720372560040}, {sk_flags = 64073888, sk_attno = 32764, sk_strategy = 0, sk_subtype = 2038697736, sk_collation = 22076, sk_func = {fn_addr = 0x563c79841928, fn_oid = 1639174664, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x67f00000000, fn_mcxt = 0x563c7984f118, fn_expr = 0x563c79840df8}, sk_argument = 140720372560040}, {sk_flags = 64073888, sk_attno = 32764, sk_strategy = 0, sk_subtype = 2038697736, sk_collation = 22076, sk_func = {fn_addr = 0x563c61b3d36f , fn_oid = 342, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 248 '\370', fn_extra = 0x563c79841348, fn_mcxt = 0x563c615bb727 , fn_expr = 0x563c79842520}, 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 = 2038697464, sk_attno = 22076, sk_strategy = 0, sk_subtype = 0, sk_collation = 1074790400, sk_func = {fn_addr = 0x563c61b8d7d9 , fn_oid = 2036802816, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 124 '|', fn_extra = 0x7ffc03d1b16c, fn_mcxt = 0x7fd034571220, fn_expr = 0x79841928}, sk_argument = 0}, {sk_flags = 2038697736, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2037869072, sk_collation = 22076, sk_func = {fn_addr = 0x0, fn_oid = 2037865792, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 108 'l', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 4620693217682128896}, {sk_flags = 1639329279, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038698824, sk_collation = 22076, sk_func = {fn_addr = 0x7ffc03d1b1f0, fn_oid = 64074216, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c79841928, fn_mcxt = 0x563c61b3d208 , 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 = 0x7ffc03d1b1f0, fn_oid = 64074216, fn_nargs = 32764, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c61b3d36f , fn_mcxt = 0x563c79841928, fn_expr = 0x563c79842c00}, sk_argument = 94817736725320}, {sk_flags = 1633428455, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038756968, sk_collation = 22076, 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 = 2038698824, sk_attno = 22076, sk_strategy = 0, sk_subtype = 1633427588, sk_collation = 22076, sk_func = {fn_addr = 0x563c79841348, 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 = 0x563c79841348, fn_oid = 2038700328, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 216 '\330', fn_extra = 0x1, fn_mcxt = 0x563c79841928, fn_expr = 0x563c79841348}, sk_argument = 94817331374782}, {sk_flags = 2036810712, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038703552, sk_collation = 22076, sk_func = {fn_addr = 0x1, fn_oid = 1633524533, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 176 '\260', fn_extra = 0x563c79841928, fn_mcxt = 0x563c79841928, fn_expr = 0x7ffc03d1b3a8}, sk_argument = 94817736728344}, {sk_flags = 1634124293, sk_attno = 22076, 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 = 0x563c61b8d7d9 , fn_mcxt = 0x563c797d9e30, fn_expr = 0x400}, sk_argument = 7}, {sk_flags = 1639508250, sk_attno = 22076, 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 = 232 '\350', fn_extra = 0x7ffc03d1b480, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 94817736307440}, {sk_flags = 2038280936, sk_attno = 22076, sk_strategy = 0, sk_subtype = 1639595044, sk_collation = 22076, sk_func = {fn_addr = 0x0, fn_oid = 1632002578, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c797db1e8, fn_mcxt = 0x563c797db2c8, fn_expr = 0x563c614674ae }, sk_argument = 0}, {sk_flags = 2038762512, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038280936, sk_collation = 22076, sk_func = {fn_addr = 0x563c797db2f0, 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 = 0x563c61b8d7d9 , fn_mcxt = 0x563c797d9e30, fn_expr = 0x40}, sk_argument = 9}, {sk_flags = 1638972181, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038280944, sk_collation = 22076, sk_func = {fn_addr = 0x563c61b0b53c , fn_oid = 678197992, fn_nargs = 32720, fn_strict = false, fn_retset = false, fn_stats = 232 '\350', fn_extra = 0x7fd0286c7ac0, fn_mcxt = 0x563c796d6a90, fn_expr = 0x563c796d6380}, sk_argument = 94817337013826}, {sk_flags = 2038280904, sk_attno = 22076, 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 = 0x3203d1b61f, fn_mcxt = 0x60, fn_expr = 0x73}, sk_argument = 140532008123136}, {sk_flags = 877358903, sk_attno = 32720, sk_strategy = 0, sk_subtype = 2038275632, sk_collation = 22076, sk_func = {fn_addr = 0x77c0, fn_oid = 1712, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 116 't', fn_extra = 0x0, fn_mcxt = 0x7fd0344b6f37, 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 = 0x563c7970c370, fn_oid = 878648416, fn_nargs = 32720, fn_strict = false, fn_retset = false, fn_stats = 3 '\003', fn_extra = 0xfffffffffffffef0, fn_mcxt = 0x4008, fn_expr = 0x0}, sk_argument = 94817736302384}, {sk_flags = 877361850, sk_attno = 32720, sk_strategy = 0, sk_subtype = 2038275632, sk_collation = 22076, sk_func = {fn_addr = 0x563c61b8d7d9 , fn_oid = 2038275632, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x4040, fn_mcxt = 0x563c61b8d9c4 , fn_expr = 0x563c797d9e30}, sk_argument = 16384}, {sk_flags = 2038282104, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038836624, sk_collation = 22076, sk_func = {fn_addr = 0x563c797db858, fn_oid = 1639507798, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x563c61b8e91a , fn_mcxt = 0x7970c370, fn_expr = 0x563c79870b18}, sk_argument = 94817736864216}}} [22:35:23.410] startKeys = {0x563c79863428, 0x563c79863470, 0x563c79672500, 0x8, 0x0, 0x563c61b8e91a , 0x28c4b401, 0x0, 0x7fd0288af938, 0x563c79672f8e, 0x563c79672e20, 0x563c79672f87, 0x563c79672e20, 0x7ffc03d1b918, 0x0, 0x563c61b8d7d9 , 0x563c79672500, 0x40, 0x3, 0x563c61b857c4 , 0x563c61e4d228, 0x563c79672f9a, 0x563c79672e20, 0x563c61cecfbd , 0x563c79672f9d, 0x563c79672e20, 0x563c79672f9c, 0x0, 0x7ffc03d1b918, 0x563c61cf3736 , 0x2, 0x3} [22:35:23.410] notnullkeys = {{sk_flags = 2, sk_attno = 22076, sk_strategy = 0, sk_subtype = 196608, sk_collation = 1, sk_func = {fn_addr = 0x3b600000000, fn_oid = 1629440549, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 100 'd', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x563c79842dd0}, sk_argument = 94817735568672}, {sk_flags = 20156, sk_attno = 0, sk_strategy = 0, sk_subtype = 131072, sk_collation = 2, sk_func = {fn_addr = 0x3b600000000, fn_oid = 1629438578, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 94 '^', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x563c79842dd0}, sk_argument = 94817735569880}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1629440549, sk_collation = 22076, sk_func = {fn_addr = 0x1000200000164, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c79842dd0, fn_mcxt = 0x560000000101, 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 = 0x563c611f4a25 , fn_oid = 2038704904, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 80 'P', fn_extra = 0x563c79842b98, fn_mcxt = 0x563c79842dd0, fn_expr = 0x563c7972a478}, sk_argument = 20159}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c79842dd0, fn_oid = 2037672600, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x300030000, fn_mcxt = 0x3b600000000, fn_expr = 0x563c611f4156 }, sk_argument = 281483566646941}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c79842dd0, fn_oid = 2037672680, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x563c618e5fb9 , fn_expr = 0x560000000101}, sk_argument = 2}, {sk_flags = 3, sk_attno = 0, sk_strategy = 0, sk_subtype = 1636720317, sk_collation = 22076, sk_func = {fn_addr = 0x1, fn_oid = 2, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 56 '8', fn_extra = 0x563c7986ec80, fn_mcxt = 0x0, fn_expr = 0x2}, 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 = 94817734829312}, {sk_flags = 2037582776, sk_attno = 22076, 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 = 94817734829312}, {sk_flags = 2037582936, sk_attno = 22076, 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 = 94817734829312}, {sk_flags = 2037583016, sk_attno = 22076, sk_strategy = 0, sk_subtype = 1976, sk_collation = 0, sk_func = {fn_addr = 0x563c79673fc8, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 208 '\320', fn_extra = 0x563c797486f8, fn_mcxt = 0x898, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 2038705616, sk_attno = 22076, sk_strategy = 0, sk_subtype = 257, sk_collation = 22016, sk_func = {fn_addr = 0x0, fn_oid = 1, fn_nargs = 2, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x3b600000000, fn_mcxt = 0x563c611f4a25 , fn_expr = 0x1000200000164}, sk_argument = 2}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 2038705616, sk_collation = 22076, sk_func = {fn_addr = 0x563c7972a478, fn_oid = 20159, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c611f4a25 , fn_mcxt = 0x563c79673b48, fn_expr = 0x563c79673b90}, sk_argument = 0}, {sk_flags = 2038705616, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2037556344, sk_collation = 22076, sk_func = {fn_addr = 0x4ebf, fn_oid = 9229, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x7fd028c88c80, fn_mcxt = 0x7fd028c88c80, fn_expr = 0x7f0000000101}, 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 = 1637763407, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 240 '\360', fn_extra = 0x2, fn_mcxt = 0x0, fn_expr = 0x563c79672500}, sk_argument = 94817735580248}, {sk_flags = 2036805608, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2038705152, sk_collation = 22076, sk_func = {fn_addr = 0x4ebc, fn_oid = 257, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x1, fn_mcxt = 0x100030000, fn_expr = 0x3b600000000}, sk_argument = 94817334036793}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 1636022596, sk_collation = 22076, 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 = 0x563c611f4a25 }, sk_argument = 281483566645604}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c79672500, fn_oid = 2037542176, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 191 '\277', fn_extra = 0x200030000, fn_mcxt = 0x3b600000000, fn_expr = 0x563c611f4272 }, sk_argument = 281483566645598}, {sk_flags = 2, sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c79672500, fn_oid = 2037543384, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x563c611f4a25 , 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 = 0x563c611f4a25 , fn_oid = 356, fn_nargs = 2, fn_strict = true, fn_retset = false, fn_stats = 2 '\002', fn_extra = 0x0, fn_mcxt = 0x563c79672500, fn_expr = 0x563c79730bb8}, sk_argument = 521}, {sk_flags = -5, sk_attno = 0, sk_strategy = 0, sk_subtype = 5, sk_collation = 0, sk_func = {fn_addr = 0x7ffc03d1ac30, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 40 '(', fn_extra = 0x563c79841170, fn_mcxt = 0x563c798411b8, fn_expr = 0x6182d5fd}, sk_argument = 3398246808}, {sk_flags = 64072848, sk_attno = 32764, sk_strategy = 0, sk_subtype = 1, sk_collation = 0, sk_func = {fn_addr = 0x563c61bdc3f2 , fn_oid = 4294967295, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 165 '\245', fn_extra = 0x7ffc03d1ac90, fn_mcxt = 0xdfb, fn_expr = 0xe01}, sk_argument = 94817334104019}, {sk_flags = 64072328, sk_attno = 32764, sk_strategy = 0, sk_subtype = 1652429168, sk_collation = 22076, sk_func = {fn_addr = 0x563c79841d60, fn_oid = 1636388182, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c611e0636 , fn_mcxt = 0x7ffc03d1ac78, fn_expr = 0x563c61e8bf96}, sk_argument = 140720372558896}, {sk_flags = 1639831334, sk_attno = 22076, sk_strategy = 0, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c61282aa5 , fn_oid = 2038701696, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x2, fn_mcxt = 0x100030000, fn_expr = 0x3b600000000}, sk_argument = 94817335789903}, {sk_flags = 257, sk_attno = 0, sk_strategy = 1, sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0x563c00000003, fn_oid = 196608, fn_nargs = 1, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c619e494f , fn_mcxt = 0x1000200000167, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 2036802816, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2037629240, sk_collation = 22076, sk_func = {fn_addr = 0x563c61da9d71, fn_oid = 196608, fn_nargs = 2, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c611f4a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 2036802816, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2037843736, sk_collation = 22076, sk_func = {fn_addr = 0x17, fn_oid = 196608, fn_nargs = 3, fn_strict = false, fn_retset = false, fn_stats = 0 '\000', fn_extra = 0x563c611f4a25 , fn_mcxt = 0x1000200000164, fn_expr = 0x2}, sk_argument = 0}, {sk_flags = 2036802816, sk_attno = 22076, sk_strategy = 0, sk_subtype = 2037843816, sk_collation = 22076, sk_func = {fn_addr = 0x17, fn_oid = 2038699640, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 11 '\v', fn_extra = 0x563c61e8bf90, fn_mcxt = 0x7ffc03d1adb8, fn_expr = 0x563c61e8bf88}, sk_argument = 94817337855754}, {sk_flags = 2037728128, 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 = 0xb, fn_mcxt = 0x0, fn_expr = 0x563c79672500}, sk_argument = 94817735016848}, {sk_flags = 20156, sk_attno = 0, sk_strategy = 0, sk_subtype = 356, sk_collation = 65538, sk_func = {fn_addr = 0x563c61b857c4 , fn_oid = 1642385960, fn_nargs = 22076, fn_strict = false, fn_retset = false, fn_stats = 91 '[', fn_extra = 0x563c798426c8, fn_mcxt = 0x563c611e053b , fn_expr = 0x200020000}, sk_argument = 4080218931200}, {sk_flags = 1629438578, sk_attno = 22076, sk_strategy = 0, sk_subtype = 350, sk_collation = 65538, sk_func = {fn_addr = 0x101, fn_oid = 0, fn_nargs = 0, fn_strict = false, fn_retset = false, fn_stats = 1 '\001', fn_extra = 0x100030000, fn_mcxt = 0x563c79863dd0, fn_expr = 0x563c618e5ebd }, 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 = 94817734829312}} [22:35:23.410] keysz = 2 [22:35:23.410] strat_total = 3 [22:35:23.410] blkno = 4294967295 [22:35:23.410] lastcurrblkno = 0 [22:35:23.410] __func__ = "_bt_first" [22:35:23.410] #8 0x0000563c61212a8c in btgettuple (scan=0x563c798631d8, dir=BackwardScanDirection) at ../src/backend/access/nbtree/nbtree.c:243 [22:35:23.410] so = 0x563c79870b18 [22:35:23.410] res = [22:35:23.410] #9 0x0000563c611f2118 in index_getnext_tid (scan=scan@entry=0x563c798631d8, direction=direction@entry=BackwardScanDirection) at ../src/backend/access/index/indexam.c:637 [22:35:23.410] found = [22:35:23.410] __func__ = "index_getnext_tid" [22:35:23.410] #10 0x0000563c614fb5f2 in IndexOnlyNext (node=node@entry=0x563c797da508) at ../src/backend/executor/nodeIndexonlyscan.c:121 [22:35:23.410] estate = 0x563c797d9f30 [22:35:23.410] econtext = 0x563c797da718 [22:35:23.410] direction = BackwardScanDirection [22:35:23.410] scandesc = 0x563c798631d8 [22:35:23.410] slot = 0x563c797da938 [22:35:23.410] tid = [22:35:23.410] __func__ = "IndexOnlyNext" [22:35:23.410] #11 0x0000563c614b3f8e in ExecScanFetch (recheckMtd=0x563c614fad3f , accessMtd=0x563c614fb523 , epqstate=0x0, node=0x563c797da508) at ../src/include/executor/execScan.h:126 [22:35:23.410] No locals. [22:35:23.410] #12 ExecScanExtended (projInfo=0x563c797dacc8, qual=0x0, epqstate=0x0, recheckMtd=0x563c614fad3f , accessMtd=0x563c614fb523 , node=0x563c797da508) at ../src/include/executor/execScan.h:187 [22:35:23.410] slot = [22:35:23.410] econtext = 0x563c797da718 [22:35:23.410] econtext = [22:35:23.410] slot = [22:35:23.410] #13 ExecScan (node=node@entry=0x563c797da508, accessMtd=accessMtd@entry=0x563c614fb523 , recheckMtd=recheckMtd@entry=0x563c614fad3f ) at ../src/backend/executor/execScan.c:59 [22:35:23.410] epqstate = 0x0 [22:35:23.410] qual = 0x0 [22:35:23.410] projInfo = 0x563c797dacc8 [22:35:23.410] #14 0x0000563c614fb188 in ExecIndexOnlyScan (pstate=) at ../src/backend/executor/nodeIndexonlyscan.c:347 [22:35:23.410] node = 0x563c797da508 [22:35:23.410] #15 0x0000563c614ac7e3 in ExecProcNodeFirst (node=0x563c797da508) at ../src/backend/executor/execProcnode.c:469 [22:35:23.410] No locals. [22:35:23.410] #16 0x0000563c61503ee7 in ExecProcNode (node=node@entry=0x563c797da508) at ../src/include/executor/executor.h:341 [22:35:23.410] No locals. [22:35:23.410] #17 0x0000563c615047e1 in ExecLimit (pstate=) at ../src/backend/executor/nodeLimit.c:95 [22:35:23.410] node = 0x563c797da198 [22:35:23.410] econtext = 0x563c797da3a8 [22:35:23.410] direction = [22:35:23.410] slot = [22:35:23.410] outerPlan = 0x563c797da508 [22:35:23.410] __func__ = "ExecLimit" [22:35:23.410] #18 0x0000563c614ac7e3 in ExecProcNodeFirst (node=0x563c797da198) at ../src/backend/executor/execProcnode.c:469 [22:35:23.410] No locals. [22:35:23.410] #19 0x0000563c614962c8 in ExecProcNode (node=node@entry=0x563c797da198) at ../src/include/executor/executor.h:341 [22:35:23.410] No locals. [22:35:23.410] #20 0x0000563c61496e18 in ExecutePlan (queryDesc=queryDesc@entry=0x563c79842ed0, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x563c7984fff0) at ../src/backend/executor/execMain.c:1783 [22:35:23.410] estate = 0x563c797d9f30 [22:35:23.410] planstate = 0x563c797da198 [22:35:23.410] use_parallel_mode = false [22:35:23.410] slot = [22:35:23.410] current_tuple_count = 0 [22:35:23.410] #21 0x0000563c614984d3 in standard_ExecutorRun (queryDesc=0x563c79842ed0, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:435 [22:35:23.410] estate = 0x563c797d9f30 [22:35:23.410] operation = CMD_SELECT [22:35:23.410] dest = 0x563c7984fff0 [22:35:23.410] sendTuples = [22:35:23.410] oldcontext = 0x563c79842dd0 [22:35:23.410] #22 0x0000563c61498533 in ExecutorRun (queryDesc=queryDesc@entry=0x563c79842ed0, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:371 [22:35:23.410] No locals. [22:35:23.410] #23 0x0000563c618ac636 in PortalRunSelect (portal=portal@entry=0x563c796f7590, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x563c7984fff0) at ../src/backend/tcop/pquery.c:953 [22:35:23.410] queryDesc = 0x563c79842ed0 [22:35:23.410] direction = [22:35:23.410] nprocessed = [22:35:23.410] __func__ = "PortalRunSelect" [22:35:23.410] #24 0x0000563c618afc8a in PortalRun (portal=portal@entry=0x563c796f7590, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x563c7984fff0, altdest=altdest@entry=0x563c7984fff0, qc=qc@entry=0x7ffc03d1ba70) at ../src/backend/tcop/pquery.c:797 [22:35:23.410] _save_exception_stack = 0x7ffc03d1bb20 [22:35:23.410] _save_context_stack = 0x0 [22:35:23.410] _local_sigjmp_buf = {{__jmpbuf = {0, 8172884446730967937, 94817735374224, 94817734834472, 94817734834448, 94817734834400, 2516139660604267393, 8172866768521714561}, __mask_was_saved = 0, __saved_mask = {__val = {94817337534378, 64076287, 4, 94817734834400, 112, 179, 94817735374224, 94817734834472, 94817734834448, 94817734834400, 94817337621949, 179, 2, 179, 94817326689251, 0}}}} [22:35:23.410] _do_rethrow = [22:35:23.410] result = [22:35:23.410] nprocessed = [22:35:23.410] saveTopTransactionResourceOwner = 0x563c796b4048 [22:35:23.410] saveTopTransactionContext = 0x563c7970c240 [22:35:23.410] saveActivePortal = 0x0 [22:35:23.410] saveResourceOwner = 0x563c796b4048 [22:35:23.410] savePortalContext = 0x0 [22:35:23.410] saveMemoryContext = 0x563c7970c240 [22:35:23.410] __func__ = "PortalRun" [22:35:23.410] #25 0x0000563c618a8833 in exec_simple_query (query_string=query_string@entry=0x563c79672600 "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 [22:35:23.410] cmdtaglen = 6 [22:35:23.410] snapshot_set = [22:35:23.410] per_parsetree_context = 0x0 [22:35:23.410] plantree_list = 0x563c798509e0 [22:35:23.410] parsetree = 0x563c796738e0 [22:35:23.410] commandTag = [22:35:23.410] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:35:23.410] querytree_list = [22:35:23.410] portal = 0x563c796f7590 [22:35:23.410] receiver = 0x563c7984fff0 [22:35:23.410] format = 0 [22:35:23.410] cmdtagname = [22:35:23.410] parsetree_item__state = [22:35:23.410] dest = DestRemote [22:35:23.410] oldcontext = 0x563c7970c240 [22:35:23.410] parsetree_list = 0x563c79673910 [22:35:23.410] parsetree_item = 0x563c79673928 [22:35:23.410] save_log_statement_stats = false [22:35:23.410] was_logged = true [22:35:23.410] use_implicit_block = false [22:35:23.410] msec_str = "@\331Pb, username=) at ../src/backend/tcop/postgres.c:4759 [22:35:23.410] query_string = 0x563c79672600 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;" [22:35:23.410] firstchar = [22:35:23.410] input_message = {data = 0x563c79672600 "SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;", len = 109, maxlen = 1024, cursor = 109} [22:35:23.410] local_sigjmp_buf = {{__jmpbuf = {94817350548248, 8172868860133170049, 140720372563184, 94817347492160, 24, 11, 2516139660671376257, 8172866770328542081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94817734560032, 16128, 94817350542304, 94817735094272, 24, 94817337534294, 0, 9, 2, 94817350548256, 94817734560032, 94817350542304, 94817347492160, 24, 11}}}} [22:35:23.410] send_ready_for_query = false [22:35:23.410] idle_in_transaction_timeout_enabled = false [22:35:23.410] idle_session_timeout_enabled = false [22:35:23.410] __func__ = "PostgresMain" [22:35:23.410] #27 0x0000563c618a13ee in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:122 [22:35:23.410] bsdata = [22:35:23.410] #28 0x0000563c61745bcd in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x7ffc03d1bc80, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffc03d1bcf0) at ../src/backend/postmaster/launch_backend.c:290 [22:35:23.410] pid = [22:35:23.410] #29 0x0000563c6174b18a in BackendStartup (client_sock=client_sock@entry=0x7ffc03d1bcf0) at ../src/backend/postmaster/postmaster.c:3580 [22:35:23.410] bn = 0x563c7969acd8 [22:35:23.410] pid = [22:35:23.410] startup_data = {canAcceptConnections = CAC_OK, socket_created = 796516113345962, fork_started = 796516113345963} [22:35:23.410] cac = [22:35:23.410] __func__ = "BackendStartup" [22:35:23.410] #30 0x0000563c6174d675 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1701 [22:35:23.410] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\t\260\210`, "\374\177\000\000\000\004\000\000\000\000\000\000h6\3445\320\177\000\000@֒5\320\177\000\000\3402\3445\320\177\000\000\316)fR\000\000\000", __ss_align = 64077440}, salen = 2}} [22:35:23.410] i = 0 [22:35:23.410] now = [22:35:23.410] last_lockfile_recheck_time = 1743200904 [22:35:23.410] last_touch_time = 1743200904 [22:35:23.410] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 904147680, user_data = 0x0}, {pos = 64077504, events = 32764, fd = 903973448, user_data = 0x10}, {pos = 898815552, events = 32720, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 904147680, user_data = 0x7ffc03d1be38}, {pos = 64077376, events = 32764, fd = 904148584, user_data = 0x0}, {pos = 2036803096, events = 22076, fd = 877361850, user_data = 0x563c79672618}, {pos = 1, events = 22076, fd = 32768, user_data = 0xffffffff}, {pos = 876797984, events = 32720, fd = 899192016, user_data = 0x563c796a0108}, {pos = 2036989928, events = 22076, fd = 2036989377, user_data = 0x7fd035e1eebe}, {pos = 1, events = 0, fd = 904147680, user_data = 0x1ae}, {pos = 1645268336, events = 22076, fd = 0, user_data = 0x0}, {pos = 229, events = 0, fd = 903999166, user_data = 0x1}, {pos = 0, events = 0, fd = 876797984, user_data = 0x7fd0344f2e80 }, {pos = 16, events = 0, fd = 64078496, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fd035e212ba}, {pos = 0, events = 0, fd = 877325780, user_data = 0x0}, {pos = 1652416960, events = 22076, fd = 2, user_data = 0x0}, {pos = 2036550080, events = 22076, fd = 1636012245, user_data = 0x563c796a4fa0}, {pos = 1636016234, events = 22076, fd = 2037010427, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 876831944, user_data = 0x7fd03449c880 }, {pos = 891842296, events = 32720, fd = 64078704, user_data = 0x100007f00000002}, {pos = 877359261, events = 32720, fd = 2, user_data = 0x563c796a4fa0}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 878648416, events = 32720, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 22016, 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 = 2036985280, events = 22076, fd = 1080, user_data = 0x563c7969fde0}, {pos = 1639506009, events = 22076, fd = 1024, user_data = 0x7fd0344b58ee}, {pos = 878631392, events = 32720, fd = 877269358, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2036990448, user_data = 0x76ac294ce69ae600}, {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 = 0x563c7969fde0}, {pos = 3, events = 0, fd = 0, user_data = 0x647e}, {pos = -328, events = 4294967295, fd = 0, user_data = 0x106}, {pos = 877605011, events = 32720, fd = 2036989408, user_data = 0x1}, {pos = 2036989608, events = 22076, fd = 1024, user_data = 0x7ffc03d1c378}, {pos = 1639587149, events = 22076, fd = 1652521680, user_data = 0x563c61b9080a }, {pos = 2036989408, events = 22076, fd = 2036802816, user_data = 0x563c7969fde0}, {pos = 877353198, events = 32720, fd = 0, user_data = 0x563c61ba2474 }, {pos = 2036989408, events = 1, fd = 1639589309, user_data = 0x563c79672500}, {pos = 877275825, events = 32720, fd = 877270256, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -426056192, events = 1990994252, fd = 2036550080, user_data = 0x76ac294ce69ae600}, {pos = 13, events = 0, fd = -426056192, user_data = 0x0}, {pos = 876982841, events = 32720, fd = 0, user_data = 0x563c617458b3 }, {pos = 4194304, events = 0, fd = 2036636720, user_data = 0x1}, {pos = 0, events = 0, fd = 2036550080, user_data = 0x563c61b9069e }, {pos = 2036636720, events = 22076, fd = 2036802816, user_data = 0x563c79649c30}, {pos = 1, events = 0, fd = 0, user_data = 0x563c61b4eb1d }, {pos = 13, events = 0, fd = 2036980744, user_data = 0x563c7969dbe8}, {pos = 1652418392, events = 22076, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1635015277, user_data = 0x563c79672500}, {pos = 1635032178, events = 22076, fd = 1648737296, user_data = 0x563c79672ea8}} [22:35:23.410] nevents = 1 [22:35:23.410] __func__ = "ServerLoop" [22:35:23.410] #31 0x0000563c6174eed9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563c79630830) at ../src/backend/postmaster/postmaster.c:1399 [22:35:23.410] opt = [22:35:23.410] status = [22:35:23.410] userDoption = [22:35:23.410] listen_addr_saved = false [22:35:23.410] output_config_variable = [22:35:23.410] __func__ = "PostmasterMain" [22:35:23.410] #32 0x0000563c6157deca in main (argc=4, argv=0x563c79630830) at ../src/backend/main/main.c:227 [22:35:23.410] do_check_root = [22:35:23.410] dispatch_option =