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

Sun Aug 5 03:32:22 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?

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