Skip to content

Migration hangs with "Currently creating table: undefined" #144

@rsshilli

Description

@rsshilli

Great project! Thank you for creating this. I struggled with pgloader for too long before giving up and looking for something new.

I'm on MySQL 8.0.42 migrating to Postgres 17 and when I run npm start I get the following error:

> [email protected] start
> node dist/src/main.js

        --[FsOps::createLogsDirectory] Creating directory /Users/ryanshillington/projects/nmig/logs_directory...
        --[FsOps::createLogsDirectory] Creating directory /Users/ryanshillington/projects/nmig/logs_directory/not_created_views...
        --[FsOps::createLogsDirectory] Directory /Users/ryanshillington/projects/nmig/logs_directory already exists...
        --[FsOps::createLogsDirectory] Directory /Users/ryanshillington/projects/nmig/logs_directory/not_created_views already exists...
        --[FsOps::readDataAndIndexTypesMap] Data and Index Types Maps are loaded...
        --[BootProcessor::boot] 
        /\_  |\  /\/\ /\___
        |  \ | |\ | | | __
        | |\\| || | | | \_ \
        | | \| || | | |__/ |
        \|   \/ /_|/______/

        NMIG - the database migration tool
        Copyright (C) 2016 - present, Anatoly Khaytovich <[email protected]>

        --[boot] Configuration has been just loaded.
        --[boot] NMIG is starting. 

        --[DataPoolManager::createDataPoolTable] table "public"."data_pool_publicclient_local_RocketsRUS" is created...
        --[TableProcessor::createTable] Currently creating table: `undefined`
        --[TableProcessor::createTable] Currently creating table: `undefined`
---<snip snip (the line above repeats itself for all 321 tables) snip snip >---
    
        --[Main] error: [object Object]

        --[StructureLoader::default] Source DB structure is loaded...

                --[StructureLoader::default] Tables to migrate: 321

                --[StructureLoader::default] Views to migrate: 0
        --[TableProcessor::createTable] Error: Table 'client_local_rocketsrus.undefined' doesn't exist

        SQL: SHOW FULL COLUMNS FROM `undefined`;


        --[TableProcessor::createTable] Error: Table 'client_local_rocketsrus.undefined' doesn't exist

        SQL: SHOW FULL COLUMNS FROM `undefined`;


---<snip snip (the 5 lines above repeat themselves for all 321 tables) snip snip >---

Unfortunately it doesn't stop with an error or anything. If I look in the DB, the only tables created start with "data_pool" and "state_logs".

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions