[postgres@pgrepl1 ~]$ pgpool -n & [1] 5549 [postgres@pgrepl1 ~]$ 2013-07-08 16:22:00 LOG: pid 5549: Backend status file /tmp/pgpool_status does not exist 2013-07-08 16:22:00 LOG: pid 5549: pgpool-II successfully started. version 3.2.4 (namameboshi) [postgres@pgrepl1 ~]$ [postgres@pgrepl1 ~]$ [postgres@pgrepl1 ~]$ [postgres@pgrepl1 ~]$ psql -p 9999 psql (9.2.4) Type "help" for help. postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role ---------+----------+------+--------+-----------+-------- 0 | pgrepl3 | 5432 | 2 | 0.500000 | master 1 | pgrepl4 | 5432 | 2 | 0.500000 | slave (2 rows) postgres=# create database bench; CREATE DATABASE postgres=# \q [postgres@pgrepl1 ~]$ pgbench -i -p 9999 -U postgres bench 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 1364 statement: drop table if exists pgbench_branches message: table "pgbench_branches" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 1293 statement: drop table if exists pgbench_branches message: table "pgbench_branches" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 1364 statement: drop table if exists pgbench_tellers message: table "pgbench_tellers" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 1293 statement: drop table if exists pgbench_tellers message: table "pgbench_tellers" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 1364 statement: drop table if exists pgbench_accounts message: table "pgbench_accounts" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 1293 statement: drop table if exists pgbench_accounts message: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_accounts" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 1364 statement: drop table if exists pgbench_history message: table "pgbench_history" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 1293 statement: drop table if exists pgbench_history message: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_history" does not exist, skipping 2013-07-08 16:23:40 LOG: pid 5550: do_query: error message from backend function "pgpool_regclass(cstring)" does not exist 2013-07-08 16:23:40 LOG: pid 5550: do_query: error message from backend current transaction is aborted, commands ignored until end of transaction block 2013-07-08 16:23:40 LOG: pid 5550: do_query: error message from backend current transaction is aborted, commands ignored until end of transaction block 2013-07-08 16:23:40 LOG: pid 5550: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 back end pid: 1364 statement: insert into pgbench_branches(bid,bbalance) values(1,0) message: current transaction is aborted, commands ignored until end of transaction block 2013-07-08 16:23:40 ERROR: pid 5550: read_kind_from_backend: 1 th kind C does not match with master or majority connection kind E 2013-07-08 16:23:40 ERROR: pid 5550: kind mismatch among backends. Possible last query was: "insert into pgbench_branches(bid,bbalance) values(1,0)" kind details are: 0[E: current transaction is aborted, commands ignored until end of transaction block] 1[C] 2013-07-08 16:23:40 LOG: pid 5550: do_child: exits with status 1 due to error ERROR: kind mismatch among backends. Possible last query was: "insert into pgbench_branches(bid,bbalance) values(1,0)" kind details are: 0[E: current transaction is aborted, commands ignored until end of transaction block] 1[C] HINT: check data consistency among db nodes ERROR: kind mismatch among backends. Possible last query was: "insert into pgbench_branches(bid,bbalance) values(1,0)" kind details are: 0[E: current transaction is aborted, commands ignored until end of transaction block] 1[C] HINT: check data consistency among db nodes