A host can only exist in one Cluster at a time.
If an "Add Existing Cluster"-job fails, and a subsequent retry throws the error:
"Host 1.2.3.4:nnnn is already in an other cluster."
Then you can do the following things in order
- Check if you have an /etc/cmon.d/cmon_X.cnf file that contains the hostname and remove the file:
rm /etc/cmon.d/cmon_X.cnf
- Delete the host from server_node, mysql_server, and hosts table.
mysql -ucmon -p -h127.0.0.1
use cmon;
DELETE FROM server_node WHERE hostname='1.2.3.4';
DELETE FROM mysql_server WHERE hostname='1.2.3.4';
DELETE FROM hosts WHERE hostname='1.2.3.4'; - Restart cmon:
service cmon restart
Notes:
You may have to execute the deletion several times for each hostname/IP of the cluster you are trying to add
The '1.2.3.4' is an example address.
The X in cmon_X.cnf should be replaced by a number.
Be careful to not remove the wrong cmon_X.cnf file
Comments
7 comments
@rainbow obby You may need to repeat the deleting process for each hostname/IP of the cluster you are attempting to add.
In the scenario where the "Add Existing Cluster" job encounters an error stating, "Host 1.2.3.4:nnnn is already in another cluster," several steps can be taken to resolve the issue. First, check for the existence of the /etc/cmon.d/cmon_X.cnf file containing the hostname and remove it if found. Next, delete the host from the server_node, mysql_server, and hosts tables in the cmon database. Afterward, restart cmon using the command "service cmon restart." It's essential to replace '1.2.3.4' with the actual IP address, and exercise caution not to delete the wrong cmon_X.cnf file. Execute deletions multiple times if needed. For an equally seamless experience, explore Bitstarz for online gaming
YOU ARE ALWAYS LIKE THIS!
try it -> https://fnfunkin.onl/
Thanks for sharing insights on managing clusters effectively! If you're keen on exploring innovative ways to optimize your workflow and enhance productivity, you might enjoy checking out <a href="https://www-reminimodapk.com/">Remini Mod APK</a>.
<a href="https://docs.google.com/spreadsheets/d/1zsh1CmHs2pw08cfmWj82cqh8lPgtTZ6ZeHxZql3PDOI/edit?gid=0#gid=0">Thank you</a> for sharing insights on managing clusters effectively!
Please sign in to leave a comment.