Hipchat Server fails to upgrade due to mariadb unmet dependencies error
プラットフォームについて: 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 は除く
This is for an outdated version of Hipchat Server
This article applies to a version of Hipchat Server which will be deprecated soon. After that period the version will no longer be supported.
You should upgrade to a more recent version of Hipchat Server as soon as you can to take advantage of new features, and security and bug fixes.
問題
When trying to run an upgrade via 'hipchat upgrade --upgrade', admin encounters the following error from the server terminal:
The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-5.5 (= 5.5.38+maria-1~precise) but 5.5.37+maria-1~precise is to be installed
mariadb-server-core-5.5 : Depends: libmariadbclient18 (>= 5.5.38+maria-1~precise) but 5.5.37+maria-1~precise is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
If you try to upgrade via the server UI, you'll see the above error in /var/log/chef.log
診断
Run the following command from server terminal:
dpkg -l | grep maria | grep ii
The expected output would be:
ii libmariadbclient-dev 10.0.21+maria-1~precise MariaDB database development files
ii libmariadbclient18 10.0.21+maria-1~precise MariaDB database client library
ii libmysqlclient18 10.0.21+maria-1~precise Virtual package to satisfy external depends
ii mariadb-client 10.0.21+maria-1~precise MariaDB database client (metapackage depending on the latest version)
ii mariadb-client-10.0 10.0.21+maria-1~precise MariaDB database client binaries
ii mariadb-client-core-10.0 10.0.21+maria-1~precise MariaDB database core client binaries
ii mariadb-common 5.5.38+maria-1~precise MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-server-10.0 10.0.21+maria-1~precise MariaDB database server binaries
ii mariadb-server-core-10.0 10.0.21+maria-1~precise MariaDB database core server files
ii mysql-common 5.5.38+maria-1~precise MariaDB database common files (e.g. /etc/mysql/my.cnf)
If mariadb version is not on version 5.5.38, you're affected by the issue.
原因
Upgrade process cannot begins due to mariadb (database) dependencies issue. A different version of mariadb was trying to be installed.
ソリューション
- Snapshot the server
SSH into the server and run the following commands
For versions older than 1.3.7:wget https://s3.amazonaws.com/uploads.hipchat.com/10804/81265/RttRfgS6ewFqZsK/mariadbfix.sh chmod +x mariadbfix.sh sudo dont-blame-hipchat ./mariadbfix.sh hipchat upgrade --restart hipchat service --restart
For versions 1.3.7 and newer:
wget https://s3.amazonaws.com/hipchat-server-stable/utils/mariadbfix10.sh chmod +x mariadbfix.sh sudo dont-blame-hipchat ./mariadbfix10.sh hipchat upgrade --restart hipchat service --restart
If there's still an issue, please send in the following logs to Support for further review:
- /var/log/chef.log
- /var/log/hipchat/update.log
- /var/log/hipchat/hup.log
- /var/log/schema_upgrade.log