[mythtv-users] Upgrading to newer version -- one step forward, two steps...

Sat Apr 11 19:22:29 UTC 2015

I'd really like to upgrade to the latest version of MythTV, so I'd
appreciate any help I can get.

It seems each time I find some time to try again to upgrade my "works
just fine, but really old" mythbuntu 10.04 system I run into a
different problem that stumps me.  I finally abandoned the hope of
just building the new system on the same hardware and got some new
hardware to build an independent instance of mythbuntu and then
replace the old system (moving the disks containing the recordings
from the old system to the new system and migrating the database
data).

I'm having a new problem just getting the database upgrading to work,
something I didn't run into in the past, and I have run out of ideas
on how to fix it.

Because my working system is so old, I now have to do a two-stage
migration to get current.  I tried just going straight to the
mythbuntu 14.04 install, but it wouldn't have anything to do with
upgrading the restored database to the current version, clearly saying
it was too old.  I have no problem getting the 12.04.1 version
installed and updated to 12.04.5.  When I try to upgrade the restored
database, I run into a problem.  FWIW, I restore the database using:

# /usr/bin/mythconverg_restore.pl --verbose --drop_database
--create_database --directory /var/lib/mythtv/db_backups --filename
mythconverg-1254-20150411083132.sql.gz

Then I try to get it upgraded to something I hope I could turn around
and use on the 14.04 install, but I get errors in the mythbackend log
that I haven't figured out how to fix.  It reports A) It is not
allowed to upgrade the database, and B) Console in non-interactive,
can't prompt user.  I tried everything I could think of to make an
interactive console window it would accept, but nothing worked (e.g.
xterm -C, or xterm -C < /dev/console, or xconsole). As for the "not
allowed to upgrade" bit, I don't recall that I ever saw that in past
attempts to upgrade, even with the same 12.04.1 install CD.  I can't
swear that I tried doing the database upgrade before upgrading from
mythbuntu 12.04.1 to 12.04.5, so I will try that while watching to see
if anyone on the list has a more promising approach.

Here's the entire log from the backend run:

