Mailing List Archive: MythTV: Users

Mythtv 0.22 upgrade problems

Index | Next | Previous | View Threaded

mythtv at blandford

Nov 7, 2009, 5:58 PM

Post #1 of 24 (1071 views)
Permalink

Mythtv 0.22 upgrade problems

Hello,

I have been running mythtv for several years and am currently at 0.21.

I am trying to upgrade to 0.22 using the atrpms packages.

After the upgrade, running mythvsetup appears to go fine and I see the
schema updates occur.

However, when I start the front end, it tries to update the schema for
mythvideo but fails. On the screen it says:

Warning: MythTV wants to upgrade your database for the Video schema,
from 1016 to 1028.

Messages from the frontend log say:
Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL3: Unable to execute statement
Database error was:
Table 'mythconverg.videocountry' doesn't exist

2009-11-07 18:55:09.110 Couldn't upgrade video database schema, exiting.
2009-11-07 18:55:09.110 Unable to initialize plugin 'mythvideo'.

Looking at the database, that table does not appear to exist.

Any suggestions on how to proceed?

Michael

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 7, 2009, 7:08 PM

Post #2 of 24 (1053 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/07/2009 08:58 PM, mythtv a blandford wrote:
> I have been running mythtv for several years and am currently at 0.21.
>
> I am trying to upgrade to 0.22 using the atrpms packages.
>
> After the upgrade, running mythvsetup appears to go fine and I see the
> schema updates occur.
>
> However, when I start the front end, it tries to update the schema for
> mythvideo but fails. On the screen it says:
>
> Warning: MythTV wants to upgrade your database for the Video schema,
> from 1016 to 1028.
>
> Messages from the frontend log say:
> Query was:
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Table 'mythconverg.videocountry' doesn't exist
>
> 2009-11-07 18:55:09.110 Couldn't upgrade video database schema, exiting.
> 2009-11-07 18:55:09.110 Unable to initialize plugin 'mythvideo'.
>
> Looking at the database, that table does not appear to exist.
>
> Any suggestions on how to proceed?

