slave_max_allowed_packet Not Honored on Slave IO Reconnect
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
George Ormond Lorch III | ||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
George Ormond Lorch III | ||
5.6 |
Fix Released
|
High
|
George Ormond Lorch III |
Bug Description
Description:
It seems that in the event that a slave was disconnected from the master, under certain conditions, upon reconnect, it will report that it received a packet larger the slave_max_
Using my test below, max_allowed_packet is set to 4M, slave is 1M and slave_max_
If I do stop slave; start slave; the replication would go through fine.
How to repeat:
This is using MySQL Sandbox and the test file can be anything around 1.5M, have not tested up to what size limits would work.
<script>
#!/bin/bash
VER=$1
PRT=$2
PFX=$3
PTH=/ssd/
ERR=1
#while [ $ERR ]; do
sbtool -o delete --source_dir=$PTH 2>&1 /dev/null
make_replicatio
for n in master node1 node2; do
cat >> $PTH/$n/
innodb_
binlog_format=ROW
secure-
EOF
done
$PTH/restart_all 2>&1 /dev/null
$PTH/master/restart
$PTH/m -e 'set global max_allowed_packet = 1048576*4'
t=$(cat <<EOF
show global variables like '%packet%';
CREATE TABLE tblblobs (
id int(11) NOT NULL AUTO_INCREMENT,
activity_
blob_name char(16) NOT NULL COMMENT 'unique blob name',
status enum('INCOMPLET
payload mediumblob NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY blob_name (blob_name)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO tblblobs (blob_name, payload) VALUES('test', LOAD_FILE(
INSERT INTO tblblobs (blob_name, payload) VALUES('test', LOAD_FILE(
EOF
)
echo $t | $PTH/m test
sleep 60
$PTH/s1 -e "SHOW SLAVE STATUS \G"|grep slave_max_
ERR=$?
#done
</script>
This is a cross report for http://
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 83 lines (+39/-7)5 files modifiedPercona-Server/mysql-test/suite/rpl/r/rpl_bug68490.result (+8/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-master.opt (+1/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-slave.opt (+2/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490.test (+21/-0)
Percona-Server/sql/slave.cc (+7/-7)
- Stewart Smith (community): Approve
-
Diff: 92 lines (+45/-10)5 files modifiedPercona-Server/mysql-test/suite/rpl/r/rpl_bug68490.result (+11/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-master.opt (+1/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-slave.opt (+2/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490.test (+21/-0)
Percona-Server/sql/rpl_slave.cc (+10/-10)
George -
What is the status of this bug on 5.1?