[MDEV-36343] UBSAN: Index_statistics - runtime error: -nan is outside the range of representable values of type 'unsigned long long' - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 10.11, 11.4, 11.8, 12.0
Fix Version/s: 10.5, 10.6, 10.11, 11.4, 11.8
Component/s: Optimizer
Labels:
Environment:
clang-20.1 or clang-18.1

Description

10.6 - main.update_innodb test
CURRENT_TEST: main.update_innodb
/source/sql/sql_statistics.h:482:35: runtime error: -nan is outside the range of representable values of type 'unsigned long long'
#0 0x557ebdd41d4a in Index_statistics::set_avg_frequency(unsigned int, double) /source/sql/sql_statistics.h:482:35
#1 0x557ebdd41d4a in read_statistics_for_table(THD, TABLE, TABLE_LIST*, bool, bool) /source/sql/sql_statistics.cc:3031:24
#2 0x557ebdd41d4a in read_statistics_for_tables(THD, TABLE_LIST, bool) /source/sql/sql_statistics.cc:3236:23
#3 0x557ebde63154 in mysql_multi_update_prepare(THD*) /source/sql/sql_update.cc:1939:10
#4 0x557ebda6d777 in mysql_execute_command(THD*, bool) /source/sql/sql_parse.cc:4520:10
#5 0x557ebda4dab6 in mysql_parse(THD, char, unsigned int, Parser_state*) /source/sql/sql_parse.cc:8209:18
#6 0x557ebda45d5b in dispatch_command(enum_server_command, THD, char, unsigned int, bool) /source/sql/sql_parse.cc:1908:7
#7 0x557ebda4fa1b in do_command(THD*, bool) /source/sql/sql_parse.cc:1421:17
#8 0x557ebdfcf94c in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1386:11
#9 0x557ebdfcf2d2 in handle_one_connection /source/sql/sql_connect.cc:1298:5
#10 0x557ebd603476 in asan_thread_start(void*) asan_interceptors.cpp.o
#11 0x7f46877e61c3 (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)
#12 0x7f468786685b (/lib/x86_64-linux-gnu/libc.so.6+0x10985b) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)

Attachments

Issue Links

is part of

MDEV-25454 Make MariaDB server UBSAN safe

Confirmed

relates to

MDEV-35721 UBSAN: runtime error: -nan is outside the range of representable values of type 'unsigned long long' in Index_statistics::set_avg_frequency on INSERT or SHOW INDEX

In Review

Activity

Ascending order - Click to sort in descending order

Daniel Black created issue - 4 days ago

Daniel Black made changes - 4 days ago

Field	Original Value	New Value
Link		This issue is part of MDEV-25454 [ MDEV-25454 ]

Roel Van de Paar made changes - Yesterday

Labels

UBSAN beginner-friendly

UBSAN beginner-friendly float-cast-overflow

Roel Van de Paar made changes - Yesterday

Environment

clang-20.1

clang-20.1 or clang-18.1

Roel Van de Paar added a comment - Yesterday

Confirmed. Trace with error type report:

export UBSAN_OPTIONS=suppressions=${HOME}/mariadb-qa/UBSAN.filter:print_stacktrace=1:report_error_type=1

CS 10.6.22 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 (Debug, UBASAN) Build 15/02/2025
/test/10.6_dbg_san/sql/sql_statistics.h:482:35: runtime error: -nan is outside the range of representable values of type 'unsigned long long'
#0 0x5612eaa3f269 in Index_statistics::set_avg_frequency(unsigned int, double) /test/10.6_dbg_san/sql/sql_statistics.h:482:35
#1 0x5612eaa3f269 in read_statistics_for_table(THD, TABLE, TABLE_LIST*, bool, bool) /test/10.6_dbg_san/sql/sql_statistics.cc:3031:24
#2 0x5612eaa3f269 in read_statistics_for_tables(THD, TABLE_LIST, bool) /test/10.6_dbg_san/sql/sql_statistics.cc:3236:23
#3 0x5612eab870fd in mysql_multi_update_prepare(THD*) /test/10.6_dbg_san/sql/sql_update.cc:1939:10
#4 0x5612ea720175 in mysql_execute_command(THD*, bool) /test/10.6_dbg_san/sql/sql_parse.cc:4520:10
#5 0x5612ea6e2b28 in mysql_parse(THD, char, unsigned int, Parser_state*) /test/10.6_dbg_san/sql/sql_parse.cc:8209:18
#6 0x5612ea6d6db4 in dispatch_command(enum_server_command, THD, char, unsigned int, bool) /test/10.6_dbg_san/sql/sql_parse.cc:1908:7
#7 0x5612ea6e554d in do_command(THD*, bool) /test/10.6_dbg_san/sql/sql_parse.cc:1421:17
#8 0x5612ead2c6ec in do_handle_one_connection(CONNECT*, bool) /test/10.6_dbg_san/sql/sql_connect.cc:1386:11
#9 0x5612ead2bfab in handle_one_connection /test/10.6_dbg_san/sql/sql_connect.cc:1298:5
#10 0x5612ea1ec3ac in asan_thread_start(void*) asan_interceptors.cpp.o
#11 0x14b15109ca93 in start_thread nptl/pthread_create.c:447:8
#12 0x14b151129c3b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

SUMMARY: UndefinedBehaviorSanitizer: float-cast-overflow /test/10.6_dbg_san/sql/sql_statistics.h:482:35

Roel Van de Paar added a comment - Yesterday Confirmed. Trace with error type report: export UBSAN_OPTIONS=suppressions=${HOME} /mariadb-qa/UBSAN .filter:print_stacktrace=1:report_error_type=1 CS 10.6.22 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 (Debug, UBASAN) Build 15/02/2025 /test/10.6_dbg_san/sql/sql_statistics.h:482:35: runtime error: -nan is outside the range of representable values of type 'unsigned long long' #0 0x5612eaa3f269 in Index_statistics::set_avg_frequency(unsigned int, double) /test/10.6_dbg_san/sql/sql_statistics.h:482:35 #1 0x5612eaa3f269 in read_statistics_for_table(THD*, TABLE*, TABLE_LIST*, bool, bool) /test/10.6_dbg_san/sql/sql_statistics.cc:3031:24 #2 0x5612eaa3f269 in read_statistics_for_tables(THD*, TABLE_LIST*, bool) /test/10.6_dbg_san/sql/sql_statistics.cc:3236:23 #3 0x5612eab870fd in mysql_multi_update_prepare(THD*) /test/10.6_dbg_san/sql/sql_update.cc:1939:10 #4 0x5612ea720175 in mysql_execute_command(THD*, bool) /test/10.6_dbg_san/sql/sql_parse.cc:4520:10 #5 0x5612ea6e2b28 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /test/10.6_dbg_san/sql/sql_parse.cc:8209:18 #6 0x5612ea6d6db4 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /test/10.6_dbg_san/sql/sql_parse.cc:1908:7 #7 0x5612ea6e554d in do_command(THD*, bool) /test/10.6_dbg_san/sql/sql_parse.cc:1421:17 #8 0x5612ead2c6ec in do_handle_one_connection(CONNECT*, bool) /test/10.6_dbg_san/sql/sql_connect.cc:1386:11 #9 0x5612ead2bfab in handle_one_connection /test/10.6_dbg_san/sql/sql_connect.cc:1298:5 #10 0x5612ea1ec3ac in asan_thread_start(void*) asan_interceptors.cpp.o #11 0x14b15109ca93 in start_thread nptl/pthread_create.c:447:8 #12 0x14b151129c3b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:78 SUMMARY: UndefinedBehaviorSanitizer: float-cast-overflow /test/10.6_dbg_san/sql/sql_statistics.h:482:35

Roel Van de Paar made changes - Yesterday

Status

Open [ 1 ]

Confirmed [ 10101 ]

Roel Van de Paar added a comment - Yesterday

ES all versions affected also.

Roel Van de Paar added a comment - Yesterday ES all versions affected also.

