Alan Burlison <[email protected]> writes: > Dag H. Wanvik wrote: > >> No, that should not matter unless there is a bug somewhere. Maybe we >> can best untangle these issues if you can provide a repro? > > OK, I've replicated this from the command-line. Here are the steps I used:
Great that you can reproduce it, Alan. I'm willing to have a look if you can send me (a link to) the database (I can access SWAN). Before we do that though, I notice that you are specifying the securityMechanism=8 on the client connect here. Just a long shot, did you try without that setting? Thanks, Dag > > 1. Copy the database from the master to the slave, with the master > shut down. > > 2. Start the database server on the slave: > > $ export CLASSPATH=/opt/db-derby/lib/derbyrun.jar > $ cd /tmp/auth > $ java org.apache.derby.drda.NetworkServerControl start -h bleaklow -p > 1527 -noSecurityManager > 2009-07-08 13:31:46.286 GMT : Apache Derby Network Server - 10.5.1.1 - > (764942) started and ready to accept connections on port 1527 > > 3. Start ij on the master and try to start the slave database in > startSlave mode: > > ij> connect > jdbc:derby://bleaklow/opensolaris;user=auth;password=CHANGEME;securityMechanism=8;startSlave=true'; > ERROR XRE09: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE09, SQLERRMC: > Cannot start replication slave mode for database 'opensolaris'. The > database has already been booted. > > I thought that perhaps the problem was that I was trying to put the > slave DB into startSlave mode from a different machine to the one that > the slave server was running on, so I tried opening up the closed DB > on the master in startSlave mode and got an identical result: > > $ java org.apache.derby.drda.NetworkServerControl start -h fire -p > 1528 -noSecurityManager > 2009-07-08 13:53:04.557 GMT : Apache Derby Network Server - 10.5.1.1 - > (764942) started and ready to accept connections on port 1528 > > ij> connect > jdbc:derby://fire/opensolaris;user=auth;password=CHANGEME;securityMechanism=8;startSlave=true'; > ERROR XRE09: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE09, SQLERRMC: > Cannot start replication slave mode for database 'opensolaris'. The > database has already been booted. > > I also tried switching everything to localhost, as in the example script: > >> ij> connect >> 'jdbc:derby://localhost/opensolaris;user=auth;password=CHANGEME;securityMechanism=8;startSlave=true'; >> ERROR XRE09: DERBY SQL error: SQLCODE: -1, SQLSTATE: XRE09, SQLERRMC: Cannot >> start replication slave mode for database 'opensolaris'. The database has >> already been booted > > So whatever the problem is, it seems to be to so with the contents of > the particular database that I'm trying to replicate. I can provide a > copy to anyone that wants to dig - it is a small (3.6Mb) test datbase > with just dummy data in it. > > -- > Alan Burlison
