[Pgpool-general] Replication problems when i try to create a table with a constraint or a serial data type
Ivan Pozo
ipozom at gmail.com
Fri Feb 19 22:45:03 UTC 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100219/e81799f4/attachment-0001.html>
More information about the Pgpool-general
mailing list