Backup your database (
http://www.mythtv.org/wiki/Database_Backup_and_Restore ).

Then:

cat << "EOF" | mysql -umythtv -p mythconverg
DROP TABLE IF EXISTS videocast;
DROP TABLE IF EXISTS videocategory;
DROP TABLE IF EXISTS videocountry;
DROP TABLE IF EXISTS videogenre;
DROP TABLE IF EXISTS videometadata;
DROP TABLE IF EXISTS videometadatacast;
DROP TABLE IF EXISTS videometadatacountry;
DROP TABLE IF EXISTS videometadatagenre;
DROP TABLE IF EXISTS videotypes;
DROP TABLE IF EXISTS filemarkup;
DROP TABLE IF EXISTS dvdinput;
DROP TABLE IF EXISTS dvdtranscode;
DELETE FROM settings WHERE value
IN ('mythvideo.DBSchemaVer',
'VideoDBSchemaVer',
'DVDDBSchemaVer');
EOF

Then start mythfrontend and it should re-create the video/DVD schema for
you.

I'm guessing at one point in the past you had only MythDVD or MythVideo
installed back when they were separate plugins.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mythtv at blandford

Nov 7, 2009, 7:33 PM

Post #3 of 24 (1053 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/07/2009 08:08 PM, Michael T. Dean wrote:
> On 11/07/2009 08:58 PM, mythtv a blandford wrote:
>> I have been running mythtv for several years and am currently at 0.21.
>>
>> I am trying to upgrade to 0.22 using the atrpms packages.
>>
>> After the upgrade, running mythvsetup appears to go fine and I see the
>> schema updates occur.
>>
>> However, when I start the front end, it tries to update the schema for
>> mythvideo but fails. On the screen it says:
>>
>> Warning: MythTV wants to upgrade your database for the Video schema,
>> from 1016 to 1028.
>>
>> Messages from the frontend log say:
>> Query was:
>> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
>> Driver error was [2/1146]:
>> QMYSQL3: Unable to execute statement
>> Database error was:
>> Table 'mythconverg.videocountry' doesn't exist
>>
>> 2009-11-07 18:55:09.110 Couldn't upgrade video database schema, exiting.
>> 2009-11-07 18:55:09.110 Unable to initialize plugin 'mythvideo'.
>>
>> Looking at the database, that table does not appear to exist.
>>
>> Any suggestions on how to proceed?
>
> Backup your database (
> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>
> Then:
>
> cat << "EOF" | mysql -umythtv -p mythconverg
> DROP TABLE IF EXISTS videocast;
> DROP TABLE IF EXISTS videocategory;
> DROP TABLE IF EXISTS videocountry;
> DROP TABLE IF EXISTS videogenre;
> DROP TABLE IF EXISTS videometadata;
> DROP TABLE IF EXISTS videometadatacast;
> DROP TABLE IF EXISTS videometadatacountry;
> DROP TABLE IF EXISTS videometadatagenre;
> DROP TABLE IF EXISTS videotypes;
> DROP TABLE IF EXISTS filemarkup;
> DROP TABLE IF EXISTS dvdinput;
> DROP TABLE IF EXISTS dvdtranscode;
> DELETE FROM settings WHERE value
> IN ('mythvideo.DBSchemaVer',
> 'VideoDBSchemaVer',
> 'DVDDBSchemaVer');
> EOF
>
> Then start mythfrontend and it should re-create the video/DVD schema for
> you.
>
> I'm guessing at one point in the past you had only MythDVD or MythVideo
> installed back when they were separate plugins.

Thank you!

Thats seems to have worked fine.

0.22 is coming up fine now. I do have to reassociate all my videos but
it is so worth it! Thank you again,

Michael
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

torbjorn.jansson at gmail

Nov 8, 2009, 2:10 AM

Post #4 of 24 (1037 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

knowledgejunkie at gmail

Nov 10, 2009, 4:56 PM

Post #5 of 24 (882 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

2009/11/8 Michael T. Dean <mtdean[at]thirdcontact.com>:
> On 11/07/2009 08:58 PM, mythtv a blandford wrote:
>>
>> I have been running mythtv for several years and am currently at 0.21.
>>
>> I am trying to upgrade to 0.22 using the atrpms packages.
>>
>> After the upgrade, running mythvsetup appears to go fine and I see the
>> schema updates occur.
>>
>> However, when I start the front end, it tries to update the schema for
>> mythvideo but fails. �On the screen it says:
>>
>> Warning: MythTV wants to upgrade your database for the Video schema, from
>> 1016 to 1028.
>>
>> Messages from the frontend log say:
>> Query was:
>> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
>> Driver error was [2/1146]:
>> QMYSQL3: Unable to execute statement
>> Database error was:
>> Table 'mythconverg.videocountry' doesn't exist
>>
>> 2009-11-07 18:55:09.110 Couldn't upgrade video database schema, exiting.
>> 2009-11-07 18:55:09.110 Unable to initialize plugin 'mythvideo'.
>>
>> Looking at the database, that table does not appear to exist.
>>
>> Any suggestions on how to proceed?
>
> Backup your database (
> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>
> Then:
>
> cat << "EOF" | mysql -umythtv -p mythconverg
> DROP TABLE IF EXISTS videocast;
> DROP TABLE IF EXISTS videocategory;
> DROP TABLE IF EXISTS videocountry;
> DROP TABLE IF EXISTS videogenre;
> DROP TABLE IF EXISTS videometadata;
> DROP TABLE IF EXISTS videometadatacast;
> DROP TABLE IF EXISTS videometadatacountry;
> DROP TABLE IF EXISTS videometadatagenre;
> DROP TABLE IF EXISTS videotypes;
> DROP TABLE IF EXISTS filemarkup;
> DROP TABLE IF EXISTS dvdinput;
> DROP TABLE IF EXISTS dvdtranscode;
> DELETE FROM settings WHERE value
> � IN ('mythvideo.DBSchemaVer',
> � � � 'VideoDBSchemaVer',
> � � � 'DVDDBSchemaVer');
> EOF
>
> Then start mythfrontend and it should re-create the video/DVD schema for
> you.
>
> I'm guessing at one point in the past you had only MythDVD or MythVideo
> installed back when they were separate plugins.

Is there a reason why a check for missing tables (and their creation
if found to be missing) was not the first schema update once MythVideo
and MythDVD were integrated. I'm sure Michael will not be the last
user to have used one or the other plugin exclusively in the past.

Is it possible to retrospectively alter the MythVideo schema for 1016
to "CREATE TABLE IF NOT EXISTS..." first, so that we check for any
missing tables and create them instead of having the upgrade fail?

Cheers,
Nick

--
Nick Morrott

MythTV Official wiki: http://mythtv.org/wiki/
MythTV users list archive: http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 10, 2009, 5:35 PM

Post #6 of 24 (880 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/10/2009 07:56 PM, Nick Morrott wrote:
> 2009/11/8 Michael T. Dean:
>
>> On 11/07/2009 08:58 PM, mythtv a blandford wrote:
>>
>>> I have been running mythtv for several years and am currently at 0.21.
>>>
>>> I am trying to upgrade to 0.22 using the atrpms packages.
>>>
>>> After the upgrade, running mythvsetup appears to go fine and I see the
>>> schema updates occur.
>>>
>>> However, when I start the front end, it tries to update the schema for
>>> mythvideo but fails. On the screen it says:
>>>
>>> Warning: MythTV wants to upgrade your database for the Video schema, from
>>> 1016 to 1028.
>>>
>>> Messages from the frontend log say:
>>> Query was:
>>> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
>>> Driver error was [2/1146]:
>>> QMYSQL3: Unable to execute statement
>>> Database error was:
>>> Table 'mythconverg.videocountry' doesn't exist
>>>
>>> 2009-11-07 18:55:09.110 Couldn't upgrade video database schema, exiting.
>>> 2009-11-07 18:55:09.110 Unable to initialize plugin 'mythvideo'.
>>>
>>> Looking at the database, that table does not appear to exist.
>>>
>>> Any suggestions on how to proceed?
>>>
>> Backup your database (
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>>
>> Then:
>>
>> cat << "EOF" | mysql -umythtv -p mythconverg
>> DROP TABLE IF EXISTS videocast;
>> DROP TABLE IF EXISTS videocategory;
>> DROP TABLE IF EXISTS videocountry;
>> DROP TABLE IF EXISTS videogenre;
>> DROP TABLE IF EXISTS videometadata;
>> DROP TABLE IF EXISTS videometadatacast;
>> DROP TABLE IF EXISTS videometadatacountry;
>> DROP TABLE IF EXISTS videometadatagenre;
>> DROP TABLE IF EXISTS videotypes;
>> DROP TABLE IF EXISTS filemarkup;
>> DROP TABLE IF EXISTS dvdinput;
>> DROP TABLE IF EXISTS dvdtranscode;
>> DELETE FROM settings WHERE value
>> IN ('mythvideo.DBSchemaVer',
>> 'VideoDBSchemaVer',
>> 'DVDDBSchemaVer');
>> EOF
>>
>> Then start mythfrontend and it should re-create the video/DVD schema for
>> you.
>>
>> I'm guessing at one point in the past you had only MythDVD or MythVideo
>> installed back when they were separate plugins.
>>
>
> Is there a reason why a check for missing tables (and their creation
> if found to be missing) was not the first schema update once MythVideo
> and MythDVD were integrated. I'm sure Michael will not be the last
> user to have used one or the other plugin exclusively in the past.
>
> Is it possible to retrospectively alter the MythVideo schema for 1016
> to "CREATE TABLE IF NOT EXISTS..." first, so that we check for any
> missing tables and create them instead of having the upgrade fail?

Mine was a guess as to where we might have a bug--that's all I'm
motivated to provide because:

a) the MythVideo/MythDVD integration occurred prior to MythTV 0.21
(therefore, nearly /all/ users have already been through it, so if there
is a bug, their schemas are already broken),
b) if there was a problem with it, not only would we have to fix the
problem, but because everyone's already used the buggy code to upgrade,
we'd have to identify all possible failure modes, the extent of the
problems they caused, and write code to programmatically identify which
failure occurred and to fix all those possible failures,
c) since we've already released MythTV 0.22, we can't add new DB schema
changes even if we fix the upgrade that's failing to ignore failures
d) because of the above, there's not a good place to add new fixes
e) resetting MythVideo's data (and MythDVD really has none) is not a bad
idea with the upgrade to MythTV 0.22--due to all the new support for
advanced and image metadata, nearly everyone will be redoing all their
video metadata, anyway, and clearing out all the old MythVideo data is
pretty much the only way to switch to using MythVideo Storage Groups
f) if someone does the reset the MythVideo schema, they can be
absolutely certain that their MythVideo schema is correct--regardless of
what's happened in the past.

