[
https://issues.apache.org/jira/browse/JCR-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537036
]
Jukka Zitting commented on JCR-1165:
------------------------------------
> I do not think that 100k nodes is not all that much and think that this
> "small" limit is artificial.
Would you put 100k files in a single directory in a typical file system?
The way Jackrabbit handles the node hierarchy is similar to what many file
systems do, including the limitations on the size of a single directory. Note
that you can have such large nodes in Jackrabbit as long as the underlying
persistence engine is able to store them (you need to extend the size of the
node_data column), but Jackrabbit isn't really designed to perform well with
such hierarchies.
Is there a reason why you want to place all the nodes in a single location? How
about splitting them to subnodes based on date or some other property (or even
randomly), and using search to access those nodes that you're interested in?
> Got a db error while saving the node values
> -------------------------------------------
>
> Key: JCR-1165
> URL: https://issues.apache.org/jira/browse/JCR-1165
> Project: Jackrabbit
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 1.0.1
> Environment: Sun Solaris
> Reporter: Abhinav
> Assignee: Jukka Zitting
>
> We are using external blobs to save the values on file system.
> Recently we started getting a db2 error while saving the node values.
> the error is happening becuase the value stored in node_data column of
> T_DMS_NODE (T_DMS_ is prefixed for all DMS tables) table is greated than 1MB.
> We tried increasing the column size to 2 MB and it worked after that.
> I am wondering why more than 1MB space is required if the files are stored
> externally. I think something is going wrong with the way data has been
> stored.
> INFO | jvm 1 | 2007/10/06 13:31:05 | 11845944 [RMI TCP
> Connection(46)-10.88.0.54] ERROR
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager - failed to
> write node state: ab35dd4b-5a7c-4623-a79e-ddd982899a6d
> INFO | jvm 1 | 2007/10/06 13:31:05 | com.ibm.db2.jcc.b.SqlException:
> DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.b.zc.d(zc.java:1351)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.a.db.l(db.java:366)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.a.db.a(db.java:64)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.a.r.a(r.java:48)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.a.tb.c(tb.java:266)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.b.ad.Z(ad.java:1666)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.b.ad.d(ad.java:2224)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.b.ad.V(ad.java:521)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> com.ibm.db2.jcc.b.ad.executeUpdate(ad.java:504)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager.store(SimpleD
> bPersistenceManager.java:585)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.AbstractPersistenceManager.store(AbstractPe
> rsistenceManager.java:75)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager.store(SimpleD
> bPersistenceManager.java:446)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedIte
> mStateManager.java:574)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemSta
> teManager.java:697)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemState
> Manager.java:315)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManage
> r.java:322)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemState
> Manager.java:291)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemS
> tateManager.java:257)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1189)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:805)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> org.apache.jackrabbit.rmi.server.ServerSession.save(ServerSession.java:210)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> java.lang.reflect.Method.invoke(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.rmi.transport.Transport$1.run(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> java.security.AccessController.doPrivileged(Native Method)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.rmi.transport.Transport.serviceCall(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
> INFO | jvm 1 | 2007/10/06 13:31:05 | at java.lang.Thread.run(Unknown
> Source)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
