LinHES Forums :: View topic - R5.5 Upgrade from R5F27

edgar@mythtv:~$ tail -50 /var/log/mythtv/mythbackend.log
Service Location Descriptor (0xa1) length(15)

Channel #2 name(KVPTSD2) 18-3 mod(ATSC 8-VSB) cTSID(0x113)
pnum(2) ETM_loc(0) access_ctrl(0) hidden(0) hide_guide(1) service_type(2) source_id(3)
descriptors length(17) count(1)
Service Location Descriptor (0xa1) length(15)

2008-07-26 16:00:02.002 DB Error (change_program):
Query was:
UPDATE program SET starttime = '2008-07-26T18:29:46', endtime = '2008-07-26T19:00:00' WHERE chanid = 1182 AND starttime = '2008-07-26T18:00:00'
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1182-2008-07-26 18:29:46-0' for key 1

2008-07-26 16:00:02.020 DB Error (change_program):
Query was:
UPDATE program SET starttime = '2008-07-26T19:29:46', endtime = '2008-07-26T20:00:00' WHERE chanid = 1182 AND starttime = '2008-07-26T19:00:00'
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1182-2008-07-26 19:29:46-0' for key 1

2008-07-26 16:00:03.076 TVRec(2): Changing from None to RecordingOnly
2008-07-26 16:00:03.086 TVRec(2): HW Tuner: 2->2
2008-07-26 16:00:03.120 AutoExpire: CalcParams(): Max required Free Space: 3.0 GB w/freq: 15 min
2008-07-26 16:00:03.125 Started recording: Cold Case "Stand Up and Holler": channel 1291 on cardid 2, sourceid 1
2008-07-26 16:00:58.377 JobQueue: Commercial Flagging Starting for Cold Case "Stand Up and Holler" recorded from channel 1291 at Sat Jul 26 16:00:00 2008
2008-07-26 16:00:58.570 Using runtime prefix = /usr
2008-07-26 16:00:58.572 Empty LocalHostName.
2008-07-26 16:00:58.572 Using localhost value of mythtv
2008-07-26 16:00:58.586 New DB connection, total: 1
2008-07-26 16:00:58.590 Connected to database 'mythconverg' at host: localhost
2008-07-26 16:00:58.592 Closing DB connection named 'DBManager0'
2008-07-26 16:00:58.593 Connected to database 'mythconverg' at host: localhost
2008-07-26 16:00:58.597 New DB connection, total: 2
2008-07-26 16:00:58.598 Connected to database 'mythconverg' at host: localhost
2008-07-26 16:00:58.646 Connecting to backend server: 192.168.0.8:6543 (try 1 of 5)
2008-07-26 16:00:58.649 Using protocol version 40
2008-07-26 16:00:58.649 MainServer::HandleAnnounce Monitor
2008-07-26 16:00:58.651 adding: mythtv as a client (events: 0)
2008-07-26 16:00:58.652 MainServer::HandleAnnounce Monitor
2008-07-26 16:00:58.652 adding: mythtv as a client (events: 1)
2008-07-26 16:00:58.850 AFD: Opened codec 0xb3d1dfb0, id(MPEG2VIDEO) type(Video)
2008-07-26 16:00:58.864 AFD: codec AC3 has 2 channels
2008-07-26 16:00:58.866 AFD: Opened codec 0xb3d1e470, id(AC3) type(Audio)
2008-07-26 16:01:03.262 Reschedule requested for id -1.
2008-07-26 16:01:03.266 Invalid search key in recordid 55
2008-07-26 16:01:04.885 Scheduled 820 items in 1.6 = 0.03 match + 1.59 place

Author:	stevenj [ Mon Jul 14, 2008 11:15 pm ]
Post subject:
tjc wrote: Looks like you need to run mythtv-setup on each of your BE machines and define your capture cards... Yeh, this log was from my backend with my 4th tuner and I cleared out and re-entered the tuner list (always end up doing this on upgrades) long before I got around to upgrading this box. But anyway, I just posted this for Human per his request.

Author:	tjc [ Tue Jul 15, 2008 6:58 am ]
Post subject:
Ah! That explains it. It looks like there are several MBE/SBE/FE notes I need to add to the Hints...

Author:	tonymuka [ Sat Jul 26, 2008 1:16 pm ]
Post subject:
I experienced the loop issue too upon auto upgrading from RF27. I also noticed that mythcommflag was using a majority of cpu time while the schema updates were happening, maybe this has to do with it? I have the log if it will help anything. I appreciate this thread and all the tips. Thanks!

Author:	arriflex [ Sat Jul 26, 2008 5:21 pm ]
Post subject:
I noticed the same hang happening, I have a feeling it might have to do with my input card configuration. I need to check my profile and make sure it is accurate. Here's the output from my log while the elipses continue to scroll: Code: edgar@mythtv:~$ tail -50 /var/log/mythtv/mythbackend.log Service Location Descriptor (0xa1) length(15) Channel #2 name(KVPTSD2) 18-3 mod(ATSC 8-VSB) cTSID(0x113) pnum(2) ETM_loc(0) access_ctrl(0) hidden(0) hide_guide(1) service_type(2) source_id(3) descriptors length(17) count(1) Service Location Descriptor (0xa1) length(15) 2008-07-26 16:00:02.002 DB Error (change_program): Query was: UPDATE program SET starttime = '2008-07-26T18:29:46', endtime = '2008-07-26T19:00:00' WHERE chanid = 1182 AND starttime = '2008-07-26T18:00:00' Driver error was [2/1062]: QMYSQL3: Unable to execute query Database error was: Duplicate entry '1182-2008-07-26 18:29:46-0' for key 1 2008-07-26 16:00:02.020 DB Error (change_program): Query was: UPDATE program SET starttime = '2008-07-26T19:29:46', endtime = '2008-07-26T20:00:00' WHERE chanid = 1182 AND starttime = '2008-07-26T19:00:00' Driver error was [2/1062]: QMYSQL3: Unable to execute query Database error was: Duplicate entry '1182-2008-07-26 19:29:46-0' for key 1 2008-07-26 16:00:03.076 TVRec(2): Changing from None to RecordingOnly 2008-07-26 16:00:03.086 TVRec(2): HW Tuner: 2->2 2008-07-26 16:00:03.120 AutoExpire: CalcParams(): Max required Free Space: 3.0 GB w/freq: 15 min 2008-07-26 16:00:03.125 Started recording: Cold Case "Stand Up and Holler": channel 1291 on cardid 2, sourceid 1 2008-07-26 16:00:58.377 JobQueue: Commercial Flagging Starting for Cold Case "Stand Up and Holler" recorded from channel 1291 at Sat Jul 26 16:00:00 2008 2008-07-26 16:00:58.570 Using runtime prefix = /usr 2008-07-26 16:00:58.572 Empty LocalHostName. 2008-07-26 16:00:58.572 Using localhost value of mythtv 2008-07-26 16:00:58.586 New DB connection, total: 1 2008-07-26 16:00:58.590 Connected to database 'mythconverg' at host: localhost 2008-07-26 16:00:58.592 Closing DB connection named 'DBManager0' 2008-07-26 16:00:58.593 Connected to database 'mythconverg' at host: localhost 2008-07-26 16:00:58.597 New DB connection, total: 2 2008-07-26 16:00:58.598 Connected to database 'mythconverg' at host: localhost 2008-07-26 16:00:58.646 Connecting to backend server: 192.168.0.8:6543 (try 1 of 5) 2008-07-26 16:00:58.649 Using protocol version 40 2008-07-26 16:00:58.649 MainServer::HandleAnnounce Monitor 2008-07-26 16:00:58.651 adding: mythtv as a client (events: 0) 2008-07-26 16:00:58.652 MainServer::HandleAnnounce Monitor 2008-07-26 16:00:58.652 adding: mythtv as a client (events: 1) 2008-07-26 16:00:58.850 AFD: Opened codec 0xb3d1dfb0, id(MPEG2VIDEO) type(Video) 2008-07-26 16:00:58.864 AFD: codec AC3 has 2 channels 2008-07-26 16:00:58.866 AFD: Opened codec 0xb3d1e470, id(AC3) type(Audio) 2008-07-26 16:01:03.262 Reschedule requested for id -1. 2008-07-26 16:01:03.266 Invalid search key in recordid 55 2008-07-26 16:01:04.885 Scheduled 820 items in 1.6 = 0.03 match + 1.59 place

Author:	tjc [ Sat Jul 26, 2008 11:29 pm ]
Post subject:
This almost looks like you've got two processes running and trying to add the same record to the DB...

LinHES Forums http://forums.linhes.org/

R5.5 Upgrade from R5F27 http://forums.linhes.org/viewtopic.php?f=1&t=18478	Page 2 of 2

Page 2 of 2	All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/