I think this is a known issue and has been fixed in 2.3.2.1. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Hi: > > I'm getting issues when i'm trying to create a table with a constraint > (like a primary key) or a serial data type. My current env is Red Hat 5.3, > postgresql 8.1.11 and pgpool-II.2.3.1. Apparently, pg-pool is receiving a > null kind when is expecting a 'C' or 'Z' kind from the postgres server in > the moment of the query processing. > > Bellow i'm displaying a log with the error i got. I will appreciate your > help in order to solve this. > > 2010-02-15 14:57:00 DEBUG: pid 4546: key: listen_addresses > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '*' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: port > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 9999 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: pcp_port > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 9898 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: socket_dir > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/tmp' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: pcp_socket_dir > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/tmp' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_socket_dir > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/tmp' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: pcp_timeout > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 10 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: num_init_children > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 32 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: max_pool > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 4 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: child_life_time > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 300 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: connection_life_time > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 0 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: child_max_connections > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 0 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: client_idle_limit > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 0 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: false > 2010-02-15 14:57:00 DEBUG: pid 4546: value: > kind: 7 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: authentication_timeout > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 60 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: logdir > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/tmp' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: pid_file_name > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/var/run/pgpool/pgpool.pid' > kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: replication_mode > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: load_balance_mode > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: replication_stop_on_mismatch > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: replication_stop_on_mismatch: 0 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: replicate_select > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: replicate_select: 0 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: reset_query_list > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'ABORT; RESET ALL; SET SESSION > AUTHORIZATION DEFAULT' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: extract_string_tokens: token: ABORT > 2010-02-15 14:57:00 DEBUG: pid 4546: extract_string_tokens: token: RESET > ALL > 2010-02-15 14:57:00 DEBUG: pid 4546: extract_string_tokens: token: SET > SESSION AUTHORIZATION DEFAULT > 2010-02-15 14:57:00 DEBUG: pid 4546: key: print_timestamp > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: master_slave_mode > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: connection_cache > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: health_check_timeout > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 20 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: health_check_period > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 0 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: health_check_user > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'nobody' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: failover_command > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: failback_command > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: fail_over_on_backend_error > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: insert_lock > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: ignore_leading_white_space > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: log_statement > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: log_per_node_statement > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: log_connections > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: log_hostname > 2010-02-15 14:57:00 DEBUG: pid 4546: value: true kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: parallel_mode > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: enable_query_cache > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: pgpool2_hostname > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_hostname > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'localhost' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_port > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 9000 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_dbname > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'pgpool' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_schema > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'pgpool_catalog' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_user > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'pgpool' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: system_db_password > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_hostname0 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '192.168.112.89' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_port0 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 9000 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: pool_config: port slot number 0 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_weight0 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 1 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: pool_config: weight slot number 0 > weight: 1.000000 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_data_directory0 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/data1' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_hostname1 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '192.168.112.89' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_port1 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 9001 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: pool_config: port slot number 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_weight1 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 1 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: pool_config: weight slot number 1 > weight: 1.000000 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: backend_data_directory1 > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '/data2' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: enable_pool_hba > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: recovery_user > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 'nobody' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: recovery_password > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: recovery_1st_stage_command > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: recovery_2nd_stage_command > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: recovery_timeout > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 90 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: client_idle_limit_in_recovery > 2010-02-15 14:57:00 DEBUG: pid 4546: value: 0 kind: 2 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: lobj_lock_table > 2010-02-15 14:57:00 DEBUG: pid 4546: value: '' kind: 4 > 2010-02-15 14:57:00 DEBUG: pid 4546: key: ssl > 2010-02-15 14:57:00 DEBUG: pid 4546: value: false kind: 1 > 2010-02-15 14:57:00 DEBUG: pid 4546: num_backends: 2 num_backends: 2 > total_weight: 2.000000 > 2010-02-15 14:57:00 DEBUG: pid 4546: backend 0 weight: 1073741823.500000 > 2010-02-15 14:57:00 DEBUG: pid 4546: backend 1 weight: 1073741823.500000 > 2010-02-15 14:57:00 DEBUG: pid 4551: I am 4551 > 2010-02-15 14:57:00 DEBUG: pid 4547: I am 4547 > 2010-02-15 14:57:00 DEBUG: pid 4548: I am 4548 > 2010-02-15 14:57:00 DEBUG: pid 4549: I am 4549 > 2010-02-15 14:57:00 DEBUG: pid 4550: I am 4550 > 2010-02-15 14:57:00 DEBUG: pid 4553: I am 4553 > 2010-02-15 14:57:00 DEBUG: pid 4552: I am 4552 > 2010-02-15 14:57:00 DEBUG: pid 4554: I am 4554 > 2010-02-15 14:57:00 DEBUG: pid 4555: I am 4555 > 2010-02-15 14:57:00 DEBUG: pid 4556: I am 4556 > 2010-02-15 14:57:00 DEBUG: pid 4557: I am 4557 > 2010-02-15 14:57:00 DEBUG: pid 4558: I am 4558 > 2010-02-15 14:57:00 DEBUG: pid 4560: I am 4560 > 2010-02-15 14:57:00 DEBUG: pid 4561: I am 4561 > 2010-02-15 14:57:00 DEBUG: pid 4562: I am 4562 > 2010-02-15 14:57:00 DEBUG: pid 4563: I am 4563 > 2010-02-15 14:57:00 DEBUG: pid 4564: I am 4564 > 2010-02-15 14:57:00 DEBUG: pid 4559: I am 4559 > 2010-02-15 14:57:00 DEBUG: pid 4565: I am 4565 > 2010-02-15 14:57:00 DEBUG: pid 4566: I am 4566 > 2010-02-15 14:57:00 DEBUG: pid 4567: I am 4567 > 2010-02-15 14:57:00 DEBUG: pid 4568: I am 4568 > 2010-02-15 14:57:00 DEBUG: pid 4569: I am 4569 > 2010-02-15 14:57:00 DEBUG: pid 4570: I am 4570 > 2010-02-15 14:57:00 DEBUG: pid 4571: I am 4571 > 2010-02-15 14:57:00 DEBUG: pid 4572: I am 4572 > 2010-02-15 14:57:00 DEBUG: pid 4573: I am 4573 > 2010-02-15 14:57:00 DEBUG: pid 4574: I am 4574 > 2010-02-15 14:57:00 DEBUG: pid 4575: I am 4575 > 2010-02-15 14:57:00 DEBUG: pid 4576: I am 4576 > 2010-02-15 14:57:00 DEBUG: pid 4577: I am 4577 > 2010-02-15 14:57:00 DEBUG: pid 4578: I am 4578 > 2010-02-15 14:57:00 LOG: pid 4546: pgpool-II successfully started. version > 2.3.2 (tomiteboshi) > 2010-02-15 14:57:00 DEBUG: pid 4579: I am PCP 4579 > 2010-02-15 14:57:21 DEBUG: pid 4578: I am 4578 accept fd 5 > 2010-02-15 14:57:21 LOG: pid 4578: connection received: host=[local] > 2010-02-15 14:57:21 DEBUG: pid 4578: Protocol Major: 3 Minor: 0 database: > postgres user: postgres > 2010-02-15 14:57:21 DEBUG: pid 4578: new_connection: connecting 0 backend > 2010-02-15 14:57:21 DEBUG: pid 4578: new_connection: connecting 1 backend > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_ssl: SSL requested but SSL support > is not available > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_ssl: SSL requested but SSL support > is not available > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 0 > length: 8 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 1 > length: 8 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 25 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 25 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: client_encoding > value: UTF8 > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: client_encoding > value: UTF8 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 23 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 23 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: DateStyle value: > ISO, MDY > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: DateStyle value: > ISO, MDY > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 26 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 26 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: integer_datetimes > value: off > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: integer_datetimes > value: off > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 20 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 20 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: is_superuser value: > on > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: is_superuser value: > on > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 25 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 25 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: server_encoding > value: UTF8 > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: server_encoding > value: UTF8 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 26 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 26 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: server_version > value: 8.1.11 > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: server_version > value: 8.1.11 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 35 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 35 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: > session_authorization value: postgres > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: > session_authorization value: postgres > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 36 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 36 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: > standard_conforming_strings value: off > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: > standard_conforming_strings value: off > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 0 length: 18 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length2: master slot: > 1 length: 18 > 2010-02-15 14:57:21 DEBUG: pid 4578: 0 th backend: name: TimeZone value: > Caracas > 2010-02-15 14:57:21 DEBUG: pid 4578: 1 th backend: name: TimeZone value: > Caracas > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 0 > length: 12 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 1 > length: 12 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_send_auth_ok: send pid 4583 to > frontend > 2010-02-15 14:57:21 DEBUG: pid 4578: read_kind_from_backend: read kind from > 0 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:57:21 DEBUG: pid 4578: read_kind_from_backend: read kind from > 1 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_process_query: kind from backend: > Z > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:57:21 DEBUG: pid 4578: pool_read_message_length: slot: 1 > length: 5 > 2010-02-15 14:57:21 DEBUG: pid 4578: ReadyForQuery: message length: 5 > 2010-02-15 14:57:21 DEBUG: pid 4578: ReadyForQuery: transaction state: I > 2010-02-15 14:57:47 DEBUG: pid 4578: read kind from frontend Q(51) > 2010-02-15 14:57:47 LOG: pid 4578: statement: select * from test; > 2010-02-15 14:57:47 LOG: pid 4578: DB node id: 0 backend pid: 4582 > statement: select * from test; > 2010-02-15 14:57:53 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend T NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > T > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend D NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > D > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend D NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > D > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend D NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > D > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend C NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > C > 2010-02-15 14:57:53 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend Z NUM_BACKENDS: 1 > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_process_query: kind from backend: > Z > 2010-02-15 14:57:53 DEBUG: pid 4551: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:57:53 DEBUG: pid 4551: ReadyForQuery: message length: 5 > 2010-02-15 14:57:53 DEBUG: pid 4551: ReadyForQuery: transaction state: I > 2010-02-15 14:57:53 DEBUG: pid 4551: end_load_balance: end load balance mode > 2010-02-15 14:57:59 DEBUG: pid 4551: read kind from frontend Q(51) > 2010-02-15 14:57:59 LOG: pid 4551: statement: select * from test2; > 2010-02-15 14:57:59 LOG: pid 4551: DB node id: 0 backend pid: 4586 > statement: select * from test2; > 2010-02-15 14:57:59 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:57:59 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend T NUM_BACKENDS: 1 > 2010-02-15 14:57:59 DEBUG: pid 4551: pool_process_query: kind from backend: > T > 2010-02-15 14:57:59 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend C NUM_BACKENDS: 1 > 2010-02-15 14:57:59 DEBUG: pid 4551: pool_process_query: kind from backend: > C > 2010-02-15 14:57:59 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend Z NUM_BACKENDS: 1 > 2010-02-15 14:57:59 DEBUG: pid 4551: pool_process_query: kind from backend: > Z > 2010-02-15 14:57:59 DEBUG: pid 4551: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:57:59 DEBUG: pid 4551: ReadyForQuery: message length: 5 > 2010-02-15 14:57:59 DEBUG: pid 4551: ReadyForQuery: transaction state: I > 2010-02-15 14:57:59 DEBUG: pid 4551: end_load_balance: end load balance mode > 2010-02-15 14:58:23 DEBUG: pid 4551: read kind from frontend Q(51) > 2010-02-15 14:58:23 LOG: pid 4551: statement: create table test11 > (idtest11 serial); > 2010-02-15 14:58:23 LOG: pid 4551: DB node id: 0 backend pid: 4586 > statement: BEGIN > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: Query: BEGIN > 2010-02-15 14:58:23 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: C > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: kind: C > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: kind: Z > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: transaction state: T > 2010-02-15 14:58:23 LOG: pid 4551: DB node id: 1 backend pid: 4587 > statement: BEGIN > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: Query: BEGIN > 2010-02-15 14:58:23 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: C > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: kind: C > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: kind: Z > 2010-02-15 14:58:23 DEBUG: pid 4551: do_command: transaction state: T > 2010-02-15 14:58:23 LOG: pid 4551: DB node id: 0 backend pid: 4586 > statement: create table test11 (idtest11 serial); > 2010-02-15 14:58:23 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: N > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: N > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: N > 2010-02-15 14:58:23 DEBUG: pid 4551: detect_error: kind: N > 2010-02-15 14:58:23 LOG: pid 4551: SimpleQuery: Error or notice message > from backend: : DB node id: 0 backend pid: 4586 statement: create table > test11 (idtest11 serial); message: CREATE TABLE will create implicit > sequence "test11_idtest11_seq" for serial column "test11.idtest11" > 2010-02-15 14:58:23 LOG: pid 4551: DB node id: 1 backend pid: 4587 > statement: create table test11 (idtest11 serial); > 2010-02-15 14:58:23 DEBUG: pid 4551: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 14:58:23 LOG: pid 4551: SimpleQuery: Error or notice message > from backend: : DB node id: 1 backend pid: 4587 statement: create table > test11 (idtest11 serial); message: CREATE TABLE will create implicit > sequence "test11_idtest11_seq" for serial column "test11.idtest11" > 2010-02-15 14:58:23 DEBUG: pid 4551: read_kind_from_backend: read kind from > 0 th backend NUM_BACKENDS: 2 > 2010-02-15 14:58:23 DEBUG: pid 4551: read_kind_from_backend: read kind from > 1 th backend NUM_BACKENDS: 2 > 2010-02-15 14:58:23 ERROR: pid 4551: pool_process_query: kind is 0! > 2010-02-15 14:58:23 LOG: pid 4551: do_child: exits with status 1 due to > error > 2010-02-15 14:58:23 DEBUG: pid 4546: reap_handler called > 2010-02-15 14:58:23 DEBUG: pid 4546: reap_handler: call wait3 > 2010-02-15 14:58:23 LOG: pid 4588: connection received: host=[local] > 2010-02-15 14:58:23 DEBUG: pid 4546: child 4551 exits with status 256 > 2010-02-15 14:58:23 DEBUG: pid 4588: Protocol Major: 3 Minor: 0 database: > postgres user: postgres > 2010-02-15 14:58:23 DEBUG: pid 4588: new_connection: connecting 0 backend > 2010-02-15 14:58:23 DEBUG: pid 4590: I am 4590 > 2010-02-15 14:58:23 DEBUG: pid 4546: fork a new child pid 4590 > 2010-02-15 14:58:23 DEBUG: pid 4546: reap_handler: normally exited > 2010-02-15 14:58:23 DEBUG: pid 4588: new_connection: connecting 1 backend > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_ssl: SSL requested but SSL support > is not available > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_ssl: SSL requested but SSL support > is not available > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 0 > length: 8 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 1 > length: 8 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 25 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 25 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: client_encoding > value: UTF8 > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: client_encoding > value: UTF8 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 23 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 23 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: DateStyle value: > ISO, MDY > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: DateStyle value: > ISO, MDY > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 26 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 26 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: integer_datetimes > value: off > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: integer_datetimes > value: off > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 20 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 20 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: is_superuser value: > on > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: is_superuser value: > on > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 25 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 25 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: server_encoding > value: UTF8 > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: server_encoding > value: UTF8 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 26 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 26 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: server_version > value: 8.1.11 > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: server_version > value: 8.1.11 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 35 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 35 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: > session_authorization value: postgres > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: > session_authorization value: postgres > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 36 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 36 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: > standard_conforming_strings value: off > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: > standard_conforming_strings value: off > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 0 length: 18 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length2: master slot: > 1 length: 18 > 2010-02-15 14:58:23 DEBUG: pid 4588: 0 th backend: name: TimeZone value: > Caracas > 2010-02-15 14:58:23 DEBUG: pid 4588: 1 th backend: name: TimeZone value: > Caracas > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 0 > length: 12 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 1 > length: 12 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_send_auth_ok: send pid 4592 to > frontend > 2010-02-15 14:58:23 DEBUG: pid 4588: read_kind_from_backend: read kind from > 0 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:58:23 DEBUG: pid 4588: read_kind_from_backend: read kind from > 1 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_process_query: kind from backend: > Z > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:58:23 DEBUG: pid 4588: pool_read_message_length: slot: 1 > length: 5 > 2010-02-15 14:58:23 DEBUG: pid 4588: ReadyForQuery: message length: 5 > 2010-02-15 14:58:23 DEBUG: pid 4588: ReadyForQuery: transaction state: I > 2010-02-15 14:59:34 DEBUG: pid 4588: read kind from frontend Q(51) > 2010-02-15 14:59:34 LOG: pid 4588: statement: create table test11 > (idtest11 integer); > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 0 backend pid: 4591 > statement: BEGIN > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: Query: BEGIN > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: transaction state: T > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 1 backend pid: 4592 > statement: BEGIN > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: Query: BEGIN > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: transaction state: T > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 0 backend pid: 4591 > statement: create table test11 (idtest11 integer); > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 1 backend pid: 4592 > statement: create table test11 (idtest11 integer); > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: read_kind_from_backend: read kind from > 0 th backend C NUM_BACKENDS: 2 > 2010-02-15 14:59:34 DEBUG: pid 4588: read_kind_from_backend: read kind from > 1 th backend C NUM_BACKENDS: 2 > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_process_query: kind from backend: > C > 2010-02-15 14:59:34 DEBUG: pid 4588: read_kind_from_backend: read kind from > 0 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:59:34 DEBUG: pid 4588: read_kind_from_backend: read kind from > 1 th backend Z NUM_BACKENDS: 2 > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_process_query: kind from backend: > Z > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_read_message_length: slot: 1 > length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: ReadyForQuery: message length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: ReadyForQuery: transaction state: T > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 1 backend pid: 4592 > statement: COMMIT > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: Query: COMMIT > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 14:59:34 LOG: pid 4588: DB node id: 0 backend pid: 4591 > statement: COMMIT > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: Query: COMMIT > 2010-02-15 14:59:34 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 14:59:34 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 14:59:34 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_read_message_length: slot: 0 > length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: pool_read_message_length: slot: 1 > length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: ReadyForQuery: message length: 5 > 2010-02-15 14:59:34 DEBUG: pid 4588: ReadyForQuery: transaction state: I > 2010-02-15 15:01:35 DEBUG: pid 4588: read kind from frontend Q(51) > 2010-02-15 15:01:35 LOG: pid 4588: statement: alter table test11 add > primary key (idtest11); > 2010-02-15 15:01:35 LOG: pid 4588: DB node id: 0 backend pid: 4591 > statement: BEGIN > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: Query: BEGIN > 2010-02-15 15:01:35 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: transaction state: T > 2010-02-15 15:01:35 LOG: pid 4588: DB node id: 1 backend pid: 4592 > statement: BEGIN > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: Query: BEGIN > 2010-02-15 15:01:35 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: C > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: kind: C > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: kind: Z > 2010-02-15 15:01:35 DEBUG: pid 4588: do_command: transaction state: T > 2010-02-15 15:01:35 LOG: pid 4588: DB node id: 0 backend pid: 4591 > statement: alter table test11 add primary key (idtest11); > 2010-02-15 15:01:35 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 0 completing the query > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: N > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: N > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: N > 2010-02-15 15:01:35 DEBUG: pid 4588: detect_error: kind: N > 2010-02-15 15:01:35 LOG: pid 4588: SimpleQuery: Error or notice message > from backend: : DB node id: 0 backend pid: 4591 statement: alter table > test11 add primary key (idtest11); message: ALTER TABLE / ADD PRIMARY KEY > will create implicit index "test11_pkey" for table "test11" > 2010-02-15 15:01:35 LOG: pid 4588: DB node id: 1 backend pid: 4592 > statement: alter table test11 add primary key (idtest11); > 2010-02-15 15:01:35 DEBUG: pid 4588: wait_for_query_response: waiting for > backend 1 completing the query > 2010-02-15 15:01:35 LOG: pid 4588: SimpleQuery: Error or notice message > from backend: : DB node id: 1 backend pid: 4592 statement: alter table > test11 add primary key (idtest11); message: ALTER TABLE / ADD PRIMARY KEY > will create implicit index "test11_pkey" for table "test11" > 2010-02-15 15:01:35 DEBUG: pid 4588: read_kind_from_backend: read kind from > 0 th backend NUM_BACKENDS: 2 > 2010-02-15 15:01:35 DEBUG: pid 4588: read_kind_from_backend: read kind from > 1 th backend NUM_BACKENDS: 2 > 2010-02-15 15:01:35 ERROR: pid 4588: pool_process_query: kind is 0! > 2010-02-15 15:01:35 LOG: pid 4588: do_child: exits with status 1 due to > error > > > > -- > Ing. Ivan José Pozo Michelangelli > +58 (416) 6122347 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general