Database query failed on vMotion Deep Security Agent (DSA)

- Updated:
- 27 Feb 2017
- Product/Version:
- Deep Security 9.0
- Deep Security 9.5
- Deep Security 9.6
- Platform:
- N/A N/A

Summary

You may encounter the errors below in server0.log of Deep Security Manager (DSM):

Oct 13, 2016 11:28:58 AM com.thirdbrigade.manager.core.db.Locks lock
WARNING: ThID:239|TID:0|TNAME:Primary|UID:-1|UNAME:|Waiting for lock LOOK_FOR_JOBS_VMOTION.123
for tenant TID:0|TNAME:Primary on object null since 10/13/16 11:18 AM

Details

The error mentioned above indicates a database lock issue in performing a DSM task.

To fix the issue:

Check if there is a scheduled task running an activation or deactivation job on vMotion or vCenter sync. Disable the task, if any.
Execute the following SQL commands:
delete * from managerjobs where completeddate = null or completeddate='';
Start the Deep Security Manager.
Run the following commands on cmd:
dsm_c –action resetevents -type all
dsm_c -action resetcounters
Restart the DSM node.

Rating:

Category:

Troubleshoot

Solution Id:

1116764

Feedback

Did this article help you?

Thank you for your feedback!

What was the problem with this article?

The image(s) in the article did not display properly.

The article did not provide detailed procedure.

The article is hard to understand and follow.

The video did not play properly.

The article did not resolve my issue.

Others. Please specify.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

Thanks for voting.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.