Hi,Yea, figure out why you're running out of RAM ... your overall system is highly over-committed on RAM, resulting the the kernel having no choice but to kill some process or another, due to the way things work, this will typically be mariadb as it's the single process consuming the most RAM.
Kind regards, Jaco On 2026/03/26 01:12, Ruben Safir via discuss wrote:
Still crashing [ruben@www3 ~]$ sudo grep maria /var/log/everything.log [sudo] password for ruben: Mar 22 21:25:23 www3 start-stop-daemon[19993]: Will stop /usr/bin/mariadbd Mar 23 15:51:04 www3 start-stop-daemon[25003]: Will stop /usr/bin/mariadbd Mar 23 15:51:04 www3 mariadb[25003]: start-stop-daemon: no matching processes found Mar 23 15:51:08 www3 mariadb[25012]: WARNING: mariadb is already stopped Mar 24 19:30:13 www3 kernel: [ 25033] 60 25033 553615 3971 3831 140 0 1204224 99374 0 mariadbd Mar 24 19:30:13 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.named,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=25033,uid=60 Mar 24 19:30:13 www3 kernel: Out of memory: Killed process 25033 (mariadbd) total-vm:2214460kB, anon-rss:15324kB, file-rss:560kB, shmem-rss:0kB, UID:60 pgtables:1176kB oom_score_adj:0 There must be a fix for this, otherwise and website with a mariadb would be useless On Mon, Mar 23, 2026 at 04:00:47PM -0400, Ruben Safir wrote:eh Mar 18 21:46:30 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=29990,uid=60 Mar 18 21:46:42 www3 mariadb[30043]: WARNING: mariadb is already stopped Mar 18 21:47:36 www3 kernel: mariadbd invoked oom-killer: gfp_mask=0x140dca(GFP_HIGHUSER_MOVABLE|__GFP_COMP|__GFP_ZERO), order=0, oom_score_adj=0 Mar 18 21:47:36 www3 kernel: CPU: 1 UID: 60 PID: 30070 Comm: mariadbd Not tainted 6.12.71-1-lts #1 0c6f64fd677899b1f215535073935a6275af35f3 Mar 18 21:47:36 www3 kernel: [ 30070] 60 30070 441047 43420 43395 25 0 483328 0 0 mariadbd Mar 18 21:47:36 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=30070,uid=60 On Sat, Mar 21, 2026 at 02:27:58PM -0400, Ruben Safir via discuss wrote:Thanks! I'll try it. I already have the libraries on the system so I will alter the init script. Is Monty still around? We used to talk quite a bit but I don't see him much any more. On Sat, Mar 21, 2026 at 08:10:25PM +0200, Gordan Bobic via discuss wrote:I don't think you can controll it through my.cnf. You'll have to edit the init script to add the LD_PRELOAD environment variable when mysqld/mariadbd loads. On Sat, 21 Mar 2026 at 20:06, Ruben Safir <[email protected]> wrote:On Sat, Mar 21, 2026 at 07:47:20PM +0200, Gordan Bobic via discuss wrote:yum install gperftools-libs ``` systemctl edit mariadb ``` and add this: ``` [Service] Environment="LD_PRELOAD=libtcmalloc_minimal.so.4" ``` Then: ``` systemctl daemon-reload systemctl restart mariadb ```This can not be controlled through my.conf or is this kernel/system environment issue. I don't use systemdOn Sat, 21 Mar 2026 at 19:38, Ruben Safir <[email protected]> wrote:On Sat, Mar 21, 2026 at 02:42:48PM +0200, Gordan Bobic via discuss wrote:Assuming you don't have your memory for MariaDB set too high for your RAM size (check using one of the many online MariaDB/MySQL memory calculators), it could be glibc's malloc() that has less than stellare fragmentation/occupancy characteristics. You might want to LD_PRELOAD tcmalloc and see of the OOM problem goes away.Aside from altering header files and recompiling :) how would I go about and do that.I have seen this problem manifest looking like a memory leak on several database estates I look after. On Sat, 21 Mar 2026 at 14:28, Ruben Safir via discuss <[email protected]> wrote:On Sat, Mar 21, 2026 at 08:53:49AM -0300, Arlindo Neto wrote:It looks like apache is also getting killed by OOM in your 4GB VM.Where do you see apache getting killed? Apache seems to always be running and mariadbd is killed. And it won't restart. I often pound the heck out of apache http://www.brookln-fishing.com alone is my master peice of stupid web design with thousand of images on it which swells apaches connecitons and cached memory in modperl. It is only maria which seems to be crashing. It is used for a simple text mailing list which stores emails in mariadb and serves them read-only. Mailing list entries are live stored on a back end database on another machine where the mail is running and perdiodically I just rsync the entire database from /usr/locl/var to the webserver. The mailing list gets hammered by bots and that seems to be the source of the problem.MariaDB could be the victim here. I believe your next move should be tuning Apache so it uses less memory, or move your db server to a spare VPS, so you can better troubleshoot who is eating up your RAM. Cheers. On Sat, Mar 21, 2026 at 8:28 AM Ruben Safir via discuss < [email protected]> wrote:Not sure if this is much help Mar 17 21:03:13 www3 kernel: Out of memory: Killed process 14642 (mariadbd) total-vm:4142548kB, anon-rss:13008kB, file-rss:440kB, shmem-rss:0kB, UID:60 pgtables:1612kB oom_score_adj:0 Mar 18 05:41:20 www3 mariadb[25757]: start-stop-daemon: no matching processes found Mar 18 08:41:16 www3 kernel: Out of memory: Killed process 25788 (mariadbd) total-vm:3217532kB, anon-rss:9196kB, file-rss:328kB, shmem-rss:0kB, UID:60 pgtables:1080kB oom_score_adj:0 Mar 17 21:03:13 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=68,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=14642,uid=60 Mar 18 05:41:24 www3 mariadb[25767]: WARNING: mariadb is already stopped Mar 18 08:41:16 www3 kernel: [ 25788] 60 25788 804383 2381 2299 82 0 1105920 91680 0 mariadbd Mar 18 08:41:16 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=68,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=25788,uid=60 Mar 18 21:45:07 www3 kernel: mariadbd invoked oom-killer: gfp_mask=0x140dca(GFP_HIGHUSER_MOVABLE|__GFP_COMP|__GFP_ZERO), order=0, oom_score_adj=0 Mar 18 21:45:07 www3 kernel: CPU: 1 UID: 60 PID: 29866 Comm: mariadbd Not tainted 6.12.71-1-lts #1 0c6f64fd677899b1f215535073935a6275af35f3 Mar 18 21:45:07 www3 kernel: [ 29866] 60 29866 441047 22216 22186 30 0 303104 0 0 mariadbd Mar 18 21:45:07 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/68,task=/usr/local/apac,pid=14730,uid=2 Mar 18 21:46:30 www3 kernel: oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=openrc.mariadb,mems_allowed=0,global_oom,task_memcg=/openrc.mariadb,task=mariadbd,pid=29990,uid=60 On Sat, Mar 21, 2026 at 06:52:51AM -0400, Ruben Safir via discuss wrote:I'll see what I can do on the next crash, but I haven't been able to get anything from the logs On Sat, Mar 21, 2026 at 05:57:31AM -0400, Ruben Safir wrote:mariadb, which I am running at Artix Linux, has been set up and flawlessly running for decades with Perl DBI:DBD Of late, it has regularly been crashing and I can't find even log entries as to the cause, but suspect that the server is gettinghammeredby AI robots stressing the system. A LONG time ago I had a similar problem with memory allcoation being excusted and Monty showed me howtoincrease the memory allocation. I don't know if a similar thing will help as I am sure that these f***king robots will steal as many resources as you will feed them. Once it crashed, it will not restart. Sometimes I need to kill apache as well to restart. Occasionally I've had to do a complete system reboot. Do I have a solution to this? Reuvain -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013 _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013 _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013 _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net Follow us: LinkedIn: https://www.linkedin.com/company/shatteredsilicon X: https://x.com/ssiliconbg _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013-- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net Follow us: LinkedIn: https://www.linkedin.com/company/shatteredsilicon X: https://x.com/ssiliconbg _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013-- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net Follow us: LinkedIn: https://www.linkedin.com/company/shatteredsilicon X: https://x.com/ssiliconbg _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013 _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]-- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and extermination camps, but incompatible with living as a free human being. -RI Safir 2013
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
