Skip to main content
deleted 1 characters in body
Source Link

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just useruse sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it'smysqlbinlog is able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the part up to and including the long statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the part up to and including the long statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just use sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if mysqlbinlog is able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the part up to and including the long statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

added 36 characters in body
Source Link

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the part up to and including the long statement. Run Run the modified script manually manually on the slave and set the master_logfile to to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the part up to and including the long statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

added 31 characters in body
Source Link

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

IfOr just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

A possible solution that comes to mind is to set the master_log_position to the next one:

change master to master_log_position = <next_pos>;
start slave;

Or just user sql_slave_skip_counter = 1. If that doesn't work, you may try to parse the binlog (if it's able to parse it ...):

mysqlbinlog filename > script.sql

Edit the script and remove the statement. Run the modified script manually on the slave and set the master_logfile to the next binlog:

change master to master_log_file ...;
start slave;

You may also check, just in case, if both master and slave use the same max_allowed_packet.

added 31 characters in body
Source Link
Loading
Source Link
Loading