jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Tang (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-2136) ORA-01461: can bind a LONG value only for insert into a LONG column
Date Wed, 10 Jun 2009 17:23:07 GMT
ORA-01461: can bind a LONG value only for insert into a LONG column
-------------------------------------------------------------------

                 Key: JCR-2136
                 URL: https://issues.apache.org/jira/browse/JCR-2136
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: jackrabbit-core
    Affects Versions: 1.5.0
         Environment: 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
            Reporter: Joe Tang
            Priority: Critical


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)

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