zachliu commented on issue #23512:
URL: https://github.com/apache/airflow/issues/23512#issuecomment-1156682542
@jhtimmins thank you for looking into this :pray: to make sure we are on
the same page:
* i don't have 4 webservers, i have 1 webserver with 4 gunicorn workers. the
# of workers is controlled by
```
# Number of workers to run the Gunicorn web server
workers = 4
```
in my `airflow.cfg`
* the `ERROR: duplicate key value violates unique constraint` message showed
up `24` times when I first ran it
* there are no errors after the initial run but these logs keep showing up
every time
```
webserver_1 | [2022-06-15 16:02:47,740] {{manager.py:585}} INFO -
Removed Permission can create on Users to role Admin
webserver_1 | [2022-06-15 16:02:47,763] {{manager.py:543}} INFO -
Removed Permission View: can_create on Users
webserver_1 | [2022-06-15 16:02:50,223] {{manager.py:508}} INFO -
Created Permission View: can create on Users
```
the last entry of the `ab_permission_view` table and the
`ab_permission_view_role` table are being removed and added back every time. so
their IDs keep increasing (before the fix it was the last 2 entries, now it's
just the last 1 entry)
* when i set `workers = 1` in my `airflow.cfg`, i got no errors in the first
run but of course i still get these three log messages every time
so i guess if we could fix the mechanism that generates the above log
messages, this matter will be solved 100%
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
