Bug #109129 MySql Server crashing when using temp table with spatial index
Submitted: 17 Nov 2022 20:25 Modified: 18 Nov 2022 15:47
Reporter: Fabio Schett Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:8.0.31 OS:Ubuntu (22.04 5.15.0-52-generic)
Assigned to: CPU Architecture:x86

[17 Nov 2022 20:25] Fabio Schett
I call a STORED PROCEDURE which is creating a temporary table with spatial index on datatype POINT. It consumes data within a timeframe of 15 Minutes and is doing some calculation for stats.

the procedure crashes MySQL Server completely, see logs.

How to repeat:
It's repeatable with the provided files in attachment uploaded to sftp.oracle.com

including instructions to repeat use case

Suggested fix:
Stop/Cancel Procedure. or do it like MariaDB, which won't shutdown database.
[17 Nov 2022 20:35] Fabio Schett
uploaded repeatable scripts to sftp
[18 Nov 2022 15:47] MySQL Verification Team
Ni Mr. Schett,

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

You have already submitted your report here:


Thank you for your interest in MySQL.