Date: Fri, 27 Apr 2018 14:17:58 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 227806] databases/mysql57-server: multi-master group replication doesn't seem to work Message-ID: <bug-227806-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D227806 Bug ID: 227806 Summary: databases/mysql57-server: multi-master group replication doesn't seem to work Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Some People Priority: --- Component: Individual Port(s) Assignee: mmokhi@freebsd.org Reporter: mefystofel@gmail.com Flags: maintainer-feedback?(mmokhi@freebsd.org) Assignee: mmokhi@freebsd.org $uname -a FreeBSD srv-db-01 11.1-RELEASE-p8 FreeBSD 11.1-RELEASE-p8 #0 r330926: Wed M= ar 14 13:59:52 CET 2018 $pkg info | grep mysql mysql57-client-5.7.22_1 Multithreaded SQL database (client) mysql57-server-5.7.22 Multithreaded SQL database (server) I'm trying to setup multi-master group replication (between three nodes) an= d I can't seem to bootstrap the primary node. The same procedure works fine on Debian Stretch (with the same version of MySQL). -=3Dmy.cnf=3D- [mysqld] gtid_mode =3D ON enforce_gtid_consistency =3D ON master_info_repository =3D TABLE relay_log_info_repository =3D TABLE binlog_checksum =3D NONE log_slave_updates =3D ON log_bin =3D binlog binlog_format =3D ROW transaction_write_set_extraction =3D XXHASH64 loose-group_replication_bootstrap_group =3D OFF loose-group_replication_start_on_boot =3D OFF loose-group_replication_ssl_mode =3D REQUIRED loose-group_replication_recovery_use_ssl =3D 1 loose-group_replication_single_primary_mode =3D OFF loose-group_replication_enforce_update_everywhere_checks =3D ON server_id =3D 10 bind-address =3D "192.168.58.36" loose-group_replication_group_name =3D "d504d507-1217-11e8-8d30-005020a0d30= 2" loose-group_replication_ip_whitelist =3D "192.168.58.36,192.168.58.37,192.168.58.38" loose-group_replication_group_seeds =3D "192.168.58.36:33006,192.168.58.37:33006,192.168.58.38:33006" loose-group_replication_single_primary_mode =3D OFF loose-group_replication_enforce_update_everywhere_checks =3D ON report_host =3D "192.168.58.36" loose-group_replication_local_address =3D "192.168.58.36:33006" -=3DSQL=3D- SET SQL_LOG_BIN=3D0; CREATE USER 'replica'@'%' IDENTIFIED BY 'xxx' REQUIRE SSL; GRANT REPLICATION SLAVE ON *.* TO 'replica'@'%'; FLUSH PRIVILEGES; SET SQL_LOG_BIN=3D1; CHANGE MASTER TO MASTER_USER=3D'replica', MASTER_PASSWORD=3D'xxx' FOR CHANN= EL 'group_replication_recovery'; INSTALL PLUGIN group_replication SONAME 'group_replication.so'; SET GLOBAL group_replication_bootstrap_group=3DON; START GROUP_REPLICATION; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log. SELECT * FROM performance_schema.replication_group_members; +---------------------------+-----------+-------------+-------------+------= --------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +---------------------------+-----------+-------------+-------------+------= --------+ | group_replication_applier | | | NULL | OFFLI= NE=20=20 | +---------------------------+-----------+-------------+-------------+------= --------+ 1 row in set (0.00 sec) -=3D Logs =3D- 2018-04-27T09:44:10.6NZ mysqld_safe Logging to '/var/db/mysql/srv-db-01.err= '. 2018-04-27T09:44:10.6NZ mysqld_safe Starting mysqld daemon with databases f= rom /var/db/mysql 2018-04-27T09:44:10.899254Z 0 [Warning] TIMESTAMP with implicit DEFAULT val= ue is deprecated. Please use --explicit_defaults_for_timestamp server option (= see documentation for more details). 2018-04-27T09:44:10.901715Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.22-log) starting as process 23378 ... 2018-04-27T09:44:10.906855Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-04-27T09:44:10.906990Z 0 [Note] InnoDB: Uses event mutexes 2018-04-27T09:44:10.907083Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-04-27T09:44:10.907170Z 0 [Note] InnoDB: Compressed tables use zlib 1.2= .11 2018-04-27T09:44:10.907660Z 0 [Note] InnoDB: Number of pools: 1 2018-04-27T09:44:10.907873Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-04-27T09:44:10.909738Z 0 [Note] InnoDB: Initializing buffer pool, total size =3D 128M, instances =3D 1, chunk size =3D 128M 2018-04-27T09:44:10.929881Z 0 [Note] InnoDB: Completed initialization of bu= ffer pool 2018-04-27T09:44:10.946047Z 0 [Note] InnoDB: Highest supported file format = is Barracuda. 2018-04-27T09:44:10.964472Z 0 [Warning] InnoDB: Resizing redo log from 2*16= 384 to 2*3072 pages, LSN=3D2598701 2018-04-27T09:44:11.085718Z 0 [Warning] InnoDB: Starting to delete and rewr= ite log files. 2018-04-27T09:44:11.110520Z 0 [Note] InnoDB: Setting log file ./ib_logfile1= 01 size to 48 MB 2018-04-27T09:44:11.466069Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2018-04-27T09:44:11.840825Z 0 [Note] InnoDB: Renaming log file ./ib_logfile= 101 to ./ib_logfile0 2018-04-27T09:44:11.841082Z 0 [Warning] InnoDB: New log files created, LSN=3D2598701 2018-04-27T09:44:11.841594Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-04-27T09:44:11.841786Z 0 [Note] InnoDB: Setting file './ibtmp1' size t= o 12 MB. Physically writing the file full; Please wait ... 2018-04-27T09:44:11.960047Z 0 [Note] InnoDB: File './ibtmp1' size is now 12= MB. 2018-04-27T09:44:11.961302Z 0 [Note] InnoDB: 96 redo rollback segment(s) fo= und. 96 redo rollback segment(s) are active. 2018-04-27T09:44:11.961391Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-04-27T09:44:11.961747Z 0 [Note] InnoDB: Waiting for purge to start 2018-04-27T09:44:12.012742Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 2598692 2018-04-27T09:44:12.013421Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-04-27T09:44:12.013627Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool 2018-04-27T09:44:12.026908Z 0 [Note] InnoDB: Buffer pool(s) load completed = at 180427 11:44:12 2018-04-27T09:44:12.089689Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-04-27T09:44:12.089851Z 0 [Note] Skipping generation of SSL certificate= s as certificate files are present in data directory. 2018-04-27T09:44:12.090871Z 0 [Warning] CA certificate ca.pem is self signe= d. 2018-04-27T09:44:12.091055Z 0 [Note] Skipping generation of RSA key pair as= key files are present in data directory. 2018-04-27T09:44:12.092368Z 0 [Note] Server hostname (bind-address): '192.168.58.36'; port: 3306 2018-04-27T09:44:12.092477Z 0 [Note] - '192.168.58.36' resolves to '192.168.58.36'; 2018-04-27T09:44:12.092593Z 0 [Note] Server socket created on IP: '192.168.58.36'. 2018-04-27T09:44:12.128198Z 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=3Dsrv-db-01-relay-bin' to avoid this problem. 2018-04-27T09:44:12.197042Z 0 [Note] Event Scheduler: Loaded 0 events 2018-04-27T09:44:12.197333Z 0 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.7.22-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2018-04-27T09:46:14.025321Z 3 [ERROR] Plugin group_replication reported: 'C= an't read the server values for the read_only and super_read_only variables.' 2018-04-27T09:46:14.025456Z 3 [ERROR] Plugin group_replication reported: 'C= an't read the server value for the super_read_only variable.' 2018-04-27T09:46:14.025468Z 3 [ERROR] Plugin group_replication reported: 'C= ould not enable the server read only mode and guarantee a safe recovery executio= n' 2018-04-27T09:46:14.025485Z 3 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member' 2018-04-27T09:46:14.025497Z 3 [ERROR] Plugin group_replication reported: 'E= rror calling group communication interfaces while trying to leave the group' --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-227806-7788>