| Bug #104762 | ("'<=' not supported between instances of 'int' and 'NoneType'") | ||
|---|---|---|---|
| Submitted: | 30 Aug 2021 4:31 | Modified: | 1 Sep 2021 13:24 |
| Reporter: | Vasu Rao | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
| Version: | 8.0.24 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 | |
[1 Sep 2021 13:00]
MySQL Verification Team
Hello Vasu Rao, Thank you for the bug report. Please do not submit the same bug more than once. An existing bug report already describes this problem. Because of this, we hope you add your comments to the original bug instead. https://bugs.mysql.com/bug.php?id=93594 Regards, Ashwini Patil
[1 Sep 2021 13:24]
Vasu Rao
Hi Ashwini,
That error is belongs to min_value which you shared the bug link.
But here i am getting different error i.e
("'<=' not supported between instances of 'int' and 'NoneType'")
I checked some of the bug and links .. i tried to implement that , but no luck
[9 Apr 14:16]
venkateswara rao motupalli
Hi @Vasu Rao, I'm exactly hit with the same error while migrating PostgreSQL to MySQL over the workbench. Do you see any updates anywhere in the MySQL page for exact resolution? Were you able to get over this error ? I have seen your similar query to MySQL Bug #102532 as well. I have enquired on this error there as well. https://bugs.mysql.com/bug.php?id=102532&thanks=3¬ify=71
Description: While migrating from Postgresql 13 to MySQL 8.0 we are getting this error in Migration Step from Workbench Migration Wizard . Please provide me the solution . Thanks in advance. Starting... Migrate Selected Objects.... - Migrating... - Migrating schema test_db... - Migrating schema contents for schema test_db - Table test_db.comments migrated - Table test_db.genres migrated - Table test_db.kids_audit migrated Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 190, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_object_migration.py", line 110, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 503, 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: ("'<=' not supported between instances of 'int' and 'NoneType'")