# start mythtv-backend; tail -f /var/log/mythtv/mythbackend.log
mythtv-backend start/running, process 4025
Apr 11 13:15:42 peregrine mythbackend[3784]: I CoreContext
mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale en_US
Apr 11 13:15:42 peregrine mythbackend[3784]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
Apr 11 13:15:42 peregrine mythbackend[3784]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:15:42 peregrine mythbackend[3784]: C CoreContext
schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old.
Waiting to see if DB is being upgraded.
Apr 11 13:15:43 peregrine mythbackend[3784]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:15:47  mythbackend[3784]: last message repeated 4 times
Apr 11 13:15:47 peregrine mythbackend[3784]: C CoreContext
schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
Apr 11 13:15:47 peregrine mythbackend[3784]: E CoreContext
dbcheck.cpp:469 (UpgradeTVDatabaseSchema) Not allowed to upgrade the
database.
Apr 11 13:15:47 peregrine mythbackend[3784]: I CoreContext
schemawizard.cpp:316 (PromptForUpgrade) Console is non-interactive,
can't prompt user...
Apr 11 13:15:47 peregrine mythbackend[3784]: E CoreContext
main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new
schema
Apr 11 13:20:49 peregrine mythbackend[4025]: C thread_unknown
mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version:
fixes/0.25 [v0.25.3-49-gb5adf03] www.mythtv.org
Apr 11 13:20:49 peregrine mythbackend[4025]: C thread_unknown
mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile:
4.8.1, runtime: 4.8.1
Apr 11 13:20:49 peregrine mythbackend[4025]: N thread_unknown
mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose
msgs:  general
Apr 11 13:20:49 peregrine mythbackend[4025]: N thread_unknown
logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Apr 11 13:20:49 peregrine mythbackend[4025]: I thread_unknown
logging.cpp:229 (FileLogger) Added logging to the console
Apr 11 13:20:49 peregrine mythbackend[4025]: I thread_unknown
logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Apr 11 13:20:49 peregrine mythbackend[4025]: I thread_unknown
logging.cpp:425 (DatabaseLogger) Added database logging to table
logging
Apr 11 13:20:49 peregrine mythbackend[4025]: N thread_unknown
logging.cpp:1215 (logStart) Setting up SIGHUP handler
Apr 11 13:20:49 peregrine mythbackend[4025]: N thread_unknown
mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Apr 11 13:20:49 peregrine mythbackend[4025]: N thread_unknown
mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory =
/home/mythtv/.mythtv
Apr 11 13:20:49 peregrine mythbackend[4025]: I CoreContext
mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.UTF-8
Apr 11 13:20:49 peregrine mythbackend[4025]: N CoreContext
mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Apr 11 13:20:49 peregrine mythbackend[4025]: I CoreContext
mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of
peregrine
Apr 11 13:20:49 peregrine mythbackend[4025]: N CoreContext
mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to
en_US
Apr 11 13:20:49 peregrine mythbackend[4025]: I CoreContext
mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale en_US
Apr 11 13:20:49 peregrine mythbackend[4025]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
Apr 11 13:20:49 peregrine mythbackend[4025]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:20:49 peregrine mythbackend[4025]: C CoreContext
schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old.
Waiting to see if DB is being upgraded.
Apr 11 13:20:50 peregrine mythbackend[4025]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:20:54  mythbackend[4025]: last message repeated 4 times
Apr 11 13:20:54 peregrine mythbackend[4025]: C CoreContext
schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
Apr 11 13:20:54 peregrine mythbackend[4025]: E CoreContext
dbcheck.cpp:469 (UpgradeTVDatabaseSchema) Not allowed to upgrade the
database.
Apr 11 13:20:54 peregrine mythbackend[4025]: I CoreContext
schemawizard.cpp:316 (PromptForUpgrade) Console is non-interactive,
can't prompt user...
Apr 11 13:20:54 peregrine mythbackend[4025]: E CoreContext
main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new
schema
Apr 11 13:20:54 peregrine mythbackend[4036]: C thread_unknown
mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version:
fixes/0.25 [v0.25.3-49-gb5adf03] www.mythtv.org
Apr 11 13:20:54 peregrine mythbackend[4036]: C thread_unknown
mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile:
4.8.1, runtime: 4.8.1
Apr 11 13:20:54 peregrine mythbackend[4036]: N thread_unknown
mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose
msgs:  general
Apr 11 13:20:54 peregrine mythbackend[4036]: N thread_unknown
logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Apr 11 13:20:54 peregrine mythbackend[4036]: I thread_unknown
logging.cpp:229 (FileLogger) Added logging to the console
Apr 11 13:20:54 peregrine mythbackend[4036]: I thread_unknown
logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Apr 11 13:20:54 peregrine mythbackend[4036]: I thread_unknown
logging.cpp:425 (DatabaseLogger) Added database logging to table
logging
Apr 11 13:20:54 peregrine mythbackend[4036]: N thread_unknown
logging.cpp:1215 (logStart) Setting up SIGHUP handler
Apr 11 13:20:54 peregrine mythbackend[4036]: N thread_unknown
mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Apr 11 13:20:54 peregrine mythbackend[4036]: N thread_unknown
mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory =
/home/mythtv/.mythtv
Apr 11 13:20:54 peregrine mythbackend[4036]: I CoreContext
mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.UTF-8
Apr 11 13:20:54 peregrine mythbackend[4036]: N CoreContext
mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Apr 11 13:20:54 peregrine mythbackend[4036]: I CoreContext
mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of
peregrine
Apr 11 13:20:54 peregrine mythbackend[4036]: N CoreContext
mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to
en_US
Apr 11 13:20:54 peregrine mythbackend[4036]: I CoreContext
mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale en_US
Apr 11 13:20:54 peregrine mythbackend[4036]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
Apr 11 13:20:54 peregrine mythbackend[4036]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:20:54 peregrine mythbackend[4036]: C CoreContext
schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old.
Waiting to see if DB is being upgraded.
Apr 11 13:20:55 peregrine mythbackend[4036]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:20:59  mythbackend[4036]: last message repeated 4 times
Apr 11 13:20:59 peregrine mythbackend[4036]: C CoreContext
schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
Apr 11 13:20:59 peregrine mythbackend[4036]: E CoreContext
dbcheck.cpp:469 (UpgradeTVDatabaseSchema) Not allowed to upgrade the
database.
Apr 11 13:20:59 peregrine mythbackend[4036]: I CoreContext
schemawizard.cpp:316 (PromptForUpgrade) Console is non-interactive,
can't prompt user...
Apr 11 13:20:59 peregrine mythbackend[4036]: E CoreContext
main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new
schema
Apr 11 13:20:59 peregrine mythbackend[4046]: C thread_unknown
mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version:
fixes/0.25 [v0.25.3-49-gb5adf03] www.mythtv.org
Apr 11 13:20:59 peregrine mythbackend[4046]: C thread_unknown
mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile:
4.8.1, runtime: 4.8.1
Apr 11 13:20:59 peregrine mythbackend[4046]: N thread_unknown
mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose
msgs:  general
Apr 11 13:20:59 peregrine mythbackend[4046]: N thread_unknown
logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Apr 11 13:20:59 peregrine mythbackend[4046]: I thread_unknown
logging.cpp:229 (FileLogger) Added logging to the console
Apr 11 13:20:59 peregrine mythbackend[4046]: I thread_unknown
logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Apr 11 13:20:59 peregrine mythbackend[4046]: I thread_unknown
logging.cpp:425 (DatabaseLogger) Added database logging to table
logging
Apr 11 13:20:59 peregrine mythbackend[4046]: N thread_unknown
logging.cpp:1215 (logStart) Setting up SIGHUP handler
Apr 11 13:20:59 peregrine mythbackend[4046]: N thread_unknown
mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Apr 11 13:20:59 peregrine mythbackend[4046]: N thread_unknown
mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory =
/home/mythtv/.mythtv
Apr 11 13:20:59 peregrine mythbackend[4046]: I CoreContext
mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.UTF-8
Apr 11 13:20:59 peregrine mythbackend[4046]: N CoreContext
mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Apr 11 13:20:59 peregrine mythbackend[4046]: I CoreContext
mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of
peregrine
Apr 11 13:20:59 peregrine mythbackend[4046]: N CoreContext
mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to
en_US
Apr 11 13:20:59 peregrine mythbackend[4046]: I CoreContext
mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale en_US
Apr 11 13:20:59 peregrine mythbackend[4046]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
Apr 11 13:20:59 peregrine mythbackend[4046]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:20:59 peregrine mythbackend[4046]: C CoreContext
schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old.
Waiting to see if DB is being upgraded.
Apr 11 13:21:00 peregrine mythbackend[4046]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1254
Apr 11 13:21:04  mythbackend[4046]: last message repeated 4 times
Apr 11 13:21:04 peregrine mythbackend[4046]: C CoreContext
schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
Apr 11 13:21:04 peregrine mythbackend[4046]: E CoreContext
dbcheck.cpp:469 (UpgradeTVDatabaseSchema) Not allowed to upgrade the
database.
Apr 11 13:21:04 peregrine mythbackend[4046]: I CoreContext
schemawizard.cpp:316 (PromptForUpgrade) Console is non-interactive,
can't prompt user...
Apr 11 13:21:04 peregrine mythbackend[4046]: E CoreContext
main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new
schema
^C

