[mythtv-users] Re: [mythtv] Bug inserting recordings into 'recorded' database with cvs from 13/oct/04

[Aaron Robertson-Hodder]

Hi,

 

I am having the same problem described below. 

 

Slave backend errors when inserting into recorded and oldrecorded.
Running .16 CVS from about the same time.

 

Did you get this fixed? Does anyone know the answer?

 

Thanks.

 

 

Mark Wrote:

 

Hi all, 

(switched to the user list as it seems to be a problem more related to 
my setup) 

On Wed, 2004-10-13 at 23:39, Mark Cooke wrote: 
> Hi all, 
> 
> I upgraded my setup with current CVS code today, and since then after
a 
> recording starts, I have been getting the following from the backend: 
> 
> DB Error (WriteRecordedToDB): 
> Query was: 
> INSERT INTO recorded 
>
(chanid,starttime,endtime,title,subtitle,description,hostname,category,r
ecgroup,autoexpire,recordid,seriesid,programid,stars,previouslyshown,ori
ginalairdate)
VALUES(:CHANID,:STARTS,:ENDS,:TITLE,:SUBTITLE,:DESC,:HOSTNAME,:CATEGORY,
:RECGROUP,:AUTOEXP,:RECORDID,:SERIESID,:PROGRAMID,:STARS,:REPEAT,:ORIGAI
RDATE); 
> Driver error was [2/1048]: 
> QMYSQL3: Unable to execute query 
> Database error was: 
> Column 'seriesid' cannot be null 
> 
> Recordings are written to disk correctly, but they don't appear in the

> recorded programmes list. 

An update: 

The SQL error also happens for the oldrecorded table with DB Error 
(addHistory), showing the same error that seriesid cannot be null. 

It only appears to happen with my remote backend. Recordings on the 
local backend appear in the table as expected. The entry in the 
recorded table shows 'seriesid' as an empty string for these successful 
recordings. 

The other differences are that the remote backend has 2 x PVR-x50 cards,

and the local backend has a bt8x8 V4L device. 


I've tried dropping all entries in the 'program' table, and re-running 
mythfilldatabase with the latest tv_grab_rt_uk instead of 
tv_grab_uk_bleb. I wasn't particularly expecting this to help, and it 
didn't. 

This issue is still present for my setup in today's CVS. 

Best regards, 

Mark 


More information on my setup: 

Machine 'gw', 10.2.3.1, front+backend+mysql, 1 x bt8x8, 2.6.8-1 
Machine 'tv', 10.2.3.150, backend, 2 x ivtv, nfsroot 2.4.26 

Both are running the same cvs release of mythtv, fedora core 2. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20041029/b6a42581/attachment.html