[mythtv-users] database recovery, no backup

[Ross Boylan]

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