Bug #96524 | --innodb-force-recovery=1 crashes FLUSH BINARY LOGS on debug build | ||
---|---|---|---|
Submitted: | 13 Aug 2019 14:08 | Modified: | 22 Oct 2019 10:57 |
Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S6 (Debug Builds) |
Version: | 8.0.17 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[13 Aug 2019 14:08]
Laurynas Biveinis
[14 Aug 2019 6:39]
Laurynas Biveinis
Add --nowarnings to -master.opt file to see that the test passes in the release build
[16 Aug 2019 7:21]
MySQL Verification Team
Hello Laurynas, Thank you for the report and feedback. I quickly tried on tarball build but not seeing crash(it fails with warning, even with --nowarnings). Could you please confirm exact cmake commands, gcc etc used in your environment to reproduce this at our end? Thank you. - ./mtr --debug-server --nowarnings Bug96524 Logging: ./mtr --debug-server --nowarnings Bug96524 MySQL Version 8.0.17 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.Bug96524 [ fail ] Test ended at 2019-08-16 09:17:17 Result file '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/r/Bug96524.result' doesn't exist. Either create a result file or disable check-testcases and run the test case. Use --nocheck-testcases option to disable check-testcases. Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- CREATE DATABASE transforms; FLUSH BINARY LOGS; DROP DATABASE transforms; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/log/main.Bug96524/Bug96524.log' ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 18 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.Bug96524 -- ./mtr --debug-server Bug96524 Logging: ./mtr --debug-server Bug96524 MySQL Version 8.0.17 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.Bug96524 [ fail ] Test ended at 2019-08-16 09:19:47 CURRENT_TEST: main.Bug96524 Could not execute 'check-warnings' for testcase 'main.Bug96524' (res: 1): mysqltest: At line 64: Query 'LOAD DATA INFILE '$log_warning' INTO TABLE error_log CHARACTER SET latin1 FIELDS TERMINATED BY 'xykls37' ESCAPED BY '' ignore 1 lines (line) SET file_name = '$log_error'' failed with wrong error 1881: 'Operation not allowed when innodb_force_recovery > 0.', should have failed with any of '0,1290' errors. not ok safe_process[3884]: Child process: 3885, exit: 1 mysqltest failed but provided no output The result from queries just before the failure was: < snip > CREATE DATABASE transforms; FLUSH BINARY LOGS; DROP DATABASE transforms; Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- CREATE DATABASE transforms; FLUSH BINARY LOGS; DROP DATABASE transforms; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/log/main.Bug96524/Bug96524.log' ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 18 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.Bug96524 Sincerely, Umesh
[16 Aug 2019 7:55]
Laurynas Biveinis
Perhaps it's -DWITH_INNODB_EXTRA_DEBUG=ON macOS 10.14.6 $ clang --version Apple LLVM version 10.0.1 (clang-1001.0.46.4) Target: x86_64-apple-darwin18.7.0 Thread model: posix InstalledDir: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin Cmake options: -DBUILD_CONFIG=mysql_release -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DWITH_PAM=ON -DENABLE_DOWNLOADS=ON -DWITHOUT_TOKUDB=ON -DDOWNLOAD_BOOST=ON -DWITH_BOOST=~/percona/mysql-boost/ -DWITH_ROCKSDB=OFF -DWITH_KEYRING_VAULT=ON -DWITH_AUTHENTICATION_LDAP=ON -DWITH_SYSTEM_LIBS=ON -DWITH_RAPIDJSON=bundled -DWITH_MYSQLX=OFF -DWITH_ICU=/usr/local/opt/icu4c -DDEBUG_EXTNAME=OFF -DWITH_DEBUG=ON -DWITH_INNODB_EXTRA_DEBUG=ON
[22 Oct 2019 9:55]
Pedro Figueiredo
A duplicate of BUG#97312
[22 Oct 2019 10:57]
MySQL Verification Team
Thank you Pedro. regards, Umesh