| Bug #33654 | "slow log" is missing a line | ||
|---|---|---|---|
| Submitted: | 3 Jan 2008 15:49 | Modified: | 28 Mar 2008 19:25 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Server | Severity: | S3 (Non-critical) |
| Version: | 6.0.4-alpha | OS: | MacOS (x86) |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
[9 Jan 2008 9:15]
Konstantin Osipov
Obviously, this is not Server: Tests, because the bug is not in the main test suite. If there are additional tests run by build, failures of these tests must be analyzed and the test case extracted before a bug is reported. Lack of this step makes it very hard to do preliminary analysis and correct dispatching of a bug. In particular, I can't see from the report whether this is I_S specific problem, or slow log specific problem. I can't easily repeat and see it, since it's a platform-specific problem. Setting the bug to "Open": please extract the failing test case and add to the bug report.
[9 Jan 2008 9:27]
Joerg Bruehe
The issue was detected when running a test of the "extra" suite, which is available internally and managed by System QA. It is not the build team's fault that the typical developer doesn't download that tree and run the test, that the server code gets changed faster than these tests are following (which has been used as an excuse not to run the tests in pushbuild), or that this tree hasn't been integrated into the main tree yet. If you want that situation changed, I am completely on your side.
[9 Jan 2008 9:51]
Joerg Bruehe
Correction: The suite *was* developed by QA when that still was one team, it is now maintained by *Server* QA.
[28 Jan 2008 19:56]
Joerg Bruehe
I now get this difference in 5.1.23-rc also. Most occurrences are on the same platform as the original report (OS X, x86), but they start to spread to others (like SLES10-x86). Also, not always the full set of differences shows up, sometimes it is just the last part: --- /PATH/mysql-test/suite/funcs_1/r/innodb__datadict.result +++ /PATH/mysql-test/suite/funcs_1/r/innodb__datadict.reject @@ -14210,7 +14210,7 @@ NULL mysql proc BASE TABLE MyISAM 10 Dynamic 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Stored Procedures NULL mysql procs_priv BASE TABLE MyISAM 10 Fixed 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_bin NULL Procedure privileges NULL mysql servers BASE TABLE MyISAM 10 Fixed 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL MySQL Foreign Servers table -NULL mysql slow_log BASE TABLE CSV 10 Dynamic 2 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Slow log +NULL mysql slow_log BASE TABLE CSV 10 Dynamic 1 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Slow log NULL mysql tables_priv BASE TABLE MyISAM 10 Fixed 5 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_bin NULL Table privileges NULL mysql time_zone BASE TABLE MyISAM 10 Fixed 5 #ARL# #DL# #MDL# #IL# #DF# 6 YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Time zones NULL mysql time_zone_leap_second BASE TABLE MyISAM 10 Fixed 22 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Leap seconds information for time zones mysqltest: Result content mismatch
[19 Feb 2008 11:48]
Matthias Leich
This bug will be fixed within
WL#4203 Reorganize and fix the data dictionary tests of
testsuite funcs_1
[11 Mar 2008 11:10]
Matthias Leich
WL#4203 Reorganize and fix the data dictionary tests of
testsuite funcs_1
was pushed to mysql-<version>-build
Version is in (5.0,5.1,6.0).
1. The tests "<engine>__datadict" do no more exist.
2. The checks where the problem above occured were
moved into the new test "is_tables_mysql".
3. The number of rows within the table is now unified
by "--replace_column ......".
[27 Mar 2008 22:04]
Bugs System
Pushed into 5.1.24-rc
[27 Mar 2008 22:12]
Bugs System
Pushed into 5.0.60
[28 Mar 2008 11:10]
Bugs System
Pushed into 6.0.5-alpha
[28 Mar 2008 19:25]
Paul DuBois
Fix involves test case changes. No changelog entry needed.
Description: Found in the tests when building 6.0.4-alpha In both the "myisam__datadict" and the "memory__datadict" tests (but *not* in "innodb__datadict"), on just one platform (OS X, x86), I see this difference (line numbers from "memory__datadict"): @@ -1369,7 +1369,7 @@ ENGINE CSV VERSION 10 ROW_FORMAT Dynamic -TABLE_ROWS 2 +TABLE_ROWS 1 AVG_ROW_LENGTH #ARL# DATA_LENGTH #DL# MAX_DATA_LENGTH #MDL# @@ -4671,7 +4674,7 @@ ENGINE CSV VERSION 10 ROW_FORMAT Dynamic -TABLE_ROWS 2 +TABLE_ROWS 1 AVG_ROW_LENGTH #ARL# DATA_LENGTH #DL# MAX_DATA_LENGTH #MDL# @@ -14418,7 +14691,7 @@ NULL mysql proc BASE TABLE MyISAM 10 Dynamic 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Stored Procedures NULL mysql procs_priv BASE TABLE MyISAM 10 Fixed 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_bin NULL Procedure privileges NULL mysql servers BASE TABLE MyISAM 10 Fixed 0 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL MySQL Foreign Servers table -NULL mysql slow_log BASE TABLE CSV 10 Dynamic 2 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Slow log +NULL mysql slow_log BASE TABLE CSV 10 Dynamic 1 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Slow log NULL mysql tables_priv BASE TABLE MyISAM 10 Fixed 5 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_bin NULL Table privileges NULL mysql time_zone BASE TABLE MyISAM 10 Fixed 5 #ARL# #DL# #MDL# #IL# #DF# 6 YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Time zones NULL mysql time_zone_leap_second BASE TABLE MyISAM 10 Fixed 22 #ARL# #DL# #MDL# #IL# #DF# NULL YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss utf8_general_ci NULL Leap seconds information for time zones In all cases, this is about table "slow_log", and the command producing the output is SELECT * FROM information_schema.tables WHERE NOT( table_schema = 'information_schema') AND NOT (table_schema = 'mysql' AND table_name LIKE 'help_%'); How to repeat: Run the "funcs_1" suite.