| Bug #111498 | Data Import Wizard Failing | ||
|---|---|---|---|
| Submitted: | 20 Jun 2023 17:02 | Modified: | 23 Jun 2023 19:48 |
| Reporter: | Christian Mosley | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 8.0.33 | OS: | Windows (Windows 10 Pro - 22H2) |
| Assigned to: | CPU Architecture: | Any (AMD) | |
[21 Jun 2023 12:34]
MySQL Verification Team
Hello Christian, Thank you for the bug report. I tried to reproduce your issue on windows 10 with workbench 8.0.33 using dummy csv file to import but I am not seeing any issues at my end. Please provide sample csv file to reproduce this issue at our end. Regards, Ashwini Patil
[22 Jun 2023 12:42]
MySQL Verification Team
Hello Christian, Thank you for the details. I could not repeat the issue with given csv file. Please see the attached screenshot. Also, please upgrade WB to latest version i.e 8.0.33 and inform us if problem still exists. Thanks. Regards, Ashwini Patil
[22 Jun 2023 12:44]
MySQL Verification Team
8.0.33 test results
Attachment: 111498_test_results.PNG (image/png, text), 40.10 KiB.
[23 Jun 2023 19:48]
Christian Mosley
I have updated to the latest version and the issue persists. What else can I uninstall and reinstall that could be causing the parser to fail?
Description: The table import wizard fails to parse any .csv or json file. Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_wizard.py", line 131, in start_import retval = self.module.start(self.stop) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_export_be.py", line 300, in start ret = self.start_import() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_power_import_export_be.py", line 687, in start_import self._editor.executeManagementCommand(query, 1) grt.DBError: ('VT13001: [BUG] unexpected statement type: *sqlparser.PrepareStmt', 1105) ERROR: Import data file: ('VT13001: [BUG] unexpected statement type: *sqlparser.PrepareStmt', 1105) Failed How to repeat: Start the table import wizard, pick a table, choose a .csv or json file, set your columns press import and watch it hang. Same error, whether its 40 column table or a 1 column table. ERROR: Import data file: ('VT13001: [BUG] unexpected statement type: *sqlparser.PrepareStmt', 1105)