Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-30995

Upgrade from 5.1.3 to 5.2.5 Fails Because user_mapping Table is Not Created

    XMLWordPrintable

Details

    • Bug
    • Resolution: Support Request
    • Medium
    • None
    • 5.2.5
    • None

    Description

      This past weekend I attempted to upgrade from 5.1.3 to 5.2.5. This upgrade failed when it failed to find a table name user_mapping table.

      2013-09-28 16:00:33,300 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist
      2013-09-28 16:00:33,303 ERROR [TP-Processor3] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.user_mapping' doesn't exist
      2013-09-28 16:00:33,307 ERROR [TP-Processor3] [[Catalina].[localhost].[/confluence].[noop]] log Servlet.service() for servlet noop threw exception
      org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist
              at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
              at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
              at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
              at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
              at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
              at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
              at com.atlassian.confluence.user.persistence.dao.hibernate.HibernateConfluenceUserDao.findByUsername(HibernateConfluenceUserDao.java:79)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      

      After a lot of banging my head on my desk I instead attempted to upgrade to 5.2.3 which succeeded.

      I infer from this that the 5.2.5 upgrade is missing the logic to create this necessary table, or that you can't upgrade to 5.2.5 directly and have to upgrade to 5.2.3 first. If it's the latter, this should be documented.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              5b5e5f44da5f Andre Bickford
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: