Database errors

[tvdave]

Can someone please tell me what the backend is trying to tell me. I noticed these errors appear

2014-07-29 15:07:36.132995 E [65/11779] EIT mythdb.cpp:183 (DBError) - DB Error (programrating insert):
Query was:
INSERT INTO programrating ( chanid, starttime, system, rating) VALUES (?, ?, ?, ?)
Bindings were:
:CHANID=1072, :RATING="PG", :START=2014-07-29T06:05:20Z, :SYS=""
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1072-2014-07-29 06:05:20--PG' for key 'chanid'

I restarted the backend and the error has gone... clearly not the best fix.

Also a scheduled recording failed. The log around the time is as follows

Also a recording failed - the log around the time is as follows
2014-07-29 02:01:21.228268 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 1 2014-07-28T16:30:00Z EITScanner
2014-07-29 02:01:21.549527 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 4 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:02:27.119063 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 5 2014-07-28T16:26:02Z EITScanner
2014-07-29 02:02:27.440557 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:02:27.440595 I [65/12035] Scheduler mythdbcon.cpp:409 (PurgeIdleConnections) - New DB connection, total: 10
2014-07-29 02:06:27.280109 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 2 2014-07-28T17:00:00Z EITScanner
2014-07-29 02:06:27.608958 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:07:54.391568 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 1 2014-07-28T16:37:45Z EITScanner
2014-07-29 02:07:54.723749 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:08:58.470760 N [65/12291] Expire autoexpire.cpp:264 (CalcParams) - AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2014-07-29 02:11:33.315831 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 3 2014-08-04T19:30:00Z EITScanner
2014-07-29 02:11:33.640924 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:16:39.535158 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 4 2014-08-04T23:30:00Z EITScanner
2014-07-29 02:16:39.864195 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place
2014-07-29 02:21:45.680605 I [65/12035] Scheduler scheduler.cpp:2099 (HandleReschedule) - Reschedule requested for MATCH 0 1 5 2014-07-28T17:53:03Z EITScanner
2014-07-29 02:21:46.012818 I [65/12035] Scheduler scheduler.cpp:2212 (HandleReschedule) - Scheduled 5 items in 0.0 = 0.00 match + 0.00 check + 0.00 place

Any ideas?

[pvr4me]

I don't think the database error is an OS X issue--perhaps a mod could move this post to Troubleshooting. Or maybe the United Kingdom section as it appears to occur during EIT processing.

Regarding the other log snippet, I think that may also be related to EIT processing. EIT is feeding 'new' program listings data to Myth every 1-5 minutes and that triggers a re-schedule. Not an error; just keeping up to date.

I imagine people who know UK EIT will want to know which service/channels you're receiving.

Craig