- Posts: 725
- Thank you received: 15
Agents stops almost every day
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
9 years 4 months ago #10231
by hanisultan
Agents stops almost every day was created 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?
What can I do?
Please Log in or Create an account to join the conversation.
9 years 4 months ago #10232
by admin
Mike
ETL Architect
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
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.
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 725
- Thank you received: 15
9 years 4 months ago #10233
by hanisultan
Replied by hanisultan on topic Agents stops almost every day
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.
9 years 4 months ago #10234
by admin
Mike
ETL Architect
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
Can you post it here please
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 725
- Thank you received: 15
9 years 4 months ago #10235
by hanisultan
Replied by hanisultan on topic Agents stops almost every day
there you go
Please Log in or Create an account to join the conversation.