[mythtv-users] Watching Recordings/Commercial Flagging Problem

Dan Mount bubber-mythtv at bubber.com
Tue Nov 4 01:45:00 UTC 2008


I'm still trying to track this down. 

'tsunami' is my master backend. The sql queries, at least ones that return ip addresses, seem to return the correct values. Live tv works fine.

Any ideas?

Here is the output from /usr/bin/mythcommflag -j 482 -v all:

2008-11-03 20:35:47.808 Using runtime prefix = /usr
2008-11-03 20:35:47.808 Unable to read configuration file mysql.txt
2008-11-03 20:35:47.808 Empty LocalHostName.
2008-11-03 20:35:47.808 Using localhost value of tsunami.newbighouse.com
2008-11-03 20:35:47.809 MCP::DefaultUPnP() - No default UPnP backend
2008-11-03 20:35:47.820 New DB connection, total: 1
2008-11-03 20:35:47.825 Connected to database 'mythconverg' at host: localhost
2008-11-03 20:35:47.825 Closing DB connection named 'DBManager0'
2008-11-03 20:35:47.825 Clearing Settings Cache.
2008-11-03 20:35:47.825 Enabling Settings Cache.
2008-11-03 20:35:47.825 Clearing Settings Cache.
2008-11-03 20:35:47.826 Connected to database 'mythconverg' at host: localhost
2008-11-03 20:35:47.826 MSqlQuery: SELECT type, chanid, starttime FROM jobqueue WHERE id = 482;
2008-11-03 20:35:47.827 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCPU' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.828 MSqlQuery: SELECT commmethod FROM channel WHERE chanid = '2162';
2008-11-03 20:35:47.828 MSqlQuery: SELECT data FROM settings WHERE value = 'CommercialSkipMethod' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.828 MSqlQuery: SELECT data FROM settings WHERE value = 'CommercialSkipMethod' AND hostname IS NULL;
2008-11-03 20:35:47.829 MSqlQuery: SELECT recorded.chanid,starttime,endtime,title, subtitle,description,channel.channum, channel.callsign,channel.name,channel.commmethod, channel.outputfilters,seriesid,programid,filesize, lastmodified,stars,previouslyshown,originalairdate, hostname,recordid,transcoder,playgroup, recorded.recpriority,progstart,progend,basename,recgroup, storagegroup FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recorded.chanid = '2162' AND starttime = '20081102163000' ;
2008-11-03 20:35:47.830 New DB connection, total: 2
2008-11-03 20:35:47.831 Connected to database 'mythconverg' at host: localhost
2008-11-03 20:35:47.831 MSqlQuery: SELECT commflagged, cutlist, autoexpire, editing, bookmark, watched, preserve FROM recorded LEFT JOIN recordedprogram ON (recorded.chanid = recordedprogram.chanid AND recorded.progstart = recordedprogram.starttime) WHERE recorded.chanid = '2162' AND recorded.starttime = '2008-11-02T16:30:00' ;
2008-11-03 20:35:47.832 MSqlQuery: SELECT audioprop+0, videoprop+0, subtitletypes+0 FROM recorded LEFT JOIN recordedprogram ON (recorded.chanid = recordedprogram.chanid AND recorded.progstart = recordedprogram.starttime) WHERE recorded.chanid = '2162' AND recorded.starttime = '2008-11-02T16:30:00' ;
2008-11-03 20:35:47.833 MSqlQuery: SELECT basename FROM recorded WHERE chanid = '2162' AND       starttime = '2008-11-02T16:30:00';
2008-11-03 20:35:47.833 MSqlQuery: SELECT data FROM settings WHERE value = 'AlwaysStreamFiles' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.834 MSqlQuery: SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'Default'
2008-11-03 20:35:47.834 SG(Default): FindRecordingFile: Searching for '2162_20081102163000.mpg'
2008-11-03 20:35:47.834 SG(Default): FindRecordingDir: Checking '/mnt/tv'
2008-11-03 20:35:47.834 SG(Default): FindRecordingFile: Found '/mnt/tv/2162_20081102163000.mpg'
2008-11-03 20:35:47.834 ProgramInfo: GetPlaybackURL: File is local: '/mnt/tv/2162_20081102163000.mpg'
2008-11-03 20:35:47.834 RingBuf(/mnt/tv/2162_20081102163000.mpg): OpenFile(/mnt/tv/2162_20081102163000.mpg, 12)
2008-11-03 20:35:47.834 RingBuf(/mnt/tv/2162_20081102163000.mpg): CalcReadAheadThresh(168445136 KB)
			 -> threshhold(64 KB) min read(0 KB) blk size(32 KB)
