Differences between revisions 3 and 4
Revision 3 as of 2010-04-22 12:03:27
Size: 1139
Comment: Cleared up confused description of SQL queries and results.
Revision 4 as of 2010-08-16 10:24:52
Size: 1139
Editor: localhost
Comment: converted to 1.6 markup
No differences found!

Verify that the database is empty

Use ssh to go the admin machine and into your installation directory (netarkivet.dk -> kb-test-adm-001, and /home/test/TESTX)

Check that no admin.data file exists.

Check that a database directory, adminDB, exists.

Check the port number for the database by running the command:

  • > more conf/start_external_database.sh

It should give a line like:

  • java -cp $INSTALLDIR/lib/db/derby.jar:$INSTALLDIR/lib/db/derbynet.jar org.apache.derby.drda.NetworkServerControl -p 8139 start ...

The port in this case is 8139.

Log into the database and check the status (it is an external database, so the applications does not need to be shutdown before accessing the database).

  • > java -cp lib/db/derbyclient-*.jar:lib/db/derbytools-*.jar org.apache.derby.tools.ij

  • > connect 'jdbc:derby://localhost:$PORT/adminDB'

Check the content of the different tables.

SELECT COUNT(*) FROM file;

SELECT COUNT(*) FROM replica;

SELECT COUNT(*) FROM replicafileinfo;

The last number should be the product of the first two. The number of replicas should be 3.

It42VerifyNotEmptyDatabase (last edited 2010-08-16 10:24:52 by localhost)