Mariadb 10.11.17 doesn't work with Quote::markQuotesRecollect

[stp94]

Preconditions and environment

• version 2.4.7 -p10
• Mariadb 10.11.17

query from:
\Magento\Quote\Model\ResourceModel\Quote::markQuotesRecollect

UPDATE quote AS t1
INNER JOIN (SELECT quote_item.quote_id AS entity_id
FROM quote_item
WHERE (product_id IN ( '24442' ))
GROUP BY quote_id) AS t2
ON t1.entity_id = t2.entity_id
SET t1.trigger_recollect = 1,
t1.updated_at = t1.updated_at

This query return result:
Query 1 ERROR at Line 1: : Lost connection to MySQL server during query

on MariaDB 10.11.17, on 10.11.16 everything works fine. Testing on two environements.

Steps to reproduce

Example.
Upgrade MariaDB to 10.11.17
run query from \Magento\Quote\Model\ResourceModel\Quote::markQuotesRecollect
or run this method.

Expected result

Query should be executed with no problems.

Actual result

Query can't executed

Additional information

No response

Release note

No response

Triage and priority

• Severity: S0 - Affects critical data or functionality and leaves users without workaround.
• Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
• Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
• Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
• Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.

[m2-assistant]

Hi @stp94. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce.

• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this
• To learn more about issue processing workflow, refer to the Code Contributions.

---

Join Magento Community Engineering Slack and ask your questions in #github channel.
⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[github-jira-sync-bot]

✅ Jira issue https://jira.corp.adobe.com/browse/AC-17267 is successfully created for this GitHub issue.