Bug #62456 | (./mysql-test-run --debug) AND (set of DEBUG variable) => disabled trace | ||
---|---|---|---|
Submitted: | 17 Sep 2011 0:39 | Modified: | 21 Sep 2011 14:40 |
Reporter: | Oleg Tsarev | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Tests | Severity: | S3 (Non-critical) |
Version: | 5.1.58, 5.5.17 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[17 Sep 2011 0:39]
Oleg Tsarev
[17 Sep 2011 9:39]
Valeriy Kravchuk
Thank you for the bug report. Verified with 5.5.17 on Mac OS X also: macbook-pro:mysql-test openxs$ ./mtr --debug --record debug_dsabled_trace Logging: ./mtr --debug --record debug_dsabled_trace 110917 12:31:42 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/BI0aMLon22/ is case insensitive 110917 12:31:42 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.17 Checking supported features... - skipping ndbcluster - SSL connections supported - binaries are debug compiled Collecting tests... vardir: /Users/openxs/dbs/5.5/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/Users/openxs/dbs/5.5/mysql-test/var'... Installing system database... Using server port 58506 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.debug_dsabled_trace [ pass ] 1066 MTR's internal check of the test case 'main.debug_dsabled_trace' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/Users/openxs/dbs/5.5/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/Users/openxs/dbs/5.5/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /Users/openxs/dbs/5.5/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /Users/openxs/dbs/5.5/mysql-test/var/tmp/check-mysqld_1.result 2011-09-17 12:31:58.000000000 +0300 +++ /Users/openxs/dbs/5.5/mysql-test/var/tmp/check-mysqld_1.reject 2011-09-17 12:32:00.000000000 +0300 @@ -68,7 +68,7 @@ DATADIR /Users/openxs/dbs/5.5/mysql-test/var/mysqld.1/data/ DATETIME_FORMAT %Y-%m-%d %H:%i:%s DATE_FORMAT %Y-%m-%d -DEBUG d:i:A,/Users/openxs/dbs/5.5/mysql-test/var/log/mysqld.1.trace:t +DEBUG d,after_mysql_insert:i:A,/Users/openxs/dbs/5.5/mysql-test/var/log/mysqld.1.trace:t DEFAULT_STORAGE_ENGINE MyISAM DEFAULT_WEEK_FORMAT 0 DELAYED_INSERT_LIMIT 100 mysqltest: Result content mismatch not ok -------------------------------------------------------------------------- The servers were restarted 0 times Spent 1.066 of 20 seconds executing testcases Check of testcase failed for: main.debug_dsabled_trace Completed: All 1 tests were successful. macbook-pro:mysql-test openxs$ cat var/log/mysqld.1.trace | grep "query:" T@1 : | | | | | info: query: (null) ... T@4 : | | query: SHOW GLOBAL VARIABLES LIKE 'DEBUG' T@4 : | | | | | | info: query: SHOW GLOBAL VARIABLES LIKE 'DEBUG' T@4 : | | query: SHOW SESSION VARIABLES LIKE 'DEBUG' T@4 : | | | | | | info: query: SHOW SESSION VARIABLES LIKE 'DEBUG' T@4 : | | query: SET GLOBAL DEBUG='+d,after_mysql_insert' T@4 : | | | | | | info: query: SET GLOBAL DEBUG='+d,after_mysql_insert' macbook-pro:mysql-test openxs$ So, indeed, further trace is disabled by setting DEBUG.
[21 Sep 2011 9:26]
Oleg Tsarev
Sorry, bug is invalid. DBUG_PRINT("query", .... ) work on in two cases: 1) "d" is not setuped 2) "query" is setuped. In my test-case enough add "+d,query".