You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by "David (JIRA)" <ji...@apache.org> on 2019/05/17 13:30:00 UTC

[jira] [Created] (AIRFLOW-4530) Multiple web workers cause unique constraint violations inserting role/permissions

David created AIRFLOW-4530:
------------------------------

             Summary: Multiple web workers cause unique constraint violations inserting role/permissions
                 Key: AIRFLOW-4530
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-4530
             Project: Apache Airflow
          Issue Type: Bug
          Components: webserver
    Affects Versions: 1.10.3, 1.10.2
            Reporter: David
         Attachments: scratch_38.txt

While upgrading from 1.10.0 to 1.10.3 (also happens on 1.10.2) I discovered that having multiple webserver workers causes unique constraint errors on cluster startup. The causes my webserver to crash (due to a locking issue eventually, I think), and when it starts back up, the errors don't reappear and everything runs fine. I've attached logs from my docker-compose stdout, so postgres and webserver logs are intermingled here. If I reduce the worker count to 1 these errors go away. Happens with both sync and gevent workers. This also leaves the sequences and max values on the tables out of synchronization.

 

Here is my log output: [^scratch_38.txt]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)