[MDEV-28487] sequences not respect value of binlog_row_image with select nextval(seq_gen) Created: 2022-05-06  Updated: 2022-07-26  Resolved: 2022-07-13

Status: Closed
Project: MariaDB Server
Component/s: Replication, Sequences
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2

Type: Bug Priority: Critical
Reporter: Richard Stracke Assignee: Brandon Nesterenko
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MXS-4120 Avrorouter crash with a SEQUENCE engi... Closed

 Description   

Even with binlog_row_image = full, select nextval(seq_gen) write to binlog in binlog_row_image = minimal mode.

 
 
START TRANSACTION
 
/*!*/;
 
# at 15406542
 
# at 15406588
 
#220504 18:00:23 server id 202  end_log_pos 15406588 CRC32 0xe4eb5cad 	Annotate_rows:
 
#Q> select nextval(seq_gen)
 
### INSERT INTO `t1`.`seq_gen`
 
### SET
 
###   @1=3000 /* LONGINT meta=0 nullable=0 is_null=0 */
 
###   @8=0 /* LONGINT meta=0 nullable=0 is_null=0 */



 Comments   
Comment by Brandon Nesterenko [ 2022-07-07 ]

Hi Andrei! This is ready for review:

PR-2184

Comment by Andrei Elkin [ 2022-07-11 ]

Notes are provided on GH.

Comment by Brandon Nesterenko [ 2022-07-13 ]

Pushed into 10.3 as 02e85ae.

No merge conflicts occurred when cherry-picking through 10.10.

The new test, rpl.rpl_row_img_sequence, may fail intermittently on kvm-ports-freebsd130-amd64 due to MDEV-28986

Generated at Thu Feb 08 10:01:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.