Percona Server moved to https://jira.percona.com/projects/PS

percona_show_slave_status_nolock fails on 12.4

Bug #694736 reported by Aleksandr Kuzminsky
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Aleksandr Kuzminsky
Percona Server moved to https://jira.percona.com/projects/PS 5.1.53-12.4

Bug Description

main.percona_show_slave_status_nolock [ fail ]
        Test ended at 2010-12-27 06:14:36

CURRENT_TEST: main.percona_show_slave_status_nolock
--- /mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/r/percona_show_slave_status_nolock.result 2010-12-27 15:39:54.000000000 +0300
+++ /mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/r/percona_show_slave_status_nolock.reject 2010-12-27 17:14:36.000000000 +0300
@@ -13,7 +13,7 @@
 0
 SHOW SLAVE STATUS NOLOCK;
 Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error
- host user port 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 No No 0 0 276 577 None 0 No NULL No 0 0
+Waiting for master to send event host user port 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 Yes Yes 0 0 276 577 None 0 No 0 No 0 0
 select count(*) from t;
 count(*)
 0

mysqltest: Result content mismatch

Warnings from just before the error:
Note 1051 Unknown table 't1'
Note 1051 Unknown table 't2'
Note 1051 Unknown table 't3'
Note 1051 Unknown table 't4'
Note 1051 Unknown table 't5'
Note 1051 Unknown table 't6'
Note 1051 Unknown table 't7'
Note 1051 Unknown table 't8'

 - saving '/mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/var/log/main.percona_show_slave_status_nolock/' to '/mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/var/log/main.percona_show_slave_status_nolock/'

Retrying test main.percona_show_slave_status_nolock, attempt(2/3)...

main.percona_show_slave_status_nolock [ retry-pass ] 10577

Retrying test main.percona_show_slave_status_nolock, attempt(3/3)...

main.percona_show_slave_status_nolock [ retry-fail ]
        Test ended at 2010-12-27 06:14:58

CURRENT_TEST: main.percona_show_slave_status_nolock
--- /mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/r/percona_show_slave_status_nolock.result 2010-12-27 15:39:54.000000000 +0300
+++ /mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/r/percona_show_slave_status_nolock.reject 2010-12-27 17:14:58.000000000 +0300
@@ -13,7 +13,7 @@
 0
 SHOW SLAVE STATUS NOLOCK;
 Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error
- host user port 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 No No 0 0 276 577 None 0 No NULL No 0 0
+Waiting for master to send event host user port 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 Yes Yes 0 0 276 577 None 0 No 0 No 0 0
 select count(*) from t;
 count(*)
 0

mysqltest: Result content mismatch

Warnings from just before the error:
Note 1051 Unknown table 't1'
Note 1051 Unknown table 't2'
Note 1051 Unknown table 't3'
Note 1051 Unknown table 't4'
Note 1051 Unknown table 't5'
Note 1051 Unknown table 't6'
Note 1051 Unknown table 't7'
Note 1051 Unknown table 't8'

 - saving '/mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/var/log/main.percona_show_slave_status_nolock/' to '/mnt/data1/home/buildbot/slaves/percona-server-51-12/full_test/build/Percona-Server/mysql-test/var/log/main.percona_show_slave_status_nolock/'

Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
milestone: none → 5.1.53-12.4
Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
status: New → Fix Committed
status: Fix Committed → In Progress
Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
status: In Progress → Fix Committed
Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2589

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.