Bug #112602 Workbench crashes upon data export
Submitted: 3 Oct 14:17 Modified: 4 Nov 12:58
Reporter: Hassan Tauqer Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.34 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: MySQL Verification Team CPU Architecture:x86
Tags: WBBugReporter

[3 Oct 14:17] Hassan Tauqer
I export data weekly off of Workbench. I am facing an issue since a couple of weeks where, whenever i export a CSV, the application goes into not responding. When i open the exported file, it does not include all the records.  Sometimes 15000/37000,  sometimes 6000/37000 etc. 

Killing the task and repeating it brings up the same issue.

How to repeat:
Open any table/view. 

Export the records as a CSV.

App has crashed and exported records are incomplete.

Suggested fix:
Updated Workbench to 8.0.34

Kill task from task manager. hoping to fix it.
[3 Oct 14:20] Hassan Tauqer
Changed severity
[4 Oct 12:58] MySQL Verification Team
Hello Hassan,

Thank you for the bug report.
After reviewing the log file attached, noted below errors.

View 'trackerdb.v_powerbi_commissiondetail_with_postal_codes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Can't parse <ENTRY timestamp='12:34:37'>SELECT * FROM trackerdb.sales_adjustment WHERE destination_city = 'SEABOARD FARMS INC ?GUYMON'</ENTRY>, of file: C:\Users\HassanTauqer\AppData\Roaming\MySQL\Workbench\sql_history\2022-10-17
09:11:14 [ERR][SQL Editor Form]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'htauqer'@'' for table 'events_statements_current'
09:11:14 [ERR][SQL Editor Form]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'htauqer'@'' for table 'events_stages_history_long'
09:11:14 [ERR][SQL Editor Form]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'htauqer'@'' for table 'events_waits_history_long'

Please provide the necessary permissions to above tables and try again. Thanks.

Ashwini Patil
[5 Nov 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".