[mythtv-users] dd_v_ tables missing from mythconverg
R. G. Newbury
newbury at mandamus.org
Tue Nov 13 03:10:44 UTC 2007
Michael T. Dean wrote:
> On 11/12/2007 09:14 AM, R. G. Newbury wrote:
>> William Munson wrote:
>>> R. G. Newbury wrote:
>>>> I think I have borked by mythconverg database and do not have an old
>>>> enough backup to reconstruct the prior state.
>>>> SVN 14830 segfaulted at every attempt to play LiveTV or from the
>>>> library. I stepped back to 14794. But I think the error may have
>>>> predated that as I have listings for only 8 days. This is most likely
>>>> the result of a schema advance and revert...Operator error!
>>>> DBSchemaVer is 1201. Mythfilldatabase reports that is cannot do inserts
>>>> to various "dd_v_xxx" tables. Those tables do not exist.
>>>> So, how do I "re-update" and make it stick? As noted, 14830 segfaults badly.
>>> I have not tried this myself but you should be able to change
>>> DBSchemaVer in the settings table to a lower number and rerun
>>> mythtv-setup to re-upgrade your database. With a reasonably current SVN
>>> I have a version of 1201.
>> I tried something like this...I changed DBSchemaVer to 1200 in
> Generally not a good idea to mess with DBSchemaVer... Always better to do
>> but I cannot now be sure that I didn't just restart mythbackend
>> and frontend....I cannot remember.
>> But whatever I did, changed DBSchemaVer to 1201 again, but DID NOT
>> create the missing tables....
>> I will try it again, running mythtv-setup first.
>> Anyone else have any good ideas? (I don't mind hearing *bad* ideas, but
>> I make no promises about using them!)
> the MythTV "Spring Cleaning" (TM):
Mike you have to go to a meeting. In the meantime, repeat after me: 'I'm
Mike and I am an addict. I am addicted to telling everyone to delete all
their cards from the database and then recreate them'.
Cause of course, that's what the 'Spring Cleaning' (MM Mike's Mark!)
But yes, that would be one way of forcing a schema upgrade. However, it
would be a little faster to just use the --tables switch in mysqldump to
back up the desired tables. The real killer being, of course, that I
would lose all the particular settings which let my box play HD without
xvmc (not available for Intel 945G and exceedingly dependent upon a
couple of switches being exactly right)
.....A little more work required to create a separate 'settings' table
dump and to diff it and edit it, I guess...
Thanks for the idea, however. I will try the straight schema change, but
I suspect that it is a non-starter, although why is another question.
Then it's off for the backup route. Only 7 days of listings data
available at present.
More information about the mythtv-users