Сервер периодически выдает 500 ошибку + каждые 4 минуты перезагружается MariaDB — есть идеи?

Question

[orange47]

Спасите Помогите))) Ума не приложу что делать и как найти ошибку...
Apache 2.4.6-90.el7.centos
MySQL 5.5.64-1.el7
PHP 5.4.16-46.1.el7_7
Perl 5.16.3-294.el7_6
Kernel 3.10.0-1062.9.1.el7.x86_64

лог мессаджес
Oct 31 10:04:07 new mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Oct 31 10:04:07 new mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Oct 31 10:04:07 new mysqld_safe: 201031 10:04:07 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Oct 31 10:04:07 new mysqld_safe: 201031 10:04:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 31 10:04:10 new systemd: Started MariaDB database server.
Oct 31 10:05:01 new systemd: Started Session 43549 of user root.
Oct 31 10:05:01 new systemd: Started Session 43546 of user root.
Oct 31 10:05:01 new systemd: Started Session 43548 of user root.
Oct 31 10:05:01 new systemd: Started Session 43547 of user root.
Oct 31 10:05:01 new systemd: Started Session 43550 of user root.
Oct 31 10:05:01 new systemd: Started Session 43551 of user root.
Oct 31 10:05:01 new systemd: Started Session 43552 of user root.
Oct 31 10:05:01 new systemd: Started Session 43553 of user root.
Oct 31 10:06:01 new systemd: Started Session 43555 of user root.
Oct 31 10:06:01 new systemd: Started Session 43554 of user root.
Oct 31 10:06:01 new systemd: Started Session 43556 of user root.
Oct 31 10:07:01 new systemd: Started Session 43557 of user root.
Oct 31 10:07:01 new systemd: Started Session 43559 of user root.
Oct 31 10:07:01 new systemd: Started Session 43558 of user root.
Oct 31 10:08:01 new systemd: Started Session 43560 of user root.
Oct 31 10:08:01 new systemd: Started Session 43561 of user root.
Oct 31 10:08:01 new systemd: Started Session 43562 of user root.
Oct 31 10:08:01 new systemd: Started Session 43563 of user root.
Oct 31 10:08:02 new systemd: Stopping MariaDB database server...
Oct 31 10:08:04 new systemd: Stopped MariaDB database server.
Oct 31 10:08:04 new systemd: Starting MariaDB database server...
Oct 31 10:08:04 new mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Oct 31 10:08:04 new mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Oct 31 10:08:04 new mysqld_safe: 201031 10:08:04 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Oct 31 10:08:04 new mysqld_safe: 201031 10:08:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 31 10:08:07 new systemd: Started MariaDB database server.
Oct 31 10:09:01 new systemd: Started Session 43565 of user root.
Oct 31 10:09:01 new systemd: Started Session 43564 of user root.
Oct 31 10:09:01 new systemd: Started Session 43566 of user root.

лог Марии:

201031 10:16:10 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1966363809
201031 10:16:10 [Note] Plugin 'FEEDBACK' is disabled.
201031 10:16:10 [Note] Server socket created on IP: '127.0.0.1'.
201031 10:16:10 [Note] Event Scheduler: Loaded 0 events
201031 10:16:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
201031 10:20:02 [Note] /usr/libexec/mysqld: Normal shutdown
201031 10:20:02 [Note] Event Scheduler: Purging the queue. 0 events
201031 10:20:02 InnoDB: Starting shutdown...
201031 10:20:04 InnoDB: Shutdown completed; log sequence number 1966363819
201031 10:20:04 [Note] /usr/libexec/mysqld: Shutdown complete
201031 10:20:04 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
201031 10:20:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
201031 10:20:05 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 14360 ...
201031 10:20:05 InnoDB: The InnoDB memory heap is disabled
201031 10:20:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
201031 10:20:05 InnoDB: Compressed tables use zlib 1.2.7
201031 10:20:05 InnoDB: Using Linux native AIO
201031 10:20:05 InnoDB: Initializing buffer pool, size = 8.0G
201031 10:20:05 InnoDB: Completed initialization of buffer pool
201031 10:20:05 InnoDB: highest supported file format is Barracuda.
201031 10:20:05 InnoDB: Waiting for the background threads to start
201031 10:20:06 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1966363819
201031 10:20:06 [Note] Plugin 'FEEDBACK' is disabled.
201031 10:20:06 [Note] Server socket created on IP: '127.0.0.1'.
201031 10:20:06 [Note] Event Scheduler: Loaded 0 events
201031 10:20:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
201031 10:24:01 [Note] /usr/libexec/mysqld: Normal shutdown
201031 10:24:01 [Note] Event Scheduler: Purging the queue. 0 events
201031 10:24:01 InnoDB: Starting shutdown...
201031 10:24:06 InnoDB: Shutdown completed; log sequence number 1966363829
201031 10:24:06 [Note] /usr/libexec/mysqld: Shutdown complete
201031 10:24:06 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
201031 10:24:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
201031 10:24:06 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 15334 ...
201031 10:24:06 InnoDB: The InnoDB memory heap is disabled
201031 10:24:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
201031 10:24:06 InnoDB: Compressed tables use zlib 1.2.7
201031 10:24:06 InnoDB: Using Linux native AIO
201031 10:24:06 InnoDB: Initializing buffer pool, size = 8.0G
201031 10:24:07 InnoDB: Completed initialization of buffer pool
201031 10:24:07 InnoDB: highest supported file format is Barracuda.
201031 10:24:07 InnoDB: Waiting for the background threads to start
201031 10:24:08 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1966363829
201031 10:24:08 [Note] Plugin 'FEEDBACK' is disabled.
201031 10:24:08 [Note] Server socket created on IP: '127.0.0.1'.
201031 10:24:08 [Note] Event Scheduler: Loaded 0 events
201031 10:24:08 [Note] /usr/libexec/mysqld: ready for connections.

Comments

[ky0]

В кроне, может, задание какое-нибудь, установленное выполняться раз в 4 минуты? Больно промежутки одинаковые...

Answer 1

[alfss]

Кто-то рестартует сервак, смотрите крон, может какие программы крутятся незнакомые, может, что-то в systemd базы дописано, в логах нет падения.

Очень интересно откуда столько сессий рута

Comments

[orange47]

## ISPsystem acme.sh certs update task
8 3 * * * /usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core acmesh.certs.update >/dev/null 2>&1
## ISPsystem task which collect system statistics
*/5 * * * * /usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core sysinfostat >/dev/null 2>&1
## ISPsystem delete expire logs task
0 3 * * * /usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core deletearchivelogs >/dev/null 2>&1
## ISPsystem usagestat task
11 3 * * * /usr/local/mgr5/sbin/cron-core sbin/usagestat >/dev/null 2>&1
## ISPsystem problems autosolve task (/usr/local/mgr5)
*/5 * * * * /usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core problems.autosolve >/dev/null 2>&1
## ISPsystem update package cache task
2 6 * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/pkgupdate.sh >/dev/null 2>&1
## ISPmanager stat handler (ispmgr)
15 9 * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr ispstat >/dev/null 2>&1
## ISPmanager periodic tasks handler (ispmgr)
* * * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr periodic >/dev/null 2>&1
## ISPsystem problems autosolve task (/usr/local/mgr5)
*/5 * * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr problems.autosolve >/dev/null 2>&1
## Check DS records from the domain registrar
52 4 * * 0 /usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr checkdsrecords >/dev/null 2>&1
## ISPsystem upgrade task
12 17 * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/pkgupgrade.sh coremanager >/dev/null 2>&1
## ISPsystem check packages task
12 18 * * * /usr/local/mgr5/sbin/cron-ispmgr etc/scripts/pkgcheck.sh >/dev/null 2>&1
# BACKUP
0 0 * * * nice -n 19 ionice -c3 /root/bin/backup.sh > /var/log/backup.log 2>&1
*/4 * * * * /var/www/cgi-bin/ping.sh >/dev/null 2>&1
## ISPmanager letsencrypt cert update check
7 3 * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr letsencrypt.check.update >/dev/null 2>&1
* * * * * rsync -r /var/www/data/logs/ /root/tmp/logs/
## ISPmanager metric task
*/5 * * * * /usr/local/mgr5/sbin/cron-ispmgr sbin/metric >/dev/null 2>&1
## ISPsystem services monitoring task (srvmon)
*/15 * * * * /usr/local/mgr5/sbin/cron-ispmgr addon/srvmon >/dev/null 2>&1

[Денис Юрьев]

/var/www/cgi-bin/ping.sh
идеальный кандидат, еще и по параметрам запуска подходит (каждые 4 минуты), посмотрите что там.
в ispmanager 5 lite нет такого скрипта, тем более в кроне

[orange47]

Денис Юрьев, благодарю за помощь. Все дело было именно в нем.