Opened 15 years ago

Closed 15 years ago

#628 closed defect (fixed)

DB error message on quick restart during pre-recording

Reported by: mythtv@… Owned by: Isaac Richards
Priority: trivial Milestone: unknown
Component: mythtv Version:
Severity: low Keywords:
Cc: Ticket locked: no


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).

Change History (1)

comment:1 Changed 15 years ago by mythtv@…

Resolution: fixed
Status: newclosed

Given the error message, very likely fixed by [7892] as part of fix for #650. Will reopen if observe again.

Note: See TracTickets for help on using tickets.