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

Create a technical support case if you need further support.

SQL server deadlock issue occurs in Deep Security

    • Updated:
    • 12 Dec 2016
    • Product/Version:
    • Deep Security 9.5
    • Deep Security 9.5
    • Deep Security 9.6
    • Deep Security 9.6
    • Platform:
    • Amazon AMI 32-bit
    • Amazon AMI 64-bit
    • CentOS 5.4 32-bit
    • CentOS 5.4 64-bit
    • CentOS 5.5 32-bit
    • CentOS 5.5 64-bit
    • CentOS 5.6 32-bit
    • CentOS 5.6 64-bit
    • CentOS 5.7 32-bit
    • CentOS 5.7 64-bit
    • CentOS 5.8 32-bit
    • CentOS 5.8 64-bit
    • CentOS 6 32-bit
    • CentOS 6 64-bit
    • CentOS 6.1 32-bit
    • CentOS 6.1 64-bit
    • CentOS 6.2 32-bit
    • CentOS 6.2 64-bit
    • HPUX 11.x
    • IBM AIX 6.1
    • Linux - Red Hat RHEL 5 32-bit
    • Linux - Red Hat RHEL 5 64-bit
    • Linux - Red Hat RHEL 6 32-bit
    • Linux - Red Hat RHEL 6 64-bit
    • Linux - SuSE 10
    • Linux - SuSE 10 64-bit
    • Linux - SuSE 11
    • Linux - SuSE 11 64-bit
    • Oracle Linux 5 32-bit
    • Oracle Linux 5 64-bit
    • Oracle Linux 6 32-bit
    • Oracle Linux 6 64-bit
    • Oracle Solaris 11 SPARC
    • Oracle Solaris 11 x86
    • Ubuntu 10.04 64-bit
    • Ubuntu 12.04 64-bit
    • Unix - Solaris (Sun) version 10 (SunOS 5.10)
    • Unix - Solaris (Sun) version 9 (SunOS 5.9)
    • VMware vSphere 5.1
    • VMware vSphere 5.5
    • Windows 2003 Server R2
    • Windows 2003 Small Business Server
    • Windows 2003 Small Business Server R2
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Essential Business Server
    • Windows 2008 Server Core
    • Windows 2008 Server Foundation
    • Windows 2008 Server R2
    • Windows 2008 Server R2 Datacenter
    • Windows 2008 Server R2 Enterprise
    • Windows 2008 Server R2 with Hyper-V(TM)
    • Windows 2008 Small Business Server
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Datacenter R2
    • Windows 2012 Enterprise
    • Windows 2012 Server Essential R2
    • Windows 2012 Server Foundation R2
    • Windows 2012 Standard R2
    • Windows 8.1 32-bit
    • Windows 8.1 64-bit
    • Windows Vista 32-bit
    • Windows Vista 64-bit
    • Windows XP Professional
    • Windows XP Professional 64-bit
Summary

When the SQL server deadlock issue happens in Deep Security, the SQL Server Logs may show error similar to the following:

00 00:40:39.950 54 <?query --(@P0 int,@P1 int)INSERT INTO saphosts (HostID, SAPState) VALUES ( @P0 ,  @P1 ) SELECT
SCOPE_IDENTITY() AS _JTDS_GENE_R_ATED_KEYS_--?> TE\sa_te-trendmicro-svc NULL                 218                   8
2 NULL              22,007                   5                   0                     7 sleeping                   1 NULL
TEPROTDM01 DSM Trend Micro Inc. 2016-12-05 10:45:58.913 2016-12-05 10:44:32.247 NULL 2016-12-05 11:26:39.543
Details
Public

As a workaround, do the following:

  1. Stop the Deep Security Manager service on all nodes.
  2. Open the dsm.properties file located on these paths:
    • For Windows: Program Files\Trend Micro\Deep Security Manager\webclient\webapps\ROOT\WEB-INF
    • For Linux: /opt/dsm/webclient/webapps/root/web-inf/
  3. Add the following line:

    database.SqlServer.useReadCommittedSnapshot=true

  4. Restart the Deep Security Manager service.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1106280
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.