Content
View differences
Updated by Oliver Günther over 2 years ago
### Summary
I'm running OpenProject 12.5.8 (enterprise edition) on RHEL8 on one server and the PSQL-13-DB on another server (from our database-cluster). After upgrading to the latest OpenProject-Version (which is currently 13.0.3), I run "openproject configure" but this command fails when doing the database-migrations.
### Steps to reproduce
1. Run OpenProject 12.5.8 on RHEL8 and your PSQL13-DB on another server.
2. Upgrade to latest OpenProject-version (currently 13.0.3) via "yum update"
3. Run "openproject configure" afterwards
### What is the buggy behavior?
* Command "openproject configure" fails during the database migration with
```text
-- execute("CREATE EXTENSION IF NOT EXISTS btree_gist; ALTER TABLE journals ADD CONSTRAINT non_overlapping_journals_validity_periods EXCLUDE USING gist (journable_id WITH =, journable_type WITH =, validity_period WITH &&) DEFERRABLE")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedFile: FEHLER: konnte Erweiterungskontrolldatei »/usr/share/pgsql/extension/btree_gist.control« nicht öffnen: Datei oder Verzeichnis nicht gefunden
```
* The mentioned file does not exist because PSQL isn't installed on the openproject-server
* Therefore I installed the package "pg\_auto\_failover\_13" that contained the file "btree\_gist.control"
* But even after copying the file to the location "/usr/share/pgsql/extension/btree\_gist.control" the same error-message when doing "openproject configure" occured.
### What is the expected behavior?
1. DB-migration should work properly.
### Solution for existing installations
Install the `postgresql13-contrib` package on the server that is operating the PostgreSQL database.
### **Logs**
Output from command "openproject configure" is attached, starting with btree-gist-PSQL-command.
### Environment information
_Please check and fill out the following details to help us identify in what versions and distributions of OpenProject the error occurs_
**OpenProject installation type**
* [ ] Hosted cloud edition
* [x] Packaged installation
* RHEL8
* [ ] Docker All-in-one container
* [ ] Docker-compose installation
* [ ] Other (please specify)
**OpenProject version**
_12.5.8 to 13.0.1 / 13.0.3 (same problem with both versions)_
**Browser**
* [ ] Chrome
* [ ] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [x] Other (please specify)
**Language**
_Please specify the browser language and the language of the OpenProject user for which the bug occurred._
I'm running OpenProject 12.5.8 (enterprise edition) on RHEL8 on one server and the PSQL-13-DB on another server (from our database-cluster). After upgrading to the latest OpenProject-Version (which is currently 13.0.3), I run "openproject configure" but this command fails when doing the database-migrations.
### Steps to reproduce
1. Run OpenProject 12.5.8 on RHEL8 and your PSQL13-DB on another server.
2. Upgrade to latest OpenProject-version (currently 13.0.3) via "yum update"
3. Run "openproject configure" afterwards
### What is the buggy behavior?
* Command "openproject configure" fails during the database migration with
```text
-- execute("CREATE EXTENSION IF NOT EXISTS btree_gist; ALTER TABLE journals ADD CONSTRAINT non_overlapping_journals_validity_periods EXCLUDE USING gist (journable_id WITH =, journable_type WITH =, validity_period WITH &&) DEFERRABLE")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedFile: FEHLER: konnte Erweiterungskontrolldatei »/usr/share/pgsql/extension/btree_gist.control« nicht öffnen: Datei oder Verzeichnis nicht gefunden
```
* The mentioned file does not exist because PSQL isn't installed on the openproject-server
* Therefore I installed the package "pg\_auto\_failover\_13" that contained the file "btree\_gist.control"
* But even after copying the file to the location "/usr/share/pgsql/extension/btree\_gist.control" the same error-message when doing "openproject configure" occured.
### What is the expected behavior?
1. DB-migration should work properly.
### Solution for existing installations
Install the `postgresql13-contrib` package on the server that is operating the PostgreSQL database.
### **Logs**
Output from command "openproject configure" is attached, starting with btree-gist-PSQL-command.
### Environment information
_Please check and fill out the following details to help us identify in what versions and distributions of OpenProject the error occurs_
**OpenProject installation type**
* [ ] Hosted cloud edition
* [x] Packaged installation
* RHEL8
* [ ] Docker All-in-one container
* [ ] Docker-compose installation
* [ ] Other (please specify)
**OpenProject version**
_12.5.8 to 13.0.1 / 13.0.3 (same problem with both versions)_
**Browser**
* [ ] Chrome
* [ ] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [x] Other (please specify)
**Language**
_Please specify the browser language and the language of the OpenProject user for which the bug occurred._