Bug #112775 Contribution: Rondb 475 contribute

• Submitted: 19 Oct 2023 14:17
• Modified: 11 Dec 2023 20:07
• Reporter: OCA Admin (OCA)
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• OS: Any
• 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.