Issue Details (XML | Word | Printable)

Key: CONF-4755
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Critical Critical
Assignee: Unassigned
Reporter: Andrei Lissovski
Votes: 7
Watchers: 4
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Confluence

DataIntegrityViolationException on MySQL 5.0 during Confluence configuration at the admin account creation step

Created: 26/Nov/05 12:39 AM   Updated: 20/Sep/07 10:30 PM
Component/s: Database / Hibernate
Affects Version/s: 2.0
Fix Version/s: 2.6.0

Time Tracking:
Not Specified

Environment: MySQL 5.0, Tomcat 4.1, JDK 1.4.2_07, Windows XP SP2
Issue Links:
Blocker
 

Participants: Andrei Lissovski, Daniel Ostermeier, Paul Curren [Atlassian], Per Fragemann [Atlassian] and Tom Davies [Atlassian]
Since last comment: 1 year, 10 weeks, 2 days ago
Resolution Date: 20/Sep/07 10:30 PM
Labels:


 Description  « Hide
Getting the following error during the configuration wizard step where an admin account is created. See the stack trace below.

Manually changing the database schema so that boolean_val column in os_propertyentry table is of type bit(8) fixes the problem. Guessing that Hibernate 2.1.6 (version used in Confluence 2.0) does not speak the MySQL 5.0 dialect very well. This will probably fix itself once a more recent version of Hibernate is used. Filing a bug anyway so that this can be tracked.

org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Data too long for column 'boolean_val' at row 1
java.sql.BatchUpdateException: Data too long for column 'boolean_val' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1540)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:59)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1811)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1568)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at org.springframework.orm.hibernate.HibernateTemplate$24.doInHibernate(HibernateTemplate.java:461)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:220)
at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:457)
at bucket.user.persistence.dao.hibernate.BucketGroupDAO.findGroupByGroupname(BucketGroupDAO.java:40)
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:324)
at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
at $Proxy2.findGroupByGroupname(Unknown Source)
at com.opensymphony.user.provider.hibernate.HibernateAccessProvider.handles(HibernateAccessProvider.java:72)
at bucket.user.providers.ChainedUserProvider.handles(ChainedUserProvider.java:125)
at bucket.user.providers.CachingAccessProvider.handles(CachingAccessProvider.java:52)
at com.opensymphony.user.UserManager.getProvider(UserManager.java:312)
at com.opensymphony.user.UserManager.access$100(UserManager.java:34)
at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392)
at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100)
at com.opensymphony.user.Group.(Group.java:36)
at com.opensymphony.user.UserManager.buildEntity(UserManager.java:341)
at com.opensymphony.user.UserManager.createEntity(UserManager.java:373)
at com.opensymphony.user.UserManager.createGroup(UserManager.java:230)
at bucket.user.DefaultUserAccessor.addGroup(DefaultUserAccessor.java:91)
at com.atlassian.confluence.user.DefaultUserAccessor.addGroup(DefaultUserAccessor.java:97)
at bucket.user.DefaultUserAccessor.getGroupCreateIfNecessary(DefaultUserAccessor.java:196)
at bucket.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:35)
at com.atlassian.confluence.user.DefaultUserAccessor.addUser(DefaultUserAccessor.java:85)
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:324)
at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116)
at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
at $Proxy9.addUser(Unknown Source)
at com.atlassian.confluence.setup.actions.SetupAdministrator.createAdmin(SetupAdministrator.java:75)
at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:39)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
at com.atlassian.confluence.setup.actions.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:28)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:69)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:94)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:82)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:90)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:150)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:31)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Referer URL: http://localhost:4742/confluence/setup/setupadministrator-start.action
Build Information:
Confluence Home: D:\Confluence
Uptime: 20 minutes, 13 seconds
Version: 2.0
Build Number: 320
Server Information:
Application Server: Apache Tomcat/4.1.31
Servlet Version: 2.3
Database Dialect: bucket.dialect.MySQLDialect
Memory Information:
Total Memory: 63 MB
Free Memory: 6 MB
Used Memory: 57 MB
System Information:
System Date: Monday, 21 Nov 2005
System Time: 23:13:43
System Favourite Colour: Chartreuse
Java Version: 1.4.2_07
Java Vendor: Sun Microsystems Inc.
JVM Version: 1.0
JVM Vendor: Sun Microsystems Inc.
JVM Implementation Version: 1.4.2_07-b05
Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
Java VM: Java HotSpot(TM) Server VM
User Name: SYSTEM
User Timezone: America/Los_Angeles
Operating System: Windows XP 5.1
OS Architecture: x86
Request
Information:
URL: http://localhost:4742/confluence/setup/setupadministrator.action

  • Scheme: http
  • Server: localhost
  • Port: 4742
  • URI: /confluence/500page.jsp
  • - Context Path: /confluence
  • - Servlet Path: /500page.jsp
  • - Path Info: null
  • - Query String: null
    Attributes:
  • javax.servlet.error.servlet_name : action
  • webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@99480a
  • javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Data too long for column 'boolean_val' at row 1
  • javax.servlet.error.message :
  • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
  • _sitemesh_using_stream : false
  • javax.servlet.error.request_uri : /confluence/setup/setupadministrator.action
  • javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Data too long for column 'boolean_val' at row 1
  • javax.servlet.error.status_code : 500
  • _sitemesh_filterapplied : true
  • sessioninview.FILTERED : true
  • com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Daniel Ostermeier added a comment - 27/Nov/05 06:13 PM
