Bug #79249 | main.group_min_max fails under Valgrind | ||
---|---|---|---|
Submitted: | 12 Nov 2015 12:45 | Modified: | 27 Nov 2015 13:49 |
Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.6.27 | OS: | Ubuntu (15.10) |
Assigned to: | CPU Architecture: | Any |
[12 Nov 2015 12:45]
Laurynas Biveinis
[12 Nov 2015 13:35]
MySQL Verification Team
miguel@ubuntu1510:~/mysql-5.6.27/mysql-test$ ./mtr --debug-server --valgrind group_min_max --valgrind-option=--track-origins=yes Logging: ./mtr --debug-server --valgrind group_min_max --valgrind-option=--track-origins=yes 2015-11-12 11:32:35 0 [Note] /home/miguel/mysql-5.6.27/sql/mysqld-debug (mysqld 5.6.27-debug) starting as process 16634 ... 2015-11-12 11:32:35 16634 [Note] Plugin 'FEDERATED' is disabled. 2015-11-12 11:32:35 16634 [Note] Binlog end 2015-11-12 11:32:35 16634 [Note] Shutting down plugin 'CSV' 2015-11-12 11:32:35 16634 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.27 Turning on valgrind for all executables Running valgrind with options " --track-origins=yes " Turning off --check-testcases to save time when valgrinding Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/home/miguel/mysql-5.6.27/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.group_min_max [ fail ] Found warnings/errors in server log file! Test ended at 2015-11-12 11:34:23 line ==16660== Thread 18: ==16660== Conditional jump or move depends on uninitialised value(s) ==16660== at 0x4C31D52: __memcmp_sse4_1 (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so) ==16660== by 0x9AFE86: QUICK_GROUP_MIN_MAX_SELECT::add_range(SEL_ARG*) (opt_range.cc:12876) ==16660== by 0x9AF498: TRP_GROUP_MIN_MAX::make_quick(PARAM*, bool, st_mem_root*) (opt_range.cc:12635) ==16660== by 0x9983EA: SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, st_order::enum_order) (opt_range.cc:2971) ==16660== by 0x9FD49D: get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long) (sql_optimizer.cc:3983) ==16660== by 0x9FC732: make_join_statistics(JOIN*, TABLE_LIST*, Item*, Mem_root_array<Key_use, true>*, bool) (sql_optimizer.cc:3694) ==16660== by 0x9F34D7: JOIN::optimize() (sql_optimizer.cc:363) ==16660== by 0x834260: mysql_execute_select(THD*, st_select_lex*, bool) (sql_select.cc:1086) ==16660== by 0x8345EA: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, SQL_I_List<st_order>*, SQL_I_List<st_order>*, Item*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:1221) ==16660== by 0x986D93: mysql_explain_unit(THD*, st_select_lex_unit*, select_result*) (opt_explain.cc:2132) ==16660== by 0x98695C: explain_query_expression(THD*, select_result*) (opt_explain.cc:2034) ==16660== by 0x807FD1: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5119) ==16660== by 0x800B40: mysql_execute_command(THD*) (sql_parse.cc:2656) ==16660== by 0x80AE5C: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6386) ==16660== by 0x7FD97B: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1340) ==16660== by 0x7FC9B8: do_command(THD*) (sql_parse.cc:1037)
[12 Nov 2015 14:12]
MySQL Verification Team
Thank you for the bug report. Repeatable on Ubuntu 15.10. miguel@debianvb:~/mysql-5.6.27/mysql-test$ ./mtr --debug-server --valgrind group_min_max --valgrind-option=--track-origins=yes Logging: ./mtr --debug-server --valgrind group_min_max --valgrind-option=--track-origins=yes 2015-11-12 12:03:20 0 [Note] /home/miguel/mysql-5.6.27/sql/mysqld-debug (mysqld 5.6.27-debug) starting as process 16125 ... 2015-11-12 12:03:20 16125 [Note] Plugin 'FEDERATED' is disabled. 2015-11-12 12:03:20 16125 [Note] Binlog end 2015-11-12 12:03:20 16125 [Note] Shutting down plugin 'CSV' 2015-11-12 12:03:20 16125 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.27 Turning on valgrind for all executables Running valgrind with options " --track-origins=yes " Turning off --check-testcases to save time when valgrinding Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/home/miguel/mysql-5.6.27/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.group_min_max [ pass ] 63798 worker[1] Valgrind report from /home/miguel/mysql-5.6.27/mysql-test/var/log/mysqld.1.err after tests: main.group_min_max miguel@debianvb:~/mysql-5.6.27/mysql-test$ lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 8.2 (jessie) Release: 8.2 Codename: jessie
[27 Nov 2015 13:49]
Erlend Dahl
Reported internally and fixed in 5.6.29, 5.7.11, 5.8.0.