Re: pgsql: ICU support

On 03/23/2017 04:07 PM, Peter Eisentraut wrote:
> On 3/23/17 15:33, Peter Eisentraut wrote:
>> ICU support
> Seeing some crashes on the build farm, investigating. If someone can
> reproduce locally and get a backtrace, let me know.
>

The buildfarm actually does that :-)

See for example
<https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2017-03-23%2019%3A37%3A22>
which has stuff like:

Program terminated with signal SIGSEGV, Segmentation fault.
#0 Generic_Text_IC_like (collation=100, pat=0x10cf3f8, str=0x10cf388) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/like.c:197
197 if (pg_database_encoding_max_length() > 1 || locale->provider == COLLPROVIDER_ICU)
#0 Generic_Text_IC_like (collation=100, pat=0x10cf3f8, str=0x10cf388) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/like.c:197
#1 texticlike (fcinfo=<optimized out>) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/like.c:394
#2 0x00000000005db832 in ExecMakeFunctionResultNoSets (fcache=0x106af48, econtext=0x106b828, isNull=0x7fff5884877c "") at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/executor/execQual.c:1866
#3 0x00000000005dfe76 in ExecEvalExprSwitchContext (expression=expression(at)entry=0x106af48, econtext=<optimized out>, isNull=isNull(at)entry=0x7fff5884877c "") at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/executor/execQual.c:4228
#4 0x0000000000671d29 in evaluate_expr (expr=<optimized out>, result_type=result_type(at)entry=16, result_typmod=result_typmod(at)entry=-1, result_collation=result_collation(at)entry=0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:4680
#5 0x00000000006732ab in evaluate_function (context=0x7fff58848aa0, func_tuple=0x7fb799a56048, funcvariadic=0 '\000', args=0x10cf8a0, input_collid=100, result_collid=0, result_typmod=-1, result_type=16, funcid=1633) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:4237
#6 simplify_function (funcid=1633, result_type=16, result_typmod=result_typmod(at)entry=-1, result_collid=0, input_collid=100, args_p=args_p(at)entry=0x7fff588488f8, funcvariadic=0 '\000', process_args=1 '\001', allow_non_const=1 '\001', context=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:3877
#7 0x0000000000673b4a in eval_const_expressions_mutator (node=0x10cf410, context=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:2584
#8 0x0000000000619be7 in expression_tree_mutator (node=node(at)entry=0x10cf460, mutator=mutator(at)entry=0x673a10 <eval_const_expressions_mutator>, context=context(at)entry=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/nodes/nodeFuncs.c:3017
#9 0x0000000000673a50 in eval_const_expressions_mutator (node=0x10cf460, context=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:3527
#10 0x0000000000619e4b in expression_tree_mutator (node=node(at)entry=0x10cf4b0, mutator=mutator(at)entry=0x673a10 <eval_const_expressions_mutator>, context=context(at)entry=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/nodes/nodeFuncs.c:2912
#11 0x0000000000673a50 in eval_const_expressions_mutator (node=0x10cf4b0, context=context(at)entry=0x7fff58848aa0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:3527
#12 0x000000000067574f in eval_const_expressions (root=root(at)entry=0x10cf5d0, node=<optimized out>) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:2378
#13 0x0000000000660d95 in preprocess_expression (root=root(at)entry=0x10cf5d0, expr=<optimized out>, kind=kind(at)entry=1) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/plan/planner.c:880
#14 0x000000000066519d in subquery_planner (glob=glob(at)entry=0x10cf198, parse=parse(at)entry=0x10cec38, parent_root=parent_root(at)entry=0x0, hasRecursion=hasRecursion(at)entry=0 '\000', tuple_fraction=tuple_fraction(at)entry=0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/plan/planner.c:593
#15 0x0000000000666321 in standard_planner (parse=0x10cec38, cursorOptions=256, boundParams=<optimized out>) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/optimizer/plan/planner.c:306
#16 0x00000000006efeec in pg_plan_query (querytree=querytree(at)entry=0x10cec38, cursorOptions=cursorOptions(at)entry=256, boundParams=boundParams(at)entry=0x0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:798
#17 0x00000000006effce in pg_plan_queries (querytrees=<optimized out>, cursorOptions=cursorOptions(at)entry=256, boundParams=boundParams(at)entry=0x0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:864
#18 0x00000000006f0467 in exec_simple_query (query_string=0x10cdd68 "SELECT 'hawkeye' ILIKE 'h%' AS \"true\";") at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:1029
#19 0x00000000006f17cb in PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x10784a0, dbname=0x1078298 "regression", username=<optimized out>) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:4071
#20 0x0000000000478ce0 in BackendRun (port=0x1073670) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:4317
#21 BackendStartup (port=0x1073670) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:3989
#22 ServerLoop () at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:1729
#23 0x00000000006907f7 in PostmasterMain (argc=argc(at)entry=8, argv=argv(at)entry=0x104c6e0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:1337
#24 0x0000000000479e98 in main (argc=8, argv=0x104c6e0) at /home/bf/bfr/root/HEAD/pgsql.build/../pgsql/src/backend/main/main.c:228

cheers

andrew

--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services