"temp_smartgroup_product" Errors in /var/log/messages

"temp_smartgroup_product" Errors in /var/log/messages

Summary

One or more specific smart groups fail to compile. When logging level is increased  on the Software Vulnerability Manager On-Prem Linux server, the following error is seen in the /var/log/messages log:

'"temp_smartgroup_product" table is full'

Cause

If the MySQL server instance isn't properly fine-tuned as per best-practices and engineering recommendations, that can lead to some temporary tables being generated, that can overwhelm the database instance quickly and consume more space than it is available.

There are a number of different tuning settings that can effect this including innodb_file_per_table, max_heap_table_size, and tmp_table_size among others. These settings are configured on the Linux server hosting the MySQL database as stored in the database configuration file /etc/my.cnf.

Resolution

To resolve this issue, the best bet it to reach out to Flexera Support and request the best recommended fine-tuning settings your concrete MySQL implementation. Each server generally requires different settings based on the amount of hosts it manages, the hardware configuration, and other variables. 

On the Application server (where Apache is installed):

1. Stop the Software Vulnerability Manager On-Prem daemons:

systemctl stop sgdaemon
systemctl stop scandaemon

2) Flush the server memory:

sync; echo 3 > /proc/sys/vm/drop_caches

On the DB server, increase the values in the /etc/my.cnf file:

 

# These two values should always match
max_heap_table_size
tmp_table_size

You can also Increase max_allowed_packet

Also, do ensure that innodb_file_per_table = 1

Exit the configuration file by saving the settings (ESC --> :wq!) and restart MySQL:

systemctl restart mysqld

 

Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Oct 05, 2019 03:42 PM
Updated by:
 
Contributors