[pgpool-general: 858] JDBC application cannot connect to pgpool

Sat Aug 4 18:10:14 JST 2012

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120804/f44d1116/attachment-0001.html>