[Dbbalancer-users] Re: Test failed

[Andrew M. <an...@ca...>]

On Thu, 2002-11-07 at 02:10, Michael E. Labhard wrote:
> Andrew:
> 
> 	Thank you for the reply.  However, I don't see how the conf file you have 
> attached differs significantly from the one I am using.  Mine appears below 
> along with the output from the run_test.sh command.  Any other ideas?

Does the script try and do a TCP connection, or through a socket?  Are
the permissions on the socket sufficient to allow the process to connect
to it?

I know that in packaging DBBalancer for Debian I ran into a number of
socket permission problems.

Regards,
					Andrew.
> 
> -- Michael
> 
> Confuration File:
> 
> daemon.reader-port=6666
> daemon.writer-port=6666
> daemon.init-threads=5
> daemon.min-threads=5
> daemon.max-threads=30
> daemon.init-db-connections=5
> daemon.min-db-connections=5
> daemon.max-db-connections=30
> daemon.reaper-delay=1
> daemon.dbname=dbbalancer
> daemon.user=mel
> daemon.password=
> daemon.auth-method=trusted
> 
> machine.host=localhost
> machine.dbname=dbbalancer
> machine.port=5432
> machine.dbuser=mel
> machine.dbpassword=
> 
> 
> Test Output:
> 
> ----------------------------------------------------------
> DBBalancer test script. Version 0.2.3
> ----------------------------------------------------------
> 
> For this script to work, you should have:
>  a) Created the db's in every host included in the pool (pgsql/create_db.sh)
>  b) Modified the variables on top of this script to point to your real config
>  c) Modified the $TESTER script or program to also point to your real config
>  d) Configured and started your backend databases and DBBalancerDaemon 
> processes
> 
> ----------------------------------------------------------
> Checking reader process ......OK!
> 
> ----------------------------------------------------------
> 1. One concurrent user test.
> ----------------------------------------------------------
> 
> ----------------------------------------------------------
>  1.1 Direct to Postgres (5432).
> 
> 
> 
> Iterations      : 1000
> Server Port     : 5432
> Query           : SELECT TB_ONE.FIELD1, TB_ONE.FIELD2, TB_TWO.FIELD1 FROM 
> TB_ONE,TB_TWO WHERE TB_ONE.FIELD2=TB_TWO.FIELD2
> 
> 
> ------------------------------------------
>  Executed 1000 requests.
>  In 9.000000 seconds.
>  Had 0 errors.
> ------------------------------------------
>  Result: 111.111111 requests/second.
> 
> 
> ----------------------------------------------------------
>  1.2 Thru DBBalancer (6666)
> 
> 
> 
> Iterations      : 1000
> Server Port     : 6666
> Query           : SELECT TB_ONE.FIELD1, TB_ONE.FIELD2, TB_TWO.FIELD1 FROM 
> TB_ONE,TB_TWO WHERE TB_ONE.FIELD2=TB_TWO.FIELD2
> 
> 
> 
> 6666 -> request 1: inf req/sProblem with the connection: could not connect to 
> server: Connection refused
> 	Is the server running on host localhost and accepting
> 	TCP/IP connections on port 6666?
> 
> 
> 6666 -> request 1: inf req/sProblem with the connection: could not connect to 
> server: Connection refused
> 	Is the server running on host localhost and accepting
> 	TCP/IP connections on port 6666?
> 
>  
> 
-- 
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/ 
---------------------------------------------------------------------