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: c690358bd1ce7bb7d5fdf9914d316f9c creationTimestamp: "2026-08-07T06:10:54Z" generation: 7 labels: branch: main build: "191" context: release created-by-lighthouse: "true" event-GUID: bb763ccc-9226-11f1-953e-6c756ddec863 lighthouse.jenkins-x.io/baseSHA: 1b63b33df5d9eab76a58a77d93c271e767c4030a lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1786083054755" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-bifrost-main-release-tjs54 lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 1b63b33df5d9eab76a58a77d93c271e767c4030a 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-fknbc-from-build-pack-pod provider: github repository: bifrost tekton.dev/pipeline: apitaltrade-bifrost-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-07T06:14:14Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:spec: f:completedTimestamp: {} f:status: {} manager: jx-promote-0.6.45 operation: Update time: "2026-08-07T06:15:18Z" - 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-08-07T06:16:09Z" name: greencapitaltrade-bifrost-main-191 namespace: jx resourceVersion: "249450641" uid: 215fb4fe-6067-4abf-887d-157982a559e2 spec: baseSHA: 1b63b33df5d9eab76a58a77d93c271e767c4030a batchPipelineActivity: {} build: "191" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/bifrost/main/191.log completedTimestamp: "2026-08-07T06:14:55Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: bifrost gitUrl: https://github.com/greencapitaltrade/bifrost.git lastCommitMessage: | fix(asset): detect trips when ignition is unknown Trips and Stops were empty in production even with GPS present. _fetch_gps_points selected COALESCE(en.ignition, false), so "no ignition row for this sample" became false. detect_trips_batch then read that as ACC-off, which blocks the stopped->moving transition that starts a trip and trips the immediate-trip-end branch on every point. The guard meant to prevent this, `if hasattr(point, 'engine_status') else True`, was dead code: _fetch_gps_points always sets the attribute. GT06 sends location and status in separate packets, landing on different asset.iot.data rows, so only 1.5% of GPS samples carry an ignition reading and 0.6% have it on. 98.5% of points could never start a trip. Keep the NULL and test `is not None`. The realtime path already did this (process_gps_data: `gps_data.get('engine_on', True)`), and it matches the settled rule that trip start is GPS-only. An explicit ignition=false still ends a trip; only unknown changes meaning. Also memoise _device_has_raw_accelerometer per device. It opens a connection to the separate IoT database and ran once per GPS point. Over the cron's 3h window that is a few hundred redundant connections; over a 90-day sweep it is one per point across 7.5M points, which is why historical detection could not finish. Busiest asset: >10min timeout to 28.7s. GPS recovered retroactively (as ~87 days of it was on 2026-08-06) never produces trips, because the rolling window has already moved past it. Rather than a script someone runs by hand in a prod shell, the cron now sweeps history itself: set asset_management.trip_catchup_days and it works through the backlog 25 assets per run, tracking a cursor, then clears its own keys when it catches up. Off unless the key is set. The cursor advances past a failing asset so one bad asset cannot wedge the sweep, and each asset runs in its own savepoint because a DB error would otherwise abort the cursor and take every later asset with it. Refs: #447, #450 lastCommitSHA: e535ea3a706928144b11eff3debb5174ec47b9d5 message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/bifrost/main releaseNotesURL: https://github.com/greencapitaltrade/bifrost/releases/tag/v6.90.19 startedTimestamp: "2026-08-07T06:10:54Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-08-07T06:14:55Z" name: Release startedTimestamp: "2026-08-07T06:13:55Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5223 startedTimestamp: "2026-08-07T06:14:55Z" status: Succeeded startedTimestamp: "2026-08-07T06:14:55Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-07T06:16:02Z" name: from build pack startedTimestamp: "2026-08-07T06:10:59Z" status: Succeeded steps: - completedTimestamp: "2026-08-07T06:11:16Z" name: Git Clone startedTimestamp: "2026-08-07T06:10:59Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:20Z" name: Next Version startedTimestamp: "2026-08-07T06:11:16Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:25Z" name: Jx Variables startedTimestamp: "2026-08-07T06:11:20Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:28Z" name: Setup Pip Cache startedTimestamp: "2026-08-07T06:11:26Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:29Z" name: Process Config Templates startedTimestamp: "2026-08-07T06:11:29Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:30Z" name: Update Asset Management Version startedTimestamp: "2026-08-07T06:11:30Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:32Z" name: Check Registry startedTimestamp: "2026-08-07T06:11:30Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:02Z" name: Build Container Build startedTimestamp: "2026-08-07T06:11:33Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:14Z" name: Promote Changelog startedTimestamp: "2026-08-07T06:14:03Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:18Z" name: Promote Helm Release startedTimestamp: "2026-08-07T06:14:14Z" status: Succeeded - completedTimestamp: "2026-08-07T06:15:21Z" name: Promote Jx Promote startedTimestamp: "2026-08-07T06:14:18Z" status: Succeeded - completedTimestamp: "2026-08-07T06:16:02Z" name: Publish Org Kb startedTimestamp: "2026-08-07T06:15:22Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-07T06:16:02Z" name: from build pack startedTimestamp: "2026-08-07T06:10:59Z" status: Succeeded steps: - completedTimestamp: "2026-08-07T06:11:16Z" name: Git Clone startedTimestamp: "2026-08-07T06:10:59Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:20Z" name: Next Version startedTimestamp: "2026-08-07T06:11:16Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:25Z" name: Jx Variables startedTimestamp: "2026-08-07T06:11:20Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:28Z" name: Setup Pip Cache startedTimestamp: "2026-08-07T06:11:26Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:29Z" name: Process Config Templates startedTimestamp: "2026-08-07T06:11:29Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:30Z" name: Update Asset Management Version startedTimestamp: "2026-08-07T06:11:30Z" status: Succeeded - completedTimestamp: "2026-08-07T06:11:32Z" name: Check Registry startedTimestamp: "2026-08-07T06:11:30Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:02Z" name: Build Container Build startedTimestamp: "2026-08-07T06:11:33Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:14Z" name: Promote Changelog startedTimestamp: "2026-08-07T06:14:03Z" status: Succeeded - completedTimestamp: "2026-08-07T06:14:18Z" name: Promote Helm Release startedTimestamp: "2026-08-07T06:14:14Z" status: Succeeded - completedTimestamp: "2026-08-07T06:15:21Z" name: Promote Jx Promote startedTimestamp: "2026-08-07T06:14:18Z" status: Succeeded - completedTimestamp: "2026-08-07T06:16:02Z" name: Publish Org Kb startedTimestamp: "2026-08-07T06:15:22Z" status: Succeeded version: 6.90.19 status: {}