Webinoly is just the perfect tool for NGINX experts. Give it a try!
0 votes
2.9k views
by

Hello all,

My vps is don't start mysql, can you help me?

Message when i run command "service mysql status". I'm using ubuntu 18.04
* mariadb.service - MariaDB 10.2.16 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           `-migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Fri 2018-06-29 07:27:37 UTC; 6h left
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1368 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exit
  Process: 1120 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_r
  Process: 1102 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, statu
  Process: 1098 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status
 Main PID: 1368 (code=exited, status=7)
   Status: "MariaDB server is down"
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [Note] InnoDB: Starting shutdown...
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [Note] InnoDB: Removed temporary tab
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [ERROR] Plugin 'InnoDB' init functio
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [ERROR] Plugin 'InnoDB' registration
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [Note] Plugin 'FEEDBACK' is disabled
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [ERROR] /usr/sbin/mysqld: unknown va
Jun 29 07:27:37 xxxx mysqld[1368]: 2018-06-29  7:27:37 140691000334272 [ERROR] Aborting
Jun 29 07:27:37 xxxx systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING
Jun 29 07:27:37 xxxx systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 29 07:27:37 xxxx systemd[1]: Failed to start MariaDB 10.2.16 database server.

1 Answer

0 votes
by Expert

Hi Le,

Please, provide more details.

  • Is it a fresh installation?
  • Since when is it failing?
  • What's the output of sudo webinoly -verify and sudo webinoly -info ?
  • Did you see the mysql log?
by
Hello QROkes,

+++++++++++++++++++++++++++++++++++++++++++

webinoly -verify

 Verifying integrity of the entire Webinoly system...

Integrity test passed!!

+++++++++++++++++++++++++++++++++++++++++++

webinoly -info
 

[SYSTEM]

Operating System: Linux version 4.15.0-22-generic (buildd@lgw01-amd64-013) (gcc version 7.3.0 (Ubuntu 7.3.0-16ubuntu3)) #24-Ubuntu SMP Wed May 16 12:15:17 UTC 2018

Description:    Ubuntu 18.04 LTS

Codename:       bionic

Cores: 1

RAM: 1009044kb

SWAP: 1048572kb

File descriptors: 302713

[Disk Usage]

Filesystem     Type  Size  Used Avail Use% Mounted on

/dev/vda1      ext4   25G   12G   12G  51% /

[NGINX]

nginx version: nginx/1.14.0

Nginx file descriptors: 196763

worker_processes: auto

worker_connections: 8192

worker_rlimit_nofile: 196763

client_max_body_size: 100m

[CACHE]

FastCGI 200: 30d

FastCGI 3xx/4xx: 1m

FastCGI inactive: 7d

FastCGI max-size: 192m

open_file_cache_valid: 3m

open_file_cache max: 65587

open_file_cache inactive: 5m

[PHP]

PHP 7.2.7-1+ubuntu18.04.1+deb.sury.org+1 (cli) (built: Jun 22 2018 08:45:49) ( NTS )

memory_limit:  128M

post_max_size:  100M

upload_max_filesize:  100M

max_file_uploads:  20

max_execution_time:  300

[MYSQL]

mysql  Ver 15.1 Distrib 10.2.16-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

PhpMyAdmin: true

[Raw Conf]

nginx-ppa:stable

pre-packs:true

nginx:true

swap-owner:webinoly

tools-port:22222

nginx-tool:true

mysql-client:true

mysql-root:bjVGYVJUMDMK

mysql-admin:QTN5MzVyVkYK

mysql:true

mail:ledung240509@gmail.com

php-v7.1:purged

php-ver:7.2

php:true

php-v7.2:true

web-tool:true

php-tool:true

mysql-tool:true

wp-admin-auth:purged

app-version:1.5.0

timezone:Asia/Ho_Chi_Minh

php-optim:true

linux-optim:true

server-version:1.1

nginx-optim:true

status-api:in8

++++++++++++++++++++++++++++++++++
Yesterday, i will update webinoly is latest verison and after about 6 hours is mysql error.

I'm using ubuntu 18.04
by Expert
Everything seems normal in Webinoly.

What do you see in the MySQL log?
by
ls /var/log/mysql

mariadb-bin.000018  mariadb-bin.000025  mariadb-bin.000032  mariadb-bin.000039

mariadb-bin.000019  mariadb-bin.000026  mariadb-bin.000033  mariadb-bin.000040

mariadb-bin.000020  mariadb-bin.000027  mariadb-bin.000034  mariadb-bin.000041

mariadb-bin.000021  mariadb-bin.000028  mariadb-bin.000035  mariadb-bin.000042

mariadb-bin.000022  mariadb-bin.000029  mariadb-bin.000036  mariadb-bin.index

mariadb-bin.000023  mariadb-bin.000030  mariadb-bin.000037  mariadb-bin.state

mariadb-bin.000024  mariadb-bin.000031  mariadb-bin.000038

What file will i have to check? If you need vps information for check logs, please tell me :D. I will send info.

Thank you for quick support.
by Expert

You can use: sudo log -mysql to see the logs.

Did you try rebooting your server?

by

Hmm,

I got a message => Log file not found!!! 

Yeah, i have restarted. Do you need my vps info?

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #c33720; background-color: #ffffff} span.s1 {font-variant-ligatures: no-common-ligatures}
by Expert
Sorry, but I'm not really sure what is happening with MySQL in your server. Webinoly is working fine as expected. My best advice is start again with a new and fresh VPS.
by
Poor for me :D. Thank you ^^
by Expert
You're welcome!

And don't worry, these things happens, you should always have a backup/restore plan, that's why we have duply/duplicity pre-installed in Webinoly.
by
Yep, i will try it, but mysql service is not working :D. I will lose some data :(.
Welcome to the Community site for Webinoly.

Our Optimized LEMP Web Server is a powerful set of commands for doing just about anything you could wish.

With Webinoly you can set up your NGINX web server in just one step.

* * * * * * *

To report a bug, please create a new issue on GitHub or ask a question here with the bug tag.
Webinoly Support Paypal Donations

PayPal · GitHub Sponsors · Bitcoin

It is very important that any visitor to the site read the disclaimer, terms of use and privacy and legal statement before start browsing.

...