Mailing-List: contact dev-help@airflow.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@airflow.incubator.apache.org
From: Robin Bartholdson <robin.bartholdson@formulate.se>
Content-Type: multipart/signed; boundary="Apple-Mail=_825EECDE-D1ED-41BC-A8AC-C2DEA541F897"; protocol="application/pkcs7-signature"; micalg=sha1
Message-Id: <3707C25B-5DF0-42B7-9BA0-77DF0BFE5C61@formulate.se>
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\))
Subject: Re: alembic.util.exc.CommandError: Can't locate revision identified by '8504051e801b'
Date: Wed, 17 May 2017 23:27:16 +0200
References: <CADOayQ_B4rhRK-6sekJw=0SkV7D4zGvgoAG1MN64Sft4wu2RfA@mail.gmail.com>
To: dev@airflow.incubator.apache.org
In-Reply-To: <CADOayQ_B4rhRK-6sekJw=0SkV7D4zGvgoAG1MN64Sft4wu2RfA@mail.gmail.com>
archived-at: Wed, 17 May 2017 21:28:56 -0000

--Apple-Mail=_825EECDE-D1ED-41BC-A8AC-C2DEA541F897
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Sounds like you might have database migrations past the 1.7.1.3 release

What does your alembic_version table look like in your airflow db?=20

> select * from alembic_version

Does it say =E2=80=988504051e801b=E2=80=99? If so, I guess you could, =
among other things:

=E2=80=A2 upgrade everything to Airflow 1.8.1 :-)
=E2=80=A2 upgrade your py3.6 installation to the same (code) commit as =
your py2.7 installation
=E2=80=A2 create new clean db for your py3.6 install
=E2=80=A2 downgrade the db (e.g. to the 1.7.1.3 head 2e82aab8ef20, which =
will probably break your py2.7 installation instead=E2=80=A6)

Best,
-Robin

> On 17 May 2017, at 14:49, Rafael Barbosa <rrbarbosa@gmail.com> wrote:
>=20
> Hi,
>=20
> I attempted to move our airflow installation from python2.7 to =
python3.6.
> As far as I can tell, that is the only change in the airflow system. I =
am
> running version 1.7.1.3. When starting the new system, I the following
> error thrown a couple times:
>=20
> `alembic.util.exc.CommandError: Can't locate revision identified by
> '8504051e801b'`
>=20
> I am still able to run and test tasks manually, but the scheduler does =
not
> seem to work. When I start to the python2.7 installation, everything =
works
> as expected.
>=20
> I tried finding the source of the problem, but I am not familiar with
> alembic. Running `airflow initdb` or `upgradedb` give me the same =
error.
> This is what I get if I run `alembic history` from the airflow folder
>=20
> ```
> $> alembic history
> [2017-05-17 12:20:29,233] {__init__.py:36} INFO - Using executor
> LocalExecutor
> 1968acfc09e3 -> 2e82aab8ef20 (head), rename user table
> bba5a7cfc896 -> 1968acfc09e3, add is_encrypted column to variable =
table
> bbc73705a13e -> bba5a7cfc896, Add a column to track the encryption =
state of
> the 'Extra' field in connection
> 4446e08588 -> bbc73705a13e, Add notification_sent column to sla_miss
> 561833c1c74b -> 4446e08588, dagrun start end
> 40e67319e3a9 -> 561833c1c74b, add password column to user
> 2e541a1dcfed -> 40e67319e3a9, dagrun_config
> 1b38cef5b76e -> 2e541a1dcfed, task_duration
> 502898887f84 -> 1b38cef5b76e, add dagrun
> 52d714495f0 -> 502898887f84, Adding extra to Log
> 338e90f54d61 -> 52d714495f0, job_id indices
> 13eb55f81627 -> 338e90f54d61, More logging into task_isntance
> 1507a7289a2f -> 13eb55f81627, maintain history for compatibility with
> earlier migrations
> e3a246e0dc1 -> 1507a7289a2f, create is_encrypted
> <base> -> e3a246e0dc1, current schema
> ```
>=20
> What am I missing?
>=20
> Thanks,
> Rafael


