ephraimbuddy commented on pull request #21517:
URL: https://github.com/apache/airflow/pull/21517#issuecomment-1036232853


   I got the error again:
   ```
   [2022-02-10 21:45:58,686] {manager.py:570} ERROR - Add Permission to Role 
Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique 
constraint "ab_permission_view_role_permission_view_id_role_id_key"
   DETAIL:  Key (permission_view_id, role_id)=(109, 1) already exists.
   
   [SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) 
VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, 
%(role_id)s) RETURNING ab_permission_view_role.id]
   [parameters: {'permission_view_id': 109, 'role_id': 1}]
   (Background on this error at: http://sqlalche.me/e/14/gkpj)
   [2022-02-10 21:45:58,689] {manager.py:570} ERROR - Add Permission to Role 
Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique 
constraint "ab_permission_view_role_permission_view_id_role_id_key"
   DETAIL:  Key (permission_view_id, role_id)=(109, 1) already exists.
   
   [SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) 
VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, 
%(role_id)s) RETURNING ab_permission_view_role.id]
   [parameters: {'permission_view_id': 109, 'role_id': 1}]
   (Background on this error at: http://sqlalche.me/e/14/gkpj)
   [2022-02-10 21:46:00,497] {security.py:408} INFO - Deleted 1 faulty 
permissions
   /usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py:1461 
SAWarning: DELETE statement on table 'ab_permission_view' expected to delete 1 
row(s); 0 were matched.  Please set confirm_deleted_rows=False within the 
mapper configuration to prevent this warning.
   [2022-02-10 21:46:00,512] {security.py:408} INFO - Deleted 1 faulty 
permissions
   ```


-- 
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]


Reply via email to