MySQL Bugs: #116537: mysqld crashing with signal 8 in Item_func_mul::real

Bug #116537	mysqld crashing with signal 8 in Item_func_mul::real_op()+0x77
Submitted:	4 Nov 2024 13:40	Modified:	4 Nov 2024 13:57
Reporter:	Thomas Tampe	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.36	OS:	Ubuntu
Assigned to:		CPU Architecture:	x86

Description:
We encountered two crashes of mysqld in the last two weeks:

2024-10-16T13:50:01Z UTC - mysqld got signal 8 ;
2024-10-30T07:51:52Z UTC - mysqld got signal 8 ;

Both stack traces contain as the top entry
/usr/sbin/mysqld(Item_func_mul::real_op()+0x77)

(full stacktraces will follow)

In both cases the server recovered.

How to repeat:
Cannot.

Hi Mr. Tampe,

Thank you for your bug report.

However, let us inform you that this is a forum, ONLY for the reports with fully repeatable test cases.

Each of those test cases should consist of the set of SQL statements, that always lead to the problem that you reported, which is a crash.

Without a described test case, we can not proceed with the processing of your bug report.

Can't repeat.

crash seems related to a multiplication op in the stored procedure

CREATE DEFINER=`debian-sys-maint`@`localhost` PROCEDURE `GetPlaces`(
    IN lat DOUBLE,
    IN lon DOUBLE,
    IN radius INT,
    IN groupid INT
    )
BEGIN
    SELECT p.*, 
        IFNULL((6371000*
            acos(cos(radians(lat))*
                 cos(radians(latitude))*
                 cos(radians(longitude)-radians(lon)) +
                 sin(radians(lat))*
                 sin(radians(latitude)))),
            radius+1) AS distance 
    FROM customerplaces p
    WHERE parent_group = groupid 
    HAVING distance < radius
    ;
END