jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jukka Zitting (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JCR-1165) Got a db error while saving the node values
Date Tue, 23 Oct 2007 15:07:50 GMT

    [ 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.


Mime
View raw message