[mythtv-users] Possible bug in database schema upgrade (0.21 -> 0.22)
Michael T. Dean
mtdean at thirdcontact.com
Fri Nov 6 04:32:59 UTC 2009
On 11/05/2009 06:30 PM, Michael T. Dean wrote:
> On 11/05/2009 05:27 PM, Lars Michael Jogbäck wrote:
>> I've found problem when I was trying to upgrade my database
>> When I ran mythtv-setup, it spitted out the infamous "Database
>> corruption detected. Unable to proceed with database upgrade. (Table:
>> oldrecorded, Warnings: 157)"
>> After more carefully examining those it turns out, that when changing
>> the datatype of description from TEXT to VARBINARY(255) it got
>> truncated just between the two bytes in an existing utf8 character and
>> by that causing an false positive.
> Thanks. I'll get this fixed.
Lars, do you by any chance still have a copy of the pre-upgrade backup
that I could get for a test-run with the fix. We'd like to run a sanity
check on the fix with real data versus generated data. If you still
have it, I'd appreciate your posting a bzip2'ed or gzip'ed copy of the
backup file at http://filebin.ca/ (or anywhere else you'd like) and
sending me an e-mail (direct to my address and with the same subject, if
you don't want it on the list) with the link so I can download it and do
a test run.
More information about the mythtv-users