The user that you use for connecting to postgresql exists in all
database servers and the pg_hba.conf is configured for allowing this
user connecting from pgpool?<br>yes, i use user postgres on all db server with same password<br><br>Do you can connect from psql client through pgpool?<br>yes<br><br>In the pgpool.conf-sample-relication file, the property enable_pool_hba
is in off. That means you do not able to use md5 authentication. Would
you review this?<br>i use password authentication on pg_hba and set pool_hba off<br><br><div class="gmail_quote">On Sun, Aug 5, 2012 at 1:32 AM, Lazáro Rubén García Martínez <span dir="ltr"><<a href="mailto:lgarciam@vnz.uci.cu" target="_blank">lgarciam@vnz.uci.cu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The user that you use for connecting to postgresql exists in all database servers and the pg_hba.conf is configured for allowing this user connecting from pgpool?<br>
<br>
Do you can connect from psql client through pgpool?<br>
<br>
In the pgpool.conf-sample-relication file, the property enable_pool_hba is in off. That means you do not able to use md5 authentication. Would you review this?<br>
<br>
enable_pool_hba = off<br>
<br>
Regards.<br>
________________________________________<br>
From: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>] On Behalf Of Soni Maula Harriz [<a href="mailto:soni.harriz@sangkuriang.co.id">soni.harriz@sangkuriang.co.id</a>]<br>
Sent: Saturday, August 04, 2012 4:40 AM<br>
To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 858] JDBC application cannot connect to pgpool<br>
<div><div class="h5"><br>
dear all,<br>
<br>
we are using pgpool-II 3.2.0 with replication mode and load balancing<br>
OS : Centos 6 (Pgpool and postgresql 8.4.9), Ubuntu (Postgresql 8.4.11)<br>
application using JDBC 4<br>
we have a problem : the application cannot connect to the database<br>
<br>
here is the pgpool.conf<br>
<br>
replication_mode = on<br>
replicate_select = off<br>
insert_lock = on<br>
lobj_lock_table = ''<br>
replicate_select = off<br>
insert_lock = on<br>
lobj_lock_table = ''<br>
replication_stop_on_mismatch = on<br>
failover_if_affected_tuples_mismatch = on<br>
load_balance_mode = on<br>
ignore_leading_white_space = on<br>
white_function_list = ''<br>
black_function_list = 'nextval,setval'<br>
fail_over_on_backend_error = on<br>
<br>
other configuration values use default value from pgpool.conf.sample-replication (except for backend configuration)<br>
<br>
and here is the log of pgpool<br>
<br>
2012-08-04 08:21:48 ERROR: pid 8895: Bind: cannot get parse message ""<br>
2012-08-04 08:21:48 LOG: pid 8895: do_child: exits with status 1 due to error<br>
2012-08-04 08:21:48 DEBUG: pid 8805: reap_handler called<br>
2012-08-04 08:21:48 DEBUG: pid 8805: reap_handler: call wait3<br>
2012-08-04 08:21:48 DEBUG: pid 8805: child 8895 exits with status 256<br>
2012-08-04 08:21:48 DEBUG: pid 8805: fork a new child pid 8897<br>
2012-08-04 08:21:48 DEBUG: pid 8805: reap_handler: normally exited<br>
2012-08-04 08:21:48 DEBUG: pid 8897: I am 8897<br>
2012-08-04 08:21:48 DEBUG: pid 8897: pool_initialize_private_backend_status: initialize backend status<br>
2012-08-04 08:21:49 DEBUG: pid 8897: I am 8897 accept fd 6<br>
2012-08-04 08:21:49 DEBUG: pid 8897: Protocol Major: 3 Minor: 0 database: psc_sub_terminal user: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8897: new_connection: connecting 0 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8897: new_connection: connecting 1 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8897: new_connection: skipping slot 1 because backend_status = 3<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_ssl: SSL requested but SSL support is not available<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length: slot: 0 length: 8<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_do_auth: auth kind:3<br>
2012-08-04 08:21:49 DEBUG: pid 8897: trying clear text password authentication<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 28<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: client_encoding value: UNICODE<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: DateStyle value: ISO, MDY<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: integer_datetimes value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 27<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: IntervalStyle value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 20<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: is_superuser value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: server_encoding value: UTF8<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 26<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: server_version value: 8.4.10<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 35<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: session_authorization value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 36<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: standard_conforming_strings value: off<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8897: 0 th backend: name: TimeZone value: localtime<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length: slot: 0 length: 12<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_do_auth: cp->info[i]:0x7f1c3938b000 pid:5102<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_send_auth_ok: send pid 5102 to frontend<br>
2012-08-04 08:21:49 DEBUG: pid 8897: select_load_balancing_node: selected backend id is 0<br>
2012-08-04 08:21:49 DEBUG: pid 8897: selected load balancing node: 0<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_command_success: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_writing_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_failed_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_transaction_isolation: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_skip_reading_from_backends: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_ignore_till_sync: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: read_kind_from_backend: kind: Z from 0 th backend<br>
2012-08-04 08:21:49 DEBUG: pid 8897: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ProcessBackendResponse: kind from backend: Z<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ReadyForQuery: transaction state:^@<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ProcessBackendResponse: Ready For Query<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ProcessFrontendResponse: kind from frontend P(50)<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: Parse: statement name <><br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ReadyForQuery: transaction state:I<br>
2012-08-04 08:21:49 DEBUG: pid 8897: can_query_context_destroy: query context 0x176f540 is still used. query:SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: Parse: waiting for master completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8897: wait_for_query_response: waiting for backend 0 completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8897: detect_error: kind: 1<br>
2012-08-04 08:21:49 DEBUG: pid 8897: read_kind_from_backend: kind: 1 from 0 th backend<br>
2012-08-04 08:21:49 DEBUG: pid 8897: read_kind_from_backend: read kind from 0 th backend 1 NUM_BACKENDS: 2<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ProcessBackendResponse: kind from backend: 1<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_command_success: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: ProcessFrontendResponse: kind from frontend B(42)<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_unset_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8897: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 ERROR: pid 8897: Bind: cannot get parse message ""<br>
2012-08-04 08:21:49 LOG: pid 8897: do_child: exits with status 1 due to error<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler called<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler: call wait3<br>
2012-08-04 08:21:49 DEBUG: pid 8805: child 8897 exits with status 256<br>
2012-08-04 08:21:49 DEBUG: pid 8805: fork a new child pid 8898<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler: normally exited<br>
2012-08-04 08:21:49 DEBUG: pid 8896: I am 8896 accept fd 6<br>
2012-08-04 08:21:49 DEBUG: pid 8896: Protocol Major: 3 Minor: 0 database: psc_sub_terminal user: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8896: new_connection: connecting 0 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8896: new_connection: connecting 1 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8898: I am 8898<br>
2012-08-04 08:21:49 DEBUG: pid 8896: new_connection: skipping slot 1 because backend_status = 3<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_initialize_private_backend_status: initialize backend status<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_ssl: SSL requested but SSL support is not available<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length: slot: 0 length: 8<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_do_auth: auth kind:3<br>
2012-08-04 08:21:49 DEBUG: pid 8896: trying clear text password authentication<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 28<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: client_encoding value: UNICODE<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: DateStyle value: ISO, MDY<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: integer_datetimes value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 27<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: IntervalStyle value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 20<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: is_superuser value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: server_encoding value: UTF8<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 26<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: server_version value: 8.4.10<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 35<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: session_authorization value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 36<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: standard_conforming_strings value: off<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8896: 0 th backend: name: TimeZone value: localtime<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length: slot: 0 length: 12<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_do_auth: cp->info[i]:0x7f1c39347000 pid:5103<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_send_auth_ok: send pid 5103 to frontend<br>
2012-08-04 08:21:49 DEBUG: pid 8896: select_load_balancing_node: selected backend id is 0<br>
2012-08-04 08:21:49 DEBUG: pid 8896: selected load balancing node: 0<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_command_success: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_writing_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_failed_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_transaction_isolation: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_skip_reading_from_backends: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_ignore_till_sync: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: read_kind_from_backend: kind: Z from 0 th backend<br>
2012-08-04 08:21:49 DEBUG: pid 8896: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>
2012-08-04 08:21:49 DEBUG: pid 8896: ProcessBackendResponse: kind from backend: Z<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8896: ReadyForQuery: transaction state:^@<br>
2012-08-04 08:21:49 DEBUG: pid 8896: ProcessBackendResponse: Ready For Query<br>
2012-08-04 08:21:49 DEBUG: pid 8896: ProcessFrontendResponse: kind from frontend P(50)<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_set_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: Parse: statement name <><br>
2012-08-04 08:21:49 DEBUG: pid 8896: Parse: statement name <><br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8896: ReadyForQuery: transaction state:I<br>
2012-08-04 08:21:49 DEBUG: pid 8896: can_query_context_destroy: query context 0x176f540 is still used. query:SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8896: Parse: waiting for master completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8896: wait_for_query_response: waiting for backend 0 completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8896: detect_error: kind: 1<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler called<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler: call wait3<br>
2012-08-04 08:21:49 ERROR: pid 8805: Child process 8896 was terminated by segmentation fault<br>
2012-08-04 08:21:49 DEBUG: pid 8805: child 8896 exits with status 139 by signal 11<br>
2012-08-04 08:21:49 DEBUG: pid 8805: fork a new child pid 8900<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler: normally exited<br>
2012-08-04 08:21:49 DEBUG: pid 8898: I am 8898 accept fd 6<br>
2012-08-04 08:21:49 DEBUG: pid 8898: Protocol Major: 3 Minor: 0 database: psc_sub_terminal user: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8898: new_connection: connecting 0 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8898: new_connection: connecting 1 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8898: new_connection: skipping slot 1 because backend_status = 3<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_ssl: SSL requested but SSL support is not available<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length: slot: 0 length: 8<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_do_auth: auth kind:3<br>
2012-08-04 08:21:49 DEBUG: pid 8898: trying clear text password authentication<br>
2012-08-04 08:21:49 DEBUG: pid 8900: I am 8900<br>
2012-08-04 08:21:49 DEBUG: pid 8900: pool_initialize_private_backend_status: initialize backend status<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 28<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: client_encoding value: UNICODE<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: DateStyle value: ISO, MDY<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: integer_datetimes value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 27<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: IntervalStyle value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 20<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: is_superuser value: on<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 25<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: server_encoding value: UTF8<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 26<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: server_version value: 8.4.10<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 35<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: session_authorization value: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 36<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: standard_conforming_strings value: off<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length2: master slot: 0 length: 23<br>
2012-08-04 08:21:49 DEBUG: pid 8898: 0 th backend: name: TimeZone value: localtime<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length: slot: 0 length: 12<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_do_auth: cp->info[i]:0x7f1c3938b000 pid:5104<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_send_auth_ok: send pid 5104 to frontend<br>
2012-08-04 08:21:49 DEBUG: pid 8898: select_load_balancing_node: selected backend id is 0<br>
2012-08-04 08:21:49 DEBUG: pid 8898: selected load balancing node: 0<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_command_success: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_writing_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_failed_transaction: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_transaction_isolation: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_skip_reading_from_backends: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_ignore_till_sync: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: read_kind_from_backend: kind: Z from 0 th backend<br>
2012-08-04 08:21:49 DEBUG: pid 8898: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2<br>
2012-08-04 08:21:49 DEBUG: pid 8898: ProcessBackendResponse: kind from backend: Z<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8898: ReadyForQuery: transaction state:^@<br>
2012-08-04 08:21:49 DEBUG: pid 8898: ProcessBackendResponse: Ready For Query<br>
2012-08-04 08:21:49 DEBUG: pid 8898: ProcessFrontendResponse: kind from frontend P(50)<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_set_doing_extended_query_message: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: Parse: statement name <><br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_read_message_length: slot: 0 length: 5<br>
2012-08-04 08:21:49 DEBUG: pid 8898: ReadyForQuery: transaction state:I<br>
2012-08-04 08:21:49 DEBUG: pid 8898: can_query_context_destroy: query context 0x176f540 is still used. query:SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_unset_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: pool_set_query_in_progress: done<br>
2012-08-04 08:21:49 DEBUG: pid 8898: Parse: waiting for master completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8898: wait_for_query_response: waiting for backend 0 completing the query<br>
2012-08-04 08:21:49 DEBUG: pid 8898: detect_error: kind: 1<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler called<br>
2012-08-04 08:21:49 DEBUG: pid 8900: I am 8900 accept fd 6<br>
2012-08-04 08:21:49 DEBUG: pid 8900: Protocol Major: 3 Minor: 0 database: psc_sub_terminal user: postgres<br>
2012-08-04 08:21:49 DEBUG: pid 8900: new_connection: connecting 0 backend<br>
2012-08-04 08:21:49 DEBUG: pid 8805: reap_handler: call wait3<br>
2012-08-04 08:21:49 ERROR: pid 8805: Child process 8898 was terminated by segmentation fault<br>
<br>
and here is the error message from JDBC application<br>
<br>
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)<br>
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:262)<br>
at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:791)<br>
at com.daksa.psc_epayment.db.DBPostgre.CreateNewConnection(DBPostgre.java:283)<br>
at com.daksa.psc_epayment.db.DBPostgre.initializeConnections(DBPostgre.java:261)<br>
at com.daksa.psc_epayment.db.DBPostgre.tryInitializeConnections(DBPostgre.java:213)<br>
at com.daksa.psc_epayment.db.DBPostgre.<init>(DBPostgre.java:62)<br>
at com.daksa.psc_epayment.db.DBConnectionPools.initializeDB(DBConnectionPools.java:54)<br>
at com.daksa.psc_epayment.db.DBConnectionPools.<init>(DBConnectionPools.java:23)<br>
at com.daksa.psc_epayment.db.DBConnectionPools.<clinit>(DBConnectionPools.java:18)<br>
at com.daksa.psc_epayment.server.Main.initSingleton(Main.java:42)<br>
at com.daksa.psc_epayment.server.Main.main(Main.java:21)<br>
Caused by: java.io.EOFException<br>
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:276)<br>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1654)<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
<br>
and in postgresql log<br>
<br>
2012-08-04 15:37:01 WIT LOG: unexpected EOF on client connection<br>
2012-08-04 15:37:02 WIT LOG: unexpected EOF on client connection<br>
2012-08-04 15:37:03 WIT LOG: unexpected EOF on client connection<br>
2012-08-04 15:37:03 WIT LOG: unexpected EOF on client connection<br>
2012-08-04 15:37:03 WIT LOG: unexpected EOF on client connection<br>
<br>
<br>
thanks for the answer<br>
<br>
--<br>
Best Regards,<br>
<br>
Soni Maula Harriz<br>
Database Administrator<br>
PT. Data Aksara Sangkuriang<br>
<br>
<br>
</div></div>________________________________<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>