Differences between revisions 2 and 4 (spanning 2 versions)
⇤ ← Revision 2 as of 2010-04-22 11:58:11 →
Size: 1467
Editor: ColinRosenthal
Comment:
← Revision 4 as of 2010-08-16 10:24:52 → ⇥
Size: 1139
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 19: Line 19:
 . > java -cp lib/db/derbyclient-10.5.3.0.jar:lib/db/derbytools-10.5.3.0.jar org.apache.derby.tools.ij
 > connect 'jdbc:derby://localhost:$PORT/adminDB'
Check the content of the different tables. The file table and the replicafileinfo table should be empty, whereas the replica table should contain the replicas:		  . > 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.
Line 23: Line 23:
 . > SELECT * FROM file;
...		 SELECT COUNT(*) FROM file;
Line 26: Line 25:
It should now contain the amount of harvested files (at least 4, two for each harvest, and at least 1-metadata-1.arc and 2-metadata-1.arc). SELECT COUNT(*) FROM replica;
Line 28: Line 27:
 . > SELECT * FROM replicafileinfo;
...		 SELECT COUNT(*) FROM replicafileinfo;
Line 31: Line 29:
If should now contain the 3 times the amount of harvested files, one for each replica (thus at least 12).

 . > SELECT * FROM replica;
...

3 rows selected

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

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)