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

Confluence upgrade failed due to database case sensitivity

XMLWordPrintable

      Summary

      Occasionally upgrade will fail for some customers due to case sensitivity.

      For example:

      2009-09-23 10:57:35,759 ERROR [Main Thread] [confluence.upgrade.upgradetask.ResizeProfileImagesUpgradeTask] doUpgrade SQL error occured whilst performing ResizeProfileImagesUpgradeTask
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databaseName.OS_USER' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

      In reality the table OS_USER actually exists in lower case.

      The upgrade fail because the query to be executed is (see line 57 of confluence.upgrade.upgradetask.ResizeProfileImagesUpgradeTask for Confluence 3.0.1):

      57.   ResultSet rs = statement.executeQuery("select OS_USER.USERNAME, OS_PROPERTYENTRY.STRING_VAL from OS_USER, OS_PROPERTYENTRY where OS_USER.ID = OS_PROPERTYENTRY.ENTITY_ID and OS_PROPERTYENTRY.ENTITY_KEY = '" + UserPreferencesKeys.PROPERTY_USER_PROFILE_PICTURE + "'");

      The upgrade task in this case (and other cases involving schema update) need to be smart enough to identify what database casing is used so the upgrade can proceed smoothly.

        1. ResizeProfileImagesUpgradeTask-2.2.9.class
          6 kB

            [CONFSERVER-17039] Confluence upgrade failed due to database case sensitivity

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2897330 ] New: CONFSERVER Bug Workflow v4 [ 2991436 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2789057 ] New: JAC Bug Workflow v3 [ 2897330 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2719443 ] New: JAC Bug Workflow v2 [ 2789057 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388277 ] New: JAC Bug Workflow [ 2719443 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2264868 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388277 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2208410 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2264868 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2190087 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2208410 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1922078 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2190087 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1725592 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1922078 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1677917 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1725592 ]

              bnguyen Brian Nguyen (Inactive)
              rhartono Roy Hartono [Atlassian]
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: