enterprise-support team mailing list archive

[Sveta Smirnova <sveta@xxxxxxxxxxxxx>]

Public bug reported:

Even after fix for bug #74734 mysqlbinlog cannot read events with
numbers, larger than 4G

How to repeat:
Create event, larger than 4G:

set binlog_format='row';
create table t1(f1 longtext);
insert into t1 values(repeat('a', 1073741824/2));
create table t2 like t1;
flush logs;
insert into t2 select f1 from t1 union all select f1 from t1 union all select f1 from t1 union all select f1 from t1 union all select f1 from t1 union all select f1 from t1 union all select f1 from t1 union all select f1 from t1;

Process binary log with mysqlbinlog using no options, it will succeed:

mysqlbinlog var/mysqld.1/data/master-bin.000002 >tmp.sql

Now find all valied positions:

cat tmp.sql | grep -i at > tmp.sql.cr 
cat tmp.sql.cr 
# at 4
#150723 22:33:08 server id 1  end_log_pos 120 CRC32 0x62430c0b  Start: binlog v 4, server v 5.6.25-73.1-debug-log created 150723 22:33:08
# at 120
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
# at 192
# at 238
# at 536871190
# at 1073742142
# at 1610613094
# at 2147484046
# at 2684354998
# at 3221225950
# at 3758096902
# at 4294967854
# at 4294967927
#150723 22:33:11 server id 1  end_log_pos 679 CRC32 0xd83ecaea  Rotate to master-bin.000003  pos: 4

Try to read binary log, starting from position 4294967854:

mysqlbinlog var/mysqld.1/data/master-bin.000002 --start-position=4294967854 >tmp.sql
mysqlbinlog: [Warning] option 'start-position': unsigned value 4294967854 adjusted to 4294967295
ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 1633771873, event_type: 97
ERROR: Could not read entry at offset 4294967295: Error in log format or read error.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.5
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.6
     Importance: Undecided
         Status: Confirmed


** Tags: i57211

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: Confirmed

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.5
       Status: New => Confirmed

** Bug watch added: MySQL Bug System #77818
   http://bugs.mysql.com/bug.php?id=77818

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=77818
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1477750

Title:
  mysqlbinlog cannot read events with numbers, larger than 4G

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1477750/+subscriptions