2008-11-03 20:35:47.845 MSqlQuery: SELECT data FROM settings WHERE value = 'VbiFormat' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.846 MSqlQuery: SELECT data FROM settings WHERE value = 'VbiFormat' AND hostname IS NULL;
2008-11-03 20:35:47.846 MSqlQuery: DELETE FROM inuseprograms WHERE chanid = '2162' AND starttime = '2008-11-02T16:30:00' AND hostname = 'tsunami.newbighouse.com' AND recusage = 'flagger' ;
2008-11-03 20:35:47.847 MSqlQuery: INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname, lastupdatetime,  rechost, recdir )  VALUES  ('2162', '2008-11-02T16:30:00', 'flagger', 'tsunami.newbighouse.com', '2008-11-03T20:35:47',  'tsunami.newbighouse.com', '.');
2008-11-03 20:35:47.847 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.848 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL;
2008-11-03 20:35:47.848 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.849 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL;
2008-11-03 20:35:47.849 MythSocket(a0eba98:6): new socket
2008-11-03 20:35:47.849 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.850 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname IS NULL;
2008-11-03 20:35:47.850 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.851 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname IS NULL;
2008-11-03 20:35:47.851 Connecting to backend server: 10.69.69.201:6543 (try 1 of 5)
2008-11-03 20:35:47.851 MythSocket(a0e7620:7): new socket
2008-11-03 20:35:47.851 MythSocket(a0e7620:7): attempting connect() to (10.69.69.201:6543)
2008-11-03 20:35:47.852 MythSocket(a0e7620:7): state change Idle -> Connected
2008-11-03 20:35:47.852 write ->  7 21      MYTH_PROTO_VERSION 40
2008-11-03 20:35:47.852 read  <-  7 13      ACCEPT[]:[]40
2008-11-03 20:35:47.852 Using protocol version 40
2008-11-03 20:35:47.852 write ->  7 37      ANN Monitor tsunami.newbighouse.com 0
2008-11-03 20:35:47.860 read  <-  7 2       OK
2008-11-03 20:35:47.860 MythSocket(a0eba98:6): attempting connect() to (10.69.69.201:6543)
2008-11-03 20:35:47.861 MythSocket(a0eba98:6): state change Idle -> Connected
2008-11-03 20:35:47.861 write ->  6 37      ANN Monitor tsunami.newbighouse.com 1
2008-11-03 20:35:47.863 read  <-  6 2       OK
2008-11-03 20:35:47.863 MythSocket(a0eba98:6): UpRef: 1
2008-11-03 20:35:47.863 write ->  7 33      MESSAGE[]:[]RECORDING_LIST_CHANGE
2008-11-03 20:35:47.864 MythSocket: readyread thread start
2008-11-03 20:35:47.864 read  <-  7 2       OK
2008-11-03 20:35:47.864 MythSocket(a0eba98:6): socket is readable
2008-11-03 20:35:47.865 MythSocket(a0eba98:6): cb->readyRead()
2008-11-03 20:35:47.865 read  <-  6 51      BACKEND_MESSAGE[]:[]RECORDING_LIST_CHANGE[]:[]empty
2008-11-03 20:35:47.865 MythEvent: RECORDING_LIST_CHANGE
2008-11-03 20:35:47.865 MSqlQuery: SELECT data FROM settings WHERE value = 'CommRewindAmount' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.866 MSqlQuery: SELECT data FROM settings WHERE value = 'CommNotifyAmount' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.866 MSqlQuery: SELECT data FROM settings WHERE value = 'CommNotifyAmount' AND hostname IS NULL;
2008-11-03 20:35:47.867 MSqlQuery: SELECT data FROM settings WHERE value = 'DecodeExtraAudio' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.867 MSqlQuery: SELECT data FROM settings WHERE value = 'EnableMHEG' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.868 MSqlQuery: SELECT data FROM settings WHERE value = 'Prefer708Captions' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.868 MSqlQuery: SELECT data FROM settings WHERE value = 'VBIpageNr' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.869 MSqlQuery: SELECT data FROM settings WHERE value = 'VBIpageNr' AND hostname IS NULL;
2008-11-03 20:35:47.869 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBorder' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.870 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBorder' AND hostname IS NULL;
2008-11-03 20:35:47.870 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBlankFrameMaxDiff' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.871 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBlankFrameMaxDiff' AND hostname IS NULL;
2008-11-03 20:35:47.871 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDarkBrightness' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.871 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDarkBrightness' AND hostname IS NULL;
2008-11-03 20:35:47.872 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDimBrightness' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.872 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDimBrightness' AND hostname IS NULL;
2008-11-03 20:35:47.873 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBoxBrightness' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.873 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBoxBrightness' AND hostname IS NULL;
2008-11-03 20:35:47.874 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDimAverage' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.874 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectDimAverage' AND hostname IS NULL;
2008-11-03 20:35:47.874 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMaxCommBreakLength' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.875 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMaxCommBreakLength' AND hostname IS NULL;
2008-11-03 20:35:47.875 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMinCommBreakLength' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.876 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMinCommBreakLength' AND hostname IS NULL;
2008-11-03 20:35:47.876 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMinShowLength' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.877 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMinShowLength' AND hostname IS NULL;
2008-11-03 20:35:47.877 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMaxCommLength' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.877 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectMaxCommLength' AND hostname IS NULL;
2008-11-03 20:35:47.878 MSqlQuery: SELECT data FROM settings WHERE value = 'CommSkipAllBlanks' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.878 MSqlQuery: SELECT data FROM settings WHERE value = 'CommSkipAllBlanks' AND hostname IS NULL;
2008-11-03 20:35:47.879 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBlankCanHaveLogo' AND hostname = 'tsunami.newbighouse.com' ;
2008-11-03 20:35:47.879 MSqlQuery: SELECT data FROM settings WHERE value = 'CommDetectBlankCanHaveLogo' AND hostname IS NULL;
2008-11-03 20:35:47.880 MSqlQuery: SELECT id FROM jobqueue WHERE chanid = '2162' AND starttime = '2008-11-02T16:30:00' AND type = 2;
2008-11-03 20:35:47.880 mythcommflag processing JobID 482
2008-11-03 20:35:47.880 MSqlQuery: UPDATE recorded SET commflagged = 2 WHERE chanid = '2162' AND starttime = '2008-11-02T16:30:00' ;
2008-11-03 20:35:47.880 mythcommflag sending COMMFLAG_START notification
2008-11-03 20:35:47.881 write ->  7 51      MESSAGE[]:[]COMMFLAG_START 2162 2008-11-02T16:30:00
2008-11-03 20:35:47.881 MythSocket(a0eba98:6): socket is readable
2008-11-03 20:35:47.882 MythSocket(a0eba98:6): cb->readyRead()
2008-11-03 20:35:47.882 read  <-  6 69      BACKEND_MESSAGE[]:[]COMMFLAG_START 2162 2008-11-02T16:30:00[]:[]empty
2008-11-03 20:35:47.882 MythEvent: COMMFLAG_START 2162 2008-11-02T16:30:00
2008-11-03 20:35:47.882 read  <-  7 2       OK
2008-11-03 20:35:47.882 JobQueue: ChangeJobStatus(482, Running, 'Building Head Start Buffer')
2008-11-03 20:35:47.883 MSqlQuery: UPDATE jobqueue SET status = 4, comment = 'Building Head Start Buffer' WHERE id = 482;
2008-11-03 20:35:47.883 NVP: OpenFile() Warning, old player exited before new ring buffer created. 
			RingBuffer will use filename 'output.nuv'.
			m_playbackinfo filename is 2162_20081102163000.mpg
2008-11-03 20:35:47.883 RingBuf(output.nuv): OpenFile(output.nuv, 4)
2008-11-03 20:35:47.883 MythSocket(a0e72d0:10): new socket
2008-11-03 20:35:47.883 MythSocket(a0e72d0:10): attempting connect() to (0.0.0.0:65535)
2008-11-03 20:35:47.883 MythSocket(a0e72d0:10): connect() failed (ConnectionRefused)
2008-11-03 20:35:47.883 RemoteFile::openSocket(control socket): 
			Could not connect to server "" @ port -1
2008-11-03 20:35:47.884 MythSocket(a0e72d0:10): DownRef: -1
2008-11-03 20:35:47.884 MythSocket(a0e72d0:-1): delete socket
2008-11-03 20:35:47.884 MythSocket(a0e72d0:10): new socket
2008-11-03 20:35:47.884 MythSocket(a0e72d0:10): attempting connect() to (0.0.0.0:65535)
2008-11-03 20:35:47.884 MythSocket(a0e72d0:10): connect() failed (ConnectionRefused)
2008-11-03 20:35:47.884 RemoteFile::openSocket(file data socket): 
			Could not connect to server "" @ port -1
2008-11-03 20:35:47.884 MythSocket(a0e72d0:10): DownRef: -1
2008-11-03 20:35:47.884 MythSocket(a0e72d0:-1): delete socket
2008-11-03 20:35:47.884 RingBuffer::RingBuffer(): Failed to open remote file (output.nuv)
2008-11-03 20:35:47.884 RingBuf(output.nuv): CalcReadAheadThresh(168735744 KB)
			 -> threshhold(64 KB) min read(0 KB) blk size(32 KB)
2008-11-03 20:35:47.884 NVP::OpenFile(): Error, file not found: output.nuv
2008-11-03 20:35:47.885 MSqlQuery: UPDATE recorded SET commflagged = 0 WHERE chanid = '2162' AND starttime = '2008-11-02T16:30:00' ;
2008-11-03 20:35:47.885 MSqlQuery: DELETE FROM inuseprograms WHERE chanid = '2162' AND starttime = '2008-11-02T16:30:00' AND hostname = 'tsunami.newbighouse.com' AND recusage = 'flagger' ;
2008-11-03 20:35:47.886 write ->  7 33      MESSAGE[]:[]RECORDING_LIST_CHANGE
2008-11-03 20:35:47.886 MythSocket(a0eba98:6): socket is readable
2008-11-03 20:35:47.886 MythSocket(a0eba98:6): cb->readyRead()
2008-11-03 20:35:47.887 read  <-  6 51      BACKEND_MESSAGE[]:[]RECORDING_LIST_CHANGE[]:[]empty
2008-11-03 20:35:47.887 MythEvent: RECORDING_LIST_CHANGE
2008-11-03 20:35:47.887 read  <-  7 2       OK


-----Original Message-----
From: "Dan Mount" <bubber-mythtv at bubber.com>
Sent: Sunday, November 2, 2008 6:50pm
To: mythtv-users at mythtv.org
Subject: [mythtv-users] Watching Recordings/Commercial Flagging Problem

When I try to watch recordings on any front end, or a backend trys to flag commercials, I get an error.

I updated my systems to the latest from atrpms and can't watch recordings now. I've posted the log and version output below...

My master backend has two tuners and runs commercial flag jobs only. I have a second backend that has no tuners and it runs commercial flag and transcode jobs. The second backend shares the recorded directory with the master and mounts it via nfs.

---

SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL;
Does return my master backend IP successfully.

---

Error in mythbackend.log
---
2008-11-02 18:30:50.315 NVP: OpenFile() Warning, old player exited before new ring buffer created. 
                        RingBuffer will use filename 'output.nuv'.
                        m_playbackinfo filename is 2048_20081102180000.mpg
2008-11-02 18:30:50.318 RemoteFile::openSocket(control socket): 
                        Could not connect to server "" @ port -1
2008-11-02 18:30:50.321 RemoteFile::openSocket(file data socket): 
                        Could not connect to server "" @ port -1
2008-11-02 18:30:50.323 RingBuffer::RingBuffer(): Failed to open remote file (output.nuv)
2008-11-02 18:30:50.325 NVP::OpenFile(): Error, file not found: output.nuv

---

Output from mythbackend --version
---
Please include all output in bug reports.
MythTV Version   : 18753M
MythTV Branch    : branches/release-0-21-fixes
Library API      : 0.21.20080304-1
Network Protocol : 40
Options compiled in:
 linux release using_oss using_alsa using_arts using_jack using_backend using_dbox2 using_dvb using_firewire using_frontend using_hdhomerun using_iptv using_ivtv using_joystick_menu using_libfftw3 using_lirc using_opengl_vsync using_opengl_video using_v4l using_x11 using_xrandr using_xv using_xvmc using_xvmcw using_xvmc_vld using_glx_proc_addr_arb using_bindings_perl using_bindings_python using_opengl using_ffmpeg_threads using_libavc_5_3 using_live


Thanks for any help.. What other information can I provide?

Dan


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users




More information about the mythtv-users mailing list