MythTV vs BBC Radio multiplex changes
The BBC have rejigged their DVB-T configuration, with the result that, as of Wednesday, Radios 1 through 4 stopped working. They did broadcast warnings in advance, explaining how to rescan channels to continue to receive those stations. As is often the case, doing things with MythTV turned out to be a little more complicated than with bog-standard consumer receivers. I can’t be the only person to have been affected, and I hope that this solution will help.
On Wednesday, as predicted, my MythTV box could no longer receive Radio 4. I fired up mythtv-setup and rescanned the available channels. It found Radio 4 and the rest, and everything looked fine. But when I tried to tune to any of the channels, it didn’t work. I’d see (L_S) Partial Lock in the tuning window, followed after a few seconds by the tuning timeout message. A partial lock can be caused by a poor signal, but I have an exceptionally good signal here, and the statistics were showing a signal strength of 94%—so it couldn’t be that.
I wondered whether the transmission changes had resulted in an incompatibility with MythTV. I wondered whether I should upgrade my installation. I even started looking at the prices of new hardware online with a view to building a better, faster, smaller, quieter MythTV box.
In the meantime, I let it lie, and grabbed the radio programmes I’d missed via the Listen Again service (using a combination of MPlayer and LAME to rip and transcode the useless streaming Real audio to MP3s).
This evening, I came across a more helpful technical explanation of the changes:
BBC Radio 1, 2, 3, 4 on Freeview (digital terrestrial television)
On the morning of Wednesday 3 October, following the installation of new equipment, BBC Radio 1, 2, 3 and 4 on Freeview moved into the same space as the other BBC radio services – from multiplex A to multiplex B. Channel numbers have not changed, but you will need to rescan your Freeview receiver to make sure you can continue to hear these networks – see your instruction manual or our advice on rescanning your receiver. No other services or other platforms are affected.
That gave me somewhere to start, so I SSH’d in and had a peek at the channel table in MythTV’s database. (Incidentally, this has an exceptionally confused database schema with no consistent naming strategy.)
mysql -umythtv -p mythconverg
mysql> select * from channel where name like '%Radio 4%' \G
There were two entries for Radio 4. That couldn’t be right! What’s more, they were pointing at different multiplexes. In my case, that was multiplex IDs 3 and 4. The obvious hypothesis was that the old channel entries hadn’t been deleted or replaced by the new ones, and were being selected in preference to the newer ones by the backend software.
Using the useful hint from the quote above, that all the BBC stations were now on the same multiplex, it was easy enough to work it out.
mysql> select channum, name, mplexid from channel where channum >= 700 and channum < 706; +---------+-------------+---------+ | channum | name | mplexid | +---------+-------------+---------+ | 705 | BBC R5 Live | 4 | | 701 | 1Xtra BBC | 4 | | 700 | BBC Radio 1 | 3 | | 702 | BBC Radio 2 | 3 | | 703 | BBC Radio 3 | 3 | | 704 | BBC Radio 4 | 3 | | 700 | BBC Radio 1 | 4 | | 702 | BBC Radio 2 | 4 | | 703 | BBC Radio 3 | 4 | | 704 | BBC Radio 4 | 4 | +---------+-------------+---------+ 8 rows in set (0.00 sec)
BBC R5 Live and 1Xtra BBC appeared once on multiplex ID 4, whilst the other stations appeared twice each, on multiplex IDs 3 and 4. Multiplex ID 4 was therefore the correct one.
Before proceeding, I took a quick backup dump of the database.
mysqldump -umythtv -p mythconverg | gzip > mythconverg.gz.sql
I then deleted the bogus channel entries:
mysql> delete from channel where channum >= 700 and channum < 706 and mplexid=3;
After restarting mythbackend, Radios 1 to 4 worked once more!
I know that MythTV handles the case when a station on a multiplex changes, because it successfully picked up the change when Virgin 1 replaced FTN earlier this week, but it doesn’t appear to expect a station to shift multiplexes, and doesn’t know to remove the old entry when this happens. It shouldn’t be a hard problem to solve.
I love MythTV for what it does—on a good day, it can do stuff that the commercial competition won’t (can you imagine a Sky+ receiver identifying and skipping ads?!)—but, like much open source software, it’s really not suitable for anyone who isn’t ready and willing to delve into its viscera once in a while. It’s hard to set up, and sometimes hard to keep running. I approach it as a project to tinker with, and I’m very happy with it overall, but I recognise that I’m not a typical user who just wants to watch TV.
2007-10-06 00:35 UTC. Comments: 5.
David Latter
Wrote at 2007-10-09 18:11 UTC using Internet Explorer 7.0 on Windows XP:
Hi Paul,Thanks for the answer to this problem. It came up number one in google and did exactly as it said on the tin.
Regards
Dave
Dave K
Wrote at 2007-10-23 18:08 UTC using Firefox 2.0.0.6 on Windows Vista:
Cheers for the tip, didn’t even know this was an issue. I was googling for information on the channel ids for Virgin 1, Dave and Nuts TV.Thanks !
Dave
Rob Willett
Wrote at 2008-04-27 13:58 UTC using Firefox 2.0.0.14 on Mac OS X:
Paul,I had a similar problem with my Myth box and this solved it for me. I had exactly the same issue, the same symptoms, did what you suggested and I now have Radio listings back.
Many thanks.
Rob.
Ray Ward
Wrote at 2009-03-31 14:53 UTC using Firefox 3.0.8 on Windows 2000:
I Wonder if delete channel data in mythtv-setup does the same thing. I think it’s probably better to remove all and rescan rather than just rescan.Any comments.
Horaci
Wrote at 2010-08-24 11:43 UTC using Firefox 3.6.8 on Linux:
Hey this was useful indeed! I had a similar issue with a whole multiplex changing.The mythtv-setup channel scan wouldn’t delete the channels from mysql so I just deleted all entries on the channel table and did a new full scan with mythtv-setup. Things working now!