From: Date: October 11 2006 10:07am Subject: bk commit into 5.0 tree (aelkin:1.2297) BUG#20697 List-Archive: http://lists.mysql.com/commits/13450 X-Bug: 20697 Message-Id: <200610110807.k9B87Q58026663@dsl-hkigw8-feb9fb00-191.dhcp.inet.fi> Below is the list of changes that have just been committed into a local 5.0 repository of elkin. When elkin does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet@stripped, 2006-10-11 11:07:20+03:00, aelkin@stripped +1 -0 bug#20697 - results in sync with the test mysql-test/r/rpl_deadlock.result@stripped, 2006-10-11 11:05:56+03:00, aelkin@stripped +0 -87 # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: aelkin # Host: dsl-hkigw8-feb9fb00-191.dhcp.inet.fi # Root: /home/elkin/MySQL/TEAM/BARE/5.0 --- 1.11/mysql-test/r/rpl_deadlock.result 2006-10-11 11:07:26 +03:00 +++ 1.12/mysql-test/r/rpl_deadlock.result 2006-10-11 11:07:26 +03:00 @@ -185,91 +185,4 @@ Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master # -drop table if exists t1; -create table t1 (f int unique) engine=innodb; -insert into t1 values (0); -begin; -select * from t1 where f = 0 for update; -f -0 -begin; -insert into t1 values (1); -update t1 set f=-1 where f = 0; -commit; -insert into t1 values (2); -show slave status; -Slave_IO_State # -Master_Host 127.0.0.1 -Master_User root -Master_Port MASTER_MYPORT -Connect_Retry 1 -Master_Log_File master-bin.000001 -Read_Master_Log_Pos 19618 -Relay_Log_File # -Relay_Log_Pos # -Relay_Master_Log_File master-bin.000001 -Slave_IO_Running # -Slave_SQL_Running No -Replicate_Do_DB -Replicate_Ignore_DB -Replicate_Do_Table -Replicate_Ignore_Table -Replicate_Wild_Do_Table -Replicate_Wild_Ignore_Table -Last_Errno 1205 -Last_Error Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'update t1 set f=-1 where f = 0' -Skip_Counter 0 -Exec_Master_Log_Pos 19227 -Relay_Log_Space # -Until_Condition None -Until_Log_File -Until_Log_Pos 0 -Master_SSL_Allowed No -Master_SSL_CA_File -Master_SSL_CA_Path -Master_SSL_Cert -Master_SSL_Cipher -Master_SSL_Key -Seconds_Behind_Master # -set @@global.sql_slave_skip_counter = 4; -start slave; -show slave status; -Slave_IO_State # -Master_Host 127.0.0.1 -Master_User root -Master_Port MASTER_MYPORT -Connect_Retry 1 -Master_Log_File master-bin.000001 -Read_Master_Log_Pos 19618 -Relay_Log_File # -Relay_Log_Pos # -Relay_Master_Log_File master-bin.000001 -Slave_IO_Running # -Slave_SQL_Running Yes -Replicate_Do_DB -Replicate_Ignore_DB -Replicate_Do_Table -Replicate_Ignore_Table -Replicate_Wild_Do_Table -Replicate_Wild_Ignore_Table -Last_Errno 0 -Last_Error -Skip_Counter 0 -Exec_Master_Log_Pos 19618 -Relay_Log_Space # -Until_Condition None -Until_Log_File -Until_Log_Pos 0 -Master_SSL_Allowed No -Master_SSL_CA_File -Master_SSL_CA_Path -Master_SSL_Cert -Master_SSL_Cipher -Master_SSL_Key -Seconds_Behind_Master # -select * from t1; -f -0 -2 -commit; drop table t1,t2,t3,t4;