Memory problem

Question

Good morning,

I am having a memory problem.
I have configured the RAM for the software (version 2.4.1) up to 30 GB. The software has been placed on a virtual server with 36 GB of RAM, and it is the only software running on this server.

For the past few months, I have been creating calculation processes on a database comprising a mix of three databases: EcoInvent, Agribalyse, and Agrifootprint (I need these because I work in plant extraction chemistry).
At first, I ran calculations and everything was fine; I got the results without any problems.
For the past two weeks, every time I run a calculation (whether it's for my products or a simple process, I only run one calculation at a time), the application crashes during the calculation without any log messages.
I checked with our IT department, and the server's RAM is reaching saturation point, and there are no errors in the Java trycatch.
Do you have any ideas, please?

Thank you in advance.

Answer 1

It sounds like a somewhat complicated setup and thus there are several reasons possible but easy things would be to 

a) compress the database

or b) make a backup and recreate the database from the backup. 

Let me know if this works, thank you.

Best wishes,

Andreas

- you could also use libraries if you do not modify the databases and only integrate them in your system, this will reduce memory needs a lot

Comments

Thank you very much for your quick response and explanations.

I tested both solutions:
- I compressed the database twice, and each time I got this message:
" This will compress the database and free up unsued space. For bigger databases this might take a while.
Size before compression : 21210 MB
Size after compression : 21210 MB"
- I created a backup
In both cases, I had exactly the same problem. I'm a little lost.

Regarding your last sentence, I'm sorry, but I'm not an IT specialist and I don't understand this solution. Could you explain it to me in more detail, please? I shared your reply with our IT department, but they couldn't explain it to me either.

Thank you anyway.