Bug #2930 | multitable update does not replicate | ||
---|---|---|---|
Submitted: | 23 Feb 2004 17:34 | Modified: | 26 Feb 2004 15:10 |
Reporter: | Przemyslaw Popielarski | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 4.0.18 | OS: | Linux (Linux x86) |
Assigned to: | CPU Architecture: | Any |
[23 Feb 2004 17:34]
Przemyslaw Popielarski
[24 Feb 2004 11:29]
MySQL Verification Team
Could not repaat with 4.0.18. I got this in both binary log and executed on the slave: [/mnt/work/mysql-4.1]$ ./client/mysqlbinlog /usr/local/var/sinisa-bin.000001 # at 4 #040224 21:28:07 server id 1 log_pos 4 Start: binlog v 3, server v 4.1.2-alpha-debug-log created 040224 21:28:07 at startup # at 79 #040224 21:28:23 server id 1 log_pos 79 Query thread_id=1 exec_time=0 error_code=0 use bug; SET TIMESTAMP=1077650903; create table t1 (id bigint(20) auto_increment primary key, title text); # at 183 #040224 21:28:27 server id 1 log_pos 183 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650907; create table t2 (id bigint(20) auto_increment primary key, title text); # at 287 #040224 21:28:38 server id 1 log_pos 287 Intvar SET INSERT_ID=1; # at 315 #040224 21:28:38 server id 1 log_pos 315 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650918; insert into t1 set id=NULL, title="test"; # at 389 #040224 21:28:39 server id 1 log_pos 389 Intvar SET INSERT_ID=2; # at 417 #040224 21:28:39 server id 1 log_pos 417 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650919; insert into t1 set id=NULL, title="test"; # at 491 #040224 21:28:39 server id 1 log_pos 491 Intvar SET INSERT_ID=3; # at 519 #040224 21:28:39 server id 1 log_pos 519 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650919; insert into t1 set id=NULL, title="test"; # at 593 #040224 21:28:41 server id 1 log_pos 593 Intvar SET INSERT_ID=4; # at 621 #040224 21:28:41 server id 1 log_pos 621 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650921; insert into t1 set id=NULL, title="test"; # at 695 #040224 21:28:44 server id 1 log_pos 695 Intvar SET INSERT_ID=1; # at 723 #040224 21:28:44 server id 1 log_pos 723 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650924; insert into t2 set id=NULL, title="test"; # at 797 #040224 21:28:53 server id 1 log_pos 797 Intvar SET INSERT_ID=2; # at 825 #040224 21:28:53 server id 1 log_pos 825 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077650933; insert into t2 set id=NULL, title="test"; # at 899 #040224 21:30:22 server id 1 log_pos 899 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1077651022; update t1 left join t2 on t1.id = t2.id set t1.title="tttt"; # at 992
[24 Feb 2004 12:19]
Przemyslaw Popielarski
Okey, tried again today and got this in master's and slave's logs. Seems to be ok now.
[26 Feb 2004 15:10]
Guilhem Bichot
Hi, Indeed, I tested this and it worked. Guilhem