There are several obvious issues in what you posted, to so with ulimit. You
need to look at your service scripts and make sure that they set suitable
limits for what you are configuring in my.cnf.
Are you using the CentOS 8 bundled MariaDB 10.3 or the packages from the
MariaDB repositories?
Your journalctl output seems incomplete. systemctl status output may also
be useful (make sure neither is truncated in width).
Comment out all of your tuning options and see if it starts then. Unless
you know _exactly_ what you are doing or had somebody who _really_ knows
what they are doing change any options other than innodb_buffer_pool_size,
you should probably leave them at defaults.
On Sun, May 17, 2020 at 3:00 PM Ralf Hartings
Hi
My up-to-date Wordpress website running with mariadb 10.3 on CentOS8 (up to date) has been running for a long time without any issues. Suddenly, yesterday, my server became unreachable and did not respond to anything. Only power off/on helped to get it to respond again, but the website is down. I did not update the server in the last 2 weeks. No changes whatsoever.
The logs show the mariadb server is restarting and crashing continuously. I switched off the mariadb.service to avoid any possible further issues, as I run a mailserver on the same machine (which runs just fine now).
Please look at my post in the CentOS forum: https://forums.centos.org/viewtopic.php?f=54&t=74436&p=313469#p313469 The people there are great experts in CentOS, but probably no experts in mariadb in the same way as you are, and I really would like to get my site up again ASAP.
Thanks a lot for reading this post and helping me out on this!
/Ralf
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp