Bug #25303 test 'log_state' fail on ppc macos

• Submitted: 28 Dec 2006 7:04
• Modified: 11 Apr 2007 9:42
• Reporter: Antony Curtis
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: MacOS (MacOS 10.4.8)
• Assigned to: Daniel Fischer
• CPU Architecture: Any

[28 Dec 2006 7:04] Antony Curtis

Description:
Test log_state fails on macos,

log_state                      [ fail ]

Errors are (from /Users/antony/Work/mysql-5.1/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/log_state.result  Tue Jul  4 23:37:28 2006
--- r/log_state.reject  Thu Dec 28 09:59:00 2006
***************
*** 31,37 ****
  Variable_name Value
  general_log   ON
  log   ON
! log_slow_queries      OFF
  slow_query_log        OFF
  set session long_query_time=1;
  select sleep(2);
--- 31,37 ----
  Variable_name Value
  general_log   ON
  log   ON
! log_slow_queries      ON
  slow_query_log        OFF
  set session long_query_time=1;
  select sleep(2);
***************
*** 81,87 ****
  Variable_name Value
  general_log   ON
  log   ON
! log_slow_queries      OFF
  slow_query_log        OFF
  show variables like 'general_log_file';
  Variable_name Value
--- 81,87 ----
  Variable_name Value
  general_log   ON
  log   ON
! log_slow_queries      ON
  slow_query_log        OFF
  show variables like 'general_log_file';
  Variable_name Value
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Result from queries before failure can be found in /Users/antony/Work/mysql-5.1/mysql-test/var/log/log_state.log

Aborting: log_state failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
Autoreleasing /tmp/mysql-test-ports:200

How to repeat:
Build on PowerPC MacOS using:

BUILD/compile-ppc-debug-max

run test:

mysql-test-run.pl --do-test=log_state

[28 Dec 2006 10:15] Sveta Smirnova

Thank you for the report.

I can not repeat it using last BK sources

[28 Dec 2006 10:17] Sveta Smirnova

Tested on IntelMac and G5

[28 Dec 2006 10:52] Antony Curtis

found the problem - due to particular compiler optimizations, sizeof(my_bool) != sizeof(bool), so the fix is to change log_slow_queries in set_var.cc from SHOW_BOOL to SHOW_MY_BOOL

[2 Apr 2007 13:37] Daniel Fischer

Re-opening because still occured in 5.1.17-beta build.

[2 Apr 2007 13:38] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/23548

ChangeSet@1.2497, 2007-04-02 15:36:59+02:00, [e-mail] +1 -0
  BUG#25303 log_state fails

[11 Apr 2007 9:42] Daniel Fischer

This was fixed in 5.1.17-beta as a build fix.

[12 Apr 2007 17:52] Bugs System

Pushed into 5.1.18-beta