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)