One jobId with two entries of same parameter name in db

[infinelilux]

We get an exception, because we somehow have two entries for the same jobid with the same name in our hangfire db, table jobparameter.
So the upsert in PostgreSqlConnection does not seem to be atomic.

When reading via PostgreSqlConnection.GetJobParameter method with querysingleordefault it now throws an Exception.
Should there be a unique constraint for columns {jobid, name} in table jobparameter?

[azygis]

Interesting. Indeed there should be a unique constraint. Is it a custom parameter or any of the built-ins? Can you share whar these parameters are?