[
https://issues.apache.org/jira/browse/JCR-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537029
]
Alan Cabrera commented on JCR-1165:
-----------------------------------
I am concerned by this comment. I do not think that 100k nodes is not all that
much and think that this "small" limit is artificial.
> 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.
