Barry,
Basically what is happening is there is a check to make sure that the
number of commbreaks equals the number in the structure. And in your case they
do not, so instead of a segfault we set the number of commbreaks to zero.
Can you do the query into the db and see what you get?
Fill in the ? with correct values from the recording.
Here are some of the values:
m.type in (4,5)
FLOOR (m.mark/30)=FLOOR(s.mark/30)
The commbreak_count=3 gets set by this query: SELECT * FROM recordedmarkup
WHERE chanid = ? AND starttime
= ? AND TYPE IN ( 4 )";
Set the chanid and starttime to the same values as above.
One thing I have noticed is that after the upgrade you need to force the
commskip program to run on all recorded shows.
When mvpmc pulls the commskips in looks into 2 different tables in the DB. In
needs the data from the first table to get the actual data in the second table.
send me the queries and I can take a look.
Mike
----- Original Message ----
> From: Barry McLarnon <[email protected]>
> To: [email protected]
> Sent: Sun, February 14, 2010 4:06:45 PM
> Subject: [Mvpmc-users] Commskip Problem
>
> I recently migrated my MythTV backend server to a new system after the old
> one developed hardware problems. The new system runs MythTV 0.22, while the
> old one ran (I think) 0.20. With the new system, my two MVP boxes play back
> my recordings just fine (I'm using a recent dongle from Mike Drons), except
> that commercial skipping isn't working at all. It does work, however, when I
> run a frontend on the same system as the backend, so the actual flagging and
> database are apparently okay. When I start mvpmc via telnet and enable
> MythTV protocol debugging, I see this:
>
> (cmyth)cmyth_commbreaklist_create
>
>
> (cmyth)cmyth_mysql_get_commbreak_list, query=SELECT
> m.type,m.mark,s.mark,s.offset FROM recordedmarkup m INNER JOIN recordedseek
> AS s ON m.chanid = s.chanid AND m.starttime = s.starttime WHERE m.chanid = ?
> AND m.starttime = ? AND m.type in (?,?) and FLOOR(m.mark/?)=FLOOR(s.mark/?)
> ORDER BY `m`.`mark` LIMIT 300
>
>
> (cmyth)cmyth_mysql_get_commbreak_list: COMMBREAK rows= 0
>
>
> Found 3 commercial breaks for current program.
>
>
> commbreak error. Setting number of commercial breaks to zero
>
>
> (cmyth)cmyth_get_commbreaklist - returned rows=0 commbreak_count=3
>
> So, my question is: what would cause a "commbreak error", and how should I go
> about trying to fix it?
>
> TIA,
>
> Barry
>
> --
> Barry McLarnon Ottawa, ON
>
> ------------------------------------------------------------------------------
> SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> http://p.sf.net/sfu/solaris-dev2dev
> _______________________________________________
> Mvpmc-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mvpmc-users
> mvpmc wiki: http://mvpmc.wikispaces.com/
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
