Error during search: Can’t reconnect until invalid transaction is rolled back openwebui. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
If you are facing this error in the openwebui, I can show you how to fix it.
My Environment
- OpenWebUI is installed using Helm on Kubernetes How to install OpenWebUI on Kubernetes with helm
- OpenWebUI uses Azure PostgreSQL Database How to use PostgreSQL with OpenWebUI
I encountered this error while promoting in OpenWebUI. I troubleshot it for a few days and then discovered that if your application uses connection pooling, the connection associated with the invalid transaction cannot be reused until it has been rolled back. This prevents further operations from being executed on that connection.
Then I change the Azure PostgreSQL Database Tier in Azure from Burstable to General Purpose mode.
After changing the tier I have enabled the pgbouncer in the Server Parameters in the Azure PostgreSQL console. You can go to the Database page in the Portal then Server Parameters and search for pgbouncer.enabled and switch it to true. You don’t have to restart the PostgreSQL server.
After enabling the pgbouncer you will not get this error. At least I didn’t get this error after these steps.
Please let me know in the comment if this solved your issue or not.
Can’t reconnect until invalid transaction is rolled back openwebui