• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue maria db error problem

tumeva

New Pleskian
hello database server stops and restarts by itself.


Aug 12 18:04:34 server systemd: mariadb.service: main process exited, code=killed, status=6/ABRT
Aug 12 18:04:34 server systemd: Unit mariadb.service entered failed state.
Aug 12 18:04:34 server systemd: mariadb.service failed.



ov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Attempting backtrace. You can use the following information to find out
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: where mysqld died. If you see no messages after this, something went
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: terribly wrong...
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: stack_bottom = 0x0 thread_stack 0x49000
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55ceac66c58e]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55ceac10954f]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: sigaction.c:0(__restore_rt)[0x7f0d4e8775f0]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: :0(__GI_raise)[0x7f0d4cb48337]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: :0(__GI_abort)[0x7f0d4cb49a28]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x4d3560)[0x55ceabe49560]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xaebf97)[0x55ceac461f97]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xb02603)[0x55ceac478603]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xb02a1d)[0x55ceac478a1d]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xb03976)[0x55ceac479976]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xaf0d50)[0x55ceac466d50]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xb4cd08)[0x55ceac4c2d08]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xb578f2)[0x55ceac4cd8f2]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x984cf3)[0x55ceac2facf3]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0xa3b0e8)[0x55ceac3b10e8]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x92a001)[0x55ceac2a0001]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x64)[0x55ceac10bdd4]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x5c59f0)[0x55ceabf3b9f0]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x9ba)[0x55ceabf3cb7a]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x4f8bf1)[0x55ceabe6ebf1]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x4ae)[0x55ceabe74dde]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f0d4cb34505]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: /usr/sbin/mysqld(+0x4f280d)[0x55ceabe6880d]
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: The manual page at MySQL :: MySQL 8.0 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing contains
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: information that should help you find out what is causing the crash.
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Writing a core file...
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Working directory at /var/lib/mysql
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Resource Limits:
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Limit Soft Limit Hard Limit Units
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max cpu time unlimited unlimited seconds
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max file size unlimited unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max data size unlimited unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max stack size 8388608 unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max core file size 0 unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max resident set unlimited unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max processes 31088 31088 processes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max open files 16364 16364 files
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max locked memory 65536 65536 bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max address space unlimited unlimited bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max file locks unlimited unlimited locks
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max pending signals 31088 31088 signals
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max msgqueue size 819200 819200 bytes
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max nice priority 0 0
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max realtime priority 0 0
Nov 06 14:07:17 hostname.replaced.co.uk mysqld[15637]: Max realtime timeout unlimited unlimited us
Nov 06 14:07:17 hostname.replaced.co.uk systemd[1]: mariadb.service: main process exited, code=killed, status=6/ABRT
Nov 06 14:07:17 hostname.replaced.co.uk systemd[1]: Failed to start MariaDB 10.3.19 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: systemd-devel Info Page
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Nov 06 14:07:17 hostname.replaced.co.uk systemd[1]: Unit mariadb.service entered failed state.
Nov 06 14:07:17 hostname.replaced.co.uk systemd[1]: mariadb.service failed.
 
Back
Top