On 3/27/19 9:48 AM, Tom Lane wrote:
> Alexander Korotkov <a.korot...@postgrespro.ru> writes:
>> Still no reproduction.
> Annoying, but it's probably not worth expending more effort on
> right now. I wonder whether that buildfarm animal can be upgraded
> to capture core dump stack traces --- if so, then if it happens
> again we'd have more info.
>
>
I was able to get this stack trace.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
[Switching to Thread 3960.0x34b4]
0x00007ffb9ce6a458 in ntdll!RtlRaiseStatus ()
from C:\WINDOWS\SYSTEM32\ntdll.dll
(gdb) bt
#0 0x00007ffb9ce6a458 in ntdll!RtlRaiseStatus ()
from C:\WINDOWS\SYSTEM32\ntdll.dll
#1 0x00007ffb9ce7760e in ntdll!memset () from C:\WINDOWS\SYSTEM32\ntdll.dll
#2 0x00007ffb9ac52e1a in msvcrt!_setjmpex ()
from C:\WINDOWS\System32\msvcrt.dll
#3 0x000000000087431a in pg_re_throw ()
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/error/elog.c:1720
#4 0x0000000000874106 in errfinish (dummy=<optimized out>)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/error/elog.c:464
#5 0x00000000007cc938 in jsonpath_yyerror (result=result@entry=0x0,
message=message@entry=0xab0868 <__func__.110231+1592> "unrecognized flag of
LIKE_REGEX predicate")
at
/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/jsonpath_scan.l:305
#6 0x00000000007cec9d in makeItemLikeRegex (pattern=<optimized out>,
pattern=<optimized out>, flags=<optimized out>, expr=0x73c7a80)
at
/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/jsonpath_gram.y:512
#7 jsonpath_yyparse (result=<optimized out>, result@entry=0x4b0e818)
at
/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/jsonpath_gram.y:183
#8 0x00000000007ced61 in parsejsonpath (
str=str@entry=0x73c71e0 "$ ? (@ like_regex \"pattern\" flag \"a\")",
len=len@entry=37)
at
/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/jsonpath_scan.l:481
#9 0x00000000007cf347 in jsonPathFromCstring (
in=0x73c71e0 "$ ? (@ like_regex \"pattern\" flag \"a\")", len=37)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/jsonpath.c:170
#10 0x00000000008795ea in InputFunctionCall (flinfo=flinfo@entry=0x4b0e970,
str=str@entry=0x73c71e0 "$ ? (@ like_regex \"pattern\" flag \"a\")",
typioparam=typioparam@entry=4072, typmod=typmod@entry=-1)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/fmgr/fmgr.c:1548
#11 0x00000000008797fc in OidInputFunctionCall (functionId=<optimized out>,
str=0x73c71e0 "$ ? (@ like_regex \"pattern\" flag \"a\")",
typioparam=4072, typmod=typmod@entry=-1)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/utils/fmgr/fmgr.c:1651
#12 0x000000000053e395 in stringTypeDatum (tp=tp@entry=0x7475b50,
string=<optimized out>, atttypmod=atttypmod@entry=-1)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_type.c:641
#13 0x000000000052729d in coerce_type (pstate=0x73c7618, node=0x73c7848,
inputTypeId=<optimized out>, targetTypeId=4072, targetTypeMod=-1,
ccontext=COERCION_EXPLICIT, cformat=COERCE_EXPLICIT_CAST, location=46)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_coerce.c:304
#14 0x000000000052772b in coerce_to_target_type (
pstate=pstate@entry=0x73c7618, expr=<optimized out>,
expr@entry=0x73c7848, exprtype=<optimized out>, exprtype@entry=705,
targettype=<optimized out>, targettypmod=-1,
ccontext=ccontext@entry=COERCION_EXPLICIT,
cformat=cformat@entry=COERCE_EXPLICIT_CAST, location=location@entry=46)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_coerce.c:103
#15 0x000000000052c489 in transformTypeCast (tc=0x73c7378, pstate=0x73c7618)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_expr.c:2811
#16 transformExprRecurse (pstate=pstate@entry=0x73c7618,
expr=expr@entry=0x73c7378)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_expr.c:202
#17 0x000000000052f8aa in transformExprRecurse (expr=0x73c7378,
pstate=0x73c7618)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_expr.c:163
#18 transformExpr (pstate=pstate@entry=0x73c7618, expr=expr@entry=0x73c7378,
exprKind=exprKind@entry=EXPR_KIND_SELECT_TARGET)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_expr.c:155
#19 0x000000000053be7f in transformTargetEntry (
pstate=pstate@entry=0x73c7618, node=0x73c7378, expr=expr@entry=0x0,
exprKind=exprKind@entry=EXPR_KIND_SELECT_TARGET, colname=0x0,
resjunk=resjunk@entry=false)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_target.c:103
#20 0x000000000053d40d in transformTargetList (pstate=pstate@entry=0x73c7618,
targetlist=<optimized out>,
exprKind=exprKind@entry=EXPR_KIND_SELECT_TARGET)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/parse_target.c:190
#21 0x0000000000500f22 in transformSelectStmt (stmt=0x73c7468,
pstate=0x73c7618)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/analyze.c:1232
#22 transformStmt (pstate=0x73c7618, parseTree=0x73c7468)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/analyze.c:301
#23 0x0000000000503223 in transformTopLevelStmt (parseTree=0x73c7580,
pstate=0x73c7618)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/analyze.c:196
#24 parse_analyze (parseTree=0x73c7580,
sourceText=0x73c67c8 "select '$ ? (@ like_regex \"pattern\" flag
\"a\")'::jsonpath;", paramTypes=0x0, numParams=0, queryEnv=queryEnv@entry=0x0)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/parser/analyze.c:116
#25 0x0000000000748094 in pg_analyze_and_rewrite (
parsetree=parsetree@entry=0x73c7580,
query_string=query_string@entry=0x73c67c8 "select '$ ? (@ like_regex
\"pattern\" flag \"a\")'::jsonpath;", paramTypes=paramTypes@entry=0x0,
numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:695
#26 0x00000000007487e3 in exec_simple_query (
query_string=0x73c67c8 "select '$ ? (@ like_regex \"pattern\" flag
\"a\")'::jsonpath;")
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:1140
#27 0x000000000074a06f in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x7356e80, dbname=<optimized out>,
username=<optimized out>)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:4247
#28 0x00000000006c61e3 in BackendRun (port=0x4b0f3f0, port=0x4b0f3f0)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:4399
#29 SubPostmasterMain (argc=argc@entry=3, argv=argv@entry=0x59b6070)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:4921
#30 0x00000000008d0d9a in main (argc=3, argv=0x59b6070)
at
c:/MinGW/msys/1.0/home/pgrunner/bf/root/HEAD/pgsql.build/../pgsql/src/backend/main/main.c:205
