Database Schema Warnings Related to 'mismatched definitions' Appear in the Log

お困りですか?

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

コミュニティに質問

症状

atlassian-confluence.log に次のメッセージが表示される。

Column [follower] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.follower varchar(255) nullable] and actual [Column follow_connections.follower varchar(255) non-nullable]
Column [followee] of table [follow_connections] has mismatched definitions for expected [Column follow_connections.followee varchar(255) nullable] and actual [Column follow_connections.followee varchar(255) non-nullable]
Index [sp_comp_idx] of table [spacepermissions] has mismatched definitions for expected [Index spacepermissions.sp_comp_idx on [permtype, permgroupname] non-unique] and actual [Index spacepermissions.sp_comp_idx on [permtype, permgroupname, permusername] non-unique]

原因

These warnings indicate that there is a discrepancy between Hibernate's expectation of the database schema, and the actual schema. This could be related to columns, data types, indexes etc.

ソリューション

In some cases, you may have elected to make these changes to the schema knowingly. If that is the case and you are confident they are not introducing any unexpected behaviour, they are fine to ignore.

However, schema requirements can change over time, or database misconfiguration can mean that changes are not applied correctly. If you're not aware of the reason for the discrepancy, it's best to fix it.

To resolve the issue, speak with your database administrator, as they should be able to make the required changes. It is also worth asking them to look into the Database Setup documents for your database system and ensure that the database is configured as recommended.

If you or your database administrator would like more information about your schema mismatches, please feel free to contact Support.

Last modified on Mar 30, 2016

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

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