jackrabbit-dev mailing list archives

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

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


Mime
View raw message