<div dir="ltr">Hi Suresh<div><br></div><div>Thanks for the update. Glad to hear your problem is solved with the new version of pgpool-II.</div><div><br></div><div>Thanks</div><div>Best regards</div><div>Muhammad Usama</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 8, 2015 at 8:48 PM, Suresh Tavvala <span dir="ltr"><<a href="mailto:Suresh.Tavvala@mozido.com" target="_blank">Suresh.Tavvala@mozido.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-family:Calibri,sans-serif">
<div>
<div>
<div style="font-size:14px">Hi muhammad,</div>
<div style="font-size:14px"><br>
</div>
<div style="font-size:14px">I have upgraded to 3.4.2 and started working fine. Seems like there is bug in old version. Thank you once again for your time.</div>
<div>
<div style="font-size:14px"><b style="font-size:15px"><br>
</b></div>
<div><span style="font-size:15px">~Suresh</span></div>
</div>
</div>
</div>
<div style="font-size:14px"><br>
</div>
<span style="font-size:14px">
<div style="font-family:Calibri;font-size:11pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Thursday, June 4, 2015 at 2:59 PM<div><div class="h5"><br>
<span style="font-weight:bold">To: </span>suresh tavvala <<a href="mailto:Suresh.Tavvala@mozido.com" target="_blank">Suresh.Tavvala@mozido.com</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>" <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [pgpool-general: 3779] Unable to get connections by tomcat common dbcp or c3p0 connection pooling from pgpool host/port<br>
</div></div></div><div><div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Jun 4, 2015 at 9:28 PM, Suresh Tavvala <span dir="ltr">
<<a href="mailto:Suresh.Tavvala@mozido.com" target="_blank">Suresh.Tavvala@mozido.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<div>
<div style="font-size:14px">Hi Muhammad,</div>
<div style="font-size:14px"><br>
</div>
<div style="font-size:14px">Thank you for reply and sorry for delay in responding back. Here are requested details</div>
<div style="font-size:14px"><br>
</div>
<div style="font-size:14px"> pgpool-II. version 3.2.0</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>pgpool-II 3.2.0 is very old, Any specific reason you are using this very old version. Can you check with a newer version of pgpool-II if the problem still exists? </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<div>
<div style="font-size:14px"><br>
</div>
<div style="font-size:14px">Here I am attaching core dump file. And also would you mind to let me know what core dump analyzer you are using ?</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div> I normally use GDB for debugging and analyzing core files. </div>
<div><br>
</div>
<div>Thanks</div>
<div>Muhammad Usama</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<div>
<div>
<div style="font-size:14px"><b style="font-size:15px"><br>
</b></div>
<div><span style="font-size:15px">~Suresh</span></div>
</div>
</div>
<div style="font-size:14px"><br>
</div>
<span style="font-size:14px">
<div style="font-family:Calibri;font-size:11pt;text-align:left;color:black;border-width:1pt medium medium;border-style:solid none none;padding:3pt 0in 0in;border-top-color:rgb(181,196,223)">
<span style="font-weight:bold">From: </span>Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Wednesday, June 3, 2015 at 2:31 PM<br>
<span style="font-weight:bold">To: </span>suresh tavvala <<a href="mailto:Suresh.Tavvala@mozido.com" target="_blank">Suresh.Tavvala@mozido.com</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>" <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [pgpool-general: 3779] Unable to get connections by tomcat common dbcp or c3p0 connection pooling from pgpool host/port<br>
</div>
<div>
<div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Hi
<div><br>
</div>
<div>What version of pgpool-II are you using? Log suggests that a segmentation fault is causing the child process to crash.</div>
<div><br>
</div>
<div>Can you please share the core dump of crashing child process.</div>
<div><br>
</div>
<div>Thanks</div>
<div>Best regards</div>
<div>Muhammad Usama</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Jun 3, 2015 at 10:09 PM, Suresh Tavvala <span dir="ltr">
<<a href="mailto:Suresh.Tavvala@mozido.com" target="_blank">Suresh.Tavvala@mozido.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div style="word-wrap:break-word">
<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 style="white-space:pre-wrap"></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 style="white-space:pre-wrap"></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>
<span><font color="#888888">
<div><br>
</div>
<div><br>
</div>
</font></span></div>
<span><font color="#888888">
<div style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">~Suresh</div>
</font></span></div>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div></div></span>
</div>
</blockquote></div><br></div>