[MDEV-21191] MariaDB crashes executing SELECT request after upgrading to 10.4.10 Created: 2019-12-02  Updated: 2019-12-11  Resolved: 2019-12-11

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

Type: Bug Priority: Major
Reporter: David Le Borgne Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: crash, regression
Environment:

CentOS Linux release 7.7.1908
Linux 4.15.18-9-pve (x86_64)

Attachments: Text File MDEV-21191_EXPLAIN_SELECT.txt     Text File mariadb111_journal.txt    
Issue Links:
Problem/Incident
is caused by MDEV-16188 Use in-memory PK filters built from r... Closed

 Description   

We upgraded from MariaDB 10.3.20 to MariaDB 10.4.10 and everything went fine during the upgade. But since then, MariaDB systematically crashes when playing the following SELECT SQL request :

SELECT PV.*
 
FROM PROPVAL PV,
 
     PROPLIST PL
 
WHERE (PV.OBJIHM_CODE IS NULL OR PV.OBJIHM_CODE = 0)
 
AND   PV.PROPLIST_CODE = PL.PROPLIST_CODE
 
AND   PV.ZONEECR_CODE = 58298
 
ORDER BY PV.UNIVERS_CODE

If the SELECT clause is changed to SELECT PL.*, then the request executes without error.

 Comments   
Comment by Marko Mäkelä [ 2019-12-02 ]

dleborgne, can you please show the EXPLAIN SELECT? I wonder if this report could duplicate MDEV-19919, whose fix will be present in 10.4.11.

Comment by David Le Borgne [ 2019-12-02 ]

Please find enclosed the EXPLAIN SELECT

Comment by Marko Mäkelä [ 2019-12-02 ]

Because MDEV-21191_EXPLAIN_SELECT.txt says ref|filter, this bug must have been caused by MDEV-16188.
igor should be able to tell whether this bug might already have been fixed in the upcoming 10.4.11.
dleborgne, you could try to install a recent 10.4 development snapshot and report whether it works with that. (Note: not for production environment!)

Comment by Igor Babaev [ 2019-12-02 ]

David,
I can't claim that I've fixed the bug without a test case.

Comment by David Le Borgne [ 2019-12-03 ]

After upgrading to 10.4 build 29736, I can confirm that the problem is fixed.
Thanks for your time !

Comment by Marko Mäkelä [ 2019-12-11 ]

Build 29736 corresponds to source code revision 0b8b11b0b15f2d3d20dc801e50fa2beedc080dad from December 2.
Thank you for testing it, dleborgne!

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