Top Menu

Jump to content
    Global modules

    Global modules

    • Home
    • Projects
    • Activity
    • Work packages
    • Gantt charts
    • Calendars
    • Team planners
    • Boards
    • News
    Home
    Home
Help
    Getting started
    • Introduction video
  • 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

User menu

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...