[ask]Gagal start mysql

[yogisparingga]

salam
selamat siang2 rekan2 dwh, ada yang pernah mengalami hal seperti ini, mysql gagal start gara2 ganti ip address.
berbagai macam cara udh dicoba malam tadi, sampai siang ini belum bisa juga.

mohon masukan dan saran nya kepada rekan2 dwh.
atas bantuanya saya ucapkan terima kasih

[root@kayuara ~]# systemctl restart mysql
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@kayuara ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.34 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Tue 2022-03-22 10:07:01 WIB; 5s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 7184 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7)
  Process: 7056 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 7054 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 7184 (code=exited, status=7)
   Status: "MariaDB server is down"

Mar 22 10:06:58 kayuara.idtelnetwork.com systemd[1]: Starting MariaDB 10.3.34 database server...
Mar 22 10:06:58 kayuara.idtelnetwork.com mysqld[7184]: 2022-03-22 10:06:58 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB) starting as process 7184 ...
Mar 22 10:06:58 kayuara.idtelnetwork.com mysqld[7184]: 2022-03-22 10:06:58 0 [Warning] Could not increase number of max_open_files to more than 40000 (request: 160185)
Mar 22 10:07:01 kayuara.idtelnetwork.com systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
Mar 22 10:07:01 kayuara.idtelnetwork.com systemd[1]: Failed to start MariaDB 10.3.34 database server.
Mar 22 10:07:01 kayuara.idtelnetwork.com systemd[1]: Unit mariadb.service entered failed state.
Mar 22 10:07:01 kayuara.idtelnetwork.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

hasil journalctl -xe

[root@kayuara ~]# journalctl -xe
Mar 22 10:11:11 kayuara.idtelnetwork.com sshd[7840]: Disconnected from 172.168.1.1 port 39540 [preauth]
Mar 22 10:11:17 kayuara.idtelnetwork.com sshd[7844]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1  user=root
Mar 22 10:11:17 kayuara.idtelnetwork.com sshd[7844]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:19 kayuara.idtelnetwork.com sshd[7844]: Failed password for root from 172.168.1.1 port 38753 ssh2
Mar 22 10:11:20 kayuara.idtelnetwork.com sshd[7844]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:22 kayuara.idtelnetwork.com sshd[7844]: Failed password for root from 172.168.1.1 port 38753 ssh2
Mar 22 10:11:22 kayuara.idtelnetwork.com sshd[7844]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:25 kayuara.idtelnetwork.com sshd[7844]: Failed password for root from 172.168.1.1 port 38753 ssh2
Mar 22 10:11:25 kayuara.idtelnetwork.com sshd[7844]: Received disconnect from 172.168.1.1 port 38753:11:  [preauth]
Mar 22 10:11:25 kayuara.idtelnetwork.com sshd[7844]: Disconnected from 172.168.1.1 port 38753 [preauth]
Mar 22 10:11:25 kayuara.idtelnetwork.com sshd[7844]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1  user=root
Mar 22 10:11:31 kayuara.idtelnetwork.com sshd[7846]: Invalid user joey from 172.168.1.1 port 34960
Mar 22 10:11:31 kayuara.idtelnetwork.com sshd[7846]: input_userauth_request: invalid user joey [preauth]
Mar 22 10:11:31 kayuara.idtelnetwork.com sshd[7846]: pam_unix(sshd:auth): check pass; user unknown
Mar 22 10:11:31 kayuara.idtelnetwork.com sshd[7846]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1
Mar 22 10:11:33 kayuara.idtelnetwork.com sshd[7846]: Failed password for invalid user joey from 172.168.1.1 port 34960 ssh2
Mar 22 10:11:33 kayuara.idtelnetwork.com sshd[7846]: Received disconnect from 172.168.1.1 port 34960:11: Bye Bye [preauth]
Mar 22 10:11:33 kayuara.idtelnetwork.com sshd[7846]: Disconnected from 172.168.1.1 port 34960 [preauth]
Mar 22 10:11:46 kayuara.idtelnetwork.com sshd[7854]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1  user=root
Mar 22 10:11:46 kayuara.idtelnetwork.com sshd[7854]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:48 kayuara.idtelnetwork.com sshd[7856]: Did not receive identification string from 172.168.1.1 port 61000
Mar 22 10:11:49 kayuara.idtelnetwork.com sshd[7854]: Failed password for root from 172.168.1.1 port 51341 ssh2
Mar 22 10:11:49 kayuara.idtelnetwork.com sshd[7854]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:51 kayuara.idtelnetwork.com sshd[7854]: Failed password for root from 172.168.1.1 port 51341 ssh2
Mar 22 10:11:52 kayuara.idtelnetwork.com sshd[7854]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:53 kayuara.idtelnetwork.com sshd[7854]: Failed password for root from 172.168.1.1 port 51341 ssh2
Mar 22 10:11:53 kayuara.idtelnetwork.com sshd[7854]: Received disconnect from 172.168.1.1 port 51341:11:  [preauth]
Mar 22 10:11:53 kayuara.idtelnetwork.com sshd[7854]: Disconnected from 172.168.1.1 port 51341 [preauth]
Mar 22 10:11:53 kayuara.idtelnetwork.com sshd[7854]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1  user=root
Mar 22 10:11:56 kayuara.idtelnetwork.com sshd[7861]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=172.168.1.1  user=root
Mar 22 10:11:56 kayuara.idtelnetwork.com sshd[7861]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Mar 22 10:11:58 kayuara.idtelnetwork.com sshd[7861]: Failed password for root from 172.168.1.1 port 47917 ssh2
Mar 22 10:11:58 kayuara.idtelnetwork.com sshd[7861]: Received disconnect from 172.168.1.1 port 47917:11: Bye Bye [preauth]
Mar 22 10:11:58 kayuara.idtelnetwork.com sshd[7861]: Disconnected from 172.168.1.1 port 47917 [preauth]
Mar 22 10:12:01 kayuara.idtelnetwork.com systemd[1]: Started Session 22 of user root.
-- Subject: Unit session-22.scope has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit session-22.scope has finished starting up.
--
-- The start-up result is done.
Mar 22 10:12:01 kayuara.idtelnetwork.com CROND[7866]: (root) CMD (/usr/local/cpanel/bin/autossl_check_cpstore_queue)

 

