Top Menu

Jump to content
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    Home
    • 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
    • Upgrade to Enterprise edition
    • 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

      OpenProject ID Google

Side Menu

Collapse project menu
  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Expand project menu
Support Installation & Updates
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. Support Installation & Updates
  5. mysql->postgres migration fails

mysql->postgres migration fails

Added by roland rlx over 5 years ago

Trying to migrate an installation to postgres following this:

https://docs.openproject.org/installation-and-operations/misc/packaged-postgresql-migration/

Installed is the deb-package 9.0.4-1570023722.b1f1184d.xenial on Ubuntu 16.04

# sudo openproject run ./docker/mysql-to-postgres/bin/migrate-mysql-to-postgres
Migrating database from MySQL to PostgreSQL.

Import
  MySQL database
    mysql://openproject:REDACTED@127.0.0.1:3306/openproject
  into Postgres database 
    postgresql://openproject:REDACTED@localhost/openproject
  ?
WARNING: This resets the given Postgres database.

Y/n 
Resetting target database...
Database dropped
Creating database...
Importing database ...
2020-03-19T12:57:22.019965Z NOTICE Starting pgloader, log system is ready.
2020-03-19T12:57:22.090584Z LOG pgloader version "3.6.1"
Unhandled exception 11 at 0x7f3bd107be40, context->regs at #x7f3bd09224c8
Exception occurred while executing foreign code
received signal 11; faulting address: 0x7f3bd0e1
address not mapped to object
? for help

Loading...