"temp_smartgroup_product" Errors in /var/log/messages
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'
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.
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
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