[mythtv-users] interactive backend start now (to upgrade database)?

[Mike Perkins]

On 13/03/12 13:45, Brian J. Murrell wrote:
> So, I was just upgrading my BE to v0.25-beta-99-gff73126 and it
> wouldn't start via upstart (i.e. service mythtv-backend start), so I
> tried starting it at a prompt:
>
> # su - mythtv -c "mythbackend"
> 2012-03-13 09:20:02.738440 C  mythbackend version: master [v0.25-beta-99-gff73126] www.mythtv.org
> 2012-03-13 09:20:02.738649 N  Enabled verbose msgs:  general
> 2012-03-13 09:20:02.738851 N  Setting Log Level to LOG_INFO
> 2012-03-13 09:20:02.739214 I  Added logging to the console
> 2012-03-13 09:20:02.739288 I  Added database logging to table logging
> ...
> 2012-03-13 09:20:04.092083 I  Current MythTV Schema Version (DBSchemaVer): 1296
> 2012-03-13 09:20:05.100344 I  Current MythTV Schema Version (DBSchemaVer): 1296
> 2012-03-13 09:20:06.108608 I  Current MythTV Schema Version (DBSchemaVer): 1296
> 2012-03-13 09:20:07.116941 I  Current MythTV Schema Version (DBSchemaVer): 1296
> 2012-03-13 09:20:08.125199 I  Current MythTV Schema Version (DBSchemaVer): 1296
> 2012-03-13 09:20:08.125616 C  Timed out waiting.
> 2012-03-13 09:20:08.162771 E  Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
> 2012-03-13 09:22:32.821096 C  Database Backup complete.
>
> Warning: MythTV wants to upgrade your database,
> for the TV schema, from 1296 to 1299.
>
> Database Host: localhost
> Database Name: mythconverg
>
> If your system becomes unstable, a database backup is located in /video/mythtv/mythconverg-1296-20120313092008.sql.gz
>
>
> Shall I upgrade this database? [yes]  2012-03-13 09:22:32.910503 C  Backed up database to file: '/video/mythtv/mythconverg-1296-20120313092008.sql.gz'
>
> An interactive prompt?  Huh?  So I hit RETURN and:
>
>
> There are also other clients using this database. They should be shut down first.
> 2012-03-13 09:25:28.024956 C  Newest MythTV Schema Version : 1299
> 2012-03-13 09:25:28.036328 C  Upgrading to MythTV schema version 1297
> 2012-03-13 09:25:28.333661 C  Upgrading to MythTV schema version 1298
> 2012-03-13 09:25:28.742284 C  Upgrading to MythTV schema version 1299
> 2012-03-13 09:25:28.750014 N  Database Schema upgrade complete, unlocking.
> 2012-03-13 09:25:28.753160 I  Loading en_us translation for module mythfrontend
> 2012-03-13 09:25:28.757478 N  MythBackend: Starting up as the master server.
>
> So yeah, it was an interactive prompt in the backend (read: daemon)
> startup.  Deamon's by their very nature are not supposed to expoect
> to have a tty and therefore be allowed to interact.
>
Personally, whenever I upgrade, the first thing I run is mythtv-setup. That way 
I can double-check that the various settings have come across as sane values.

- it would also allow a proper interactive response when upgrading the schemas, 
of course.

-- 

Mike Perkins