I kept getting errors when I tried to transcode
I checked /etc/var/mythtv/mythbackend.log and found this error message:
Parser not found for Codec Id: 94210 !
a few times, along with
2006-07-19 08:21:21.114 Connected to database 'mythconverg' at host: localhost
2006-07-19 08:21:22.428 Unknown video codec:
2006-07-19 08:21:23.746 Transcoding /myth/tv/1003_20060719000000.mpg failed
2006-07-19 08:21:25.234 Unknown socket closing
2006-07-19 08:21:26.693 Transcode Errored for Doctor Who "World War Three":
Doing a quick search of the forum found this posting
http://mysettopbox.tv/phpBB2/viewtopic. ... nown+codec
suggesting I update via svn and update ffmpeg so I did the following from the posts:
Code:
svn co http://svn.mythtv.org/svn/branches/release-0-19-fixes/mythtv
wget ftp://ftp.knoppmyth.net/R5/diffs/knoppmyth_tv_0.19.0-4_i586.diff
cd mythtv
patch -p1 < ../knoppmyth_tv_0.19.0-4_i586.diff
chmod +x debian/rules
fakeroot dpkg-buildpackage -us -uc -b
su -
dpkg -i ../*.deb
exit
and
cd /usr/src/
cvs -z9 -d:pserver:anonymous@mplayerhq.hu:/cvsroot/ffmpeg co ffmpeg
cd ffmpeg
./configure --prefix=/usr
make
make install
But to no avail. Still errored out.
Checking the code in
http://www.cuymedia.net/doxygen-dev-docs/html I found the jobqueue explained well:
http://www.cuymedia.net/doxygen-dev-doc ... ue_8h.htmlSelect * from jobqueue; confirmed that the jobs were erroring, which I already knew of course.
I ran jobqueue in a terminal, and in mysql entered
update jobqueue where type=1 and status=304 limit 1;
Note: The h file of course lists values in hex. Mysql displays the value in decimal. Therefore I needed to convert 0x0130 to 304 for my query.
In the jobqueue output I saw unknown video codec:
The : with nothing after it got me wondering, so I did a
Code:
select * from recordingprofiles;
+----+--------------+------------+------------+--------------+
| id | name | videocodec | audiocodec | profilegroup |
+----+--------------+------------+------------+--------------+
| 1 | Default | NULL | NULL | 1 |
| 2 | Live TV | NULL | NULL | 1 |
| 3 | High-Quality | NULL | NULL | 1 |
| 4 | Low-Quality | NULL | NULL | 1 |
| 5 | Default | NULL | NULL | 2 |
| 6 | Live TV | NULL | NULL | 2 |
| 7 | High-Quality | NULL | NULL | 2 |
| 8 | Low-Quality | NULL | NULL | 2 |
| 9 | Default | NULL | NULL | 3 |
| 10 | Live TV | NULL | NULL | 3 |
| 11 | High-Quality | NULL | NULL | 3 |
| 12 | Low-Quality | NULL | NULL | 3 |
| 13 | RTjpeg/MPEG4 | NULL | NULL | 4 |
| 14 | MPEG2 | NULL | NULL | 4 |
+----+--------------+------------+------------+--------------+
Checking some old notes, I found that I had added the following in the past to create a custom profile.
insert into recordingprofiles (name,videocodec,audiocodec,profilegroup) values ('480i Resize','MPEG-4','Uncompressed','6');
So, I did the following
[code]
cd /myth/backup
mysqldump mythconverg > backup_before_I_updated_recordingprofiles.sql
#make a backup, always make a backup
mysql -umythtv -pmythtv mythconverg
update recordingprofiles set videocodec='MPEG-4',audiocodec='Uncompressed';
#above changes the table to have values in those fields
update jobqueue set status=1 where type=1 and status=304;
#above takes all the transcoding jobs (type=1) that have errored (Status=304) in the database
[c/ode]
And voila, suddenly the machine is transcoding again!
The transcoders section in setup, TV, Recording Profiles is supposed to take care of this and add the values when you set up the transcoders, but something must have gone wrong when I did a reinstall.
AFter this I went in and resetup the transcoders, and this time all is fine.