Bug #110099 MySQL Workbench Migration Postgres to MySQL Error
Submitted: 16 Feb 2023 14:00 Modified: 17 Feb 2023 12:19
Reporter: Bhargav Trivedi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S3 (Non-critical)
Version:8.0.32 Build 261262 CE 64 bits OS:Windows (Windows 11 Pro)
Assigned to: CPU Architecture:Any (Intel i7 Quad core)

[16 Feb 2023 14:00] Bhargav Trivedi 
Description:
Object Migration I am getting this error. 

Starting...
Migrate Selected Objects....
- Migrating...
- Migrating schema mig...
- Migrating schema contents for schema mig
- Table mig.account_targets migrated

Traceback (most recent call last):
  File "D:\Applications\MySQL Workbench\workbench\wizard_progress_page_widget.py", line 197, in thread_work
    self.func()
  File "D:\Applications\MySQL Workbench\modules\migration_object_migration.py", line 117, in task_migrate
    self.main.plan.migrate()
  File "D:\Applications\MySQL Workbench\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 '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:
1. Source will be local Postgres 15
2. Ran Migration goes through
3. Destination is giving this error
[17 Feb 2023 12:08] MySQL Verification Team 
Hello Bhargab,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.32 and tried to migrate from Postgres to MySQL but I am not seeing any issues at my end.
Please see Bug #102532.

Regards,
Ashwini Patil
[17 Feb 2023 12:19] Bhargav Trivedi 
Thank You Ashwini for the your response. 

I have gone through the link given by you. The problem still persists on the same ticket. 

Please let me know if have to make any alterations to the .py files mentioned in the logs. 

Thanks