Top navigation bar disappears after upgrade
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
After upgrading JIRA, the top navigation bar has disappeared. The issue only happens to few users. For other users, the top bar shows up fine.=
There is nothing strange in the logs.
診断
For the users that do not have the top navigation bar also have a broken avatar in their profile page.
Searching for the default avatar id in the database returns null :
select * from propertystring where id in (select id from propertyentry where property_key like '%avatar.user.default%');
原因
The default user avatar setting is missing in the instance. This is the reason why the avatar for these users is broken. Due to the same reason, the top navigation bar is also missing.
ソリューション
In order to fix the issue we need to insert the default user avatar in the database :
Run this query in the database and note the id:
select id from propertyentry where property_key like '%avatar.user.default%' ;
Run this query and note the id:
select id from avatar where filename like 'Avatar-default%';
Insert the following data in database
insert into propertystring values (<id from step 1>,<id from step 2>);
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。