| Bug #116563 | Migration from PostgreSQL unsupported type error | ||
|---|---|---|---|
| Submitted: | 5 Nov 2024 16:41 | Modified: | 6 Dec 2024 14:27 |
| Reporter: | Chandra Earl | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S3 (Non-critical) |
| Version: | 8.0.4 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
[6 Nov 2024 11:13]
MySQL Verification Team
Hi Mr. Earl, Thank you for your bug report. Can you check whether the version that you are quoting, 8.0.4 is the correct one ??? Also, please provide all the data on Postgres version / release, version and release of MySQL Server and Workbench and the entire procedure that you have followed in this migration.
[6 Nov 2024 13:52]
Chandra Earl
MySQL Workbench - Version 8.0.40 build 4610070 CE (64 bits) Postgres - version 17.0 I'm not using MySQL server, this is all on localhost. I'm following the MySQL tutorial - https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql.html, where I'm using the psqlodbc_x64.msi driver found at https://www.postgresql.org/ftp/odbc/releases/REL-17_00_0002/. Specifically the Postgres SQL Unicode driver (although, changing it to any of the others doesn't work anyway).
[6 Nov 2024 14:27]
MySQL Verification Team
Hi Mr. Earl, Since you are using ODBC , can you run it in debug mode and send us back the error log ???
[7 Dec 2024 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Trying to migrate a database from PostgreSQL to MySQL - works just fine until the actual migration step where I get this error: Starting... Migrate Selected Objects.... - Migrating... - Migrating schema [xxx]... - Migrating schema contents for schema [xxx] Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 198, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\migration_object_migration.py", line 118, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0\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 '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 How to repeat: -