Hello,
I'm testing replication with Derby 10.5 on encrypted database and I cannot
start the slave server which always hangs indefinitely, while derby.log says
that replication can start. Connecting ith startMaster on the master server
results in XRE04 error.
Setting :
Master server : 192.168.1.103
DB frozen and copied to slave
Slave server : 192.168.1.100
In ij on slave :
CONNECT
'jdbc:derby://192.168.1.100:1527/replicatest;ssl=basic;bootPassword=bootPassword;startSlave=true;slaveHost=192.168.1.100;slavePort=1528';
ij does not return.
In derby.log :
2009-06-01 09:07:05.634 GMT:
Amorçage de Derby version The Apache Software Foundation - Apache Derby -
10.5.1.1 - (764942) : instance 601a400f-0121-9af7-af43-00004d18f867
sur le répertoire de base de données /home/derby/replicatest
La base de données esclave de réplication 'replicatest' écoute les
connexions à partir du maître sur '192.168.1.100 :1528'.
On slave :
netstat -l -n | grep 15
tcp 0 0 :::1527 :::* LISTEN
tcp 0 0 ::ffff:192.168.1.100:1528 :::* LISTEN
On master (ij):
CONNECT
'jdbc:derby://192.168.1.103/replicatest;ssl=basic;bootPassword=bootPassword;startMaster=true;slaveHost=192.168.1.100;slavePort=1528';
ERREUR XRE04 : DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE04, SQLERRMC:
replicatest192.168.1.1001528XRE04.U.1
On master :
telnet 192.168.1.100 1528
Result on slave :
ERREUR XJ040 : DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Echec
du d�marrage de la base de donn�es 'replicatest' ; pour plus de d�tails, voir
l'exception suivante.::SQLSTATE: XRE04Impossible détablir une connexion avec
lhomologue de la base de données répliquée 'replicatest' à ladresse '{1}:{2}'.
So it seems that startSlave always hangs in ij, startMaster can't connect to
the slave, the slave seems to wait for replication on 1528.
I have searched the web, derby bug database, derby mailing lists archives in
vain.
Please help.
Thank you.