jackrabbit-dev mailing list archives

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

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

Abhinav commented on JCR-1165:
------------------------------

You can say the heirarchy is pretty flat. There are around 100,000 nodes under a parent and
it will grow further.

Do you think that we have to increase the columns size furhter? Do you think it will affect
the performane in long run?

Regards
Abhinav

> 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