-
Bug
-
Resolution: Answered
-
Medium
-
None
-
None
-
None
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
- is related to
-
CWD-147 Table names are too long for MySQL with UTF-8
- Closed
Hi Igor and Mickael,
We have Crowd 1.0.7 working on utf8 with MySQL 5.0.27.. Sorry we don't remember doing anything special to make it work though..
Take a look at
CWD-147and see if that helps you out.Damon.