You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/01/28 14:58:29 UTC

[GitHub] [airflow] tfayyaz opened a new issue #21187: Breeze failing due to mysql error - public key is not available

tfayyaz opened a new issue #21187:
URL: https://github.com/apache/airflow/issues/21187


   ### Apache Airflow version
   
   2.2.3 (latest released)
   
   ### What happened
   
   I followed all the instructions to set up Breeze for the first time but when I run `./breeze` I get the following error:
   
   ```
   #10 9.605 
   #10 9.605 Installing mysql client version 8.0
   #10 9.605 
   #10 9.613 gpg: keybox '/tmp/tmp.u3jwOIxYZN/pubring.kbx' created
   #10 12.79 gpg: keyserver receive failed: No keyserver available
   #10 22.83 gpg: keyserver receive failed: Server indicated a failure
   #10 58.88 gpg: keyserver receive failed: No name
   #10 58.88 gpg: keyserver receive failed: No keyserver available
   #10 58.89 gpg: WARNING: nothing exported
   #10 58.90 deb http://repo.mysql.com/apt/debian/ buster mysql-8.0
   #10 59.04 Get:1 http://security.debian.org/debian-security buster/updates InRelease [65.4 kB]
   #10 59.04 Get:2 http://deb.debian.org/debian buster InRelease [122 kB]
   #10 59.06 Get:3 http://repo.mysql.com/apt/debian buster InRelease [22.1 kB]
   #10 59.15 Get:4 https://dl.yarnpkg.com/debian stable InRelease [17.1 kB]
   #10 59.15 Get:5 https://deb.nodesource.com/node_14.x buster InRelease [4584 B]
   #10 59.18 Get:6 http://deb.debian.org/debian buster-updates InRelease [51.9 kB]
   #10 59.29 Err:3 http://repo.mysql.com/apt/debian buster InRelease
   #10 59.29   The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
   #10 59.47 Get:7 http://security.debian.org/debian-security buster/updates/main amd64 Packages [313 kB]
   #10 59.56 Get:8 https://deb.nodesource.com/node_14.x buster/main amd64 Packages [770 B]
   #10 59.71 Get:9 http://deb.debian.org/debian buster/main amd64 Packages [7906 kB]
   #10 59.95 Get:10 https://dl.yarnpkg.com/debian stable/main amd64 Packages [10.5 kB]
   #10 60.00 Get:11 https://dl.yarnpkg.com/debian stable/main all Packages [10.5 kB]
   #10 60.20 Get:12 http://deb.debian.org/debian buster-updates/main amd64 Packages [8792 B]
   #10 61.30 Reading package lists...
   #10 62.13 W: GPG error: http://repo.mysql.com/apt/debian buster InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
   #10 62.13 E: The repository 'http://repo.mysql.com/apt/debian buster InRelease' is not signed.
   #10 62.13 W: Target Packages (mysql-8.0/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list.d/mysql.list:1 and /etc/apt/sources.list.d/mysql.list:2
   #10 62.13 W: Target Packages (mysql-8.0/binary-all/Packages) is configured multiple times in /etc/apt/sources.list.d/mysql.list:1 and /etc/apt/sources.list.d/mysql.list:2
   ------
   error: failed to solve: executor failed running [/bin/bash -o pipefail -o errexit -o nounset -o nolog -c chmod a+x /scripts/docker/install_mysql.sh /scripts/docker/install_mssql.sh     && sync      && /scripts/docker/install_mysql.sh prod      && /scripts/docker/install_mysql.sh dev      && /scripts/docker/install_mssql.sh     && adduser --gecos "First Last,RoomNumber,WorkPhone,HomePhone" --disabled-password               --quiet "airflow" --home "/home/airflow"     && echo -e "airflow\nairflow" | passwd airflow 2>&1     && echo "airflow ALL=(ALL) NOPASSWD: ALL" > /etc/sudoers.d/airflow     && chmod 0440 /etc/sudoers.d/airflow]: exit code: 100
   ```
   
   I am not sure what steps to take to resolve this.
   
   ### What you expected to happen
   
   _No response_
   
   ### How to reproduce
   
   _No response_
   
   ### Operating System
   
   MacOS version 10.15.7
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Deployment
   
   Docker-Compose
   
   ### Deployment details
   
   _No response_
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] boring-cyborg[bot] commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1024302045


   Thanks for opening your first issue here! Be sure to follow the issue template!
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] potiuk commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1057423197


   > yeah, in the host otherwise i got exactly the same error message as shown above very strange indeed
   
   Do you happen to have a log :P ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] zachliu commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
zachliu commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1057337103


   yeah, in the host
   otherwise i got exactly the same error message as shown above
   very strange indeed


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] potiuk commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1058255266


   🤷  > too bad .  Cosmic rays most likely ;) 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] potiuk commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1024697532


   Rebase ot latest `./main`. It is already fixed there via #20912. You can apply it to your own copy/branch if you want by cherry-picking  and resolving conflicts.
   
   Duplicate of #20912 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] zachliu commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
zachliu commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1058158824


   > > yeah, in the host otherwise i got exactly the same error message as shown above very strange indeed
   > 
   > Do you happen to have a log :P ?
   
   unfortunately no, i had all sorts of weird issues when i tried to `./breeze` under the `providers-amazon/3.0.0` tag
   now i can't reproduce this error even after i removed `467B942D3A79BD29` from my key ring :joy: 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] potiuk closed issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
potiuk closed issue #21187:
URL: https://github.com/apache/airflow/issues/21187


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] potiuk commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1057291550


   @zachliu  - did you have to do it in the host? What was failing with breeze before you did it (I think it should not be needed).


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] zachliu commented on issue #21187: Breeze failing due to mysql error - public key is not available

Posted by GitBox <gi...@apache.org>.
zachliu commented on issue #21187:
URL: https://github.com/apache/airflow/issues/21187#issuecomment-1057071367


   same issue on `2.2.4`, i had to do
   ```
   sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
   ```
   before `./breeze`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org