OTA updates miss-sync between thingsboard cloud and edge

[lagoon-come-strep]

Describe the bug

While updating/adding OTA updates to thingsboard cloud with edge disconnected (and after reconnect to thingboard edge). thingboard edge get a package that no longer exist in thingboard cloud.

I first notice the following error message as thingboard cloud notification:

Edge 'X' communication failure occurred
Failure message: '{Failed to deliver the batch}: {[downlinkMsgId: 1148911177 otaPackageUpdateMsg { msgType: ENTITY_UPDATED_RPC_MESSAGE idMSB: -500257102057696785 idLSB: -7726154770906329955 entity: "{\"id\":{\"entityType\":\"OTA_PACKAGE\",\"id\":\"f90ebad0-ef7c-11ef-94c7-2f2bb8704c9d\"},\"createdTime\":1740050550525,\"tenantId\":{\"entityType\":\"TENANT\",\"id\":\"d64d06f0-b700-11ef-95ce-bb0d4cdea9f4\"},\"deviceProfileId\":{\"entityType\":\"DEVICE_PROFILE\",\"id\":\"cf5ee200-b7aa-11ef-b5b3-a76f6216e9a1\"}'

In thingboard cloud log, I get this message:
2025-02-20 11:25:31,354 [grpc-default-executor-4] ERROR o.t.s.s.edge.rpc.EdgeGrpcSession - [d64d06f0-b700-11ef-95ce-bb0d4cdea9f4][1fd2f682-0028-77ab-7891-e1a9e330544c] Msg processing failed! Msg Id: [1148911177], Error msg: OtaPackage with such title and version already exists!

The superfluous package in edge don't autoremove with cloud manual sync.
Try to add a package with the same name in cloud to overwritten it doesn't work.

I wonder how to fix it. I don't really know if it is a bug.

Your Server Environment

• own setup
  • Deployment: monolith
  • Deployment type: docker-compose
  • ThingsBoard edge Version 3.8.0EDGE
  • ThingsBoard cloud Version 3.8.1
  • Community Edition
  • Debian bookworm

Your Client Environment

• firefox (windows & ubuntu)

Your Device

• Connectivity
  • MQTT

To Reproduce
Check the Describe the bug section. I've maybe remove the ethernet cable while updating.

Expected behavior
OTA updates firmware & software list in thingsboard cloud & edge are identical

Additional context
Edge got a firmware package more than cloud (and seems to be undeletable)

---

Disclaimer

We appreciate your contribution whether it is a bug report, feature request, or pull request with improvement (hopefully). Please comply with the Community ethics policy, and do not expect us to answer your requests immediately. Also, do not treat GitHub issues as a support channel.

[volodymyr-babak]

adding @jekka001 to check this.