com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update

Atlassian JIRA | Damon Rand | 10 years ago
  1. 0

    Exception is attached. 12:52:41,593 DEBUG crowd.console.action.setup.DefaultAdministrator: Could not execute JDBC batch update; nested exception is: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update java.rmi.RemoteException: Could not execute JDBC batch update; nested exception is: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update at com.atlassian.crowd.integration.directory.internal.InternalDirectory.addGroup(InternalDirectory.java:110) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.addGroup(DirectoryManagerGeneric.java:140) at com.atlassian.crowd.console.action.setup.DefaultAdministrator.doUpdate(DefaultAdministrator.java:64) 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 webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415) at webwork.action.ActionSupport.execute(ActionSupport.java:144) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:174) 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 com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.console.filter.SetupFilter.doFilter(SetupFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.util.persistence.hibernate.SessionManagerFilter.doFilter(SessionManagerFilter.java:62) 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.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) Caused by: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update at com.atlassian.crowd.util.persistence.hibernate.HibernateDAO.save(HibernateDAO.java:30) at com.atlassian.crowd.model.group.GroupDAOHibernate.add(GroupDAOHibernate.java:25) at com.atlassian.crowd.integration.directory.internal.InternalDirectory.addGroup(InternalDirectory.java:107) ... 35 more Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985) at com.atlassian.crowd.util.persistence.hibernate.HibernateDAO.save(HibernateDAO.java:26) ... 37 more Caused by: java.sql.BatchUpdateException: Table 'crowddb.remotegroupmembers' doesn't exist at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:896) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) ... 43 more

    Atlassian JIRA | 10 years ago | Damon Rand
    com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update
  2. 0

    Exception is attached. 12:52:41,593 DEBUG crowd.console.action.setup.DefaultAdministrator: Could not execute JDBC batch update; nested exception is: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update java.rmi.RemoteException: Could not execute JDBC batch update; nested exception is: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update at com.atlassian.crowd.integration.directory.internal.InternalDirectory.addGroup(InternalDirectory.java:110) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.addGroup(DirectoryManagerGeneric.java:140) at com.atlassian.crowd.console.action.setup.DefaultAdministrator.doUpdate(DefaultAdministrator.java:64) 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 webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415) at webwork.action.ActionSupport.execute(ActionSupport.java:144) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:174) 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 com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.console.filter.SetupFilter.doFilter(SetupFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.util.persistence.hibernate.SessionManagerFilter.doFilter(SessionManagerFilter.java:62) 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.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) Caused by: com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update at com.atlassian.crowd.util.persistence.hibernate.HibernateDAO.save(HibernateDAO.java:30) at com.atlassian.crowd.model.group.GroupDAOHibernate.add(GroupDAOHibernate.java:25) at com.atlassian.crowd.integration.directory.internal.InternalDirectory.addGroup(InternalDirectory.java:107) ... 35 more Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985) at com.atlassian.crowd.util.persistence.hibernate.HibernateDAO.save(HibernateDAO.java:26) ... 37 more Caused by: java.sql.BatchUpdateException: Table 'crowddb.remotegroupmembers' doesn't exist at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:896) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) ... 43 more

    Atlassian JIRA | 10 years ago | Damon Rand
    com.atlassian.crowd.util.persistence.PersistenceException: Could not execute JDBC batch update
  3. 0

    Expression in h:selectOneMenu value causes write instead of read?

    Stack Overflow | 5 years ago | Kawu
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java jpa ManyToOne cascade remove not working as expected

    Stack Overflow | 3 years ago | mad_programmer
    org.hibernate.exception.DataException: Could not execute JDBC batch update
  6. 0

    [EHO-103] Changing first day of week to Monday causes Internal Error - eHour JIRA

    ehour.nl | 1 year ago
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

  1. linxiaolong 36 times, last 6 days ago
  2. linxiaolong 4 times, last 4 months ago
  3. mortalman7 32 times, last 5 months ago
9 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    Table 'crowddb.remotegroupmembers' doesn't exist

    at com.mysql.jdbc.PreparedStatement.executeBatch()
  2. MySQL jdbc
    PreparedStatement.executeBatch
    1. com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:896)
    1 frame
  3. org.apache.tomcat
    DelegatingStatement.executeBatch
    1. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
    1 frame
  4. Hibernate
    ActionQueue.executeActions
    1. org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
    2. org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
    3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
    4. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143)
    4 frames
  5. Hibernate
    SessionImpl.flush
    1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
    2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
    3 frames
  6. com.atlassian.crowd
    DefaultAdministrator.doUpdate
    1. com.atlassian.crowd.util.persistence.hibernate.HibernateDAO.save(HibernateDAO.java:26)
    2. com.atlassian.crowd.model.group.GroupDAOHibernate.add(GroupDAOHibernate.java:25)
    3. com.atlassian.crowd.integration.directory.internal.InternalDirectory.addGroup(InternalDirectory.java:107)
    4. com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.addGroup(DirectoryManagerGeneric.java:140)
    5. com.atlassian.crowd.console.action.setup.DefaultAdministrator.doUpdate(DefaultAdministrator.java:64)
    5 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:585)
    4 frames
  8. webwork.action
    ActionSupport.execute
    1. webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415)
    2. webwork.action.ActionSupport.execute(ActionSupport.java:144)
    2 frames
  9. webwork.dispatcher
    ServletDispatcher.service
    1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
    2. webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:174)
    2 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    1 frame
  11. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  12. Sitemesh
    PageFilter.doFilter
    1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
    2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
    2 frames
  13. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  14. com.atlassian.crowd
    SetupFilter.doFilter
    1. com.atlassian.crowd.console.filter.SetupFilter.doFilter(SetupFilter.java:57)
    1 frame
  15. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  16. com.atlassian.crowd
    SessionManagerFilter.doFilter
    1. com.atlassian.crowd.util.persistence.hibernate.SessionManagerFilter.doFilter(SessionManagerFilter.java:62)
    1 frame
  17. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    8 frames
  18. Grizzly HTTP
    LeaderFollowerWorkerThread.runIt
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
    2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
    3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    4 frames
  19. Tomcat Util
    ThreadPool$ControlRunnable.run
    1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    1 frame
  20. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame