mythbuntu-bugs team mailing list archive

[Thomas Mashos <thomas@xxxxxxxxxx>]

This doesn't sound like it's related to packaging, as database upgrades
only happen when upgrading a major version (eg. 0.25 -> 0.26). Minor
upgrades don't change the database so there isn't anything to update. This
sounds like another issue to me (perhaps hardware).

Have you run a check on the database to look for corrupt tables?

Thanks,

Thomas Mashos


On Sun, Feb 3, 2013 at 10:18 PM, Andrew <1097868@xxxxxxxxxxxxxxxxxx> wrote:

> It was just the latest mythtv updates for mythbuntu 0.25.
>
> New version: 2:0.25.3+fixes.20130202.1d4d50b-0ubuntu0mythbuntu2
> Old version:2:0.25.3+fixes.20130127.79a24c9-0ubuntu0mythbuntu2
>
> I doubt it is a problem with that upgrade though as I've experienced
> this issue several times now. I think that each time, the problem has
> appeared after rebooting the system.
>
> Not sure if it is related, but I have been seeing mythweb show deleted
> programs as still recording in the upcoming recordings screen. I'm
> thinking that either my database is corrupt, or something is corrupting
> it during reboots.
>
> --
> You received this bug notification because you are a member of Mythbuntu
> Bug Team, which is subscribed to Mythbuntu.
> https://bugs.launchpad.net/bugs/1097868
>
> Title:
>   After upgrade, recordings table is corrupted and new recordings are
>   not working
>
> Status in Mythbuntu, Ubuntu derivative focused upon MythTV:
>   New
>
> Bug description:
>   I just updated my mythbuntu and after the last update mythtv is unable
>   to record scheduled recordings anymore.
>
>   The symptom is that in the "Watch Recordings", there are 2 entries for
>   each program that are grayed out.
>
>   For example, I have Sesame Street set to record each day and only keep
>   2 recordings maximum for my girls. Today, when this attempted to
>   record the 10AM showing, I ended up with two entries in the
>   mythfrondend. Both show "Sesame Street - Elmo and Zoe's Hat Contest"
>   on Jan 9 10:00 AM. Both are grayed out with the X by the title.
>
>   Logging into the mysql database, I ran this query:
>   select * from recorded where subtitle like 'Elmo and Zoe%';
>
>   Please see the attached "recordings.sql" file for the two results.
>
>   In that table, the basename column value for the two records is
>   1121_20130109100001.mpg and 1121_20130109100000.mpg
>
>   Looking at my /var/lib/mythtv/recordings, I see what it should be:
>   $ ls -lh /var/lib/mythtv/recordings/1121_20130109*
>   -rw-r--r-- 1 mythtv mythtv 1.4G Jan  9 09:05
> /var/lib/mythtv/recordings/1121_20130109083000.mpg
>   -rw-rw-rw- 1 mythtv mythtv 8.1K Jan  9 10:00
> /var/lib/mythtv/recordings/1121_20130109083000.mpg.-1.100x75.png
>   -rw-rw-rw- 1 mythtv mythtv  71K Jan  9 09:05
> /var/lib/mythtv/recordings/1121_20130109083000.mpg.png
>   -rw-r--r-- 1 mythtv mythtv 1.4G Jan  9 09:35
> /var/lib/mythtv/recordings/1121_20130109090000.mpg
>   -rw-rw-rw- 1 mythtv mythtv  13K Jan  9 10:00
> /var/lib/mythtv/recordings/1121_20130109090000.mpg.-1.100x75.png
>   -rw-rw-rw- 1 mythtv mythtv 101K Jan  9 09:35
> /var/lib/mythtv/recordings/1121_20130109090000.mpg.png
>
>   So, for some reason, it seems, that the record in the database is
>   using 2013-01-09 @10 but the file is being save with @9.
>
>   I'm thinking that I may have to delete my whole database and re-
>   configure mythtv.
>
>   Since I can't record programs and view them using mythfrontend
>   anymore, this is a major issue for me. I've never had a problem like
>   this with mythtv in the 4 or so years I have been using it. Any help
>   would be greatly appreciated.
>
>   ProblemType: Bug
>   DistroRelease: Ubuntu 12.04
>   Package: mythtv-backend
> 2:0.25.3+fixes.20130104.010e576-0ubuntu0mythbuntu3 [origin:
> LP-PPA-mythbuntu-0.25]
>   ProcVersionSignature: Ubuntu 3.2.0-35.55-generic 3.2.34
>   Uname: Linux 3.2.0-35-generic x86_64
>   NonfreeKernelModules: nvidia
>   .var.log.mythtv.mythavtest.log:
>
>   .var.log.mythtv.mythccextractor.log:
>
>   .var.log.mythtv.mythjobqueue.log:
>
>   .var.log.mythtv.mythlcdserver.log:
>
>   .var.log.mythtv.mythmediaserver.log:
>
>   .var.log.mythtv.mythshutdown.log:
>
>   .var.log.mythtv.mythtranscode.log:
>
>   .var.log.mythtv.mythutil.log:
>
>   .var.log.mythtv.mythwelcome.log:
>
>   ApportVersion: 2.0.1-0ubuntu15.1
>   Architecture: amd64
>   CrashDB: mythbuntu
>   Date: Wed Jan  9 11:00:23 2013
>   InstallationMedia: Mythbuntu 12.04.1 "Precise Pangolin" - Release amd64
> (20120818.1)
>   Installed_mythtv_dbg: 0.0
>   MarkForUpload: True
>   ProcEnviron:
>    TERM=screen
>    PATH=(custom, no user)
>    LANG=en_US.UTF-8
>    SHELL=/bin/bash
>   SourcePackage: mythtv
>   UpgradeStatus: No upgrade log present (probably fresh install)
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/mythbuntu/+bug/1097868/+subscriptions
>
> _______________________________________________
> Mailing list: https://launchpad.net/~mythbuntu-bugs
> Post to     : mythbuntu-bugs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~mythbuntu-bugs
> More help   : https://help.launchpad.net/ListHelp
>