[MDEV-16900] [Draft] Read invalid event from master: 'Found invalid event in binary log' Created: 2018-08-05  Updated: 2023-11-26  Resolved: 2023-11-26

Status: Closed
Project: MariaDB Server
Component/s: Replication, Storage Engine - RocksDB
Affects Version/s: 10.5.15, 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: File mysql-bin.000126     File mysql.err     File mysql.err    

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/411936374

10.3 d453374fc480112266996a1026b97654cc174c09

2018-08-04 16:55:02 9 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:19300' in log '' at position 4
2018-08-04 16:55:02 9 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:19300',replication starts at GTID position ''
2018-08-04 16:55:02 10 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 4, relay log './mysql-relay-bin.000001' position: 4; GTID position ''
2018-08-04 16:57:16 9 [ERROR] Read invalid event from master: 'Found invalid event in binary log', master could be corrupt but a more likely cause of this is a bug
2018-08-04 16:57:16 9 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
2018-08-04 16:57:16 9 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000126', position 4; GTID position 0-1-619
2018-08-04 16:57:20 10 [Note] Error reading relay log event: slave SQL thread was killed
2018-08-04 16:57:20 10 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000126' at position 4; GTID position '0-1-619'

The mentioned binary log and the error logs from master and slave are attached. The whole data directory and all binary logs are available on demand.

Not reproducible right away by converting to the MTR test.

dev 2757a4ca0d5b94d5966761fd342386ebaa7d5903

perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --engine=RocksDB --duration=350 --threads=6 --seed=1533401695 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/versioning.yy --mysqld=--log_output=FILE --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=RocksDB --mysqld=--plugin-load-add=ha_rocksdb --mysqld=--log_bin_trust_function_creators=1 --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --rpl-mode=row-nosync --use-gtid=current_pos


Generated at Thu Feb 08 08:32:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.