Misleading yellow banner related to database upgrade displayed after upgrading Fisheye to 4.2.1
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Problem
After upgrading Fisheye to 4.2.1 from a version that requires database upgrade, e.g., from 3.9.1, the following yellow banner is displayed in Fisheye:
⚠️ Update from db version XX to 103 experienced problems. Please review WARN/ERROR logs in /path/to/var/log/atlassian-fisheye-upgrade-db-XX-103.log
Where XX is the original database version, which varies according to the instance version, and /path/to is the full path of the directory into which Fisheye stores data, known as FISHEYE_INSTenvironment variable.
The /path/to/var/log/atlassian-fisheye-upgrade-db-XX-103.log file does contain some warnings like this:
1
2
3
2016-11-18 00:07:43,500 INFO [main ] MigrateUsersToCwdUsers-perform - Processing user 162. username=theusername;displayName=TheDisplayName;email=theusername@company.com;authType=LDAP;enabled=true;crucible=true
2016-11-18 00:07:43,502 WARN [main ] MigrateUsersToCwdUsers-perform - The user theusername had a non empty password for LDAP authentication. The password will not be migrated.
2016-11-18 00:07:43,519 DEBUG [main ] MigrateUsersToCwdUsers-perform - Migrating user theusername to cwd_usersAlso, the file /path/to/var/log/atlassian-fisheye-upgrade-db-XX-103.log ends with:
1
2016-11-18 00:08:24,244 INFO [main ] BumpDbVersionUpgradeTask-bumpVersionNumberUp - Database upgrade from version 102 is successfulNote: The log file does not mention version 103 at all, and there is no such upgrade script #103 in <FishEye Installation Directory>/4.2.1/sql/<DB_TYPE>/upgrade.
Cause
The yellow banner gets displayed if there are WARN or ERROR log messages in the upgrade. These messages mean that the user theusername had a password in the database which got there at some point in the past, but since LDAP is being used, the password is not stored in the database and instead it is delegated to LDAP to check authentication.
Also, regarding the absence of the upgrade script #103, it really doesn't exist. The upgrade #103 is just Java-based, not involving database changes.
Resolution
These specific
WARNmessages are harmless and no action is required, meaning that in this case the yellow banner can be ignored.However, there might be
WARNmessages related to other things that need to be investigated further, meaning that the yellow banner should not be ignored.
Was this helpful?