Other data I collected that might be relevant/enlightening:

# mythbackend --version
Please attach all output as a file in bug reports.
MythTV Version : v0.25.3-49-gb5adf03
MythTV Branch : fixes/0.25
Network Protocol : 72
Library API : 0.25.20130225-1
QT Version : 4.8.1
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse
using_pulseoutput using_backend using_bindings_perl
using_bindings_python using_bindings_php using_crystalhd using_dvb
using_firewire using_frontend using_hdhomerun using_ceton using_hdpvr
using_iptv using_ivtv using_joystick_menu using_libcec using_libcrypto
using_libdns_sd using_libxml2 using_lirc using_mheg using_opengl_video
using_qtwebkit using_qtscript using_qtdbus using_v4l2 using_x11
using_xrandr using_xv using_bindings_perl using_bindings_python
using_bindings_php using_mythtranscode using_opengl using_vaapi
using_vdpau using_ffmpeg_threads using_live using_mheg using_libass
using_libxml2
# uname -a
Linux peregrine 3.2.0-80-generic-pae #116-Ubuntu SMP Mon Mar 23
17:29:27 UTC 2015 i686 i686 i386 GNU/Linux
# more /etc/issue.net
::::::::::::::
/etc/issue.net
::::::::::::::
Ubuntu 12.04.5 LTS
# more /etc/*-release
::::::::::::::
/etc/lsb-release
::::::::::::::
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=12.04
DISTRIB_CODENAME=precise
DISTRIB_DESCRIPTION="Ubuntu 12.04.5 LTS"
::::::::::::::
/etc/os-release
::::::::::::::
NAME="Ubuntu"
VERSION="12.04.5 LTS, Precise Pangolin"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu precise (12.04.5 LTS)"
VERSION_ID="12.04"
#

--
Craig.