oom on postgres?? #2674

New Issue

AliasAlreadyTaken · 2022-09-13T21:45:00Z

AliasAlreadyTaken commented

2022-09-13 21:45:00 +00:00

[1897974.399364] Out of memory: Killed process 385785 (minetestserver) total-vm:51164600kB, anon-rss:28644436kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:98796kB oom_score_adj:0

flux added the

1. kind/bug

2. prio/critical

labels 2022-09-13 22:59:39 +00:00

flux commented

2022-09-13 23:00:05 +00:00

postgres was using 51GB memory?!

flux commented

2022-09-13 23:16:57 +00:00

probably something we should do is to call VACUUM whenever we start the main server process, at most once a day?

some other stuff:

https://dba.stackexchange.com/questions/160887/how-can-i-find-the-source-of-postgresql-per-connection-memory-leaks/222815#222815
https://italux.medium.com/postgresql-out-of-memory-3fc1105446d
this is more for very different database usage situations. minetest only has a handful of connections to the database, and the querios are generally very simple, but the connections are very long lived... buckaroo might have some ideas about why this can happen and how to prevent it.

probably something we should do is to call `VACUUM` whenever we start the main server process, at most once a day? some other stuff: * https://dba.stackexchange.com/questions/160887/how-can-i-find-the-source-of-postgresql-per-connection-memory-leaks/222815#222815 * https://italux.medium.com/postgresql-out-of-memory-3fc1105446d this is more for very different database usage situations. minetest only has a handful of connections to the database, and the querios are generally very simple, but the connections are very long lived... buckaroo might have some ideas about why this can happen and how to prevent it.

AliasAlreadyTaken commented

2023-12-05 13:22:32 +00:00

Hasn't happened ever since, so we'll close.

As of today, the server is up 8 days 10 hours and uses up 58GB virtual and 34GB real memory.

Form comparison testserver is up 12 hours and uses up 5.7GB virtual and 3.4 real memory.

Postgresql uses 16.8GB memory

The server currently has 64GB

Hasn't happened ever since, so we'll close. As of today, the server is up 8 days 10 hours and uses up 58GB virtual and 34GB real memory. Form comparison testserver is up 12 hours and uses up 5.7GB virtual and 3.4 real memory. Postgresql uses 16.8GB memory The server currently has 64GB

AliasAlreadyTaken closed this issue

2023-12-05 13:22:32 +00:00

AliasAlreadyTaken added the

5. result/cannot reproduce

label 2023-12-05 13:22:39 +00:00

Sign in to join this conversation.