Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Database query failed on vMotion Deep Security Agent (DSA)

    • Updated:
    • 28 Aug 2017
    • Product/Version:
    • Deep Security 10.0
    • Deep Security 10.1
    • 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
Public

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

To fix the issue:

  1. Check if there is a scheduled task running an activation or deactivation job on vMotion or vCenter sync. Disable the task, if any.
  2. Execute the following SQL commands:

    delete * from managerjobs where completeddate = null or completeddate='';

  3. Start the Deep Security Manager.
  4. Run the following commands on cmd:

    dsm_c –action resetevents -type all
    dsm_c -action resetcounters

  5. Restart the DSM node.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1116764
Feedback
Did this article help you?

Thank you for your feedback!

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


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.