症状

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:

      テーブル名	Primary key field
      ATTACHMENTDATA	ATTACHMENTDATAID
      添付ファイル	ATTACHMENTID
      bandana	BANDANAID
      BODYCONTENT	BODYCONTENTID
      clustersafety	CLUSTERSAFETYID
      CONFANCESTORS	DESCENDENTID,ANCESTORPOSITION
      confversion	CONFVERSIONID
      CONTENT	CONTENTID
      CONTENT_LABEL	ID
      CONTENT_PERM	ID
      CONTENT_PERM_SET	ID
      CONTENTLOCK	CONTENTLOCKID
      cwd_app_dir_group_mapping	ID
      cwd_app_dir_mapping	ID
      cwd_app_dir_operation	app_dir_mapping_id,operation_type
      cwd_application	ID
      cwd_application_address	application_id, remote_address
      cwd_application_attribute	application_id,attribute_name
      cwd_directory	ID
      cwd_directory_attribute	directory_id,attribute_name
      cwd_directory_operation	directory_id,operation_type
      cwd_group	ID
      cwd_group_attribute	ID
      cwd_membership	ID
      cwd_user	ID
      cwd_user_attribute	ID
      cwd_user_credential_record	ID
      decorator	DECORATORID
      external_entities	ID
      external_members	extentityid,groupid
      EXTRNLNKS	LINKID
      FOLLOW_CONNECTIONS	CONNECTIONID
      groups	ID
      hibernate_unique_key
      IMAGEDETAILS	ATTACHMENTID
      indexqueueentries	ENTRYID
      KEYSTORE	KEYID
      LABEL	LABELID
      LINKS	LINKID
      local_members	userid,groupid
      LOGININFO	ID
      通知	Notification ID
      os_group	ID
      os_propertyentry	entity_name,entity_id,entity_key
      os_user	ID
      os_user_group	group_id,user_id
      PAGETEMPLATES	TEMPLATEID
      plugindata	PLUGINDATAID
      remembermetoken	ID
      spacegrouppermissions	SPACEGROUPPERMID
      spacegroups	spacegroupid
      SPACEPERMISSIONS	PERMID
      SPACES	SPACEID
      TRACKBACKLINKS	LINKID
      TRUSTEDAPP	TRUSTEDAPPID
      TRUSTEDAPPRESTRICTION	TRUSTEDAPPRESTRICTIONID
      users	ID