Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Error after upgrade to 8.3 - "sh: 1: ng: not found"

Added by Gustav Gans over 5 years ago

Hello,

after i upgrade my debian stretch OpenProject to 8.3, i got a error if i run: openproject run rake assets:precompile:

W, [2019-03-14T06:37:43.920256 #16353]  WARN -- : [auth_saml] Missing settings from '/opt/openproject/config/plugins/auth_saml/settings.yml', skipping omniauth registration.
W, [2019-03-14T06:37:43.988133 #16353]  WARN -- : hook registered
Cleaning linked target directory /opt/openproject/frontend/src/app/modules/plugins/linked
Linking frontend of OpenProject plugin openproject-avatars to /opt/openproject/frontend/src/app/modules/plugins/linked/openproject-avatars.
Linking frontend of OpenProject plugin openproject-costs to /opt/openproject/frontend/src/app/modules/plugins/linked/openproject-costs.
Linking frontend of OpenProject plugin openproject-documents to /opt/openproject/frontend/src/app/modules/plugins/linked/openproject-documents.
Linking frontend of OpenProject plugin openproject-my_project_page to /opt/openproject/frontend/src/app/modules/plugins/linked/openproject-my_project_page.
Regenerating frontend plugin registry /opt/openproject/frontend/src/app/modules/plugins/linked-plugins.module.ts.
Cleaning linked target directory /opt/openproject/frontend/legacy/app/plugins
Linking legacy frontend of OpenProject plugin openproject-costs to /opt/openproject/frontend/legacy/app/plugins/openproject-costs.
Linking legacy frontend of OpenProject plugin openproject-my_project_page to /opt/openproject/frontend/legacy/app/plugins/openproject-my_project_page.
Building angular frontend
npm run build

> openproject-frontend@0.1.0 prebuild /opt/openproject/frontend
> ./scripts/link_plugin_placeholder.js

> openproject-frontend@0.1.0 build /opt/openproject/frontend
> ng build --prod && npm run legacy-webpack

sh: 1: ng: not found
npm ERR! file sh
npm ERR! code ELIFECYCLE
npm ERR! errno ENOENT
npm ERR! syscall spawn
npm ERR! openproject-frontend@0.1.0 build: `ng build --prod && npm run legacy-webpack`
npm ERR! spawn ENOENT
npm ERR!
npm ERR! Failed at the openproject-frontend@0.1.0 build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
rake aborted!
Failed to compile angular frontend: 1
/opt/openproject/lib/tasks/assets.rake:54:in `block (4 levels) in <top (required)>'
/opt/openproject/lib/tasks/assets.rake:53:in `block (3 levels) in <top (required)>'
/opt/openproject/lib/tasks/assets.rake:52:in `chdir'
/opt/openproject/lib/tasks/assets.rake:52:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'
Tasks: TOP => assets:precompile => assets:compile_environment => assets:prepare_op => assets:angular
(See full trace by running task with --trace)

And the Webinterface is a white page.

I have search for ""sh: 1: ng: not found" openproject", but found nothing from OP8.3.

If i run npm link @angular/cli as root i got "command not found".

root@server ~ # free -h
total        used        free      shared  buff/cache   available
Mem:            15G        1,0G        2,0G        170M         12G         13G
Swap:          8,0G          0B        8,0G
root@server ~ #

Edit: i have found a mistake from me, after i upgrade with apt, i run "openproject run rake assets:precompile" without "openproject configure", can that be the fault? I have run openproject configure successful now, but its the same problem.

Any ideas?

Burt


Replies (9)

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Oliver Günther over 5 years ago

Hi Burt,

you only need to run openproject configure which includes assets precompilation if needed. In 8.3. this is only the case IF you use a custom plugin (specified via openproject config:get CUSTOM_GEMFILE)

What is the output of openproject configure ?

Best,

Oliver

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Gustav Gans over 5 years ago

Hello Oliver,

the output from openproject configure is:

root@server ~ # openproject configure
Launching installer for openproject...
Selected addons: legacy-installer postgres apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[postgres] ./bin/configure
Installation is already using MySQL, skipping postgres addon.
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[postgres] ./bin/preinstall
INFO: autoinstall=skip. Skipping to next step.
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
Module perl already enabled
Module dav already enabled
Considering dependency dav for dav_svn:
Module dav already enabled
Module dav_svn already enabled
[Thu Mar 14 14:43:16.243861 2019] [so:warn] [pid 27759] AH01574: module dav_module is already loaded, skipping
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 2a01:4f8:161:8023::2. Set the 'ServerName' directive globally to suppress this message
Module cgi already enabled
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[postgres] ./bin/postinstall
[apache2] ./bin/postinstall
Module rewrite already enabled
Considering dependency setenvif for ssl:
Module setenvif already enabled
Considering dependency mime for ssl:
Module mime already enabled
Considering dependency socache_shmcb for ssl:
Module socache_shmcb already enabled
Module ssl already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Module headers already enabled
Module expires already enabled
Considering dependency filter for deflate:
Module filter already enabled
Module deflate already enabled
Module filter already enabled
Site openproject already enabled
[repositories] ./bin/postinstall
No repositories have been configured. Skipping configuration.
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall
`/home/openproject` is not a directory.
Bundler will use `/tmp/bundler/home/user' as your home directory temporarily.
`/home/openproject` is not a directory.
Bundler will use `/tmp/bundler/home/user' as your home directory temporarily.

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

*   OpenProject requires UTF-8 encoding set on MySQL < 5.7              *
and UTF-8mb4 beyond that. Please ensure having set
*                                                                       *
production:
*         encoding: utf8mb4                                         *

*   in config/database.yml.                                             *
Otherwise, you WILL run into encoding issue when using 4 byte
*   UTF-8 characters since utf8 encoding in MySQL doesn't support them. *

*   If you have been running utf8 in the past, please see this guide    *
on how to convert your database:
*   https://mathiasbynens.be/notes/mysql-utf8mb4                        *

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

W, [2019-03-14T14:43:26.808945 #28636]  WARN -- : [auth_saml] Missing settings from '/opt/openproject/config/plugins/auth_saml/settings.yml', skipping omniauth registration.
W, [2019-03-14T14:43:26.874976 #28636]  WARN -- : hook registered
*** Seeding for locale: 'en'
*** Seeding basic data
↳ BuiltinRolesSeeder
*** Skipping built in role Non member - already exists
*** Skipping built in role Anonymous - already exists
↳ RoleSeeder
*** Skipping roles as there are already some configured
↳ ActivitySeeder
*** Skipping activities as there are already some configured
↳ ColorSeeder
*** Skipping colors as there are already some configured
↳ ColorSchemeSeeder
*** Skipping flat colors as there are already some configured
↳ WorkflowSeeder
*** Skipping types, statuses and workflows as there are already some configured
↳ PrioritySeeder
*** Skipping priorities as there are already some configured
↳ SettingSeeder
*** Skipping settings as all settings already exist in the db
Loading discovered seeders:
↳ SettingSeeder
*** Skipping BasicData::Backlogs::SettingSeeder
↳ EnumerationsSeeder
*** Seeding admin user
*** No need to seed an admin as there already is one.
*** Seeding demo data
↳ ProjectSeeder
*** Skipping DemoData::ProjectSeeder
Loading discovered seeders:
↳ MyProjectsOverviewSeeder
*** Skipping DemoData::MyProjectPage::MyProjectsOverviewSeeder
*** Loading action_view_railtie seed data
*** Loading active_storage seed data
*** Loading action_cable_engine seed data
*** Loading doorkeeper_engine seed data
*** Loading typed_dag_engine seed data
*** Loading date_validator_engine seed data
*** Loading ok_computer seed data
*** Loading bourbon_engine seed data
*** Loading i18n_js_engine seed data
*** Loading openproject_translations seed data
*** Loading openproject_global_roles seed data
*** Loading openproject_auth_plugins seed data
*** Loading openproject_auth_saml seed data
*** Loading openproject_openid_connect seed data
*** Loading openproject_documents seed data
*** Loading openproject_my_project_page seed data
*** Loading openproject_xls_export seed data
*** Loading reportingengine seed data
*** Loading openproject_costs seed data
*** Loading openproject_reporting seed data
*** Loading openproject_meeting seed data
*** Loading openproject_pdf_export seed data
*** Loading openproject_backlogs seed data
*** Loading openproject_avatars seed data
*** Loading openproject_two_factor_authentication seed data
*** Loading openproject_webhooks seed data
*** Loading openproject_github_integration seed data
*** Loading openproject_ldap_groups seed data
*** Loading grids seed data
Nothing to do.
Nothing to do.
root@server ~ #

looks normal?

(First output was not complete, sorry)

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Gustav Gans over 5 years ago

If i open OP in the webbrowser (i clear the cache complete), i get:

https://dlsz.de/s/BrowserOP.png

Next strange thing is, i have only a production.log.1 - not without number:

-rw-r--r--  1 openproject openproject      0 Sep 21 06:25 markdown-migration.log 
-rw-r--r--  1 openproject openproject   1837 Sep 21 06:25 markdown-migration.log.1 
-rw-r--r--  1 openproject openproject 439540 Mär 13 06:25 production.log.1 
-rw-r--r--  1 openproject openproject   4188 Mär  4 06:25 production.log.10.gz 
-rw-r--r--  1 openproject openproject   4679 Mär  3 06:25 production.log.11.gz 

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Gustav Gans over 5 years ago

I have install the version 8.2.1 from backup (created with OP, delete the old database, import the backup, dpkg -i .deb-file), everything works, i can login, see the projects etc .. see the log at the end from this posting.

Now i upgrade again to OP 8.3:

dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets/v3.0/cu« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets/v3.0/Er« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets/v3.0/kx« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets/v3.0/S9« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets/v3.0« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets/sprockets« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
dpkg: Warnung: Altes Verzeichnis »/opt/openproject/tmp/cache/assets« kann nicht gelöscht werden: Das Verzeichnis ist nicht leer
openproject (8.3.0-1551993323.071e6bf7.stretch) wird eingerichtet ...
Neue Version der Konfigurationsdatei /etc/default/openproject wird installiert ...
==============
The openproject package provides an installer. Please run the following command to finish the installation:
sudo openproject configure
==============

Aktueller Status: 0 (-1) upgradable.

Do 14. Mär 19:20:11 CET 2019

root@server ~ # openproject configure
Launching installer for openproject...
Selected addons: legacy-installer postgres apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[postgres] ./bin/configure
Installation is already using MySQL, skipping postgres addon.
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[postgres] ./bin/preinstall
INFO: autoinstall=skip. Skipping to next step.
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
Module perl already enabled
Module dav already enabled
Considering dependency dav for dav_svn:
Module dav already enabled
Module dav_svn already enabled
[Thu Mar 14 19:20:19.046100 2019] [so:warn] [pid 4442] AH01574: module dav_module is already loaded, skipping
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 2a01:4f8:161:8023::2. Set the 'ServerName' directive globally to suppress this message
Module cgi already enabled
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[postgres] ./bin/postinstall
[apache2] ./bin/postinstall
Module rewrite already enabled
Considering dependency setenvif for ssl:
Module setenvif already enabled
Considering dependency mime for ssl:
Module mime already enabled
Considering dependency socache_shmcb for ssl:
Module socache_shmcb already enabled
Module ssl already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Module headers already enabled
Module expires already enabled
Considering dependency filter for deflate:
Module filter already enabled
Module deflate already enabled
Module filter already enabled
Site openproject already enabled
[repositories] ./bin/postinstall
No repositories have been configured. Skipping configuration.
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

*   OpenProject requires UTF-8 encoding set on MySQL < 5.7              *
and UTF-8mb4 beyond that. Please ensure having set
*                                                                       *
production:
*         encoding: utf8mb4                                         *

*   in config/database.yml.                                             *
Otherwise, you WILL run into encoding issue when using 4 byte
*   UTF-8 characters since utf8 encoding in MySQL doesn't support them. *

*   If you have been running utf8 in the past, please see this guide    *
on how to convert your database:
*   https://mathiasbynens.be/notes/mysql-utf8mb4                        *

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

W, [2019-03-14T19:20:29.832487 #5317]  WARN -- : [auth_saml] Missing settings from '/opt/openproject/config/plugins/auth_saml/settings.yml', skipping omniauth registration.
W, [2019-03-14T19:20:29.899692 #5317]  WARN -- : hook registered
I, [2019-03-14T19:20:31.038616 #5317]  INFO -- : Migrating to CreateDoorkeeperTables (20181112125034)
== 20181112125034 CreateDoorkeeperTables: migrating ===========================
-- adapter_name()
-> 0.0000s
-- create_table(:oauth_applications, {:options=>"ENGINE=InnoDB"})
-> 0.4214s
-- add_foreign_key(:oauth_applications, :users, {:column=>:owner_id, :on_delete=>:nullify})
-> 0.7443s
-- add_foreign_key(:oauth_applications, :users, {:column=>:client_credentials_user_id, :on_delete=>:nullify})
-> 0.9024s
-- add_index(:oauth_applications, :uid, {:unique=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `index_oauth_applications_on_uid`  ON `oauth_applications` (`uid`)
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `index_oauth_applications_on_uid`  ON `oauth_applications` (`uid`)
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'

Caused by:
Mysql2::Error: Specified key was too long; max key length is 767 bytes
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
root@server ~ #53

Edit: i now install the old version again from backup:

root@server ~ # mysql -u root 
MariaDB [(none)]> drop database openproject; 
MariaDB [(none)]> CREATE DATABASE openproject CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 
MariaDB [(none)]> exit 
root@server ~ # mysql -u root openproject < mysql-dump-20190314010001.sql

root@server ~ # dpkg -i openproject_8.2.1-1550429392.328d0cc4.stretch_amd64.deb
dpkg: Warnung: Version 8.3.0-1551993323.071e6bf7.stretch des Paketes openproject wird durch ältere Version 8.2.1-1550429392.328d0cc4.stretch ersetzt
(Lese Datenbank ... 96777 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von openproject_8.2.1-1550429392.328d0cc4.stretch_amd64.deb ...
Entpacken von openproject (8.2.1-1550429392.328d0cc4.stretch) über (8.3.0-1551993323.071e6bf7.stretch) ...
openproject (8.2.1-1550429392.328d0cc4.stretch) wird eingerichtet ...
Neue Version der Konfigurationsdatei /etc/default/openproject wird installiert ...
==============
The openproject package provides an installer. Please run the following command to finish the installation:
sudo openproject configure
==============
root@server ~ # openproject configure
Launching installer for openproject...
Selected addons: legacy-installer mysql apache2 repositories smtp memcached openproject
[legacy-installer] ./bin/configure
[mysql] ./bin/configure
MySQL connection OK
DONE
[apache2] ./bin/configure
DONE
[repositories] ./bin/configure
DONE
[smtp] ./bin/configure
DONE
[memcached] ./bin/configure
DONE
[openproject] ./bin/configure
[legacy-installer] ./bin/preinstall
[mysql] ./bin/preinstall
[apache2] ./bin/preinstall
[repositories] ./bin/preinstall
Module perl already enabled
Module dav already enabled
Considering dependency dav for dav_svn:
Module dav already enabled
Module dav_svn already enabled
[Thu Mar 14 19:48:35.353475 2019] [so:warn] [pid 7672] AH01574: module dav_module is already loaded, skipping
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 2a01:4f8:161:8023::2. Set the 'ServerName' directive globally to suppress this message
Module cgi already enabled
[smtp] ./bin/preinstall
[memcached] ./bin/preinstall
[openproject] ./bin/preinstall
[legacy-installer] ./bin/postinstall
[mysql] ./bin/postinstall
Generating /etc/openproject/conf.d/database...
[apache2] ./bin/postinstall
Module rewrite already enabled
Considering dependency setenvif for ssl:
Module setenvif already enabled
Considering dependency mime for ssl:
Module mime already enabled
Considering dependency socache_shmcb for ssl:
Module socache_shmcb already enabled
Module ssl already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Module headers already enabled
Module expires already enabled
Considering dependency filter for deflate:
Module filter already enabled
Module deflate already enabled
Module filter already enabled
Site openproject already enabled
[repositories] ./bin/postinstall
No repositories have been configured. Skipping configuration.
[smtp] ./bin/postinstall
[memcached] ./bin/postinstall
[openproject] ./bin/postinstall

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

*   OpenProject requires UTF-8 encoding set on MySQL < 5.7              *
and UTF-8mb4 beyond that. Please ensure having set
*                                                                       *
production:
*         encoding: utf8mb4                                         *

*   in config/database.yml.                                             *
Otherwise, you WILL run into encoding issue when using 4 byte
*   UTF-8 characters since utf8 encoding in MySQL doesn't support them. *

*   If you have been running utf8 in the past, please see this guide    *
on how to convert your database:
*   https://mathiasbynens.be/notes/mysql-utf8mb4                        *

*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *

*** Seeding for locale: 'en'
*** Seeding basic data
↳ BuiltinRolesSeeder
*** Skipping built in role Non member - already exists
*** Skipping built in role Anonymous - already exists
↳ RoleSeeder
*** Skipping roles as there are already some configured
↳ ActivitySeeder
*** Skipping activities as there are already some configured
↳ ColorSeeder
*** Skipping colors as there are already some configured
↳ ColorSchemeSeeder
*** Skipping flat colors as there are already some configured
↳ WorkflowSeeder
*** Skipping types, statuses and workflows as there are already some configured
↳ PrioritySeeder
*** Skipping priorities as there are already some configured
↳ SettingSeeder
*** Skipping settings as all settings already exist in the db
Loading discovered seeders:
↳ EnumerationsSeeder
↳ SettingSeeder
*** Skipping BasicData::Backlogs::SettingSeeder
*** Seeding admin user
*** No need to seed an admin as there already is one.
*** Seeding demo data
↳ ProjectSeeder
*** Skipping DemoData::ProjectSeeder
Loading discovered seeders:
↳ MyProjectsOverviewSeeder
*** Skipping DemoData::MyProjectPage::MyProjectsOverviewSeeder
*** Loading action_view_railtie seed data
*** Loading action_cable_engine seed data
*** Loading typed_dag_engine seed data
*** Loading date_validator_engine seed data
*** Loading ok_computer seed data
*** Loading bourbon_engine seed data
*** Loading i18n_js_engine seed data
*** Loading openproject_translations seed data
*** Loading openproject_global_roles seed data
*** Loading openproject_auth_plugins seed data
*** Loading openproject_openid_connect seed data
*** Loading openproject_documents seed data
*** Loading openproject_my_project_page seed data
*** Loading openproject_xls_export seed data
*** Loading reportingengine seed data
*** Loading openproject_costs seed data
*** Loading openproject_reporting seed data
*** Loading openproject_meeting seed data
*** Loading openproject_pdf_export seed data
*** Loading openproject_backlogs seed data
*** Loading openproject_avatars seed data
*** Loading openproject_two_factor_authentication seed data
*** Loading openproject_webhooks seed data
*** Loading openproject_github_integration seed data
Nothing to do.
Nothing to do.
root@server ~ #

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Gustav Gans over 5 years ago

OK, have a idea - the Error: Specified key was too long; max key length is 767 bytes Error is known, try something...

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Oliver Günther over 5 years ago

Hi Gustav,

what is your MySQL database encoding and collation set to? I suspect that it is not set to UTF-8 which is what OpenProject requires for MySQL versions <= 5.6

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Roman A over 5 years ago

Hi all

I encountered exactly the same error (ng: not found) after upgrading. I also decided to ditch the new version and re-install the old one which still supported mysql (v8.2.1) but Im always gettings an error when trying to use my old database:

*** Seeding for locale: 'en'
*** Seeding basic data
 ↳ BuiltinRolesSeeder
   *** Skipping built in role Non member - already exists
   *** Skipping built in role Anonymous - already exists
 ↳ RoleSeeder
   *** Skipping roles as there are already some configured
 ↳ ActivitySeeder
 ↳ ColorSeeder
   *** Skipping colors as there are already some configured
 ↳ ColorSchemeSeeder
   *** Skipping flat colors as there are already some configured
 ↳ WorkflowSeeder
   *** Skipping types, statuses and workflows as there are already some configured
 ↳ PrioritySeeder
rake aborted!
ActiveModel::UnknownAttributeError: unknown attribute 'color_id' for IssuePriority.
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activemodel-5.1.6.1/lib/active_model/attribute_assignment.rb:48:in `_assign_attribute'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activemodel-5.1.6.1/lib/active_model/attribute_assignment.rb:40:in `block in _assign_attributes'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activemodel-5.1.6.1/lib/active_model/attribute_assignment.rb:39:in `each'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activemodel-5.1.6.1/lib/active_model/attribute_assignment.rb:39:in `_assign_attributes'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6.1/lib/active_record/attribute_assignment.rb:26:in `_assign_attributes'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activemodel-5.1.6.1/lib/active_model/attribute_assignment.rb:33:in `assign_attributes'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6.1/lib/active_record/core.rb:337:in `initialize'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6.1/lib/active_record/inheritance.rb:66:in `new'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6.1/lib/active_record/inheritance.rb:66:in `new'
/opt/openproject/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.6.1/lib/active_record/persistence.rb:50:in `create!'

EDIT: Fixed it by using the SQL dump from a week ago...

RE: Error after upgrade to 8.3 - "sh: 1: ng: not found" - Added by Michael Pietsch over 5 years ago

I got the same error when updating (using mariadb Ver 15.1 Distrib 10.1.37-MariaDB on debian 9 with UTF8mb4 enabled)

== 20181112125034 CreateDoorkeeperTables: migrating ===========================
-- adapter_name()
   -> 0.0000s
-- create_table(:oauth_applications, {:options=>"ENGINE=InnoDB"})
   -> 0.6278s
-- add_foreign_key(:oauth_applications, :users, {:column=>:owner_id, :on_delete=>:nullify})
   -> 0.6122s
-- add_foreign_key(:oauth_applications, :users, {:column=>:client_credentials_user_id, :on_delete=>:nullify})
   -> 0.4053s
-- add_index(:oauth_applications, :uid, {:unique=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `index_oauth_applications_on_uid`  ON `oauth_applications` (`uid`)
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE UNIQUE INDEX `index_oauth_applications_on_uid`  ON `oauth_applications` (`uid`)
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'

Caused by:
Mysql2::Error: Specified key was too long; max key length is 767 bytes
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
/opt/openproject/db/migrate/20181112125034_create_doorkeeper_tables.rb:22:in `change'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:814:in `exec_migration'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:797:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:796:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:977:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `each'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1210:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1036:in `up'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:1011:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli/exec.rb:28:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:463:in `exec'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:27:in `dispatch'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/cli.rb:18:in `start'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:30:in `block in <top (required)>'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/openproject/vendor/bundle/ruby/2.6.0/gems/bundler-2.0.1/exe/bundle:22:in `<top (required)>'
/opt/openproject/bin/bundle:3:in `load'
/opt/openproject/bin/bundle:3:in `<main>'

RE: Error after upgrade to 8.3 - \"sh: 1: ng: not found\" - Added by Wieland Lindenthal over 5 years ago

Hi Michael,

What I understand from your post is that you have MariaDB in Version 10.1.37. That version is smaller than what OP requires for proper UTF8mb4 support.  Maria DB 10.2 is equivalent to MySQL 5.7, which is required. So you either want to upgrade your MariaDB version, or go the old encoding: utf8 path with all the downsides.

Please see https://github.com/opf/openproject/blob/stable/8/docs/installation/manual/README.md

We recommend against using MySQL. If you have to use MySQL instead, please ensure a version of >= 5.7 (MariaDB version >= 10.2) as it supports special characters such as emojis (emoticons) out of the box.

If you can, this might be a good point in time to move to PostgreSQL as OP now uses PostgreSQL as the default DB (for a couple of very good reasons)

  • (1 - 9/9)
Loading...