[mythtv-users] Backend Log - Is this Normal ?

Dave Ansell dave at theansells.com
Thu Mar 24 19:58:14 UTC 2005


I am getting a lot of SQL errors in my backend log.   Is this normal? - it 
is taking up a lot of log space.

They seem to be to do with programme data.  I am using freeview dvb (UK) 
EPG.

Is there something I should be doing to stop these messages?

Example :-

2005-03-12 17:34:51.816 Closing DVB recorder
2005-03-12 17:35:20.009 Reschedule requested for id -1.
2005-03-12 17:35:20.032 Scheduled 0 items in 0.0 = 0.01 match + 0.01 place
DB Error (Adding Event):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,description,subtitle,category,programid,stereo,closecaptioned,hdtv)VALUES 
(1002,'2005-03-16 22:40:00','2005-03-16 23:40:00','Teen Angels','Dr Tanya 
Byron and Dr Stephen Briers step in to help a couple exert some control over 
their unruly teenage sons, but the boys aren''t keen on rules. Strong 
language.','Terrible Twins','arts/culture',63308,1,0,0);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1002-2005-03-16 22:40:00' for key 1

DB Error (Adding Event):
Query was:
INSERT INTO program 
(chanid,starttime,endtime,title,description,subtitle,category,programid,stereo,closecaptioned,hdtv)VALUES 
(1002,'2005-03-16 22:40:00','2005-03-16 23:40:00','Teen Angels','Dr Tanya 
Byron and Dr Stephen Briers step in to help a couple exert some control over 
their unruly teenage sons, but the boys aren''t keen on rules. Strong 
language.','Terrible Twins','arts/culture',63308,1,0,0);
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1002-2005-03-16 22:40:00' for key 1

2005-03-12 17:35:20.284 Reschedule requested for id -1.
2005-03-12 17:35:20.300 Scheduled 0 items in 0.0 = 0.01 match + 0.01 place



More information about the mythtv-users mailing list