Skip to content

[Maintenance]: Investigate DB locking #8469

@matusdrobuliak66

Description

@matusdrobuliak66

where? sim4life.io

Image Image Image
UPDATE projects SET ui=$1::jsonb, last_change_date=now() WHERE projects.uuid = $2::varchar RETURNING projects.id, projects.type, projects.template_type, projects.uuid, projects.name, projects.description, projects.thumbnail, projects.prj_owner, projects.creation_date, projects.last_change_date, projects.ui, projects.classifiers, projects.dev, projects.quality, projects.published, projects.hidden, projects.workspace_id, projects.trashed, projects.trashed_by, projects.trashed_explicitly
UPDATE projects SET last_change_date=now(), quality=$1::jsonb WHERE projects.uuid = $2::varchar RETURNING projects.id, projects.type, projects.template_type, projects.uuid, projects.name, projects.description, projects.thumbnail, projects.prj_owner, projects.creation_date, projects.last_change_date, projects.ui, projects.classifiers, projects.dev, projects.quality, projects.published, projects.hidden, projects.workspace_id, projects.trashed, projects.trashed_by, projects.trashed_explicitly
SELECT projects.id, projects.type, projects.template_type, projects.uuid, projects.name, projects.description, projects.thumbnail, projects.prj_owner, projects.workspace_id, projects.workbench, projects.ui, projects.dev, projects.published, projects.hidden, projects.creation_date, projects.last_change_date, projects.trashed, projects.trashed_by, projects.trashed_explicitly, projects.classifiers, projects.quality, projects.access_rights 
FROM projects 
WHERE projects.uuid = '1cbd3628-a28d-11f0-a9

Metadata

Metadata

Labels

t:maintenanceSome planned maintenance work

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions