[mythtv-users] database recovery, no backup

Sat Jul 21 02:43:28 UTC 2012

For 0.25 you need to use dist-upgrade otherwise you can get stuck with
partial upgrade. Run
# apt-get update
# apt-get dist-upgrade
and see if that fixes it.
 On Jul 21, 2012 2:29 AM, "Ross Boylan" <RossBoylan at stanfordalumni.org>
wrote:

> On Fri, 2012-07-20 at 09:09 -0700, Cecil Watson wrote:
> >
> >
> > On Fri, Jul 20, 2012 at 8:46 AM, Ross Boylan
> > <RossBoylan at stanfordalumni.org> wrote:
> >         During an upgrade from .24 to .25 (using Marillat's Debian
> >         repository)
> >         my database got borked and the system won't start.  The
> >         standard advice
> >         is to restore from backup, but I don't have one.
> > Define system won't start.
> mythbackend log
> 2012-05-13 21:31:40.262783 C [342/342] thread_unknown
> mythcommandlineparser.cpp:2534 (ConfigureLogging) - mythbackend version:
>  [v0.25pre] www.mythtv.org
> 2012-05-13 21:31:40.262873 N [342/342] thread_unknown
> mythcommandlineparser.cpp:2536 (ConfigureLogging) - Enabled verbose msgs:
>  general
> 2012-05-13 21:31:40.263316 N [342/342] thread_unknown logging.cpp:1176
> (logStart) - Setting Log Level to LOG_INFO
> 2012-05-13 21:31:40.263472 I [342/342] thread_unknown logging.cpp:229
> (FileLogger) - Added logging to the console
> 2012-05-13 21:31:40.276940 I [342/342] thread_unknown logging.cpp:238
> (FileLogger) - Added logging to
> /var/log/mythtv/mythbackend.20120513213140.342.log
> 2012-05-13 21:31:40.276975 I [342/342] thread_unknown logging.cpp:425
> (DatabaseLogger) - Added database logging to table logging
> 2012-05-13 21:31:40.277331 N [342/342] thread_unknown logging.cpp:1215
> (logStart) - Setting up SIGHUP handler
> 2012-05-13 21:31:40.338971 N [342/342] thread_unknown mythdirs.cpp:51
> (InitializeMythDirs) - Using runtime prefix = /usr
> 2012-05-13 21:31:40.339039 N [342/342] thread_unknown mythdirs.cpp:64
> (InitializeMythDirs) - Using configuration directory =
> /var/lib/mythtv/.mythtv
> 2012-05-13 21:31:40.390779 I [342/342] CoreContext mythcorecontext.cpp:227
> (Init) - Assumed character encoding: en_US.UTF-8
> 2012-05-13 21:31:40.437278 E [342/342] CoreContext configuration.cpp:64
> (Load) - Error parsing: /var/lib/mythtv/.mythtv/config.xml at line: 1
>  column: 1
> 2012-05-13 21:31:40.437301 E [342/342] CoreContext configuration.cpp:66
> (Load) - Error Msg: unexpected end of file
> 2012-05-13 21:31:40.490617 N [342/342] CoreContext mythcontext.cpp:477
> (LoadDatabaseSettings) - Empty LocalHostName.
> 2012-05-13 21:31:40.490645 I [342/342] CoreContext mythcontext.cpp:481
> (LoadDatabaseSettings) - Using localhost value of corn
> 2012-05-13 21:31:40.490823 E [342/342] CoreContext configuration.cpp:64
> (Load) - Error parsing: /var/lib/mythtv/.mythtv/config.xml at line: 1
>  column: 1
> 2012-05-13 21:31:40.490835 E [342/342] CoreContext configuration.cpp:66
> (Load) - Error Msg: unexpected end of file
> 2012-05-13 21:31:42.474211 N [342/342] CoreContext
> mythcorecontext.cpp:1270 (InitLocale) - Setting QT default locale to en_US
> 2012-05-13 21:31:42.474539 I [342/342] CoreContext
> mythcorecontext.cpp:1303 (SaveLocaleDefaults) - Current locale en_US
> 2012-05-13 21:31:42.514424 N [342/342] CoreContext mythlocale.cpp:121
> (LoadDefaultsFromXML) - Reading locale defaults from
> /usr/share/mythtv//locales/en_us.xml
> 2012-05-13 21:31:42.941783 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:42.941837 C [342/342] CoreContext schemawizard.cpp:135
> (CompareAndWait) - MythTV database schema is old. Waiting to see if DB is
> being upgraded.
> 2012-05-13 21:31:44.021755 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:45.024322 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:46.026637 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:47.028983 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:48.031182 I [342/342] CoreContext schemawizard.cpp:117
> (Compare) - Current MythTV Schema Version (DBSchemaVer): 1266
> 2012-05-13 21:31:48.031282 C [342/342] CoreContext schemawizard.cpp:179
> (CompareAndWait) - Timed out waiting.
> 2012-05-13 21:31:48.041371 C [342/342] CoreContext dbutil.cpp:217
> (BackupDB) - Database backups disabled.  Skipping backup.
> 2012-05-13 21:31:48.111326 I [342/342] CoreContext schemawizard.cpp:316
> (PromptForUpgrade) - Console is non-interactive, can't prompt user...
> 2012-05-13 21:31:48.111346 C [342/342] CoreContext schemawizard.cpp:341
> (PromptForUpgrade) - Upgrading.
> 2012-05-13 21:31:48.129495 C [342/342] CoreContext dbcheck.cpp:495
> (UpgradeTVDatabaseSchema) - Newest MythTV Schema Version : 1299
> 2012-05-13 21:31:48.209034 E [342/342] CoreContext videodbcheck.cpp:369
> (doUpgradeVideoDatabaseSchema) - Unrecognized video database schema
> version. Unable to upgrade database.
> 2012-05-13 21:31:48.209051 E [342/342] CoreContext videodbcheck.cpp:372
> (doUpgradeVideoDatabaseSchema) - Please see
> mythplugins/mythvideo/README.database for more information.
> 2012-05-13 21:31:48.209064 E [342/342] CoreContext videodbcheck.cpp:375
> (doUpgradeVideoDatabaseSchema) - mythvideo.DBSchemaVer: '1011',
> VideoDBSchemaVer: '', DVDDBSchemaVer: ''
> 2012-05-13 21:31:48.209074 E [342/342] CoreContext dbcheck.cpp:509
> (UpgradeTVDatabaseSchema) - Database Schema upgrade FAILED, unlocking.
> 2012-05-13 21:31:48.209245 E [342/342] CoreContext main_helpers.cpp:529
> (run_backend) - Couldn't upgrade database to new schema
> and myth then exits.
>
> >
> >         I have all the recordings, and I assume that data is likely
> >         still in the
> >         database.  I tried a little debugging, but haven't located the
> >         schema
> >         migration code.
> >
> >         Any advice about the best way to proceed?
> > myisamchk -f /path/to/mysql/mythconverg/*.MYI
> > or
> > http://www.mythtv.org/wiki/Optimize_mythdb.pl
> > Post greater detail as to what the problem is.
> I have no reason to think the database is corrupt in the mysql sense;
> rather, the tables are not in a well-defined state for myth.
>
> I think it went part-way through the upgrade and then failed because I
> had not installed an "optional" component (mythweb?  also the frontend
> is missing the suggested mythgallery, mythgame, mythmusic, mythvideo,
> and mythweather packages).  I was using it only to record TV.
>
> Ross
> >
> >         Thanks.
> >         Ross
> >
> >
> >
> >
> > --
> > Enjoy the day,
> >
> > Cecil
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120721/f3fb0352/attachment.html>