[mythtv-users] Upgrade to 0.22 database won't upgrade

[Gary Dawes]

2009/11/21 Michael Harnden <mike at rochestervball.com>

> On Saturday 21 November 2009 04:09:04 pm Michael Harnden wrote:
> > Using Mythbuntu, did a dist-upgrade and I am having problems getting
> myth-
> > setup to run. When I run it, all I get is a blank white screen. Here is
> the
> > output from mythbackend.log.
> >
> > 2009-11-21 15:55:52.805 New DB connection, total: 2
> > 2009-11-21 15:55:52.806 Connected to database 'mythconverg' at host:
> >  localhost 2009-11-21 15:55:52.810 Waiting for Database Backup to
> complete.
> > 2009-11-21 15:55:53.813 Waiting for Database Backup to complete.
> > 2009-11-21 15:55:54.815 Waiting for Database Backup to complete.
> > 2009-11-21 15:55:55.818 Waiting for Database Backup to complete.
> > 2009-11-21 15:55:56.821 Waiting for Database Backup to complete.
> > 2009-11-21 15:55:57.823 Waiting for Database Backup to complete.
> > 2009-11-21 15:55:57.824 Timed out waiting.
> > 2009-11-21 15:56:00.525 Backing up database with script:
> > '/usr/share/mythtv/mythconverg_backup.pl'
> > 2009-11-21 15:56:51.997 mythbackend version: branches/release-0-22-fixes
> > [22869] www.mythtv.org
> > 2009-11-21 15:56:51.999 Using runtime prefix = /usr
> > 2009-11-21 15:56:52.000 Using configuration directory =
> >  /home/mythtv/.mythtv 2009-11-21 15:56:52.001 Empty LocalHostName.
> > 2009-11-21 15:56:52.002 Using localhost value of mythtv-server.site
> > 2009-11-21 15:56:52.026 New DB connection, total: 1
> > 2009-11-21 15:56:52.031 Connected to database 'mythconverg' at host:
> >  localhost 2009-11-21 15:56:52.032 Closing DB connection named
> 'DBManager0'
> > 2009-11-21 15:56:52.034 Connected to database 'mythconverg' at host:
> >  localhost 2009-11-21 15:56:52.041 Current MythTV Schema Version
> >  (DBSchemaVer): 1214 2009-11-21 15:56:52.042 MythTV database schema is
> old.
> >  Waiting to see if DB is being upgraded.
> > 2009-11-21 15:56:53.043 New DB connection, total: 2
> > 2009-11-21 15:56:53.045 Connected to database 'mythconverg' at host:
> >  localhost 2009-11-21 15:56:53.049 Waiting for Database Backup to
> complete.
> > 2009-11-21 15:56:54.053 Waiting for Database Backup to complete.
> > 2009-11-21 15:56:55.056 Waiting for Database Backup to complete.
> > 2009-11-21 15:56:56.058 Waiting for Database Backup to complete.
> > 2009-11-21 15:56:57.061 Waiting for Database Backup to complete.
> > 2009-11-21 15:56:58.063 Waiting for Database Backup to complete.
> > 2009-11-21 15:56:58.064 Timed out waiting.
> > 2009-11-21 15:57:01.025 Backing up database with script:
> > '/usr/share/mythtv/mythconverg_backup.pl'
> >
> > I now have a ton of mysql backups, as mythbackend just keeps looping into
> > backing up with the mythconverge_backup script. I thought running
> >  myth-setup started the upgrade process. Am I missing something simple?
> > Mike
> >
> > Mike
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> I ended up dropping and restoring my database to solve this.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Have you ran mythtv-setup to upgrade the schema? Which is what I needed to
do. I also had some corruption in my db due to the character encoding. This
wiki page has the details
http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding

I needed to manually remove the section for the people table before it would
sucessfully import though. You can turn on debug level messages for both
mythbackend and mythtv-setup which will show you exactly what is failing.
The option to use is
"-v debug".
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091121/142165c2/attachment.htm>