--Apple-Mail=_825EECDE-D1ED-41BC-A8AC-C2DEA541F897
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIKCjCCBK8w
ggOXoAMCAQICEQDgI8sVEoNTia1hbnpUZ2shMA0GCSqGSIb3DQEBCwUAMG8xCzAJBgNVBAYTAlNF
MRQwEgYDVQQKEwtBZGRUcnVzdCBBQjEmMCQGA1UECxMdQWRkVHJ1c3QgRXh0ZXJuYWwgVFRQIE5l
dHdvcmsxIjAgBgNVBAMTGUFkZFRydXN0IEV4dGVybmFsIENBIFJvb3QwHhcNMTQxMjIyMDAwMDAw
WhcNMjAwNTMwMTA0ODM4WjCBmzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hl
c3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxQTA/BgNV
BAMTOENPTU9ETyBTSEEtMjU2IENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWls
IENBMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAibEN2npTGU5wUh28VqYGJre4SeCW
51Gr8fBaE0kVo7SMG2C8elFCp3mMpCLfF2FOkdV2IwoU00oCf7YdCYBupQQ92bq7Fv6hh6kuQ1JD
FnyvMlDIpk9a6QjYz5MlnHuI6DBk5qT4VoD9KiQUMxeZrETlaYujRgZLwjPU6UCfBrCxrJNAubUI
kzqcKlOjENs9IGE8VQOO2U52JQIhKfqjfHF2T+7hX4Hp+1SA28N7NVK3hN4iPSwwLTF/Wb1SN7Az
aS1D6/rWpfGXd2dRjNnuJ+u8pQc4doykqTj/34z1A6xJvsr3c5k6DzKrnJU6Ez0ORjpXdGFQvsZA
P8vk4p+iIQIDAQABo4IBFzCCARMwHwYDVR0jBBgwFoAUrb2YejS0Jvf6xCZU7wO94CTLVBowHQYD
VR0OBBYEFJJha4LhoqCqT+xn8cKj97SAAMHsMA4GA1UdDwEB/wQEAwIBhjASBgNVHRMBAf8ECDAG
AQH/AgEAMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDARBgNVHSAECjAIMAYGBFUdIAAw
RAYDVR0fBD0wOzA5oDegNYYzaHR0cDovL2NybC51c2VydHJ1c3QuY29tL0FkZFRydXN0RXh0ZXJu
YWxDQVJvb3QuY3JsMDUGCCsGAQUFBwEBBCkwJzAlBggrBgEFBQcwAYYZaHR0cDovL29jc3AudXNl
cnRydXN0LmNvbTANBgkqhkiG9w0BAQsFAAOCAQEAGypurFXBOquIxdjtzVXzqmthK8AJECOZD8Vm
am+x9bS1d14PAmEA330F/hKzpICAAPz7HVtqcgIKQbwFusFY1SbC6tVNhPv+gpjPWBvjImOcUvi7
BTarfVil3qs7Y+Xa1XPv7OD7e+Kj//BCI5zKto1NPuRLGAOyqC3U2LtCS5BphRDbpjc06HvgARCl
nMo6x59PiDRuimXQGoq7qdzKyjbR9PzCZCk1r9axp3ER0gNDsY8+muyeMlP0dpLKhjQHuSzK5hxK
2JkNwYbikJL7WkJqIyEQ6WXH9dW7fuqMhSACYurROgcsWcWZM/I4ieW26RZ6H3kU9koQGib6fIr7
mzCCBVMwggQ7oAMCAQICEG8d10XBG15h5Js926Esqs8wDQYJKoZIhvcNAQELBQAwgZsxCzAJBgNV
BAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcTB1NhbGZvcmQxGjAY
BgNVBAoTEUNPTU9ETyBDQSBMaW1pdGVkMUEwPwYDVQQDEzhDT01PRE8gU0hBLTI1NiBDbGllbnQg
QXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQTAeFw0xNjExMDMwMDAwMDBaFw0xNzEx
MDMyMzU5NTlaMC8xLTArBgkqhkiG9w0BCQEWHnJvYmluLmJhcnRob2xkc29uQGZvcm11bGF0ZS5z
ZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAOD3aw9uuBK0k8HOGjVo+9oH2Kb6QKDZ
mmy11agqxyz2r+WjlJVq0PxgOI0fA/arhSSlaiGw4QdzJfXUfre5nmkhD0OMADWMLKxBqH1Pld5V
326Uw0g3qaXHq87adYN83FLD9jd2zPl81o9pjDSuTkTNlClo88thponylQ8tAKfEl5hK7pDbDaDp
5lsH/JPmjYXUxEXxInf/YdS6IwMvGPr6gXwVm8QnKuGnxbUIEkONrXa0L6WAjI2ZwqM5iCbol2Nt
50XyXwKvbL2RB5zIQRQKATbu2Jq7v+7iuSd7VibLgRkuKNesdjBGtu4xvFrodOFv7II3w5Mm6iws
RGa/qp8CAwEAAaOCAfwwggH4MB8GA1UdIwQYMBaAFJJha4LhoqCqT+xn8cKj97SAAMHsMB0GA1Ud
DgQWBBQZ2IAYqTxxB1lOoi8RUX02uDWAZjAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAg
BgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1Ud
IAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9k
by5uZXQvQ1BTMF0GA1UdHwRWMFQwUqBQoE6GTGh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9E
T1NIQTI1NkNsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgZAGCCsGAQUF
BwEBBIGDMIGAMFgGCCsGAQUFBzAChkxodHRwOi8vY3J0LmNvbW9kb2NhLmNvbS9DT01PRE9TSEEy
NTZDbGllbnRBdXRoZW50aWNhdGlvbmFuZFNlY3VyZUVtYWlsQ0EuY3J0MCQGCCsGAQUFBzABhhho
dHRwOi8vb2NzcC5jb21vZG9jYS5jb20wKQYDVR0RBCIwIIEecm9iaW4uYmFydGhvbGRzb25AZm9y
bXVsYXRlLnNlMA0GCSqGSIb3DQEBCwUAA4IBAQB8OH2N4/vMZmnJPKAmO0+1Lot5L0+XXvVgdWbl
PpyLerWgTTY7hEVpWw8NemWSGPSLr9vpQIc2xjiwGTA3jKtvEmKwRfuB1lEY3OFgIhMcQQa+aAu5
IdrIImcQrLv3QOtGmNrMmRSVp/b6/DWRaPIDqqiAsXQzokTAJp4h15Yn5dEKSgTLWw2lexcVerFq
jXPMAun8R58qQ3dzyRY4u2Rn5g5GZi76qSkk9YhMWEceR2YmFkhhFmt4JcnOaGgH6kkCtyBM6ERk
+Gy8tRz4lqrfkzOG3SzerUITJdxLFEx9xz9S9g3pg4y8K+m8B7JZgoHPtGTY/vO+t7iEA0T2kp6W
MYIDwzCCA78CAQEwgbAwgZsxCzAJBgNVBAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0
ZXIxEDAOBgNVBAcTB1NhbGZvcmQxGjAYBgNVBAoTEUNPTU9ETyBDQSBMaW1pdGVkMUEwPwYDVQQD
EzhDT01PRE8gU0hBLTI1NiBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBD
QQIQbx3XRcEbXmHkmz3boSyqzzAJBgUrDgMCGgUAoIIB5zAYBgkqhkiG9w0BCQMxCwYJKoZIhvcN
AQcBMBwGCSqGSIb3DQEJBTEPFw0xNzA1MTcyMTI3MTdaMCMGCSqGSIb3DQEJBDEWBBRk9/TCrl8J
KrwXXKyxaKhZiImn+zCBwQYJKwYBBAGCNxAEMYGzMIGwMIGbMQswCQYDVQQGEwJHQjEbMBkGA1UE
CBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8g
Q0EgTGltaXRlZDFBMD8GA1UEAxM4Q09NT0RPIFNIQS0yNTYgQ2xpZW50IEF1dGhlbnRpY2F0aW9u
IGFuZCBTZWN1cmUgRW1haWwgQ0ECEG8d10XBG15h5Js926Esqs8wgcMGCyqGSIb3DQEJEAILMYGz
oIGwMIGbMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQH
EwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDFBMD8GA1UEAxM4Q09NT0RPIFNI
QS0yNTYgQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBTZWN1cmUgRW1haWwgQ0ECEG8d10XBG15h
5Js926Esqs8wDQYJKoZIhvcNAQEBBQAEggEAMbffJg0DD8523pBeJMYxR9PJbXA88B4Qc0Ylyl60
iPAko8K5OExxjIV4ZuSgTdTyljEdwy3aEeSakJk4E0mrpkxAvhKyyf9dWgQThxY8ZnhO986LiDhX
KSMcBlm4WAdtfGUkQr8eXZhMtbObvc5NWlOAlFJHZH3HJc3G1iXIvYDOBEPwUV0Mwxob2+j0Aa9t
aZihfQA8dPQh5HvdiTitMDlnTVVWF4zl+JgTtE3pJPHYOBi3Gdbd4vNeDdPeLkcsrnzLltO7+5/w
cC6lB4N88HaNbJjUsD0GR21H1rDxlCwigr6kWYGaSRoC6ABkGwqhdZDSYc/8fuWaXNEnoOzXZAAA
AAAAAA==
--Apple-Mail=_825EECDE-D1ED-41BC-A8AC-C2DEA541F897--