| Bug #69203 | Valgrind warnings and crash on select from an InnoDB table | ||
|---|---|---|---|
| Submitted: | 11 May 2013 17:35 | Modified: | 8 Nov 2013 9:58 |
| Reporter: | Elena Stepanova | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Linux (Ubuntu 12.04 64-bit) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[11 May 2013 17:35]
Elena Stepanova
[12 May 2013 13:33]
MySQL Verification Team
Sounds like this? Bug 16761469 - CRASH UNDER VALGRIND IN GET_SCHED_INDEXER AT UT0COUNTER.H DURING JOIN EXECUTION
[12 May 2013 19:51]
MySQL Verification Team
Thank you for the bug report. Which is your Valgrind version? If it prior of 3.8.1 please upgrade and test again. Thanks.
[13 May 2013 6:12]
MySQL Verification Team
I can not repeat described behavior with valgrind-3.8.1 [ushastry@ushastry mysql-test]$ valgrind --version valgrind-3.8.1 [ushastry@ushastry mysql-test]$ ./mysql-test-run.pl --valgrind-mysqld uVal Logging: ./mysql-test-run.pl --valgrind-mysqld uVal 2013-05-13 11:38:20 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431 2013-05-13 11:38:20 23500 [Note] Plugin 'FEDERATED' is disabled. 2013-05-13 11:38:20 23500 [Note] Binlog end 2013-05-13 11:38:20 23500 [Note] Shutting down plugin 'CSV' 2013-05-13 11:38:20 23500 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.7.1 Turning on valgrind for mysqld(s) only Running valgrind with options " --show-reachable=yes " Turning off --check-testcases to save time when valgrinding Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/mybuilds/mysql-5.7.1/mysql-test/var'... Installing system database... Using server port 52239 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES (10),(11); SELECT * FROM t1; pk 10 11 main.uVal [ pass ] 3400 valgrind_report [ pass ] -------------------------------------------------------------------------- The servers were restarted 0 times Spent 3.400 of 33 seconds executing testcases Completed: All 2 tests were successful. [ushastry@ushastry mysql-test]$ [ushastry@ushastry mysql-test]$ cat t/uVal.test CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES (10),(11); SELECT * FROM t1;
[14 May 2013 13:10]
Elena Stepanova
It is 3.7.0 which happens to be the latest version offered by official repos for Ubuntu 12.04 (indicated in OS field), which, in turn, is the latest LTS release of Ubuntu. sudo apt-get install valgrind Reading package lists... Done Building dependency tree Reading state information... Done valgrind is already the newest version. ... valgrind --version valgrind-3.7.0
[15 May 2013 18:48]
MySQL Verification Team
Thank you for the feedback. Please test with >= 3.8.1 version which isn't repeatable this bug report a similar internal bug report was closed !bug. On Centos 6.3 isn't repeatable: [miguel@tikal 5.5]$ cat /etc/issue CentOS release 6.4 (Final) Kernel \r on an \m [miguel@tikal 5.5]$ valgrind --version valgrind-3.8.1 [miguel@tikal 5.5]$
[15 May 2013 19:27]
Elena Stepanova
>> Please test with >= 3.8.1 I trust your results if you're saying it's not repeatable with 3.8.1. If it's a good enough reason to consider it not to be a bug, please go ahead and close.
