Re: [Dbbalancer-users] dbbalancer 0.4.4 writer daemon problems
Status: Alpha
Brought to you by:
xperience
Menu
▾
▴
Re: [Dbbalancer-users] dbbalancer 0.4.4 writer daemon problems
|
From: Andrew M. <an...@ca...> - 2004-05-19 02:55:53
|
On Tue, 2004-05-18 at 22:22 +0530, Dushyanth Harinath wrote:
> Hi guys,
>
> Iam getting this error below when i try to connect through the dbbalancer
> writer daemon.
I think this might be the authentication problem I fixed in CVS. You
may want to try the latest CVS, which is able to fallback if the
connection attempt uses the latest protocol.
Cheers,
Andrew.
>
> Warning: pg_connect() unable to connect to PostgreSQL server: DBBalancer:
> DBBalancer (replication mode) sync error: Received a unexpected response
> command from the backends in /var/www/html/insert.php on line 12
> Could not connect to db.
>
> I started dbbalancerd like below..
>
> # ./dbbalancerd -w -d -f etc/LoadBalancerExample.conf
>
> The error msg i get in the console when i call insert.php is below..
>
> (2051, 21:56:26.320700) (01) 2 descriptors modified.
> (2051, 21:56:26.320840) Data in BE socket (number :01:0).
> (2051, 21:56:26.320993) Received 79 bytes from BE socket.
> (2051, 21:56:26.321123) Data in BE socket (number :01:1).
> (2051, 21:56:26.321259) Received 79 bytes from BE socket.
> ***checkAndSendData(18)
> (2051, 21:56:26.321561) getBEBuffersFirstCharacter()
> (2051, 21:56:26.321681) Content of buffer 1
> HEXDUMP 79 bytes
> 43 42 45 47 49 4e 00 50 62 6c 61 6e 6b 00 54 00 CBEGIN.Pblank.T.
> 01 67 65 74 64 61 74 61 62 61 73 65 65 6e 63 6f .getdatabaseenco
> 64 69 6e 67 00 00 00 00 13 00 40 ff ff ff ff 44 ding......@....D
> 80 00 00 00 0d 53 51 4c 5f 41 53 43 49 49 43 53 .....SQL_ASCIICS
> 45 4c 45 43 54 00 43 43 4f 4d 4d 49 54 00 5a (2051, 21:56:26.322105) The
> returned command was (C)
> (2051, 21:56:26.322231) Received an unexpected response command from the
> backends (C)
> (2051) DBPostgresFrontend: Message to FrontEnd: DBBalancer: DBBalancer
> (replication mode) sync error: Received a unexpected response command from
> the backends
> HEXDUMP 114 bytes
> 45 20 44 42 42 61 6c 61 6e 63 65 72 3a 20 44 42 E DBBalancer: DB
> 42 61 6c 61 6e 63 65 72 20 28 72 65 70 6c 69 63 Balancer (replic
> 61 74 69 6f 6e 20 6d 6f 64 65 29 20 73 79 6e 63 ation mode) sync
> 20 65 72 72 6f 72 3a 20 20 52 65 63 65 69 76 65 error: Receive
> 64 20 61 20 75 6e 65 78 70 65 63 74 65 64 20 72 d a unexpected r
> 65 73 70 6f 6e 73 65 20 63 6f 6d 6d 61 6e 64 20 esponse command
> 66 72 6f 6d 20 74 68 65 20 62 61 63 6b 65 6e 64 from the backend
> 73 00 (2051, 21:56:26.323291) DBPostgresWriterConnection: Received a
> unexpected response command from the backends
> ************** handleConnectionLoop (it: 50) *************
> (1026 21:56:26.738618) DBThreadPool::reviewThreads. Current: 10, Queue: 0,
> Calm Rounds: 10.
> (1026 21:56:26.738864) DBPool::getConnectionForTest(): Lets see if pool 02,
> Conn 0...
> (1026) Connection 02 is going to be tested!!.
>
>
> In line 12, I have the below connect functon..
>
> $con=pg_connect("host=192.168.0.69 port=5443 dbname=test user=test
> password=qwedsa") or die ("Could not connect to db");
>
> I get this error when i try to connect from psql too..
>
> # psql -h 192.168.0.69 -p 5443 -U test -d test
> Password:
> psql: DBBalancer: DBBalancer (replication mode) sync error: Received a
> unexpected response command from the backends
>
> The same credentials works for the reader daemon and iam able to run select
> queries through it..
>
> The dbbalancer conf file is below..
>
> ---------------
> daemon.reader-port=5442
> daemon.writer-port=5443
> daemon.host=master
>
> daemon.init-threads=10
> daemon.min-threads=10
> daemon.max-threads=30
> daemon.init-db-connections=5
> daemon.min-db-connections=5
> daemon.max-db-connections=15
> daemon.reaper-delay=1
> daemon.user=test
> daemon.password=qwedsa
> daemon.dbname=test
> daemon.auth-method=password
> daemon.log-file=stderr
>
> machine.host=rs1
> machine.dbname=test
> machine.port=5432
> machine.dbuser=test
> machine.dbpassword=qwedsa
>
> machine.host=rs2
> machine.dbname=test
> machine.port=5432
> machine.dbuser=test
> machine.dbpassword=qwedsa
> ---------
>
> Password authentication is set on all the backend db's and the versions are
>
> Redhat 7.3
> Postgres 7.3.6.
> Ace 5.1.14
> libpq++-4.0.
>
> How do i get the writer daemon working. Any suggestions ?
>
> tia
> dushyanth
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
> _______________________________________________
> Dbbalancer-users mailing list
> Dbb...@li...
> https://lists.sourceforge.net/lists/listinfo/dbbalancer-users
-------------------------------------------------------------------------
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
The world isn't worse - the news coverage is better.
-------------------------------------------------------------------------
|
