Just started having a problem with MythWeb it is only when I click on "Recoded Programs", no where else. Viewing recorded programs on the actual TV connected to the box works just fine as do all other MythWeb functions. When I click on "Recorded Programs" the browser spins for quite a while (on my system it has always taken a while to generate this page, all others are very snappy) and then I get the following:
Followed by the list of recordings. At this point the mythtv-backend is no longer running. Looking in /var/log/mythtv/mythbackend.log I see the following:
2006-04-19 19:11:57.530 GetNextFreeFrame() unable to lock frame 100 times. Disc$
[mpeg2video @ 0xb72f8620]get_buffer() failed (stride changed)
2006-04-19 19:11:57.537 AFD Error: Unknown decoding error
[mpeg2video @ 0xb72f8620]get_buffer() failed (stride changed)
2006-04-19 19:11:57.569 AFD Error: Unknown decoding error
[mpeg2video @ 0xb72f8620]get_buffer() failed (stride changed)
2006-04-19 19:11:57.577 AFD Error: Unknown decoding error
[mpeg2video @ 0xb72f8620]get_buffer() failed (stride changed)
2006-04-19 19:23:09.098 Using runtime prefix = /usr
2006-04-19 19:23:09.121 New DB connection, total: 1
2006-04-19 19:23:09.139 Connected to database 'mythconverg' at host: localhost
2006-04-19 19:23:09.145 Current Schema Version: 1123
Starting up as the master server.
2006-04-19 19:23:09.240 New DB connection, total: 2
2006-04-19 19:23:09.254 Connected to database 'mythconverg' at host: localhost
2006-04-19 19:23:09.285 DVB#0 Using DVB card 0, with frontend 'Broadcom BCM3510$
2006-04-19 19:23:09.289 New DB connection, total: 3
2006-04-19 19:23:09.292 Connected to database 'mythconverg' at host: localhost
2006-04-19 19:23:09.302 New DB scheduler connection
2006-04-19 19:23:09.305 Connected to database 'mythconverg' at host: localhost
2006-04-19 19:23:09.315 mythbackend version: 0.19.20060121-2
www.mythtv.org2006-04-19 19:23:09.318 Enabled verbose msgs: important general
2006-04-19 19:23:09.320 AutoExpire: Found 1 recorders w/max rate of 138 MiB/min
2006-04-19 19:23:09.329 AutoExpire: Required Free Space: 3.0 GB w/freq: 10 min
2006-04-19 19:23:11.315 Reschedule requested for id -1.
2006-04-19 19:23:11.467 Scheduled 96 items in 0.2 = 0.05 match + 0.11 place
2006-04-19 19:23:11.473 Recording starts soon, AUTO-Startup assumed
2006-04-19 19:23:19.243 Running HouseKeeping
2006-04-19 19:24:29.348 AutoExpire: ERROR when trying to autoexpire file: /myth/tv/1014_20060417171957.mpg. File doesn't exist. Database metadata will not be removed.
2006-04-19 19:26:29.382 AutoExpire: ERROR when trying to autoexpire file: /myth/tv/1014_20060417171957.mpg. File doesn't exist. Database metadata will not be removed.
2006-04-19 19:28:19.261 Running HouseKeeping
2006-04-19 19:28:29.419 AutoExpire: ERROR when trying to autoexpire file: /myth/tv/1014_20060417171957.mpg. File doesn't exist. Database metadata will not be removed.
It was between 19:11 and 19:23 that I clicked on "Recorded Progams", so no clue at that time. Of course 19:23 was when I started the backend up again.
None of which appears to be a clue to me. Not that I actually know anythying about sql. mysql.err is empty.
How do I remove the database "metadata" to line up the reality of what is in /myth/tv?
I have already followed cesman's guide to database (table) repair.
No problems found or repaired.