My client site has huge data, which they want to download into CSV through View data export module, when multiple users are trying to download the csv file, its resulting in an error.
In log messages I can see error like-
PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction:
When I am trying to see my innodb status through: mysqlengine innodb status\G; its showing deadlock for insert into cache table.
Can anyone help in this?