Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-2136

ORA-01461: can bind a LONG value only for insert into a LONG column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Cannot Reproduce
    • 1.5
    • None
    • jackrabbit-core
    • None
    • OS: Window XP
      OS default character set: 936 (ANSI/OEM- simplified Chinese GBK)

      Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
      Database default character set: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

    Description

      This issue happens occasionally. Not only happened at node.lock(false, true) but also at other APIs like node.save(), node.checkin, etc...

      009-06-10 18:23:23,715 ERROR [org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager] could not execute statement, reason: ORA-01461: can bind a LONG value only for insert into a LONG column
      , state/code: 72000/1461
      2009-06-10 18:23:23,715 DEBUG [org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager] dump:
      java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)
      at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1197)
      at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:701)
      at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:641)
      at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:524)
      at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:712)
      at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1084)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:337)
      at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:340)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:312)
      at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:313)
      at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1105)
      at org.apache.jackrabbit.core.NodeImpl.lock(NodeImpl.java:4464)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.acquireLock(JcrInternalLocked.java:60)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.with(JcrInternalLocked.java:26)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLockedObjectUtil.checkout(JcrLockedObjectUtil.java:422)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLeaveNodeImpl.checkout(JcrLeaveNodeImpl.java:94)
      at com.vitria.modeling.repository.sapi.service.core.CoreModel.checkout(CoreModel.java:145)
      at com.vitria.modeling.repository.sapi.service.proxy.local.LocalModel.checkout(LocalModel.java:67)
      at com.vitria.m3oui.model.impl.ReposModelMgrImpl.editModel(ReposModelMgrImpl.java:2386)
      at com.vitria.m3oui.model.ModelLib.editModel(ModelLib.java:2641)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:406)
      at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
      at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1417)
      at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:878)
      at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
      at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
      at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:49)
      at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
      at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
      at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:274)
      at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:377)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at com.vitria.flex.fds.FlexOSGiMessageBrokerServlet.service(FlexOSGiMessageBrokerServlet.java:55)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
      at flex.messaging.security.TomcatValve.invoke(TomcatValve.java:143)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Thread.java:595)
      2009-06-10 18:23:23,718 ERROR [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] failed to write bundle: 4e945609-9a39-4c38-b0f4-deaa78e429af
      java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)
      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)
      at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1197)
      at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:701)
      at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:641)
      at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:524)
      at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:712)
      at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1084)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:337)
      at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:340)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:312)
      at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:313)
      at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1105)
      at org.apache.jackrabbit.core.NodeImpl.lock(NodeImpl.java:4464)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.acquireLock(JcrInternalLocked.java:60)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.with(JcrInternalLocked.java:26)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLockedObjectUtil.checkout(JcrLockedObjectUtil.java:422)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLeaveNodeImpl.checkout(JcrLeaveNodeImpl.java:94)
      at com.vitria.modeling.repository.sapi.service.core.CoreModel.checkout(CoreModel.java:145)
      at com.vitria.modeling.repository.sapi.service.proxy.local.LocalModel.checkout(LocalModel.java:67)
      at com.vitria.m3oui.model.impl.ReposModelMgrImpl.editModel(ReposModelMgrImpl.java:2386)
      at com.vitria.m3oui.model.ModelLib.editModel(ModelLib.java:2641)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:406)
      at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
      at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1417)
      at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:878)
      at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
      at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
      at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:49)
      at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
      at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
      at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:274)
      at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:377)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at com.vitria.flex.fds.FlexOSGiMessageBrokerServlet.service(FlexOSGiMessageBrokerServlet.java:55)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
      at flex.messaging.security.TomcatValve.invoke(TomcatValve.java:143)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Thread.java:595)
      2009-06-10 18:23:23,725 ERROR [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] rollback failed
      2009-06-10 18:23:23,725 ERROR [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] Reason: Closed Connection
      2009-06-10 18:23:23,725 ERROR [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] State/Code: null/17008
      2009-06-10 18:23:23,725 DEBUG [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] dump:
      java.sql.SQLException: Closed Connection
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
      at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1170)
      at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:532)
      at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:712)
      at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1084)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:337)
      at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:340)
      at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:312)
      at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:313)
      at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1105)
      at org.apache.jackrabbit.core.NodeImpl.lock(NodeImpl.java:4464)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.acquireLock(JcrInternalLocked.java:60)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrInternalLocked.with(JcrInternalLocked.java:26)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLockedObjectUtil.checkout(JcrLockedObjectUtil.java:422)
      at com.vitria.modeling.repository.sapi.service.jcr.JcrLeaveNodeImpl.checkout(JcrLeaveNodeImpl.java:94)
      at com.vitria.modeling.repository.sapi.service.core.CoreModel.checkout(CoreModel.java:145)
      at com.vitria.modeling.repository.sapi.service.proxy.local.LocalModel.checkout(LocalModel.java:67)
      at com.vitria.m3oui.model.impl.ReposModelMgrImpl.editModel(ReposModelMgrImpl.java:2386)
      at com.vitria.m3oui.model.ModelLib.editModel(ModelLib.java:2641)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:406)
      at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
      at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1417)
      at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:878)
      at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
      at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
      at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:49)
      at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
      at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
      at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:274)
      at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:377)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at com.vitria.flex.fds.FlexOSGiMessageBrokerServlet.service(FlexOSGiMessageBrokerServlet.java:55)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
      at flex.messaging.security.TomcatValve.invoke(TomcatValve.java:143)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Thread.java:595)

      Attachments

        Activity

          People

            Unassigned Unassigned
            eg_tsl Joe Tang
            Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: