Content

Support Installation & Updates

errors during upgrading openproject (11.1.0-1608208592.56ea0abf.focal) over (10.6.5-1595314086.1033a295.bionic)

Added by sebastian fontaine over 4 years ago

Here is what I did and the output I got.

the apt-part seemed to work pretty good, but the configure part not anymore

Could you please give me some advise how to solve the problem and get the upgrade done?

Thanks a lot in advance

Sebastian

root@localhost:~# apt-get install --only-upgrade openproject

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following packages were automatically installed and are no longer required:

diffstat g++-7 geoip-database gir1.2-accounts-1.0 gir1.2-gdata-0.0 gir1.2-gtksource-3.0

gir1.2-harfbuzz-0.0 gir1.2-mutter-2 gnome-software-common guile-2.0-libs iputils-arping libapt-pkg-perl

libargon2-0 libart-2.0-2 libavcodec57 libavdevice57 libavfilter6 libavformat57 libavresample3 libavutil55

libb-hooks-op-check-perl libbison-dev libboost-date-time1.65.1 libboost-filesystem1.65.1

libboost-locale1.65.1 libboost-system1.65.1 libboost-thread1.65.1 libcamel-1.2-61 libcapture-tiny-perl

libcdio17 libclass-accessor-perl libclass-method-modifiers-perl libcrystalhd3 libdevel-size-perl

libdigest-bubblebabble-perl libdouble-conversion1 libdynaloader-functions-perl libebook-contacts-1.2-2

libecal-1.2-19 libedataserver-1.2-23 libenchant1c2a libevent-2.1-6 libevent-core-2.1-6

libevent-extra-2.1-6 libexempi3 libexiv2-14 libexporter-tiny-perl libfile-copy-recursive-perl

libfont-ttf-perl libfuture-perl libgdbm5 libgeoip1 libgnome-desktop-3-17 libgraphite2-dev libgspell-1-1

libgtkmm-2.4-1v5 libgtksourceview-3.0-1 libgtksourceview-3.0-common libgutenprint-common libgutenprint2

libgweather-3-15 libharfbuzz-dev libharfbuzz-gobject0 libhttp-parser2.7.1 libhunspell-1.6-0

libicu-le-hb-dev libicu-le-hb0 libiculx60 libilmbase12 libio-pty-perl libio-string-perl libip4tc0

libiptc0 libisl19 libjemalloc1 libjson-maybexs-perl liblist-compare-perl liblist-moreutils-perl

liblvm2app2.2 liblvm2cmd2.02 libminiupnpc10 libmng2 libmozjs-52-0 libmutter-2-0 libmysofa0

libmysqlclient20 libnet-ip-perl libnss-myhostname libntfs-3g88 libnumber-compare-perl liboauth0

libopenexr22 libpanel-applet3 libpath-tiny-perl libperl4-corelibs-perl libperlio-gzip-perl libplymouth4

libpoppler73 libpostproc54 libprotobuf10 libpython2.7 libreadline7 libreadonly-perl libref-util-perl

libref-util-xs-perl libreoffice-avmedia-backend-gstreamer libreoffice-style-galaxy libruby2.5

libsereal-decoder-perl libsignon-glib1 libstdc++-5-dev libstdc++-7-dev libstrictures-perl

libsub-exporter-progressive-perl libsub-identify-perl libsub-quote-perl libswresample2 libswscale4

libtest-fatal-perl libtest-refcount-perl libtext-glob-perl libtext-levenshtein-perl libtiff5-dev

libtinfo-dev libtype-tiny-perl libtype-tiny-xs-perl libunicode-utf8-perl libusbmuxd4

libvariable-magic-perl libvpx5 libwayland-egl1-mesa libx264-152 libx265-146 libxml-namespacesupport-perl

libxml-sax-base-perl libxml-writer-perl libyaml-libyaml-perl linux-headers-4.15.0-126

linux-headers-4.15.0-126-generic linux-image-4.15.0-126-generic linux-modules-4.15.0-126-generic

linux-modules-4.15.0-91-generic linux-modules-extra-4.15.0-126-generic patchutils php7.2-common php7.2-gd

php7.2-mysql php7.2-opcache php7.2-readline php7.2-xml python-talloc python3-asn1crypto

python3-feedparser python3-html5lib python3-lxml python3-oauth python3-webencodings

python3-zope.interface qpdf qtchooser ruby-binding-of-caller ruby-debug-inspector ruby-did-you-mean

ruby-erubis ruby-mime-types ruby-mime-types-data ruby-polyglot ruby-treetop ruby2.5 t1utils

unity-lens-files unity-lens-music unity-scope-calculator unity-scope-devhelp unity-scope-firefoxbookmarks

unity-scope-manpages unity-scope-openclipart unity-scope-texdoc unity-scope-virtualbox unity-scope-yelp

unity-scope-zotero unity-scopes-runner x11proto-input-dev x11proto-kb-dev xbase-clients

Use 'apt autoremove' to remove them.

The following additional packages will be installed:

libevent-core-2.1-7 libevent-extra-2.1-7

The following NEW packages will be installed:

libevent-core-2.1-7 libevent-extra-2.1-7

The following packages will be upgraded:

openproject

1 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.

Need to get 151 MB of archives.

After this operation, 30.8 MB of additional disk space will be used.

Do you want to continue? [Y/n] Y

Get:2 http://us.archive.ubuntu.com/ubuntu focal/main amd64 libevent-core-2.1-7 amd64 2.1.11-stable-1 [89.1 kB]

Get:1 https://dl.packager.io/srv/deb/opf/openproject/stable/11/ubuntu 20.04/main amd64 openproject amd64 11.1.0-1608208592.56ea0abf.focal [151 MB]

Get:3 http://us.archive.ubuntu.com/ubuntu focal/main amd64 libevent-extra-2.1-7 amd64 2.1.11-stable-1 [60.0 kB]

Fetched 151 MB in 5s (33.1 MB/s)

Selecting previously unselected package libevent-core-2.1-7:amd64.

(Reading database ... 301083 files and directories currently installed.)

Preparing to unpack .../libevent-core-2.1-7_2.1.11-stable-1_amd64.deb ...

Unpacking libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...

Selecting previously unselected package libevent-extra-2.1-7:amd64.

Preparing to unpack .../libevent-extra-2.1-7_2.1.11-stable-1_amd64.deb ...

Unpacking libevent-extra-2.1-7:amd64 (2.1.11-stable-1) ...

Preparing to unpack .../openproject_11.1.0-1608208592.56ea0abf.focal_amd64.deb ...

Unpacking openproject (11.1.0-1608208592.56ea0abf.focal) over (10.6.5-1595314086.1033a295.bionic) ...

dpkg: warning: unable to delete old directory '/opt/openproject/public/assets/meeting': Directory not empty

dpkg: warning: unable to delete old directory '/opt/openproject/public/assets/reporting': Directory not empty

dpkg: warning: unable to delete old directory '/opt/openproject/public/assets/backlogs': Directory not empty

dpkg: warning: unable to delete old directory '/opt/openproject/public/assets/bim/ifc_viewer': Directory not empty

Setting up libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...

Setting up libevent-extra-2.1-7:amd64 (2.1.11-stable-1) ...

Setting up openproject (11.1.0-1608208592.56ea0abf.focal) ...

Installing new version of config file /etc/default/openproject ...

==============

The openproject package provides an installer. Please run the following command to finish the installation:

sudo openproject configure

==============

Processing triggers for ureadahead (0.100.0-21) ...

Processing triggers for libc-bin (2.31-0ubuntu9.1) ...

root@localhost:~#

root@localhost:~# openproject configure --trace

Launching installer for openproject...

Selected addons: legacy-installer openproject-edition postgres apache2 repositories smtp memcached openproject

[legacy-installer] ./bin/configure

[openproject-edition] ./bin/configure

DONE

[postgres] ./bin/configure

DONE

[apache2] ./bin/configure

DONE

[repositories] ./bin/configure

No server installed. Skipping.

DONE

[smtp] ./bin/configure

DONE

[memcached] ./bin/configure

DONE

[openproject] ./bin/configure

DONE

[legacy-installer] ./bin/preinstall

[openproject-edition] ./bin/preinstall

[postgres] ./bin/preinstall

INFO: autoinstall=skip. Skipping to next step.

[apache2] ./bin/preinstall

[repositories] ./bin/preinstall

[smtp] ./bin/preinstall

[memcached] ./bin/preinstall

No memcached server to install. Skipping.

[openproject] ./bin/preinstall

[legacy-installer] ./bin/postinstall

[openproject-edition] ./bin/postinstall

[postgres] ./bin/postinstall

[apache2] ./bin/postinstall

[repositories] ./bin/postinstall

[smtp] ./bin/postinstall

[memcached] ./bin/postinstall

[openproject] ./bin/postinstall

Server prefix is set. Need to recompile rails assets. Setting RECOMPILE_RAILS_ASSETS=true

Server prefix was changed from / to /openproject. Need to recompile rails assets. Setting RECOMPILE_RAILS_ASSETS=true

I, [2020-12-26T22:21:40.188281 #7602] INFO -- : Migrating to RenameCostObjectToBudget (20200810152654)

== 20200810152654 RenameCostObjectToBudget: migrating =========================

/opt/openproject/modules/budgets/db/migrate/20200810152654_rename_cost_object_to_budget.rb:4:in `up': Found unexpected primary key name. Fixing primary key names... (StructuredWarnings::StandardWarning)

-- remove_column(:cost_objects, :type)

-> 0.0008s

-- rename_table(:cost_objects, :budgets)

rake aborted!

StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedTable: ERROR: relation "cost_objects_pkey" does not exist

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `exec'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `block (2 levels) in execute'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in `block in execute'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:722:in `block (2 levels) in log'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:721:in `block in log'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract_adapter.rb:712:in `log'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in `execute'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/postgresql/schema_statements.rb:384:in `rename_table'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:890:in `block in method_missing'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:858:in `block in say_with_time'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:858:in `say_with_time'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:879:in `method_missing'

/opt/openproject/modules/budgets/db/migrate/20200810152654_rename_cost_object_to_budget.rb:12:in `up'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:831:in `exec_migration'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:812:in `block (2 levels) in migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:811:in `block in migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in `with_connection'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:810:in `migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1002:in `migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1310:in `block in execute_migration_in_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1361:in `block in ddl_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `block in transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.3.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/transactions.rb:212:in `transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1361:in `ddl_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1309:in `execute_migration_in_transaction'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1281:in `block in migrate_without_lock'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1280:in `each'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1280:in `migrate_without_lock'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1229:in `block in migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1382:in `with_advisory_lock'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1229:in `migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1061:in `up'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/migration.rb:1036:in `migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:238:in `migrate'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/railties/databases.rake:86:in `block (3 levels) in <top (required)>'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/railties/databases.rake:84:in `each'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.3.4/lib/active_record/railties/databases.rake:84:in `block (2 levels) in <top (required)>'

/opt/openproject/vendor/bundle/ruby/2.7.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'

bin/bundle:104:in `load'

bin/bundle:104:in `<main>'

Caused by:

ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "cost_objects_pkey" does not exist