{question}
How to troubleshoot "This node is not managed by a supported tool. Please use a toolbox version at least as new as 1.14.0" Toolbox error during a SingleStore DB Upgrade?
{question}
{answer}
Consider the following Toolbox error:
upgrade failed. The cluster might be in an unhealthy state. The last error was: error running memsqlctl: error running command: `/usr/bin/memsqlctl --json --yes --verbose-json start-node --memsql-id 23AB1646D2289C5BFAB90D41B913EE07AB948285`: exit status 1:
stdout: (empty)
stderr: Latest errors from the database's tracelog:
10327197 2023-02-16 19:04:05.212 FATAL: Thread 115121 (ntid 2677550, conn id -1): jumpToUpgradeStep: This node is not managed by a supported tool. Please use a toolbox version at least as new as 1.14.0.
: Failed to connect to the database: process exited: exit status 1
Troubleshooting Steps
Step 1) Run sdb-toolbox-config version to confirm the version of the toolbox you are using.
sdb-toolbox-config
version Version: 1.15.1
Commit: b3f9e9a7c5271ae6548e044a5336b5a9aca6abc7
Step 2) If you are using a version of toolbox < version 1.14.0 upgrade the toolbox to the latest version. See Upgrade SingleStoreDB Toolbox. Otherwise, move on to the next step.
Step 3) Run sdb-admin update-config --all --key toolbox_version --value <version of toolbox per sdb-toolbox-config version here>. For example, the output should be like this,
ubuntu@kafka:~$ sdb-admin update-config --all --key toolbox_version --value 1.15.1
Toolbox is about to run 'memsqlctl update-config --key toolbox_version --value 1.15.1' on the following nodes:
- On host 127.0.0.1:
+ 23AB1646D2289C5BFAB90D41B913EE07AB948285
+ E51532945A12530BDCB0EF9D970BF4BB763861ED
+ 466FBF30AAB77E5AE98B848644E56BB423F31A3C
+ E35CC9B0D5374566F857427561BB4FC82DFFD96A
Would you like to continue? [y/N]: y
✓ Updated configuration on host 127.0.0.1
+------------------------------------------+-----------------------------------------+-------------+
| MemsqlID | Message | Result |
+------------------------------------------+-----------------------------------------+-------------+
| 23AB1646D2289C5BFAB90D41B913EE07AB948285 | Updated configuration on host 127.0.0.1 | changed |
| E51532945A12530BDCB0EF9D970BF4BB763861ED | Updated configuration on host 127.0.0.1 | changed |
| 466FBF30AAB77E5AE98B848644E56BB423F31A3C | Updated configuration on host 127.0.0.1 | changed |
| E35CC9B0D5374566F857427561BB4FC82DFFD96A | Updated configuration on host 127.0.0.1 | changed |
Step 5) Confirm Toolbox is reporting the correct state of the cluster withsdb-admin list-nodes.
In case of any further issues, Reach out to SingleStore support.
{answer}