[Hostingan]

Kalau dilihat dari lognya, salah satu yang buat ga bisa start :
Mar 22 10:06:58 kayuara.idtelnetwork.com mysqld[7184]: 2022-03-22 10:06:58 0 [Warning] Could not increase number of max_open_files to more than 40000 (request: 160185)

coba cek confignya nya, pastiin max_open di bawah ket error tsb.

 

[yogisparingga]

Kalau dilihat dari lognya, salah satu yang buat ga bisa start :
Mar 22 10:06:58 kayuara.idtelnetwork.com mysqld[7184]: 2022-03-22 10:06:58 0 [Warning] Could not increase number of max_open_files to more than 40000 (request: 160185)

coba cek confignya nya, pastiin max_open di bawah ket error tsb.

sama Tuan masih belum ada perubahan, btw thanks atas jawabanya.
masih mencari apa yg salah ini

 

[mas.satriyo]

mysql gagal start gara2 ganti ip address.

ganti ip address mah harusnya aman2 aja deh ke database
pasti ada sebab lainnya

hasil journalctl -xe

coba cek log mysqld/mysql di /var/log/

2022-03-22 10:06:58 0 [Warning] Could not increase number of max_open_files to more than 40000 (request: 160185)

cek config untuk batasan max_open di file-file ini

/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
/etc/systemd/system/mysqld.service.d/limits.conf
/usr/lib/systemd/system/mariadb.service
/usr/lib/systemd/system/mariadb.service
/etc/systemd/system/mysql.service
/etc/systemd/system/mysqld.service

atau ada juga yg settingnya disimpan di sini
/etc/systemd/system/mysql.service.d/override.conf

cari nilai untuk LimitNOFILE dan LimitMEMLOCK

 

[dhyhost]

coba naikkin limit max_open_files nya aja
dari errornya itu limit open files 40.000, sedangkan requestnya ada 160.000, coba naikkin limitnya di atas 160.000

 

[yogisparingga]

ganti ip address mah harusnya aman2 aja deh ke database
pasti ada sebab lainnya


coba cek log mysqld/mysql di /var/log/


cek config untuk batasan max_open di file-file ini

/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
/etc/systemd/system/mysqld.service.d/limits.conf
/usr/lib/systemd/system/mariadb.service
/usr/lib/systemd/system/mariadb.service
/etc/systemd/system/mysql.service
/etc/systemd/system/mysqld.service

atau ada juga yg settingnya disimpan di sini
/etc/systemd/system/mysql.service.d/override.conf

cari nilai untuk LimitNOFILE dan LimitMEMLOCK

terima kasih pak atas bantuanya, sudah solved

menaikan limit yang di atas
mengubah pengaturan di etc/my.cnf
merename iblogfile0 dan 1
dan membuat direktori baru
mkdir /var/run/mysqld
chown -R mysql:mysql /var/run/mysqld

yang di lakukan yaitu

coba naikkin limit max_open_files nya aja
dari errornya itu limit open files 40.000, sedangkan requestnya ada 160.000, coba naikkin limitnya di atas 160.000

siap pak sudah solved