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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~mythbuntu-bugs > More help : https://help.launchpad.net/ListHelp > -- Mario Limonciello [email protected] -- 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 : [email protected] Unsubscribe : https://launchpad.net/~mythbuntu-bugs More help : https://help.launchpad.net/ListHelp
