Re: [Dbbalancer-users] DBBalancer Replication error

[Daniel V. S. <dv...@ar...>]

Hello Graziella. I will try to help you.

The messages you're sending don't "neccesarily" imply that an error is=20
happening. They may be saying just than a database is slower than other=20
(because of a slower machine, slower connection, etc). I would like to kn=
ow=20
what are you experieced from the client side (maybe hung connections...?)=
. =20
It would also be helpful if you sent me a full debug log (as a compressed=
=20
attachment, please). Please be careful since the log may include=20
passwords....

Regards
Daniel.

On Mi=E9 27 Nov 2002 15:31, Gra...@go... wrote:
> Hi,
>
> I tried to use DBBalancer to replicate between 2 databases, each one on=
 a
> different server.  However, when I tried to send a write request to the
> DBBalancer daemon from a java program (through JDBC) I got the followin=
g
> error:
>
> (2051,  14:06:25.119134) Login data received OK.
>  (2051,  14:06:25.119170) Max Descriptor 20.
> ( 14:06:25.119208,2051) Sending Transaction Command: begin
> (2051) DBPostgresBackend: Command to BackEnd: Qbegin;
> HEXDUMP 8 bytes
> 51 62 65 67 69 6e 3b 00                            Qbegin;.
>
> (2051) DBPostgresBackend: Command to BackEnd: Qbegin;
> HEXDUMP 8 bytes
> 51 62 65 67 69 6e 3b 00                            Qbegin;.
>
> ************** handleConnectionLoop (it: 1) *************
>  (2051,  14:06:25.221996) (04) 1 descriptors modified.
>  (2051,  14:06:25.222047) Data in FE socket.
>  (2051,  14:06:25.222087) Received 137 bytes from FE socket.
>  HEXDUMP 137 bytes
> 51 73 65 74 20 64 61 74  65 73 74 79 6c 65 20 74   Qset datestyle t
> 6f 20 27 49 53 4f 27 3b  20 73 65 6c 65 63 74 20   o 'ISO'; select
> 76 65 72 73 69 6f 6e 28  29 2c 20 63 61 73 65 20   version(), case
> 77 68 65 6e 20 70 67 5f  65 6e 63 6f 64 69 6e 67   when pg_encoding
> 5f 74 6f 5f 63 68 61 72  28 31 29 20 3d 20 27 53   _to_char(1) =3D 'S
> 51 4c 5f 41 53 43 49 49  27 20 74 68 65 6e 20 27   QL_ASCII' then '
> 55 4e 4b 4e 4f 57 4e 27  20 65 6c 73 65 20 67 65   UNKNOWN' else ge
> 74 64 61 74 61 62 61 73  65 65 6e 63 6f 64 69 6e   tdatabaseencodin
> 67 28 29 20 65 6e 64 3b  00                        g() end;.
>
> (2051,  14:06:25.222460) Didn't have data in all Backends (0 / 2).
> ************** handleConnectionLoop (it: 2) *************
>  (2051,  14:06:25.225652) (04) 1 descriptors modified.
> (2051,  14:06:25.225752) Didn't have data in all Backends (1 / 2).
> ************** handleConnectionLoop (it: 3) *************
>  (2051,  14:06:25.225819) (04) 1 descriptors modified.
> (2051,  14:06:25.225857) Didn't have data in all Backends (1 / 2).
> ************** handleConnectionLoop (it: 4) *************
>
> Could you help please?
>
> Graziella Vella
> Junior Executive (I.T.)
> Go Mobile
> Malta

--=20

-----------------------------------------------------
Regards from Spain^H^H^H^H^H England.  Daniel Varela
-----------------------------------------------------

If you think education is expensive, try ignorance.
           -Derek Bok (Former Harvard President)