| Bug #104759 | Reverse Engineer Selected Schemas in Migration Wizard | ||
|---|---|---|---|
| Submitted: | 29 Aug 2021 15:47 | Modified: | 1 Sep 2021 12:56 |
| Reporter: | Vasu Rao | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
| Version: | 8.0.26 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 | |
[30 Aug 2021 4:25]
Vasu Rao
As of now i have resolved now ..But we are facing the error now ..
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 '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
[1 Sep 2021 12:56]
MySQL Verification Team
Hello Vasu Rao, Thank you for the bug report. This is most likely duplicate of Bug #93594, please see Bug #93594. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Regards, Ashwini Patil
Description: I am doin postgresql 13 to Mysql 8 DB migration by using Workbench Migration wizard . I am getting error in Reverse Engineer Selected Schemas option.Here is the logs .. Please help us me. Starting... Connect to source DBMS... - Connecting... Connecting to postgresql@DRIVER=PostgreSQL ANSI;SERVER=50.16.135.236;PORT=5432... Opening ODBC connection to DRIVER=PostgreSQL ANSI;SERVER=50.16.135.236;PORT=5432;DATABASE=kidsdb;UID=postgres;UseDeclareFetch=1;... Connected Connect to source DBMS done Reverse engineer selected schemas.... Reverse engineering public from kidsdb - Reverse engineering catalog information 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_schema_selection.py", line 176, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 357, in reverseEngineer self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) SystemError: ProgrammingError("('42703', '[42703] ERROR: column "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer ERROR: Reverse engineer selected schemas: ProgrammingError("('42703', '[42703] ERROR: column "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer Failed How to repeat: Starting... Connect to source DBMS... - Connecting... Connecting to postgresql@DRIVER=PostgreSQL ANSI;SERVER=50.16.135.236;PORT=5432... Opening ODBC connection to DRIVER=PostgreSQL ANSI;SERVER=50.16.135.236;PORT=5432;DATABASE=kidsdb;UID=postgres;UseDeclareFetch=1;... Connected Connect to source DBMS done Reverse engineer selected schemas.... Reverse engineering public from kidsdb - Reverse engineering catalog information 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_schema_selection.py", line 176, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration.py", line 357, in reverseEngineer self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) SystemError: ProgrammingError("('42703', '[42703] ERROR: column "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer ERROR: Reverse engineer selected schemas: ProgrammingError("('42703', '[42703] ERROR: column "min_value" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer Failed