Facing: error executing SQL statement [ERROR: role with OID 1126150 does not exist (28000)]

[sachin1kumar]

Complete stacktrace:
org.hibernate.HibernateException - java.util.concurrent.CompletionException: org.hibernate.exception.GenericJDBCException: error executing SQL statement [ERROR: role with OID 1126150 does not exist (28000)] [select query]

Hiding the select query due to data privacy, when we run the query on OpenShift pod it works fine.

Observation with this issue:
Suppose currently we are facing this issue while using one of the endpoints of our microservice from Postman, making request multiple times but still same issue. Now, if we recreate the pod on Openshift then use the same endpoint we get the response and we will get the response till exact 1 hour and now if we use the same endpoint after one hour we will face the same issue again until we recreate the pod again on Openshift and this cycle repeats in order to make our endpoint works.

Quarkus bom version: 3.2.2.Final
Quarkus vault version: 'io.quarkiverse.vault:quarkus-vault:3.4.0'

[ruhilrinku]

Is there any update on the above mentioned issue ?

[kdubb]

@sachin1kumar Is this still an issue? Are you using rotating DB credentials? If so, have you set the max-lifetime to recycle connections faster than your Vault lease TTL?

[sachin1kumar]

Yes, this is still an issue. Yes, we are using rotating DB credentials.

[kdubb]

And you have max-lifetime set?

[sachin1kumar]

We tried that as well but it didn't work out. Kind regards, Sachin Kumar

…

On Sat, Sep 28, 2024 at 11:10 PM Kevin Wooten ***@***.***> wrote: And you have max-lifetime set? — Reply to this email directly, view it on GitHub <#241 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEETMDIRGENFTRDISNJ4D5LZY3SXFAVCNFSM6AAAAABD7WW42GVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANZYGUYTGMA> . You are receiving this because you were mentioned.Message ID: ***@***.*** com>