Wrong version assigned on updates

[fridex]

Describe the bug

See the following endpoint that lists data for versions. It states that elyra in version=3.5.1 (on UBI 8 Python 3.8) has a dependency on click<8,>=7.1.1. However linked versions in the database are (based on API endpoint):

"versions": [
    "7.1.1",
    "7.1.2",
    "8.0.4"
]

I suspect this wrong version assigned in the database is caused by a release of click==8.0.4. For some reason, revsolver assigns click==8.0.4 as a dependency of elyra==3.5.1 even though it does not respect the version specifier. I'm not sure if revsolver is really the issue maker, but the corresponding solver document that solved elyra==3.5.1 on UBI 8 Python 3.8 has no click==8.0.4 stated (and click in that version might not be even released at the time of solving).

To Reproduce

I see this issue for the second time. Not sure how to reproduce it directly except for waiting for package releases and check timestamps for things that are happening in the system (or run revsolver locally against a local database dump without new releases). The issue might be caused by some incosystency (maybe environment markers?) that create this issue from time to time.

[goern]

/assign @mayaCostantini
/kind bug
/priority important-soon
/sig stack-guidance

[sesheta]

Issues go stale after 90d of inactivity.
Mark the issue as fresh with /remove-lifecycle stale.
Stale issues rot after an additional 30d of inactivity and eventually close.

If this issue is safe to close now please do so with /close.

/lifecycle stale

[mayaCostantini]

/remove lifecycle-stale
/lifecycle frozen