You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Julian Reschke (JIRA)" <ji...@apache.org> on 2017/12/22 05:04:00 UTC
[jira] [Resolved] (JCR-2136) ORA-01461: can bind a LONG value only
for insert into a LONG column
[ https://issues.apache.org/jira/browse/JCR-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Reschke resolved JCR-2136.
---------------------------------
Resolution: Cannot Reproduce
> 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
> 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 was sent by Atlassian JIRA
(v6.4.14#64029)