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 M365 Manager Plus?
          New to M365 Manager Plus?
            New to RecoveryManager Plus?
            New to RecoveryManager Plus?
              New to Exchange Reporter Plus?
              New to Exchange Reporter Plus?
                New to SharePoint Manager Plus?
                New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • Connecting to Applications Manager's bundled database

                        Before you connect to Applications Manager's back-end database, it is important that you take a backup of the Applications Manager directory so that you don't make any changes/accidentally modify the database. Identify which database Applications ...

                      • Maintenance of Applications Manager backend database

                        Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...

                      • Allowing agent reregistration in Applications Manager

                        Starting with Applications Manager version 180900, an option is available in the UI to explicitly allow previously registered agents to re-register after they are reinstalled. In versions before 180900, this option is not available in the UI, and ...

                      • Integrating Applications Manager backend Microsoft SQL database with Power BI Desktop

                        Overview This KB provides step-by-step instructions to connect Power BI Desktop to your Applications Manager's Microsoft SQL backend database, enabling you to create custom reports and dashboards using Applications Manager's performance metrics and ...

                      • PostgreSQL authentication failure during Applications Manager startup

                        Problem: Applications Manager fails to start due to PostgreSQL authentication failure and shows the following error: The following errors are observed in the startup log (StartUpLogs_err.log) file, located under <Applications Manager Home>\logs\ ...
                      Related Products