Upgrade failed application will not start due to Cannot update schema

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

  1. Cannot successfully upgrade to Confluence 3.5.x

atlassian-confluence.log に次のエラーが返されます。

ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema
com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema
...
Caused by: java.sql.SQLException: Foreign key 'FKBF45A7992CAF22C1' has implicit reference to object 'CONTENT' which does not have a primary key defined on it.

診断

Check the database to ensure that tables have primary keys defined on them.

原因

None available at this time.

ソリューション

  1. The primary keys need to be added back into Confluence. This is most easily done with a database GUI, or whatever method you are most familiar with.
    1. Here is a list of the tables and the respective primary keys:

      Table NamePrimary key field
      ATTACHMENTDATA ATTACHMENTDATAID
      ATTACHMENTSATTACHMENTID
      BANDANABANDANAID
      BODYCONTENTBODYCONTENTID
      CLUSTERSAFETYCLUSTERSAFETYID
      CONFANCESTORSDESCENDENTID,ANCESTORPOSITION
      CONFVERSIONCONFVERSIONID
      CONTENTCONTENTID
      CONTENT_LABELID
      CONTENT_PERMID
      CONTENT_PERM_SETID
      CONTENTLOCKCONTENTLOCKID
      cwd_app_dir_group_mappingID
      cwd_app_dir_mappingID
      cwd_app_dir_operationapp_dir_mapping_id,operation_type
      cwd_applicationID
      cwd_application_addressapplication_id, remote_address
      cwd_application_attributeapplication_id,attribute_name
      cwd_directoryID
      cwd_directory_attributedirectory_id,attribute_name
      cwd_directory_operationdirectory_id,operation_type
      cwd_groupID
      cwd_group_attributeID
      cwd_membershipID
      cwd_userID
      cwd_user_attributeID
      cwd_user_credential_recordID
      DECORATORDECORATORID
      external_entitiesID
      external_membersextentityid,groupid
      EXTRNLNKSLINKID
      FOLLOW_CONNECTIONSCONNECTIONID
      groupsID
      hibernate_unique_key 
      IMAGEDETAILSATTACHMENTID
      INDEXQUEUEENTRIESENTRYID
      KEYSTOREKEYID
      LABELLABELID
      LINKSLINKID
      local_membersuserid,groupid
      logininfoID
      NOTIFICATIONNOTIFICATIONID
      os_groupID
      OS_PROPERTYENTRYentity_name,entity_id,entity_key
      os_userID
      os_user_groupgroup_id,user_id
      PAGETEMPLATESTEMPLATEID
      PLUGINDATAPLUGINDATAID
      remembermetokenID
      SPACEGROUPPERMISSIONSSPACEGROUPPERMID
      SPACEGROUPSSPACEGROUPID
      SPACEPERMISSIONSPERMID
      SPACESSPACEID
      TRACKBACKLINKSLINKID
      TRUSTEDAPPTRUSTEDAPPID
      TRUSTEDAPPRESTRICTIONTRUSTEDAPPRESTRICTIONID
      usersID

Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.