782703 – dev-db/mariadb-10.5.9-r4 crashes with very large IN() lists

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

Importance:	Normal critical (vote)
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)
CC List:	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.