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 systemd > > > > > > > > > > > > > > On 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 > > > > > > > > > > > > getting > > > > > > > > > > hammered > > > > > > > > > > > > by AI robots stressing the system. A LONG time ago I > > > > > > > > > > > > had a similar > > > > > > > > > > > > problem with memory allcoation being excusted and Monty > > > > > > > > > > > > showed me how > > > > > > > > > > to > > > > > > > > > > > > increase 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 -- 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]
