41.0    Database Design
  • Database Administration
  • 41.0 Database Design
  • 41.1 Database Connection Pool
  • 41.2 Setting Up PostgreSQL
  • 41.3 Troubleshooting PostgreSQL
  • 41.4 Setting Up MySQL
  • 41.5 Setting Up MariaDB
  • 41.6 Setting Up Oracle
  • 41.7 Setting Up SQL Server (MSSQL)
  • 41.8 AWS IAM Authentication
    • 41.2    Setting Up PostgreSQL   
       Table of Contents

    Database Connection Pool

    41.1.1Database Connection Pool

     

    Smile CDR manages a connection pool for each database connection. A number of database config properties control the behaviour of these connection pools.

    41.1.1.1Connection Pool Exhaustion

    If Smile CDR requests a database connection from the database and none is available, then you will see an error message like the following in the logs.

    Cannot get a connection, pool error Timeout waiting for idle object

    The first thing to check is that the value for db.connectionpool.maxtotal is lower than the number of database connections available for Smile CDR (as configured on the database server).

    If that does not resolve the issue, then you should set the following configuration parameters to true:

    This will return abandoned connections to the connection pool and DEBUG log their stack traces. You may wish to enable the Connection Pool Troubleshooting Log so these log messages are in a separate file from your main log file.

       41.0    Database Design
  • Database Administration
  • 41.0 Database Design
  • 41.1 Database Connection Pool
  • 41.2 Setting Up PostgreSQL
  • 41.3 Troubleshooting PostgreSQL
  • 41.4 Setting Up MySQL
  • 41.5 Setting Up MariaDB
  • 41.6 Setting Up Oracle
  • 41.7 Setting Up SQL Server (MSSQL)
  • 41.8 AWS IAM Authentication
    • 41.2    Setting Up PostgreSQL