Opened 18 years ago
Closed 18 years ago
#628 closed defect (fixed)
DB error message on quick restart during pre-recording
Reported by: | Owned by: | Isaac Richards | |
---|---|---|---|
Priority: | trivial | Milestone: | unknown |
Component: | mythtv | Version: | |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
At 22:59:58, mythtv started to record The Daily Show. It was brought down for an upgrade shortly thereafter. At 23:00:08, it was restarted, restarting the recording. Upon restart, it started recording The Daily Show again (correctly). However, I got the following error:
2005-11-09 23:00:12.322 DB Error (WriteRecordedToDB): Query was: INSERT INTO recorded (chanid,starttime,endtime,title, subtitle,description,hostname,category,recgroup, autoexpire,recordid,seriesid,programid,stars, previouslyshown,originalairdate,findid,transcoder, timestretch,recpriority,basename,progstart,progend) VALUES('1038','2005-11-09T23:00:00','2005-11-09T23:30:00','The Daily Show With Jon Stewart','','Actress Keira Knightley.', 'myth','Talk','Default',1,17, 'SH293053','EP2930530826',0,0,'2005-11-09', 0,0,1,0, '1038_20051109230000.mpg','2005-11-09T23:00:00','2005-11-09T23:30:00'); Driver error was [2/1062]: QMYSQL3: Unable to execute query Database error was: Duplicate entry '1038-2005-11-09 23:00:00' for key 1
Not certain why this happened. It overwrote the super-short mpg that it had created.
From my perspective, I didn't do anything wrong, but I wanted to record this backend behavior in case it was indicative of something more problematic (besides probably needing cleaned-up).
Note: See
TracTickets for help on using
tickets.
Given the error message, very likely fixed by [7892] as part of fix for #650. Will reopen if observe again.