Bug #107897 | Workbench 8.029 hungs upon importing data | ||
---|---|---|---|
Submitted: | 15 Jul 2022 23:15 | Modified: | 20 Jul 2022 10:39 |
Reporter: | Pablo Rodriguez | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 8.029 | OS: | Windows (11) |
Assigned to: | CPU Architecture: | Any (x64) | |
Tags: | CSV File, Import/Export, table |
[15 Jul 2022 23:15]
Pablo Rodriguez
[16 Jul 2022 20:59]
Steven Dorsher
I'm having the same problem with MySQL Workbench. The version is 8.0.29 and the platform is Windows 10. I load the data and the progress bar stalls at zero with the two circles filled and no data loaded after a few minutes. I am loading about 136519 rows and 8 columns. I eventually cancel. Error message is Cannot access a disposed object. Object name '_ProgressBar' I was exploring the use of this software due to difficulties using BigQuery in a Coursera Google certificate course in data analytics. However, it is important to me to have SQL software that allows me to use CSV files whether or not I complete this Google Certificate because I had the long-term intention of doing some science on my own-- I have a background in both programming and physics and with the right software this should be possible. Current workaround is using Kaggle-- I realize this is not exactly a software solution.
[16 Jul 2022 21:19]
Steven Dorsher
I was successful in uploading a table with 19 columns and 12 rows. This one uploaded quickly, the progress bar displayed correctly, and I now have a small amount of personal data I would like to analyze in my database. I was not able to use datetime format for dates and times taken from Google Docs and exported to a csv. I used text.
[18 Jul 2022 11:54]
MySQL Verification Team
Hello Pablo Rodriguez, Thank you for the bug report. I tried to reproduce your issue on windows 10 with workbench 8.0.29 using csv file provided by using "Table Data Import Wizard" but I am not seeing any issues at my end. Could you please provide steps to reproduce this issue at our end? Regards, Ashwini Patil
[19 Jul 2022 3:17]
Pablo Rodriguez
Thanks for answer, I tried to find the "Table Data Import Wizard" with no luck. The File toolbar -> "Import" only shows Reverse Engineer MySQL Script" and on Database there is another import but for schemas. Using contextual right click on the table section of the schema only shows disabled options cut, copy, paste. That’s why I was only left with the button "Import records from external file" on the insert panel of a new table, that only works if you have previously created the fields. Maybe the Wizard does it ok but I haven’t been able to find it.
[19 Jul 2022 6:49]
MySQL Verification Team
Please see the screenshot below to find "Table Data Import Wizard"
Attachment: 107897_test_results.png (image/png, text), 209.21 KiB.
[19 Jul 2022 15:58]
Pablo Rodriguez
You are using a different version of the software, on this one that panel is not there anymore, i did find a catalog tree as you show on the Model Diagram (Model Overview -> Catalog Tree) but when you right chick on the Tables it pops a contextual menu without any selectable options, see the <a href="https://photos.app.goo.gl/2WYSMGjtNGetfQiKA">screenshot</a>
[20 Jul 2022 10:39]
MySQL Verification Team
Hello Pablo Rodriguez, Thank you for the detailed feedback. Verified as described. Regards, Ashwini Patil
[20 Jul 2022 10:42]
MySQL Verification Team
8.0.29 test results
Attachment: 107897_notresponding.png (image/png, text), 227.62 KiB.