Re: [Handle-info] From jdb to mysql

[Steve <Steve.DiSorbo@yale.edu>]

Quick and Dirty you say ... always get caught by the dirty.

I have an error, not sure it related to the quick & dirty or something else.

The handle server log files fill the filesystem ...

"2007/03/12 02:09:26 EDT" 25 Started new run.
Saving global values to: /home/handle/.handle/root_info
"2007/03/12 02:09:30 EDT" 50 unspecified max_handlers count, using default: 200
"2007/03/12 02:09:30 EDT" 50 unspecified max_handlers count, using default: 200
"2007/03/12 02:09:30 EDT" 50 unspecified max_handlers count, using default: 200
"2007/03/12 02:10:10 EDT" 50 class net.handle.server.HdlTcpRequestHandler: Exception sending response: java.net.SocketException: Connection reset
"2007/03/12 02:10:10 EDT" 50 class net.handle.server.HdlTcpRequestHandler: Exception sending response: java.net.SocketException: Broken pipe
"2007/03/12 02:10:10 EDT" 50 class net.handle.server.HdlTcpRequestHandler: Exception sending response: java.net.SocketException: Broken pipe


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

mysql tables ...

mysql> show tables;
+------------------+
| Tables_in_handle |
+------------------+
| handles          |
| nas              |
+------------------+
2 rows in set (0.00 sec)

mysql> desc handles;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| handle      | varchar(255) | NO   | PRI |         |       |
| idx         | int(11)      | NO   | PRI |         |       |
| type        | blob         | YES  |     | NULL    |       |
| data        | blob         | YES  |     | NULL    |       |
| ttl_type    | smallint(6)  | YES  |     | NULL    |       |
| ttl         | int(11)      | YES  |     | NULL    |       |
| timestamp   | int(11)      | YES  |     | NULL    |       |
| refs        | blob         | YES  |     | NULL    |       |
| admin_read  | tinyint(1)   | YES  |     | NULL    |       |
| admin_write | tinyint(1)   | YES  |     | NULL    |       |
| pub_read    | tinyint(1)   | YES  |     | NULL    |       |
| pub_write   | tinyint(1)   | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
12 rows in set (0.01 sec)

mysql>



Eric Auer wrote:

Hi Steve,

I just reconfigured our handle server to use mysql rather than jdb. I
try to use it and the the following error ... SERVER NOT RESPONSIBLE FOR HANDLE: That naming authority doesn't live here

A quick and dirty solution would be something like:

INSERT INTO nas VALUES ( '0.NA/YOURPREFIX' );

There also is some way which uses one of the apps in the Handle System
jar files to do the same. One example would be using the admin tool
net.handle.apps.gui.hadmin.HandleTool ...

Eric


_______________________________________________
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/