← Back to team overview

maria-discuss team mailing list archive

Re: MEMORY tables and binlog

 

Hi, Dajka!

This looks like a bug.
Could you report it at jira.mariadb.org?
Do you know when it happen, can you reproduce it at will?

On Apr 07, Dajka Tamás wrote:
> Hi All,
> 
> When checking the binlog on the new-node01 with mysqlbinlog, I get the
> following:
> 
> # at 2361
> #210407 11:13:34 server id 4 end_log_pos 2403 CRC32 0x90080d27 GTID 100-4-37336878143 trans
> /*!100001 SET @@session.gtid_seq_no=37336878143*//*!*/;
> START TRANSACTION
> /*!*/;
> # at 2403
> #210407 11:13:34 server id 4 end_log_pos 2527 CRC32 0x27183d2f Query thread_id=341297541 exec_time=318 error_code=0
> SET TIMESTAMP=1617786814/*!*/;
> DELETE FROM `mydb1`.`collect_output`e<FB>#<98>
> /*!*/;
> # at 2527
> #210407 11:13:34 server id 4 end_log_pos 2598 CRC32 0x427f0ed7 Table_map: `mydb1`.`collect_output` mapped to number 1330
> 
> Is this a bug or a known issue? Is there any other way to solve this, than
> exclude the MEMORY tables from the replication?

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx


Follow ups

References