bcgov / bcgov/lcfs

LCFS - Fix Duplicate Draft FSE `charging_equipment` Records

Open
#3,990 0 comments 0 reactions 1 assignee Claimed by @prv-proton View on GitHub
FSE High
Dominant language
Python
Stars
7
Forks
7
Avg merge
2d 7h
Merged PRs (30d)
87

Description

**Describe the task**
Find duplicate draft records in versioned FSE `charging_equipment` data caused by the versioning bug, propose a fix strategy, align with the team lead on scope, then implement the patch.

**Purpose**
Duplicate draft records left in place risk data integrity issues and incorrect state transitions downstream. This task ensures they are identified and cleanly resolved.

**Acceptance Criteria**
- [ ] Query written to identify all affected `charging_equipment` draft records with duplicate versions
- [ ] Fix strategy documented and reviewed with team lead before any data is touched
- [ ] Patch implemented and verified after team lead sign-off on scope

**Additional context**
- Discovery only first — no records modified until strategy is approved
- Confirm the bug's active time window with whoever owns the versioning fix to scope the query
- Follow-up remediation card may be needed if data volume is large

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.