[pgpool-general: 1926] Re: load test fails

[Wolf Schwurack]

Resolved, changed parameter from the default 32 to 128;  num_init_children = 128

Wolf

From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Wolf Schwurack
Sent: Tuesday, July 23, 2013 9:22 AM
To: 'pgpool-general at pgpool.net'
Subject: [pgpool-general: 1924] load test fails

I am running a load test on pgpool and it fails over at 40 clients 5 transaction and just hangs.  When I run the same load test on the postgres database I can run  100 clients 10 transaction pre client with out any problems. Are there any setting I can set on pgpool. I have pgpool running in debug mode but doesn't tell me why its failing over.

2 postgres servers Ubuntu 10.04.4 postgres 9.2.4 master/stream
2 pgpool servers Ubuntu 10.04.4 pgpool-II version 3.2.5 using watchdog


1.       This show load test on postgres database server completed
$ pgbench -U test -c 100 -t 10 bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 10
number of transactions actually processed: 1000/1000
tps = 279.137721 (including connections establishing)
tps = 445.681855 (excluding connections establishing)


2.        Load test on pgpool - shows 30 clients 5 transaction completed and 40 clients 5 transaction hung
$ pgbench -h wd-pgtest.uen.org -U test -p 9999 -c 30 -t 5 bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 30
number of threads: 1
number of transactions per client: 5
number of transactions actually processed: 150/150
tps = 134.569579 (including connections establishing)
tps = 186.005908 (excluding connections establishing)
$ pgbench -h wd-pgtest.uen.org -U test -p 9999 -c 40 -t 5 bench
starting vacuum...end.


3.        Pgpool log file - This show at the time of the fail over but not why its failing
2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: checking pgpool 0 (pgtest-con2:9999)
2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: OK, status: 2
2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: checking pgpool 1 (pgtest-con1:9999)
2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: NG, status: 3 life:1
2013-07-23 08:32:40 LOG:   pid 1338: wd_lifecheck: lifecheck failed 3 times. pgpool 1 (pgtest-con1:9999) seems not to be working
2013-07-23 08:32:40 DEBUG: pid 1338: wd_stand_for_master: send the packet to be the new master
2013-07-23 08:32:40 LOG:   pid 1338: wd_escalation: escalated to master pgpool

      0___      Wolfgang Schwurack
     c/  /'_    System/Database Administrator
    (*)  \(*)   Utah Education Network
                Tel: (801) 587-9444
                email: wolf at uen.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130723/8dea7309/attachment.html>