Statement Cancelled Due to Client Request Error
I have a report that was working fine through yesterday and now I get a generic exception in yellowfin that says:
Error retrieving resultsAn error occurred retrieving the results from the database. Please check the SQL syntax and try again.
I thought it might be a timeout but it does it after 2 or 3 minutes and the report has always been taking that long. I had my DBA run the resulting query against the DB and it returns fine.
Here's what I see in the log:
YF:2017-07-20 17:15:30:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.MySQLStatementCancelledException: Statement cancelled due to client request