Opening whitelist page will throw error 500

お困りですか?

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

コミュニティに質問


    

プラットフォームについて: Data Center のみ - この記事は、Data Center プラットフォームのアトラシアン製品にのみ適用されます。

 

要約

Trying to open Confluence Administration >  Whitelist will throw an error 500.

環境

The issue was detected on Confluence 7.4, but it can affect any version.

診断

In the <confluence-home>/logs/atlassian-confluence.log, prior to the 500page.jsp we would see something like this:

2021-09-23 19:46:44,013 ERROR [https-jsse-nio2-8443-exec-27] [[Standalone].[localhost].[/dcifcnfl].[servlet-module-container-servlet]] log Servlet.service() for servlet [servlet-module-container-servlet] in context with path [/dcifcnfl] threw exception
java.util.concurrent.CompletionException: net.java.ao.ActiveObjectsException: Could not find enum value for 'class com.atlassian.plugins.whitelist.WhitelistType' corresponding to database value '?]v(-oJeRl"bhSVUz-.82*Tr?E, DC7B':nCH.'lAw<h99j_rUo)-c+mCl|b\gnr2(bwyXw(kx('4"?p*zo[8z@bK:v[le^#p9~W]E,%=4yJcj4U>PwV43X#zz$/5WEV\jKSpN>B7^D\);+'0IWK3-mnOu(1VN!,%*#viP+B`ar1ap(ghsq4[@QE'db]t;@>00$%"vj3p:,QUttVTV<A^<Zav=#;3}aTQTIoy{A8Y+^j3;S^IaDo-fm@WE6h)+'
	at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(Unknown Source)
...
Caused by: net.java.ao.ActiveObjectsException: Could not find enum value for 'class com.atlassian.plugins.whitelist.WhitelistType' corresponding to database value '?]v(-oJeRl"bhSVUz-.82*Tr?E, DC7B':nCH.'lAw<h99j_rUo)-c+mCl|b\gnr2(bwyXw(kx('4"?p*zo[8z@bK:v[le^#p9~W]E,%=4yJcj4U>PwV43X#zz$/5WEV\jKSpN>B7^D\);+'0IWK3-mnOu(1VN!,%*#viP+B`ar1ap(ghsq4[@QE'db]t;@>00$%"vj3p:,QUttVTV<A^<Zav=#;3}aTQTIoy{A8Y+^j3;S^IaDo-fm@WE6h)+'
	at net.java.ao.types.EnumType.pullFromDatabase(EnumType.java:36)
...


Running select on the database table AO_21D670_WHITELIST_RULES will show broken records like this:

select * from AO_21D670_WHITELIST_RULES;


原因

At the moment, it is still unclear how these records are created.

ソリューション

Stop the Confluence, create the backup of the DB, and then remove affected rows, in this case:

DELETE FROM AO_21D670_WHITELIST_RULES WHERE ID IN (6,7,8,9);



最終更新日: 2021 年 10 月 6 日

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

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