Changes between Initial Version and Version 1 of Ticket #5586


Ignore:
Timestamp:
10/23/23 01:55:35 (13 months ago)
Author:
Wenjing
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5586 – Description

    initial v1  
    1 
    21{{{
    32DROP TABLE IF EXISTS t;
    … …  
    76SELECT * FROM t As a1 JOIN t As a2 ON ST_Intersects(a1.geom, a2.geom);
    87
    9 ERROR INFO:
    10 -- psql:script/simplify.sql:7: server closed the connection unexpectedly
    11 -- This probably means the server terminated abnormally
    12 -- before or while processing the request.
    13 -- psql:script/simplify.sql:7: error: connection to server was lost
    148}}}
     9stack trace:
    1510
    16 It could be ST_Boundary makes the boundary of POINT(0 0) be 'EMPTY' instead of POINT EMPTY, resulting in this crash.
     11{{{
     12Program received signal SIGSEGV, Segmentation fault.
     130x00007fc000d0cf4c in ?? () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     14(gdb) bt
     15#0  0x00007fc000d0cf4c in ?? () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     16#1  0x00007fc000d34f22 in geos::algorithm::PointLocator::computeLocation(geos::geom::Coordinate const&, geos::geom::Geometry const*) () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     17#2  0x00007fc000d35078 in geos::algorithm::PointLocator::computeLocation(geos::geom::Coordinate const&, geos::geom::Geometry const*) () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     18#3  0x00007fc000d35209 in geos::algorithm::PointLocator::locate(geos::geom::Coordinate const&, geos::geom::Geometry const*) () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     19#4  0x00007fc000d53aed in geos::geom::prep::BasicPreparedGeometry::isAnyTargetComponentInTest(geos::geom::Geometry const*) const () from /lib/x86_64-linux-gnu/libgeos.so.3.10.2
     20#5  0x00007fc00142c15c in GEOSPreparedIntersects_r () from /lib/x86_64-linux-gnu/libgeos_c.so.1
     21#6  0x00007fc001488f74 in ST_Intersects (fcinfo=0x55d8585cbaf0) at lwgeom_geos.c:2458
     22#7  0x000055d8577d57e2 in ExecInterpExpr (state=0x55d8585cb618, econtext=0x55d8585ca580, isnull=0x7ffd0c310a6f)
     23    at execExprInterp.c:758
     24#8  0x000055d85782ad25 in ExecEvalExprSwitchContext (state=0x55d8585cb618, econtext=0x55d8585ca580,
     25    isNull=0x7ffd0c310a6f) at ../../../src/include/executor/executor.h:355
     26#9  0x000055d85782ae24 in ExecQual (state=0x55d8585cb618, econtext=0x55d8585ca580)
     27    at ../../../src/include/executor/executor.h:424
     28#10 0x000055d85782b15c in ExecNestLoop (pstate=0x55d8585ca478) at nodeNestloop.c:214
     29#11 0x000055d8577e13c3 in ExecProcNode (node=0x55d8585ca478) at ../../../src/include/executor/executor.h:273
     30#12 0x000055d8577e3cf0 in ExecutePlan (estate=0x55d8585ca248, planstate=0x55d8585ca478, use_parallel_mode=false,
     31    operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x55d85899c1f0,
     32    execute_once=true) at execMain.c:1670
     33--Type <RET> for more, q to quit, c to continue without paging--
     34#13 0x000055d8577e1957 in standard_ExecutorRun (queryDesc=0x55d8589949c8, direction=ForwardScanDirection, count=0,
     35    execute_once=true) at execMain.c:365
     36#14 0x000055d8577e17de in ExecutorRun (queryDesc=0x55d8589949c8, direction=ForwardScanDirection, count=0,
     37    execute_once=true) at execMain.c:309
     38#15 0x000055d857a69ce0 in PortalRunSelect (portal=0x55d8585758c8, forward=true, count=0, dest=0x55d85899c1f0)
     39    at pquery.c:924
     40#16 0x000055d857a69942 in PortalRun (portal=0x55d8585758c8, count=9223372036854775807, isTopLevel=true,
     41    run_once=true, dest=0x55d85899c1f0, altdest=0x55d85899c1f0, qc=0x7ffd0c310ea0) at pquery.c:768
     42#17 0x000055d857a62d1b in exec_simple_query (
     43    query_string=0x55d8584f5ea8 "SELECT * FROM t As a1 JOIN t As a2 ON ST_Intersects(a1.geom, a2.geom);")
     44    at postgres.c:1273
     45#18 0x000055d857a67a2b in PostgresMain (dbname=0x55d85852f868 "postgres", username=0x55d85852f850 "postgres")
     46    at postgres.c:4657
     47#19 0x000055d8579a003f in BackendRun (port=0x55d8585223a0) at postmaster.c:4423
     48#20 0x000055d85799f684 in BackendStartup (port=0x55d8585223a0) at postmaster.c:4108
     49#21 0x000055d85799c00d in ServerLoop () at postmaster.c:1767
     50#22 0x000055d85799b90f in PostmasterMain (argc=3, argv=0x55d8584ef7a0) at postmaster.c:1466
     51#23 0x000055d85786019b in main (argc=3, argv=0x55d8584ef7a0) at main.c:198
     52}}}