Error message while performing database backup of Applications Manager

Error message while performing database backup of Applications Manager

While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables.

 

pg_dump: WARNING: out of shared memory
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.


Reference screenshot:


Cause

The error is caused by insufficient value of Max_locks_per_transaction parameter in the PostgreSQL.conf file. This parameter controls the average number of object locks allocated for each transaction. The default value of this parameter is 64. 


Solution

To overcome this error, perform the steps below:

 

  • Navigate to AppManager_Home\working\pgsql\data\amdb in your Applications Manager installation.

  • Uncomment the line #max_locks_per_transaction = 64 in the  postgresql.conf  file

  • Increase the value of max_locks_per_transaction to a higher value, eg. max_locks_per_transaction = 10000

  • Restart the Applications Manager.

  • ​Take backup of the database again.

 

 

 

 




      New to ADSelfService Plus?

      Start your free trial

        Resources

            • Related Articles

            • Applications Manager DB Maintenance for PGSQL Backend

              Windows Installations Note: Please take complete db backup using the <AppManager Home>\bin\BackupPGSQLDB.bat (or BackupPGSQLDB.sh) script without fail before following the below steps: Open services.msc, stop “ManageEngine Applications ...

            • Connecting to Applications Manager's bundled database

              How can I connect to Applications Manager's back-end database? Note: Take a backup of the AppManager directory before modifying anything in the database. Check am.dbserver.type value in <Applications Manager Home>\conf\AMServer.properties file to ...

            • Maintenance of Applications Manager

              Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...

            • Issues while upgrading Applications Manager with PostgreSQL backend database

              Problem 1: After installing Applications Manager versions 14850 and above with PostgreSQL backend, following error message is shown due to error initPGSQLDB.sh because of GLIBC_2.9 not found:  ./initdb: /lib64/libc.so.6: version `GLIBC_2.9' not found ...

            • Steps to configure Azure PostgreSQL Database as Applications Manager's back-end

              Applications Manager comes bundled with PostgreSQL. If you want to use your own PostgreSQL instead, follow the steps mentioned below: Prerequisites: A compatible PostgreSQL database should be accessible from Applications Manager installation. To know ...