'MYSQL workbench 8 Migration wizard error "SystemError: TypeError("'>' not supported between instances of 'NoneType' and 'int'")"
I've been trying to migrate a PSQL (v13.4) database to MySQL (8.0.26) with the Migration wizard tool from Mysql Workbench. I've had to change some code from "db_postgresql_re_grt.py" to fix some issues, however, every time that I select the source objects to migrate and clic "next" i get this error:
Traceback (most recent call last): File "C:\ProgramFiles\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate self.main.plan.migrate()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 510, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state,self.migrationSource.catalog) SystemError: TypeError("'>' not supported between instances of 'NoneType' and 'int'"): error calling Python module function DbPostgresqlMigration.migrateCatalog ERROR: Migrate Selected Objects: TypeError("'>' not supported between instances of 'NoneType' and 'int'"): error calling Python module function DbPostgresqlMigration.migrateCatalog Failed
I haven't found a solution for this... There is a question in stackoverflow that suggest to catch the type of a column and assign some specific value to the "prefix_length_limit" variable in "db_generic_migration_grt.py" code, but that didn't seem to work...
Is someone else having this same issue?
How could I fix this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|