[MDEV-26204] Update locks cannot be acquired during a READ UNCOMMITTED transaction with SELECT Created: 2021-07-21  Updated: 2021-08-23  Resolved: 2021-08-23

Status: Closed
Project: MariaDB Server
Component/s: GIS, Storage Engine - InnoDB
Affects Version/s: 10.3.30
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Richard H Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu 18.04

Attachments: File test-case.sql    
Issue Links:
Duplicate
is duplicated by MDEV-26123 Using Spatial Indexes results in Upda... Stalled

 Description   

After upgrading from 10.3.29 to 10.3.30 we started hitting "Update locks cannot be acquired during a READ UNCOMMITTED transaction" errors which did not occur in previous versions.

Recreate test case DB with the attached test-case.sql and perform this query:

SELECT * FROM polygonassets p WHERE ST_Contains(p.shape, (SELECT point FROM pointassets WHERE id = 0x000007158cce4a99950bb6589b31ab1b));

This will result in:

ERROR 1207 (25000): Update locks cannot be acquired during a READ UNCOMMITTED transaction

Might be related to MDEV-26123?

 Comments   
Comment by Marko Mäkelä [ 2021-07-21 ]

This report is a duplicate of MDEV-26123. The fix MDEV-25594 first appeared in MariaDB Server 10.2.39, 10.3.30, 10.4.20, 10.5.11, 10.6.1.

Generated at Thu Feb 08 09:43:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.