0 votes
662 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?

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.

If you have a question about Webinoly, please ask in English or Spanish.

To report a bug, please ask a question here with the bug tag.

News: Now you can use any external SMTP service in your server. All the server outgoing emails from any of your websites will be sent through this service.

Donations

Webinoly Support Paypal Donations Webinoly Support Bitcoin Donations

Your regular donations is what keep this project moving forward. If you like Webinoly, buy me a coffee or a beer to show support.

Affiliate Links

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

...