[09:05:58.208] src/tools/ci/cores_backtrace.sh linux /tmp/cores [09:05:58.454] dumping /tmp/cores/postgres-6-70945.core for /tmp/cirrus-ci-build/build-32/tmp_install/usr/local/pgsql/bin/postgres [09:05:58.728] [New LWP 70945] [09:05:58.728] [09:05:58.728] This GDB supports auto-downloading debuginfo from the following URLs: [09:05:58.728] [09:05:58.728] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:05:58.728] Debuginfod has been disabled. [09:05:58.728] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:05:58.884] [Thread debugging using libthread_db enabled] [09:05:58.884] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:05:58.884] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [09:05:58.884] Program terminated with signal SIGABRT, Aborted. [09:05:58.884] #0 0xf7f42559 in __kernel_vsyscall () [09:05:59.015] [09:05:59.015] Thread 1 (Thread 0xf3de7240 (LWP 70945)): [09:05:59.015] #0 0xf7f42559 in __kernel_vsyscall () [09:05:59.015] No symbol table info available. [09:05:59.015] #1 0xf687d2f7 in ?? () from /lib/i386-linux-gnu/libc.so.6 [09:05:59.015] No symbol table info available. [09:05:59.015] #2 0xf682c111 in raise () from /lib/i386-linux-gnu/libc.so.6 [09:05:59.015] No symbol table info available. [09:05:59.015] #3 0xf681526a in abort () from /lib/i386-linux-gnu/libc.so.6 [09:05:59.015] No symbol table info available. [09:05:59.015] #4 0xf6a38d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:05:59.015] No locals. [09:05:59.015] #5 0xf6a47896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:05:59.015] No locals. [09:05:59.015] #6 0xf6a2558c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [09:05:59.015] bp = 4292716872 [09:05:59.015] pc = [09:05:59.015] Opts = {FromUnrecoverableHandler = 208, pc = 4292717288, bp = 4137833824} [09:05:59.015] #7 0x56f7e5a4 in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [09:05:59.015] __func__ = "pg_check_regex_collation" [09:05:59.015] #8 0x56f7e92f in pg_regcomp (re=0xffddaae0, string=0x5838fc0c, len=37, flags=3, collation=100) at ../src/backend/regex/regcomp.c:453 [09:05:59.015] var = {re = 0xffddaae0, now = 0x5838fc20, stop = 0x5838fca0, err = 0, cflags = 3, lasttype = 110, nexttype = 94, nextvalue = 152, lexcon = 1, nsubexp = 0, subs = 0xffdda9b4, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x58373870, cm = 0x58373698, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1474424820, cv = 0x58392a40, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [09:05:59.015] v = 0xffdda984 [09:05:59.015] g = 0x58373650 [09:05:59.015] i = [09:05:59.015] j = [09:05:59.015] debug = 0x0 [09:05:59.015] #9 0x5728413b in RE_compile_and_cache (text_re=0x5838fbc0, cflags=3, collation=100) at ../src/backend/utils/adt/regexp.c:209 [09:05:59.015] text_re_len = 37 [09:05:59.015] text_re_val = 0x5838fbc4 "***S^(?:a){1,1}?((?:b.d)){1,1}(?:.*)$", '\221' , "\230" [09:05:59.015] pattern = 0x5838fc0c [09:05:59.015] pattern_len = 37 [09:05:59.015] i = [09:05:59.015] regcomp_result = [09:05:59.015] re_temp = {cre_context = 0x583735c0, cre_pat = 0x5838fb30 "\324\001", cre_pat_len = 64, cre_flags = 0, cre_collation = 1463753388, cre_re = {re_magic = 65239, re_nsub = 1479313180, re_info = 100000, re_csize = 4, re_endp = 0x40 , re_collation = 100, re_guts = 0x58373650 '\177' , re_fns = 0x57e09da0 "\371H\366V\374\357\365V"}} [09:05:59.015] errMsg = "\364\357\341W\365\243=W \3338X@\002\000\000,\253\335\3770\3738X\003\000\000\000\240\3738X\000\000\000\000f\266=W@\000\000\000\003\000\000\0000\3738X̳=W\364\357\341W\254\3378X\364\357\341W<\000\000\000\334\3368X,\253\335\377\334\3368X\364\357\341W\000\000\000\000\324\001\000\000\004\210,X" [09:05:59.015] oldcontext = 0x5838fb30 [09:05:59.015] __func__ = "RE_compile_and_cache" [09:05:59.015] #10 0x57285aa2 in textregexsubstr (fcinfo=0x5838df90) at ../src/backend/utils/adt/regexp.c:593 [09:05:59.015] s = 0x582c872c [09:05:59.015] p = [09:05:59.015] re = [09:05:59.015] pmatch = {{rm_so = 1480123412, rm_eo = 1479313408}, {rm_so = 1474424820, rm_eo = 1462264665}} [09:05:59.015] so = [09:05:59.015] eo = [09:05:59.015] #11 0x56c8827f in ExecInterpExpr (state=0x5838dedc, econtext=0x5838dd5c, isnull=0xffddac2f) at ../src/backend/executor/execExprInterp.c:770 [09:05:59.015] fcinfo = 0x5838df90 [09:05:59.015] args = 0x5838dfa4 [09:05:59.015] nargs = 2 [09:05:59.015] d = [09:05:59.015] op = 0x5838e06c [09:05:59.015] resultslot = 0x5838de60 [09:05:59.015] innerslot = 0x0 [09:05:59.015] outerslot = 0x0 [09:05:59.015] scanslot = 0x0 [09:05:59.015] dispatch_table = {0x56c86284 , 0x56c862d7 , 0x56c863d9 , 0x56c864db , 0x56c865dd , 0x56c8682e , 0x56c86a7f , 0x56c86cd0 , 0x56c86d28 , 0x56c86d80 , 0x56c86dd8 , 0x56c86e2f , 0x56c871f2 , 0x56c875b5 , 0x56c87978 , 0x56c87bba , 0x56c87eab , 0x56c87fc2 , 0x56c88138 , 0x56c88325 , 0x56c8837c , 0x56c883d3 , 0x56c88403 , 0x56c885ef , 0x56c8877b , 0x56c887ab , 0x56c88997 , 0x56c88b23 , 0x56c88bd1 , 0x56c88d7e , 0x56c88e10 , 0x56c88f3e , 0x56c8906c , 0x56c891e8 , 0x56c89319 , 0x56c8944a , 0x56c894a1 , 0x56c894f8 , 0x56c89610 , 0x56c89769 , 0x56c898c2 , 0x56c899da , 0x56c89a31 , 0x56c89a88 , 0x56c89b1a , 0x56c89b71 , 0x56c89f61 , 0x56c8a0ee , 0x56c8a5d9 , 0x56c8a62c , 0x56c8a883 , 0x56c8aaca , 0x56c8ad61 , 0x56c8adb4 , 0x56c8ae07 , 0x56c8ae5a , 0x56c8aead , 0x56c8af04 , 0x56c8af57 , 0x56c8b360 , 0x56c8b584 , 0x56c8b5d7 , 0x56c8b62e , 0x56c8b685 , 0x56c8b6dc , 0x56c8b7e1 , 0x56c8b826 , 0x56c8b7e1 , 0x56c89d69 , 0x56c8b970 , 0x56c8b9c3 , 0x56c8ba16 , 0x56c8baee , 0x56c8bc70 , 0x56c8be7c , 0x56c8bffd , 0x56c8b872 , 0x56c8b8c6 , 0x56c8b919 , 0x56c8c22d , 0x56c8c280 , 0x56c8c2d7 , 0x56c8c32a , 0x56c8c396 , 0x56c8c3ed , 0x56c8c440 , 0x56c8c612 , 0x56c8c665 , 0x56c8c89a , 0x56c8c8f1 , 0x56c8c948 , 0x56c8ca37 , 0x56c8cc95 , 0x56c8ce1b , 0x56c8cf9a , 0x56c8d156 , 0x56c8d5c6 , 0x56c8d9f6 , 0x56c8ddfb , 0x56c8e31c , 0x56c8e7f2 , 0x56c8ec9b , 0x56c8edd2 , 0x56c8ef08 , 0x56c8ef5f , 0x56c8efb6 } [09:05:59.015] #12 0x56c7b867 in ExecInterpExprStillValid (state=0x5838dedc, econtext=0x5838dd5c, isNull=0xffddac2f) at ../src/backend/executor/execExprInterp.c:2035 [09:05:59.015] No locals. [09:05:59.015] #13 0x56d284e5 in ExecEvalExprSwitchContext (state=0x5838dedc, econtext=, isNull=) at ../src/include/executor/executor.h:367 [09:05:59.015] retDatum = [09:05:59.015] oldContext = 0x5838db20 [09:05:59.015] #14 0x56d285e0 in ExecProject (projInfo=0x5838ded8) at ../src/include/executor/executor.h:401 [09:05:59.015] econtext = 0x5838dd5c [09:05:59.015] state = 0x5838dedc [09:05:59.015] slot = 0x5838de60 [09:05:59.015] isnull = 87 [09:05:59.015] #15 0x56d28a01 in ExecResult (pstate=0x5838dcd0) at ../src/backend/executor/nodeResult.c:135 [09:05:59.015] node = 0x5838dcd0 [09:05:59.015] outerTupleSlot = [09:05:59.015] outerPlan = [09:05:59.015] econtext = 0x5838dd5c [09:05:59.015] #16 0x56cace31 in ExecProcNodeFirst (node=0x5838dcd0) at ../src/backend/executor/execProcnode.c:469 [09:05:59.015] No locals. [09:05:59.015] #17 0x56c96e15 in ExecProcNode (node=node@entry=0x5838dcd0) at ../src/include/executor/executor.h:278 [09:05:59.015] No locals. [09:05:59.015] #18 0x56c9701a in ExecutePlan (estate=estate@entry=0x5838dbb0, planstate=0x5838dcd0, use_parallel_mode=, operation=CMD_SELECT, sendTuples=true, numberTuples=1, direction=ForwardScanDirection, dest=0x58385dcc, execute_once=true) at ../src/backend/executor/execMain.c:1650 [09:05:59.015] slot = [09:05:59.015] current_tuple_count = 0 [09:05:59.015] #19 0x56c98f99 in standard_ExecutorRun (queryDesc=0x58385df8, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:361 [09:05:59.015] estate = 0x5838dbb0 [09:05:59.015] operation = CMD_SELECT [09:05:59.015] dest = 0x58385dcc [09:05:59.015] sendTuples = [09:05:59.015] oldcontext = 0x58383ac0 [09:05:59.015] __func__ = "standard_ExecutorRun" [09:05:59.015] #20 0xf3dd08eb in pgss_ExecutorRun (queryDesc=0x58385df8, direction=ForwardScanDirection, count=1, execute_once=true) at ../contrib/pg_stat_statements/pg_stat_statements.c:1033 [09:05:59.015] _save_exception_stack = 0xffddb5f4 [09:05:59.015] _save_context_stack = 0xffddaed4 [09:05:59.015] _local_sigjmp_buf = {{__jmpbuf = {-203550732, 1474424820, 1, 1, -451219528, -464463968}, __mask_was_saved = 0, __saved_mask = {__val = {1479537112, 1479803660, 1474364228, 1474424820, 1480121812, 1, 1480088304, 1463914868, 32, 1480089080, 1480087676, 1, 1478524980, 1479803712, 1474424820, 1474424820, 1480121264, 1480089080, 32, 1456056386, 1474424820, 1474424820, 1479803660, 1480080064, 1477845584, 1479803712, 1474364228, 4091416564, 1480089080, 0, 1480080208, 4091353415}}}} [09:05:59.015] _do_rethrow = false [09:05:59.015] #21 0x56c9924a in ExecutorRun (queryDesc=0x58385df8, direction=ForwardScanDirection, count=1, execute_once=true) at ../src/backend/executor/execMain.c:300 [09:05:59.015] No locals. [09:05:59.015] #22 0x56cc3fc9 in postquel_getnext (es=es@entry=0x58385a98, fcache=fcache@entry=0x58383b50) at ../src/backend/executor/functions.c:897 [09:05:59.015] count = 1 [09:05:59.015] result = [09:05:59.015] #23 0x56cc6f0d in fmgr_sql (fcinfo=0x5836c524) at ../src/backend/executor/functions.c:1198 [09:05:59.015] completed = [09:05:59.015] fcache = 0x58383b50 [09:05:59.015] sqlerrcontext = {previous = 0x0, callback = 0x56cc1f75 , arg = 0x5836c4f8} [09:05:59.015] oldcontext = 0x583702f0 [09:05:59.015] randomAccess = [09:05:59.015] lazyEvalOK = [09:05:59.015] is_first = [09:05:59.015] pushed_snapshot = false [09:05:59.015] es = 0x58385a98 [09:05:59.015] slot = [09:05:59.015] result = [09:05:59.015] eslist = 0x58385b7c [09:05:59.015] eslc = [09:05:59.015] __func__ = "fmgr_sql" [09:05:59.015] #24 0x56c8827f in ExecInterpExpr (state=0x5836c46c, econtext=0x5836c97c, isnull=0xffddafaf) at ../src/backend/executor/execExprInterp.c:770 [09:05:59.015] fcinfo = 0x5836c524 [09:05:59.015] args = 0x5836c538 [09:05:59.015] nargs = 3 [09:05:59.015] d = [09:05:59.015] op = 0x5836c570 [09:05:59.015] resultslot = 0x0 [09:05:59.015] innerslot = 0x0 [09:05:59.015] outerslot = 0x0 [09:05:59.015] scanslot = 0x0 [09:05:59.015] dispatch_table = {0x56c86284 , 0x56c862d7 , 0x56c863d9 , 0x56c864db , 0x56c865dd , 0x56c8682e , 0x56c86a7f , 0x56c86cd0 , 0x56c86d28 , 0x56c86d80 , 0x56c86dd8 , 0x56c86e2f , 0x56c871f2 , 0x56c875b5 , 0x56c87978 , 0x56c87bba , 0x56c87eab , 0x56c87fc2 , 0x56c88138 , 0x56c88325 , 0x56c8837c , 0x56c883d3 , 0x56c88403 , 0x56c885ef , 0x56c8877b , 0x56c887ab , 0x56c88997 , 0x56c88b23 , 0x56c88bd1 , 0x56c88d7e , 0x56c88e10 , 0x56c88f3e , 0x56c8906c , 0x56c891e8 , 0x56c89319 , 0x56c8944a , 0x56c894a1 , 0x56c894f8 , 0x56c89610 , 0x56c89769 , 0x56c898c2 , 0x56c899da , 0x56c89a31 , 0x56c89a88 , 0x56c89b1a , 0x56c89b71 , 0x56c89f61 , 0x56c8a0ee , 0x56c8a5d9 , 0x56c8a62c , 0x56c8a883 , 0x56c8aaca , 0x56c8ad61 , 0x56c8adb4 , 0x56c8ae07 , 0x56c8ae5a , 0x56c8aead , 0x56c8af04 , 0x56c8af57 , 0x56c8b360 , 0x56c8b584 , 0x56c8b5d7 , 0x56c8b62e , 0x56c8b685 , 0x56c8b6dc , 0x56c8b7e1 , 0x56c8b826 , 0x56c8b7e1 , 0x56c89d69 , 0x56c8b970 , 0x56c8b9c3 , 0x56c8ba16 , 0x56c8baee , 0x56c8bc70 , 0x56c8be7c , 0x56c8bffd , 0x56c8b872 , 0x56c8b8c6 , 0x56c8b919 , 0x56c8c22d , 0x56c8c280 , 0x56c8c2d7 , 0x56c8c32a , 0x56c8c396 , 0x56c8c3ed , 0x56c8c440 , 0x56c8c612 , 0x56c8c665 , 0x56c8c89a , 0x56c8c8f1 , 0x56c8c948 , 0x56c8ca37 , 0x56c8cc95 , 0x56c8ce1b , 0x56c8cf9a , 0x56c8d156 , 0x56c8d5c6 , 0x56c8d9f6 , 0x56c8ddfb , 0x56c8e31c , 0x56c8e7f2 , 0x56c8ec9b , 0x56c8edd2 , 0x56c8ef08 , 0x56c8ef5f , 0x56c8efb6 } [09:05:59.015] #25 0x56c7b867 in ExecInterpExprStillValid (state=0x5836c46c, econtext=0x5836c97c, isNull=0xffddafaf) at ../src/backend/executor/execExprInterp.c:2035 [09:05:59.015] No locals. [09:05:59.015] #26 0x56e6a373 in ExecEvalExprSwitchContext (isNull=0xffddafaf, econtext=, state=0x5836c46c) at ../src/include/executor/executor.h:367 [09:05:59.015] retDatum = [09:05:59.015] oldContext = 0x5836c2d0 [09:05:59.015] retDatum = [09:05:59.015] oldContext = [09:05:59.015] #27 evaluate_expr (expr=0x58373da0, result_type=25, result_typmod=-1, result_collation=100) at ../src/backend/optimizer/util/clauses.c:5009 [09:05:59.015] estate = 0x5836c360 [09:05:59.015] exprstate = 0x5836c46c [09:05:59.015] oldcontext = 0x582c7370 [09:05:59.015] const_val = [09:05:59.015] const_is_null = 87 [09:05:59.015] resultTypLen = 7197 [09:05:59.015] resultTypByVal = false [09:05:59.015] #28 0x56e6a8d2 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=0x58373d1c, funcvariadic=false, func_tuple=0xf2372ff0, context=0xffddb2ac) at ../src/backend/optimizer/util/clauses.c:4515 [09:05:59.015] funcform = [09:05:59.015] has_nonconst_input = false [09:05:59.015] has_null_input = false [09:05:59.015] arg = 0x0 [09:05:59.015] newexpr = [09:05:59.015] #29 0x56e6fee9 in simplify_function (funcid=funcid@entry=2074, result_type=25, result_typmod=-1, result_collid=100, input_collid=100, args_p=0xffddb104, funcvariadic=false, process_args=true, allow_non_const=true, context=0xffddb2ac) at ../src/backend/optimizer/util/clauses.c:4104 [09:05:59.015] args = 0x58373d1c [09:05:59.015] func_tuple = 0xf2372ff0 [09:05:59.015] func_form = 0xf2373028 [09:05:59.015] newexpr = [09:05:59.015] __func__ = "simplify_function" [09:05:59.015] #30 0x56e6b2bc in eval_const_expressions_mutator (node=0x582c8680, context=0xffddb2ac) at ../src/backend/optimizer/util/clauses.c:2591 [09:05:59.015] expr = 0x582c8680 [09:05:59.015] args = 0x58373d1c [09:05:59.015] simple = [09:05:59.015] newexpr = [09:05:59.015] __func__ = "eval_const_expressions_mutator" [09:05:59.015] #31 0x56d99f75 in expression_tree_mutator_impl (node=0x582c8848, mutator=0x56e6aa35 , context=0xffddb2ac) at ../src/backend/nodes/nodeFuncs.c:3464 [09:05:59.015] targetentry = 0x582c8848 [09:05:59.015] newnode = 0x58373cc4 [09:05:59.015] __func__ = "expression_tree_mutator_impl" [09:05:59.015] #32 0x56e6aae2 in eval_const_expressions_mutator (node=0x582c8848, context=0xffddb2ac) at ../src/backend/optimizer/util/clauses.c:3723 [09:05:59.015] __func__ = "eval_const_expressions_mutator" [09:05:59.015] #33 0x56d9a775 in expression_tree_mutator_impl (node=0x582c8874, mutator=0x56e6aa35 , context=0xffddb2ac) at ../src/backend/nodes/nodeFuncs.c:3549 [09:05:59.015] temp__state = [09:05:59.015] resultlist = 0x0 [09:05:59.015] temp = [09:05:59.015] __func__ = "expression_tree_mutator_impl" [09:05:59.015] #34 0x56e6aae2 in eval_const_expressions_mutator (node=0x582c8874, context=0xffddb2ac) at ../src/backend/optimizer/util/clauses.c:3723 [09:05:59.015] __func__ = "eval_const_expressions_mutator" [09:05:59.015] #35 0x56e6e8d2 in eval_const_expressions (root=0x583739f0, node=0x582c8874) at ../src/backend/optimizer/util/clauses.c:2266 [09:05:59.015] context = {boundParams = 0x0, root = 0x583739f0, active_fns = 0x0, case_val = 0x0, estimate = false} [09:05:59.015] #36 0x56e22c44 in preprocess_expression (root=root@entry=0x583739f0, expr=, kind=kind@entry=1) at ../src/backend/optimizer/plan/planner.c:1229 [09:05:59.015] No locals. [09:05:59.015] #37 0x56e3427a in subquery_planner (glob=, parse=, parent_root=, hasRecursion=, tuple_fraction=, setops=) at ../src/backend/optimizer/plan/planner.c:849 [09:05:59.015] root = [09:05:59.015] newWithCheckOptions = [09:05:59.015] newHaving = [09:05:59.015] hasOuterJoins = false [09:05:59.015] hasResultRTEs = true [09:05:59.015] final_rel = [09:05:59.015] l = 0x0 [09:05:59.015] #38 0x56e36084 in standard_planner (parse=0x582c8184, query_string=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:423 [09:05:59.015] result = [09:05:59.015] glob = 0x582c916c [09:05:59.015] tuple_fraction = 0 [09:05:59.015] root = [09:05:59.015] final_rel = [09:05:59.015] best_path = [09:05:59.015] top_plan = [09:05:59.015] lp = [09:05:59.015] lr = [09:05:59.015] #39 0xf3dd5f54 in pgss_planner (parse=0x582c8184, query_string=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:973 [09:05:59.015] _save_exception_stack = 0xffddb7f4 [09:05:59.015] _save_context_stack = 0x0 [09:05:59.015] _local_sigjmp_buf = {{__jmpbuf = {-203550732, -203550732, 1479316004, 0, -450383944, -453630048}, __mask_was_saved = 0, __saved_mask = {__val = {1479308144, 32, 0, 1463753388, 1474424820, 1, 1, 1457032661, 32, 1, 1474424820, 1457032646, 0, 0, 0, 1457031633, 1474424820, 0, 1479316004, 1457035590, 1479311480, 1474424820, 1479315960, 1459634786, 0, 1479311748, 1479311748, 1459634731, 3879816193, 3800423748, 1474424820, 0}}}} [09:05:59.015] _do_rethrow = false [09:05:59.015] result = 0x0 [09:05:59.015] #40 0x56e3729b in planner (parse=0x582c8184, query_string=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:282 [09:05:59.015] result = [09:05:59.015] #41 0x570bfe53 in pg_plan_query (querytree=0x582c8184, query_string=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:911 [09:05:59.015] plan = [09:05:59.015] #42 0x570c022c in pg_plan_queries (querytrees=0x582c9224, query_string=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", cursorOptions=2048, boundParams=0x0) at ../src/backend/tcop/postgres.c:1005 [09:05:59.015] query = 0x582c8184 [09:05:59.015] stmt = [09:05:59.015] query_list__state = [09:05:59.015] stmt_list = 0x0 [09:05:59.015] query_list = [09:05:59.015] #43 0x570c07f6 in exec_simple_query (query_string=query_string@entry=0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";") at ../src/backend/tcop/postgres.c:1202 [09:05:59.015] cmdtaglen = 6 [09:05:59.015] snapshot_set = true [09:05:59.015] per_parsetree_context = 0x0 [09:05:59.015] plantree_list = [09:05:59.015] parsetree = 0x582c8030 [09:05:59.015] commandTag = CMDTAG_SELECT [09:05:59.015] qc = {commandTag = 4292720608, nprocessed = 6257723478655496180} [09:05:59.015] querytree_list = [09:05:59.015] portal = [09:05:59.015] receiver = [09:05:59.015] format = 22331 [09:05:59.015] cmdtagname = [09:05:59.015] parsetree_item__state = [09:05:59.015] dest = DestRemote [09:05:59.015] oldcontext = 0x58340260 [09:05:59.015] parsetree_list = 0x582c804c [09:05:59.015] parsetree_item = 0x582c805c [09:05:59.015] save_log_statement_stats = false [09:05:59.015] was_logged = true [09:05:59.015] use_implicit_block = false [09:05:59.015] msec_str = "\000t,XF\000\000\000Q\000\000\000\315\345\327V\340\267\335\377\376\377\377?\231\244 g\302\347\327V" [09:05:59.015] __func__ = "exec_simple_query" [09:05:59.015] #44 0x570c3870 in PostgresMain (dbname=0x582fd72c "regression", username=0x582fd710 "postgres") at ../src/backend/tcop/postgres.c:4792 [09:05:59.015] query_string = 0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";" [09:05:59.015] firstchar = [09:05:59.015] input_message = {data = 0x582c7400 "SELECT SUBSTRING('abcdefg' SIMILAR 'a#\"(b_d)#\"%' ESCAPE '#') AS \"bcd\";", len = 71, maxlen = 1024, cursor = 71} [09:05:59.015] local_sigjmp_buf = {{__jmpbuf = {1474424820, 1478524812, 1478524816, 1, -449884232, 1176352489}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 0, 1479148304, 1463661516, 1, 1504, 1474424820, 84, 1474425584, 198, 1474424820, 1474424820, 0, 468, 1479148304, 1463753564, 1479148304, 3760, 0, 1463753388, 1474424820, 1478519456, 1478524816, 1460125830, 3760, 4136122954, 1474424820, 1458832626, 4065019304, 1, 4135676757, 1474424820}}}} [09:05:59.015] send_ready_for_query = false [09:05:59.015] idle_in_transaction_timeout_enabled = false [09:05:59.015] idle_session_timeout_enabled = false [09:05:59.015] __func__ = "PostgresMain" [09:05:59.015] #45 0x570b8f7a in BackendMain (startup_data=0xffddb92c "", startup_data_len=4) at ../src/backend/tcop/backend_startup.c:107 [09:05:59.015] bsdata = 0xffddb92c [09:05:59.015] #46 0x56f50bc6 in postmaster_child_launch (child_type=, startup_data=, startup_data_len=, client_sock=) at ../src/backend/postmaster/launch_backend.c:266 [09:05:59.015] pid = [09:05:59.015] #47 0x56f56c00 in BackendStartup (client_sock=client_sock@entry=0xffddb978) at ../src/backend/postmaster/postmaster.c:3417 [09:05:59.015] bn = 0x582ec2e4 [09:05:59.015] pid = [09:05:59.015] startup_data = {canAcceptConnections = CAC_OK} [09:05:59.015] __func__ = "BackendStartup" [09:05:59.015] #48 0x56f5718d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1650 [09:05:59.015] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\004W\a\000\000\000Lq\336\363`E/XG\236\004W\364\357\341W`E/XГ,X\\\260\004W\364\357\341W\247E/X(\302.X\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\000N/\004\000\000\000\000\000P\n\000\000\000\000\000\000\b\000\000\000\000\000\000\000t80\000\000\000\000\000o\244 g\000\000\000\000ٺm\036", __ss_align = 0}, salen = 2}} [09:05:59.015] i = 0 [09:05:59.015] now = [09:05:59.015] last_lockfile_recheck_time = 1730192533 [09:05:59.015] last_touch_time = 1730192533 [09:05:59.015] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 398463669, fd = 0, user_data = 0x6720a46e}, {pos = 0, events = 194509408, 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 = 0xf688b51c}, {pos = 1479495024, events = 145, fd = 4096, user_data = 0xf688bb32}, {pos = -157220876, events = 4137748472, fd = 6176, user_data = 0x1000}, {pos = 1479495016, events = 1, fd = 1, user_data = 0x0}, {pos = 256, events = 0, fd = 99, user_data = 0x62}, {pos = 0, events = 0, fd = 0, user_data = 0xf6a107c0}, {pos = 4096, events = 4137746420, fd = -216, user_data = 0xf688c93f }, {pos = 1479188528, events = 4137746420, fd = -2245624, user_data = 0xf68fca3c <__fstat64_time64+44>}, {pos = 7, events = 4137323817, fd = -2245888, user_data = 0xf6a0fff4}, {pos = -158908361, events = 4137746420, fd = 1479188528, user_data = 0xf6865b22 <_IO_file_doallocate+178>}, {pos = 1479188528, events = 1479495024, fd = 1479499120, user_data = 0x1}, {pos = 2049, events = 0, fd = 274254, user_data = 0x0}, {pos = 33152, events = 1, fd = 1002, user_data = 0x3eb}, {pos = 0, events = 4160017220, fd = -159309606, user_data = 0x5663a3ca}, {pos = 4096, events = 8, fd = 0, user_data = 0x6720a46f}, {pos = 0, events = 4160192500, fd = 0, user_data = 0x6720a46e}, {pos = 0, events = 4150268320, fd = -159397576, user_data = 0xf67facf8}, {pos = 2090263927, events = 4160018185, fd = 1, user_data = 0x1}, {pos = -159373416, events = 1510, fd = -159344488, user_data = 0xf76011a0}, {pos = -2245660, events = 4292721632, fd = -216, user_data = 0x800}, {pos = -2245624, events = 44, fd = 0, user_data = 0xf67fc938}, {pos = -134774796, events = 4135622808, fd = 1449163675, user_data = 0xf6802798}, {pos = 2090263927, events = 4150268320, fd = 23, user_data = 0xffddbc70}, {pos = -2245660, events = 1479471648, fd = -157220876, user_data = 0x811}, {pos = 0, events = 1479464208, fd = 1, user_data = 0x573da565 }, {pos = 0, events = 0, fd = -157226156, user_data = 0xde0}, {pos = 1479501184, events = 2090263927, fd = -134771672, user_data = 0xffddbc70}, {pos = -2245516, events = 4160020174, fd = 1448977684, user_data = 0xffddbc74}, {pos = 16204, events = 3, fd = 3, user_data = 0x0}, {pos = 2, events = 3, fd = 0, user_data = 0x1}, {pos = 48, events = 0, fd = 14807028, user_data = 0x573dae0e }, {pos = -134774796, events = 44, fd = 0, user_data = 0xffffff0c}, {pos = 0, events = 182424, fd = 70282, user_data = 0xf68d25bc }, {pos = 11, events = 0, fd = -2245312, user_data = 0xf6882582 }, {pos = -1, events = 4135593880, fd = -144698976, user_data = 0x582eff00}, {pos = 1474424820, events = 0, fd = 3, user_data = 0x0}, {pos = 1479474944, events = 0, fd = 1449163675, user_data = 0x57e1f234 }, {pos = -134772144, events = 4160047051, fd = 0, user_data = 0xf6874c5d}, {pos = -2245412, events = 4160195624, fd = -202683104, user_data = 0x1}, {pos = 0, events = 4137741140, fd = -157228160, user_data = 0xffddbcdc}, {pos = -1857585829, events = 1128, fd = -134774796, user_data = 0xf6873380}, {pos = 0, events = 0, fd = 0, user_data = 0x3fbfc600}, {pos = -159373416, events = 4136444848, fd = 0, user_data = 0x3fbfc600}, {pos = -157220876, events = 70282, fd = 182424, user_data = 0xf682c380 }, {pos = 2, events = 4292721984, fd = 0, user_data = 0x57e1eff4}, {pos = 0, events = 4135764838, fd = 1474424820, user_data = 0x56f50818 }, {pos = 2, events = 4292721984, fd = 0, user_data = 0x2006ac}, {pos = 4194304, events = 0, fd = 74, user_data = 0x0}, {pos = -157220876, events = 4292722108, fd = 1479459396, user_data = 0xf68cc0bc <__clock_gettime64+60>}, {pos = 0, events = 4292722108, fd = 1474424820, user_data = 0x573f02eb }, {pos = 1479453920, events = 0, fd = 1479453920, user_data = 0x3fbfc600}, {pos = -2245112, events = 1479310984, fd = 1479459368, user_data = 0xf68c05ad }, {pos = 0, events = 4292722108, fd = 1479316432, user_data = 0x57e1eff4}, {pos = 0, events = 0, fd = 1479188528, user_data = 0xf6a0fff4}, {pos = 1479453920, events = 1479459368, fd = 1479188528, user_data = 0x6720a495}, {pos = 0, events = 537308283, fd = 0, user_data = 0x57e1eff4}, {pos = 0, events = 182424, fd = 1458906777, user_data = 0x56f56068 }, {pos = 1479310984, events = 1479459368, fd = 0, user_data = 0x0}, {pos = 11, events = 1476390064, fd = 1479310404, user_data = 0x57ffecb0 }} [09:05:59.016] nevents = 1 [09:05:59.016] __func__ = "ServerLoop" [09:05:59.016] #49 0x56f588da in PostmasterMain (argc=4, argv=0x582a0200) at ../src/backend/postmaster/postmaster.c:1348 [09:05:59.016] opt = [09:05:59.016] status = [09:05:59.016] userDoption = [09:05:59.016] listen_addr_saved = false [09:05:59.016] output_config_variable = [09:05:59.016] __func__ = "PostmasterMain" [09:05:59.016] #50 0x56d84ad5 in main (argc=4, argv=0x582a0200) at ../src/backend/main/main.c:196 [09:05:59.016] do_check_root = [09:05:59.041] -e [09:05:59.041] [09:05:59.041] [09:05:59.113] dumping /tmp/cores/postgres-6-68426.core for /tmp/cirrus-ci-build/build-32/tmp_install//usr/local/pgsql/bin/postgres [09:05:59.370] [New LWP 68426] [09:05:59.370] [09:05:59.370] This GDB supports auto-downloading debuginfo from the following URLs: [09:05:59.370] [09:05:59.370] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:05:59.370] Debuginfod has been disabled. [09:05:59.370] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:05:59.492] [Thread debugging using libthread_db enabled] [09:05:59.492] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:05:59.492] Core was generated by `postgres: postgres regression [local] SELECT '. [09:05:59.492] Program terminated with signal SIGABRT, Aborted. [09:05:59.492] #0 0xf7f9f559 in __kernel_vsyscall () [09:06:00.010] [09:06:00.010] Thread 1 (Thread 0xf3e44240 (LWP 68426)): [09:06:00.010] #0 0xf7f9f559 in __kernel_vsyscall () [09:06:00.010] No symbol table info available. [09:06:00.010] #1 0xf68da2f7 in ?? () from /lib/i386-linux-gnu/libc.so.6 [09:06:00.010] No symbol table info available. [09:06:00.010] #2 0xf6889111 in raise () from /lib/i386-linux-gnu/libc.so.6 [09:06:00.010] No symbol table info available. [09:06:00.010] #3 0xf687226a in abort () from /lib/i386-linux-gnu/libc.so.6 [09:06:00.010] No symbol table info available. [09:06:00.010] #4 0xf6a95d4a in __sanitizer::Abort () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:06:00.010] No locals. [09:06:00.010] #5 0xf6aa4896 in __sanitizer::Die () at ../../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:06:00.010] No locals. [09:06:00.010] #6 0xf6a8258c in __ubsan::__ubsan_handle_type_mismatch_v1_abort (Data=, Pointer=) at ../../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:148 [09:06:00.010] bp = 4293137608 [09:06:00.010] pc = [09:06:00.010] Opts = {FromUnrecoverableHandler = 208, pc = 4293138024, bp = 4138214752} [09:06:00.010] #7 0x56f1a5a4 in pg_check_regex_collation (is_similar_to=true) at ../src/backend/regex/regc_pg_locale.c:302 [09:06:00.010] __func__ = "pg_check_regex_collation" [09:06:00.010] #8 0x56f1a92f in pg_regcomp (re=0xffe41660, string=0x58cccb14, len=5, flags=19, collation=100) at ../src/backend/regex/regcomp.c:453 [09:06:00.010] var = {re = 0xffe41660, now = 0x58cccb1c, stop = 0x58cccb28, err = 0, cflags = 19, lasttype = 110, nexttype = 115, nextvalue = 5, lexcon = 1, nsubexp = 0, subs = 0xffe41534, nsubs = 10, sub10 = {0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, nfa = 0x58ca2840, cm = 0x58ca2668, nlcolor = -1, wordchrs = 0x0, tree = 0x0, treechain = 0x0, treefree = 0x0, ntree = 1474015220, cv = 0x58ca71a0, cv2 = 0x0, lacons = 0x0, nlacons = 0, spaceused = 3728} [09:06:00.010] v = 0xffe41504 [09:06:00.010] g = 0x58ca2620 [09:06:00.010] i = [09:06:00.010] j = [09:06:00.010] debug = 0x0 [09:06:00.010] #9 0x5722013b in RE_compile_and_cache (text_re=0x58cb9918, cflags=19, collation=100) at ../src/backend/utils/adt/regexp.c:209 [09:06:00.010] text_re_len = 5 [09:06:00.010] text_re_val = 0x58cb991c "\\d+kB~\204\204\204\204\204\204 " [09:06:00.010] pattern = 0x58cccb14 [09:06:00.010] pattern_len = 5 [09:06:00.010] i = [09:06:00.010] regcomp_result = [09:06:00.010] re_temp = {cre_context = 0x58ca2590, cre_pat = 0xffe41700 "", cre_pat_len = 468, cre_flags = 1474015220, cre_collation = 1474015220, cre_re = {re_magic = 65239, re_nsub = 1024, re_info = 1152, re_csize = 4, re_endp = 0x57dba500 "ɇ>Wg\257>W\274\203>W\256\210>Wȃ>W\253\303>W\001", re_collation = 100, re_guts = 0x58ca2620 '\204' , re_fns = 0x57da5da0 "\371\b\360V\374\257\357V"}} [09:06:00.010] errMsg = "\364\257\333W\307b7W\003\000\000\000\020\000\000\000\364\257\333W|\312\314X|\000\000\000\200\000\000\000\364\257\333W\201d7W\003\000\000\000\300\262\314X\000\000\000\000\365c7W\000\004\000\000\a\000\000\000P\262\314XP\262\314X\004\000\000\000\300\262\314X\000\000\000\000fv7W\200\000\000\000\004\000\000\000P\262\314X" [09:06:00.010] oldcontext = 0x58ccb250 [09:06:00.010] __func__ = "RE_compile_and_cache" [09:06:00.010] #10 0x572d5de4 in replace_text_regexp (src_text=0x58ccdddc, pattern_text=0x58cb9918, replace_text=0x58cb9960, cflags=19, collation=100, search_start=0, n=0) at ../src/backend/utils/adt/varlena.c:4255 [09:06:00.010] ret_text = [09:06:00.010] re = [09:06:00.010] src_text_len = 30 [09:06:00.010] nmatches = 0 [09:06:00.010] buf = {data = 0x58ccc67c "", len = 0, maxlen = 1024, cursor = 0} [09:06:00.010] pmatch = {{rm_so = 2285, rm_eo = 0}, {rm_so = -1828868, rm_eo = 1489770912}, {rm_so = 1489738144, rm_eo = 3}, {rm_so = 1474015220, rm_eo = 4}, {rm_so = 188, rm_eo = 1459986049}, {rm_so = 1478107772, rm_eo = 1455432795}, {rm_so = 1474015220, rm_eo = 1489770780}, {rm_so = 1489737800, rm_eo = 1455441222}, {rm_so = 1489770772, rm_eo = -1828868}, {rm_so = 1489770772, rm_eo = 1455437926}} [09:06:00.010] nmatch = 1 [09:06:00.010] data = 0x58ccca88 [09:06:00.010] data_len = 30 [09:06:00.010] data_pos = [09:06:00.010] start_ptr = [09:06:00.010] escape_status = 0 [09:06:00.010] __func__ = "replace_text_regexp" [09:06:00.010] #11 0x57221e9f in textregexreplace (fcinfo=0x58cc19cc) at ../src/backend/utils/adt/regexp.c:687 [09:06:00.010] s = 0x58ccdddc [09:06:00.010] p = 0x58cb9918 [09:06:00.010] r = 0x58cb9960 [09:06:00.010] opt = [09:06:00.010] flags = {cflags = 3, glob = true} [09:06:00.010] __func__ = "textregexreplace" [09:06:00.010] #12 0x56c2427f in ExecInterpExpr (state=0x58cc1914, econtext=0x58cc138c, isnull=0xffe4195f) at ../src/backend/executor/execExprInterp.c:770 [09:06:00.010] fcinfo = 0x58cc19cc [09:06:00.010] args = 0x58cc19e0 [09:06:00.010] nargs = 4 [09:06:00.010] d = [09:06:00.010] op = 0x58cc1a3c [09:06:00.010] resultslot = 0x0 [09:06:00.010] innerslot = 0x0 [09:06:00.010] outerslot = 0x0 [09:06:00.010] scanslot = 0x0 [09:06:00.010] dispatch_table = {0x56c22284 , 0x56c222d7 , 0x56c223d9 , 0x56c224db , 0x56c225dd , 0x56c2282e , 0x56c22a7f , 0x56c22cd0 , 0x56c22d28 , 0x56c22d80 , 0x56c22dd8 , 0x56c22e2f , 0x56c231f2 , 0x56c235b5 , 0x56c23978 , 0x56c23bba , 0x56c23eab , 0x56c23fc2 , 0x56c24138 , 0x56c24325 , 0x56c2437c , 0x56c243d3 , 0x56c24403 , 0x56c245ef , 0x56c2477b , 0x56c247ab , 0x56c24997 , 0x56c24b23 , 0x56c24bd1 , 0x56c24d7e , 0x56c24e10 , 0x56c24f3e , 0x56c2506c , 0x56c251e8 , 0x56c25319 , 0x56c2544a , 0x56c254a1 , 0x56c254f8 , 0x56c25610 , 0x56c25769 , 0x56c258c2 , 0x56c259da , 0x56c25a31 , 0x56c25a88 , 0x56c25b1a , 0x56c25b71 , 0x56c25f61 , 0x56c260ee , 0x56c265d9 , 0x56c2662c , 0x56c26883 , 0x56c26aca , 0x56c26d61 , 0x56c26db4 , 0x56c26e07 , 0x56c26e5a , 0x56c26ead , 0x56c26f04 , 0x56c26f57 , 0x56c27360 , 0x56c27584 , 0x56c275d7 , 0x56c2762e , 0x56c27685 , 0x56c276dc , 0x56c277e1 , 0x56c27826 , 0x56c277e1 , 0x56c25d69