Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#11773 closed Bug Report - General (fixed)

BE ocassionally reports DB Error (QueryAverageAspectRatio)

Reported by: warpme@… Owned by: David Engel <dengel@…>
Priority: minor Milestone: 0.27
Component: MythTV - General Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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.

Attachments (1)

be.log (138.9 KB) - added by warpme@… 6 years ago.
BE log

Download all attachments as: .zip

Change History (3)

Changed 6 years ago by warpme@…

Attachment: be.log added

BE log

comment:1 Changed 6 years ago by David Engel <dengel@…>

Owner: set to David Engel <dengel@…>
Resolution: fixed
Status: newclosed

comment:2 Changed 6 years ago by gigem

Milestone: unknown0.27
Note: See TracTickets for help on using tickets.