Created on 09-30-2024 02:55 AM Edited on 10-22-2024 10:47 AM By Jdavenport
Description | This article describes how to fix the 'Error PSQLException: ERROR: no shared memory available'. |
Scope | FortiSIEM. |
Solution |
This error occurs when queries are causing postgresql to run out of shared memory:
As the message indicates, the value of 'max_locks_per_transaction' has to be increased. In the case below, it will be increased to 200, but in other cases, it can be increased to 1024.
Change the value of #max_locks_per_transaction:
From: # max_locks_per_transaction = 64 # min 10
systemctl stop postgresql-13
cd /opt/glassfish/domains/domain1/
Wait for 5-10 minutes and check the phProesses rate up with the 'phstatus' command. |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.