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