Alteryx Service stopping intermittently due to issues with MongoDB(connection refused)

Question

Hi all, We are currently using Alteryx server. Few times a week, the service is going down intermittently due to be below issues. 2020-04-21 06:16:27.115000,ALERT,9864,AlteryxService,,,,,,,,"Starting EmbeddedMongo service" 2020-04-21 06:16:35.925000,ERROR,9864,AlteryxService,,,,,,,,"Persistence_MongoDB.cpp: 350. Mongo error: ""No suitable servers found (`serverSelectionTryOnce` set): [connection refused calling ismaster on 'localhost:27018']: generic server error"" code: " 2020-04-21 06:16:38.763000,ERROR,31884,AlteryxService,MongoController,,,2020-04-21 06:16:35.434801,n6wapp00016,37052,33964,"MongoDaemon_PingImpl_SocketError: Error code " 2020-04-21 06:16:41.784000,ERROR,9864,AlteryxService,,,,,,,,"AlteryxService_SvcReportEvent: App message >" 2020-04-21 06:16:41.784000,ERROR,9864,AlteryxService,,,,,,,,"AlteryxService_LogStartupError: There was an error starting the Alteryx Service >" Once we restart the Service, the service works fine without issues for few days and stops again.

fharper · Answer

We are on 2019.4.8 and have been for a month and the service went down late this afternoon and would not restart. We thought it was an issue with a backend auth system component, one of the SQL DBs was down. But once fixed the service still would not restart. keeps going into Stopped status , never gets to running. We have a main server and a worker. 2020-08-23 01:33:31.245312,USLILVMALTRYX03,2692,2516,"ClientConnection.cpp: 347. Server Error: 404" 2020-08-23 01:33:31.371000,ERROR,5892,AlteryxService,RenderWorker,,,,2020-08-23 01:33:31.245312,USLILVMALTRYX03,2692,2516,"RenderWorkerThread_DoWork_Error: Error in render worker, PID <2692> id error ."No one seems to know what is causing and thus how to fix???

wildflower · Answer

Hi @masterarun - what Server version are you on? We're attempting to upgrade from 2019.4.6 to 2020.2.3 and are running into issues connecting to our user-managed MongoDB.