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 clear="all">
<br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>