MFC - _mysql_exceptions.OperationalError

Unanswered Question
May 18th, 2009
User Badges:

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.
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
steven_geerts Tue, 06/02/2009 - 20:56
User Badges:

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

Actions

This Discussion