apiVersion: jenkins.io/v1 kind: PipelineActivity metadata: annotations: lighthouse.jenkins-x.io/cloneURI: https://github.com/greencapitaltrade/destiny.git lighthouse.jenkins-x.io/job: release pipeline.jenkins-x.io/traceID: c127bdb5d2ef7b2f8294f1f1c125e4ab creationTimestamp: "2026-08-13T10:30:43Z" generation: 7 labels: branch: main build: "177" context: release created-by-lighthouse: "true" event-GUID: 056b7a10-9702-11f1-87b5-c7338d0a855c lighthouse.jenkins-x.io/baseSHA: 2fb8844bf7ccba0e30920f0c1b231febd6d31e5e lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1786617043779" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-destiny-main-release-2262k lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 2fb8844bf7ccba0e30920f0c1b231febd6d31e5e lighthouse.jenkins-x.io/refs.org: greencapitaltrade lighthouse.jenkins-x.io/refs.repo: destiny lighthouse.jenkins-x.io/type: postsubmit owner: greencapitaltrade podName: apitaltrade-destiny-main-release-lckcc-from-build-pack-pod provider: github repository: destiny tekton.dev/pipeline: apitaltrade-destiny-main-release managedFields: - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:labels: f:branch: {} f:context: {} f:owner: {} f:provider: {} f:repository: {} f:spec: f:lastCommitMessage: {} f:lastCommitSHA: {} f:releaseNotesURL: {} f:version: {} manager: jx-changelog-0.10.29 operation: Update time: "2026-08-13T10:35:21Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:annotations: .: {} f:lighthouse.jenkins-x.io/cloneURI: {} f:lighthouse.jenkins-x.io/job: {} f:pipeline.jenkins-x.io/traceID: {} f:labels: .: {} f:build: {} f:created-by-lighthouse: {} f:event-GUID: {} f:lighthouse.jenkins-x.io/baseSHA: {} f:lighthouse.jenkins-x.io/branch: {} f:lighthouse.jenkins-x.io/buildNum: {} f:lighthouse.jenkins-x.io/context: {} f:lighthouse.jenkins-x.io/id: {} f:lighthouse.jenkins-x.io/job: {} f:lighthouse.jenkins-x.io/lastCommitSHA: {} f:lighthouse.jenkins-x.io/refs.org: {} f:lighthouse.jenkins-x.io/refs.repo: {} f:lighthouse.jenkins-x.io/type: {} f:podName: {} f:tekton.dev/pipeline: {} f:spec: .: {} f:baseSHA: {} f:batchPipelineActivity: {} f:build: {} f:buildLogsUrl: {} f:completedTimestamp: {} f:context: {} f:gitBranch: {} f:gitOwner: {} f:gitRepository: {} f:gitUrl: {} f:message: {} f:pipeline: {} f:startedTimestamp: {} f:status: {} f:steps: {} manager: jx-build-controller operation: Update time: "2026-08-13T10:38:32Z" name: greencapitaltrade-destiny-main-177 namespace: jx resourceVersion: "266254805" uid: a695e16a-8b19-4d26-9b96-0caf4d6bce6d spec: baseSHA: 2fb8844bf7ccba0e30920f0c1b231febd6d31e5e batchPipelineActivity: {} build: "177" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/destiny/main/177.log completedTimestamp: "2026-08-13T10:38:27Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: destiny gitUrl: https://github.com/greencapitaltrade/destiny.git lastCommitMessage: | fix(engine): stop opening a nested transaction in completeStep/failStep/advanceFlow/executeStep GcKoaApp.initApp() (HTTP) and the shared kafka consumer both already wrap every call into these functions in one ambient CLS transaction, and Sequelize auto-attaches it to any query that doesn't pass its own transaction option. sequelize.transaction() does NOT check CLS for a parent before opening a new one -- it always starts a genuinely separate connection, not a savepoint -- so calling it here could self-deadlock: an implicit FK lock held by the ambient transaction's connection blocks this function's own locked read on the same row, and the ambient connection never releases it until this same call resolves. Reproduced live on staging via the real lsp-sanction webhook (had to pg_terminate_backend twice to unblock). completeStep, failStep, advanceFlow and executeStep now read the ambient transaction from CLS directly (needed only for lock:/afterCommit(); every other query auto-attaches on its own) instead of opening or threading one through as a parameter. engine/migrate.js's own top-level sequelize.transaction() call (a standalone migration script, not called from an HTTP/kafka context) is unaffected -- CLS makes that transaction visible to advanceFlow the same way. Co-Authored-By: Claude Sonnet 5 lastCommitSHA: 8224e936bdf315a9ccb8e47ccfdbee839477ae95 message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/destiny/main releaseNotesURL: https://github.com/greencapitaltrade/destiny/releases/tag/v1.78.6 startedTimestamp: "2026-08-13T10:30:43Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-08-13T10:38:27Z" name: from build pack startedTimestamp: "2026-08-13T10:31:11Z" status: Succeeded steps: - completedTimestamp: "2026-08-13T10:31:34Z" name: Git Clone startedTimestamp: "2026-08-13T10:31:11Z" status: Succeeded - completedTimestamp: "2026-08-13T10:31:43Z" name: Next Version startedTimestamp: "2026-08-13T10:31:34Z" status: Succeeded - completedTimestamp: "2026-08-13T10:31:47Z" name: Jx Variables startedTimestamp: "2026-08-13T10:31:43Z" status: Succeeded - completedTimestamp: "2026-08-13T10:33:21Z" name: Build Npm Install startedTimestamp: "2026-08-13T10:31:47Z" status: Succeeded - completedTimestamp: "2026-08-13T10:35:09Z" name: Build Container Build startedTimestamp: "2026-08-13T10:33:22Z" status: Succeeded - completedTimestamp: "2026-08-13T10:35:21Z" name: Promote Changelog startedTimestamp: "2026-08-13T10:35:10Z" status: Succeeded - completedTimestamp: "2026-08-13T10:35:27Z" name: Promote Helm Release startedTimestamp: "2026-08-13T10:35:22Z" status: Succeeded - completedTimestamp: "2026-08-13T10:37:28Z" name: Promote Jx Promote startedTimestamp: "2026-08-13T10:35:28Z" status: Succeeded - completedTimestamp: "2026-08-13T10:38:27Z" name: Publish Org Kb startedTimestamp: "2026-08-13T10:37:29Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5457 startedTimestamp: "2026-08-13T10:36:43Z" status: Succeeded startedTimestamp: "2026-08-13T10:36:43Z" status: Succeeded - kind: Promote promote: environment: production pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5458 startedTimestamp: "2026-08-13T10:37:25Z" status: Succeeded startedTimestamp: "2026-08-13T10:37:25Z" status: Succeeded version: 1.78.6 status: {}