You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airflow.apache.org by Ali Naqvi <al...@conornash.com> on 2017/01/28 19:34:28 UTC
Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Hi folks,
We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
We are seeing issues when running the webserver using our database we have
been using for Airflow 1.7.1.3. Here are two examples:
a) when trying to create a manual dag run
https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%202017-01-28%2014.09.27.png?dl=0
b) when trying to open a dag by clicking on it in the ui
https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%202017-01-28%2014.11.03.png?dl=0
Since the Updating.md file in the git repo doesn't outline any issues with
DB migration, where can we find all of the changes to DB and what are the
steps for database migration?
Am I over-thinking it? is it as simple as:
airflow upgradedb
Cheers,
Ali
Re: Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Posted by Bolke de Bruin <bd...@gmail.com>.
There is a pr out for updating.md that has some more details (but isn't done yet). Gives a bit more perspective on what has changed and what you need to think off.
Bolke
Sent from my iPhone
> On 28 Jan 2017, at 23:52, Ali Naqvi <al...@conornash.com> wrote:
>
> It's a production database, which is why I wanted to get an understanding
> of the changes first.
>
> Cheers,
> Ali
>
>> On 28 Jan 2017 5:50 pm, "Ali Naqvi" <al...@conornash.com> wrote:
>>
>> Ok good to know :D
>>
>>> On 28 Jan 2017 5:50 pm, "Bolke de Bruin" <bd...@gmail.com> wrote:
>>>
>>> So yes it is as simple as that :-)
>>>
>>> Sent from my iPhone
>>>
>>>> On 28 Jan 2017, at 23:49, Bolke de Bruin <bd...@gmail.com> wrote:
>>>>
>>>> Did you issue an "airflow upgradedb" ?
>>>>
>>>> Sent from my iPhone
>>>>
>>>>> On 28 Jan 2017, at 20:34, Ali Naqvi <al...@conornash.com> wrote:
>>>>>
>>>>> Hi folks,
>>>>> We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
>>>>>
>>>>> We are seeing issues when running the webserver using our database we
>>> have
>>>>> been using for Airflow 1.7.1.3. Here are two examples:
>>>>>
>>>>> a) when trying to create a manual dag run
>>>>> https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%202017-
>>> 01-28%2014.09.27.png?dl=0
>>>>>
>>>>> b) when trying to open a dag by clicking on it in the ui
>>>>> https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%202017-
>>> 01-28%2014.11.03.png?dl=0
>>>>>
>>>>> Since the Updating.md file in the git repo doesn't outline any issues
>>> with
>>>>> DB migration, where can we find all of the changes to DB and what are
>>> the
>>>>> steps for database migration?
>>>>>
>>>>> Am I over-thinking it? is it as simple as:
>>>>>
>>>>> airflow upgradedb
>>>>>
>>>>> Cheers,
>>>>> Ali
>>>
>>
Re: Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Posted by Ali Naqvi <al...@conornash.com>.
It's a production database, which is why I wanted to get an understanding
of the changes first.
Cheers,
Ali
On 28 Jan 2017 5:50 pm, "Ali Naqvi" <al...@conornash.com> wrote:
> Ok good to know :D
>
> On 28 Jan 2017 5:50 pm, "Bolke de Bruin" <bd...@gmail.com> wrote:
>
>> So yes it is as simple as that :-)
>>
>> Sent from my iPhone
>>
>> > On 28 Jan 2017, at 23:49, Bolke de Bruin <bd...@gmail.com> wrote:
>> >
>> > Did you issue an "airflow upgradedb" ?
>> >
>> > Sent from my iPhone
>> >
>> >> On 28 Jan 2017, at 20:34, Ali Naqvi <al...@conornash.com> wrote:
>> >>
>> >> Hi folks,
>> >> We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
>> >>
>> >> We are seeing issues when running the webserver using our database we
>> have
>> >> been using for Airflow 1.7.1.3. Here are two examples:
>> >>
>> >> a) when trying to create a manual dag run
>> >> https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%202017-
>> 01-28%2014.09.27.png?dl=0
>> >>
>> >> b) when trying to open a dag by clicking on it in the ui
>> >> https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%202017-
>> 01-28%2014.11.03.png?dl=0
>> >>
>> >> Since the Updating.md file in the git repo doesn't outline any issues
>> with
>> >> DB migration, where can we find all of the changes to DB and what are
>> the
>> >> steps for database migration?
>> >>
>> >> Am I over-thinking it? is it as simple as:
>> >>
>> >> airflow upgradedb
>> >>
>> >> Cheers,
>> >> Ali
>>
>
Re: Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Posted by Ali Naqvi <al...@conornash.com>.
Ok good to know :D
On 28 Jan 2017 5:50 pm, "Bolke de Bruin" <bd...@gmail.com> wrote:
> So yes it is as simple as that :-)
>
> Sent from my iPhone
>
> > On 28 Jan 2017, at 23:49, Bolke de Bruin <bd...@gmail.com> wrote:
> >
> > Did you issue an "airflow upgradedb" ?
> >
> > Sent from my iPhone
> >
> >> On 28 Jan 2017, at 20:34, Ali Naqvi <al...@conornash.com> wrote:
> >>
> >> Hi folks,
> >> We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
> >>
> >> We are seeing issues when running the webserver using our database we
> have
> >> been using for Airflow 1.7.1.3. Here are two examples:
> >>
> >> a) when trying to create a manual dag run
> >> https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%
> 202017-01-28%2014.09.27.png?dl=0
> >>
> >> b) when trying to open a dag by clicking on it in the ui
> >> https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%
> 202017-01-28%2014.11.03.png?dl=0
> >>
> >> Since the Updating.md file in the git repo doesn't outline any issues
> with
> >> DB migration, where can we find all of the changes to DB and what are
> the
> >> steps for database migration?
> >>
> >> Am I over-thinking it? is it as simple as:
> >>
> >> airflow upgradedb
> >>
> >> Cheers,
> >> Ali
>
Re: Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Posted by Bolke de Bruin <bd...@gmail.com>.
So yes it is as simple as that :-)
Sent from my iPhone
> On 28 Jan 2017, at 23:49, Bolke de Bruin <bd...@gmail.com> wrote:
>
> Did you issue an "airflow upgradedb" ?
>
> Sent from my iPhone
>
>> On 28 Jan 2017, at 20:34, Ali Naqvi <al...@conornash.com> wrote:
>>
>> Hi folks,
>> We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
>>
>> We are seeing issues when running the webserver using our database we have
>> been using for Airflow 1.7.1.3. Here are two examples:
>>
>> a) when trying to create a manual dag run
>> https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%202017-01-28%2014.09.27.png?dl=0
>>
>> b) when trying to open a dag by clicking on it in the ui
>> https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%202017-01-28%2014.11.03.png?dl=0
>>
>> Since the Updating.md file in the git repo doesn't outline any issues with
>> DB migration, where can we find all of the changes to DB and what are the
>> steps for database migration?
>>
>> Am I over-thinking it? is it as simple as:
>>
>> airflow upgradedb
>>
>> Cheers,
>> Ali
Re: Migrating database from Airflow 1.7.1.3 to Airflow 1.8.0
Posted by Bolke de Bruin <bd...@gmail.com>.
Did you issue an "airflow upgradedb" ?
Sent from my iPhone
> On 28 Jan 2017, at 20:34, Ali Naqvi <al...@conornash.com> wrote:
>
> Hi folks,
> We are working on upgrading Airflow 1.7.1.3 to Airflow 1.8.0 b5.
>
> We are seeing issues when running the webserver using our database we have
> been using for Airflow 1.7.1.3. Here are two examples:
>
> a) when trying to create a manual dag run
> https://www.dropbox.com/s/e2zoaqamg29h8sk/Screenshot%202017-01-28%2014.09.27.png?dl=0
>
> b) when trying to open a dag by clicking on it in the ui
> https://www.dropbox.com/s/7bm64xto0vrt1f8/Screenshot%202017-01-28%2014.11.03.png?dl=0
>
> Since the Updating.md file in the git repo doesn't outline any issues with
> DB migration, where can we find all of the changes to DB and what are the
> steps for database migration?
>
> Am I over-thinking it? is it as simple as:
>
> airflow upgradedb
>
> Cheers,
> Ali