Server (Master node) unresponsive and PostgreSQL Suspended

HenrikE — Mon, 19 Feb 2024 13:07:14 GMT

Hi,

Environment:
Qlik Sense Enterprise
Qlik Sense August 2023, patch 7

Setup: one Master node and one Slave

Issue:
We have been facing an issue two Mondays in a row now. Last Monday it was in the afternoon and today it was in the morning where the server (with the Master node) gets unresponsive.

Last Monday I was after a long time able to logon to the server and check some monitoring applications and where in the Resource Monitor I saw below. Don’t know if it is the reason or consequence but Postgresql had been set to Suspended.

Today I wasn’t able to logon to the server at all but behavior is just the same as last week, making me think I would have looked the same.

Perhaps worth mentioning is that I setup a REST-API last Monday. The API has a limit of 50 request per hour and 300 per day, of which both I reached/exceeded, since I’m using a While loop to extract rows and write them to a QVD (dropping table before starting over and reading from the stored QVD). Finally the task/script fails when reaching either threshold, see below script error message. However rest of the week and during the weekend I continued working with and testing the API without issues.

Error: HTTP protocol error 429 (Too Many Requests):
{
“message”:”API rate limit exceeded”
}

The solution have been in both cases to do a hard restart of the server (with the Master node only, Slave node is working and answering as usual).

Wondering if anyone know if this is a known issue, and/or has experienced the same issue and if so know the problem and have a solution or can point in any direction on how to trace the issue, logs to look into – Qlik or Windows, Postgresql config, etc. etc.? Any help would be highly appreciated.

Thanks!
Henrik

Re: Server (Master node) unresponsive and PostgreSQL Suspended

Alan_Slaughter — Tue, 27 Feb 2024 20:37:41 GMT

Hi Henrik, maybe this will provide some help:

https://community.qlik.com/t5/Official-Support-Articles/Turn-on-PostgreSQL-logs-in-Qlik-Sense/ta-p/1715486

Re: Server (Master node) unresponsive and PostgreSQL Suspended

HenrikE — Thu, 29 Feb 2024 08:55:38 GMT

Thank you @Alan_Slaughter! Much appreciated!

After upgrade and with a separated PostgreSQL (instead of bundled as before) I assume the logs will be located here:

C:\Program Files\PostgreSQL\14\

instead of here:

C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6\pg_log

topic Re: Server (Master node) unresponsive and PostgreSQL Suspended in Management & Governance

Server (Master node) unresponsive and PostgreSQL Suspended

Re: Server (Master node) unresponsive and PostgreSQL Suspended

Re: Server (Master node) unresponsive and PostgreSQL Suspended