12-18-2018 10:12 AM - edited 01-29-2022 12:48 PM
Error Code: No suitable servers found: `serverSelectionTimeoutMS` expired: [connection refused calling ismaster on 'localhost:27018']: generic server error" code:
Check the mongod.lock file is > 0KB in size.
Alteryx Server had an unclean shutdown.
If the mongod.lock file does have data inside (1KB usually), we recommend you first backup your persistence database (in case of corruption) before proceeding. Alternatively, in step 1 below, rename the file instead of deleting it if you do not have a backup.
cd "\Program files\Alteryx\bin"
mongod --dbpath "folder path from system settings" --auth --port 27018
sc start AlteryxService
cd "\Program files\Alteryx\bin
AlteryxService test
Alteryx Server v2018.4
Thanks you, Jessica, for this article.
I attempted to execute this procedure because we had a server that wouldn't automatically restart its service after a maintenance reboot. Executed the steps and a rebooted the server after; AlteryxService started as needed. Will monitor for a period to see if this issue occurs again.
FWIW: Noted in the service log that there were repeated timeout errors during the restart "...Error <No suitable servers found: `serverSelectionTimeoutMS` expired...". The total elapsed time between the first and last error was approx 45 seconds. Is serverSelectionTimeoutMS a configurable value that could be set to a longer interval to wait for the system to boot up and respond?
Regards,
KJ
Thanks for this wonderful and lucid explanation. It helped me restart my Alteryx services.
For me the services would not run through Services.msc , command line and through Alteryx system settings during multiple attempts. So used the approach given in the post above and it worked.
Regards,
Varun
First of all, check if the disk is full.
Hi
Thank you for the info, i have tried upgrading the server and experiencing issues.
the mongolock file is 0kb and when running the test mentioned above, i receive the below error:
E:\Program Files\Alteryx\bin>AlteryxService test AlteryxService version: 2021.4.2.05617 PID: 4488 main thread: 8832 Local logging enabled level <7> path <E:\Alteryx Data\Service\AlteryxServiceLog.log>.
Starting Telemetry service...
Starting Logging service...
Starting Status service...
Starting Settings service...
Starting EmbeddedMongo service...
There was an error starting the Alteryx Service: Mongo error: "No suitable servers found: `serverSelectionTimeoutMS` expired: [Failed to connect to target host: localhost:27018]: generic server error" code: <mongodb:13053>