Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: System Health Alert "There Are Database Tables on Your Server That Are Extremely Close to Their Size Limit"

App Control: System Health Alert "There Are Database Tables on Your Server That Are Extremely Close to Their Size Limit"

Environment

  • App Control Server: All Supported Versions
  • App Control Agent:  All Supported Versions

Symptoms

  • Many Computers reporting 'Approvals Out of Date' in Status column
  • Alert received that a table is close to approaching the  ~2.15 billion (8.9 and below) or ~4.3 billion (8.10 and above) limit
Health indicator Alert: Database Table Limit - There Are Database Tables on Your Server That Are Extremely Close to Their Size Limit

Cause

  • The 'das' database will stop functioning properly if one of the tables reaches the limit.
  • This condition will also affect communication between the Server/Agent, resulting in the 'Approvals Out Of Date' status. 

Resolution

  1. Upgrade to App Control Server 8.10 or Higher. Over the last several releases we've made many improvements to various tables within App Control. Including:
    • 8.7.0: The ability to reuse rows that have been pruned on the dbo.filenames and dbo.pathnames tables
    • 8.9.0: The ability to reuse rows on the dbo.antibodies table (EP-12544). Converted the antibody_groups_antibodies table to bigint (EP-13037).
    • 8.9.2: Improved the reuse row functionality (EP-16515)
    • 8.10.: Doubled the row capacity by adding the ability to use negative integers EP-18212). Converted alert_event_data to bigint (EP-17524)
  2. If you've already upgraded or are unable to upgrade run the below queries and provide them to Support
    Query 1:
    select max(pathname_id) from dbo.pathnames with (nolock)
    
    Query 2:
    select count (*) from das.dbo.UnusedPathnames with (nolock)
    
    Query 3:
    select max(filename_id) from dbo.filenames with (nolock)
    
    Query 4:
    select count (*) from das.dbo.UnusedFilenames with (nolock)
    
    Query 5:
    select max(antibody_id) from das.dbo.antibodies with (nolock)
    
    Query 6:
    select count (*) from das.dbo.UnusedAntibodies with (nolock)

Labels (1)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎09-09-2020
Views:
1392
Contributors