[Dbbalancer-users] dbbalancer 0.4.4 writer daemon problems

[Dushyanth H. <dus...@di...>]

Hi guys,

Iam getting this error below when i try to connect through the dbbalancer 
writer daemon.

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