Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6.1, 10.2.39, 10.3.30, 10.4.20, 10.5.11
-
None
Description
Simple table with two colums Type(varchar) and Point(point)
An index on Type(Tindex) and a spatial index on Point(Pindex)
Now a query like
SELECT X(Point) as x,Y(Point) as y,hotels.Type FROM hotels WHERE (Type in ("acco")) AND MBRContains( GeomFromText( 'LINESTRING(4.922 52.909,5.625 52.483)' ), hotels.Point) |
;
|
Results in a
Error in query (1207): Update locks cannot be acquired during a READ UNCOMMITTED transaction
While both
SELECT X(Point) as x,Y(Point) as y,hotels.Type FROM hotels USE INDEX (Pindex) WHERE (Type in ("acco")) AND MBRContains( GeomFromText( 'LINESTRING(4.922 52.909,5.625 52.483)' ), hotels.Point) |
;
|
and
SELECT X(Point) as x,Y(Point) as y,hotels.Type FROM hotels USE INDEX (Tindex) WHERE (Type in ("acco")) AND MBRContains( GeomFromText( 'LINESTRING(4.922 52.909,5.625 52.483)' ), hotels.Point) |
;
|
work fine. As mariadb 10.5.10 did
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | hotels | range | filter | Type,Pindex | Pindex | Type | 34 | 302 | NULL | 340 (4%) | Using where; Using rowid filter |
Attachments
Issue Links
- duplicates
-
MDEV-26204 Update locks cannot be acquired during a READ UNCOMMITTED transaction with SELECT
- Closed
- is caused by
-
MDEV-25594 Crash in deadlock checker under high load
- Closed
- links to