MFC - _mysql_exceptions.OperationalError

Andreas Krueger · ‎05-18-2009

I have problems running a scheduled report in MFC 1.4.0


An error has occured:

The following report(s) failed during their scheduled run time:

'Volume Report by Domain' - Due to error: _mysql_exceptions.OperationalError - (1213, 'Deadlock found when trying to get lock; try restarting transaction')

Hostname: <hostname>
Version : Version 1.4.0 (107)

What means the "deadlock"-error ?
I already changed the running times of all reports - only one report runs at the same time.

There is more than enough space on all harddrives and I have 8 GB RAM.

Thanks for help.

steven_geerts · ‎06-02-2009

Hello,

In the fancy world of the DBA's a deadlock normally means that two (or more) queries are waiting on each other's results, thus can not proceed. The DB engine detects this and stops both queries to prevent it selves from dying a painful death.
Why this is happening within MFC report generation is something Ironport Support can explain (if MFC is still supported)

Good luck,

Steven