[Dspace-tech] Handle server limit (99999 items?)

[Alan Orth]

Hi,

I'm wondering what happens when the handle server reaches item number 99999? Our handle server is currently at 65000 or so, so this could be a problem for us in the next year or less.

Thanks,

--

Alan Orth
alan...@gmail.com
https://alaninkenya.org
https://mjanja.ch
"In heaven all the interesting people are missing." -Friedrich Nietzsche

GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0

[Hilton Gibson]

Hi Alan

Check: https://www.repository.cam.ac.uk/browse?type=title

They are up to 195598 so far, so 999999 seems to be the limit.

One million is not bad?

How is Kenya?

Cheers

hg

Hilton Gibson

Ubuntu Linux Systems Administrator

Stellenbosch University Library

http://staff.lib.sun.ac.za/~hgibson/docs/cv/cv.html

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
DSpace-tech mailing list
DSpac...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[Alan Orth]

Thanks for pointing out the Cambridge example, Hilton! So they passed the event horizon (and lived to tell the tale) before we had to. *phew*

Kenya's great. The GNU/Linux community[0] is getting stronger by the day! :P

Regards,

[0] https://nairobilug.or.ke/

[Mark H. Wood]

I think 2147483647 or 9223372036854775807 is much more likely as the
limit.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

[Mark H. Wood]

On Thu, May 07, 2015 at 08:35:22AM -0400, Mark H. Wood wrote:
> I think 2147483647 or 9223372036854775807 is much more likely as the
> limit.

The suffix is generated by a DBMS SEQUENCE object. In PostgreSQL,
handle_seq.max_value is the latter of the above. (2**63 - 1: the
limit of an SQL BIGINT, or java.lang.Long.MAX_VALUE.)

However, HandleManager.createHandle(Context, DSpaceObject) uses
TableRow.getIntColumn to retrieve it, and this will throw
IllegalArgumentException when the value exceeds the former of the
above (2**31 - 1: java.lang.Integer.MAX_VALUE).

We should fix that.

[Hilton Gibson]

On 7 May 2015 at 15:31, Mark H. Wood <mw...@iupui.edu> wrote:

We should fix that.

​Agreed +1​

[Peter Dietz]

I thought handle (hdl.handle.net) itself was capable of string. So. If DSpace were to mint a handle like 123456789/12345-theory-of-relativity, that that would resolve? Even though DSpace is db integer incrementing handles, its not limited to numeric. We could mint uuid/guid, or at time of creation, allow the user to customize the handle? 123456789/dietz-thesis

Also, another potential limitation of DSpace's handle is if you had multiple prefixes. An odd case, but suppose you wanted to have different handle prefixes: 1234.thesis, 1234.publication, and 1234.media. DSpace would auto-integer-increment the suffix. So it wouldn't produce 1234.thesis/1, 1234.publication/1, 1234.media/1, but instead 1234.thesis/1, 1234.publication/2, 1234.media/3. Again odd case, so likely no one will ever run into it.

________________
Peter Dietz
Longsight
www.longsight.com
pe...@longsight.com
p: 740-599-5005 x809