Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix(api): remove deacklock on database #5945

Merged
merged 1 commit into from
Sep 20, 2021
Merged

Conversation

fsamin
Copy link
Member

@fsamin fsamin commented Sep 20, 2021

Process 29654 waits for ShareLock on transaction 317362823; blocked by process 41641.
Process 41641 waits for ShareLock on transaction 317362703; blocked by process 29654.
Process 29654: UPDATE workflow_node_run SET commits = $1 where id = $2
Process 41641: update "workflow_run" set "num"=$1, "version"=$2, "project_id"=$3, "workflow_id"=$4, "status"=$5, "workflow"=$6, "start"=$7, "last_modified"=$8, "infos"=$9, "last_sub_num"=$10, "last_execution"=$11, "to_delete"=$12, "join_triggers_run"=$13, "header"=$14, "read_only"=$15, "to_craft"=$16, "to_craft_opts"=$17 where "id"=$18;

Signed-off-by: francois samin [email protected]

@ovh ovh deleted a comment from ovh-cds Sep 20, 2021
@sonarqubecloud
Copy link

Kudos, SonarCloud Quality Gate passed!    Quality Gate passed

Bug A 0 Bugs
Vulnerability A 0 Vulnerabilities
Security Hotspot A 0 Security Hotspots
Code Smell A 0 Code Smells

No Coverage information No Coverage information
No Duplication information No Duplication information

@yesnault yesnault merged commit ef9d729 into master Sep 20, 2021
@fsamin fsamin deleted the fix/api/pg_deadlock branch September 24, 2021 08:16
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants