<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Sep 9, 2013 at 7:32 AM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 09/08/2013 09:05 PM, Captain Hook wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Sun, Sep 8, 2013 at 1:11 PM, Jean-Yves Avenard wrote:<div class="im"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 8 September 2013 14:34, Captain Hook wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext<br>
dbcheck.cpp:417 (performActualUpdate) DB Error (Performing database<br>
upgrade): #012Query was: ALTER TABLE program ADD INDEX title_subtitle_start<br>
(title, subtitle, starttime); #012Error was: Driver error was<br>
[2/1061]:#012QMYSQL: Unable to execute query#012Database error<br>
was:#012Duplicate key name 'title_subtitle_start'#012 #012new version: 1316<br>
Sep 8 14:20:57 MythTV mythtv-setup.real: mythtv-setup[4299]: E CoreContext<br>
dbcheck.cpp:502 (UpgradeTVDatabaseSchema) Database schema upgrade failed.<br>
</blockquote>
looks like you had earlier attempted an upgrade and somehow screwed up<br>
your database schema...<br>
did you run any command touching the mysql database ?<br>
<br>
<br>
</blockquote></div></blockquote><div class="im">
I am quite certain that this was my first attempt at upgrading. I've only<br>
been using MythTV for about 7 months and was sticking with .26 until I<br>
started seeing all the praises. There should be nothing else on my backend<br>
that could be affecting MySQL at all. This is basically a dedicated backend<br>
and the only thing installed that I can think of that I have installed is<br>
VMWare Tools. It is a myth backend exclusively.<br>
</div></blockquote>
<br>
He means you started mythbackend and it attempted--and failed--to upgrade the database. Then, you (or some script on your system) restarted mythbackend, and it's attempting to upgrade the database--but, now, because of the previous attempt, the failure is different (and useless at helping us figure out the actual cause).<br>
<br>
Because there's no transaction support for our database, any time you attempt an upgrade and it fails, the state of the database is indeterminate. Therefore, you should always restore the pre-upgrade backup you made (or, failing that, the one that was automatically made for you) and then attempt an upgrade, again. See <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database" target="_blank">http://www.mythtv.org/wiki/<u></u>Database_Backup_and_Restore#<u></u>Replacing_an_existing_database</a> for information on how to restore the backup.<br>
<br>
Also, it is highly recommended to always use mythtv-setup for database upgrades, because it will tell you if there's a failure interactively--rather than waiting until after you start mythfrontend and MythWeb and any of a number of other applications, which may further confuse the state of the database.<br>
<br>
Because you seem to have done multiple attempted upgrades, make sure you get the first pre-upgrade backup to restore.<br>
<br>
I'm guessing your program table definition was corrupt and you were missing an index that was supposed to be there. I'd have to see a log from a "first-upgrade-attempt" to know for sure, though.<br>
<br>
Mike<div class="HOEnZb"><div class="h5"><br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br></div><div class="gmail_extra">I understand now. I did attempt to upgrade multiple times, so you are both correct there. I didn't realize that I was to run myth-setup after upgrading and didn't attempt to run it until after I figured out that my backend wasn't working. I will restore a backup and attempt this again and then look at the log if it fails. Thanks.</div>
</div>