Roel Van de Paar made changes - Yesterday

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.4 [ 29301 ]
Fix Version/s		11.8 [ 29921 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.4 [ 29301 ]
Affects Version/s		11.8 [ 29921 ]
Affects Version/s		12.0 [ 29945 ]
Affects Version/s	10.6.21 [ 29953 ]
Description	{noformat:title=10.6 - main.update_innodb test} CURRENT_TEST: main.update_innodb /source/sql/sql_statistics.h:482:35: runtime error: -nan is outside the range of representable values of type 'unsigned long long' #0 0x557ebdd41d4a in Index_statistics::set_avg_frequency(unsigned int, double) /source/sql/sql_statistics.h:482:35 #1 0x557ebdd41d4a in read_statistics_for_table(THD, TABLE, TABLE_LIST, bool, bool) /source/sql/sql_statistics.cc:3031:24 #2 0x557ebdd41d4a in read_statistics_for_tables(THD, TABLE_LIST, bool) /source/sql/sql_statistics.cc:3236:23 #3 0x557ebde63154 in mysql_multi_update_prepare(THD) /source/sql/sql_update.cc:1939:10 #4 0x557ebda6d777 in mysql_execute_command(THD, bool) /source/sql/sql_parse.cc:4520:10 #5 0x557ebda4dab6 in mysql_parse(THD, char, unsigned int, Parser_state) /source/sql/sql_parse.cc:8209:18 #6 0x557ebda45d5b in dispatch_command(enum_server_command, THD, char, unsigned int, bool) /source/sql/sql_parse.cc:1908:7 #7 0x557ebda4fa1b in do_command(THD, bool) /source/sql/sql_parse.cc:1421:17 #8 0x557ebdfcf94c in do_handle_one_connection(CONNECT, bool) /source/sql/sql_connect.cc:1386:11 #9 0x557ebdfcf2d2 in handle_one_connection /source/sql/sql_connect.cc:1298:5 #10 0x557ebd603476 in asan_thread_start(void*) asan_interceptors.cpp.o #11 0x7f46877e61c3 (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8) #12 0x7f468786685b (/lib/x86_64-linux-gnu/libc.so.6+0x10985b) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8) {noformat}	{noformat:title=10.6 - main.update_innodb test} CURRENT_TEST: main.update_innodb /source/sql/sql_statistics.h:482:35: runtime error: -nan is outside the range of representable values of type 'unsigned long long' #0 0x557ebdd41d4a in Index_statistics::set_avg_frequency(unsigned int, double) /source/sql/sql_statistics.h:482:35 #1 0x557ebdd41d4a in read_statistics_for_table(THD, TABLE, TABLE_LIST, bool, bool) /source/sql/sql_statistics.cc:3031:24 #2 0x557ebdd41d4a in read_statistics_for_tables(THD, TABLE_LIST, bool) /source/sql/sql_statistics.cc:3236:23 #3 0x557ebde63154 in mysql_multi_update_prepare(THD) /source/sql/sql_update.cc:1939:10 #4 0x557ebda6d777 in mysql_execute_command(THD, bool) /source/sql/sql_parse.cc:4520:10 #5 0x557ebda4dab6 in mysql_parse(THD, char, unsigned int, Parser_state) /source/sql/sql_parse.cc:8209:18 #6 0x557ebda45d5b in dispatch_command(enum_server_command, THD, char, unsigned int, bool) /source/sql/sql_parse.cc:1908:7 #7 0x557ebda4fa1b in do_command(THD, bool) /source/sql/sql_parse.cc:1421:17 #8 0x557ebdfcf94c in do_handle_one_connection(CONNECT, bool) /source/sql/sql_connect.cc:1386:11 #9 0x557ebdfcf2d2 in handle_one_connection /source/sql/sql_connect.cc:1298:5 #10 0x557ebd603476 in asan_thread_start(void*) asan_interceptors.cpp.o #11 0x7f46877e61c3 (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8) #12 0x7f468786685b (/lib/x86_64-linux-gnu/libc.so.6+0x10985b) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8) {noformat}

Roel Van de Paar made changes - Yesterday

Link

This issue relates to MDEV-35721 [ MDEV-35721 ]

Roel Van de Paar added a comment - Yesterday

Also see MDEV-35721

Roel Van de Paar added a comment - Yesterday Also see MDEV-35721

People

Assignee:: Unassigned

Reporter:: Daniel Black

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 4 days ago 05:02

Updated:: Yesterday 05:25

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration