Differences between revisions 1 and 4 (spanning 3 versions)
Revision 1 as of 2010-03-08 13:08:03
Size: 1472
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 2: Line 2:
Line 12: Line 11:
 > more conf/start_external_database.sh  . > more conf/start_external_database.sh
It should give a line like:
Line 14: Line 14:
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 ...''
 . ''java -cp $INSTALLDIR/lib/db/derby.jar:$INSTALLDIR/lib/db/derbynet.jar org.apache.derby.drda.NetworkServerControl -p '''8139''' start ...''
Line 22: Line 19:
 > java -cp lib/db/derbyclient-10.4.2.0.jar:lib/db/derbytools-10.4.2.0.jar org.apache.derby.tools.ij  . > 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 24: Line 23:
 > connect 'jdbc:derby://localhost:$PORT/adminDB' SELECT COUNT(*) FROM file;
Line 26: Line 25:
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: SELECT COUNT(*) FROM replica;
Line 28: Line 27:
 > SELECT * FROM file; SELECT COUNT(*) FROM replicafileinfo;
Line 30: Line 29:
...

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 * FROM replicafileinfo;

...

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)