[Pgpool-general] Replication problems when i try to create a table with a constraint or a serial data type

Sat Feb 20 00:19:38 UTC 2010

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