Thanks for your quick reply Gordon!
I will get you the info you asked for soon (no acces to server right now..).
However, I have not touched any of the settings since i installed mariadb in October last year, and it has worked ever since without any issues! That makes me very suspicious.....
I have not been in "my.cnf" (don't even know where that is) as far as I know. To my knowledge, I have not tuned anything, just installed it out of the box.
Are the settings in that file created during a default installation?
Would a forced re-install of all my mariadb rpm's help to put everything back to default, incl all setting files, assuming that this will work?
Anyhow, I will come back to you and the mailing list with the info you asked for as soon as I have access again to the server.
Many Thanks again!
/Ralf
Den 17 maj 2020, kI 16:15, Gordan Bobic <
gordan.bobic@gmail.com> skrev:
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.
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
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