Content
View differences
Updated by Evgeniy Belov almost 6 years ago
### **Environment**:
Your OpenProject Version: 10.6.3 to 10.6.1
Operating System / Browser / Language: Ubuntu 18.04.4 LTS
### **Logs**
Jun 30 15:38:43 aeop openproject-web-1.service\[5108\]: E, \[2020-06-30T15:38:43.170769 #26651\] ERROR -- : \[current\_user=**<scrubbed>**\] PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "member\_roles\_pkey"
Jun 30 15:38:43 aeop openproject-web-1.service\[5108\]: DETAIL: Key (id)=(773) already exists
### **Steps to reproduce:**
We hit the issue described here https://community.openproject.com/projects/openproject/work\_packages/33732/activity and our production system became inaccessible, so the only option was to revert the Openproject version to the last known working one 10.6.1
1. Stopped the openproject service
2. Reverted the package from openproject\_10.6.3-1593439203.f3992efa.bionic\_amd64.deb to openproject\_10.6.1-1591618676.9058b21b.bionic\_amd64.deb
3. Restored from a pre-upgrade backup as noted here https://docs.openproject.org/installation-and-operations/operation/restoring/
4. Ran openproject configure
5. Started back the service
### **Actual Behavior**
The Openproject instance started and users were able to login. Tracking works. However when an admin tries to modify the roles for some user a 500 error is thrown and the error above is observed in the application logs.
### **Expected Behavior**
The application should permit modifications of user access as usual.
Your OpenProject Version: 10.6.3 to 10.6.1
Operating System / Browser / Language: Ubuntu 18.04.4 LTS
### **Logs**
Jun 30 15:38:43 aeop openproject-web-1.service\[5108\]: E, \[2020-06-30T15:38:43.170769 #26651\] ERROR -- : \[current\_user=**<scrubbed>**\] PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "member\_roles\_pkey"
Jun 30 15:38:43 aeop openproject-web-1.service\[5108\]: DETAIL: Key (id)=(773) already exists
### **Steps to reproduce:**
We hit the issue described here https://community.openproject.com/projects/openproject/work\_packages/33732/activity and our production system became inaccessible, so the only option was to revert the Openproject version to the last known working one 10.6.1
1. Stopped the openproject service
2. Reverted the package from openproject\_10.6.3-1593439203.f3992efa.bionic\_amd64.deb to openproject\_10.6.1-1591618676.9058b21b.bionic\_amd64.deb
3. Restored from a pre-upgrade backup as noted here https://docs.openproject.org/installation-and-operations/operation/restoring/
4. Ran openproject configure
5. Started back the service
### **Actual Behavior**
The Openproject instance started and users were able to login. Tracking works. However when an admin tries to modify the roles for some user a 500 error is thrown and the error above is observed in the application logs.
### **Expected Behavior**
The application should permit modifications of user access as usual.