[03:02:58.485] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:02:58.694] dumping /tmp/cores/postgres-6-79648.core for /tmp/cirrus-ci-build/build-32/tmp_install//usr/local/pgsql/bin/postgres [03:02:58.946] [New LWP 79648] [03:02:58.946] [03:02:58.946] This GDB supports auto-downloading debuginfo from the following URLs: [03:02:58.946] [03:02:58.946] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:02:58.946] Debuginfod has been disabled. [03:02:58.946] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:02:59.104] [Thread debugging using libthread_db enabled] [03:02:59.104] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:02:59.104] Core was generated by `postgres: postgres regression_test_regex [local] SELECT '. [03:02:59.104] Program terminated with signal SIGABRT, Aborted. [03:02:59.104] #0 0xf7edb559 in __kernel_vsyscall () [03:02:59.418] [03:02:59.418] Thread 1 (Thread 0xf3d80240 (LWP 79648)): [03:02:59.418] #0 0xf7edb559 in __kernel_vsyscall () [03:02:59.418] No symbol table info available. [03:02:59.418] #1 0xf6816407 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:02:59.418] No symbol table info available. [03:02:59.418] #2 0xf67c5111 in raise () from /lib/i386-linux-gnu/libc.so.6 [03:02:59.418] No symbol table info available. [03:02:59.418] #3 0xf67ae26a in abort () from /lib/i386-linux-gnu/libc.so.6 [03:02:59.418] No symbol table info available. [03:02:59.418] #4 0xf69d1d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:02:59.418] No locals. [03:02:59.418] #5 0xf69e0896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:02:59.418] No locals. [03:02:59.418] #6 0xf69be58c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [03:02:59.418] bp = 4290258936 [03:02:59.418] pc = [03:02:59.418] Opts = {FromUnrecoverableHandler = 208, pc = 4290259416, bp = 4137411936} [03:02:59.418] #7 0x56ff6c2f in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [03:02:59.418] __func__ = "pg_check_regex_collation" [03:02:59.418] #8 0x56ff6fba in pg_regcomp (re=0xffb829d0, string=0x599e91dc, len=8, flags=3, collation=100) at ../src/backend/regex/regcomp.c:453 [03:02:59.418] var = {re = 0xffb829d0, now = 0x599e91f8, stop = 0x599e91fc, err = 0, cflags = 3, lasttype = 110, nexttype = 60, nextvalue = 36, lexcon = 1, nsubexp = 0, subs = 0xffb82864, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x599e9448, cm = 0x599e9270, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1474940916, cv = 0x599e7ec0, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [03:02:59.418] v = 0xffb82834 [03:02:59.418] g = 0x599e9228 [03:02:59.418] i = [03:02:59.418] j = [03:02:59.418] debug = 0x0 [03:02:59.418] #9 0xeaf5e89f in test_re_compile (text_re=text_re@entry=0x599c24c4, cflags=3, collation=collation@entry=100, result_re=0xffb829d0) at ../src/test/modules/test_regex/test_regex.c:176 [03:02:59.418] text_re_len = 8 [03:02:59.418] text_re_val = 0x599c24c8 "[[:<:]]a~\177\177\177 " [03:02:59.418] pattern = 0x599e91dc [03:02:59.418] pattern_len = [03:02:59.418] regcomp_result = [03:02:59.418] errMsg = "x\257FW\300\002\250Y\f\000\000\000\000\000\000\000ЮFW\364\317\351W|\005\250Y\200ȧYpd\323V\300\002\250Y\f\000\000\000d*\270\377Ed\323V\200ȧY\364\317\351W\260\221\236Ys\bBW|\005\250Y\376\364AW0\006\250YI\343\365\352x\020\250Y\310\017\250Y\001\000\000\000\002\000\000" [03:02:59.418] __func__ = "test_re_compile" [03:02:59.418] #10 0xeaf6032a in test_regex (fcinfo=0x59a7c880) at ../src/test/modules/test_regex/test_regex.c:101 [03:02:59.418] flags = [03:02:59.418] collation = 100 [03:02:59.418] oldcontext = 0x59a787d0 [03:02:59.418] pattern = 0x599c24c4 [03:02:59.418] re_flags = {cflags = 3, eflags = 0, info = 1152, glob = false, indices = false, partial = false} [03:02:59.418] cpattern = {re_magic = 65239, re_nsub = 1504185092, re_info = 128, re_csize = 4, re_endp = 0x59a80fc8 "w\001", re_collation = 100, re_guts = 0x599e9228 '\177' , re_fns = 0x57e87dc0 "\204\317\375V\207v\375V"} [03:02:59.418] funcctx = 0x599e91b0 [03:02:59.418] matchctx = [03:02:59.418] result_ary = [03:02:59.418] #11 0x56d28af5 in ExecMakeTableFunctionResult (setexpr=0x59a80620, econtext=, argContext=0x59a7c7f0, expectedDesc=0x59a814ac, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [03:02:59.418] result = 1463603642 [03:02:59.418] tupstore = 0x0 [03:02:59.418] tupdesc = 0x0 [03:02:59.418] funcrettype = 1009 [03:02:59.418] returnsTuple = false [03:02:59.418] returnsSet = true [03:02:59.418] fcinfo = 0x59a7c880 [03:02:59.418] fcusage = {fs = 0x0, save_f_total_time = {ticks = 6286206802287274716}, save_total = {ticks = -1514851026972950760}, start = {ticks = 6286129778171369044}} [03:02:59.418] rsinfo = {type = T_ReturnSetInfo, econtext = 0x59a8057c, expectedDesc = 0x59a814ac, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [03:02:59.418] tmptup = {t_len = 1009, t_self = {ip_blkid = {bi_hi = 1009, bi_lo = 0}, ip_posid = 53236}, t_tableOid = 1464282888, t_data = 0x57e9cff4} [03:02:59.418] callerContext = 0x59a802c0 [03:02:59.418] first_time = true [03:02:59.418] __func__ = "ExecMakeTableFunctionResult" [03:02:59.418] #12 0x56d5b4ea in FunctionNext (node=0x59a80470) at ../src/backend/executor/nodeFunctionscan.c:94 [03:02:59.418] tstore = 0x0 [03:02:59.418] estate = [03:02:59.418] direction = ForwardScanDirection [03:02:59.418] scanslot = 0x59a815c4 [03:02:59.418] alldone = [03:02:59.418] oldpos = [03:02:59.418] funcno = [03:02:59.418] att = [03:02:59.418] #13 0x56d2a683 in ExecScanFetch (node=node@entry=0x59a80470, accessMtd=accessMtd@entry=0x56d5b241 , recheckMtd=recheckMtd@entry=0x56d5b11f ) at ../src/backend/executor/execScan.c:131 [03:02:59.418] estate = [03:02:59.418] #14 0x56d2a791 in ExecScan (node=0x59a80470, accessMtd=0x56d5b241 , recheckMtd=0x56d5b11f ) at ../src/backend/executor/execScan.c:180 [03:02:59.418] econtext = 0x59a8057c [03:02:59.418] qual = 0x0 [03:02:59.418] projInfo = 0x0 [03:02:59.418] #15 0x56d5b1b2 in ExecFunctionScan (pstate=0x59a80470) at ../src/backend/executor/nodeFunctionscan.c:269 [03:02:59.418] node = [03:02:59.418] #16 0x56d22ded in ExecProcNodeFirst (node=0x59a80470) at ../src/backend/executor/execProcnode.c:469 [03:02:59.418] No locals. [03:02:59.418] #17 0x56d0cda0 in ExecProcNode (node=node@entry=0x59a80470) at ../src/include/executor/executor.h:278 [03:02:59.418] No locals. [03:02:59.418] #18 0x56d0cfa5 in ExecutePlan (estate=estate@entry=0x59a80350, planstate=0x59a80470, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x59a840f8, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:02:59.418] slot = [03:02:59.418] current_tuple_count = 0 [03:02:59.418] #19 0x56d0ef24 in standard_ExecutorRun (queryDesc=0x599e8da0, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:362 [03:02:59.418] estate = 0x59a80350 [03:02:59.418] operation = CMD_SELECT [03:02:59.418] dest = 0x59a840f8 [03:02:59.418] sendTuples = [03:02:59.418] oldcontext = 0x599e8d10 [03:02:59.418] __func__ = "standard_ExecutorRun" [03:02:59.418] #20 0x56d0f1f6 in ExecutorRun (queryDesc=0x599e8da0, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:303 [03:02:59.418] No locals. [03:02:59.418] #21 0x5713ce6d in PortalRunSelect (portal=portal@entry=0x59a18910, forward=forward@entry=true, count=0, count@entry=2147483647, dest=0x59a840f8) at ../src/backend/tcop/pquery.c:924 [03:02:59.418] queryDesc = 0x599e8da0 [03:02:59.418] direction = [03:02:59.418] nprocessed = [03:02:59.418] __func__ = "PortalRunSelect" [03:02:59.418] #22 0x571406b5 in PortalRun (portal=0x59a18910, count=2147483647, isTopLevel=true, run_once=true, dest=0x59a840f8, altdest=0x59a840f8, qc=0xffb82ea4) at ../src/backend/tcop/pquery.c:768 [03:02:59.418] _save_exception_stack = 0xffb82f24 [03:02:59.418] _save_context_stack = 0x0 [03:02:59.418] _local_sigjmp_buf = {{__jmpbuf = {1474940916, 1, 1503758608, 1503404376, 893586822, 1830803671}, __mask_was_saved = 0, __saved_mask = {__val = {8, 0, 1474940916, 60, 1467189906, 1474940916, 1474940916, 1474940916, 0, 60, 468, 1464252315, 1503400848, 60, 0, 1464252134, 1503563024, 2, 0, 1474940916, 2, 1503758608, 1503404376, 1452794904, 60, 2, 1503404376, 1460925438, 1503894112, 1474940916, 1503404348, 1460871305}}}} [03:02:59.418] _do_rethrow = [03:02:59.418] result = [03:02:59.418] nprocessed = [03:02:59.418] saveTopTransactionResourceOwner = 0x599f6210 [03:02:59.418] saveTopTransactionContext = 0x59a399d0 [03:02:59.418] saveActivePortal = 0x0 [03:02:59.418] saveResourceOwner = 0x599f6210 [03:02:59.418] savePortalContext = 0x0 [03:02:59.418] saveMemoryContext = 0x59a399d0 [03:02:59.418] __func__ = "PortalRun" [03:02:59.418] #23 0x571391fa in exec_simple_query (query_string=query_string@entry=0x599c1420 "select * from test_regex('[[:<:]]a', 'a', 'LP');") at ../src/backend/tcop/postgres.c:1283 [03:02:59.418] cmdtaglen = 6 [03:02:59.418] snapshot_set = [03:02:59.418] per_parsetree_context = 0x0 [03:02:59.418] plantree_list = 0x59a840cc [03:02:59.418] parsetree = 0x599c213c [03:02:59.418] commandTag = [03:02:59.418] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:02:59.418] querytree_list = [03:02:59.418] portal = 0x59a18910 [03:02:59.418] receiver = [03:02:59.418] format = 0 [03:02:59.418] cmdtagname = [03:02:59.418] parsetree_item__state = [03:02:59.418] dest = DestRemote [03:02:59.418] oldcontext = 0x59a399d0 [03:02:59.418] parsetree_list = 0x599c2158 [03:02:59.418] parsetree_item = 0x599c2168 [03:02:59.418] save_log_statement_stats = false [03:02:59.418] was_logged = false [03:02:59.418] use_implicit_block = false [03:02:59.418] msec_str = " \024\234Y0\000\000\000Q\000\000\000\352D\337V\020/\270\377\376\377\377?,\2716g\337F\337V" [03:02:59.418] __func__ = "exec_simple_query" [03:02:59.418] #24 0x5713c154 in PostgresMain (dbname=0x5999c2cc "regression_test_regex", username=0x599f4590 "postgres") at ../src/backend/tcop/postgres.c:4798 [03:02:59.418] query_string = 0x599c1420 "select * from test_regex('[[:<:]]a', 'a', 'LP');" [03:02:59.418] firstchar = [03:02:59.418] input_message = {data = 0x599c1420 "select * from test_regex('[[:<:]]a', 'a', 'LP');", len = 49, maxlen = 1024, cursor = 49} [03:02:59.418] local_sigjmp_buf = {{__jmpbuf = {1474940916, 1479052972, 1479052976, 1, 893676934, 1651952855}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1503240944, 1464160092, 1, 1504, 1474940916, 84, 1474941680, 198, 1474940916, 1474940916, 256, 468, 1503240944, 1464251941, 1503240944, 9760, 0, 1464251765, 1474940916, 1479047616, 1479052976, 1460619726, 9760, 4135701338, 1474940916, 1459321134, 3943461160, 1, 4135254869, 1474940916}}}} [03:02:59.418] send_ready_for_query = false [03:02:59.418] idle_in_transaction_timeout_enabled = false [03:02:59.418] idle_session_timeout_enabled = false [03:02:59.418] __func__ = "PostgresMain" [03:02:59.418] #25 0x5713185e in BackendMain (startup_data=0xffb8306c "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [03:02:59.418] bsdata = 0xffb8306c [03:02:59.418] #26 0x56fc8038 in postmaster_child_launch (child_type=, child_slot=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:274 [03:02:59.418] pid = [03:02:59.418] #27 0x56fcd493 in BackendStartup (client_sock=client_sock@entry=0xffb830b8) at ../src/backend/postmaster/postmaster.c:3377 [03:02:59.418] bn = 0x599ee4c0 [03:02:59.418] pid = [03:02:59.418] startup_data = {canAcceptConnections = CAC_OK} [03:02:59.418] cac = [03:02:59.418] __func__ = "BackendStartup" [03:02:59.418] #28 0x56fcf4d6 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:02:59.418] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\fW\b\000\000\000L\001\330\363\260$\237Y\244(\fW\364\317\351W\260$\237Y\3603\234Y\271:\fW\364\317\351W\367$\237Yh3\234Y\377\027\000\000\000\020\000\000\000\000\000\000\000\000\000\000\001\000\000\000\352\003\000\000\353\003\000\000\200\201\000\000\272\267\006\000\000\000\000\000P\n\000\000\000\000\000\000\b\000\000\000\000\000\000\000t80\000\000\000\000\000Ը6g\000\000\000\000\302=\221\024", __ss_align = 0}, salen = 2}} [03:02:59.418] i = 0 [03:02:59.418] now = [03:02:59.418] last_lockfile_recheck_time = 1731639596 [03:02:59.418] last_touch_time = 1731639596 [03:02:59.418] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 65143300, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 945068287, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x1b}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 4112, user_data = 0xf682462c}, {pos = 1503550544, events = 54, fd = 4096, user_data = 0xf6824c42}, {pos = -157642764, events = 4137326584, fd = 8224, user_data = 0x1000}, {pos = 1503550536, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x6b}, {pos = 0, events = 0, fd = 0, user_data = 0xf69a97c0}, {pos = 4096, events = 4137324532, fd = -216, user_data = 0xf6825a4f }, {pos = 1503281232, events = 4137324532, fd = -4705464, user_data = 0xf6895b4c <__fstat64_time64+44>}, {pos = 8, events = 4136901929, fd = -4705728, user_data = 0xf69a8ff4}, {pos = -159330249, events = 4137324532, fd = 1503281232, user_data = 0xf67feb22 <_IO_file_doallocate+178>}, {pos = 1503281232, events = 1503550544, fd = 1503554640, user_data = 0x1}, {pos = 2049, events = 0, fd = 440250, user_data = 0x0}, {pos = 33152, events = 4159595332, fd = -159731494, user_data = 0x566aa6bd}, {pos = 0, events = 0, fd = 2640, user_data = 0x0}, {pos = 4096, events = 4159770612, fd = 0, user_data = 0x6736b8d4}, {pos = 0, events = 4149846432, fd = -159819464, user_data = 0xf6793cf8}, {pos = 2090263927, events = 4159596297, fd = 1, user_data = 0x1}, {pos = -159795304, events = 1510, fd = -159766376, user_data = 0xf759a1a0}, {pos = -4705516, events = 4290261776, fd = 2048, user_data = 0xf6824c42}, {pos = -157642764, events = 43, fd = 0, user_data = 0xf6795938}, {pos = -135196684, events = 4135200920, fd = 1449622727, user_data = 0xf679b798}, {pos = 2090263927, events = 4149846432, fd = 23, user_data = 0xffb833a0}, {pos = -4705516, events = 4091862096, fd = 2056, user_data = 0xf6823619}, {pos = 8, events = 4137326528, fd = -157642764, user_data = 0x811}, {pos = 0, events = 0, fd = 1, user_data = 0x5745402e }, {pos = -157642764, events = 2090263927, fd = -135193560, user_data = 0xffb833a0}, {pos = -4705372, events = 4159598286, fd = 1449436496, user_data = 0xffb833a4}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 7045835, user_data = 0x1400}, {pos = -135196684, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 12, fd = 79621, user_data = 0xf686b6cc }, {pos = 12, events = 0, fd = -4705168, user_data = 0xf681b692 }, {pos = -1, events = 4135171992, fd = -145120864, user_data = 0x1010}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 1474940916, events = 0, fd = 1449622727, user_data = 0x57e9d234 }, {pos = -135194032, events = 4159625163, fd = 0, user_data = 0xf680dc6d}, {pos = -4705268, events = 4159773736, fd = -203104992, user_data = 0x1}, {pos = 0, events = 4137319252, fd = -157650048, user_data = 0xffb8340c}, {pos = 0, events = 1128, fd = -135196684, user_data = 0xf680c380}, {pos = 0, events = 0, fd = 0, user_data = 0x9f826100}, {pos = -159795304, events = 4136023232, fd = -157642764, user_data = 0x9f826100}, {pos = -157642764, events = 79621, fd = 12, user_data = 0xf67c5380 }, {pos = 2, events = 4290262128, fd = 0, user_data = 0x57e9cff4}, {pos = 0, events = 4135342950, fd = 1474940916, user_data = 0x56fc7c7e }, {pos = 2, events = 4290262128, fd = 0, user_data = 0x57456f3c }, {pos = 4194304, events = 0, fd = 119875829, user_data = 0x79816}, {pos = 1731639596, events = 0, fd = 74, user_data = 0x0}, {pos = -157642764, events = 4290262268, fd = 1503594020, user_data = 0xf68651cc <__clock_gettime64+60>}, {pos = 0, events = 4290262268, fd = 1474940916, user_data = 0x5740fa03 }, {pos = 1503546400, events = 0, fd = 1474940916, user_data = 0x574136c4 }, {pos = -4704952, events = 1503594064, fd = 1503409000, user_data = 0x8596bd}, {pos = 0, events = 4290262268, fd = 1503409136, user_data = 0x57e9cff4}, {pos = 12, events = 1503592100, fd = 1503592080, user_data = 0x56fca7e0 }, {pos = 13, events = 0, fd = 12, user_data = 0x57e9cff4}, {pos = 0, events = 12, fd = 12, user_data = 0x56fc7e58 }, {pos = 237, events = 1478999808, fd = 1459400489, user_data = 0x56fcc08a }, {pos = 1503592080, events = 12, fd = 0, user_data = 0x0}, {pos = 12, events = 1476911760, fd = 1503403136, user_data = 0x5807e290 }} [03:02:59.418] nevents = 1 [03:02:59.418] __func__ = "ServerLoop" [03:02:59.418] #29 0x56fd0da2 in PostmasterMain (argc=8, argv=0x5999a230) at ../src/backend/postmaster/postmaster.c:1361 [03:02:59.418] opt = [03:02:59.418] status = [03:02:59.418] userDoption = [03:02:59.418] listen_addr_saved = false [03:02:59.418] output_config_variable = [03:02:59.418] __func__ = "PostmasterMain" [03:02:59.418] #30 0x56dfa9f2 in main (argc=8, argv=0x5999a230) at ../src/backend/main/main.c:196 [03:02:59.418] do_check_root = [03:02:59.444] -e [03:02:59.444] [03:02:59.444] [03:02:59.506] dumping /tmp/cores/sh-3-44768.core for /bin/sh [03:02:59.555] [03:02:59.555] This GDB supports auto-downloading debuginfo from the following URLs: [03:02:59.555] [03:02:59.555] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:02:59.555] Debuginfod has been disabled. [03:02:59.555] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:02:59.560] [New LWP 44768] [03:02:59.562] [Thread debugging using libthread_db enabled] [03:02:59.562] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:02:59.562] Core was generated by `sh -c cp "pg_wal/000000010000000000000003.00000028.backup" "/tmp/cirrus-ci-buil'. [03:02:59.562] Program terminated with signal SIGQUIT, Quit. [03:02:59.562] #0 0x00007f6c936eeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] [03:02:59.567] Thread 1 (Thread 0x7f6c9365c740 (LWP 44768)): [03:02:59.567] #0 0x00007f6c936eeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] No symbol table info available. [03:02:59.567] #1 0x00007f6c9369b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] No symbol table info available. [03:02:59.567] #2 0x00007f6c9369b497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] No symbol table info available. [03:02:59.567] #3 0x0000562a4a49f5c1 in ?? () [03:02:59.567] No symbol table info available. [03:02:59.567] #4 0x0000562a4a499369 in ?? () [03:02:59.567] No symbol table info available. [03:02:59.567] #5 0x0000562a4a49820f in ?? () [03:02:59.567] No symbol table info available. [03:02:59.567] #6 0x0000562a4a498c3b in ?? () [03:02:59.567] No symbol table info available. [03:02:59.567] #7 0x0000562a4a49666f in ?? () [03:02:59.567] No symbol table info available. [03:02:59.567] #8 0x00007f6c9368624a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] No symbol table info available. [03:02:59.567] #9 0x00007f6c93686305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [03:02:59.567] No symbol table info available. [03:02:59.567] #10 0x0000562a4a496781 in ?? () [03:02:59.567] No symbol table info available. [03:02:59.577] -e [03:02:59.577] [03:02:59.577] [03:02:59.644] dumping /tmp/cores/postgres-6-63849.core for /tmp/cirrus-ci-build/build-32/tmp_install//usr/local/pgsql/bin/postgres [03:02:59.894] [New LWP 63849] [03:02:59.894] [03:02:59.894] This GDB supports auto-downloading debuginfo from the following URLs: [03:02:59.894] [03:02:59.894] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:02:59.894] Debuginfod has been disabled. [03:02:59.894] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:00.006] [Thread debugging using libthread_db enabled] [03:03:00.006] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:00.006] Core was generated by `postgres: postgres regression [local] SELECT '. [03:03:00.006] Program terminated with signal SIGABRT, Aborted. [03:03:00.006] #0 0xf7edf559 in __kernel_vsyscall () [03:03:00.094] [03:03:00.094] Thread 1 (Thread 0xf3d84240 (LWP 63849)): [03:03:00.094] #0 0xf7edf559 in __kernel_vsyscall () [03:03:00.094] No symbol table info available. [03:03:00.094] #1 0xf681a407 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.094] No symbol table info available. [03:03:00.094] #2 0xf67c9111 in raise () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.094] No symbol table info available. [03:03:00.094] #3 0xf67b226a in abort () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.094] No symbol table info available. [03:03:00.094] #4 0xf69d5d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:03:00.094] No locals. [03:03:00.094] #5 0xf69e4896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:03:00.094] No locals. [03:03:00.094] #6 0xf69c258c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [03:03:00.094] bp = 4293863928 [03:03:00.094] pc = [03:03:00.094] Opts = {FromUnrecoverableHandler = 208, pc = 4293864344, bp = 4137428320} [03:03:00.094] #7 0x57007c2f in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [03:03:00.094] __func__ = "pg_check_regex_collation" [03:03:00.094] #8 0x57007fba in pg_regcomp (re=0xffef2b90, string=0x5945ea5c, len=37, flags=3, collation=100) at ../src/backend/regex/regcomp.c:453 [03:03:00.094] var = {re = 0xffef2b90, now = 0x5945ea70, stop = 0x5945eaf0, err = 0, cflags = 3, lasttype = 110, nexttype = 94, nextvalue = 152, lexcon = 1, nsubexp = 0, subs = 0xffef2a64, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x59447700, cm = 0x59447528, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1475010548, cv = 0x593c2ef0, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [03:03:00.094] v = 0xffef2a34 [03:03:00.094] g = 0x594474e0 [03:03:00.094] i = [03:03:00.094] j = [03:03:00.094] debug = 0x0 [03:03:00.094] #9 0x5730e5d7 in RE_compile_and_cache (text_re=0x5945ea10, cflags=3, collation=100) at ../src/backend/utils/adt/regexp.c:209 [03:03:00.094] text_re_len = 37 [03:03:00.094] text_re_val = 0x5945ea14 "***S^(?:a){1,1}?((?:b.d)){1,1}(?:.*)$", '`' , "\230" [03:03:00.094] pattern = 0x5945ea5c [03:03:00.094] pattern_len = 37 [03:03:00.094] i = [03:03:00.094] regcomp_result = [03:03:00.094] re_temp = {cre_context = 0x59447450, cre_pat = 0x5945e980 "\324\001", cre_pat_len = 64, cre_flags = 0, cre_collation = 1464321397, cre_re = {re_magic = 65239, re_nsub = 1496909580, re_info = 100000, re_csize = 4, re_endp = 0x40 , re_collation = 100, re_guts = 0x594474e0 '\177' , re_fns = 0x57e98dc0 "\204\337\376V\207\206\376V"}} [03:03:00.094] errMsg = "d,\357\377\276NFW\374\315EY\000\316EY8\322EY\200\351EY\003\000\000\000\360\351EY\000\000\000\000/aFW@\000\000\000\003\000\000\000\200\351EY\225^FW\031\000\000\000\031\000\000\000\364\337\352W<\000\000\000\000\316EY\375\334=W\364\337\352W\364\337\352W\000\000\000\000\324\001\000\000h\a9Y" [03:03:00.094] oldcontext = 0x5945e980 [03:03:00.094] __func__ = "RE_compile_and_cache" [03:03:00.094] #10 0x5730ff3e in textregexsubstr (fcinfo=0x5945cde0) at ../src/backend/utils/adt/regexp.c:593 [03:03:00.094] s = 0x5939071c [03:03:00.094] p = [03:03:00.094] re = [03:03:00.094] pmatch = {{rm_so = 1497748068, rm_eo = 1496909668}, {rm_so = 1475010548, rm_eo = 1462831093}} [03:03:00.094] so = [03:03:00.094] eo = [03:03:00.094] #11 0x56d0f20a in ExecInterpExpr (state=0x5945cd2c, econtext=0x5945cbac, isnull=0xffef2cdf) at ../src/backend/executor/execExprInterp.c:770 [03:03:00.094] fcinfo = 0x5945cde0 [03:03:00.094] args = 0x5945cdf4 [03:03:00.094] nargs = 2 [03:03:00.094] d = [03:03:00.094] op = 0x5945cebc [03:03:00.094] resultslot = 0x5945ccb0 [03:03:00.094] innerslot = 0x0 [03:03:00.094] outerslot = 0x0 [03:03:00.094] scanslot = 0x0 [03:03:00.094] dispatch_table = {0x56d0d20f , 0x56d0d262 , 0x56d0d364 , 0x56d0d466 , 0x56d0d568 , 0x56d0d7b9 , 0x56d0da0a , 0x56d0dc5b , 0x56d0dcb3 , 0x56d0dd0b , 0x56d0dd63 , 0x56d0ddba , 0x56d0e17d , 0x56d0e540 , 0x56d0e903 , 0x56d0eb45 , 0x56d0ee36 , 0x56d0ef4d , 0x56d0f0c3 , 0x56d0f2b0 , 0x56d0f307 , 0x56d0f35e , 0x56d0f38e , 0x56d0f57a , 0x56d0f706 , 0x56d0f736 , 0x56d0f922 , 0x56d0faae , 0x56d0fb5c , 0x56d0fd09 , 0x56d0fd9b , 0x56d0fec9 , 0x56d0fff7 , 0x56d10173 , 0x56d102a4 , 0x56d103d5 , 0x56d1042c , 0x56d10483 , 0x56d1059b , 0x56d106f4 , 0x56d1084d , 0x56d10965 , 0x56d109bc , 0x56d10a13 , 0x56d10aa5 , 0x56d10afc , 0x56d10eec , 0x56d11079 , 0x56d11564 , 0x56d115b7 , 0x56d1180e , 0x56d11a55 , 0x56d11cec , 0x56d11d3f , 0x56d11d92 , 0x56d11de5 , 0x56d11e38 , 0x56d11e8f , 0x56d11ee2 , 0x56d122eb , 0x56d1250f , 0x56d12562 , 0x56d125b9 , 0x56d12610 , 0x56d12667 , 0x56d1276c , 0x56d127b1 , 0x56d1276c , 0x56d10cf4 , 0x56d128fb , 0x56d1294e , 0x56d129a1 , 0x56d12a79 , 0x56d12bfb , 0x56d12e07 , 0x56d12f88 , 0x56d127fd , 0x56d12851 , 0x56d128a4 , 0x56d131b8 , 0x56d1320b , 0x56d13262 , 0x56d132b5 , 0x56d13321 , 0x56d13378 , 0x56d133cb , 0x56d1359d , 0x56d135f0 , 0x56d13825 , 0x56d1387c , 0x56d138d3 , 0x56d139c2 , 0x56d13c20 , 0x56d13da6 , 0x56d13f25 , 0x56d140e1 , 0x56d14551 , 0x56d14981 , 0x56d14d86 , 0x56d152a7 , 0x56d1577d , 0x56d15c26 , 0x56d15d5d , 0x56d15e93 , 0x56d15eea , 0x56d15f41 } [03:03:00.094] #12 0x56d027f2 in ExecInterpExprStillValid (state=0x5945cd2c, econtext=0x5945cbac, isNull=0xffef2cdf) at ../src/backend/executor/execExprInterp.c:2035 [03:03:00.094] No locals. [03:03:00.094] #13 0x56daf4f5 in ExecEvalExprSwitchContext (state=0x5945cd2c, econtext=, isNull=) at ../src/include/executor/executor.h:367 [03:03:00.094] retDatum = [03:03:00.094] oldContext = 0x5945c970 [03:03:00.094] #14 0x56daf5f0 in ExecProject (projInfo=0x5945cd28) at ../src/include/executor/executor.h:401 [03:03:00.094] econtext = 0x5945cbac [03:03:00.094] state = 0x5945cd2c [03:03:00.094] slot = 0x5945ccb0 [03:03:00.094] isnull = 87 [03:03:00.094] #15 0x56dafa11 in ExecResult (pstate=0x5945cb20) at ../src/backend/executor/nodeResult.c:135 [03:03:00.094] node = 0x5945cb20 [03:03:00.094] outerTupleSlot = [03:03:00.094] outerPlan = [03:03:00.094] econtext = 0x5945cbac [03:03:00.094] #16 0x56d33ded in ExecProcNodeFirst (node=0x5945cb20) at ../src/backend/executor/execProcnode.c:469 [03:03:00.094] No locals. [03:03:00.094] #17 0x56d1dda0 in ExecProcNode (node=node@entry=0x5945cb20) at ../src/include/executor/executor.h:278 [03:03:00.094] No locals. [03:03:00.094] #18 0x56d1dfa5 in ExecutePlan (estate=estate@entry=0x5945ca00, planstate=0x5945cb20, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=1, direction=ForwardScanDirection, dest=0x593bc76c, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:03:00.094] slot = [03:03:00.094] current_tuple_count = 0 [03:03:00.094] #19 0x56d1ff24 in standard_ExecutorRun (queryDesc=0x593bc798, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:362 [03:03:00.094] estate = 0x5945ca00 [03:03:00.094] operation = CMD_SELECT [03:03:00.094] dest = 0x593bc76c [03:03:00.094] sendTuples = [03:03:00.094] oldcontext = 0x59454920 [03:03:00.094] __func__ = "standard_ExecutorRun" [03:03:00.094] #20 0x56d201f6 in ExecutorRun (queryDesc=0x593bc798, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:303 [03:03:00.094] No locals. [03:03:00.094] #21 0x56d4af85 in postquel_getnext (es=es@entry=0x594568f8, fcache=fcache@entry=0x594549b0) at ../src/backend/executor/functions.c:897 [03:03:00.094] count = 1 [03:03:00.094] result = [03:03:00.094] #22 0x56d4def6 in fmgr_sql (fcinfo=0x594443d4) at ../src/backend/executor/functions.c:1198 [03:03:00.094] completed = [03:03:00.094] fcache = 0x594549b0 [03:03:00.094] sqlerrcontext = {previous = 0x0, callback = 0x56d48f31 , arg = 0x594443a8} [03:03:00.094] oldcontext = 0x593c0490 [03:03:00.094] randomAccess = [03:03:00.094] lazyEvalOK = [03:03:00.094] is_first = [03:03:00.094] pushed_snapshot = false [03:03:00.094] es = 0x594568f8 [03:03:00.094] slot = [03:03:00.094] result = [03:03:00.094] eslist = 0x593bc51c [03:03:00.094] eslc = [03:03:00.094] __func__ = "fmgr_sql" [03:03:00.094] #23 0x56d0f20a in ExecInterpExpr (state=0x5944431c, econtext=0x5944482c, isnull=0xffef2f6f) at ../src/backend/executor/execExprInterp.c:770 [03:03:00.094] fcinfo = 0x594443d4 [03:03:00.094] args = 0x594443e8 [03:03:00.094] nargs = 3 [03:03:00.094] d = [03:03:00.094] op = 0x59444420 [03:03:00.094] resultslot = 0x0 [03:03:00.094] innerslot = 0x0 [03:03:00.094] outerslot = 0x0 [03:03:00.094] scanslot = 0x0 [03:03:00.094] dispatch_table = {0x56d0d20f , 0x56d0d262 , 0x56d0d364 , 0x56d0d466 , 0x56d0d568 , 0x56d0d7b9 , 0x56d0da0a , 0x56d0dc5b , 0x56d0dcb3 , 0x56d0dd0b , 0x56d0dd63 , 0x56d0ddba , 0x56d0e17d , 0x56d0e540 , 0x56d0e903 , 0x56d0eb45 , 0x56d0ee36 , 0x56d0ef4d , 0x56d0f0c3 , 0x56d0f2b0 , 0x56d0f307 , 0x56d0f35e , 0x56d0f38e , 0x56d0f57a , 0x56d0f706 , 0x56d0f736 , 0x56d0f922 , 0x56d0faae , 0x56d0fb5c , 0x56d0fd09 , 0x56d0fd9b , 0x56d0fec9 , 0x56d0fff7 , 0x56d10173 , 0x56d102a4 , 0x56d103d5 , 0x56d1042c , 0x56d10483 , 0x56d1059b , 0x56d106f4 , 0x56d1084d , 0x56d10965 , 0x56d109bc , 0x56d10a13 , 0x56d10aa5 , 0x56d10afc , 0x56d10eec , 0x56d11079 , 0x56d11564 , 0x56d115b7 , 0x56d1180e , 0x56d11a55 , 0x56d11cec , 0x56d11d3f , 0x56d11d92 , 0x56d11de5 , 0x56d11e38 , 0x56d11e8f , 0x56d11ee2 , 0x56d122eb , 0x56d1250f , 0x56d12562 , 0x56d125b9 , 0x56d12610 , 0x56d12667 , 0x56d1276c , 0x56d127b1 , 0x56d1276c , 0x56d10cf4 , 0x56d128fb , 0x56d1294e , 0x56d129a1 , 0x56d12a79 , 0x56d12bfb , 0x56d12e07 , 0x56d12f88 , 0x56d127fd , 0x56d12851 , 0x56d128a4 , 0x56d131b8 , 0x56d1320b , 0x56d13262 , 0x56d132b5 , 0x56d13321 , 0x56d13378 , 0x56d133cb , 0x56d1359d , 0x56d135f0 , 0x56d13825 , 0x56d1387c , 0x56d138d3 , 0x56d139c2 , 0x56d13c20 , 0x56d13da6 , 0x56d13f25 , 0x56d140e1 , 0x56d14551 , 0x56d14981 , 0x56d14d86 , 0x56d152a7 , 0x56d1577d , 0x56d15c26 , 0x56d15d5d , 0x56d15e93 , 0x56d15eea , 0x56d15f41 } [03:03:00.094] #24 0x56d027f2 in ExecInterpExprStillValid (state=0x5944431c, econtext=0x5944482c, isNull=0xffef2f6f) at ../src/backend/executor/execExprInterp.c:2035 [03:03:00.094] No locals. [03:03:00.094] #25 0x56ef157d in ExecEvalExprSwitchContext (isNull=0xffef2f6f, econtext=, state=0x5944431c) at ../src/include/executor/executor.h:367 [03:03:00.094] retDatum = [03:03:00.094] oldContext = 0x59444180 [03:03:00.094] retDatum = [03:03:00.094] oldContext = [03:03:00.094] #26 evaluate_expr (expr=0x593906bc, result_type=25, result_typmod=-1, result_collation=100) at ../src/backend/optimizer/util/clauses.c:5009 [03:03:00.094] estate = 0x59444210 [03:03:00.094] exprstate = 0x5944431c [03:03:00.094] oldcontext = 0x5938f360 [03:03:00.094] const_val = [03:03:00.094] const_is_null = 87 [03:03:00.094] resultTypLen = -14618 [03:03:00.094] resultTypByVal = false [03:03:00.094] #27 0x56ef1adc in evaluate_function (funcid=funcid@entry=2074, result_type=result_type@entry=25, result_typmod=result_typmod@entry=-1, result_collid=100, input_collid=100, args=0x59390bc0, funcvariadic=false, func_tuple=0xeaf8a3f0, context=0xffef326c) at ../src/backend/optimizer/util/clauses.c:4515 [03:03:00.094] funcform = [03:03:00.094] has_nonconst_input = false [03:03:00.094] has_null_input = false [03:03:00.094] arg = 0x0 [03:03:00.094] newexpr = [03:03:00.094] #28 0x56ef70f3 in simplify_function (funcid=funcid@entry=2074, result_type=25, result_typmod=-1, result_collid=100, input_collid=100, args_p=0xffef30c4, funcvariadic=false, process_args=true, allow_non_const=true, context=0xffef326c) at ../src/backend/optimizer/util/clauses.c:4104 [03:03:00.094] args = 0x59390bc0 [03:03:00.094] func_tuple = 0xeaf8a3f0 [03:03:00.094] func_form = 0xeaf8a428 [03:03:00.094] newexpr = [03:03:00.094] __func__ = "simplify_function" [03:03:00.094] #29 0x56ef24c6 in eval_const_expressions_mutator (node=0x59390670, context=0xffef326c) at ../src/backend/optimizer/util/clauses.c:2591 [03:03:00.094] expr = 0x59390670 [03:03:00.094] args = 0x59390bc0 [03:03:00.094] simple = [03:03:00.094] newexpr = [03:03:00.094] __func__ = "eval_const_expressions_mutator" [03:03:00.094] #30 0x56e20f67 in expression_tree_mutator_impl (node=0x593907ac, mutator=0x56ef1c3f , context=0xffef326c) at ../src/backend/nodes/nodeFuncs.c:3463 [03:03:00.094] targetentry = 0x593907ac [03:03:00.094] newnode = 0x59390b68 [03:03:00.094] __func__ = "expression_tree_mutator_impl" [03:03:00.094] #31 0x56ef1cec in eval_const_expressions_mutator (node=0x593907ac, context=0xffef326c) at ../src/backend/optimizer/util/clauses.c:3723 [03:03:00.094] __func__ = "eval_const_expressions_mutator" [03:03:00.094] #32 0x56e21767 in expression_tree_mutator_impl (node=0x593907d8, mutator=0x56ef1c3f , context=0xffef326c) at ../src/backend/nodes/nodeFuncs.c:3548 [03:03:00.094] temp__state = [03:03:00.094] resultlist = 0x0 [03:03:00.094] temp = [03:03:00.094] __func__ = "expression_tree_mutator_impl" [03:03:00.094] #33 0x56ef1cec in eval_const_expressions_mutator (node=0x593907d8, context=0xffef326c) at ../src/backend/optimizer/util/clauses.c:3723 [03:03:00.094] __func__ = "eval_const_expressions_mutator" [03:03:00.094] #34 0x56ef5adc in eval_const_expressions (root=0x59390878, node=0x593907d8) at ../src/backend/optimizer/util/clauses.c:2266 [03:03:00.094] context = {boundParams = 0x0, root = 0x59390878, active_fns = 0x0, case_val = 0x0, estimate = false} [03:03:00.094] #35 0x56ea9e82 in preprocess_expression (root=root@entry=0x59390878, expr=, kind=kind@entry=1) at ../src/backend/optimizer/plan/planner.c:1223 [03:03:00.094] No locals. [03:03:00.094] #36 0x56ebb4b8 in subquery_planner (glob=, parse=, parent_root=, hasRecursion=, tuple_fraction=, setops=) at ../src/backend/optimizer/plan/planner.c:843 [03:03:00.094] root = [03:03:00.094] newWithCheckOptions = [03:03:00.094] newHaving = [03:03:00.094] hasOuterJoins = false [03:03:00.094] hasResultRTEs = true [03:03:00.094] final_rel = [03:03:00.094] l = 0x0 [03:03:00.094] #37 0x56ebd28e in standard_planner (parse=0x59390174, query_string=0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:417 [03:03:00.094] result = [03:03:00.094] glob = 0x593905e4 [03:03:00.094] tuple_fraction = 0 [03:03:00.094] root = [03:03:00.094] final_rel = [03:03:00.094] best_path = [03:03:00.094] top_plan = [03:03:00.094] lp = [03:03:00.094] lr = [03:03:00.094] #38 0x56ebe4c2 in planner (parse=0x59390174, query_string=0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:284 [03:03:00.094] result = [03:03:00.094] #39 0x57149737 in pg_plan_query (querytree=0x59390174, query_string=0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:911 [03:03:00.094] plan = [03:03:00.094] #40 0x57149b10 in pg_plan_queries (querytrees=0x5939084c, query_string=0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:1005 [03:03:00.094] query = 0x59390174 [03:03:00.094] stmt = [03:03:00.094] query_list__state = [03:03:00.094] stmt_list = 0x0 [03:03:00.094] query_list = [03:03:00.094] #41 0x5714a0da in exec_simple_query (query_string=query_string@entry=0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";") at ../src/backend/tcop/postgres.c:1202 [03:03:00.094] cmdtaglen = 6 [03:03:00.094] snapshot_set = true [03:03:00.094] per_parsetree_context = 0x0 [03:03:00.094] plantree_list = [03:03:00.094] parsetree = 0x59390020 [03:03:00.094] commandTag = CMDTAG_SELECT [03:03:00.094] qc = {commandTag = 4293866688, nprocessed = 6260097448814501876} [03:03:00.094] querytree_list = [03:03:00.094] portal = [03:03:00.094] receiver = [03:03:00.094] format = 22340 [03:03:00.094] cmdtagname = [03:03:00.094] parsetree_item__state = [03:03:00.094] dest = DestRemote [03:03:00.094] oldcontext = 0x5940b9b0 [03:03:00.094] parsetree_list = 0x5939003c [03:03:00.094] parsetree_item = 0x5939004c [03:03:00.094] save_log_statement_stats = false [03:03:00.094] was_logged = false [03:03:00.094] use_implicit_block = false [03:03:00.094] msec_str = "\360\3638YF\000\000\000Q\000\000\000\352T\340V\3004\357\377\376\377\377?ָ6g\337V\340V" [03:03:00.094] __func__ = "exec_simple_query" [03:03:00.094] #42 0x5714d154 in PostgresMain (dbname=0x593c658c "regression", username=0x593c6570 "postgres") at ../src/backend/tcop/postgres.c:4798 [03:03:00.094] query_string = 0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";" [03:03:00.094] firstchar = [03:03:00.094] input_message = {data = 0x5938f3f0 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", len = 71, maxlen = 1024, cursor = 71} [03:03:00.094] local_sigjmp_buf = {{__jmpbuf = {1475010548, 1479122604, 1479122608, 1, 830859351, -966547194}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1496744640, 1464229724, 1, 1504, 1475010548, 84, 1475011312, 198, 1475010548, 1475010548, 256, 468, 1496744640, 1464321573, 1496744640, 9760, 0, 1464321397, 1475010548, 1479117248, 1479122608, 1460689358, 9760, 4135717722, 1475010548, 1459390766, 3943482280, 1, 4135271253, 1475010548}}}} [03:03:00.094] send_ready_for_query = false [03:03:00.094] idle_in_transaction_timeout_enabled = false [03:03:00.094] idle_session_timeout_enabled = false [03:03:00.094] __func__ = "PostgresMain" [03:03:00.094] #43 0x5714285e in BackendMain (startup_data=0xffef361c "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [03:03:00.094] bsdata = 0xffef361c [03:03:00.094] #44 0x56fd9038 in postmaster_child_launch (child_type=, child_slot=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:274 [03:03:00.094] pid = [03:03:00.094] #45 0x56fde493 in BackendStartup (client_sock=client_sock@entry=0xffef3668) at ../src/backend/postmaster/postmaster.c:3377 [03:03:00.094] bn = 0x593bc51c [03:03:00.094] pid = [03:03:00.094] startup_data = {canAcceptConnections = CAC_OK} [03:03:00.094] cac = [03:03:00.094] __func__ = "BackendStartup" [03:03:00.094] #46 0x56fe04d6 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:03:00.094] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\rW\b\000\000\000LA\330\363\200\004 [03:03:00.094] last_lockfile_recheck_time = 1731639508 [03:03:00.094] last_touch_time = 1731639508 [03:03:00.094] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 345062850, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 945068287, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x1b}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 4112, user_data = 0xf682862c}, {pos = 1497054240, events = 96, fd = 4096, user_data = 0xf6828c42}, {pos = -157626380, events = 4137342968, fd = 8224, user_data = 0x1000}, {pos = 1497054232, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x6b}, {pos = 0, events = 0, fd = 0, user_data = 0xf69ad7c0}, {pos = 4096, events = 4137340916, fd = -216, user_data = 0xf6829a4f }, {pos = 1496784928, events = 4137340916, fd = -1099528, user_data = 0xf6899b4c <__fstat64_time64+44>}, {pos = 8, events = 4136918313, fd = -1099792, user_data = 0xf69acff4}, {pos = -159313865, events = 4137340916, fd = 1496784928, user_data = 0xf6802b22 <_IO_file_doallocate+178>}, {pos = 1496784928, events = 1497054240, fd = 1497058336, user_data = 0x1}, {pos = 2049, events = 0, fd = 427844, user_data = 0x0}, {pos = 33152, events = 4159611716, fd = -159715110, user_data = 0x566bb6bd}, {pos = 0, events = 0, fd = 2640, user_data = 0x0}, {pos = 4096, events = 4159786996, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 4149862816, fd = -159803080, user_data = 0xf6797cf8}, {pos = 2090263927, events = 4159612681, fd = 1, user_data = 0x1}, {pos = -159778920, events = 1510, fd = -159749992, user_data = 0xf759e1a0}, {pos = -1099580, events = 4293867712, fd = 2048, user_data = 0xf6828c42}, {pos = -157626380, events = 43, fd = 0, user_data = 0xf6799938}, {pos = -135180300, events = 4135217304, fd = 1449692359, user_data = 0xf679f798}, {pos = 2090263927, events = 4149862816, fd = 23, user_data = 0xffef3950}, {pos = -1099580, events = 4091878480, fd = 2056, user_data = 0xf6827619}, {pos = 8, events = 4137342912, fd = -157626380, user_data = 0x811}, {pos = 0, events = 0, fd = 1, user_data = 0x5746502e }, {pos = -157626380, events = 2090263927, fd = -135177176, user_data = 0xffef3950}, {pos = -1099436, events = 4159614670, fd = 1449506128, user_data = 0xffef3954}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 7115467, user_data = 0x1400}, {pos = -135180300, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 12, fd = 63248, user_data = 0xf686f6cc }, {pos = 12, events = 0, fd = -1099232, user_data = 0xf681f692 }, {pos = -1, events = 4135188376, fd = -145104480, user_data = 0x1010}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 1475010548, events = 0, fd = 1449692359, user_data = 0x57eae234 }, {pos = -135177648, events = 4159641547, fd = 0, user_data = 0xf6811c6d}, {pos = -1099332, events = 4159790120, fd = -203088608, user_data = 0x1}, {pos = 0, events = 4137335636, fd = -157633664, user_data = 0xffef39bc}, {pos = 0, events = 1128, fd = -135180300, user_data = 0xf6810380}, {pos = 0, events = 0, fd = 0, user_data = 0x6e38200}, {pos = -159778920, events = 4136039616, fd = -157626380, user_data = 0x6e38200}, {pos = -157626380, events = 63248, fd = 12, user_data = 0xf67c9380 }, {pos = 2, events = 4293868064, fd = 0, user_data = 0x57eadff4}, {pos = 0, events = 4135359334, fd = 1475010548, user_data = 0x56fd8c7e }, {pos = 2, events = 4293868064, fd = 0, user_data = 0x57467f3c }, {pos = 4194304, events = 0, fd = 1234137018, user_data = 0x188993}, {pos = 1731639508, events = 0, fd = 74, user_data = 0x0}, {pos = -157626380, events = 4293868204, fd = 1497097716, user_data = 0xf68691cc <__clock_gettime64+60>}, {pos = 0, events = 4293868204, fd = 1475010548, user_data = 0x57420a03 }, {pos = 1497050096, events = 0, fd = 1475010548, user_data = 0x574246c4 }, {pos = -1099016, events = 1497097760, fd = 1496912696, user_data = 0x85d6bd}, {pos = 0, events = 4293868204, fd = 1496912832, user_data = 0x57eadff4}, {pos = 12, events = 1497095796, fd = 1497095776, user_data = 0x56fdb7e0 }, {pos = 13, events = 0, fd = 12, user_data = 0x57eadff4}, {pos = 0, events = 12, fd = 12, user_data = 0x56fd8e58 }, {pos = 237, events = 1479069440, fd = 1459470121, user_data = 0x56fdd08a }, {pos = 1497095776, events = 12, fd = 0, user_data = 0x0}, {pos = 12, events = 1476981392, fd = 1496906832, user_data = 0x5808f290 }} [03:03:00.094] nevents = 1 [03:03:00.094] __func__ = "ServerLoop" [03:03:00.094] #47 0x56fe1da2 in PostmasterMain (argc=8, argv=0x59368200) at ../src/backend/postmaster/postmaster.c:1361 [03:03:00.094] opt = [03:03:00.094] status = [03:03:00.094] userDoption = [03:03:00.094] listen_addr_saved = false [03:03:00.094] output_config_variable = [03:03:00.094] __func__ = "PostmasterMain" [03:03:00.094] #48 0x56e0b9f2 in main (argc=8, argv=0x59368200) at ../src/backend/main/main.c:196 [03:03:00.094] do_check_root = [03:03:00.115] -e [03:03:00.115] [03:03:00.115] [03:03:00.181] dumping /tmp/cores/postgres-6-68251.core for /tmp/cirrus-ci-build/build-32/tmp_install//usr/local/pgsql/bin/postgres [03:03:00.422] [New LWP 68251] [03:03:00.422] [03:03:00.422] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:00.422] [03:03:00.422] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:00.422] Debuginfod has been disabled. [03:03:00.422] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:00.540] [Thread debugging using libthread_db enabled] [03:03:00.540] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:00.540] Core was generated by `postgres: postgres regression [local] SELECT '. [03:03:00.540] Program terminated with signal SIGABRT, Aborted. [03:03:00.540] #0 0xf7edf559 in __kernel_vsyscall () [03:03:00.959] [03:03:00.959] Thread 1 (Thread 0xf3d84240 (LWP 68251)): [03:03:00.959] #0 0xf7edf559 in __kernel_vsyscall () [03:03:00.959] No symbol table info available. [03:03:00.959] #1 0xf681a407 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.959] No symbol table info available. [03:03:00.959] #2 0xf67c9111 in raise () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.959] No symbol table info available. [03:03:00.959] #3 0xf67b226a in abort () from /lib/i386-linux-gnu/libc.so.6 [03:03:00.959] No symbol table info available. [03:03:00.959] #4 0xf69d5d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:03:00.959] No locals. [03:03:00.959] #5 0xf69e4896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:03:00.959] No locals. [03:03:00.959] #6 0xf69c258c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [03:03:00.959] bp = 4293863416 [03:03:00.959] pc = [03:03:00.959] Opts = {FromUnrecoverableHandler = 208, pc = 4293863832, bp = 4137428320} [03:03:00.959] #7 0x57007c2f in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [03:03:00.959] __func__ = "pg_check_regex_collation" [03:03:00.959] #8 0x57007fba in pg_regcomp (re=0xffef2990, string=0x594a7ec4, len=5, flags=19, collation=100) at ../src/backend/regex/regcomp.c:453 [03:03:00.959] var = {re = 0xffef2990, now = 0x594a7ecc, stop = 0x594a7ed8, err = 0, cflags = 19, lasttype = 110, nexttype = 115, nextvalue = 5, lexcon = 1, nsubexp = 0, subs = 0xffef2864, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x5947ebe0, cm = 0x5947ea08, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1475010548, cv = 0x5946b880, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [03:03:00.959] v = 0xffef2834 [03:03:00.959] g = 0x5947e9c0 [03:03:00.959] i = [03:03:00.959] j = [03:03:00.959] debug = 0x0 [03:03:00.959] #9 0x5730e5d7 in RE_compile_and_cache (text_re=0x59480098, cflags=19, collation=100) at ../src/backend/utils/adt/regexp.c:209 [03:03:00.959] text_re_len = 5 [03:03:00.959] text_re_val = 0x5948009c "\\d+kB~`````` " [03:03:00.959] pattern = 0x594a7ec4 [03:03:00.959] pattern_len = 5 [03:03:00.959] i = [03:03:00.959] regcomp_result = [03:03:00.959] re_temp = {cre_context = 0x5947e930, cre_pat = 0xffef2b00 "d", cre_pat_len = 468, cre_flags = 1475010548, cre_collation = 1475010548, cre_re = {re_magic = 65239, re_nsub = 1024, re_info = 1152, re_csize = 4, re_endp = 0x57ead500 "\362qMW\220\231MW\345mMW\327rMW\361mMWԭMW\001", re_collation = 100, re_guts = 0x5947e9c0 '`' , re_fns = 0x57e98dc0 "\204\337\376V\207\206\376V"}} [03:03:00.959] errMsg = "\364\337\352W\220MFW\003\000\000\000\020\000\000\000\364\337\352W,~JY|\000\000\000\200\000\000\000\364\337\352WJOFW\003\000\000\000pfJY\000\000\000\000\276NFW\000\004\000\000\a\000\000\000\000fJY\000fJY\004\000\000\000pfJY\000\000\000\000/aFW\200\000\000\000\004\000\000\000\000fJY" [03:03:00.959] oldcontext = 0x594a6600 [03:03:00.959] __func__ = "RE_compile_and_cache" [03:03:00.959] #10 0x573c43c0 in replace_text_regexp (src_text=0x594a918c, pattern_text=0x59480098, replace_text=0x594800e0, cflags=19, collation=100, search_start=0, n=0) at ../src/backend/utils/adt/varlena.c:4255 [03:03:00.959] ret_text = [03:03:00.959] re = [03:03:00.959] src_text_len = 30 [03:03:00.959] nmatches = 0 [03:03:00.959] buf = {data = 0x594a7a2c "", len = 0, maxlen = 1024, cursor = 0} [03:03:00.959] pmatch = {{rm_so = 2285, rm_eo = 0}, {rm_so = -1103060, rm_eo = 1498008912}, {rm_so = 1497891104, rm_eo = 3}, {rm_so = 1475010548, rm_eo = 4}, {rm_so = 188, rm_eo = 1460959077}, {rm_so = 1479115164, rm_eo = 1456395224}, {rm_so = 1475010548, rm_eo = 1498008780}, {rm_so = 1497890760, rm_eo = 1456403651}, {rm_so = 1498008772, rm_eo = -1103060}, {rm_so = 1498008772, rm_eo = 1456400355}} [03:03:00.959] nmatch = 1 [03:03:00.959] data = 0x594a7e38 [03:03:00.959] data_len = 30 [03:03:00.959] data_pos = [03:03:00.959] start_ptr = [03:03:00.959] escape_status = 0 [03:03:00.959] __func__ = "replace_text_regexp" [03:03:00.959] #11 0x5731033b in textregexreplace (fcinfo=0x5949cd7c) at ../src/backend/utils/adt/regexp.c:687 [03:03:00.959] s = 0x594a918c [03:03:00.959] p = 0x59480098 [03:03:00.959] r = 0x594800e0 [03:03:00.959] opt = [03:03:00.959] flags = {cflags = 3, glob = true} [03:03:00.959] __func__ = "textregexreplace" [03:03:00.959] #12 0x56d0f20a in ExecInterpExpr (state=0x5949ccc4, econtext=0x5949c73c, isnull=0xffef2c8f) at ../src/backend/executor/execExprInterp.c:770 [03:03:00.959] fcinfo = 0x5949cd7c [03:03:00.959] args = 0x5949cd90 [03:03:00.959] nargs = 4 [03:03:00.959] d = [03:03:00.959] op = 0x5949cdec [03:03:00.959] resultslot = 0x0 [03:03:00.959] innerslot = 0x0 [03:03:00.959] outerslot = 0x0 [03:03:00.959] scanslot = 0x0 [03:03:00.959] dispatch_table = {0x56d0d20f , 0x56d0d262 , 0x56d0d364 , 0x56d0d466 , 0x56d0d568 , 0x56d0d7b9 , 0x56d0da0a , 0x56d0dc5b , 0x56d0dcb3 , 0x56d0dd0b , 0x56d0dd63 , 0x56d0ddba , 0x56d0e17d , 0x56d0e540 , 0x56d0e903 , 0x56d0eb45 , 0x56d0ee36 , 0x56d0ef4d , 0x56d0f0c3 , 0x56d0f2b0 , 0x56d0f307 , 0x56d0f35e , 0x56d0f38e , 0x56d0f57a , 0x56d0f706 , 0x56d0f736 , 0x56d0f922 , 0x56d0faae , 0x56d0fb5c , 0x56d0fd09 , 0x56d0fd9b , 0x56d0fec9 , 0x56d0fff7 , 0x56d10173 , 0x56d102a4 , 0x56d103d5 , 0x56d1042c , 0x56d10483 , 0x56d1059b , 0x56d106f4 , 0x56d1084d , 0x56d10965 , 0x56d109bc , 0x56d10a13 , 0x56d10aa5 , 0x56d10afc , 0x56d10eec , 0x56d11079 , 0x56d11564 , 0x56d115b7 , 0x56d1180e , 0x56d11a55 , 0x56d11cec , 0x56d11d3f , 0x56d11d92 , 0x56d11de5 , 0x56d11e38 , 0x56d11e8f , 0x56d11ee2 , 0x56d122eb , 0x56d1250f , 0x56d12562 , 0x56d125b9 , 0x56d12610 , 0x56d12667 , 0x56d1276c , 0x56d127b1 , 0x56d1276c , 0x56d10cf4 , 0x56d128fb , 0x56d1294e , 0x56d129a1 , 0x56d12a79 , 0x56d12bfb , 0x56d12e07 , 0x56d12f88 , 0x56d127fd , 0x56d12851 , 0x56d128a4 , 0x56d131b8 , 0x56d1320b , 0x56d13262 , 0x56d132b5 , 0x56d13321 , 0x56d13378 , 0x56d133cb , 0x56d1359d , 0x56d135f0 , 0x56d13825 , 0x56d1387c , 0x56d138d3 , 0x56d139c2 , 0x56d13c20 , 0x56d13da6 , 0x56d13f25 , 0x56d140e1 , 0x56d14551 , 0x56d14981 , 0x56d14d86 , 0x56d152a7 , 0x56d1577d , 0x56d15c26 , 0x56d15d5d , 0x56d15e93 , 0x56d15eea , 0x56d15f41 } [03:03:00.959] #13 0x56d027f2 in ExecInterpExprStillValid (state=0x5949ccc4, econtext=0x5949c73c, isNull=0xffef2c8f) at ../src/backend/executor/execExprInterp.c:2035 [03:03:00.959] No locals. [03:03:00.959] #14 0xeaf16c6c in ExecEvalExpr (isNull=0xffef2c8f, econtext=0x5949c73c, state=) at ../src/include/executor/executor.h:348 [03:03:00.959] No locals. [03:03:00.959] #15 exec_eval_simple_expr (estate=estate@entry=0xffef2ef8, expr=expr@entry=0x594c2548, result=result@entry=0xffef2c4c, isNull=0xffef2c8f, rettype=0xffef2c88, rettypmod=0xffef2c84) at ../src/pl/plpgsql/src/pl_exec.c:6222 [03:03:00.959] econtext = 0x5949c73c [03:03:00.959] curlxid = [03:03:00.959] paramLI = 0x594a9134 [03:03:00.959] save_setup_arg = 0x0 [03:03:00.959] need_snapshot = [03:03:00.959] oldcontext = 0x594a8610 [03:03:00.959] #16 0xeaf1f335 in exec_eval_expr (estate=estate@entry=0xffef2ef8, expr=expr@entry=0x594c2548, isNull=isNull@entry=0xffef2c8f, rettype=0xffef2c88, rettypmod=0xffef2c84) at ../src/pl/plpgsql/src/pl_exec.c:5703 [03:03:00.959] result = 0 [03:03:00.959] rc = [03:03:00.959] attr = [03:03:00.959] __func__ = "exec_eval_expr" [03:03:00.959] #17 0xeaf21702 in exec_assign_expr (estate=0xffef2ef8, target=0x594a86d4, expr=0x594c2548) at ../src/pl/plpgsql/src/pl_exec.c:5035 [03:03:00.959] value = [03:03:00.959] isnull = 86 [03:03:00.959] valtype = 25 [03:03:00.959] valtypmod = -1 [03:03:00.959] #18 0xeaf21913 in exec_stmt_assign (estate=estate@entry=0xffef2ef8, stmt=stmt@entry=0x594c24b0) at ../src/pl/plpgsql/src/pl_exec.c:2152 [03:03:00.959] No locals. [03:03:00.959] #19 0xeaf25e63 in exec_stmts (estate=estate@entry=0xffef2ef8, stmts=0x594c2620) at ../src/pl/plpgsql/src/pl_exec.c:2016 [03:03:00.959] stmt = 0x594c24b0 [03:03:00.959] rc = [03:03:00.959] s__state = [03:03:00.959] save_estmt = 0x594c23f4 [03:03:00.959] s = [03:03:00.959] __func__ = "exec_stmts" [03:03:00.959] #20 0xeaf2a357 in exec_for_query (estate=estate@entry=0xffef2ef8, stmt=stmt@entry=0x594c23f4, portal=portal@entry=0x593eea0c, prefetch_ok=) at ../src/pl/plpgsql/src/pl_exec.c:5969 [03:03:00.959] i = 0 [03:03:00.959] var = 0x594c2420 [03:03:00.959] tuptab = 0x594ca790 [03:03:00.959] found = true [03:03:00.959] rc = [03:03:00.959] previous_id = 1 [03:03:00.959] tupdescs_match = true [03:03:00.959] n = 9 [03:03:00.959] #21 0xeaf2ad35 in exec_stmt_dynfors (estate=estate@entry=0xffef2ef8, stmt=stmt@entry=0x594c23f4) at ../src/pl/plpgsql/src/pl_exec.c:4645 [03:03:00.959] portal = 0x593eea0c [03:03:00.959] rc = [03:03:00.959] #22 0xeaf25ff3 in exec_stmts (estate=estate@entry=0xffef2ef8, stmts=0x59492580) at ../src/pl/plpgsql/src/pl_exec.c:2096 [03:03:00.959] stmt = 0x594c23f4 [03:03:00.959] rc = [03:03:00.959] s__state = [03:03:00.959] save_estmt = 0x594925ac [03:03:00.959] s = [03:03:00.959] __func__ = "exec_stmts" [03:03:00.959] #23 0xeaf26d29 in exec_stmt_block (estate=estate@entry=0xffef2ef8, block=block@entry=0x594925ac) at ../src/pl/plpgsql/src/pl_exec.c:1939 [03:03:00.959] rc = -1 [03:03:00.959] i = [03:03:00.959] __func__ = "exec_stmt_block" [03:03:00.959] #24 0xeaf26e7a in exec_toplevel_block (estate=estate@entry=0xffef2ef8, block=0x594925ac) at ../src/pl/plpgsql/src/pl_exec.c:1630 [03:03:00.959] rc = [03:03:00.959] #25 0xeaf275f1 in plpgsql_exec_function (func=0x593ca650, fcinfo=0x593c1238, simple_eval_estate=0x0, simple_eval_resowner=0x0, procedure_resowner=0x0, atomic=true) at ../src/pl/plpgsql/src/pl_exec.c:619 [03:03:00.959] estate = {func = 0x593ca650, trigdata = 0x0, evtrigdata = 0x0, retval = 0, retisnull = true, rettype = 0, fn_rettype = 25, retistuple = false, retisset = true, readonly_func = false, atomic = true, exitlabel = 0x0, cur_error = 0x0, tuple_store = 0x0, tuple_store_desc = 0x0, tuple_store_cxt = 0x593c0360, tuple_store_owner = 0x593c9004, rsi = 0xffef30c4, found_varno = 2, ndatums = 5, datums = 0x594a9160, datum_context = 0x594a8610, paramLI = 0x594a9134, simple_eval_estate = 0x5949c630, simple_eval_resowner = 0x593caa5c, procedure_resowner = 0x0, cast_hash = 0x5949a620, stmt_mcontext = 0x5949e5b0, stmt_mcontext_parent = 0x594a8610, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x5949c73c, err_stmt = 0x594c24b0, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [03:03:00.959] plerrcontext = {previous = 0x0, callback = 0xeaf23ff5 , arg = 0xffef2ef8} [03:03:00.959] i = 1 [03:03:00.959] rc = [03:03:00.959] __func__ = "plpgsql_exec_function" [03:03:00.959] #26 0xeaf31296 in plpgsql_call_handler (fcinfo=0x593c1238) at ../src/pl/plpgsql/src/pl_handler.c:276 [03:03:00.959] _save_exception_stack = 0xffef3344 [03:03:00.959] _save_context_stack = 0x0 [03:03:00.959] _local_sigjmp_buf = {{__jmpbuf = {-353013772, -353013772, 1497107752, 1479122608, 833857623, 164138109}, __mask_was_saved = 0, __saved_mask = {__val = {1456481771, 1497107828, 1497108004, 0, 1456481639, 1475010548, 0, 1497106200, 0, 1497141252, 3942121020, 1474946644, 1456471545, 1497107828, 1497105820, 1475010548, 1456482290, 1497107828, 1497105820, 1497109072, 1461228737, 1497109048, 1497109004, 0, 1456702197, 1497107828, 1497105820, 1497109072, 1456701954, 1497106324, 0, 1497105820}}}} [03:03:00.959] _do_rethrow = false [03:03:00.959] nonatomic = false [03:03:00.959] func = 0x593ca650 [03:03:00.959] save_cur_estate = 0x0 [03:03:00.959] procedure_resowner = 0x0 [03:03:00.959] retval = 0 [03:03:00.959] rc = [03:03:00.959] __func__ = "plpgsql_call_handler" [03:03:00.959] #27 0x56d3a7d9 in ExecMakeFunctionResultSet (fcache=0x593c0d28, econtext=0x593c059c, argContext=0x594a25e0, isNull=0x593c0ce4, isDone=0x593c0d14) at ../src/backend/executor/execSRF.c:624 [03:03:00.959] arguments = [03:03:00.959] result = [03:03:00.959] fcinfo = 0x593c1238 [03:03:00.959] fcusage = {fs = 0x0, save_f_total_time = {ticks = 6258584370490826740}, save_total = {ticks = 6430038129234429109}, start = {ticks = 20178203033206835}} [03:03:00.959] rsinfo = {type = T_ReturnSetInfo, econtext = 0x593c059c, expectedDesc = 0x593c1510, allowedModes = 3, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [03:03:00.959] callit = [03:03:00.959] i = [03:03:00.959] __func__ = "ExecMakeFunctionResultSet" [03:03:00.959] #28 0x56dadce1 in ExecProjectSRF (node=node@entry=0x593c0510, continuing=continuing@entry=false) at ../src/backend/executor/nodeProjectSet.c:182 [03:03:00.959] elem = [03:03:00.959] isdone = 0x593c0d14 [03:03:00.959] result = 0x593c0ce0 [03:03:00.959] isnull = [03:03:00.959] resultSlot = 0x593c0cb4 [03:03:00.959] econtext = 0x593c059c [03:03:00.959] oldcontext = 0x593c0360 [03:03:00.959] hassrf = false [03:03:00.959] hasresult = false [03:03:00.959] argno = 0 [03:03:00.959] #29 0x56dadf7d in ExecProjectSet (pstate=0x593c0510) at ../src/backend/executor/nodeProjectSet.c:106 [03:03:00.959] node = 0x593c0510 [03:03:00.959] outerTupleSlot = [03:03:00.959] resultSlot = [03:03:00.959] outerPlan = [03:03:00.959] econtext = 0x593c059c [03:03:00.959] #30 0x56d33ded in ExecProcNodeFirst (node=0x593c0510) at ../src/backend/executor/execProcnode.c:469 [03:03:00.959] No locals. [03:03:00.959] #31 0x56d1dda0 in ExecProcNode (node=node@entry=0x593c0510) at ../src/include/executor/executor.h:278 [03:03:00.959] No locals. [03:03:00.959] #32 0x56d1dfa5 in ExecutePlan (estate=estate@entry=0x593c03f0, planstate=0x593c0510, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x59484cc0, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:03:00.959] slot = [03:03:00.959] current_tuple_count = 0 [03:03:00.959] #33 0x56d1ff24 in standard_ExecutorRun (queryDesc=0x593b6d70, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:362 [03:03:00.959] estate = 0x593c03f0 [03:03:00.959] operation = CMD_SELECT [03:03:00.959] dest = 0x59484cc0 [03:03:00.959] sendTuples = [03:03:00.959] oldcontext = 0x593b6ce0 [03:03:00.959] __func__ = "standard_ExecutorRun" [03:03:00.959] #34 0x56d201f6 in ExecutorRun (queryDesc=0x593b6d70, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:303 [03:03:00.959] No locals. [03:03:00.959] #35 0x5714de6d in PortalRunSelect (portal=portal@entry=0x593ee900, forward=forward@entry=true, count=0, count@entry=2147483647, dest=0x59484cc0) at ../src/backend/tcop/pquery.c:924 [03:03:00.959] queryDesc = 0x593b6d70 [03:03:00.959] direction = [03:03:00.959] nprocessed = [03:03:00.959] __func__ = "PortalRunSelect" [03:03:00.959] #36 0x571516b5 in PortalRun (portal=0x593ee900, count=2147483647, isTopLevel=true, run_once=true, dest=0x59484cc0, altdest=0x59484cc0, qc=0xffef3454) at ../src/backend/tcop/pquery.c:768 [03:03:00.959] _save_exception_stack = 0xffef34d4 [03:03:00.959] _save_context_stack = 0x0 [03:03:00.959] _local_sigjmp_buf = {{__jmpbuf = {1475010548, 1, 1497295104, 1496907824, 831178839, -976569082}, __mask_was_saved = 0, __saved_mask = {__val = {8, 0, 1475010548, 60, 1467259538, 1475010548, 1475010548, 1475010548, 0, 60, 468, 1464321947, 1496904544, 60, 0, 1464321766, 1497066720, 2, 0, 1475010548, 2, 1497295104, 1496907824, 1452864536, 60, 2, 1496907824, 1460995070, 1497430608, 1475010548, 1496907796, 1460940937}}}} [03:03:00.959] _do_rethrow = [03:03:00.959] result = [03:03:00.959] nprocessed = [03:03:00.959] saveTopTransactionResourceOwner = 0x593c81c0 [03:03:00.959] saveTopTransactionContext = 0x5940f9c0 [03:03:00.959] saveActivePortal = 0x0 [03:03:00.959] saveResourceOwner = 0x593c81c0 [03:03:00.959] savePortalContext = 0x0 [03:03:00.959] saveMemoryContext = 0x5940f9c0 [03:03:00.959] __func__ = "PortalRun" [03:03:00.959] #37 0x5714a1fa in exec_simple_query (query_string=query_string@entry=0x5938f3f0 "select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 55');") at ../src/backend/tcop/postgres.c:1283 [03:03:00.959] cmdtaglen = 6 [03:03:00.959] snapshot_set = [03:03:00.959] per_parsetree_context = 0x0 [03:03:00.959] plantree_list = 0x59484c94 [03:03:00.959] parsetree = 0x59390014 [03:03:00.959] commandTag = [03:03:00.959] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:03:00.959] querytree_list = [03:03:00.959] portal = 0x593ee900 [03:03:00.959] receiver = [03:03:00.959] format = 0 [03:03:00.959] cmdtagname = [03:03:00.959] parsetree_item__state = [03:03:00.959] dest = DestRemote [03:03:00.959] oldcontext = 0x5940f9c0 [03:03:00.959] parsetree_list = 0x59390030 [03:03:00.959] parsetree_item = 0x59390040 [03:03:00.959] save_log_statement_stats = false [03:03:00.959] was_logged = false [03:03:00.959] use_implicit_block = false [03:03:00.959] msec_str = "\360\3638Ym\000\000\000Q\000\000\000\352T\340V\3004\357\377\376\377\377?\362\2706g\337V\340V" [03:03:00.959] __func__ = "exec_simple_query" [03:03:00.959] #38 0x5714d154 in PostgresMain (dbname=0x593c658c "regression", username=0x593c6570 "postgres") at ../src/backend/tcop/postgres.c:4798 [03:03:00.959] query_string = 0x5938f3f0 "select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 55');" [03:03:00.959] firstchar = [03:03:00.959] input_message = {data = 0x5938f3f0 "select explain_analyze_without_memory('select * from (select * from t order by a) s order by a, b limit 55');", len = 110, maxlen = 1024, cursor = 110} [03:03:00.959] local_sigjmp_buf = {{__jmpbuf = {1475010548, 1479122604, 1479122608, 1, 830859351, -966547194}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1496744640, 1464229724, 1, 1504, 1475010548, 84, 1475011312, 198, 1475010548, 1475010548, 256, 468, 1496744640, 1464321573, 1496744640, 9760, 0, 1464321397, 1475010548, 1479117248, 1479122608, 1460689358, 9760, 4135717722, 1475010548, 1459390766, 3943477928, 1, 4135271253, 1475010548}}}} [03:03:00.959] send_ready_for_query = false [03:03:00.959] idle_in_transaction_timeout_enabled = false [03:03:00.959] idle_session_timeout_enabled = false [03:03:00.959] __func__ = "PostgresMain" [03:03:00.959] #39 0x5714285e in BackendMain (startup_data=0xffef361c "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [03:03:00.959] bsdata = 0xffef361c [03:03:00.959] #40 0x56fd9038 in postmaster_child_launch (child_type=, child_slot=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:274 [03:03:00.959] pid = [03:03:00.959] #41 0x56fde493 in BackendStartup (client_sock=client_sock@entry=0xffef3668) at ../src/backend/postmaster/postmaster.c:3377 [03:03:00.959] bn = 0x593bc618 [03:03:00.959] pid = [03:03:00.959] startup_data = {canAcceptConnections = CAC_OK} [03:03:00.959] cac = [03:03:00.959] __func__ = "BackendStartup" [03:03:00.959] #42 0x56fe04d6 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:03:00.959] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\rW\b\000\000\000LA\330\363\200\004 [03:03:00.959] last_lockfile_recheck_time = 1731639508 [03:03:00.959] last_touch_time = 1731639508 [03:03:00.959] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 345062850, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 945068287, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x1b}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 4112, user_data = 0xf682862c}, {pos = 1497054240, events = 96, fd = 4096, user_data = 0xf6828c42}, {pos = -157626380, events = 4137342968, fd = 8224, user_data = 0x1000}, {pos = 1497054232, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x6b}, {pos = 0, events = 0, fd = 0, user_data = 0xf69ad7c0}, {pos = 4096, events = 4137340916, fd = -216, user_data = 0xf6829a4f }, {pos = 1496784928, events = 4137340916, fd = -1099528, user_data = 0xf6899b4c <__fstat64_time64+44>}, {pos = 8, events = 4136918313, fd = -1099792, user_data = 0xf69acff4}, {pos = -159313865, events = 4137340916, fd = 1496784928, user_data = 0xf6802b22 <_IO_file_doallocate+178>}, {pos = 1496784928, events = 1497054240, fd = 1497058336, user_data = 0x1}, {pos = 2049, events = 0, fd = 427844, user_data = 0x0}, {pos = 33152, events = 4159611716, fd = -159715110, user_data = 0x566bb6bd}, {pos = 0, events = 0, fd = 2640, user_data = 0x0}, {pos = 4096, events = 4159786996, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 4149862816, fd = -159803080, user_data = 0xf6797cf8}, {pos = 2090263927, events = 4159612681, fd = 1, user_data = 0x1}, {pos = -159778920, events = 1510, fd = -159749992, user_data = 0xf759e1a0}, {pos = -1099580, events = 4293867712, fd = 2048, user_data = 0xf6828c42}, {pos = -157626380, events = 43, fd = 0, user_data = 0xf6799938}, {pos = -135180300, events = 4135217304, fd = 1449692359, user_data = 0xf679f798}, {pos = 2090263927, events = 4149862816, fd = 23, user_data = 0xffef3950}, {pos = -1099580, events = 4091878480, fd = 2056, user_data = 0xf6827619}, {pos = 8, events = 4137342912, fd = -157626380, user_data = 0x811}, {pos = 0, events = 0, fd = 1, user_data = 0x5746502e }, {pos = -157626380, events = 2090263927, fd = -135177176, user_data = 0xffef3950}, {pos = -1099436, events = 4159614670, fd = 1449506128, user_data = 0xffef3954}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 7115467, user_data = 0x1400}, {pos = -135180300, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 12, fd = 63248, user_data = 0xf686f6cc }, {pos = 12, events = 0, fd = -1099232, user_data = 0xf681f692 }, {pos = -1, events = 4135188376, fd = -145104480, user_data = 0x1010}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 1475010548, events = 0, fd = 1449692359, user_data = 0x57eae234 }, {pos = -135177648, events = 4159641547, fd = 0, user_data = 0xf6811c6d}, {pos = -1099332, events = 4159790120, fd = -203088608, user_data = 0x1}, {pos = 0, events = 4137335636, fd = -157633664, user_data = 0xffef39bc}, {pos = 0, events = 1128, fd = -135180300, user_data = 0xf6810380}, {pos = 0, events = 0, fd = 0, user_data = 0x6e38200}, {pos = -159778920, events = 4136039616, fd = -157626380, user_data = 0x6e38200}, {pos = -157626380, events = 63248, fd = 12, user_data = 0xf67c9380 }, {pos = 2, events = 4293868064, fd = 0, user_data = 0x57eadff4}, {pos = 0, events = 4135359334, fd = 1475010548, user_data = 0x56fd8c7e }, {pos = 2, events = 4293868064, fd = 0, user_data = 0x57467f3c }, {pos = 4194304, events = 0, fd = 1234137018, user_data = 0x188993}, {pos = 1731639508, events = 0, fd = 74, user_data = 0x0}, {pos = -157626380, events = 4293868204, fd = 1497097716, user_data = 0xf68691cc <__clock_gettime64+60>}, {pos = 0, events = 4293868204, fd = 1475010548, user_data = 0x57420a03 }, {pos = 1497050096, events = 0, fd = 1475010548, user_data = 0x574246c4 }, {pos = -1099016, events = 1497097760, fd = 1496912696, user_data = 0x85d6bd}, {pos = 0, events = 4293868204, fd = 1496912832, user_data = 0x57eadff4}, {pos = 12, events = 1497095796, fd = 1497095776, user_data = 0x56fdb7e0 }, {pos = 13, events = 0, fd = 12, user_data = 0x57eadff4}, {pos = 0, events = 12, fd = 12, user_data = 0x56fd8e58 }, {pos = 237, events = 1479069440, fd = 1459470121, user_data = 0x56fdd08a }, {pos = 1497095776, events = 12, fd = 0, user_data = 0x0}, {pos = 12, events = 1476981392, fd = 1496906832, user_data = 0x5808f290 }} [03:03:00.960] nevents = 1 [03:03:00.960] __func__ = "ServerLoop" [03:03:00.960] #43 0x56fe1da2 in PostmasterMain (argc=8, argv=0x59368200) at ../src/backend/postmaster/postmaster.c:1361 [03:03:00.960] opt = [03:03:00.960] status = [03:03:00.960] userDoption = [03:03:00.960] listen_addr_saved = false [03:03:00.960] output_config_variable = [03:03:00.960] __func__ = "PostmasterMain" [03:03:00.960] #44 0x56e0b9f2 in main (argc=8, argv=0x59368200) at ../src/backend/main/main.c:196 [03:03:00.960] do_check_root = [03:03:00.986] -e [03:03:00.986] [03:03:00.986] [03:03:01.049] dumping /tmp/cores/sh-3-44773.core for /bin/sh [03:03:01.096] [03:03:01.096] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:01.096] [03:03:01.096] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:01.096] Debuginfod has been disabled. [03:03:01.096] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:01.100] [New LWP 44773] [03:03:01.102] [New LWP 44768] [03:03:01.102] [Thread debugging using libthread_db enabled] [03:03:01.102] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:01.102] Core was generated by `sh -c cp "pg_wal/000000010000000000000003.00000028.backup" "/tmp/cirrus-ci-buil'. [03:03:01.102] Program terminated with signal SIGQUIT, Quit. [03:03:01.102] #0 0x00007f6c936eeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] [Current thread is 1 (LWP 44773)] [03:03:01.103] [03:03:01.103] Thread 2 (Thread 0x7f6c9365c740 (LWP 44768)): [03:03:01.103] warning: Couldn't find general-purpose registers in core file. [03:03:01.103] #0 in ?? () [03:03:01.103] PC unavailable, cannot determine locals. [03:03:01.103] Backtrace stopped: not enough registers or memory available to unwind further [03:03:01.103] [03:03:01.103] Thread 1 (LWP 44773): [03:03:01.103] #0 0x00007f6c936eeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] No symbol table info available. [03:03:01.103] #1 0x00007f6c9369b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] No symbol table info available. [03:03:01.103] #2 0x00007f6c9369b497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] No symbol table info available. [03:03:01.103] #3 0x0000562a4a49f5f3 in ?? () [03:03:01.103] No symbol table info available. [03:03:01.103] #4 0x0000562a4a499369 in ?? () [03:03:01.103] No symbol table info available. [03:03:01.103] #5 0x0000562a4a49820f in ?? () [03:03:01.103] No symbol table info available. [03:03:01.103] #6 0x0000562a4a498c3b in ?? () [03:03:01.103] No symbol table info available. [03:03:01.103] #7 0x0000562a4a49666f in ?? () [03:03:01.103] No symbol table info available. [03:03:01.103] #8 0x00007f6c9368624a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] No symbol table info available. [03:03:01.103] #9 0x00007f6c93686305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:01.103] No symbol table info available. [03:03:01.103] #10 0x0000562a4a496781 in ?? () [03:03:01.103] No symbol table info available. [03:03:01.112] -e [03:03:01.112] [03:03:01.112] [03:03:01.177] dumping /tmp/cores/postgres-6-70914.core for /tmp/cirrus-ci-build/build-32/tmp_install/usr/local/pgsql/bin/postgres [03:03:01.422] [New LWP 70914] [03:03:01.422] [03:03:01.422] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:01.422] [03:03:01.422] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:01.422] Debuginfod has been disabled. [03:03:01.422] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:01.536] [Thread debugging using libthread_db enabled] [03:03:01.536] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:01.536] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [03:03:01.536] Program terminated with signal SIGABRT, Aborted. [03:03:01.536] #0 0xf7f06559 in __kernel_vsyscall () [03:03:01.630] [03:03:01.630] Thread 1 (Thread 0xf3dab240 (LWP 70914)): [03:03:01.630] #0 0xf7f06559 in __kernel_vsyscall () [03:03:01.630] No symbol table info available. [03:03:01.630] #1 0xf6841407 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:01.630] No symbol table info available. [03:03:01.630] #2 0xf67f0111 in raise () from /lib/i386-linux-gnu/libc.so.6 [03:03:01.630] No symbol table info available. [03:03:01.630] #3 0xf67d926a in abort () from /lib/i386-linux-gnu/libc.so.6 [03:03:01.630] No symbol table info available. [03:03:01.630] #4 0xf69fcd4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:03:01.630] No locals. [03:03:01.630] #5 0xf6a0b896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:03:01.630] No locals. [03:03:01.630] #6 0xf69e958c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [03:03:01.630] bp = 4293503704 [03:03:01.630] pc = [03:03:01.630] Opts = {FromUnrecoverableHandler = 208, pc = 4293504120, bp = 4137588064} [03:03:01.630] #7 0x56f3ac2f in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [03:03:01.630] __func__ = "pg_check_regex_collation" [03:03:01.630] #8 0x56f3afba in pg_regcomp (re=0xffe9ac70, string=0x59859c1c, len=37, flags=3, collation=100) at ../src/backend/regex/regcomp.c:453 [03:03:01.630] var = {re = 0xffe9ac70, now = 0x59859c30, stop = 0x59859cb0, err = 0, cflags = 3, lasttype = 110, nexttype = 94, nextvalue = 152, lexcon = 1, nsubexp = 0, subs = 0xffe9ab44, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x5983c890, cm = 0x5983c6b8, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1474170868, cv = 0x5985bb70, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [03:03:01.630] v = 0xffe9ab14 [03:03:01.630] g = 0x5983c670 [03:03:01.630] i = [03:03:01.630] j = [03:03:01.630] debug = 0x0 [03:03:01.630] #9 0x572415d7 in RE_compile_and_cache (text_re=0x59859bd0, cflags=3, collation=100) at ../src/backend/utils/adt/regexp.c:209 [03:03:01.630] text_re_len = 37 [03:03:01.630] text_re_val = 0x59859bd4 "***S^(?:a){1,1}?((?:b.d)){1,1}(?:.*)$", '\330' , "ؘ" [03:03:01.630] pattern = 0x59859c1c [03:03:01.630] pattern_len = 37 [03:03:01.630] i = [03:03:01.630] regcomp_result = [03:03:01.630] re_temp = {cre_context = 0x5983c5e0, cre_pat = 0x59859b40 "\324\001", cre_pat_len = 64, cre_flags = 0, cre_collation = 1463481717, cre_re = {re_magic = 65239, re_nsub = 1501108028, re_info = 100000, re_csize = 4, re_endp = 0x40 , re_collation = 100, re_guts = 0x5983c670 '\177' , re_fns = 0x57dcbdc0 "\204\017\362V\207\266\361V"}} [03:03:01.630] errMsg = "\364\017\336W\276~9W0{\205Y@\002\000\000\274\254\351\377@\233\205Y\003\000\000\000\260\233\205Y\000\000\000\000/\2219W@\000\000\000\003\000\000\000@\233\205Y\225\2169W\364\017\336W\274\177\205Y\364\017\336W<\000\000\000\354~\205Y\274\254\351\377\354~\205Y\364\017\336W\000\000\000\000\324\001\000\000\230\027yY" [03:03:01.630] oldcontext = 0x59859b40 [03:03:01.630] __func__ = "RE_compile_and_cache" [03:03:01.630] #10 0x57242f3e in textregexsubstr (fcinfo=0x59857fa0) at ../src/backend/utils/adt/regexp.c:593 [03:03:01.630] s = 0x5979174c [03:03:01.630] p = [03:03:01.630] re = [03:03:01.630] pmatch = {{rm_so = 1501922340, rm_eo = 1501108116}, {rm_so = 1474170868, rm_eo = 1461991413}} [03:03:01.630] so = [03:03:01.630] eo = [03:03:01.630] #11 0x56c4220a in ExecInterpExpr (state=0x59857eec, econtext=0x59857d6c, isnull=0xffe9adbf) at ../src/backend/executor/execExprInterp.c:770 [03:03:01.630] fcinfo = 0x59857fa0 [03:03:01.630] args = 0x59857fb4 [03:03:01.630] nargs = 2 [03:03:01.630] d = [03:03:01.630] op = 0x5985807c [03:03:01.630] resultslot = 0x59857e70 [03:03:01.630] innerslot = 0x0 [03:03:01.630] outerslot = 0x0 [03:03:01.630] scanslot = 0x0 [03:03:01.630] dispatch_table = {0x56c4020f , 0x56c40262 , 0x56c40364 , 0x56c40466 , 0x56c40568 , 0x56c407b9 , 0x56c40a0a , 0x56c40c5b , 0x56c40cb3 , 0x56c40d0b , 0x56c40d63 , 0x56c40dba , 0x56c4117d , 0x56c41540 , 0x56c41903 , 0x56c41b45 , 0x56c41e36 , 0x56c41f4d , 0x56c420c3 , 0x56c422b0 , 0x56c42307 , 0x56c4235e , 0x56c4238e , 0x56c4257a , 0x56c42706 , 0x56c42736 , 0x56c42922 , 0x56c42aae , 0x56c42b5c , 0x56c42d09 , 0x56c42d9b , 0x56c42ec9 , 0x56c42ff7 , 0x56c43173 , 0x56c432a4 , 0x56c433d5 , 0x56c4342c , 0x56c43483 , 0x56c4359b , 0x56c436f4 , 0x56c4384d , 0x56c43965 , 0x56c439bc , 0x56c43a13 , 0x56c43aa5 , 0x56c43afc , 0x56c43eec , 0x56c44079 , 0x56c44564 , 0x56c445b7 , 0x56c4480e , 0x56c44a55 , 0x56c44cec , 0x56c44d3f , 0x56c44d92 , 0x56c44de5 , 0x56c44e38 , 0x56c44e8f , 0x56c44ee2 , 0x56c452eb , 0x56c4550f , 0x56c45562 , 0x56c455b9 , 0x56c45610 , 0x56c45667 , 0x56c4576c , 0x56c457b1 , 0x56c4576c , 0x56c43cf4 , 0x56c458fb , 0x56c4594e , 0x56c459a1 , 0x56c45a79 , 0x56c45bfb , 0x56c45e07 , 0x56c45f88 , 0x56c457fd , 0x56c45851 , 0x56c458a4 , 0x56c461b8 , 0x56c4620b , 0x56c46262 , 0x56c462b5 , 0x56c46321 , 0x56c46378 , 0x56c463cb , 0x56c4659d , 0x56c465f0 , 0x56c46825 , 0x56c4687c , 0x56c468d3 , 0x56c469c2 , 0x56c46c20 , 0x56c46da6 , 0x56c46f25 , 0x56c470e1 , 0x56c47551 , 0x56c47981 , 0x56c47d86 , 0x56c482a7 , 0x56c4877d , 0x56c48c26 , 0x56c48d5d , 0x56c48e93 , 0x56c48eea , 0x56c48f41 } [03:03:01.630] #12 0x56c357f2 in ExecInterpExprStillValid (state=0x59857eec, econtext=0x59857d6c, isNull=0xffe9adbf) at ../src/backend/executor/execExprInterp.c:2035 [03:03:01.630] No locals. [03:03:01.630] #13 0x56ce24f5 in ExecEvalExprSwitchContext (state=0x59857eec, econtext=, isNull=) at ../src/include/executor/executor.h:367 [03:03:01.630] retDatum = [03:03:01.630] oldContext = 0x59857b30 [03:03:01.630] #14 0x56ce25f0 in ExecProject (projInfo=0x59857ee8) at ../src/include/executor/executor.h:401 [03:03:01.630] econtext = 0x59857d6c [03:03:01.630] state = 0x59857eec [03:03:01.630] slot = 0x59857e70 [03:03:01.630] isnull = 87 [03:03:01.630] #15 0x56ce2a11 in ExecResult (pstate=0x59857ce0) at ../src/backend/executor/nodeResult.c:135 [03:03:01.630] node = 0x59857ce0 [03:03:01.630] outerTupleSlot = [03:03:01.630] outerPlan = [03:03:01.630] econtext = 0x59857d6c [03:03:01.630] #16 0x56c66ded in ExecProcNodeFirst (node=0x59857ce0) at ../src/backend/executor/execProcnode.c:469 [03:03:01.630] No locals. [03:03:01.630] #17 0x56c50da0 in ExecProcNode (node=node@entry=0x59857ce0) at ../src/include/executor/executor.h:278 [03:03:01.630] No locals. [03:03:01.630] #18 0x56c50fa5 in ExecutePlan (estate=estate@entry=0x59857bc0, planstate=0x59857ce0, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=1, direction=ForwardScanDirection, dest=0x5984fddc, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:03:01.630] slot = [03:03:01.630] current_tuple_count = 0 [03:03:01.630] #19 0x56c52f24 in standard_ExecutorRun (queryDesc=0x5984fe08, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:362 [03:03:01.630] estate = 0x59857bc0 [03:03:01.630] operation = CMD_SELECT [03:03:01.630] dest = 0x5984fddc [03:03:01.630] sendTuples = [03:03:01.630] oldcontext = 0x5984dad0 [03:03:01.630] __func__ = "standard_ExecutorRun" [03:03:01.630] #20 0xf3d948eb in pgss_ExecutorRun (queryDesc=0x5984fe08, direction=ForwardScanDirection, count=1, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1033 [03:03:01.630] _save_exception_stack = 0xffe9b784 [03:03:01.630] _save_context_stack = 0xffe9b064 [03:03:01.630] _local_sigjmp_buf = {{__jmpbuf = {-203796492, 1474170868, 1, 1, 391331308, 1990075892}, __mask_was_saved = 0, __saved_mask = {__val = {1501331960, 1501598508, 1474110308, 1474170868, 1501920740, 1, 1501887232, 1463643197, 32, 1501888008, 1501886604, 1, 1478283092, 1501598560, 1474170868, 1474170868, 1501920192, 1501888008, 32, 1455769549, 1474170868, 1474170868, 1501598508, 1501878992, 1477600944, 1501598560, 1474110308, 4091170804, 1501888008, 0, 1501879136, 4091107655}}}} [03:03:01.630] _do_rethrow = false [03:03:01.630] #21 0x56c531d5 in ExecutorRun (queryDesc=0x5984fe08, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:301 [03:03:01.630] No locals. [03:03:01.630] #22 0x56c7df85 in postquel_getnext (es=es@entry=0x5984faa8, fcache=fcache@entry=0x5984db60) at ../src/backend/executor/functions.c:897 [03:03:01.630] count = 1 [03:03:01.630] result = [03:03:01.630] #23 0x56c80ef6 in fmgr_sql (fcinfo=0x59835544) at ../src/backend/executor/functions.c:1198 [03:03:01.630] completed = [03:03:01.630] fcache = 0x5984db60 [03:03:01.630] sqlerrcontext = {previous = 0x0, callback = 0x56c7bf31 , arg = 0x59835518} [03:03:01.630] oldcontext = 0x59847ab0 [03:03:01.630] randomAccess = [03:03:01.630] lazyEvalOK = [03:03:01.630] is_first = [03:03:01.630] pushed_snapshot = false [03:03:01.630] es = 0x5984faa8 [03:03:01.630] slot = [03:03:01.630] result = [03:03:01.630] eslist = 0x5984fb8c [03:03:01.630] eslc = [03:03:01.630] __func__ = "fmgr_sql" [03:03:01.630] #24 0x56c4220a in ExecInterpExpr (state=0x5983548c, econtext=0x5983599c, isnull=0xffe9b13f) at ../src/backend/executor/execExprInterp.c:770 [03:03:01.630] fcinfo = 0x59835544 [03:03:01.630] args = 0x59835558 [03:03:01.630] nargs = 3 [03:03:01.630] d = [03:03:01.630] op = 0x59835590 [03:03:01.630] resultslot = 0x0 [03:03:01.630] innerslot = 0x0 [03:03:01.630] outerslot = 0x0 [03:03:01.630] scanslot = 0x0 [03:03:01.630] dispatch_table = {0x56c4020f , 0x56c40262 , 0x56c40364 , 0x56c40466 , 0x56c40568 , 0x56c407b9 , 0x56c40a0a , 0x56c40c5b , 0x56c40cb3 , 0x56c40d0b , 0x56c40d63 , 0x56c40dba , 0x56c4117d , 0x56c41540 , 0x56c41903 , 0x56c41b45 , 0x56c41e36 , 0x56c41f4d , 0x56c420c3 , 0x56c422b0 , 0x56c42307 , 0x56c4235e , 0x56c4238e , 0x56c4257a , 0x56c42706 , 0x56c42736 , 0x56c42922 , 0x56c42aae , 0x56c42b5c , 0x56c42d09 , 0x56c42d9b , 0x56c42ec9 , 0x56c42ff7 , 0x56c43173 , 0x56c432a4 , 0x56c433d5 , 0x56c4342c , 0x56c43483 , 0x56c4359b , 0x56c436f4 , 0x56c4384d , 0x56c43965 , 0x56c439bc , 0x56c43a13 , 0x56c43aa5 , 0x56c43afc , 0x56c43eec , 0x56c44079 , 0x56c44564 , 0x56c445b7 , 0x56c4480e , 0x56c44a55 , 0x56c44cec , 0x56c44d3f , 0x56c44d92 , 0x56c44de5 , 0x56c44e38 , 0x56c44e8f , 0x56c44ee2 , 0x56c452eb , 0x56c4550f , 0x56c45562 , 0x56c455b9 , 0x56c45610 , 0x56c45667 , 0x56c4576c , 0x56c457b1 , 0x56c4576c , 0x56c43cf4 , 0x56c458fb , 0x56c4594e , 0x56c459a1 , 0x56c45a79 , 0x56c45bfb , 0x56c45e07 , 0x56c45f88 , 0x56c457fd , 0x56c45851 , 0x56c458a4 , 0x56c461b8 , 0x56c4620b , 0x56c46262 , 0x56c462b5 , 0x56c46321 , 0x56c46378 , 0x56c463cb , 0x56c4659d , 0x56c465f0 , 0x56c46825 , 0x56c4687c , 0x56c468d3 , 0x56c469c2 , 0x56c46c20 , 0x56c46da6 , 0x56c46f25 , 0x56c470e1 , 0x56c47551 , 0x56c47981 , 0x56c47d86 , 0x56c482a7 , 0x56c4877d , 0x56c48c26 , 0x56c48d5d , 0x56c48e93 , 0x56c48eea , 0x56c48f41 } [03:03:01.630] #25 0x56c357f2 in ExecInterpExprStillValid (state=0x5983548c, econtext=0x5983599c, isNull=0xffe9b13f) at ../src/backend/executor/execExprInterp.c:2035 [03:03:01.630] No locals. [03:03:01.630] #26 0x56e2457d in ExecEvalExprSwitchContext (isNull=0xffe9b13f, econtext=, state=0x5983548c) at ../src/include/executor/executor.h:367 [03:03:01.630] retDatum = [03:03:01.630] oldContext = 0x598352f0 [03:03:01.630] retDatum = [03:03:01.630] oldContext = [03:03:01.630] #27 evaluate_expr (expr=0x5983cdc0, result_type=25, result_typmod=-1, result_collation=100) at ../src/backend/optimizer/util/clauses.c:5009 [03:03:01.630] estate = 0x59835380 [03:03:01.630] exprstate = 0x5983548c [03:03:01.630] oldcontext = 0x59790390 [03:03:01.630] const_val = [03:03:01.630] const_is_null = 87 [03:03:01.630] resultTypLen = -2330 [03:03:01.630] resultTypByVal = false [03:03:01.630] #28 0x56e24adc in evaluate_function (funcid=funcid@entry=2074, result_type=result_type@entry=25, result_typmod=result_typmod@entry=-1, result_collid=100, input_collid=100, args=0x5983cd3c, funcvariadic=false, func_tuple=0xf23373f0, context=0xffe9b43c) at ../src/backend/optimizer/util/clauses.c:4515 [03:03:01.630] funcform = [03:03:01.630] has_nonconst_input = false [03:03:01.630] has_null_input = false [03:03:01.630] arg = 0x0 [03:03:01.630] newexpr = [03:03:01.630] #29 0x56e2a0f3 in simplify_function (funcid=funcid@entry=2074, result_type=25, result_typmod=-1, result_collid=100, input_collid=100, args_p=0xffe9b294, funcvariadic=false, process_args=true, allow_non_const=true, context=0xffe9b43c) at ../src/backend/optimizer/util/clauses.c:4104 [03:03:01.630] args = 0x5983cd3c [03:03:01.630] func_tuple = 0xf23373f0 [03:03:01.630] func_form = 0xf2337428 [03:03:01.630] newexpr = [03:03:01.630] __func__ = "simplify_function" [03:03:01.630] #30 0x56e254c6 in eval_const_expressions_mutator (node=0x597916a0, context=0xffe9b43c) at ../src/backend/optimizer/util/clauses.c:2591 [03:03:01.630] expr = 0x597916a0 [03:03:01.630] args = 0x5983cd3c [03:03:01.630] simple = [03:03:01.630] newexpr = [03:03:01.630] __func__ = "eval_const_expressions_mutator" [03:03:01.630] #31 0x56d53f67 in expression_tree_mutator_impl (node=0x597917dc, mutator=0x56e24c3f , context=0xffe9b43c) at ../src/backend/nodes/nodeFuncs.c:3463 [03:03:01.630] targetentry = 0x597917dc [03:03:01.630] newnode = 0x5983cce4 [03:03:01.630] __func__ = "expression_tree_mutator_impl" [03:03:01.630] #32 0x56e24cec in eval_const_expressions_mutator (node=0x597917dc, context=0xffe9b43c) at ../src/backend/optimizer/util/clauses.c:3723 [03:03:01.630] __func__ = "eval_const_expressions_mutator" [03:03:01.630] #33 0x56d54767 in expression_tree_mutator_impl (node=0x59791808, mutator=0x56e24c3f , context=0xffe9b43c) at ../src/backend/nodes/nodeFuncs.c:3548 [03:03:01.630] temp__state = [03:03:01.630] resultlist = 0x0 [03:03:01.630] temp = [03:03:01.630] __func__ = "expression_tree_mutator_impl" [03:03:01.630] #34 0x56e24cec in eval_const_expressions_mutator (node=0x59791808, context=0xffe9b43c) at ../src/backend/optimizer/util/clauses.c:3723 [03:03:01.630] __func__ = "eval_const_expressions_mutator" [03:03:01.630] #35 0x56e28adc in eval_const_expressions (root=0x5983ca10, node=0x59791808) at ../src/backend/optimizer/util/clauses.c:2266 [03:03:01.630] context = {boundParams = 0x0, root = 0x5983ca10, active_fns = 0x0, case_val = 0x0, estimate = false} [03:03:01.630] #36 0x56ddce82 in preprocess_expression (root=root@entry=0x5983ca10, expr=, kind=kind@entry=1) at ../src/backend/optimizer/plan/planner.c:1223 [03:03:01.630] No locals. [03:03:01.630] #37 0x56dee4b8 in subquery_planner (glob=, parse=, parent_root=, hasRecursion=, tuple_fraction=, setops=) at ../src/backend/optimizer/plan/planner.c:843 [03:03:01.630] root = [03:03:01.630] newWithCheckOptions = [03:03:01.630] newHaving = [03:03:01.630] hasOuterJoins = false [03:03:01.630] hasResultRTEs = true [03:03:01.630] final_rel = [03:03:01.630] l = 0x0 [03:03:01.630] #38 0x56df028e in standard_planner (parse=0x597911a4, query_string=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:417 [03:03:01.630] result = [03:03:01.630] glob = 0x5979218c [03:03:01.630] tuple_fraction = 0 [03:03:01.630] root = [03:03:01.630] final_rel = [03:03:01.630] best_path = [03:03:01.630] top_plan = [03:03:01.630] lp = [03:03:01.630] lr = [03:03:01.630] #39 0xf3d99f54 in pgss_planner (parse=0x597911a4, query_string=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:973 [03:03:01.630] _save_exception_stack = 0xffe9b984 [03:03:01.630] _save_context_stack = 0x0 [03:03:01.630] _local_sigjmp_buf = {{__jmpbuf = {-203796492, -203796492, 1501110852, 0, 392461804, 2000213492}, __mask_was_saved = 0, __saved_mask = {__val = {1501102992, 32, 0, 1463481717, 1474170868, 1, 1, 1456745714, 32, 0, 1474170868, 1456745699, 0, 50, 7934092, 1456744686, 1474170868, 0, 1501110852, 1456748643, 1501106328, 1474170868, 1501110808, 1459358908, 0, 1501106596, 1501106596, 1459358853, 3879816193, 3800423748, 1474170868, 0}}}} [03:03:01.630] _do_rethrow = false [03:03:01.630] result = 0x0 [03:03:01.630] #40 0x56df14a5 in planner (parse=0x597911a4, query_string=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:282 [03:03:01.630] result = [03:03:01.630] #41 0x5707c737 in pg_plan_query (querytree=0x597911a4, query_string=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:911 [03:03:01.630] plan = [03:03:01.630] #42 0x5707cb10 in pg_plan_queries (querytrees=0x59792244, query_string=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:1005 [03:03:01.630] query = 0x597911a4 [03:03:01.630] stmt = [03:03:01.630] query_list__state = [03:03:01.630] stmt_list = 0x0 [03:03:01.630] query_list = [03:03:01.630] #43 0x5707d0da in exec_simple_query (query_string=query_string@entry=0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";") at ../src/backend/tcop/postgres.c:1202 [03:03:01.630] cmdtaglen = 6 [03:03:01.630] snapshot_set = true [03:03:01.630] per_parsetree_context = 0x0 [03:03:01.630] plantree_list = [03:03:01.630] parsetree = 0x59791050 [03:03:01.630] commandTag = CMDTAG_SELECT [03:03:01.630] qc = {commandTag = 4293507440, nprocessed = 6256491050674556916} [03:03:01.630] querytree_list = [03:03:01.630] portal = [03:03:01.630] receiver = [03:03:01.630] format = 22327 [03:03:01.630] cmdtagname = [03:03:01.630] parsetree_item__state = [03:03:01.630] dest = DestRemote [03:03:01.630] oldcontext = 0x59809280 [03:03:01.630] parsetree_list = 0x5979106c [03:03:01.630] parsetree_item = 0x5979107c [03:03:01.630] save_log_statement_stats = false [03:03:01.630] was_logged = true [03:03:01.630] use_implicit_block = false [03:03:01.630] msec_str = " \004yYF\000\000\000Q\000\000\000\352\204\323Vp\271\351\377\376\377\377?\000\2716g߆\323V" [03:03:01.630] __func__ = "exec_simple_query" [03:03:01.630] #44 0x57080154 in PostgresMain (dbname=0x597c674c "regression", username=0x597c6730 "postgres") at ../src/backend/tcop/postgres.c:4798 [03:03:01.630] query_string = 0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";" [03:03:01.630] firstchar = [03:03:01.630] input_message = {data = 0x59790420 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", len = 71, maxlen = 1024, cursor = 71} [03:03:01.630] local_sigjmp_buf = {{__jmpbuf = {1474170868, 1478282924, 1478282928, 1, 394026476, -874398531}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1500943152, 1463389845, 1, 1504, 1474170868, 84, 1474171632, 198, 1474170868, 1474170868, 0, 468, 1500943152, 1463481893, 1500943152, 3760, 0, 1463481717, 1474170868, 1478277568, 1478282928, 1459849678, 3760, 4135877466, 1474170868, 1458551086, 4064774952, 1, 4135430997, 1474170868}}}} [03:03:01.630] send_ready_for_query = false [03:03:01.630] idle_in_transaction_timeout_enabled = false [03:03:01.630] idle_session_timeout_enabled = false [03:03:01.630] __func__ = "PostgresMain" [03:03:01.630] #45 0x5707585e in BackendMain (startup_data=0xffe9bacc "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [03:03:01.630] bsdata = 0xffe9bacc [03:03:01.630] #46 0x56f0c038 in postmaster_child_launch (child_type=, child_slot=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:274 [03:03:01.630] pid = [03:03:01.630] #47 0x56f11493 in BackendStartup (client_sock=client_sock@entry=0xffe9bb18) at ../src/backend/postmaster/postmaster.c:3377 [03:03:01.630] bn = 0x59791194 [03:03:01.630] pid = [03:03:01.630] startup_data = {canAcceptConnections = CAC_OK} [03:03:01.630] cac = [03:03:01.630] __func__ = "BackendStartup" [03:03:01.630] #48 0x56f134d6 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:03:01.630] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\000W\a\000\000\000L\261\332\363\200\325{Y\244h\000W\364\017\336W\200\325{Y\360#yY\271z\000W\364\017\336W\307\325{Yt#yY\377\027\000\000\000\020\000\000\000\000\000\000\000\000\000\000\001\000\000\000\352\003\000\000\353\003\000\000\200\201\000\000Ķ\006\000\000\000\000\000P\n\000\000\000\000\000\000\b\000\000\000\000\000\000\000t80\000\000\000\000\000Ը6g\000\000\000\000\302=\221\024", __ss_align = 0}, salen = 2}} [03:03:01.630] i = 0 [03:03:01.630] now = [03:03:01.630] last_lockfile_recheck_time = 1731639547 [03:03:01.630] last_touch_time = 1731639547 [03:03:01.630] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 761101318, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 945068287, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x1b}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 4112, user_data = 0xf684f62c}, {pos = 1501289872, events = 216, fd = 4096, user_data = 0xf684fc42}, {pos = -157466636, events = 4137502712, fd = 6176, user_data = 0x1000}, {pos = 1501289864, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x62}, {pos = 0, events = 0, fd = 0, user_data = 0xf69d47c0}, {pos = 4096, events = 4137500660, fd = -216, user_data = 0xf6850a4f }, {pos = 1500983376, events = 4137500660, fd = -1458776, user_data = 0xf68c0b4c <__fstat64_time64+44>}, {pos = 7, events = 4137078057, fd = -1459040, user_data = 0xf69d3ff4}, {pos = -159154121, events = 4137500660, fd = 1500983376, user_data = 0xf6829b22 <_IO_file_doallocate+178>}, {pos = 1500983376, events = 1501289872, fd = 1501293968, user_data = 0x1}, {pos = 2049, events = 0, fd = 440004, user_data = 0x0}, {pos = 33152, events = 4159771460, fd = -159555366, user_data = 0x565ee6bd}, {pos = 0, events = 0, fd = 2640, user_data = 0x0}, {pos = 4096, events = 4159946740, fd = 0, user_data = 0x6736b8d4}, {pos = 0, events = 4150022560, fd = -159643336, user_data = 0xf67becf8}, {pos = 2090263927, events = 4159772425, fd = 1, user_data = 0x1}, {pos = -159619176, events = 1510, fd = -159590248, user_data = 0xf75c51a0}, {pos = -1458828, events = 4293508464, fd = 2048, user_data = 0xf69d3ff4}, {pos = -157466636, events = 44, fd = 0, user_data = 0xf67c0938}, {pos = -135020556, events = 4135377048, fd = 1448852679, user_data = 0xf67c6798}, {pos = 2090263927, events = 4150022560, fd = 23, user_data = 0xffe9be00}, {pos = -1458828, events = 1501266496, fd = 1501261112, user_data = 0xf684e619}, {pos = 7, events = 4137502656, fd = -157466636, user_data = 0x811}, {pos = 0, events = 0, fd = 1, user_data = 0x5739802e }, {pos = -157466636, events = 2090263927, fd = -135017432, user_data = 0xffe9be00}, {pos = -1458684, events = 4159774414, fd = 1448666448, user_data = 0xffe9be04}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 6275787, user_data = 0x1400}, {pos = -135020556, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 12, fd = 70247, user_data = 0xf68966cc }, {pos = 12, events = 0, fd = -1458480, user_data = 0xf6846692 }, {pos = -1, events = 4135348120, fd = -144944736, user_data = 0x1011}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 1474170868, events = 0, fd = 1448852679, user_data = 0x57de1234 }, {pos = -135017904, events = 4159801291, fd = 0, user_data = 0xf6838c6d}, {pos = -1458580, events = 4159949864, fd = -202928864, user_data = 0x1}, {pos = 0, events = 4137495380, fd = -157473920, user_data = 0xffe9be6c}, {pos = 0, events = 1128, fd = -135020556, user_data = 0xf6837380}, {pos = 0, events = 0, fd = 0, user_data = 0xd5719600}, {pos = -159619176, events = 4136199360, fd = -157466636, user_data = 0xd5719600}, {pos = -157466636, events = 70247, fd = 12, user_data = 0xf67f0380 }, {pos = 2, events = 4293508816, fd = 0, user_data = 0x57de0ff4}, {pos = 0, events = 4135519078, fd = 1474170868, user_data = 0x56f0bc7e }, {pos = 2, events = 4293508816, fd = 0, user_data = 0x5739af3c }, {pos = 4194304, events = 0, fd = 330357762, user_data = 0x379933}, {pos = 1731639547, events = 0, fd = 74, user_data = 0x0}, {pos = -157466636, events = 4293508956, fd = 1501255328, user_data = 0xf68901cc <__clock_gettime64+60>}, {pos = 0, events = 4293508956, fd = 1474170868, user_data = 0x57353a03 }, {pos = 1501248768, events = 0, fd = 1474170868, user_data = 0x573576c4 }, {pos = -1458264, events = 1501105832, fd = 1501111156, user_data = 0x8846bd}, {pos = 0, events = 4293508956, fd = 1501111280, user_data = 0x57de0ff4}, {pos = 12, events = 1501108812, fd = 1501108792, user_data = 0x56f0e7e0 }, {pos = 13, events = 0, fd = 12, user_data = 0x57de0ff4}, {pos = 0, events = 12, fd = 12, user_data = 0x56f0be58 }, {pos = 87, events = 1478229760, fd = 1458630441, user_data = 0x56f1008a }, {pos = 1501108792, events = 12, fd = 0, user_data = 0x0}, {pos = 12, events = 1476141712, fd = 1501105252, user_data = 0x57fc2290 }} [03:03:01.630] nevents = 1 [03:03:01.630] __func__ = "ServerLoop" [03:03:01.630] #49 0x56f14da2 in PostmasterMain (argc=4, argv=0x59769220) at ../src/backend/postmaster/postmaster.c:1361 [03:03:01.630] opt = [03:03:01.630] status = [03:03:01.630] userDoption = [03:03:01.630] listen_addr_saved = false [03:03:01.630] output_config_variable = [03:03:01.630] __func__ = "PostmasterMain" [03:03:01.630] #50 0x56d3e9f2 in main (argc=4, argv=0x59769220) at ../src/backend/main/main.c:196 [03:03:01.630] do_check_root = [03:03:01.651] -e [03:03:01.651] [03:03:01.651] [03:03:01.718] dumping /tmp/cores/postgres-3-70097.core for /tmp/cirrus-ci-build/build-32/tmp_install/usr/local/pgsql/bin/postgres [03:03:01.966] [New LWP 70097] [03:03:01.966] [03:03:01.966] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:01.966] [03:03:01.966] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:01.966] Debuginfod has been disabled. [03:03:01.966] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:02.078] [New LWP 68682] [03:03:02.078] [Thread debugging using libthread_db enabled] [03:03:02.078] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:02.078] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005 '. [03:03:02.078] Program terminated with signal SIGQUIT, Quit. [03:03:02.078] #0 0xf7fbd559 in __kernel_vsyscall () [03:03:02.083] [Current thread is 1 (LWP 70097)] [03:03:02.085] [03:03:02.085] Thread 2 (Thread 0xf3e62240 (LWP 68682)): [03:03:02.085] warning: Couldn't find general-purpose registers in core file. [03:03:02.085] #0 in ?? () [03:03:02.085] PC unavailable, cannot determine locals. [03:03:02.085] Backtrace stopped: not enough registers or memory available to unwind further [03:03:02.085] [03:03:02.085] Thread 1 (LWP 70097): [03:03:02.085] #0 0xf7fbd559 in __kernel_vsyscall () [03:03:02.085] No symbol table info available. [03:03:02.085] #1 0xf68fd692 in pthread_sigmask () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.085] No symbol table info available. [03:03:02.085] #2 0xf68a7380 in sigprocmask () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.085] No symbol table info available. [03:03:02.085] #3 0xf6974085 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.085] No symbol table info available. [03:03:02.085] #4 0xf69917a8 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.085] No symbol table info available. [03:03:02.105] -e [03:03:02.105] [03:03:02.105] [03:03:02.168] dumping /tmp/cores/sh-3-83720.core for /bin/sh [03:03:02.218] [03:03:02.218] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:02.218] [03:03:02.218] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:02.218] Debuginfod has been disabled. [03:03:02.218] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:02.223] [New LWP 83720] [03:03:02.224] [Thread debugging using libthread_db enabled] [03:03:02.224] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:02.224] Core was generated by `sh -c cp "pg_wal/000000010000000000000003" "/tmp/cirrus-ci-build/build-32/testr'. [03:03:02.224] Program terminated with signal SIGQUIT, Quit. [03:03:02.224] #0 0x00007f55fc613b93 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.225] [03:03:02.225] Thread 1 (Thread 0x7f55fc53d740 (LWP 83720)): [03:03:02.225] #0 0x00007f55fc613b93 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.225] No symbol table info available. [03:03:02.225] #1 0x00005597c1b5ecc0 in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #2 0x00005597c1b5eefa in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #3 0x00005597c1b60630 in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #4 0x00005597c1b5a371 in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #5 0x00005597c1b5920f in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #6 0x00005597c1b59c3b in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #7 0x00005597c1b5766f in ?? () [03:03:02.225] No symbol table info available. [03:03:02.225] #8 0x00007f55fc56724a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.225] No symbol table info available. [03:03:02.225] #9 0x00007f55fc567305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.225] No symbol table info available. [03:03:02.225] #10 0x00005597c1b57781 in ?? () [03:03:02.225] No symbol table info available. [03:03:02.233] -e [03:03:02.233] [03:03:02.233] [03:03:02.296] dumping /tmp/cores/cp-3-83722.core for /usr/bin/cp [03:03:02.344] [03:03:02.344] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:02.344] [03:03:02.344] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:02.344] Debuginfod has been disabled. [03:03:02.344] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:02.347] [New LWP 83722] [03:03:02.353] [Thread debugging using libthread_db enabled] [03:03:02.353] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:02.353] Core was generated by `cp pg_wal/000000010000000000000003 /tmp/cirrus-ci-build/build-32/testrun/pg_com'. [03:03:02.353] Program terminated with signal SIGQUIT, Quit. [03:03:02.353] #0 0x00007fef513bc7b3 in copy_file_range () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.354] [03:03:02.354] Thread 1 (Thread 0x7fef51225580 (LWP 83722)): [03:03:02.354] #0 0x00007fef513bc7b3 in copy_file_range () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.354] No symbol table info available. [03:03:02.354] #1 0x0000557730a18291 in ?? () [03:03:02.354] No symbol table info available. [03:03:02.354] #2 0x0000557730a1c671 in ?? () [03:03:02.354] No symbol table info available. [03:03:02.354] #3 0x0000557730a1d577 in ?? () [03:03:02.354] No symbol table info available. [03:03:02.354] #4 0x0000557730a175bc in ?? () [03:03:02.354] No symbol table info available. [03:03:02.354] #5 0x0000557730a15eda in ?? () [03:03:02.354] No symbol table info available. [03:03:02.354] #6 0x00007fef512e724a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.354] No symbol table info available. [03:03:02.354] #7 0x00007fef512e7305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [03:03:02.354] No symbol table info available. [03:03:02.354] #8 0x0000557730a16171 in ?? () [03:03:02.354] No symbol table info available. [03:03:02.362] -e [03:03:02.362] [03:03:02.362] [03:03:02.432] dumping /tmp/cores/postgres-6-76704.core for /tmp/cirrus-ci-build/build-32/tmp_install//usr/local/pgsql/bin/postgres [03:03:02.670] [New LWP 76704] [03:03:02.670] [03:03:02.670] This GDB supports auto-downloading debuginfo from the following URLs: [03:03:02.670] [03:03:02.670] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:03:02.670] Debuginfod has been disabled. [03:03:02.670] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:03:02.783] [Thread debugging using libthread_db enabled] [03:03:02.783] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:03:02.783] Core was generated by `postgres: postgres regression_citext [local] SELECT '. [03:03:02.783] Program terminated with signal SIGABRT, Aborted. [03:03:02.783] #0 0xf7ecf559 in __kernel_vsyscall () [03:03:02.855] [03:03:02.855] Thread 1 (Thread 0xf3d74240 (LWP 76704)): [03:03:02.855] #0 0xf7ecf559 in __kernel_vsyscall () [03:03:02.855] No symbol table info available. [03:03:02.855] #1 0xf680a407 in ?? () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.855] No symbol table info available. [03:03:02.855] #2 0xf67b9111 in raise () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.855] No symbol table info available. [03:03:02.855] #3 0xf67a226a in abort () from /lib/i386-linux-gnu/libc.so.6 [03:03:02.855] No symbol table info available. [03:03:02.855] #4 0xf69c5d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:03:02.855] No locals. [03:03:02.855] #5 0xf69d4896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:03:02.855] No locals. [03:03:02.855] #6 0xf69b258c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [03:03:02.855] bp = 4287365288 [03:03:02.855] pc = [03:03:02.855] Opts = {FromUnrecoverableHandler = 208, pc = 4287365704, bp = 4137362784} [03:03:02.855] #7 0x56f8ac2f in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [03:03:02.855] __func__ = "pg_check_regex_collation" [03:03:02.855] #8 0x56f8afba in pg_regcomp (re=0xff8c0240, string=0x5840f9b0, len=16, flags=27, collation=100) at ../src/backend/regex/regcomp.c:453 [03:03:02.855] var = {re = 0xff8c0240, now = 0x5840f9c4, stop = 0x5840f9f0, err = 0, cflags = 27, lasttype = 110, nexttype = 94, nextvalue = 68, lexcon = 1, nsubexp = 0, subs = 0xff8c0114, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x5842c9e0, cm = 0x5842c808, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1474498548, cv = 0x58432f20, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [03:03:02.855] v = 0xff8c00e4 [03:03:02.855] g = 0x5842c7c0 [03:03:02.855] i = [03:03:02.855] j = [03:03:02.855] debug = 0x0 [03:03:02.855] #9 0x572915d7 in RE_compile_and_cache (text_re=0x5842f998, cflags=27, collation=100) at ../src/backend/utils/adt/regexp.c:209 [03:03:02.855] text_re_len = 16 [03:03:02.855] text_re_val = 0x5842f99c "***S^(?:.*a\\.*)$~", '@' , " " [03:03:02.855] pattern = 0x5840f9b0 [03:03:02.855] pattern_len = 16 [03:03:02.855] i = [03:03:02.855] regcomp_result = [03:03:02.855] re_temp = {cre_context = 0x5842c730, cre_pat = 0x57e30ff4 "\230y\206\001PZ\360\367\3007\356\3676@\216VF@\216VV@\216Vf@\216Vv@\216V\206@\216V\226@\216V\246@\216V\266@\216V\306@\216V\326@\216V\346@\216V\340:\212\366\006A\216V\026A\216VP", , cre_pat_len = -4, cre_flags = 0, cre_collation = 1459886747, cre_re = {re_magic = 65239, re_nsub = 4294967292, re_info = 100000, re_csize = 4, re_endp = 0x0, re_collation = 100, re_guts = 0x5842c7c0 '@' , re_fns = 0x57e1bdc0 "\204\017\367V\207\266\366V"}} [03:03:02.855] errMsg = "\364\017\343WwA\233V\020\000\000\000\374\377\377\377\234\312@X\274\266\003W\204\312@Xx\306@X\000\000\000\000\266\332\003W\000\000\000\000$`\353\352\374\377\377\3773\033\004W\364\017\343W\000`\353\352$`\353\352\bo@W\374\377\377\377\000\000\000\000\364\017\343W\240[\232V\360\000\000\000\000\004\000\000\004\000\000" [03:03:02.855] oldcontext = 0x5840f920 [03:03:02.855] __func__ = "RE_compile_and_cache" [03:03:02.855] #10 0x57292431 in RE_compile_and_execute (text_re=0x5842f998, dat=0xeaeb7ffd "abb", dat_len=3, cflags=, collation=100, nmatch=0, pmatch=0x0) at ../src/backend/utils/adt/regexp.c:369 [03:03:02.855] re = [03:03:02.855] #11 0x57292bf8 in texticregexeq (fcinfo=0x5840c1d8) at ../src/backend/utils/adt/regexp.c:555 [03:03:02.855] s = [03:03:02.855] p = [03:03:02.855] #12 0x56c9220a in ExecInterpExpr (state=0x5840bd14, econtext=0x5840bb58, isnull=0xff8c037f) at ../src/backend/executor/execExprInterp.c:770 [03:03:02.855] fcinfo = 0x5840c1d8 [03:03:02.855] args = 0x5840c1ec [03:03:02.855] nargs = 2 [03:03:02.855] d = [03:03:02.855] op = 0x5840bde8 [03:03:02.855] resultslot = 0x0 [03:03:02.855] innerslot = 0x0 [03:03:02.855] outerslot = 0x0 [03:03:02.855] scanslot = 0x5840bbd0 [03:03:02.855] dispatch_table = {0x56c9020f , 0x56c90262 , 0x56c90364 , 0x56c90466 , 0x56c90568 , 0x56c907b9 , 0x56c90a0a , 0x56c90c5b , 0x56c90cb3 , 0x56c90d0b , 0x56c90d63 , 0x56c90dba , 0x56c9117d , 0x56c91540 , 0x56c91903 , 0x56c91b45 , 0x56c91e36 , 0x56c91f4d , 0x56c920c3 , 0x56c922b0 , 0x56c92307 , 0x56c9235e , 0x56c9238e , 0x56c9257a , 0x56c92706 , 0x56c92736 , 0x56c92922 , 0x56c92aae , 0x56c92b5c , 0x56c92d09 , 0x56c92d9b , 0x56c92ec9 , 0x56c92ff7 , 0x56c93173 , 0x56c932a4 , 0x56c933d5 , 0x56c9342c , 0x56c93483 , 0x56c9359b , 0x56c936f4 , 0x56c9384d , 0x56c93965 , 0x56c939bc , 0x56c93a13 , 0x56c93aa5 , 0x56c93afc , 0x56c93eec , 0x56c94079 , 0x56c94564 , 0x56c945b7 , 0x56c9480e , 0x56c94a55 , 0x56c94cec , 0x56c94d3f , 0x56c94d92 , 0x56c94de5 , 0x56c94e38 , 0x56c94e8f , 0x56c94ee2 , 0x56c952eb , 0x56c9550f , 0x56c95562 , 0x56c955b9 , 0x56c95610 , 0x56c95667 , 0x56c9576c , 0x56c957b1 , 0x56c9576c , 0x56c93cf4 , 0x56c958fb , 0x56c9594e , 0x56c959a1 , 0x56c95a79 , 0x56c95bfb , 0x56c95e07 , 0x56c95f88 , 0x56c957fd , 0x56c95851 , 0x56c958a4 , 0x56c961b8 , 0x56c9620b , 0x56c96262 , 0x56c962b5 , 0x56c96321 , 0x56c96378 , 0x56c963cb , 0x56c9659d , 0x56c965f0 , 0x56c96825 , 0x56c9687c , 0x56c968d3 , 0x56c969c2 , 0x56c96c20 , 0x56c96da6 , 0x56c96f25 , 0x56c970e1 , 0x56c97551 , 0x56c97981 , 0x56c97d86 , 0x56c982a7 , 0x56c9877d , 0x56c98c26 , 0x56c98d5d , 0x56c98e93 , 0x56c98eea , 0x56c98f41 } [03:03:02.855] #13 0x56c857f2 in ExecInterpExprStillValid (state=0x5840bd14, econtext=0x5840bb58, isNull=0xff8c037f) at ../src/backend/executor/execExprInterp.c:2035 [03:03:02.855] No locals. [03:03:02.855] #14 0x56cbde9b in ExecEvalExprSwitchContext (isNull=0xff8c037f, econtext=0x5840b900, state=0x5840bd14) at ../src/include/executor/executor.h:367 [03:03:02.855] retDatum = [03:03:02.855] oldContext = 0x5840b900 [03:03:02.855] retDatum = [03:03:02.855] oldContext = [03:03:02.855] #15 ExecQual (state=state@entry=0x5840bd14, econtext=econtext@entry=0x5840bb58) at ../src/include/executor/executor.h:436 [03:03:02.855] ret = [03:03:02.855] isnull = 87 [03:03:02.855] #16 0x56cbe995 in ExecScan (node=0x5840bacc, accessMtd=0x56d34929 , recheckMtd=0x56d34594 ) at ../src/backend/executor/execScan.c:225 [03:03:02.855] slot = 0x5840bbd0 [03:03:02.855] econtext = 0x5840bb58 [03:03:02.855] qual = 0x5840bd14 [03:03:02.855] projInfo = 0x0 [03:03:02.855] #17 0x56d346db in ExecSeqScan (pstate=0x5840bacc) at ../src/backend/executor/nodeSeqscan.c:112 [03:03:02.855] node = [03:03:02.855] #18 0x56cb6ded in ExecProcNodeFirst (node=0x5840bacc) at ../src/backend/executor/execProcnode.c:469 [03:03:02.855] No locals. [03:03:02.855] #19 0x56ca0da0 in ExecProcNode (node=node@entry=0x5840bacc) at ../src/include/executor/executor.h:278 [03:03:02.855] No locals. [03:03:02.855] #20 0x56ca0fa5 in ExecutePlan (estate=estate@entry=0x5840b990, planstate=0x5840bacc, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x584308fc, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:03:02.855] slot = [03:03:02.855] current_tuple_count = 0 [03:03:02.855] #21 0x56ca2f24 in standard_ExecutorRun (queryDesc=0x58407410, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:362 [03:03:02.855] estate = 0x5840b990 [03:03:02.855] operation = CMD_SELECT [03:03:02.855] dest = 0x584308fc [03:03:02.855] sendTuples = [03:03:02.855] oldcontext = 0x58407380 [03:03:02.855] __func__ = "standard_ExecutorRun" [03:03:02.855] #22 0x56ca31f6 in ExecutorRun (queryDesc=0x58407410, direction=ForwardScanDirection, count=0, execute_once=true) at ../src/backend/executor/execMain.c:303 [03:03:02.855] No locals. [03:03:02.855] #23 0x570d0e6d in PortalRunSelect (portal=portal@entry=0x583a58e0, forward=forward@entry=true, count=0, count@entry=2147483647, dest=0x584308fc) at ../src/backend/tcop/pquery.c:924 [03:03:02.855] queryDesc = 0x58407410 [03:03:02.855] direction = [03:03:02.855] nprocessed = [03:03:02.855] __func__ = "PortalRunSelect" [03:03:02.855] #24 0x570d46b5 in PortalRun (portal=0x583a58e0, count=2147483647, isTopLevel=true, run_once=true, dest=0x584308fc, altdest=0x584308fc, qc=0xff8c06a4) at ../src/backend/tcop/pquery.c:768 [03:03:02.855] _save_exception_stack = 0xff8c0724 [03:03:02.855] _save_context_stack = 0x0 [03:03:02.855] _local_sigjmp_buf = {{__jmpbuf = {1474498548, 1, 1480218848, 1479864600, 1838755951, 1863705918}, __mask_was_saved = 0, __saved_mask = {__val = {8, 0, 1474498548, 60, 1466747538, 1474498548, 1474498548, 1474498548, 0, 60, 468, 1463809947, 1479861088, 60, 0, 1463809766, 1480618880, 2, 0, 1474498548, 2, 1480218848, 1479864600, 1452352536, 60, 2, 1479864600, 1460483070, 1480354352, 1474498548, 1479864572, 1460428937}}}} [03:03:02.855] _do_rethrow = [03:03:02.855] result = [03:03:02.855] nprocessed = [03:03:02.855] saveTopTransactionResourceOwner = 0x583831e0 [03:03:02.855] saveTopTransactionContext = 0x583c69a0 [03:03:02.855] saveActivePortal = 0x0 [03:03:02.855] saveResourceOwner = 0x583831e0 [03:03:02.855] savePortalContext = 0x0 [03:03:02.855] saveMemoryContext = 0x583c69a0 [03:03:02.855] __func__ = "PortalRun" [03:03:02.855] #25 0x570cd1fa in exec_simple_query (query_string=query_string@entry=0x5834e3f0 "SELECT name FROM srt WHERE name SIMILAR TO '%a.*';") at ../src/backend/tcop/postgres.c:1283 [03:03:02.855] cmdtaglen = 6 [03:03:02.855] snapshot_set = [03:03:02.855] per_parsetree_context = 0x0 [03:03:02.855] plantree_list = 0x584308d0 [03:03:02.855] parsetree = 0x5834f0fc [03:03:02.855] commandTag = [03:03:02.855] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:03:02.855] querytree_list = [03:03:02.855] portal = 0x583a58e0 [03:03:02.855] receiver = [03:03:02.855] format = 0 [03:03:02.855] cmdtagname = [03:03:02.855] parsetree_item__state = [03:03:02.855] dest = DestRemote [03:03:02.855] oldcontext = 0x583c69a0 [03:03:02.855] parsetree_list = 0x5834f118 [03:03:02.855] parsetree_item = 0x5834f128 [03:03:02.855] save_log_statement_stats = false [03:03:02.855] was_logged = false [03:03:02.855] use_implicit_block = false [03:03:02.855] msec_str = "\360\3434X2\000\000\000Q\000\000\000\352\204\330V\020\a\214\377\376\377\377?\031\2716g߆\330V" [03:03:02.855] __func__ = "exec_simple_query" [03:03:02.855] #26 0x570d0154 in PostgresMain (dbname=0x5832929c "regression_citext", username=0x58381560 "postgres") at ../src/backend/tcop/postgres.c:4798 [03:03:02.855] query_string = 0x5834e3f0 "SELECT name FROM srt WHERE name SIMILAR TO '%a.*';" [03:03:02.855] firstchar = [03:03:02.855] input_message = {data = 0x5834e3f0 "SELECT name FROM srt WHERE name SIMILAR TO '%a.*';", len = 51, maxlen = 1024, cursor = 51} [03:03:02.855] local_sigjmp_buf = {{__jmpbuf = {1474498548, 1478610604, 1478610608, 1, 1839091823, 1820127550}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1479701184, 1463717724, 1, 1504, 1474498548, 84, 1474499312, 198, 1474498548, 1474498548, 256, 468, 1479701184, 1463809573, 1479701184, 9760, 0, 1463809397, 1474498548, 1478605248, 1478610608, 1460177358, 9760, 4135652186, 1474498548, 1458878766, 3943412136, 1, 4135205717, 1474498548}}}} [03:03:02.855] send_ready_for_query = false [03:03:02.855] idle_in_transaction_timeout_enabled = false [03:03:02.855] idle_session_timeout_enabled = false [03:03:02.855] __func__ = "PostgresMain" [03:03:02.855] #27 0x570c585e in BackendMain (startup_data=0xff8c086c "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [03:03:02.855] bsdata = 0xff8c086c [03:03:02.855] #28 0x56f5c038 in postmaster_child_launch (child_type=, child_slot=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:274 [03:03:02.855] pid = [03:03:02.855] #29 0x56f61493 in BackendStartup (client_sock=client_sock@entry=0xff8c08b8) at ../src/backend/postmaster/postmaster.c:3377 [03:03:02.855] bn = 0x5837b490 [03:03:02.855] pid = [03:03:02.855] startup_data = {canAcceptConnections = CAC_OK} [03:03:02.855] cac = [03:03:02.855] __func__ = "BackendStartup" [03:03:02.855] #30 0x56f634d6 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:03:02.855] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\005W\b\000\000\000LA\327\363\200\3647X\244h\005W\364\017\343W\200\3647X\300\0035X\271z\005W\364\017\343W\307\3647X8\0035X\377\027\000\000\000\020\000\000\000\000\000\000\000\000\000\000\001\000\000\000\352\003\000\000\353\003\000\000\200\201\000\000\231\235\006\000\000\000\000\000P\n\000\000\000\000\000\000\b\000\000\000\000\000\000\000t80\000\000\000\000\000Ը6g\000\000\000\000\302=\221\024", __ss_align = 0}, salen = 2}} [03:03:02.855] i = 0 [03:03:02.855] now = [03:03:02.855] last_lockfile_recheck_time = 1731639576 [03:03:02.855] last_touch_time = 1731639576 [03:03:02.855] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 497135240, fd = 0, user_data = 0x6736b8d2}, {pos = 0, events = 945068287, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 1, user_data = 0x1b}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 4112, user_data = 0xf681862c}, {pos = 1480010784, events = 64, fd = 4096, user_data = 0xf6818c42}, {pos = -157691916, events = 4137277432, fd = 8224, user_data = 0x1000}, {pos = 1480010776, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x6b}, {pos = 0, events = 0, fd = 0, user_data = 0xf699d7c0}, {pos = 4096, events = 4137275380, fd = -216, user_data = 0xf6819a4f }, {pos = 1479741472, events = 4137275380, fd = -7599288, user_data = 0xf6889b4c <__fstat64_time64+44>}, {pos = 8, events = 4136852777, fd = -7599552, user_data = 0xf699cff4}, {pos = -159379401, events = 4137275380, fd = 1479741472, user_data = 0xf67f2b22 <_IO_file_doallocate+178>}, {pos = 1479741472, events = 1480010784, fd = 1480014880, user_data = 0x1}, {pos = 2049, events = 0, fd = 433561, user_data = 0x0}, {pos = 33152, events = 4159546180, fd = -159780646, user_data = 0x5663e6bd}, {pos = 0, events = 0, fd = 2640, user_data = 0x0}, {pos = 4096, events = 4159721460, fd = 0, user_data = 0x6736b8d4}, {pos = 0, events = 4149797280, fd = -159868616, user_data = 0xf6787cf8}, {pos = 2090263927, events = 4159547145, fd = 1, user_data = 0x1}, {pos = -159844456, events = 1510, fd = -159815528, user_data = 0xf758e1a0}, {pos = -7599340, events = 4287367952, fd = 2048, user_data = 0xf6818c42}, {pos = -157691916, events = 43, fd = 0, user_data = 0xf6789938}, {pos = -135245836, events = 4135151768, fd = 1449180359, user_data = 0xf678f798}, {pos = 2090263927, events = 4149797280, fd = 23, user_data = 0xff8c0ba0}, {pos = -7599340, events = 4091812944, fd = 2056, user_data = 0xf6817619}, {pos = 8, events = 4137277376, fd = -157691916, user_data = 0x811}, {pos = 0, events = 0, fd = 1, user_data = 0x573e802e }, {pos = -157691916, events = 2090263927, fd = -135242712, user_data = 0xff8c0ba0}, {pos = -7599196, events = 4159549134, fd = 1448994128, user_data = 0xff8c0ba4}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 6603467, user_data = 0x1400}, {pos = -135245836, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 12, fd = 76583, user_data = 0xf685f6cc }, {pos = 12, events = 0, fd = -7598992, user_data = 0xf680f692 }, {pos = -1, events = 4135122840, fd = -145170016, user_data = 0x1010}, {pos = 0, events = 0, fd = 3, user_data = 0x0}, {pos = 1474498548, events = 0, fd = 1449180359, user_data = 0x57e31234 }, {pos = -135243184, events = 4159576011, fd = 0, user_data = 0xf6801c6d}, {pos = -7599092, events = 4159724584, fd = -203154144, user_data = 0x1}, {pos = 0, events = 4137270100, fd = -157699200, user_data = 0xff8c0c0c}, {pos = 0, events = 1128, fd = -135245836, user_data = 0xf6800380}, {pos = 0, events = 0, fd = 0, user_data = 0xe7a91100}, {pos = -159844456, events = 4135974080, fd = -157691916, user_data = 0xe7a91100}, {pos = -157691916, events = 76583, fd = 12, user_data = 0xf67b9380 }, {pos = 2, events = 4287368304, fd = 0, user_data = 0x57e30ff4}, {pos = 0, events = 4135293798, fd = 1474498548, user_data = 0x56f5bc7e }, {pos = 2, events = 4287368304, fd = 0, user_data = 0x573eaf3c }, {pos = 4194304, events = 0, fd = 920583490, user_data = 0x2046aa}, {pos = 1731639576, events = 0, fd = 74, user_data = 0x0}, {pos = -157691916, events = 4287368444, fd = 1480054260, user_data = 0xf68591cc <__clock_gettime64+60>}, {pos = 0, events = 4287368444, fd = 1474498548, user_data = 0x573a3a03 }, {pos = 1480006640, events = 0, fd = 1474498548, user_data = 0x573a76c4 }, {pos = -7598776, events = 1480054304, fd = 1479869240, user_data = 0x84d6bd}, {pos = 0, events = 4287368444, fd = 1479869376, user_data = 0x57e30ff4}, {pos = 12, events = 1480052340, fd = 1480052320, user_data = 0x56f5e7e0 }, {pos = 13, events = 0, fd = 12, user_data = 0x57e30ff4}, {pos = 0, events = 12, fd = 12, user_data = 0x56f5be58 }, {pos = 237, events = 1478557440, fd = 1458958121, user_data = 0x56f6008a }, {pos = 1480052320, events = 12, fd = 0, user_data = 0x0}, {pos = 12, events = 1476469392, fd = 1479863376, user_data = 0x58012290 }} [03:03:02.855] nevents = 1 [03:03:02.855] __func__ = "ServerLoop" [03:03:02.855] #31 0x56f64da2 in PostmasterMain (argc=8, argv=0x58327200) at ../src/backend/postmaster/postmaster.c:1361 [03:03:02.855] opt = [03:03:02.855] status = [03:03:02.855] userDoption = [03:03:02.855] listen_addr_saved = false [03:03:02.855] output_config_variable = [03:03:02.855] __func__ = "PostmasterMain" [03:03:02.855] #32 0x56d8e9f2 in main (argc=8, argv=0x58327200) at ../src/backend/main/main.c:196 [03:03:02.855] do_check_root =