Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 782703 - dev-db/mariadb-10.5.9-r4 crashes with very large IN() lists
Summary: dev-db/mariadb-10.5.9-r4 crashes with very large IN() lists
Status: RESOLVED TEST-REQUEST
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal critical
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords: PATCH
Depends on:
Blocks:
 
Reported: 2021-04-13 18:50 UTC by Erik Dannenberg
Modified: 2021-05-18 15:10 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Erik Dannenberg 2021-04-13 18:50:36 UTC 
After upgrading to 10.5.9-r4 we got a hard db crash with a cron job. Apparently a regression in 10.5.9, see:

https://jira.mariadb.org/browse/MDEV-24953?focusedCommentId=180678&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel

The mentioned config workaround worked for us, we did not try the patch file:

http://lists.askmonty.org/pipermail/commits/2021-February/014481.html

Reproducible: Always
Comment 1 Larry the Git Cow gentoo-dev 2021-04-14 14:47:05 UTC 
The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=d0a5513049e8323a50d1798525e677056832e81b

commit d0a5513049e8323a50d1798525e677056832e81b
Author:     Thomas Deutschmann <whissi@gentoo.org>
AuthorDate: 2021-04-14 14:46:49 +0000
Commit:     Thomas Deutschmann <whissi@gentoo.org>
CommitDate: 2021-04-14 14:46:58 +0000

    dev-db/mariadb: update patch set
    
    Bug: https://bugs.gentoo.org/782703
    Bug: https://bugs.gentoo.org/782796
    Package-Manager: Portage-3.0.18, Repoman-3.0.3
    Signed-off-by: Thomas Deutschmann <whissi@gentoo.org>

 dev-db/mariadb/Manifest                 |    1 +
 dev-db/mariadb/mariadb-10.5.9-r5.ebuild | 1294 +++++++++++++++++++++++++++++++
 2 files changed, 1295 insertions(+)
Comment 2 Thomas Deutschmann (RETIRED) gentoo-dev 2021-04-14 14:48:25 UTC 
Could you please confirm if >=dev-db/mariadb-10.5.9-r5 works for you?
Comment 3 Erik Dannenberg 2021-05-18 15:10:37 UTC 
Sorry for the delay, just had a chance to test it with mariadb-10.5.9-r5 and the issue seems to be resolved.