gmo-media / mikasafabric

mikasafabric for MySQL is fork product of MySQL Fabric.
https://example.com/
GNU General Public License v2.0
3 stars 3 forks source link

mikasafabric does not try to reconnect server when its config is changed #6

Open asayamakk opened 6 years ago

asayamakk commented 6 years ago

Problem

Although config are all correct, mikasafabric fails to add servers because of previous failed cache.

To Reproduce

$ mikasafabric --version
mikasafabric 1.5.6

$ mysqld --version
/usr/local/mysql5717/bin/mysqld  Ver 5.7.17 for linux-glibc2.5 on x86_64 (MySQL Community Server (GPL))

on mikasafabric client

$ mikasafabric group add midori 192.168.199.178:3307
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

ServerError: User (mikasa_fabric@192.168.199.179) does not have appropriate privileges (DELETE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SELECT, SUPER, TRIGGER ON *.*) on server (192.168.199.178:3307, 1a801ed4-cb5b-11e7-83bc-fa163e548e11).

and then on 192.168.199.178:3307

mysql > GRANT ALL ON *.* TO mikasa_fabric@192.168.199.179 WITH GRANT OPTION;

on mikasafabric client again

$ mikasafabric group add midori 192.168.199.178:3307
Fabric UUID:  5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

ServerError: Error trying to configure server (1a801ed4-cb5b-11e7-83bc-fa163e548e11) as slave: Command (STOP SLAVE  FOR CHANNEL '', ()) failed accessing (192.168.199.178:3307). 1045 (28000): Access denied for user 'mikasa_fabric'@'192.168.199.179' (using password: YES)..

however there is no 'Access denied' log on 192.168.199.178:3307 host.

What To Expect

mikasafabric should not keep failed cache.

問題

正しい設定をしていても前回の失敗のキャッシュを保持しているため、サーバの追加に失敗する

再現方法

上と同じです

期待する動作

接続に失敗したキャッシュを保持しない

Thanks :)

yoku0825 commented 6 years ago

Thank you for your reporting.