[mythtv-users] New York PBS WNET channel 13 pid mess

[Tom Dexter]

On Sat, Jun 21, 2014 at 2:03 AM, Tom Dexter <digitalaudiorock at gmail.com> wrote:

Here's a little more on those channels before and after the rescan:

select chanid, channum, sourceid, callsign, xmltvid, atsc_major_chan,
atsc_minor_chan, freqid from channel where channum like '13%'
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+
| chanid | channum | sourceid | callsign | xmltvid | atsc_major_chan |
atsc_minor_chan | freqid |
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+
|   1131 | 13.1    |        1 | WNET-HD  | 26182   |              13 |
              1 | 13     |
|   1132 | 13.2    |        1 | WNET-SD  | 31780   |              13 |
              2 | 13     |
|   1133 | 13.3    |        1 | WNET-13  | 44667   |              13 |
              3 | 13     |
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+

select chanid, channum, sourceid, callsign, xmltvid, atsc_major_chan,
atsc_minor_chan, freqid from channel where channum like '13%'
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+
| chanid | channum | sourceid | callsign | xmltvid | atsc_major_chan |
atsc_minor_chan | freqid |
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+
|   1132 | 13.1    |        1 | WNET-HD  | 31780   |              13 |
              1 | 13     |
|   1133 | 13.2    |        1 | KIDS     | 44667   |              13 |
              2 | 13     |
|   1131 | 13.3    |        1 | V-Me     | 26182   |              13 |
              3 | 13     |
+--------+---------+----------+----------+---------+-----------------+-----------------+--------+

Now that I've thought about this a bit more, I'm tempted to try and
actaully juggle the chanids back to what they were (with the backend
stopped).  I know that'll take a little jumping though hoops because
it's the primary key (changing things to temporary unused ids etc),
but it occurred to me that things like oldrecorded still have the
original ids...that is where 1131=13.1, and I don't want stuff
happening like re-runs recording etc.  For now I have all rules for
this channel deleted anyway.

I'd like to understand exactly what happened there in any case.  What
does the channel scan use to find an existing channel based on a
specific multi-plex within that transport?  The freqid and mplexid etc
are all the same.

What an ugly fricking mess.

Tom