[MDEV-18920] Prepared statements with st_convexhull hang and eat 100% cpu Created: 2019-03-13  Updated: 2019-04-22  Resolved: 2019-04-22

Status: Closed
Project: MariaDB Server
Component/s: GIS, Prepared Statements
Affects Version/s: 10.1, 10.3.13, 10.2, 10.3, 10.4
Fix Version/s: 10.1.39

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None
Environment:

WinX64


 Description   

Prepared statements with st_convexhull hang and eat 100% cpu

*************************** 6. row ***************************
 
      Id: 9
 
    User: root
 
    Host: localhost:7859
 
      db: test
 
 Command: Query
 
    Time: 69
 
   State: NULL
 
    Info: do st_convexhull(st_aswkb(multipoint(point(-11702,15179),point(-5031,27960),point(-30557,11158),point(-27804,30314))))
 
Progress: 0.000

*Testcase
---------*

prepare s from 'do st_convexhull(st_aswkb(multipoint(point(-11702,15179),point(-5031,27960),point(-30557,11158),point(-27804,30314))))';
 
execute s;
 
execute s;



 Comments   
Comment by Elena Stepanova [ 2019-03-13 ]

Thanks for the report and test case.

Comment by Alexey Botchkov [ 2019-04-22 ]

http://lists.askmonty.org/pipermail/commits/2019-April/013665.html

Generated at Thu Feb 08 08:47:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.