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, 16 Oct 2007 15:23:50 GMT

    [ https://issues.apache.org/jira/browse/JCR-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535267
] 

Jukka Zitting commented on JCR-1165:
------------------------------------

What's your content hierarchy like? If your hierarchy is very flat (i.e. lots of child nodes
per single parent node), then the individual node states stored in the database will grow
large.

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


Mime
View raw message