[MDEV-2272] LP:809849 - spatial operations must be KILL-able Created: 2011-07-13  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug809849.xml    

 Description   

Spatial operations can be very CPU intensive, and they are not killable using KILL if they do not use any table rows. This causes the following problems:

  • The RQG can not terminate randomly-generated spatial expressions that take too long to calculate, causing the test to block until the expression is calculated;
  • It is possible to DoS a server using a spatial expression. No table or update rights are required – just the ability to connect to the server are required;
  • trying to work around the limitations of SQL and the OpenGIS model via application-side logic or CONCAT tricks may produce a query that does not use any tables and is thus unkillable.


 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 809849

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