Agents stops almost every day

More
9 years 4 months ago #10231 by hanisultan
Hello, I'm using V 5.7.7.21 and using Postgresql for repository and database. This is becoming a major issue and I don't know how to fix it. The agent gets stuck, I believe it can't connect to the DB, at random times but mostly in the morning. The database is running just fine, I can connect to it locally and remotely. What I do is stop the agent and started and it takes 3-5 tries before it connects, I get the "failed to connect" message.

What can I do?

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #10232 by admin
Replied by admin on topic Agents stops almost every day
Maybe the database is corrupted?

Stop the agent.
Do the full backup restore using postresql.

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #10233 by hanisultan
Possible but I'm writing queries againest it and able to connect to it remotely, no problem, I will try the back up and restore and see what happens

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #10234 by admin
Replied by admin on topic Agents stops almost every day
In the same folder where agent is located you should have file called <agent exe name>.log file

Can you post it here please

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #10235 by hanisultan
there you go

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #10236 by admin
Replied by admin on topic Agents stops almost every day
zip it please

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.