<br><br>
<div><span class="gmail_quote">On 11/12/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On 11/12/2007 09:14 AM, R. G. Newbury wrote:<br>> William Munson wrote:<br>><br>>> R. G. Newbury wrote:
<br>>><br>>>> I think I have borked by mythconverg database and do not have an old<br>>>> enough backup to reconstruct the prior state.<br>>>><br>>>> SVN 14830 segfaulted at every attempt to play LiveTV or from the
<br>>>> library. I stepped back to 14794. But I think the error may have<br>>>> predated that as I have listings for only 8 days. This is most likely<br>>>> the result of a schema advance and revert...Operator error!
<br>>>><br>>>> DBSchemaVer is 1201. Mythfilldatabase reports that is cannot do inserts<br>>>> to various "dd_v_xxx" tables. Those tables do not exist.<br>>>><br>>>> So, how do I "re-update" and make it stick? As noted, 14830 segfaults badly.
<br>>> I have not tried this myself but you should be able to change<br>>> DBSchemaVer in the settings table to a lower number and rerun<br>>> mythtv-setup to re-upgrade your database. With a reasonably current SVN
<br>>> I have a version of 1201.<br>>><br>><br>> I tried something like this...I changed DBSchemaVer to 1200 in<br>> mysql...<br><br>Generally not a good idea to mess with DBSchemaVer... Always better to do
<br><br>> but I cannot now be sure that I didn't just restart mythbackend<br>> and frontend....I cannot remember.<br>> But whatever I did, changed DBSchemaVer to 1201 again, but DID NOT<br>> create the missing tables....
<br>><br>> I will try it again, running mythtv-setup first.<br>><br>> Anyone else have any good ideas? (I don't mind hearing *bad* ideas, but<br>> I make no promises about using them!)<br><br>the MythTV "Spring Cleaning" (TM):
<br><a href="http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7">http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7</a><br><br>Mike<br><br>___</blockquote>
<div> </div>
<div>Can't dispute that. Those tables aren't created via the db schema upgrade processes, but rather these are "temporary tables" created/used by the data direct class of processors (now schedules direct). As long as you are using a version of mysql
3.23 or later, it supports temporary tables correctly. Prior to 3.23 I think it ignored the "temporary" table construct, although the code is supposed to handle that situation as well, I think.</div>
<div> </div>
<div>I would shut down the mythbackend and any filldatabase processes, login to mysql and check to see if there are any dd_v* tables there. If they exist, you can delete them. This should only be the case, though, if you are using mysql prior to
3.23. If they exist and you are using later than that, something has gone terribly awry.</div>
<div> </div>
<div>It they don't exist, then there is some other error in the filldatabase process. What is the exact error message that mythfilldatabase is giving? Can you run it with more logging?</div>
<div> </div></div>