MySQL Bugs: #113225: Error on observer while running replication hook 'before

Bug #113225	Error on observer while running replication hook 'before_commit'
Submitted:	26 Nov 2023 22:13	Modified:	27 Dec 2023 17:22
Reporter:	asdasdasd asdasdasdsad	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Group Replication	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Error on observer while running replication hook 'before_commit'. On 200k rows update query encrypting data on 100k it worked fine

How to repeat:
UPDATE table
SET col1 = TO_BASE64(AES_ENCRYPT(col1, @keyBase, @static_iv)), 
col2 = TO_BASE64(AES_ENCRYPT(col2 , @keyBase, @static_iv))

Hi,
I did not manage to reproduce the problem. Can you give us more data on how to reproduce.

Thanks

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

We faced the same issue today for a certain `UPDATE` statement. 
MySQL 8.0.28
ERROR 3100 (HY000) at line 90470 in file: 'Platinum6-24.05.3.1.sql': Error on observer while running replication hook 'before_commit'.

Looking into MySQL error shows:
Error on session 157083. Transaction of size 261566573 exceeds specified limit 150000000. To increase the limit please adjust group_replication_transaction_size_limit option.

show variables like 'group_replication_transaction_size_limit';
This is dynamic and can be adjusted and reverted back to default after the above update completes as a solution to the this error. 

https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html#sysvar_gro...
From MySQL 8.0, the default setting for this system variable is 150000000 bytes (approximately 143 MB).