MySQL Bugs: #107058: MySQL Workbench - Testing PG Connection in Migration crashes app

Bug #107058	MySQL Workbench - Testing PG Connection in Migration crashes app
Submitted:	19 Apr 2022 18:58	Modified:	6 Jun 2022 12:47
Reporter:	Doug Johnson	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S2 (Serious)
Version:	8.0.28	OS:	MacOS (12.3.1 Moterey)
Assigned to:		CPU Architecture:	x86

Description:
Any time I try to test a connection to my local Docker container running postgresql, workbench crashes and produces a crash report. I'm following the instructions from this point, including the step to compile my ODBC driver.

https://dev.mysql.com/blog-archive/how-to-migrate-postgresql-databases-to-mysql-using-the-...

I can connect to my local docker container database from my OS through other apps without issue.

I was able to get this to work a couple months ago but have updated MacOS since then, and don't remember what version of workbench I was using (I seem to recall needing to revert to an older version at that point).

Report included in Private coment.

How to repeat:
Follow the steps from that blog post in the description for macOS.

- Open Workbench
- Start Migration
- Choose PostgreSQL
- use psqlODBCA driver
- enter 127.0.0.1 and docker port (5512 in my case)
- enter username, password and database name (db exists)
- Click Test Connection
* Crash *

Suggested fix:
No suggestion other than hopefully figure out what the error is and fix it? Maybe better error handling at this point with useful error messages?

Hi Doug, 

Indeed our migration toolkit in workbench seems to be broken. It's not the preferable way to migrate data, there are way too many options currently (datatypes, own types, ...) 

The best way to migrate is to perform it manually. This is the job of the DBA to compare the possibilities and fix the incompatibilities.

For info, I explained a bit the process in the following articles:

- https://blogs.oracle.com/mysql/import-data-from-amazon-aurora-postgresql-to-mysql-database...
- https://blogs.oracle.com/mysql/how-to-import-data-from-amazon-redshift-to-mysql-database-s...
- https://blogs.oracle.com/mysql/how-to-import-data-from-postgresql-to-mysql-database-servic... 

Regards,

Hello,

Thank you for the bug report.
I've tried to reproduce your issue on a Mac with workbench 8.0.29 but not seeing any issues at my end.
Discussed internally with the WB developers and confirmed that it is not seen.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Regards,
Ashwini Patil

I am also having the same issue, all I do is open the migration wizard, select Postgre, enter the credentials and click test and the app crashes.  I am on 8.0.34.

Got to this thread, still trying to find a solution for this Migration Wizard. I'm on a MBP MacOS Ventura 15.6 M1 Chip, migrating from SQL Server (native) to MySQL.

The only version that worked flawless and smoothly was 8.0.21. After that one, Migration Wizard crashes at "Test Connection", and now I'm stuck because can't find 8.0.21 for M1 neither Parallels Windows 11 ARM64.

Using now JB's DataGrip.

I have the same issue on Ubuntu 22.04 and Workbench version 8.0.36 build 3737333 Community.

Testing connection outside workbench gives success:
pg_isready -d currency_rates_prod -h localhost -p 5432 -U postgres
localhost:5432 - accepting connections

When I provide this credentials to migration wizard as a source and press test connection it crushes. 

I have no idea where to look for error messages. 
Appreciate any advice.