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