<div><br></div><div>Hi,</div><div>I would like to know if I can exclude the command EXPLAIN from the pgpool.</div><div>It generates a lot of errors:</div><div><br></div><div>2012-06-13 09:35:11 ERROR: pid 15204: read_kind_from_backend: 1 th kind C does not match with master or majority connection kind D</div>
<div>2012-06-13 09:35:11 ERROR: pid 15204: kind mismatch among backends. Possible last query was: "EXPLAIN SELECT ...... " kind details are: 0[D] 1[C]</div><div>2012-06-13 09:35:11 LOG: pid 15204: do_child: exits with status 1 due to error</div>
<div><br></div><div>pool-II-3.1.3</div><div>PostgreSQL 9.1.2</div><div>both Server same Hardware.</div><div><br></div><div>Pgpool configuration:</div><div><br></div><div>listen_addresses = '*'</div><div>port = 5432</div>
<div>socket_dir = '/var/run/postgresql'</div><div>pcp_port = 9898</div><div>pcp_socket_dir = '/tmp'</div><div>backend_hostname0 = 'localhost'</div><div>backend_port0 = 5434</div><div>backend_weight0 = 1</div>
<div>backend_data_directory0 = '/var/lib/postgresql/9.1/main'</div><div>backend_flag0 = 'ALLOW_TO_FAILOVER'</div><div>backend_hostname1 = '172.16.0.1'</div><div>backend_port1 = 5434<span class="Apple-tab-span" style="white-space:pre"> </span>#doveva essere a 5434</div>
<div>backend_weight1 = 1</div><div>backend_data_directory1 = '/var/lib/postgresql/9.1/main'</div><div>backend_flag1 = 'ALLOW_TO_FAILOVER'</div><div>enable_pool_hba = off</div><div>authentication_timeout = 60</div>
<div># - SSL Connections -</div><div>num_init_children = 32</div><div>max_pool = 10 <span class="Apple-tab-span" style="white-space:pre"> </span></div><div>child_life_time = 300 </div><div>child_max_connections = 0</div>
<div>connection_life_time = 0</div><div>client_idle_limit = 0</div><div>log_destination = 'stderr'</div><div>print_timestamp = on</div><div>log_connections = off </div><div>log_hostname = on </div>
<div>log_statement = off </div><div>log_per_node_statement = off </div><div>log_standby_delay = 'none'</div><div>syslog_facility = 'LOCAL0' </div>
<div>syslog_ident = 'pgpool'</div><div>debug_level = 0</div><div>pid_file_name = '/var/run/pgpool/pgpool.pid'</div><div>logdir = '/tmp'</div><div>connection_cache = on</div><div>reset_query_list = 'ABORT; DISCARD ALL'</div>
<div>replication_mode = on</div><div>replicate_select = off</div><div>insert_lock = on</div><div>lobj_lock_table = ''</div><div>replication_stop_on_mismatch = off</div><div>failover_if_affected_tuples_mismatch = off</div>
<div>load_balance_mode = off</div><div>ignore_leading_white_space = on</div><div>white_function_list = ''</div><div>black_function_list = 'nextval,setval'</div><div>master_slave_mode = off</div><div>sr_check_period = 0</div>
<div>sr_check_user = 'nobody'</div><div>sr_check_password = ''</div><div>delay_threshold = 0</div><div>follow_master_command = ''</div><div>parallel_mode = off</div><div>enable_query_cache = off</div>
<div>pgpool2_hostname = 'localhost'</div><div>system_db_hostname = 'localhost'</div><div>system_db_port = 5434</div><div>system_db_dbname = 'pgpool'</div><div>system_db_schema = 'pgpool_catalog' </div>
<div>system_db_user = 'pgpool' </div><div>system_db_password = ''</div><div>health_check_period = 0 </div><div>health_check_timeout = 20 </div><div>health_check_user = 'nobody' </div>
<div>health_check_password = ''</div><div><br></div><div>------------------------------------</div><div><br></div><div><div><div>The answers about these questions are welcome.</div><div><br></div><div>Best Regards </div>
<div><br></div><div>Nicolas</div></div></div><div><br></div><div><br></div><div><br></div><div><br></div>