Description:
Hi I'm facing an error while trying to convert a PostgreSQL Database (Catalogue with 13 tables) into MySQL DB.
Source : PostgreSQL 16.8 on x86_64-pc-linux-gnu
Target : 8.0.41 MySQL Community Server - GPL
Error as below. Can someone let know what is the exact fix for this pls ?
I have seen multiple MySQL Bugs based blogs (from 2021 & 2022 even), nowhere there is a solution to this over last couple of years.
Request an update as the Current Production has a very high risk on a legacy hardware system.
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 198, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_object_migration.py", line 118, in task_migrate
self.main.plan.migrate()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 511, in migrate
self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog
Failed
How to repeat:
Start Migration Wizard. Input source rdbms PostgreSQL 16.8 - remote Server using ODBC. Continue. Input target rdbms - local MySQL using TCP/IP. Continue. Fetch Schemas List. Continue. Schemas Selection . Continue. Reverse Engineer Source. Continue. Object Migration [Source Objects] -> Select all . Continue. Migration (this is where issue occurs as below)
A task has failed executing..
ERROR: Migrate Selected Objects: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog
Failed
© 2025, Oracle Corporation and/or its affiliates
Description: Hi I'm facing an error while trying to convert a PostgreSQL Database (Catalogue with 13 tables) into MySQL DB. Source : PostgreSQL 16.8 on x86_64-pc-linux-gnu Target : 8.0.41 MySQL Community Server - GPL Error as below. Can someone let know what is the exact fix for this pls ? I have seen multiple MySQL Bugs based blogs (from 2021 & 2022 even), nowhere there is a solution to this over last couple of years. Request an update as the Current Production has a very high risk on a legacy hardware system. Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 198, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_object_migration.py", line 118, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 511, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ SystemError: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog ERROR: Migrate Selected Objects: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog Failed How to repeat: Start Migration Wizard. Input source rdbms PostgreSQL 16.8 - remote Server using ODBC. Continue. Input target rdbms - local MySQL using TCP/IP. Continue. Fetch Schemas List. Continue. Schemas Selection . Continue. Reverse Engineer Source. Continue. Object Migration [Source Objects] -> Select all . Continue. Migration (this is where issue occurs as below) A task has failed executing.. ERROR: Migrate Selected Objects: TypeError("'<=' not supported between instances of 'int' and 'NoneType'"): error calling Python module function DbPostgresqlMigration.migrateCatalog Failed