Hi Andrei,

Thank you for bringing this to our attention.

Regards,
-Daniel


[ Permlink | « Hide ]
Daniel Ostermeier added a comment - 19/Dec/05 09:30 PM
Other exceptions generated when attempting to deploy on MySQL 5.0:

– 2005-11-29 16:29:00,126 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
2005-11-29 16:29:00,126 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
2005-11-29 16:29:00,129 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
2005-11-29 16:29:00,129 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
2005-11-29 16:29:00,129 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: com.atlassian.confluence.spaces.SpaceDescription#12552
java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

– ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: com.atlassian.confluence.spaces.SpaceDescription#12552
java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

– ERROR [org.quartz.core.JobRunShell] Job DEFAULT.mailPollJob threw an unhandled Exception:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

– ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.mailPollJob threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list']
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)

  • Nested Exception (Underlying Cause) ---------------
    org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
    java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

— I am assuming these os_user, and os_group are ok
005-11-29 16:29:00,192 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table os_user_group (group_id bigint not null, user_id bigint not null, primary key (user_id, group_id))
2005-11-29 16:29:00,193 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Table 'os_user_group' already exists
create table os_user (id bigint not null, username varchar(255) not null unique, passwd varchar(255), primary key (id))
2005-11-29 16:29:00,194 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table os_user (id bigint not null, username varchar(255) not null unique, passwd varchar(255), primary key (id))
2005-11-29 16:29:00,194 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Table 'os_user' already exists
create table CONFANCESTORS (DESCENDENTID bigint not null, ANCESTORID bigint not null, ANCESTORPOSITION integer not null, primary key (DESCENDENTID, ANCESTORPOSITION))
create table os_group (id bigint not null, groupname varchar(255) not null unique, primary key (id))
2005-11-29 16:29:00,197 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table os_group (id bigint not null, groupname varchar(255) not null unique, primary key (id))
2005-11-29 16:29:00,197 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] Table 'os_group' already exists

– INFO [atlassian.confluence.upgrade.HashTaskListKeysUpgradeTask] Starting ...
java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's changes'' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)


[ Permlink | « Hide ]
Paul Curren [Atlassian] added a comment - 28/May/07 11:04 PM
This problem no longer exists in the 2.5 stable branch and therefore not the trunk either.

Tested using mysql 5.0.41 on Mac OS X.

A few of the acceptance tests failed so depending on the reasons for this we may still want to be wary of 'officially' support MySQL 5.

The failing tests are -

  1. BundledPluginsTest.testConfluenceRepository
  2. LanguageAcceptanceTest.testViewLanguagePacks
  3. LanguageAcceptanceTest.testSetLanguageGerman
  4. PagePermissionsAcceptanceTest.testSettingGroupPermissionWithNonAsciiCharacters
  5. SearchAcceptanceTest.testSearchInUnprintablePdf
  6. ThemeChangeAcceptanceTest.testChangeTheme
  7. ThemeChangeAcceptanceTest.testChangeSpaceTheme
  8. ThemeChangeAcceptanceTest.testSetupThemeUponSpaceCreation
  9. UserProfileAcceptanceTest.testSetUserDefaultLanguage
  10. UserProfileAcceptanceTest.testResetUserDefaultLanguage

[ Permlink | « Hide ]
Per Fragemann [Atlassian] added a comment - 20/Sep/07 10:30 PM
Actually, this works now and we have tests that verify the bug does not appear anymore in 2.6, so i changed the resolution from "not a bug" to "fixed", and i am setting the fix version to 2.6


Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators