Bug #79942 MySQL Fabric log-bin or gtid requirement logic failure

• Submitted: 13 Jan 2016 0:57
• Modified: 13 Jan 2016 7:08
• Reporter: Matthew Boehm
• Status: Won't fix
• Category: MySQL Fabric: Installation and Configuration
• Severity: S3 (Non-critical)
• Version: 1.6.3
• OS: Any
• CPU Architecture: Any
• Tags: Mysql Fabric

[13 Jan 2016 0:57] Matthew Boehm

Description:
When attempting to add a host to a group, mysqlfabric says that either binary logging or gtid must be enabled. I enabled binary logging, only and attempted to add host again. mysqlfabric gave same error.

[root@ip-172-30-3-220 ~]# mysqlfabric group add messages 172.30.3.247
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

ServerError: Server (5bd992e2-b986-11e5-874d-0ae03e37d8b5) does not have the binary log or gtid enabled.

mysql> select @@global.gtid_mode;
+--------------------+
| @@global.gtid_mode |
+--------------------+
| OFF                |
+--------------------+
1 row in set (0.00 sec)

mysql> select @@global.log_bin;
+------------------+
| @@global.log_bin |
+------------------+
|                1 |
+------------------+
1 row in set (0.00 sec)

How to repeat:
Attempt to add a host to a mysqlfabric group that does not have binary logging nor gtid enabled.

Suggested fix:
Either A) correct the logic inside mysqlfabric or B) correct the error message to say "AND" instead of "OR"

[13 Jan 2016 7:08] MySQL Verification Team

Hello Matthew Boehm,

Thank you for the report.
Verifying based on code inspection.

Thanks,
Umesh

[6 Jul 2017 19:20] Bugs System

Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)