mythbuntu-bugs team mailing list archive

Thread
Date
Re: [Bug 1097868] [NEW] After upgrade, recordings table is corrupted and new recordings are not working

To: mythbuntu-bugs@xxxxxxxxxxxxxxxxxxx
From: Mario Limonciello <superm1@xxxxxxxxxx>
Date: Wed, 09 Jan 2013 18:39:28 -0000
Reply-to: Bug 1097868 <1097868@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
have you tried to repair the database yet?  it might be able to help sort
it out?

On Wed, Jan 9, 2013 at 12:15 PM, Andrew <1097868@xxxxxxxxxxxxxxxxxx>
wrote:

> Public bug reported:
>
> 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)
>
> ** Affects: mythbuntu
>      Importance: Undecided
>          Status: New
>
>
> ** Tags: amd64 apport-bug precise third-party-packages
>
> ** Attachment added: "2 database records for sesame street"
>
> https://bugs.launchpad.net/bugs/1097868/+attachment/3478297/+files/recordings.sql
>
> --
> 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
>


-- 
Mario Limonciello
superm1@xxxxxxxxx

-- 
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
References

[Bug 1097868] [NEW] After upgrade, recordings table is corrupted and new recordings are not working
From: Andrew, 2013-01-09