main.percona_slow_extended-slave_innodb_stats fails sporadically in 5.1.56
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
5.1 |
Fix Released
|
Undecided
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Undecided
|
Alexey Kopytov |
Bug Description
Reporting https:/
Found this problem when compiling 5.1.56 in CentOS:
main.percona_
MTR's internal check of the test case 'main.percona_
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 '/home/
mysqltest: Results saved in '/home/
mysqltest: Connecting to server localhost:13011 (socket /home/ignacio.
...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/
mysqltest: ... Done processing test commands.
--- /home/ignacio.
+++ /home/ignacio.
@@ -1,4 +1,4 @@
-Slave_IO_State
+Slave_IO_State Waiting for master to send event
Master_Host 127.0.0.1
Master_User root
Master_Port 13010
@@ -8,8 +8,8 @@
Relay_Log_File #
Relay_Log_Pos #
Relay_
-Slave_IO_Running No
-Slave_SQL_Running No
+Slave_IO_Running Yes
+Slave_SQL_Running Yes
Replicate_Do_DB
Replicate_
Replicate_Do_Table
@@ -30,7 +30,7 @@
Master_SSL_Cert
Master_SSL_Cipher
Master_SSL_Key
-Seconds_
+Seconds_
Master_
Last_IO_Errno 0
Last_IO_Error
mysqltest: Result content mismatch
not ok
$ uname -a
Linux offbuild3.
Related branches
- Percona developers: Pending requested
-
Diff: 2208 lines (+972/-961)52 files modifiedmysql-test/log_connection_error.patch/percona_log_connection_error-master.opt (+1/-1)
mysql-test/log_connection_error.patch/percona_log_connection_error.result (+2/-1)
mysql-test/log_connection_error.patch/percona_log_connection_error.test (+6/-8)
mysql-test/slow_extended.patch/grep.inc (+0/-16)
mysql-test/slow_extended.patch/percona_bug643149.result (+0/-21)
mysql-test/slow_extended.patch/percona_bug643149.test (+0/-49)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.result (+0/-24)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.test (+0/-23)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.result (+0/-13)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.test (+0/-23)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result (+0/-22)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.test (+0/-51)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.result (+0/-89)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+0/-107)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.result (+0/-94)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+0/-133)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_timestamp_always-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_control-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_control.result (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_control.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result (+0/-46)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.test (+0/-40)
slow_extended.patch (+963/-0)
- Percona developers: Pending requested
-
Diff: 2189 lines (+942/-964)56 files modifiedmysql-test/slow_extended.patch/grep.inc (+0/-16)
mysql-test/slow_extended.patch/percona_slow_extended-combined-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-combined.result (+0/-18)
mysql-test/slow_extended.patch/percona_slow_extended-combined.test (+0/-6)
mysql-test/slow_extended.patch/percona_slow_extended-combined2-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.result (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.test (+0/-4)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow.result (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.result (+0/-22)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.test (+0/-19)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.result (+0/-11)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.test (+0/-19)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result (+0/-21)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.test (+0/-38)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.result (+0/-94)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+0/-116)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.result (+0/-93)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+0/-168)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result (+0/-59)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.test (+0/-41)
slow_extended.patch (+942/-0)
- Stewart Smith: Pending requested
-
Diff: 10937 lines (+5359/-3875)79 files modifiedbugfix48929.patch (+9/-9)
control_online_alter_index.patch (+14/-14)
fix-bug671764.patch (+4/-4)
microsec_process.patch (+9/-9)
mysql-test/have_response_time_distribution.inc (+0/-4)
mysql-test/have_response_time_distribution.require (+0/-2)
mysql-test/percona_server_variables_debug.result (+1/-0)
mysql-test/response-time-distribution.patch/percona_query_response_time-replication.result (+0/-67)
mysql-test/response-time-distribution.patch/percona_query_response_time-replication.test (+0/-59)
mysql-test/response-time-distribution.patch/percona_query_response_time-stored.result (+0/-313)
mysql-test/response-time-distribution.patch/percona_query_response_time-stored.test (+0/-90)
mysql-test/response-time-distribution.patch/percona_query_response_time.result (+0/-567)
mysql-test/response-time-distribution.patch/percona_query_response_time.test (+0/-68)
mysql-test/response-time-distribution.patch/percona_query_response_time_flush.inc (+0/-1)
mysql-test/response-time-distribution.patch/percona_query_response_time_show.inc (+0/-8)
mysql-test/response-time-distribution.patch/percona_query_response_time_sleep.inc (+0/-19)
mysql-test/slow_extended.patch/grep.inc (+0/-16)
mysql-test/slow_extended.patch/percona_slow_extended-combined-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-combined.result (+0/-18)
mysql-test/slow_extended.patch/percona_slow_extended-combined.test (+0/-6)
mysql-test/slow_extended.patch/percona_slow_extended-combined2-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.result (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.test (+0/-4)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow.result (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-control_global_slow.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_filter.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.result (+0/-9)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity.test (+0/-12)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.result (+0/-22)
mysql-test/slow_extended.patch/percona_slow_extended-long_query_time.test (+0/-19)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.result (+0/-11)
mysql-test/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.test (+0/-19)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.result (+0/-25)
mysql-test/slow_extended.patch/percona_slow_extended-min_examined_row_limit.test (+0/-32)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.result (+0/-21)
mysql-test/slow_extended.patch/percona_slow_extended-slave_innodb_stats.test (+0/-38)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.result (+0/-94)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+0/-116)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-slave.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.result (+0/-93)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+0/-168)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.result (+0/-3)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.test (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-master.opt (+0/-1)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result (+0/-59)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.test (+0/-41)
mysql_dump_ignore_ct.patch (+7/-8)
query_cache_enhance.patch (+53/-79)
response_time_distribution.patch (+3930/-1435)
series (+1/-1)
show_slave_status_nolock.patch (+2/-2)
show_temp_51.patch (+3/-3)
slow_extended.patch (+1234/-57)
userstat.patch (+92/-92)
- Oleg Tsarev (community): Approve
- Stewart Smith (community): Needs Fixing
-
Diff: 6277 lines (+3657/-2233)7 files modifiedpatches/log_connection_error.patch (+10/-9)
patches/microsec_process.patch (+5/-5)
patches/mysql-test.diff (+22/-57)
patches/response_time_distribution.patch (+2542/-1123)
patches/series (+1/-1)
patches/slow_extended.patch (+1058/-1019)
patches/userstat.patch (+19/-19)
Changed in percona-server: | |
status: | New → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Changed in percona-server: | |
assignee: | Oleg Tsarev (tsarev) → Alexey Kopytov (akopytov) |
Is this still the case?