question

mohammedazeroual-4946 avatar image
0 Votes"
mohammedazeroual-4946 asked OuryBa-MSFT commented

I can't open a new connection to the database after a success database connection (Azure)

Describe the issue
We use Azure Managed PostgreSQL (11). I connect successfuly to the database from spring boot application. While connecting i disable GSS Encryption (gssEncMode=disable)

But after approximately 15 minutes all the other connections are blocked, and we can't connect from another app. we get the following error : FATAL: authentication failed for user "": too many failed login attempts

Driver Version?
i have tested with 42.2.14. , 42.2.16 and 4.42.18

Spring version
i have tested with 2.1.1.RELEASE and 2.3.4.RELEASE

Java Version?
Java 11 OpenJDK (Windows)

OS Version?
Windows server 2016

PostgreSQL Version?
11

To Reproduce
1. start application that uses pgjdbc to connect to the database.
2. wait for about 15 mins.
3. Open a new connection, i get the error : FATAL: authentication failed for user "": too many failed login attempts


Thanks for your help !!

azure-database-postgresql
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@mohammedazeroual-4946 We are investigating this issue with our PG . I will reach out if I need any info from your end.
Regards,
Oury

0 Votes 0 ·

Hello @mohammedazeroual-4946 Could you please open a support ticket ad share the ticket number so we can keep traction.
Regards,
Oury

0 Votes 0 ·

0 Answers