From: Luis Soares Date: January 14 2011 5:02pm Subject: bzr commit into mysql-trunk branch (luis.soares:3507) Bug#57771 List-Archive: http://lists.mysql.com/commits/128828 X-Bug: 57771 Message-Id: <201101141702.p0EDZXcB027207@rcsinet13.oracle.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3388580932562013635==" --===============3388580932562013635== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/lsoares/Workspace/bzr/work/reviews/b12133/mysql-trunk-vanilla/ based on revid:sven.sandberg@stripped 3507 Luis Soares 2011-01-14 BUG#57771: Master losing track of binary log file after configuration change Sketch of a test case. added: mysql-test/suite/rpl/t/rpl_bug57771-master.opt mysql-test/suite/rpl/t/rpl_bug57771.test === added file 'mysql-test/suite/rpl/t/rpl_bug57771-master.opt' --- a/mysql-test/suite/rpl/t/rpl_bug57771-master.opt 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/rpl/t/rpl_bug57771-master.opt 2011-01-14 17:02:35 +0000 @@ -0,0 +1 @@ +--log-bin=$MYSQLTEST_VARDIR/mysqld.1/data/mysqld-bin === added file 'mysql-test/suite/rpl/t/rpl_bug57771.test' --- a/mysql-test/suite/rpl/t/rpl_bug57771.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/rpl/t/rpl_bug57771.test 2011-01-14 17:02:35 +0000 @@ -0,0 +1,54 @@ +# +# +-- source include/master-slave.inc +-- source include/have_binlog_format_statement.inc + +-- let $datadir= `SELECT @@datadir` +-- echo $MYSQLTEST_VARDIR + +-- cat_file $datadir/mysqld-bin.index + +--echo # Shutdown master +# Write file to make mysql-test-run.pl expect the "crash", but don't start +# it until it's told to +--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect + +# Send shutdown to the connected server and give +# it 10 seconds to die before zapping it +shutdown_server 10; + +--echo # Restart master with log-bin option set to the new path +--exec echo 'restart: --log-bin=mysqld-bin' > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect + +# Turn on reconnect +--enable_reconnect + +# Call script that will poll the server waiting for it to be back online again +--source include/wait_until_connected_again.inc + +# Turn off reconnect again +--disable_reconnect + +-- cat_file $datadir/mysqld-bin.index + +CREATE TABLE t1 (a INT); +DROP TABLE t1; + +-- connection slave + +STOP SLAVE; +-- source include/wait_for_slave_to_stop.inc +START SLAVE; + +-- sleep 1 + +-- let $status_items= Last_IO_Errno, Last_IO_Error +-- source include/show_slave_status.inc + +-- source include/check_slave_no_error.inc +-- source include/check_slave_is_running.inc + +-- connection master +-- sync_slave_with_master + +-- exit --===============3388580932562013635== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/luis.soares@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: luis.soares@stripped # target_branch: file:///home/lsoares/Workspace/bzr/work/reviews\ # /b12133/mysql-trunk-vanilla/ # testament_sha1: 9728752dea4f8c1ea19fc8452beba9a59207f719 # timestamp: 2011-01-14 17:02:44 +0000 # base_revision_id: sven.sandberg@stripped\ # j0l7jpwzegs3d401 # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWckjDK8AAnvfgAAQXOf//36n /6D////wYAavrxgAbNdh1oByAoCVNEaaKaaeJB5qaJtQ9QaNAZGmmh6hpoAaKQabSGmnqeiNMgNA AAAAAAcZMmTEYmAEyYJkANGEYAhgEppNIGiamUeKaGQGmnqNAeoYjQ09TynqZBxkyZMRiYATJgmQ A0YRgCGASSBGgBMmmpiYiT00EYiabSemUAeienyZk50W/Uudi4vxvuvQVnxQSJhpY+/enCbYusDO gTIjZZNjEov+lsccX0bN2au1waMjoMZt1zd2xnlpuDEcRGSnBfJTb1WjpnLuQMgR7NcmLwq8+aya CHvWR9bGKit3Z0nTQovnqNE3Ko0yS27KmW3t2kM0Y5FXYV+md+Bhd3hVYTEq5nbSMsNLi4LqnWRm vWc4bQgxLrJabrpS7j4pT5OKOPU5IyyMc2fvsRyuwLkZJJjoeSGyqjuc3j0aeEAqSRJsDAGPqqCs cBw1ZMTFbGlPM5GUefCXcc9gJFKqf3IVZZbRxsl90h6YIIKFmSHNC9y5UFJ7uRFwxb7aysUk5kk4 A1b2JewFRiEFGUygIA3P6hM9caMCKs2pcaMr4VfkMmh0qCtJeu+9cjjTjxEk+FXxnHd9zq7SAWpK jaq4FmYd23fndWa2hYXkTYmaPmahcEx2rORFOSTQYN+/1PA4DWuwgzjgOu3ORsSrtTySqDHZj3TN YAbrI0449VQfXcSO6lzs1eFwSZJXthVjUZGZlI5aqZfYuJMptAi6dLjDP7EsiTOnLA5roHtYxu3m wFRpPfrcTfOyAUrib88FR3ncGuwJiSWHddfUXSSuSmPL2CjAerSUpSpPEL9YFg61pKimu0yy0KSs yRAqdyeQtcTK6FW5pWyPsB2lGjNP0a177miWOUYvBpNFUIooVEtvQdzsasL6rssYlJQsQFmLORmN NFarigyGsEntMMqEkl9zxTkqewJWWFpFst0w7Dfa5sCZ5y/eFRk6wfbTI5vLgcMwbsHs2I7AzmIS HVdP7Ipb3Qch5luCI/9wwOxkHXh96XziufhEeN3sj5snOcPEB0HXy64rucoSdT4N61TsHwG5jWB7 x/qa1lzf4NjWowCbaARNbJ9C5B0nAMXGGYJK6GCVrTuSRUQQYJD1foL12YVjRG6IpqfS80KGR4/p 8ToZ5DFi7j6JP46HM+DxQ3pew6Fpv+R+solCf4mqXjO4OE+0/iVokoOHAopfQFjDBgpxY/t4wSMQ m4bkjzGU5cDjqaqgxiTCrMqD5wkiOf6L5RXBLVxv08VAOfrIcVaA5OTlalj1NrigdCUqVkgGVoCs EnCpggUGzVgLzyxxDH29h52KDyPMfmxAvqGtQziI5ZfuWndxGIGegPPgyMwKDM40BJWlLG62+6TK FIOH0sJQcJWZLxiKRgSkDxmZHO11y3+rVymI610JN+cMyXZ6NLTE5dw1aK/A67HYcd/OvqA456kl P1G9Y8DD+BvWMQaHNw7y8G0K6EybIPSLZQoTyLhTqVsyfFnM4TO9bBY9KHgxeFMi4s5YI/0A7aTL Rwwj8aHmu43OHMjvSel0Q464UeGVU/y4600hQj/JpkHERvd5I7bgzZiigo0IeiJ7LDRg2XtA96mB 9gOq2bIYt63omcfC5VHYL093kmUhSYhFL0UJRFYCYgMdB2phfFqeT+EjQodWWWJeg+CY6dbQVOjK P4FnIMTSrE519iU2q9pfK/cmLygXcawJO0ncTaKNLEEQKcUIA3ZHZlDsOyKlpAepSYiindOaAema 0JCaaBl55fBDIn5jO7c0Fd64oj05IVhFjwZD/e0GApoayDrmb8QUUORU5V7rUsLlcYx5qR4GxfzY YGivSqLssgJP24TupPasAL0jAgwM1LJzKQy9wDntm5AZa2AP4l5UgP4v8oK0JT+1RUDG62W555Hi zNA+hXgmq8KpQXvIyYfnrne9B968g50II2SO7ktZWu2wcnvMWgZx2yrRE8wtN1FUUQH2oGFDeelI vFeMosUn9YIHYIYYI/gcwv4udMpc/PSW3hnVYrFFjo1LAe8urmIqmeUJQQ7Ds1t7RNFCTpLyYWle i08h4NoTmQQ7bDA0JRu3NxJizbAU05rq3BVUTDa9LwFE/V6CszqVlsOuSXQ+RqW+a9IGe7Fkq1mr 1yRIBreupksvgBFUmypC4BkDws3JFg4oLq9DA9Sar+RdyRThQkMkjDK8 --===============3388580932562013635==--