[Kea-users] Can't upgrade MySQL schema past v6.0
klausfiend at gmail.com
Tue Sep 1 05:44:48 UTC 2020
Responses inline below ...
On Mon, Aug 31, 2020 at 1:11 PM Tomek Mrugalski <tomek at isc.org> wrote:
> On 27/08/2020 03:58, Klaus Steden wrote:
> > I'm not sure what to do, but I'm stuck. I was trying to switch over
> > to the ISC's 1.6 packages of everything, so after installing, I ran
> > through the database upgrade procedure but it only got from 5.0 to
> > 6.0.
> > For some reason, the 6.0 to 7.0 upgrade keeps failing, so I can't
> > run the 1.6 software version.
> It would help if the "some reason" be a bit more specific. It looks like
> the first attempt to upgrade failed half-way with some parts of the
> schema being updated, but not all. The follow-up tries to run the update
> fails. I have no idea or suspicion why that would happen. The 7.0 schema
> was introduced long time ago and I don't remember specific complaints
> about it.
> > Anyone else run into this one? Any advice or things I can try to fix
> > this issue?
> You may try to run the schema update manually. Take a look at the 6.0 to
> 7.0 update script here:
> It should also be available in your system if you installed kea-admin:
Yup, I installed 1.6.3 from ISC's repo so the tools are there as expected
(I did experiment with different package versions -- 1.6.1, 1.6.2, 1.8.0,
etc. of the upgrade script to see if that made a difference, but it did
not; diffs indicate no changes between versions so I didn't expect anything
different, but I did still think it useful to rule that out as a
> Copy the actual schema update (everything between <<EOF in line
> 19 and EOF in line 647) to a file and run this as a script in mysql
> and see what happens.
I wrangled someone from our database team, I will take a look at this with
his help and see what happens when we try that.
> Oh, and you did backup your DB before upgrading, right?
Unfortunately not with this one but this is just sandbox so it's not
valuable data regardless. I will make sure to do so with our production DBs
if they're not already backed up (I believe they are, but as part of a
larger SQL cluster backup process).
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Kea-users