[postgis-tickets] [PostGIS] #4125: postgis 2.5 crashes with PG11 on Debian stretch/amd64

Sat Jul 21 12:40:37 PDT 2018

#4125: postgis 2.5 crashes with PG11 on Debian stretch/amd64
----------------------+---------------------------
  Reporter:  myon     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by komzpa):

 More symbols:
 {{{
 [Thread debugging using libthread_db enabled]
 Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
 Core was generated by `postgres: 11/main: root postgis_reg [local] SELECT
 '.
 Program terminated with signal SIGSEGV, Segmentation fault.
 #0  0x00007faedc0282de in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1

 Thread 1 (Thread 0x7faee2354900 (LWP 1276)):
 #0  0x00007faedc0282de in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1
 #1  0x00007faedc0287d9 in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1
 #2  0x00007faedc029076 in _Unwind_Find_FDE () from /lib/x86_64-linux-
 gnu/libgcc_s.so.1
 #3  0x00007faedc025b13 in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1
 #4  0x00007faedc026d30 in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1
 #5  0x00007faedc0271de in _Unwind_RaiseException () from /lib/x86_64
 -linux-gnu/libgcc_s.so.1
 #6  0x00007faedc2bd2bc in __cxa_throw () from /usr/lib/x86_64-linux-
 gnu/libstdc++.so.6
 #7  0x00007faecf2b1dbc in geos::geom::LinearRing::validateConstruction()
 () from /usr/lib/x86_64-linux-gnu/libgeos-3.5.1.so
 #8  0x00007faecf2b1f3b in
 geos::geom::LinearRing::LinearRing(geos::geom::CoordinateSequence*,
 geos::geom::GeometryFactory const*) () from /usr/lib/x86_64-linux-
 gnu/libgeos-3.5.1.so
 #9  0x00007faecf2af6f5 in
 geos::geom::GeometryFactory::createLinearRing(geos::geom::CoordinateSequence*)
 const () from /usr/lib/x86_64-linux-gnu/libgeos-3.5.1.so
 #10 0x00007faed0634a7a in GEOSGeom_createLinearRing_r () from
 /usr/lib/x86_64-linux-gnu/libgeos_c.so.1
 #11 0x00007faed08d9e00 in ptarray_to_GEOSLinearRing (autofix=<optimized
 out>, pa=<optimized out>) at lwgeom_geos.c:304
 #12 LWGEOM2GEOS (lwgeom=0x55967cde1de8, autofix=<optimized out>) at
 lwgeom_geos.c:426
 #13 0x00007faed08d9d09 in LWGEOM2GEOS (lwgeom=lwgeom at entry=0x55967cde1d80,
 autofix=autofix at entry=0 '\000') at lwgeom_geos.c:467
 #14 0x00007faed08722cd in isvalid (fcinfo=0x55967ce42350) at
 lwgeom_geos.c:1414
 #15 0x000055967ac52b11 in ExecInterpExpr (state=0x55967ce42270,
 econtext=0x55967ce42b70, isnull=<optimized out>) at
 ./build/../src/backend/executor/execExprInterp.c:678
 #16 0x000055967ad0a59b in ExecEvalExprSwitchContext
 (isNull=0x7ffed2780e74, econtext=<optimized out>, state=0x55967ce42270) at
 ./build/../src/include/executor/executor.h:303
 #17 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
 ./build/../src/backend/optimizer/util/clauses.c:4880
 #18 0x000055967ad0de83 in evaluate_function (context=0x7ffed27811f0,
 func_tuple=0x7faee22b1408, funcvariadic=false, args=0x55967ce49078,
 input_collid=0, result_collid=0, result_typmod=-1, result_type=16,
 funcid=79732) at ./build/../src/backend/optimizer/util/clauses.c:4422
 #19 simplify_function (funcid=79732, result_type=16, result_typmod=-1,
 result_collid=result_collid at entry=0, input_collid=input_collid at entry=0,
 args_p=args_p at entry=0x7ffed2781010, funcvariadic=false, process_args=true,
 allow_non_const=true, context=0x7ffed27811f0) at
 ./build/../src/backend/optimizer/util/clauses.c:4062
 #20 0x000055967ad0c9ea in eval_const_expressions_mutator
 (node=0x55967cd09fd0, context=0x7ffed27811f0) at
 ./build/../src/backend/optimizer/util/clauses.c:2674
 #21 0x000055967aca50cf in expression_tree_mutator
 (node=node at entry=0x55967ce47fd0, mutator=mutator at entry=0x55967ad0c740
 <eval_const_expressions_mutator>, context=context at entry=0x7ffed27811f0) at
 ./build/../src/backend/nodes/nodeFuncs.c:3033
 #22 0x000055967ad0c7a2 in eval_const_expressions_mutator
 (node=0x55967ce47fd0, context=0x7ffed27811f0) at
 ./build/../src/backend/optimizer/util/clauses.c:3669
 #23 0x000055967aca533b in expression_tree_mutator
 (node=node at entry=0x55967cd091f0, mutator=mutator at entry=0x55967ad0c740
 <eval_const_expressions_mutator>, context=context at entry=0x7ffed27811f0) at
 ./build/../src/backend/nodes/nodeFuncs.c:2914
 #24 0x000055967ad0c7a2 in eval_const_expressions_mutator
 (node=0x55967cd091f0, context=context at entry=0x7ffed27811f0) at
 ./build/../src/backend/optimizer/util/clauses.c:3669
 #25 0x000055967ad0dccf in eval_const_expressions
 (root=root at entry=0x55967cd09bc0, node=<optimized out>) at
 ./build/../src/backend/optimizer/util/clauses.c:2472
 #26 0x000055967acf5347 in preprocess_expression
 (root=root at entry=0x55967cd09bc0, expr=<optimized out>, kind=kind at entry=1)
 at ./build/../src/backend/optimizer/plan/planner.c:1041
 #27 0x000055967acfb98b in subquery_planner
 (glob=glob at entry=0x55967ce496c8, parse=parse at entry=0x55967cd09020,
 parent_root=parent_root at entry=0x0, hasRecursion=hasRecursion at entry=false,
 tuple_fraction=tuple_fraction at entry=0) at
 ./build/../src/backend/optimizer/plan/planner.c:732
 #28 0x000055967acfcca5 in standard_planner (parse=0x55967cd09020,
 cursorOptions=256, boundParams=<optimized out>) at
 ./build/../src/backend/optimizer/plan/planner.c:405
 #29 0x000055967ada7150 in pg_plan_query
 (querytree=querytree at entry=0x55967cd09020,
 cursorOptions=cursorOptions at entry=256, boundParams=boundParams at entry=0x0)
 at ./build/../src/backend/tcop/postgres.c:809
 #30 0x000055967ada7226 in pg_plan_queries (querytrees=<optimized out>,
 cursorOptions=cursorOptions at entry=256, boundParams=boundParams at entry=0x0)
 at ./build/../src/backend/tcop/postgres.c:875
 #31 0x000055967ada773e in exec_simple_query (query_string=0x55967cf74678
 "SELECT '#408.3',
 st_isvalid('0106000020BB0B000001000000010300000005000000D6", '0' <repeats
 12 times>,
 "C0F1A138410AD7A3103190524114AE4721F7A138410000000030905241713D0A57FAA1384185EB51982C9052417B14AE87FAA138410000004"...)
 at ./build/../src/backend/tcop/postgres.c:1050
 #32 0x000055967ada9473 in PostgresMain (argc=<optimized out>,
 argv=argv at entry=0x55967cd50208, dbname=<optimized out>,
 username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4153
 #33 0x000055967aab8910 in BackendRun (port=0x55967cd48770) at
 ./build/../src/backend/postmaster/postmaster.c:4361
 #34 BackendStartup (port=0x55967cd48770) at
 ./build/../src/backend/postmaster/postmaster.c:4033
 #35 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1706
 #36 0x000055967ad34ff3 in PostmasterMain (argc=5, argv=0x55967cd02e40) at
 ./build/../src/backend/postmaster/postmaster.c:1379
 #37 0x000055967aab9e04 in main (argc=5, argv=0x55967cd02e40) at
 ./build/../src/backend/main/main.c:228

 }}}

 Highly similar stacktrace I see in PG11 on travis, PR:
 https://github.com/postgis/postgis/pull/262

 Another thing I notice is that clang is used there to emit llvm code:
 {{{
 /usr/bin/clang-3.9 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv
 -O2  -I../liblwgeom -g -O1 -I../libpgcommon  -I/usr/include
 -I/usr/include/libxml2 -I/usr/include -DHAVE_SFCGAL    -fPIC
 -I/usr/include -DHAVE_SFCGAL -I. -I./ -I/usr/include/postgresql/11/server
 -I/usr/include/postgresql/internal -I/usr/include/x86_64-linux-gnu
 -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include
 /mit-krb5 -flto=thin -emit-llvm -c -o postgis_module.bc postgis_module.c
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4125#comment:6>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.