Bug: PostgreSqlUser opens more and more connections

[johgoe]

Describe the bug
User is created and permissions are granted. PGSqlConnection idles. During time more and more connections are created and all idles. It takes some time but then the database accepts no more connection because of 100 idle connections

To Reproduce
Steps to reproduce the behavior:
Create a PostgreSqlUser CR and wait for provisioned and a little bit more.

Expected behavior
User is created and permissions are granted. PGSqlConnection is closed.

Screenshots

Additional context
I guess the connections are from this part:

https://github.com/Azure/azure-service-operator/blob/master/pkg/resourcemanager/psql/psqluser/psqluser_reconcile.go

There are just a view users

[matthchr]

Thanks for the bug report @johgoe - this is a pretty bad bug. It also seems to impact more than just PostgreSQLUser (I think it also impacts the MySQL and AzureSQL flavors).

We'll be looking to get this fixed for the next release of ASO.