ERROR empty id not valid when running upgrade-series

db.applications.find({},{"charm-origin.id":1}).pretty() shows a couple of charms without any charm-origin

e.g.:

{
 "_id" : "3f822b7a-63ed-402d-8b2c-c1f25c3f731d:sysconfig-ctrl",
 "charm-origin" : {
  "id" : ""
 }
}

removing those charms unblocked the upgrade, but those were all subordinates, which we can remove, what if this is a principal charm?

I assume this model has been upgraded through various versions.

Can you connect to Mongo:
https://discourse.charmhub.io/t/login-into-mongodb/309

And get us the output from "db.applications.find().pretty()"?

There is almost certainly some charm-origin info missing here, as that message is only emitted from charmhub download/refresh calls.

https://pastebin.canonical.com/p/cjQDxJGJpH/

@dparv, What is the charm-url for sysconfig-ctrl? Not all applications require an ID in their charm-origin.

This appears to be duplicate of or related to: https://bugs.launchpad.net/juju/+bug/1999640

Everything was deployed form charmhub. Model was not upgraded at all, brand new deployment just for testing the series upgrade of openstack. Where do I check the charm-url (although I already removed the application)

some new information from today - the controller was re-used from a previous openstack deployment (same model name + same applications) - would that in any way cause this?

Reusing a model name shouldn't have caused the issue, but it might explain why I haven't been able to track this down to the root case. Although I'd expect to see the issue with more charms if that was the case.