INFORMATIONAL: Database has 10.0% freeable memory.

1
Hi Team, I am getting below alert from Mendix for my test environment : INFORMATIONAL: Database has 10.0% freeable memory. It says informational, can you please suggest what actions are needed and how much memory left. Also , can anyone help me with how to increase the memory/resolution ? Thank you.
asked
3 answers
3

We have been seeing this on one of our applications recently too.  The redeployment and restart of the environment didn’t work in our case.

 

We downloaded a backup of the data in the environment (including the files) and restored it to a Postgres database (see restore a backup locally here).  A quick select statement like the one below executed in the Query tool of your Postgres environment should show you what tables take up a large amount of space.  The SQL statement will not show your file size and only covers structured data (i.e. tables).  You should be able to see the total file size from the backup.

 

SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
    AND C.relkind <> 'i'
    AND nspname !~ '^pg_toast'
  ORDER BY pg_total_relation_size(C.oid) DESC

 

With a bit of troubleshooting, you should be able to see whether any of your tables are unexpectedly large and perhaps whether you can delete some of the data in your tables. 

 

In our case, we will likely need a bigger app container. 

answered
0

You don’t need to take action. But if you really want to do something, redeploy with restart will free up all this memory…..

answered
0

Hi All, I also get the same alert for 3 different environments from 2 applications. I have also restarted the applications, but nothing helps. As soon as someone is starting to use the Test or Acceptance environment, I get this alert that the Database Freeable Memory is critical. Then I will recieve an Recovery Alert.

 

I think it also has to do due to an update on Mendix Cloud since October 17th;

 

Mendix Cloud Updates

October 17th, 2022

Improvements

  • We updated our alert template to remove the Application Server Memory alert.
  • We added the Database Freeable Memory alert with the critical threshold set to 10%

 

So, there was always a Database Freeable Memory issue, but now we get the alert because of the threshold set to 10%?

 

First actions to take: Inspect the trends graph Database Node Operating System Memory for anomalies and correlate those with application behavior. Resolve by identifying and optimizing long-running database queries, or by ordering more memory.

 

We had never problems with the applications where we recieve this alert, so I think we need to order more memory I guess? 

answered