apiVersion: jenkins.io/v1 kind: PipelineActivity metadata: annotations: lighthouse.jenkins-x.io/cloneURI: https://github.com/greencapitaltrade/bifrost.git lighthouse.jenkins-x.io/job: release pipeline.jenkins-x.io/traceID: 7e805bc32d19f832209153fe0b39f85b creationTimestamp: "2026-06-01T19:49:25Z" generation: 7 labels: branch: main build: "116" context: release created-by-lighthouse: "true" event-GUID: f94b45fa-5df2-11f1-977e-d9024e1610fd lighthouse.jenkins-x.io/baseSHA: 91427bea0a7b7ff35faf1ad6dd8dacc02315346b lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1780343365109" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-bifrost-main-release-2wmnb lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 91427bea0a7b7ff35faf1ad6dd8dacc02315346b lighthouse.jenkins-x.io/refs.org: greencapitaltrade lighthouse.jenkins-x.io/refs.repo: bifrost lighthouse.jenkins-x.io/type: postsubmit owner: greencapitaltrade podName: apitaltrade-bifrost-main-release-bqwp5-from-build-pack-pod provider: github repository: bifrost tekton.dev/pipeline: apitaltrade-bifrost-main-release-bqwp5 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.18 operation: Update time: "2026-06-01T19:53:03Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:spec: f:completedTimestamp: {} f:status: {} manager: jx-promote-0.6.31 operation: Update time: "2026-06-01T19:53:57Z" - 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:context: {} f:gitBranch: {} f:gitOwner: {} f:gitRepository: {} f:gitUrl: {} f:message: {} f:pipeline: {} f:startedTimestamp: {} f:steps: {} manager: jx-build-controller operation: Update time: "2026-06-01T19:54:10Z" name: greencapitaltrade-bifrost-main-116 namespace: jx resourceVersion: "69447887" uid: 88161a74-0b86-4d47-ada4-af6743ff70fc spec: baseSHA: 91427bea0a7b7ff35faf1ad6dd8dacc02315346b batchPipelineActivity: {} build: "116" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/bifrost/main/116.log completedTimestamp: "2026-06-01T19:53:38Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: bifrost gitUrl: https://github.com/greencapitaltrade/bifrost.git lastCommitMessage: | fix(entrypoint): detect fresh DB via Postgres, not local filestore This is the second half of bifrost#182. That PR fixed the addons-path glob in check_addon_versions; this fixes the OTHER reason migrations never ran on prod — the 'fresh database detected' branch was keying off the local filestore being absent. Our deployment mounts `odoo-data` as an emptyDir volume. Every rolling -deploy pod sees an empty /var/lib/odoo on boot regardless of how populated the actual database is, so: if [ ! -e "/var/lib/odoo/filestore/bifrost" ]; then # → ALWAYS true on emptyDir log 'Fresh database detected' # → only installs ODOO_INIT_ADDONS=s3_storage_backend # → skips check_addon_versions + odoo --update entirely fi So new asset_management manifest versions shipped with their pre-init migrations sitting in the image, never invoked. The next request that touched a newly-declared column blew up with `psycopg2.errors.UndefinedColumn`. Three of these so far required manual ALTER TABLE on prod: - res_users.default_team_id (this morning) - asset_iot_device.stock_lot_id (this morning) - asset_asset.subscription_state, .active_subscription_end_date, .first_delivered_on (just now, surfaced by team-filter verification) Fix is to ask Postgres directly whether the database is fresh, using the presence of `ir_module_module` (the table Odoo creates on first init) as the marker. emptyDir filestores are now correctly classified as 'existing database, possibly needs upgrade' and check_addon_versions + odoo --update run as designed. Follow-up bifrost#177's missing pre-init for the three asset.asset subscription fields will land in a separate PR — that's a model-side fix; this is the deploy-pipeline side. lastCommitSHA: 1345011fd51a8fabe40f88e9002774492017fdb5 message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/bifrost/main releaseNotesURL: https://github.com/greencapitaltrade/bifrost/releases/tag/v6.74.5 startedTimestamp: "2026-06-01T19:49:25Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-06-01T19:53:38Z" name: Release startedTimestamp: "2026-06-01T19:52:38Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/4067 startedTimestamp: "2026-06-01T19:53:38Z" status: Succeeded startedTimestamp: "2026-06-01T19:53:38Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-06-01T19:54:00Z" name: from build pack startedTimestamp: "2026-06-01T19:49:39Z" status: Succeeded steps: - completedTimestamp: "2026-06-01T19:49:55Z" name: Git Clone startedTimestamp: "2026-06-01T19:49:39Z" status: Succeeded - completedTimestamp: "2026-06-01T19:49:58Z" name: Next Version startedTimestamp: "2026-06-01T19:49:55Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:01Z" name: Jx Variables startedTimestamp: "2026-06-01T19:49:58Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:01Z" name: Setup Npm Nexus startedTimestamp: "2026-06-01T19:50:01Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:04Z" name: Setup Pip Cache startedTimestamp: "2026-06-01T19:50:01Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:04Z" name: Process Config Templates startedTimestamp: "2026-06-01T19:50:04Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:05Z" name: Update Asset Management Version startedTimestamp: "2026-06-01T19:50:05Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:07Z" name: Check Registry startedTimestamp: "2026-06-01T19:50:05Z" status: Succeeded - completedTimestamp: "2026-06-01T19:52:46Z" name: Build Container Build startedTimestamp: "2026-06-01T19:50:07Z" status: Succeeded - completedTimestamp: "2026-06-01T19:53:03Z" name: Promote Changelog startedTimestamp: "2026-06-01T19:52:46Z" status: Succeeded - completedTimestamp: "2026-06-01T19:53:07Z" name: Promote Helm Release startedTimestamp: "2026-06-01T19:53:03Z" status: Succeeded - completedTimestamp: "2026-06-01T19:54:00Z" name: Promote Jx Promote startedTimestamp: "2026-06-01T19:53:07Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-06-01T19:54:00Z" name: from build pack startedTimestamp: "2026-06-01T19:49:39Z" status: Succeeded steps: - completedTimestamp: "2026-06-01T19:49:55Z" name: Git Clone startedTimestamp: "2026-06-01T19:49:39Z" status: Succeeded - completedTimestamp: "2026-06-01T19:49:58Z" name: Next Version startedTimestamp: "2026-06-01T19:49:55Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:01Z" name: Jx Variables startedTimestamp: "2026-06-01T19:49:58Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:01Z" name: Setup Npm Nexus startedTimestamp: "2026-06-01T19:50:01Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:04Z" name: Setup Pip Cache startedTimestamp: "2026-06-01T19:50:01Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:04Z" name: Process Config Templates startedTimestamp: "2026-06-01T19:50:04Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:05Z" name: Update Asset Management Version startedTimestamp: "2026-06-01T19:50:05Z" status: Succeeded - completedTimestamp: "2026-06-01T19:50:07Z" name: Check Registry startedTimestamp: "2026-06-01T19:50:05Z" status: Succeeded - completedTimestamp: "2026-06-01T19:52:46Z" name: Build Container Build startedTimestamp: "2026-06-01T19:50:07Z" status: Succeeded - completedTimestamp: "2026-06-01T19:53:03Z" name: Promote Changelog startedTimestamp: "2026-06-01T19:52:46Z" status: Succeeded - completedTimestamp: "2026-06-01T19:53:07Z" name: Promote Helm Release startedTimestamp: "2026-06-01T19:53:03Z" status: Succeeded - completedTimestamp: "2026-06-01T19:54:00Z" name: Promote Jx Promote startedTimestamp: "2026-06-01T19:53:07Z" status: Succeeded version: 6.74.5 status: {}