cannot open ‘binlog.index’ for reading: No such file or directory

[trupti mali]

Hi,

I am getting the above error on primary node of the galera cluster. Because of which my second - newly configured cluster is not able to join in. Another information - I have a hybrid replication implementation. 

There is Async Replicaiton configured between two Galera clusters (Master to Master replicaiton) and the primary node mentioned above is one of the masters in it.

When I try to add one node to the galera custer of one of these two - i get below error on primary node -

LOGS:

Sep  3 07:08:19 localhost mysqld: tail: cannot open ‘binlog.index’ for reading: No such file or directory

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '192.168.<node2 ip>:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix ''  --binlog 'binlog' --gtid '0c771f10-4fb5-11e5-a418-164f3b890a85:1866'

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '192.168.<node 2 ip>:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix ''  --binlog 'binlog' --gtid '0c771f10-4fb5-11e5-a418-164f3b890a85:1866': 1 (Operation not permitted)

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [Note] WSREP: resuming provider at 1199

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [Note] WSREP: Provider resumed.

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '192.168.198.146:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix ''  --binlog 'binlog' --gtid '0c771f10-4fb5-11e5-a418-164f3b890a85:1866'

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [Warning] WSREP: 0.0 (192.168.199.182): State transfer to 1.0 (192.168.<node 2 ip>) failed: -1 (Operation not permitted)

Sep  3 07:08:19 localhost mysqld: 150903  7:08:19 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 1866)

Sep  3 07:08:20 localhost mysqld: 150903  7:08:20 [Note] WSREP: Member 0.0 (192.168.199.182) synced with group.

Sep  3 07:08:20 localhost mysqld: 150903  7:08:20 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1866).......

Also another finding - when I run on primary node - the below query it MariaDB [(none)]> SHOW BINARY LOGS;

+--------------------+-----------+

| Log_name           | File_size |

+--------------------+-----------+

| mariadb-bin.000001 |       333 |

| mariadb-bin.000002 |       977 |

| mariadb-bin.000003 |       347 |

| mariadb-bin.000004 |       554 |

| mariadb-bin.000005 |       414 |

| mariadb-bin.000006 |       739 |

| binlog.000001      |       342 |

| binlog.000002      |       537 |

| binlog.000003      |       358 |

| binlog.000004      |       379 |

| binlog.000005      |       415 |

| binlog.000006      |       415 |

| binlog.000007      |       375 |

+--------------------+-----------+

is this a concern?