java.sql.SQLException: ORA-08177: can't serialize access for this transaction

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • new problem on oracle
    via symmetricds by sunxh
    ,
  • [WG: Sakai QA] Trunk is down
    via by Unknown author,
  • Unable to collect changes
    via by Unknown author,
  • Problem using different schemas
    via symmetricds by jeandamore
    ,
  • Constraints are correctly when creating an object, but updates get a db exception: class Candidate { String name static constraints = { name(unique:true, blank:false) } } CandidateController{ ... def update = { def candidate = Candidate.get( params.id ) if(candidate) { candidate.properties = params println "candidate name is: ${candidate.name}" println "candidate valid is: ${candidate.validate()}" if (candidate.validate()){ if(candidate.save()) { redirect(action:show,id:candidate.id) } else { render(view:'edit',model:[candidate:candidate]) } } else { render(view:'edit',model:[candidate:candidate]) } } else { flash.message = "Candidate not found with id ${params.id}" redirect(action:edit,id:params.id) } } ... } [groovy] candidate name is: [groovy] ORA-01407: cannot update ("ELECTION_OWNER"."CANDIDATE"."NAME") to NULL [groovy] Could not synchronize database state with session [groovy] org.hibernate.exception.GenericJDBCException: could not update: [Candidate#16] [groovy] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) [groovy] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) [groovy] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [groovy] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2222) [groovy] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118) [groovy] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374) [groovy] at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91) [groovy] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) [groovy] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) [groovy] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) [groovy] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) [groovy] at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41) [groovy] at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:954) [groovy] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1526) [groovy] at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) [groovy] at org.codehaus.groovy.grails.orm.hibernate.validation.ConstrainedPersistentProperty$UniqueConstraint$1.doInHibernate(ConstrainedPersistentProperty.java:111) [groovy] at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) [groovy] at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:338) [groovy] at org.codehaus.groovy.grails.orm.hibernate.validation.ConstrainedPersistentProperty$UniqueConstraint.processValidate(ConstrainedPersistentProperty.java:108) [groovy] at org.codehaus.groovy.grails.validation.ConstrainedProperty$AbstractConstraint.validate(ConstrainedProperty.java:251) [groovy] at org.codehaus.groovy.grails.orm.hibernate.validation.ConstrainedPersistentProperty$AbstractPersistentConstraint.validate(ConstrainedPersistentProperty.java:70) [groovy] at org.codehaus.groovy.grails.orm.hibernate.validation.ConstrainedPersistentProperty.validate(ConstrainedPersistentProperty.java:205) [groovy] at org.codehaus.groovy.grails.orm.hibernate.validation.GrailsDomainClassValidator.validate(GrailsDomainClassValidator.java:88) [groovy] at org.codehaus.groovy.grails.orm.hibernate.metaclass.ValidatePersistentMethod.doInvokeInternal(ValidatePersistentMethod.java:74) [groovy] at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractDynamicPersistentMethod.invoke(AbstractDynamicPersistentMethod.java:51) [groovy] at org.codehaus.groovy.grails.commons.metaclass.AbstractDynamicMethods.invokeMethod(AbstractDynamicMethods.java:146) [groovy] at org.codehaus.groovy.grails.commons.metaclass.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:55) [groovy] at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:159) [groovy] at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:104) [groovy] at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethod(ScriptBytecodeAdapter.java:80) [groovy] at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeNoArgumentsMethod(ScriptBytecodeAdapter.java:154) [groovy] at CandidateController$_closure6.doCall(CandidateController:51) [groovy] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [groovy] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [groovy] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [groovy] at java.lang.reflect.Method.invoke(Method.java:585) [groovy] at org.codehaus.groovy.runtime.ReflectionMetaMethod.invoke(ReflectionMetaMethod.java:67) [groovy] at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:655) [groovy] at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:367) [groovy] at org.codehaus.groovy.runtime.Invoker.invokeMethod(Invoker.java:159) [groovy] at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:104) [groovy] at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethod(ScriptBytecodeAdapter.java:80) [groovy] at CandidateController$_closure6.doCall(CandidateController) [groovy] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [groovy] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [groovy] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [groovy] at java.lang.reflect.Method.invoke(Method.java:585) [groovy] at org.codehaus.groovy.runtime.ReflectionMetaMethod.invoke(ReflectionMetaMethod.java:67) [groovy] at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:655) [groovy] at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:367) [groovy] at groovy.lang.Closure.call(Closure.java:175) [groovy] at groovy.lang.Closure.call(Closure.java:170) [groovy] at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleAction(SimpleGrailsControllerHelper.java:375) [groovy] at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:310) [groovy] at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:126) [groovy] at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:79) [groovy] at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44) [groovy] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723) [groovy] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663) [groovy] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394) [groovy] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358) [groovy] at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) [groovy] at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) [groovy] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) [groovy] at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) [groovy] at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) [groovy] at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) [groovy] at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) [groovy] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75) [groovy] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) [groovy] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:137) [groovy] at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) [groovy] at org.codehaus.groovy.grails.web.servlet.filter.GrailsReloadServletFilter.doFilterInternal(GrailsReloadServletFilter.java:229) [groovy] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) [groovy] at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) [groovy] at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) [groovy] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) [groovy] at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) [groovy] at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635) [groovy] at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) [groovy] at org.mortbay.http.HttpServer.service(HttpServer.java:954) [groovy] at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) [groovy] at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) [groovy] at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) [groovy] at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) [groovy] at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) [groovy] at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) [groovy] Caused by: java.sql.SQLException: ORA-01407: cannot update ("ELECTION_OWNER"."CANDIDATE"."NAME") to NULL [groovy] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [groovy] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [groovy] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [groovy] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [groovy] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) [groovy] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) [groovy] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [groovy] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) [groovy] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400) [groovy] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) [groovy] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2208) [groovy] ... 83 more
    via by ron riley,
  • During submit process, after upload file i have this error : java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID" : invalid identifier 2010-07-21 10:03:21,406 ERROR org.dspace.app.webui.servlet.SubmissionController @ Error loading step class'org.dspace.submit.step.UploadStep': java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID" : identificateur non valide 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.executeUpdate(OraclePreparedStatement.java:3454) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1429) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:736) at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490) at org.dspace.content.Bundle.create(Bundle.java:206) at org.dspace.content.Item.createBundle(Item.java:1244) at org.dspace.content.Item.createSingleBitstream(Item.java:1387) at org.dspace.submit.step.UploadStep.processUploadFile(UploadStep.java:505) at org.dspace.submit.step.UploadStep.doProcessing(UploadStep.java:168) at org.dspace.app.webui.submit.JSPStepManager.doStepEnd(JSPStepManager.java:429) at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:284) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408) at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
    via by Vernedal,
    • java.sql.SQLException: ORA-08177: can't serialize access for this transaction at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:252) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:854) at org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.createJobInstance(JdbcJobInstanceDao.java:117) at org.springframework.batch.core.repository.support.SimpleJobRepository.createJobExecution(SimpleJobRepository.java:127) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy0.createJobExecution(Unknown Source) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:102) at org.springframework.batch.core.launch.support.CommandLineJobRunner.start(CommandLineJobRunner.java:207) at org.springframework.batch.core.launch.support.CommandLineJobRunner.main(CommandLineJobRunner.java:254) at FileToTableMain.main(FileToTableMain.java:8) Caused by: java.sql.SQLException: ORA-08177: can't serialize access for this transaction 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:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) ... 20 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    76 more bugmates