<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Hi,</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
We are observing weird pattern that tomcat connection pooling framework not able to get connections from pgpool and it is failing with below exceptions. But we are successfully able to connect thru PSQL on same pgpool host/port and execute all SQL commands.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Just to let you all know options tried and still end up with same exception</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
1. Switched from common dbcp to c3p0 pooling framework.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
2. Confirmed pgpool port is listening with domain “*” and able to telnet from other servers.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
3. Turn off pgpool connection cache attribute</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
4. Checked encoding on tomcat server which is UTF-8.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
ANY HELP GREATLY APPRECIATED…..</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div><font face="Calibri,sans-serif"><b><u>A</u></b></font><b style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;"><u>pplication server Exception log:</u></b></div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">threw exception; Error retrieving data from switch_currenty_key table: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the
underlying database!</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><span class="Apple-tab-span" style="white-space: pre;"></span>at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:282)
~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><span class="Apple-tab-span" style="white-space: pre;"></span>at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:121)
~[spring-beans-3.2.3.RELEASE.jar:3.2.3.RELEASE]</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><br>
</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><b><u>Pgpool logs:</u></b></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;"><br>
</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: 0 th backend: name: TimeZone value: US/Central</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: 1 th backend: name: TimeZone value: US/Central</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 0 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 1 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_do_auth: cp->info[i]:0x7f8637ec9000 pid:17756</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_do_auth: cp->info[i]:0x7f8637ec9088 pid:12502</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_send_auth_ok: send pid 12502 to frontend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: select_load_balancing_node: selected backend id is 0</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: selected load balancing node: 0</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_command_success: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_writing_transaction: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_failed_transaction: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_transaction_isolation: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_skip_reading_from_backends: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_ignore_till_sync: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: read_kind_from_backend: kind: Z from 0 th backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: read_kind_from_backend: kind: Z from 1 th backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ProcessBackendResponse: kind from backend: Z</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 0 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 1 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ReadyForQuery: transaction state:</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ProcessBackendResponse: Ready For Query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ProcessFrontendResponse: kind from frontend P(50)</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_doing_extended_query_message: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_set_doing_extended_query_message: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: Parse: statement name <></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 0 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_read_message_length: slot: 1 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: can_query_context_destroy: query context 0x769e10 is still used. query:SET extra_float_digits = 3</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: Parse: waiting for master completing the query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 LOG: pid 17752: DB node id: 0 backend pid: 17756 statement: Parse: ���;�</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: wait_for_query_response: waiting for backend 0 completing the query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17752: detect_error: kind: 1</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 11464: reap_handler called</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 11464: reap_handler: call wait3</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 ERROR: pid 11464: Child process 17752 was terminated by segmentation fault</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 11464: child 17752 exits with status 11 by signal 11</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 11464: fork a new child pid 17757</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 11464: reap_handler: normally exited</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17757: I am 17757</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:19 DEBUG: pid 17757: pool_initialize_private_backend_status: initialize backend status</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: I am 17729 accept fd 6</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 LOG: pid 17729: connection received: host=<<XXXXX hostname>> port=37844</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: Protocol Major: 3 Minor: 0 database: <<databasename>> user: <<username>></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: new_connection: connecting 0 backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: new_connection: connecting 1 backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_ssl: SSL requested but SSL support is not available</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_ssl: SSL requested but SSL support is not available</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 0 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 1 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_do_auth: auth kind:5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: trying md5 authentication</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: DB node id: 0 salt: 16bcf7b8</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: trying md5 authentication</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: DB node id: 1 salt: ac25a3ff</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 22</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 22</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: application_name value:</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: application_name value:</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: client_encoding value: UTF8</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: client_encoding value: UTF8</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 23</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 23</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: DateStyle value: ISO, MDY</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: DateStyle value: ISO, MDY</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: integer_datetimes value: on</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: integer_datetimes value: on</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 27</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 27</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: IntervalStyle value: postgres</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: IntervalStyle value: postgres</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 21</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 21</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: is_superuser value: off</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: is_superuser value: off</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 25</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: server_encoding value: UTF8</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: server_encoding value: UTF8</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 26</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 26</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: server_version value: 9.2.10</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: server_version value: 9.2.10</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 34</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 34</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: session_authorization value: <<user>></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: session_authorization value: <<user>></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 35</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 35</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: standard_conforming_strings value: on</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: standard_conforming_strings value: on</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 0 length: 24</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length2: master slot: 1 length: 24</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 0 th backend: name: TimeZone value: US/Central</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: 1 th backend: name: TimeZone value: US/Central</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 0 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 1 length: 12</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_do_auth: cp->info[i]:0x7f8637bff000 pid:17758</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_do_auth: cp->info[i]:0x7f8637bff088 pid:12504</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_send_auth_ok: send pid 12504 to frontend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: select_load_balancing_node: selected backend id is 0</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: selected load balancing node: 0</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_command_success: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_writing_transaction: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_failed_transaction: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_transaction_isolation: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_skip_reading_from_backends: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_ignore_till_sync: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: read_kind_from_backend: kind: Z from 0 th backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: read_kind_from_backend: kind: Z from 1 th backend</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ProcessBackendResponse: kind from backend: Z</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 0 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 1 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ReadyForQuery: transaction state:</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ProcessBackendResponse: Ready For Query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ProcessFrontendResponse: kind from frontend P(50)</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_doing_extended_query_message: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_set_doing_extended_query_message: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: Parse: statement name <></p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 0 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_read_message_length: slot: 1 length: 5</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: ReadyForQuery: transaction state:I</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: can_query_context_destroy: query context 0x769e10 is still used. query:SET extra_float_digits = 3</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_unset_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: pool_set_query_in_progress: done</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: Parse: waiting for master completing the query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 LOG: pid 17729: DB node id: 0 backend pid: 17758 statement: Parse: ���;�</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: wait_for_query_response: waiting for backend 0 completing the query</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17729: detect_error: kind: 1</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 11464: reap_handler called</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 11464: reap_handler: call wait3</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 ERROR: pid 11464: Child process 17729 was terminated by segmentation fault</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 11464: child 17729 exits with status 11 by signal 11</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 11464: fork a new child pid 17759</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 11464: reap_handler: normally exited</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17759: I am 17759</p>
<p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt;">2015-06-02 21:57:27 DEBUG: pid 17759: pool_initialize_private_backend_status: initialize backend status</p>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<div><b style="font-size: 15px;"><br>
</b></div>
<div><b style="font-size: 15px;"><u>Postgres log samples:</u></b></div>
<div><br>
</div>
<div>I do see connections authorized/established but immediately disconnections are happening with in milliseconds.</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
~Suresh</div>
</body>
</html>