[Jenkins-infra] JIRA upgrade to 6.4.2

[Kohsuke Kawaguchi]

Arnaud, I filed https://issues.jenkins-ci.org/browse/INFRA-292 for that.

We can sync up on how to get you going for trying this out locally with
containers.

The upgrade to 6.4.2 has completed. It took a while to sort out the puppet
problem on edamame, but once that's over the JIRA upgrade itself was fairly
smooth and uneventful. Yay to the local testing!

One flow that can be improved is how we put up the maintenance screen. I
was doing it outside Puppet, which means every time I run puppet to bring
in new change, puppet clobbers the maintenance screen.

The other problem is how we test after upgrade. Ideally, I want to continue
to put up the maintenance screen for users while I set magic cookie or some
such to be able to use JIRA with its production URL. I can't think of an
easy way to do this, so lifting the maintenance page currently requires a
bit of faith.


2015-04-30 9:49 GMT-07:00 Arnaud Héritier <aheritier at gmail.com>:

> ok thus +1 to schedule the mass migration to InnoDB in the future.
> Yes it might be interesting to see how they configure MariaDB
>
> On Thu, Apr 30, 2015 at 5:42 PM, Kohsuke Kawaguchi <kk at kohsuke.org> wrote:
>
>> Yes, you are right that that is what they recommend, and at once point I
>> believe I tried to convert tables en-mass to InnoDB and hit some issues.
>>
>> But if you are willing, we can take that on as a separate task. I can
>> arrange you to have the copy of the production database, and with the JIRA
>> container we can do a dry-run (to some extent, as we don't know exactly how
>> OSUOSL configures&runs MariaDB) of what happens.
>>
>> 2015-04-30 2:12 GMT-07:00 Arnaud Héritier <aheritier at gmail.com>:
>>
>> Hi,
>>>
>>>   I think that all tables should be converted to InnoDB if possible.
>>> This recommended by Atlassian to use InnoDB and if we need to do some MySQL
>>> tuning it will be easier to not have to make a different running for innodb
>>> and for myisam
>>>
>>> Arnaud
>>>
>>> On Sun, Apr 26, 2015 at 7:42 PM, Kohsuke Kawaguchi <kk at kohsuke.org>
>>> wrote:
>>>
>>>> The migration of JIRA from eggplant to a container in edamame went
>>>> smoothly yesterday.
>>>>
>>>> As a next step, I worked on the preparation of upgrading JIRA from the
>>>> current 5.0.6 to the latest 6.4.2.
>>>>
>>>> Thanks to the containerization, I was able to test this locally with a
>>>> clone of production data. I've captured obstacles and remedies that I came
>>>> across in this note
>>>> <https://github.com/jenkins-infra/jira/blob/master/UPGRADE.md>. Your
>>>> sanity check would be appreciated.
>>>>
>>>> I've requested OSUOSL to give us more disk space. edamame doesn't have
>>>> enough disk space to pull the new JIRA container, so my current plan is to
>>>> wait for the disk space to be expanded, which hopefully happen this week,
>>>> then perform this upgrade in the next Saturday.
>>>>
>>>> --
>>>> Kohsuke Kawaguchi
>>>>
>>>> _______________________________________________
>>>> Jenkins-infra mailing list
>>>> Jenkins-infra at lists.jenkins-ci.org
>>>> http://lists.jenkins-ci.org/mailman/listinfo/jenkins-infra
>>>>
>>>>
>>>
>>>
>>> --
>>> -----
>>> Arnaud Héritier
>>> http://aheritier.net
>>> Mail/GTalk: aheritier AT gmail DOT com
>>> Twitter/Skype : aheritier
>>>
>>
>>
>>
>> --
>> Kohsuke Kawaguchi
>>
>
>
>
> --
> -----
> Arnaud Héritier
> http://aheritier.net
> Mail/GTalk: aheritier AT gmail DOT com
> Twitter/Skype : aheritier
>



-- 
Kohsuke Kawaguchi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jenkins-ci.org/pipermail/jenkins-infra/attachments/20150503/f21599c7/attachment.html>