If someone else tracks down the bug(s) and finds a good solution that
fixes all possible problems caused by it, I'd be happy to take a look at
it. I just don't feel it's worth the time (mine or, for that matter,
anyone else's) to do so when copy/pasting the above mysql command into a
terminal fixes the issue in 1/2 second. :)

The only downside to this approach is that users have to find the
instructions for handling this issue. :(

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

goluboff+mythtv at gmail

Nov 13, 2009, 10:08 PM

Post #7 of 24 (757 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Sat, Nov 7, 2009 at 9:08 PM, Michael T. Dean <mtdean[at]thirdcontact.com>wrote:

>
> Backup your database (
> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>
> Then:
>
> cat << "EOF" | mysql -umythtv -p mythconverg
> DROP TABLE IF EXISTS videocast;
> DROP TABLE IF EXISTS videocategory;
> DROP TABLE IF EXISTS videocountry;
> DROP TABLE IF EXISTS videogenre;
> DROP TABLE IF EXISTS videometadata;
> DROP TABLE IF EXISTS videometadatacast;
> DROP TABLE IF EXISTS videometadatacountry;
> DROP TABLE IF EXISTS videometadatagenre;
> DROP TABLE IF EXISTS videotypes;
> DROP TABLE IF EXISTS filemarkup;
> DROP TABLE IF EXISTS dvdinput;
> DROP TABLE IF EXISTS dvdtranscode;
> DELETE FROM settings WHERE value
> IN ('mythvideo.DBSchemaVer',
> 'VideoDBSchemaVer',
> 'DVDDBSchemaVer');
> EOF
>
> Then start mythfrontend and it should re-create the video/DVD schema for
> you.
>
> I'm guessing at one point in the past you had only MythDVD or MythVideo
> installed back when they were separate plugins.
>
> Mike

I was having a similar problem after going from Ubuntu 9.04 to Ubuntu 9.10
(and Myth 0.21 to 0.22). I cleared the database per the commands above, and
now mythfrontend starts without a segfault!

The problem now is that the Video Manager doesn't find any files when I try
to scan for them. I get the following on the terminal:
Database error was:
Table 'mythconverg.videometadata' doesn't exist

So it looks like the video/DVD schema was not re-created correctly. How can
I do it manually so I can watch videos again? (at least I can watch
recordings on 0.22 now, yay!)

Mariano

goluboff+mythtv at gmail

Nov 13, 2009, 10:15 PM

Post #8 of 24 (757 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Sat, Nov 14, 2009 at 12:08 AM, Mariano Goluboff <
goluboff+mythtv[at]gmail.com <goluboff%2Bmythtv[at]gmail.com>> wrote:

>
>
> On Sat, Nov 7, 2009 at 9:08 PM, Michael T. Dean <mtdean[at]thirdcontact.com>wrote:
>
>>
>> Backup your database (
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>>
>> Then:
>>
>> cat << "EOF" | mysql -umythtv -p mythconverg
>> DROP TABLE IF EXISTS videocast;
>> DROP TABLE IF EXISTS videocategory;
>> DROP TABLE IF EXISTS videocountry;
>> DROP TABLE IF EXISTS videogenre;
>> DROP TABLE IF EXISTS videometadata;
>> DROP TABLE IF EXISTS videometadatacast;
>> DROP TABLE IF EXISTS videometadatacountry;
>> DROP TABLE IF EXISTS videometadatagenre;
>> DROP TABLE IF EXISTS videotypes;
>> DROP TABLE IF EXISTS filemarkup;
>> DROP TABLE IF EXISTS dvdinput;
>> DROP TABLE IF EXISTS dvdtranscode;
>> DELETE FROM settings WHERE value
>> IN ('mythvideo.DBSchemaVer',
>> 'VideoDBSchemaVer',
>> 'DVDDBSchemaVer');
>> EOF
>>
>> Then start mythfrontend and it should re-create the video/DVD schema for
>> you.
>>
>> I'm guessing at one point in the past you had only MythDVD or MythVideo
>> installed back when they were separate plugins.
>>
>> Mike
>
>
> I was having a similar problem after going from Ubuntu 9.04 to Ubuntu 9.10
> (and Myth 0.21 to 0.22). I cleared the database per the commands above, and
> now mythfrontend starts without a segfault!
>
> The problem now is that the Video Manager doesn't find any files when I try
> to scan for them. I get the following on the terminal:
> Database error was:
> Table 'mythconverg.videometadata' doesn't exist
>
> So it looks like the video/DVD schema was not re-created correctly. How can
> I do it manually so I can watch videos again? (at least I can watch
> recordings on 0.22 now, yay!)
>
> Mariano
>

Well, an update, now mythfrontend doesn't start anymore after exiting.
Segmentation fault after saying:
Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1028

mtdean at thirdcontact

Nov 14, 2009, 11:01 AM

Post #9 of 24 (705 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/14/2009 01:15 AM, Mariano Goluboff wrote:
> On Sat, Nov 14, 2009 at 12:08 AM, Mariano Goluboff wrote:
>
>> On Sat, Nov 7, 2009 at 9:08 PM, Michael T. Dean wrote:
>>
>>> Backup your database (
>>> http://www.mythtv.org/wiki/Database_Backup_and_Restore ).
>>>
>>> Then:
...
>>> Then start mythfrontend and it should re-create the video/DVD schema for
>>> you.
>> I was having a similar problem after going from Ubuntu 9.04 to Ubuntu 9.10
>> (and Myth 0.21 to 0.22). I cleared the database per the commands above, and
>> now mythfrontend starts without a segfault!
>>
>> The problem now is that the Video Manager doesn't find any files when I try
>> to scan for them. I get the following on the terminal:
>> Database error was:
>> Table 'mythconverg.videometadata' doesn't exist
>>
>> So it looks like the video/DVD schema was not re-created correctly. How can
>> I do it manually so I can watch videos again? (at least I can watch
>> recordings on 0.22 now, yay!)
> Well, an update, now mythfrontend doesn't start anymore after exiting.
> Segmentation fault after saying:
> Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1028

Please try re-running the mysql command. If MythVideo can't upgrade the
schema after doing so, please paste the output of the mysql command.
The following will capture the output in a file called results.log in
the user's home directory:

cat << "EOF" | mysql -umythtv -p mythconverg 2>&1 | tee results.log
DROP TABLE IF EXISTS videocast;
DROP TABLE IF EXISTS videocategory;
DROP TABLE IF EXISTS videocountry;
DROP TABLE IF EXISTS videogenre;
DROP TABLE IF EXISTS videometadata;
DROP TABLE IF EXISTS videometadatacast;
DROP TABLE IF EXISTS videometadatacountry;
DROP TABLE IF EXISTS videometadatagenre;
DROP TABLE IF EXISTS videotypes;
DROP TABLE IF EXISTS filemarkup;
DROP TABLE IF EXISTS dvdinput;
DROP TABLE IF EXISTS dvdtranscode;
DELETE FROM settings WHERE value
IN ('mythvideo.DBSchemaVer',
'VideoDBSchemaVer',
'DVDDBSchemaVer');
EOF

Also, please attach (or pastebin) the (whole) frontend log from trying
to start mythfrontend right after running the above mysql command (make
sure you get rid of any old log information in the file before starting
mythfrontend so that it only shows the session that attempted and failed
to upgrade the MythVideo schema).

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 14, 2009, 11:06 AM

Post #10 of 24 (705 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/14/2009 02:01 PM, Michael T. Dean wrote:
> The following will capture the output in a file called results.log in
> the user's home directory:

er, the current directory...

>
> cat << "EOF" | mysql -umythtv -p mythconverg 2>&1 | tee results.log
> DROP TABLE IF EXISTS videocast;
> DROP TABLE IF EXISTS videocategory;
> DROP TABLE IF EXISTS videocountry;
> DROP TABLE IF EXISTS videogenre;
> DROP TABLE IF EXISTS videometadata;
> DROP TABLE IF EXISTS videometadatacast;
> DROP TABLE IF EXISTS videometadatacountry;
> DROP TABLE IF EXISTS videometadatagenre;
> DROP TABLE IF EXISTS videotypes;
> DROP TABLE IF EXISTS filemarkup;
> DROP TABLE IF EXISTS dvdinput;
> DROP TABLE IF EXISTS dvdtranscode;
> DELETE FROM settings WHERE value
> IN ('mythvideo.DBSchemaVer',
> 'VideoDBSchemaVer',
> 'DVDDBSchemaVer');
> EOF

To put it in the user's home directory, change the command to include
$HOME/results.log . (I forgot to do that before sending.)

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

goluboff+mythtv at gmail

Nov 14, 2009, 1:32 PM

Post #11 of 24 (694 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Sat, Nov 14, 2009 at 1:01 PM, Michael T. Dean <mtdean[at]thirdcontact.com>wrote:

> On 11/14/2009 01:15 AM, Mariano Goluboff wrote:
>
>> On Sat, Nov 14, 2009 at 12:08 AM, Mariano Goluboff wrote:
>>
>> Well, an update, now mythfrontend doesn't start anymore after exiting.
>>
>
>> Segmentation fault after saying:
>> Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1028
>>
>
> Please try re-running the mysql command. If MythVideo can't upgrade the
> schema after doing so, please paste the output of the mysql command. The
> following will capture the output in a file called results.log in the user's
> home directory:
>
>
Ok, I re-ran the mysql command and this time it was able to re-create the
database correctly, so now MythVideo starts and I can scan my videos and
find them.

An interesting problem I'm now running into is that when I type mythfrontend
to start it, it gives me a segmentation fault about 4 times out of 5. So I
have to try to start it about 5 times for it to start once.

Here's the log when it seg faults:
2009-11-14 15:13:49.789 mythfrontend version: branches/release-0-22-fixes
[22594] www.mythtv.org
2009-11-14 15:13:49.813 AudioPulseUtil: Suspend Success
2009-11-14 15:13:49.814 Using runtime prefix = /usr
2009-11-14 15:13:49.814 Using configuration directory =
/home/mariano/.mythtv
2009-11-14 15:13:50.421 Empty LocalHostName.
2009-11-14 15:13:50.421 Using localhost value of mythtvbox
2009-11-14 15:13:50.426 New DB connection, total: 1
2009-11-14 15:13:50.430 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:50.430 Closing DB connection named 'DBManager0'
2009-11-14 15:13:50.442 ScreenSaverX11Private: Gnome screen saver support
enabled
2009-11-14 15:13:50.443 DPMS is active.
2009-11-14 15:13:50.444 Primary screen: 0.
2009-11-14 15:13:50.445 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:50.447 Using screen 0, 800x600 at 0,0
2009-11-14 15:13:50.470 MythUI Image Cache size set to 20971520 bytes
2009-11-14 15:13:50.471 Enabled verbose msgs: important general
2009-11-14 15:13:50.477 Primary screen: 0.
2009-11-14 15:13:50.477 Using screen 0, 800x600 at 0,0
2009-11-14 15:13:50.478 Using theme base resolution of 800x600
2009-11-14 15:13:50.485 LIRC: Successfully initialized '/dev/lircd' using
'/home/mariano/.mythtv/lircrc' config
2009-11-14 15:13:50.486 JoystickMenuThread Error: Joystick disabled - Failed
to read /home/mariano/.mythtv/joystickmenurc
2009-11-14 15:13:50.558 Using the OpenGL painter
2009-11-14 15:13:50.653 Loaded base theme from
/usr/share/mythtv/themes/MythCenter/base.xml
2009-11-14 15:13:50.806 Loaded base theme from
/usr/share/mythtv/themes/default/base.xml
2009-11-14 15:13:50.811 Current MythTV Schema Version (DBSchemaVer): 1244
2009-11-14 15:13:50.842 New DB connection, total: 2
2009-11-14 15:13:50.842 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:50.955 Desktop video mode: 800x600 60.3173 Hz
2009-11-14 15:13:51.061 Key [.,{,F10,Volume Down is bound to multiple actions
in context TV Frontend.
2009-11-14 15:13:51.061 Key ],},F11,Volume Up is bound to multiple actions
in context TV Frontend.
2009-11-14 15:13:51.095 Registering Internal as a media playback plugin.
2009-11-14 15:13:51.102 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1028
Segmentation fault

And here's the log when it starts correctly:
2009-11-14 15:13:55.387 mythfrontend version: branches/release-0-22-fixes
[22594] www.mythtv.org
2009-11-14 15:13:55.409 AudioPulseUtil: Suspend Success
2009-11-14 15:13:55.411 Using runtime prefix = /usr
2009-11-14 15:13:55.411 Using configuration directory =
/home/mariano/.mythtv
2009-11-14 15:13:56.217 Empty LocalHostName.
2009-11-14 15:13:56.217 Using localhost value of mythtvbox
2009-11-14 15:13:56.222 New DB connection, total: 1
2009-11-14 15:13:56.225 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:56.226 Closing DB connection named 'DBManager0'
2009-11-14 15:13:56.237 ScreenSaverX11Private: Gnome screen saver support
enabled
2009-11-14 15:13:56.238 DPMS is active.
2009-11-14 15:13:56.239 Primary screen: 0.
2009-11-14 15:13:56.240 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:56.242 Using screen 0, 800x600 at 0,0
2009-11-14 15:13:56.266 MythUI Image Cache size set to 20971520 bytes
2009-11-14 15:13:56.267 Enabled verbose msgs: important general
2009-11-14 15:13:56.273 Primary screen: 0.
2009-11-14 15:13:56.273 Using screen 0, 800x600 at 0,0
2009-11-14 15:13:56.274 Using theme base resolution of 800x600
2009-11-14 15:13:56.281 LIRC: Successfully initialized '/dev/lircd' using
'/home/mariano/.mythtv/lircrc' config
2009-11-14 15:13:56.282 JoystickMenuThread Error: Joystick disabled - Failed
to read /home/mariano/.mythtv/joystickmenurc
2009-11-14 15:13:56.366 Using the OpenGL painter
2009-11-14 15:13:56.454 Loaded base theme from
/usr/share/mythtv/themes/MythCenter/base.xml
2009-11-14 15:13:56.607 Loaded base theme from
/usr/share/mythtv/themes/default/base.xml
2009-11-14 15:13:56.612 Current MythTV Schema Version (DBSchemaVer): 1244
2009-11-14 15:13:56.633 New DB connection, total: 2
2009-11-14 15:13:56.635 Connected to database 'mythconverg' at host:
localhost
2009-11-14 15:13:56.757 Desktop video mode: 800x600 60.3173 Hz
2009-11-14 15:13:56.862 Key [.,{,F10,Volume Down is bound to multiple actions
in context TV Frontend.
2009-11-14 15:13:56.863 Key ],},F11,Volume Up is bound to multiple actions
in context TV Frontend.
2009-11-14 15:13:56.896 Registering Internal as a media playback plugin.
2009-11-14 15:13:56.903 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1028
2009-11-14 15:13:56.951 MMUnix::AddDevice() Error: failed to stat /dev/bdi,
eno: No such file or directory (2)
2009-11-14 15:13:56.956 MMUnix::AddDevice() Error: failed to stat
/dev/power,
eno: No such file or directory (2)
2009-11-14 15:13:56.960 MMUnix::AddDevice() Error: failed to stat
/dev/trace,
eno: No such file or directory (2)
2009-11-14 15:13:56.968 Loading window theme from
/usr/share/mythtv/themes/MythCenter/menu-ui.xml
2009-11-14 15:13:57.090 Loading menu theme from
/usr/share/mythtv/themes/defaultmenu//mainmenu.xml
2009-11-14 15:13:57.091 Found mainmenu.xml for theme 'MythCenter'
2009-11-14 15:13:57.255 Using NV NPOT texture extension
2009-11-14 15:13:57.305 MythContext: Connecting to backend server:
127.0.0.1:6543 (try 1 of 1)
2009-11-14 15:13:57.306 Using protocol version 50

mtdean at thirdcontact

Nov 14, 2009, 1:53 PM

Post #12 of 24 (695 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/14/2009 04:32 PM, Mariano Goluboff wrote:
> Ok, I re-ran the mysql command and this time it was able to re-create the
> database correctly, so now MythVideo starts and I can scan my videos and
> find them.
>
> An interesting problem I'm now running into is that when I type mythfrontend
> to start it, it gives me a segmentation fault about 4 times out of 5. So I
> have to try to start it about 5 times for it to start once.
>
> Here's the log when it seg faults:
>
...
> 2009-11-14 15:13:51.102 Current MythVideo Schema Version
> (mythvideo.DBSchemaVer): 1028
> Segmentation fault
>
> And here's the log when it starts correctly:
>
...
> 2009-11-14 15:13:56.903 Current MythVideo Schema Version
> (mythvideo.DBSchemaVer): 1028
> 2009-11-14 15:13:56.951 MMUnix::AddDevice() Error: failed to stat /dev/bdi,
> eno: No such file or directory (2)
> 2009-11-14 15:13:56.956 MMUnix::AddDevice() Error: failed to stat
> /dev/power,
> eno: No such file or directory (2)
> 2009-11-14 15:13:56.960 MMUnix::AddDevice() Error: failed to stat
> /dev/trace,
> eno: No such file or directory (2)

That's almost definitely unrelated to MythVideo, but due to issues in
http://svn.mythtv.org/trac/ticket/6137 and
http://svn.mythtv.org/trac/ticket/7135 (which, itself, is related to #6137).

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

goluboff+mythtv at gmail

Nov 14, 2009, 5:19 PM

Post #13 of 24 (664 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Sat, Nov 14, 2009 at 3:53 PM, Michael T. Dean <mtdean[at]thirdcontact.com>wrote:

> On 11/14/2009 04:32 PM, Mariano Goluboff wrote:
>
>>
>> And here's the log when it starts correctly:
>>
>>
> ...
>
>> 2009-11-14 15:13:56.903 Current MythVideo Schema Version
>>
>> (mythvideo.DBSchemaVer): 1028
>> 2009-11-14 15:13:56.951 MMUnix::AddDevice() Error: failed to stat
>> /dev/bdi,
>> eno: No such file or directory (2)
>> 2009-11-14 15:13:56.956 MMUnix::AddDevice() Error: failed to stat
>> /dev/power,
>> eno: No such file or directory (2)
>> 2009-11-14 15:13:56.960 MMUnix::AddDevice() Error: failed to stat
>> /dev/trace,
>> eno: No such file or directory (2)
>>
>
> That's almost definitely unrelated to MythVideo, but due to issues in
> http://svn.mythtv.org/trac/ticket/6137 and
> http://svn.mythtv.org/trac/ticket/7135 (which, itself, is related to
> #6137).
>
>
> Mike
> _______________________________________________
>
>
Yikes, those 2 sound like they won't be fixed for a while. Looks like I'll
have to try opening the frontend multiple times every time I need to open
it...

Mariano

easygreenus at yahoo

Nov 16, 2009, 9:26 PM

Post #14 of 24 (527 views)
Permalink

Mythtv 0.22 upgrade problems [In reply to]

Hi,

I've had problems with MythVideo since I updated to 0.22. When I try to watch
a movie, I had an icon for it, but it appeared to be looking in the wrong directory. It was looking in
a directory that I used to keep videos in, but have since changed. Dumping
the database, I found references to all my DVDs with the old path.

So, I did surgery on the database like that describe in this thread.
When I started mythfrontend, it asked me if it could upgrade the database.
Said yes. Got the following messages ( and more ) on my console
Went to

2009-11-17 00:15:49.817 Updated from old MythDVD/MythVideo schema to combined version: 1011.

Now when I go into myvideo, I don't see any movies or folder icons. How do I add my
DVDs ( in .iso format ) back to mythvideo?

2009-11-17 00:15:49.645 Inserting MythVideo initial database information.
2009-11-17 00:15:49.645 Upgrading to MythVideo schema version 1000
2009-11-17 00:15:49.652 New DB connection, total: 2
2009-11-17 00:15:49.654 Connected to database 'mythconverg' at host: 192.168.1.142
2009-11-17 00:15:49.656 Upgraded to MythVideo schema version 1000
2009-11-17 00:15:49.657 Upgrading to MythVideo schema version 1000
2009-11-17 00:15:49.661 New DB connection, total: 3
2009-11-17 00:15:49.663 Connected to database 'mythconverg' at host: 192.168.1.142
2009-11-17 00:15:49.665 Upgraded to MythVideo schema version 1000
2009-11-17 00:15:49.666 Upgrading to MythVideo schema version 1001
2009-11-17 00:15:49.674 Upgraded to MythVideo schema version 1001
2009-11-17 00:15:49.674 Upgrading to MythVideo schema version 1002

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 16, 2009, 11:49 PM

Post #15 of 24 (517 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On 11/17/2009 12:26 AM, Mike Smith wrote:
> I've had problems with MythVideo since I updated to 0.22. When I try to watch
> a movie, I had an icon for it, but it appeared to be looking in the wrong directory. It was looking in
> a directory that I used to keep videos in, but have since changed. Dumping
> the database, I found references to all my DVDs with the old path.
>
> So, I did surgery on the database like that describe in this thread.
> When I started mythfrontend, it asked me if it could upgrade the database.
> Said yes. Got the following messages ( and more ) on my console
> Went to
>
> 2009-11-17 00:15:49.817 Updated from old MythDVD/MythVideo schema to combined version: 1011.
>
> Now when I go into myvideo, I don't see any movies or folder icons. How do I add my
> DVDs ( in .iso format ) back to mythvideo?

Do a scan. In MythVideo, hit M then Scan for Videos.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

easygreenus at yahoo

Nov 17, 2009, 9:11 PM

Post #16 of 24 (449 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

I did the scan and it found all my videos. Now, when I go into MythVideo, I see
a list of the .iso files I have in the /var/dvd directory. But, when I try to play one
of them, nothing happens. I get the message below when trying to use Mplayer.
When I try to use the Internal Viewer, it puts up that black screen that looks like the
start of a movie for about 2 seconds, then goes to the tan background color for 5
seconds, then back to the menu. The console has messages complaining that it
can't open the /dev/dvd device.

Also, /var/dvd/BEERFEST.iso is an NFS mount on the mythfrontend client.

MPlayer SVN-r29189-snapshot-4.3.2 (C) 2000-2009 MPlayer Team
137 audio & 296 video codecs
Can't open joystick device /dev/input/js0: No such file or directory
Can't init input joystick
mplayer: could not connect to socket
mplayer: No such file or directory
Failed to open LIRC support. You will not be able to use your remote control.

Playing myth://Videos[at]192.168.1.142:6543/BEERFEST.iso.
No stream found to handle url myth://Videos[at]192.168.1.142:6543/BEERFEST.iso

Exiting... (End of file)
2009-11-18 00:07:57.313 Deleting UPnP client...

[mythtv[at]mythtv ~]$ ls -l /var/dvd/BEERFEST.iso
-rw-rw-rw- 1 mythtv mythtv 8314814464 2008-08-14 02:25 /var/dvd/BEERFEST.iso

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

robert.mcnamara at gmail

Nov 17, 2009, 9:15 PM

Post #17 of 24 (449 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Tue, Nov 17, 2009 at 9:11 PM, Mike Smith <easygreenus[at]yahoo.com> wrote:
> I did the scan and it found all my videos. �Now, when I go into MythVideo, �I see
> a list of the .iso files I have in the /var/dvd directory. �But, when I try to play one
> of them, nothing happens. �I get the message below when trying to use Mplayer.
> When I try to use the Internal Viewer, �it puts up that black screen that looks like the
> start of a movie for about 2 seconds, then goes to the tan background color for 5
> seconds, then back to the menu. �The console has messages complaining that it
> can't open the /dev/dvd device.
>
> Also, /var/dvd/BEERFEST.iso is an NFS mount on the mythfrontend client.
>
> MPlayer SVN-r29189-snapshot-4.3.2 (C) 2000-2009 MPlayer Team
> 137 audio & 296 video codecs
> Can't open joystick device /dev/input/js0: No such file or directory
> Can't init input joystick
> mplayer: could not connect to socket
> mplayer: No such file or directory
> Failed to open LIRC support. You will not be able to use your remote control.
>
> Playing myth://Videos[at]192.168.1.142:6543/BEERFEST.iso.
> No stream found to handle url myth://Videos[at]192.168.1.142:6543/BEERFEST.iso
>
>
> Exiting... (End of file)
> 2009-11-18 00:07:57.313 Deleting UPnP client...
>
>
> [mythtv[at]mythtv ~]$ ls -l /var/dvd/BEERFEST.iso
> -rw-rw-rw- 1 mythtv mythtv 8314814464 2008-08-14 02:25 /var/dvd/BEERFEST.iso

mplayer won't work with storage groups, and neither will the internal
player with ISO files which are Storage Group homed, presently.

To play this particular file you would need to have it as a locally
hosted file, not in a storage group.

Robert
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

easygreenus at yahoo

Nov 18, 2009, 12:09 AM

Post #18 of 24 (437 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

Sorry for my confusion, but I don't think I created a storage group /var/dvd.
I did setup mythvideo to look in /var/dvd for the videos. On my backend
system, /var/dvd is a local filesystem. On my frontend, its NFS mounted.

Are you saying mplayer won't work with an NFS mounted filesystem?

Thanks,

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

robert.mcnamara at gmail

Nov 18, 2009, 12:25 AM

Post #19 of 24 (434 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Wed, Nov 18, 2009 at 12:09 AM, Mike Smith <easygreenus[at]yahoo.com> wrote:
> Sorry for my confusion, but I don't think I created a storage group /var/dvd.

Whatever you did point myth's video storage group at contains that
file, or did last time you scanned, or it wouldn't be set up as a
storage group hosted file in the DB now.

> Are you saying mplayer won't work with an NFS mounted filesystem?
>

No, I'm saying what I said before-- the URL that's being passed to
mplayer (myth://Videos[at]192.168.1.142:6543/BEERFEST.iso) tells us that
the metadata for the movie thinks it's storage groups hosted, which
won't work in mplayer. not coincidentally, ISO playback also won't
work with the Internal player via storage groups right now. Simply
mounting the directories is not enough, you need to remove the video
storage group and rescan with only the NFS mount (and a properly
configured frontend setting pointing to that dir) to be able to use
mplayer, or play ISOs with the internal player.

Robert
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

jarpublic at gmail

Nov 18, 2009, 7:37 AM

Post #20 of 24 (386 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

> No, I'm saying what I said before-- the URL that's being passed to
> mplayer (myth://Videos[at]192.168.1.142:6543/BEERFEST.iso) tells us that
> the metadata for the movie thinks it's storage groups hosted, which
> won't work in mplayer. �not coincidentally, ISO playback also won't
> work with the Internal player via storage groups right now. �Simply
> mounting the directories is not enough, you need to remove the video
> storage group and rescan with only the NFS mount (and a properly
> configured frontend setting pointing to that dir) to be able to use
> mplayer, or play ISOs with the internal player.

Read http://www.mythtv.org/wiki/MythVideo_.22_Transition_Guide. If you
set it up on the backend with mythtv-setup then you were setting up
storage groups. If you set it up in the frontend video settings then
you are using the local setup. If you setup both then the storage
groups will be given priority. You can completely remove the storage
groups and only use the local setup. Or you can make sure that your
folder with ISOs is not in the videos storage group and then setup
only that folder in the local frontend setup.
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

easygreenus at yahoo

Nov 18, 2009, 8:10 AM

Post #21 of 24 (385 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

I've never created a storage group.� The only one I have is the default,
and its in /var/video, not /var/dvd.

Why or how could Myth get confused about this?

Thanks,

Mark

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

robert.mcnamara at gmail

Nov 18, 2009, 8:25 AM

Post #22 of 24 (372 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Wed, Nov 18, 2009 at 8:10 AM, Mike Smith <easygreenus[at]yahoo.com> wrote:
> I've never created a storage group.� The only one I have is the default,
> and its in /var/video, not /var/dvd.
>
> Why or how could Myth get confused about this?

It can't. The *only* way myth will think that there's a video storage
group is if hostnames exist in your videometadata records, and those
only get inserted if the backend returns a file list from the video
storage group. Are you using Mythbuntu? Have you run any external
metadata grabbing scripts?

Paste in the mysql output for:

SELECT * from storagegroup;

Robert
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

easygreenus at yahoo

Nov 18, 2009, 5:43 PM

Post #23 of 24 (331 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

Robert,

You were right. I did have a Videos Storage Group. I don't know how it got there.
Must be an artifact of some upgrade somewhere.

I deleted the Videos Storage group, rescanned my Videos and now I can watch
.iso movies with the internal player. Did not work with mplayer. Looks like it was
trying to rescale or something.

Thanks,

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

robert.mcnamara at gmail

Nov 18, 2009, 5:45 PM

Post #24 of 24 (331 views)
Permalink

Re: Mythtv 0.22 upgrade problems [In reply to]

On Wed, Nov 18, 2009 at 5:43 PM, Mike Smith <easygreenus[at]yahoo.com> wrote:
> Robert,
>
> You were right. �I did have a Videos Storage Group. �I don't know how it got there.
> Must be an artifact of some upgrade somewhere.
>
> I deleted the Videos Storage group, rescanned my Videos and now I can watch
> .iso movies with the internal player. �Did not work with mplayer. �Looks like it was
> trying to rescale or something.
>
> Thanks,
>
> Mike

Mike,

Glad you got it sorted out, enjoy.

Robert
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com