Troubleshooting agent issues v9
You can troubleshoot these issues that can occur with the PEM agent.
Restoring a deleted PEM agent
If an agent was deleted from the pem.agent
table then you can't restore it. You need to use the pemworker utility to reregister the agent.
If an agent was deleted from the PEM web client but still has an entry in the pem.agent
table with value of active = f
, then you can restore the agent:
Check the values of the
id
andactive
fields:pem=# SELECT * FROM pem.agent;
Update the status for the agent to
true
in thepem.agent
table:pem=# UPDATE pem.agent SET active=true WHERE id=<x>;
Where
x
is the identifier that was displayed in the output of the query used in step 1.Refresh the PEM web client.
The deleted agent is restored. However, the servers that were bound to that agent might appear to be down. To resolve this issue, modify the PEM agent properties of the server to add the bound agent again. After the successful modification, the servers appear as running properly.
Updating configuration file path (agent status displaying as unknown)
If you move the agent configuration file (agent.cfg
) from its default location /usr/edb/pem/agent/etc
to another location, the PEM dashboard might display the agent status as “unknown”. In that case, you need to update the value of the agent configuration file path in the pemagent
service file.
Use the following command to modify the
pemagent
service file as a superuser:Update the
agent.cfg
file path. For example, on a Redhat host, update the file path:Reload
systemd
, to update the modified service script:Restart the PEM agent:
Using the command line to delete a PEM agent with down or unknown status
Using the PEM web interface to delete PEM agents with Down or Unknown status can be difficult if the number of such agents is large. In this situation, you can use the command line interface to delete Down or Unknown agents.
Use the following query to delete the agents that are Down for more than N number of hours:
Use the following query to delete the agents with an Unknown status: