[MDEV-24002] MySQL server has gone away in new mariadb versions Created: 2020-10-21  Updated: 2020-11-24  Resolved: 2020-11-24

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - CTE
Affects Version/s: 10.4.15, 10.5.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Remy Fox Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback

Attachments: File DESKTOP-S66QO6U.err    

 Description   

We have a query with a recursive CTE that used to work correctly in the previous version 10.4.10. We decided to upgrade, but MariaDB crashes on this query on both 10.4.15 and 10.5.6. As far as I know, server variables have remained the same.

If I can produce a better error report, let me know.

 Comments   
Comment by Elena Stepanova [ 2020-10-21 ]

Please paste the query and the output of

SHOW CREATE TABLE ...;
 
SHOW INDEX IN ...;

for all tables involved in the query. If any of them are views, then for underlying tables as well.
Thanks.

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