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

Create a technical support case if you need further support.

Memory overcommit occurs on Linux server with PostgreSQL where Deep Security Manager database is installed

    • Updated:
    • 18 Jun 2019
    • Product/Version:
    • Deep Security 10.0
    • Deep Security 11.0
    • Platform:
    • N/A N/A
Summary

The database server may experience symptoms of memory overcommit and performing basic database tuning cannot resolve the issue. This happens on Linux server that has PostgreSQL 9.6, where the Deep Security Manager (DSM) database is currently residing.

In addition, the PostgreSQL log shows the following:

< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.002 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.022 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.043 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.063 KST > WARNING: out of shared memory
< 2019-06-09 00:24:00.063 KST > WARNING: out of shared memory
Details
Public

Root Cause

The issue occurs because the Deep Security Manager failed to properly manage the partition tables in the PostgreSQL database, resulting in many AlertUpdateEvents tables in the database.

Solution

To resolve the issue, upgrade Deep Security Manager to version 11.0 Update 8 or higher.

Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1122982
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.