[Dbbalancer-users] dbbalancer 0.4.4 writer daemon problems
Status: Alpha
Brought to you by:
xperience
Menu
▾
▴
[Dbbalancer-users] dbbalancer 0.4.4 writer daemon problems
|
From: Dushyanth H. <dus...@di...> - 2004-05-18 16:53:02
|
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
|
