[pgpool-general: 860] Re: JDBC application cannot connect to pgpool

Sun Aug 5 14:47:42 JST 2012

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?
yes, i use user postgres on all db server with same password

Do you can connect from psql client through pgpool?
yes

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?
i use password authentication on pg_hba and set pool_hba off

On Sun, Aug 5, 2012 at 1:32 AM, Lazáro Rubén García Martínez <
lgarciam at vnz.uci.cu> wrote:

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

-- 
Best Regards,

Soni Maula Harriz
Database Administrator
PT. Data Aksara Sangkuriang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120805/a42cde23/attachment-0001.html>