Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
