Bug #112775 Contribution: Rondb 475 contribute
Submitted: 19 Oct 2023 14:17 Modified: 11 Dec 2023 20:07
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: contributions

[19 Oct 2023 14:17] OCA Admin
Description:
This bug tracks a contribution by Mikael Ronström (Github user: mronstro, bug system user tag: Hopswork) as described in http://github.com/mysql/mysql-server/pull/496

How to repeat:
See description

Suggested fix:
See contribution code attached
[19 Oct 2023 14:17] OCA Admin
Contribution submitted via Github - Rondb 475 contribute 
(*) Contribution by Mikael Ronström (Github mronstro, mysql-server/pull/496#issuecomment-1756161112): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_1550237904.txt (text/plain), 10.82 KiB.

[19 Oct 2023 14:59] MySQL Verification Team
Hello Mikael,

Thank you for the report and contribution.

Sincerely,
Umesh
[27 Oct 2023 12:27] Magnus Blåudd
Posted by developer:
 
The MySQL Server fails when replicating "GRANT NDB_STORED_USER ..." with replication filter turned on. This  occurs since the replication filter causes all non-updating queries to return an error - with the assumption is that only changes need to be replicated.
[3 Nov 2023 11:07] Magnus Blåudd
https://github.com/mysql/mysql-server/pull/498
[3 Nov 2023 11:07] Magnus Blåudd
Posted by developer:
 
Also https://github.com/mysql/mysql-server/pull/498
[11 Dec 2023 20:07] Jon Stephens
Documented fix as follows in the NDB 8.0.36 and 8.3.0 changelogs:

    Replicating a GRANT NDB_STORED_USER statement with replication
    filters caused the SQL node to exit. This occured since the
    replication filter caused all non-updating queries to return an
    error, with the assumption that only changes needed to be
    replicated.

    Our thanks to Mikael Ronström for the contribution.

Closed.