[pgpool-general: 1926] Re: load test fails
Wolf Schwurack
wolf at uen.org
Wed Jul 24 03:20:40 JST 2013
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.pgpool.net/pipermail/pgpool-general/attachments/20130723/8dea7309/attachment.htm>
More information about the pgpool-general
mailing list