← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl_ndb/r/rpl_ndb_idempotent.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl_ndb/r/rpl_ndb_idempotent.result
32
32
c1      c2      c3
33
33
row3    C       3
34
34
row4    D       4
35
 
SHOW SLAVE STATUS;
36
 
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
37
 
<Slave_IO_State>        127.0.0.1       root    MASTER_PORT     1       master-bin.000001       <Read_Master_Log_Pos>   <Relay_Log_File>        <Relay_Log_Pos> master-bin.000001       Yes     Yes                             <Replicate_Ignore_Table>                        0               0       <Exec_Master_Log_Pos>   <Relay_Log_Space>       None            0       No                                              <Seconds_Behind_Master> No      <Last_IO_Errno> <Last_IO_Error> 0       
 
35
Checking that both slave threads are running.
38
36
STOP SLAVE;
39
37
CHANGE MASTER TO
40
38
master_log_file = 'master-bin.000001',
41
39
master_log_pos = <the_pos> ;
42
 
SHOW SLAVE STATUS;
43
 
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
44
 
<Slave_IO_State>        127.0.0.1       root    MASTER_PORT     1       master-bin.000001       <Read_Master_Log_Pos>   <Relay_Log_File>        <Relay_Log_Pos> master-bin.000001       No      No                              <Replicate_Ignore_Table>                        0               0       <Exec_Master_Log_Pos>   <Relay_Log_Space>       None            0       No                                              <Seconds_Behind_Master> No      <Last_IO_Errno> <Last_IO_Error> 0       
45
40
START SLAVE;
46
41
SELECT * FROM t1 ORDER BY c3;
47
42
c1      c2      c3
67
62
SELECT * FROM t1;
68
63
c1      c2      c3
69
64
row2    new on slave    2
70
 
SHOW SLAVE STATUS;
71
 
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
72
 
<Slave_IO_State>        127.0.0.1       root    MASTER_PORT     1       master-bin.000001       <Read_Master_Log_Pos>   <Relay_Log_File>        <Relay_Log_Pos> master-bin.000001       Yes     Yes                             <Replicate_Ignore_Table>                        0               0       <Exec_Master_Log_Pos>   <Relay_Log_Space>       None            0       No                                              <Seconds_Behind_Master> <Last_IO_Errno> <Last_IO_Error>         0       
 
65
Checking that both slave threads are running.
73
66
DROP TABLE IF EXISTS t1;