Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-87

Setup wizard fails on MySQL 5 - Could not execute JDBC batch update

    XMLWordPrintable

Details

    • Bug
    • Resolution: Answered
    • Medium
    • None
    • None
    • Installation/Setup
    • None

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              65037adbeda8 Damon Rand
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: