amoeba ERROR 1044 (42000): Could not create a validated object, cause: ValidateObject failed

部署amoeba过程中若出现错误：

ERROR 1044 (42000): Could not create a validated object, cause: ValidateObject failed

或

ERROR 1044 (42000): poolName=multiPool, no valid pools

解决办法：

dbServers.xml中的用户，需要在主从机上分配权限。同时注意该文件中的

<!-- mysql schema -->

<property name="schema">test</property>

test数据库肯定是要存在的。

 

mysql>GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;