Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#4019 closed defect (fixed)

mythcommflag gives database error when rebuilding the seektable for a file

Reported by: anonymous Owned by: cpinkham
Priority: minor Milestone: 0.21
Component: mythtv Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

MythTV Commercial Flagger, started at Wed Sep 26 19:38:06 2007

Rebuilding SeekTable?(s) for:
ChanID Start Time Title Status

------ -------------- ----------------------------------------- ------


2007-09-26 19:38:06.258 New DB connection, total: 2 1052 20070702235500 Robot Chicken 2007-09-26


19:38:06.332 DB Error (SetInUse?):

Query was:


INSERT INTO inuseprograms (chanid, starttime, recusage, hostname, lastupdatetime, rechost, recdir ) VALUES ('1052', '2007-07-02T23:55:00', 'flagger', 'notivo', '2007-09-26T19:38:06', 'notivo', NULL);


Driver error was [2/1048]:


QMYSQL3: Unable to execute query


Database error was:


Column 'recdir' cannot be null


2007-09-26 19:38:06.334 Using protocol version 36


99%/ 2344fpsRebuilt


Finished commercial break flagging at Wed Sep 26 19:38:22 2007

Change History (3)

comment:1 Changed 12 years ago by cpinkham

Owner: changed from Isaac Richards to cpinkham

comment:2 Changed 12 years ago by cpinkham

Resolution: fixed
Status: newclosed

(In [14546]) Modify ProgramInfo::MarkAsInUse? so that it follows symlinks trying to find the actual directory that is in use. Loosely based on a patch by David Madsen.

I believe this closes #3865 and #4019. If these issues reoccur, I will need more info to debug.

comment:3 Changed 12 years ago by rbonafied

I rebuilt using this patch and the error went away. All is good.

Note: See TracTickets for help on using tickets.