[jira] [Created] (AMBARI-21000) Ambari does not work with PGBouncer/PostgreSQL

["Robert Yokota (JIRA)" <ji...@apache.org>]

Robert Yokota created AMBARI-21000:
--------------------------------------

             Summary: Ambari does not work with PGBouncer/PostgreSQL
                 Key: AMBARI-21000
                 URL: https://issues.apache.org/jira/browse/AMBARI-21000
             Project: Ambari
          Issue Type: Bug
    Affects Versions: 2.5.2
            Reporter: Robert Yokota


When using JDBC with PGBouncer (a connection pooler for PostgreSQL), prepared statements must be disabled on the client side.  According to the PgBouncer FAQ, this is done by passing "prepareThreshold=0" in the JDBC URL.  Even when using "prepareThreshold=0", Ambari returns errors of the form "prepared statement "S_1" does not exist".  This is because Ambari uses Quartz, which uses C3P0.  Quartz by default configures C3P0 to cache prepared statements by setting maxStatementsPerConnection=120.  Fortunately, Quartz also allows you to override this C3P0 setting by passing a property named "maxCachedStatementsPerConnection".  When setting this property to 0 (which is the default in C3P0), then Ambari works properly with PGBouncer.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)