[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Handle-info] From jdb to mysql

Sean,

Recapitulation: 
    I created a myself database
    I shutdown handle server
    I add a record to the nas table
    I reconfigure config.dct to use mysql
    I start the handle server

    I use the a script to add handles, see blow.

The problem:

    I start the admintool (x-term), and authenticate.
    I try to list all handles

This is when the error occurs.




Note: the log file below is using the jdb files and not mysql.  I have a meeting  scheduled later to show how the handle server can be used as a proxy and need it to function properly.  Once that meeting ic concluded I can switch back to mysql and re-run the script to get you the log file.

-rw-r--r--    1 handle   staff        4200 Mar 12 13:15 handle_create.dat
-rwxr--r--    1 handle   staff         115 Mar 15 11:33 handle_create.ksh
-rw-r--r--    1 handle   staff        1053 Mar 15 11:38 handle_create.log

The create script linux ksh script:
$ cat handle_create.ksh
java -Xmx1000m net.handle.apps.batch.GenericBatch handle_create.dat handle_create.log

The data file:

$ cat handle_create.dat

AUTHENTICATE PUBKEY:300:0.NA/XXXXX
/usr/local/hs/svr_1/admpriv.bin|passphrase

CREATE XXXXX/hdl1
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://www.library.yale.edu/NotaBene/nbxi3/erasmus.htm
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl2
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://www.library.yale.edu/NotaBene/nbxi3/preserva.htm
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl3
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl4
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Beineckelogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl5
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Divinitylogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl6
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Ecollectionslogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl7
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Geologylogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl8
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/LewisWalpolelogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl9
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/MSSAlogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/hdl10
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://mssaserver03/madid
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/NoteBene/hdl1
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://www.library.yale.edu/NotaBene/nbxi3/erasmus.htm
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/NoteBene/hdl2
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://www.library.yale.edu/NotaBene/nbxi3/preserva.htm
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs/Beinecke
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Beineckelogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs/Divinity
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Divinitylogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs/Ecollections
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Ecollectionslogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/logs/Geology
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/Geologylogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs/LewisWalpole
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/LewisWalpolelogs
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu

CREATE XXXXX/lib/RR/logs/MSSA
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX                                                               
1000 URL 86400 1110 UTF8 http://gemini1/RR_logfiles/MSSAlogs                                                             
1001 EMAIL 8600 1110 UTF8 Steve.DiSorbo@yale.edu            

CREATE XXXXX/lib/mssa/hdl10
100 HS_ADMIN 86400 1110 ADMIN 300:111111111111:0.NA/XXXXX
1000 URL 86400 1110 UTF8 http://mssaserver03/madid
1001 EMAIL 86400 1110 UTF8 Steve.DiSorbo@yale.edu


The log file:
$ cat handle_create.log
Start Time: Thu Mar 15 11:38:43 EDT 2007
==>SUCCESS[8]: create:XXXXX/hdl1
==>SUCCESS[13]: create:XXXXX/hdl2
==>SUCCESS[18]: create:XXXXX/hdl3
==>SUCCESS[23]: create:XXXXX/hdl4
==>SUCCESS[28]: create:XXXXX/hdl5
==>SUCCESS[33]: create:XXXXX/hdl6
==>SUCCESS[38]: create:XXXXX/hdl7
==>SUCCESS[43]: create:XXXXX/hdl8
==>SUCCESS[48]: create:XXXXX/hdl9
==>SUCCESS[53]: create:XXXXX/hdl10
==>SUCCESS[58]: create:XXXXX/lib/NoteBene/hdl1
==>SUCCESS[63]: create:XXXXX/lib/NoteBene/hdl2
==>SUCCESS[68]: create:XXXXX/lib/RR/logs
==>SUCCESS[73]: create:XXXXX/lib/RR/logs/Beinecke
==>SUCCESS[78]: create:XXXXX/lib/RR/logs/Divinity
==>SUCCESS[83]: create:XXXXX/lib/RR/logs/Ecollections
==>SUCCESS[88]: create:XXXXX/lib/logs/Geology
==>SUCCESS[93]: create:XXXXX/lib/RR/logs/LewisWalpole
==>SUCCESS[98]: create:XXXXX/lib/RR/logs/MSSA
==>SUCCESS[102]: create:XXXXX/lib/mssa/hdl10
Successes/Total Entries: 20/20
Batch File Lines: 102
Finish Time: Thu Mar 15 11:38:46 EDT 2007
This batch took 2 seconds to complete at an average speed of 6.985679357317499 operations/second


Steve wrote:
I was not using the Xmx1000m java parameter.  I did add the parameter, but the same results are experienced.

the command I am using to start the server is ... java -Xmx1000m net.handle.server.Main /usr/local/hs/svr_1

Sean Reilly wrote:
What is the command-line you are using to start the server?  It is likely that due to using MySQL you may need to give the java process more memory using the -Xmx1000m java parameter.

On Mar 12, 2007, at 9:14 PM, Steve wrote:

just stdout when running the server

Sean Reilly wrote:

On Mar 12, 2007, at 6:16 PM, Steve wrote:
...
*Console logs*

   received HDL-TCP response: version=2.1; oc=105; rc=1; snId=0 caCrt cont'd noAuth
   received HDL-TCP response: version=2.1; oc=105; rc=1; snId=0 caCrt cont'd noAuth
   received HDL-TCP response: version=2.1; oc=105; rc=1; snId=0 caCrt cont'd noAuth
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space

Hi Steve,

In what software is this console located?  Is this the one from the handle admin tool, a custom application, or just stdout when running the server?

Thanks,
Sean




--Steve DiSorbo
System Programmer
Yale University ITS, AM&T Library Systems
Voice (203) 432-6694
Fax   (203) 436-4067
steve.disorbo@yale.edu
http://www.library.yale.edu/


_______________________________________________
Handle-Info mailing list
Handle-Info@cnri.reston.va.us
http://www.handle.net/mailman/listinfo/handle-info 




-- 
Steve DiSorbo
System Programmer
Yale University ITS, AM&T Library Systems
Voice (203) 432-6694
Fax   (203) 436-4067
steve.disorbo@yale.edu
http://www.library.yale.edu/