BE ocassionally reports DB Error (QueryAverageAspectRatio)

[warpme@…]

Hi, 2 days ago I upgraded to current master and launch stress tests to test is system ready to production (series of 16x concurrent HD recordings, etc). Durring tests already I saw following error in BE log:

2013-08-23 11:15:01.030544 I  Finished recording 32 (Kuchnia+ HD) "2013-08-23 11:00:00": channel 21511
 2013-08-23 11:15:01.270309 E  DB Error (QueryAverageAspectRatio):
 Query was:
 SELECT recordedmarkup.type FROM recordedmarkup WHERE recordedmarkup.chanid    = ?    AND       recordedmarkup.starttime = ? AND       recordedmarkup.type      >= ? AND       recordedmarkup.type      <= ? GROUP BY recordedmarkup.type ORDER BY SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark)                FROM recordedmarkup AS rm                 WHERE rm.chanid    = recordedmarkup.chanid    AND                       rm.starttime = recordedmarkup.starttime AND                       rm.type      = recordedmarkup.type      AND                       rm.mark      > recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1               ) - recordedmarkup.mark             ) DESC LIMIT 1
 Bindings were:
 :ASPECTEND=14, :ASPECTSTART=11, :CHANID=11110, :STARTTIME=2013-08-23T09:00:00Z
 No error type from QSqlError?  Strange...
 2013-08-23 11:15:01.270412 E  DB Error (QueryAverageAspectRatio):
 Query was:
 SELECT recordedmarkup.type FROM recordedmarkup WHERE recordedmarkup.chanid    = ?    AND       recordedmarkup.starttime = ? AND       recordedmarkup.type      >= ? AND       recordedmarkup.type      <= ? GROUP BY recordedmarkup.type ORDER BY SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark)                FROM recordedmarkup AS rm                 WHERE rm.chanid    = recordedmarkup.chanid    AND                       rm.starttime = recordedmarkup.starttime AND                       rm.type      = recordedmarkup.type      AND                       rm.mark      > recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1               ) - recordedmarkup.mark             ) DESC LIMIT 1
 Bindings were:
 :ASPECTEND=14, :ASPECTSTART=11, :CHANID=11103, :STARTTIME=2013-08-23T09:00:00Z
 No error type from QSqlError?  Strange...
 2013-08-23 11:15:02.273076 I  Updating status for "46 (HBO Comedy HD)":"2013-08-23 11:00:00" on cardid 19 (Nagrywam => Nagrane)

I saw those errors independently on my stress tests but they are more frequent during tests. Full BE log attached.

[warpme@…]

BE log

[David Engel <dengel@…>]

In 38aba3d036729812546c891c551a26ec1c4c19dc/mythtv:

Fix spurious error message in PI::QueryAverageAspectRati?()

Fixes #11773