From: Andrei Elkin Date: March 8 2011 7:29pm Subject: bzr push into mysql-trunk branch (andrei.elkin:3736 to 3737) Bug#58754 Bug#11765758 List-Archive: http://lists.mysql.com/commits/132635 X-Bug: 58754,11765758 Message-Id: <201103081929.p28JTTRU001544@mysql1000.dsl.inet.fi> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0557416178==" --===============0557416178== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline 3737 Andrei Elkin 2011-03-08 Bug#11765758 bug#58754 RPL_CORRUPTION FAILED on mysql-trunk There are two outstanding issues: a crash and stopping slave with an unexpected error. The current patch is hunting over the crash. Here is the first step to sort out whether `+d' dbug instruction that leads to the error-log relates to the crash. Notice, no real changes neither to the sources not the tests are done. The idea is just to watch PB2 on the win 64. @ mysql-test/suite/rpl/r/rpl_corruption.result results are updated. @ mysql-test/suite/rpl/t/rpl_corruption.test changed dbug control to use the abs not incremental syntax in order to avoid cluttering the error log with extra info. todo: restore to the original once relateness of the syntax to the issue got sorted out. modified: mysql-test/suite/rpl/r/rpl_corruption.result mysql-test/suite/rpl/t/rpl_corruption.test 3736 MySQL Build Team 2011-03-08 fixing Bug #34984 [patch] mysqld_multi to support reload option modified: scripts/mysqld_multi.sh === modified file 'mysql-test/suite/rpl/r/rpl_corruption.result' --- a/mysql-test/suite/rpl/r/rpl_corruption.result 2011-01-10 06:17:31 +0000 +++ b/mysql-test/suite/rpl/r/rpl_corruption.result 2011-03-08 19:28:55 +0000 @@ -33,10 +33,10 @@ START SLAVE IO_THREAD; include/wait_for_slave_io_error.inc [errno=1595] SET GLOBAL debug="-d,corrupt_queue_event"; # 6. Slave. Corruption in relay log -SET GLOBAL debug="+d,corrupt_read_log_event_char"; +SET GLOBAL debug="d,corrupt_read_log_event_char"; START SLAVE; include/wait_for_slave_sql_error.inc [errno=1593] -SET GLOBAL debug="-d,corrupt_read_log_event_char"; +SET GLOBAL debug=""; # 7. Seek diff for tables on master and slave include/start_slave.inc include/diff_tables.inc [master:t1, slave:t1] === modified file 'mysql-test/suite/rpl/t/rpl_corruption.test' --- a/mysql-test/suite/rpl/t/rpl_corruption.test 2011-01-10 06:17:31 +0000 +++ b/mysql-test/suite/rpl/t/rpl_corruption.test 2011-03-08 19:28:55 +0000 @@ -100,11 +100,19 @@ SET GLOBAL debug="-d,corrupt_queue_event # Emulate corruption in relay log --echo # 6. Slave. Corruption in relay log -SET GLOBAL debug="+d,corrupt_read_log_event_char"; + +# +# Bug #58630 shows `+d' syntax has a side effect +# Andrei changed it to unsigned `d' version which does not affect the tests logics. +# todo: restore back to `+d' when Bug #58630, OBug#11765758 sorted out +# +SET GLOBAL debug="d,corrupt_read_log_event_char"; START SLAVE; let $slave_sql_errno= 1593; --source include/wait_for_slave_sql_error.inc -SET GLOBAL debug="-d,corrupt_read_log_event_char"; +# see above comments on `+d' syntax + +SET GLOBAL debug=""; # Start normal replication and compare same table on master # and slave --===============0557416178== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/andrei.elkin@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: andrei.elkin@stripped # target_branch: file:///home/andrei/MySQL/BZR/2a-23May/mysql-trunk/ # testament_sha1: c1b23fd182f1eea93a67c86a0b74f23373a084da # timestamp: 2011-03-08 21:29:29 +0200 # source_branch: file:///home/andrei/MySQL/BZR/2a-23May/mysql-trunk-\ # bugfixing/ # base_revision_id: build@stripped # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWYDnjd0AAsffgEAQWO///3/l 3gD////wYAbur4KLrE6xtqUoqSVFBKmgmppM9UPKejKbFAPUAHqMTQ00eo0ANSTTIPJBoDJmiAMI GgaYmhkNA5gTE0GEyZMmRhME00yMTAEMAkhJpo1GICbVMZDSTQAPUNpDT1GaR6Q5gTE0GEyZMmRh ME00yMTAEMAkkE00CekaZBNGpiZqZGhDQABoNMs2H8T028ddIIe05RO98NZI/A14VYqnOc9FsQUa EUbBxujjFX0xKt2n++uX8GHSfuYjMwzBb70XSmyx9WONuqUTkGPawQjicuUqbbnCVvrR8x66cnMz hMUYxiRLvwuZu6nVfo9oVkEndev0f2YPOMb63PMids9b6+wfuZHh69c632NtuuuIwqjmRXHrpGXf ObW6GEFaGDq8LHYsv4tJaS+cjSyErm1wna5sGZ7y+mXbysPXx0cZt8RY6Mz3gugrzmNJDsP4CykT +VQzVF80KCp5AbYzh5CsO7RZ3BWS6qp8HUvtiTTIN/rQZlBGY2qokxv1NRQ8t2BYhVaM6bzJJgGQ mx7nJB5C7+8lvkVbxTtSK1KN4OO026D5i8MVNkPcdtpQTGU4E0JDG0v9UUlqj9/eVeNecrZ1X7tu xK4bIKeN9/aKEisufbUbdRA2+fFcsROAtITLa1QsLCg+7TSuk7FhYkDryW5/cS21WC5AciNRlrK4 IreqFZYZHNehWajCp5YyvJJGolKY07BQSNgGyqgwxmUpgPf/xthsJBzABcyiCF9GrbBgqmGCGskr HUYMM6Iu6T2kyFbFQ+BXHTBC6R7wHcjjtNZuTPoOfJ9E+yOADZNpF0kzA7xY96ux2XCursIjh1o8 UZywJHEjEY14DznVpLEI3GpgO7Kq2+RgSymLtvKEU2I8mKlKiZaqDSweDMeVxjBaxXYYGyyMUiA9 PtVAIJYMXjUe+VuJcXF6bWz0LQCBmm5VWUzaC4zMLd5w6y+mh9et2pVYErR4K2tSklCidKWBIch8 YdWIpc3INXFcBZkMHIY3DFtEVeznLYNVeUGmkLIXyCJctaJcGpxOPlKfh5hal5fswfH4BprpuCk/ g/n8nti0MAudRd0nsEdRiZsQGRoReeP2RHihgL5Qd5eikLv4/HpEg/wKz3+lyCBcfFjGZXipIjr1 23vHyqZ3geKYx/rMyWo2uJq9J1q6Ob6QluHEMR9eoPH4C9pUfDgS9xyIwPSusrHOVMZha0oXbMYX g5XEoNBCBJIb2/SNtlZO5In0YH4nIDgbSbINXiJW0b3lwjdCrduWUohKVfNfk3gairrKeNeh1Fy9 V4TdWFuyRVJFSmondQaMmeHCec1dw9paQkTpL3LE9lT5unzcyGzaTHNg3wnthVe4ckdZhs08zmZH qniRJEepx9Jtyy8T2HSlzhsQuRAltNsXLoatdQWHLO23Jzgv3aFvhCP45t2YpFx0lqbD4vMqgbdo 1EHWMdDpnCVktztwlHpujUrb9/blPs7dtFABmoMMLD2DkRgi/CVvM9Ry48TOBBHCi38uYHoeHQYx WxMO7gGy3BE2MM5OMAHA8IAPUCxS0+QDX+h03cHdhxx3EyJQH8smZLT+Tj3FXYBVilkkSJgO8ytP OUex2PPXzNjI1YPn1Kcc1ogiSw/ZzILnORrdbbLZdH/uOk5ahhDBy1VruQyxDE3d2HlYdldot3BZ OiI3I9vNcaL2pbzEMET2xX7k56WgnLa58xakDC2cgLPdRB1auVu4aDYbHuyQpCberi3hRUHVEYL1 sXt61YTmqxmK2Quo9jkkDNcPZDMhvIZBG5rKZWpTRfB1TB5k2S/UIdRR0Ose7idvJ0EHYOb30cAy G7rMwCw0MwA0vdCMxmZbkDkVMNaoguxc4rA0bZ/lSmHBulM+uoqzlh1uGBmN9K134LWBDISbSEq2 BSReg/A4rK3pdMd0HjJZwJbdi0KLGo7uUNmZ1JDlNk0oMEajvhVvq+h1gS21WS/SrOzM72FLlcCb N07WKYLzeuFIkhpGTZvg/LLQXvFCqSdhlr7b1vethE5bckSNBkxMJjbzmgwChdhCCjWlUOXMYmhe PFGoPCeTY6DX3PuarB/ewRvnhAsiHA0CA9hggTIMWXELZObEd1BmRHYidl6gLSRES2vfsLtpTViI 4WAuUzWBJbGHaxsWfcwbdTaK33nQ40uPEyGGReyhLmyumN0NEAt6799nzkGvan3Zm5Pk9ENjzRup MmvlUFe9blZorTATxaKzNj5GQZIOHAT66U3WKH/i7kinChIQHPG7oA== --===============0557416178==--