From: Marc Alff Date: April 10 2012 9:39am Subject: bzr push into mysql-trunk-pfs-tuning branch (marc.alff:3493 to 3494) List-Archive: http://lists.mysql.com/commits/143435 Message-Id: <201204100839.q3A8di7r009505@acsmt358.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3494 Marc Alff 2012-04-10 [merge] Merge mysql-trunk --> mysql-trunk-pfs-tuning removed: mysql-test/suite/rpl/t/rpl_report_port-slave.opt modified: libmysqld/lib_sql.cc mysql-test/suite/rpl/r/rpl_corruption.result mysql-test/suite/rpl/r/rpl_master_pos_wait.result mysql-test/suite/rpl/r/rpl_report_port.result mysql-test/suite/rpl/t/rpl_corruption.test mysql-test/suite/rpl/t/rpl_master_pos_wait.test mysql-test/suite/rpl/t/rpl_report_port.test mysql-test/suite/sys_vars/t/innodb_buffer_pool_filename_basic.test storage/innobase/dict/dict0boot.cc storage/innobase/dict/dict0crea.cc storage/innobase/dict/dict0load.cc storage/innobase/handler/ha_innodb.cc storage/innobase/handler/ha_innodb.h storage/innobase/handler/handler0alter.cc storage/innobase/handler/i_s.cc storage/innobase/include/dict0boot.h storage/innobase/include/dict0crea.h storage/innobase/include/dict0load.h storage/innobase/os/os0file.cc 3493 Marc Alff 2012-04-06 [merge] Merge mysql-trunk --> mysql-trunk-pfs-tuning modified: mysql-test/collections/default.push mysql-test/mysql-test-run.pl mysql-test/suite/perfschema/include/digest_cleanup.inc mysql-test/suite/perfschema/include/digest_execution.inc mysql-test/suite/perfschema/include/digest_setup.inc mysql-test/suite/perfschema/r/digest_table_full.result mysql-test/suite/perfschema/r/start_server_no_digests.result mysql-test/suite/perfschema/r/statement_digest.result mysql-test/suite/perfschema/r/statement_digest_consumers.result mysql-test/suite/perfschema/r/statement_digest_consumers2.result storage/innobase/include/ut0vec.ic storage/perfschema/pfs_digest.cc === modified file 'libmysqld/lib_sql.cc' --- a/libmysqld/lib_sql.cc 2012-03-13 13:16:27 +0000 +++ b/libmysqld/lib_sql.cc 2012-04-06 18:58:01 +0000 @@ -349,6 +349,8 @@ static int emb_stmt_execute(MYSQL_STMT * set_stmt_errmsg(stmt, net); DBUG_RETURN(1); } + else if (stmt->mysql->status == MYSQL_STATUS_GET_RESULT) + stmt->mysql->status= MYSQL_STATUS_STATEMENT_GET_RESULT; DBUG_RETURN(0); } === modified file 'mysql-test/suite/rpl/r/rpl_corruption.result' --- a/mysql-test/suite/rpl/r/rpl_corruption.result 2012-03-23 20:11:19 +0000 +++ b/mysql-test/suite/rpl/r/rpl_corruption.result 2012-04-09 11:08:46 +0000 @@ -26,13 +26,13 @@ include/wait_for_slave_io_error.inc [err SET GLOBAL master_verify_checksum=0; SET GLOBAL debug="d,corrupt_read_log_event"; START SLAVE IO_THREAD; -include/wait_for_slave_io_error.inc [errno=1595,1721] +include/wait_for_slave_io_error.inc [errno=1595,1741] SET GLOBAL debug=""; SET GLOBAL master_verify_checksum=1; # 5. Slave. Corruption in network SET GLOBAL debug="d,corrupt_queue_event"; START SLAVE IO_THREAD; -include/wait_for_slave_io_error.inc [errno=1595,1721] +include/wait_for_slave_io_error.inc [errno=1595,1741] # 6. Slave. Corruption in relay log SET GLOBAL debug="d,corrupt_read_log_event_char"; START SLAVE SQL_THREAD; === modified file 'mysql-test/suite/rpl/r/rpl_master_pos_wait.result' --- a/mysql-test/suite/rpl/r/rpl_master_pos_wait.result 2012-03-23 20:11:19 +0000 +++ b/mysql-test/suite/rpl/r/rpl_master_pos_wait.result 2012-04-09 22:45:19 +0000 @@ -35,8 +35,8 @@ SQL_THREAD_WAIT_AFTER_GTIDS('', 2) 0 SELECT SQL_THREAD_WAIT_AFTER_GTIDS('error-gtid', 2); ERROR HY000: Malformed GTID set specification 'error-gtid'. -SELECT SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 2); +SELECT SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 0); STOP SLAVE SQL_THREAD; -SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 2) +SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 0) NULL include/rpl_end.inc === modified file 'mysql-test/suite/rpl/r/rpl_report_port.result' --- a/mysql-test/suite/rpl/r/rpl_report_port.result 2012-03-23 20:11:19 +0000 +++ b/mysql-test/suite/rpl/r/rpl_report_port.result 2012-04-10 06:03:57 +0000 @@ -3,9 +3,12 @@ Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives. [connection master] -include/assert.inc [The default value shown for the slave's port number is the actual port number of the slave.] include/rpl_restart_server.inc [server_number=2 parameters: --report-port=9000] include/start_slave.inc [Slave restarted with the report-port set to some value] include/assert.inc [The value shown for the slave's port number is 9000 which is the value set for report-port.] +include/rpl_restart_server.inc [server_number=2 parameters: --report-port=] +include/start_slave.inc +[Slave restarted with the report-port set to the value of slave's port number] +include/assert.inc [The default value shown for the slave's port number is the actual port number of the slave.] include/rpl_end.inc === modified file 'mysql-test/suite/rpl/t/rpl_corruption.test' --- a/mysql-test/suite/rpl/t/rpl_corruption.test 2012-03-06 22:52:58 +0000 +++ b/mysql-test/suite/rpl/t/rpl_corruption.test 2012-04-09 11:08:46 +0000 @@ -80,7 +80,7 @@ reap; SET GLOBAL debug="d,corrupt_read_log_event"; --connection slave START SLAVE IO_THREAD; -let $slave_io_errno= 1236; +let $slave_io_errno= 1236; # ER_MASTER_FATAL_ERROR_READING_BINLOG --source include/wait_for_slave_io_error.inc --connection master @@ -91,7 +91,7 @@ SET GLOBAL master_verify_checksum=0; SET GLOBAL debug="d,corrupt_read_log_event"; --connection slave START SLAVE IO_THREAD; -let $slave_io_errno= 1595,1721; +let $slave_io_errno= 1595,1741; # ER_SLAVE_RELAY_LOG_WRITE_FAILURE, ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE --source include/wait_for_slave_io_error.inc --connection master SET GLOBAL debug=""; @@ -102,14 +102,14 @@ SET GLOBAL master_verify_checksum=1; --connection slave SET GLOBAL debug="d,corrupt_queue_event"; START SLAVE IO_THREAD; -let $slave_io_errno= 1595,1721; +let $slave_io_errno= 1595,1741; # ER_SLAVE_RELAY_LOG_WRITE_FAILURE, ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE --source include/wait_for_slave_io_error.inc # Emulate corruption in relay log --echo # 6. Slave. Corruption in relay log SET GLOBAL debug="d,corrupt_read_log_event_char"; START SLAVE SQL_THREAD; -let $slave_sql_errno= 1593; +let $slave_sql_errno= 1593; # ER_SLAVE_FATAL_ERROR --source include/wait_for_slave_sql_error.inc # Start normal replication and compare same table on master === modified file 'mysql-test/suite/rpl/t/rpl_master_pos_wait.test' --- a/mysql-test/suite/rpl/t/rpl_master_pos_wait.test 2012-02-14 07:55:14 +0000 +++ b/mysql-test/suite/rpl/t/rpl_master_pos_wait.test 2012-04-09 22:45:19 +0000 @@ -53,7 +53,7 @@ SELECT SQL_THREAD_WAIT_AFTER_GTIDS('erro # SQL_THREAD_WAIT_AFTER_GTIDS: Check if it hangs when slave is # idle and STOP SLAVE is issued. # -send SELECT SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 2); +send SELECT SQL_THREAD_WAIT_AFTER_GTIDS('7805be8e-51ab-11e1-bacc-6706c20ad7ba:1', 0); --connection slave1 STOP SLAVE SQL_THREAD; --connection slave === removed file 'mysql-test/suite/rpl/t/rpl_report_port-slave.opt' --- a/mysql-test/suite/rpl/t/rpl_report_port-slave.opt 2012-02-28 08:32:27 +0000 +++ b/mysql-test/suite/rpl/t/rpl_report_port-slave.opt 1970-01-01 00:00:00 +0000 @@ -1 +0,0 @@ ---report-port= === modified file 'mysql-test/suite/rpl/t/rpl_report_port.test' --- a/mysql-test/suite/rpl/t/rpl_report_port.test 2012-03-09 02:37:16 +0000 +++ b/mysql-test/suite/rpl/t/rpl_report_port.test 2012-04-10 06:02:27 +0000 @@ -10,22 +10,18 @@ # #====Method==== # -# Start replication with report port not set.This will give the actual port -# number of the slave (ie. SLAVE_PORT) for the on doing SHOW SLAVE HOSTS on -# the master. -# Restart the slave server with report port set to 9000 and start the slave. +# Start replication with report port set to 9000 and restart the slave. # In this case on doing SHOW SLAVE HOSTS on the master, we get the port number # of the slave to be 9000. +# In the second case restart the slave server with report port not set. In this +# case on doing SHOW SLAVE HOSTS on the master, we get the actual port number +# of the slave (ie. SLAVE_PORT). source include/master-slave.inc; +source include/have_binlog_format_mixed.inc; connection master; ---let $report_port= query_get_value(SHOW SLAVE HOSTS, Port, 1) ---let assert_text= The default value shown for the slave's port number is the actual port number of the slave. ---let assert_cond= $report_port = "$SLAVE_MYPORT" ---source include/assert.inc - # Start the server with some value being passed to the report_port=