service mysql restart failing in controller node

asked 2019-02-25 00:20:19 -0500

fadilmohd007@gmail.com gravatar image

updated 2019-02-25 02:46:22 -0500

I'm trying to install openstack queens in ubuntu 16.04 LTS server version by following this document https://docs.openstack.org/install-guide/environment-sql-database-ubuntu.html (Link to document) In the step provided in the link i was trying to restart service mysql but it throws an error.I have created 99-openstack.cnf and contents are as follows

[mysqld]
bind-address = 192.168.16.11

default-storage-engine =innodb
innodb_file_per_table = on
max_connections= 4096
collation-server =utf8_general_ci
charecter-set-server = utf8

error Job for mysql.service failed because control process exited with error code.See "systemctl status mysql.service" and "journalctl -xe" for details

the out put of systemctl status mysql.service and journalctl -xe is posted as image(unfortunately need 10 points for that).

status mysql service says --

mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2019-02-25 11:44:30 IST; 20s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 2903 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE

Feb 25 11:44:30 ubuntu /etc/init.d/mysql[3377]: 0 processes alive and '/usr/bin/
Feb 25 11:44:30 ubuntu /etc/init.d/mysql[3377]: [61B blob data]
Feb 25 11:44:30 ubuntu /etc/init.d/mysql[3377]: error: 'Can't connect to local M
Feb 25 11:44:30 ubuntu /etc/init.d/mysql[3377]: Check that mysqld is running and
Feb 25 11:44:30 ubuntu /etc/init.d/mysql[3377]: 
Feb 25 11:44:30 ubuntu mysql[2903]:    ...fail!
Feb 25 11:44:30 ubuntu systemd[1]: mysql.service: Control process exited, code=e
Feb 25 11:44:30 ubuntu systemd[1]: Failed to start LSB: Start and stop the mysql
Feb 25 11:44:30 ubuntu systemd[1]: mysql.service: Unit entered failed state.
Feb 25 11:44:30 ubuntu systemd[1]: mysql.service: Failed with result 'exit-code'

journalctl shows

Feb 25 12:32:35 ubuntu kernel: blk_update_request: I/O error, dev loop0, sector 0
Feb 25 12:32:35 ubuntu kernel: blk_update_request: I/O error, dev loop0, sector 0
Feb 25 12:32:35 ubuntu kernel: Buffer I/O error on dev loop0, logical block 0, async page read
Feb 25 12:32:35 ubuntu kernel: blk_update_request: I/O error, dev loop0, sector 0

Feb 25 12:32:35 ubuntu kernel: Buffer I/O error on dev loop0, logical block 0, async page read
Feb 25 12:32:35 ubuntu NetworkManager[942]: <info>  [1551078155.6049] Loaded device plugin: NMWwanFactory (/usr/lib/x86_64-lin
Feb 25 12:32:35 ubuntu systemd[1]: Started LXD - container startup/shutdown.
Feb 25 12:32:35 ubuntu snapd[957]: 2019/02/25 12:32:35.834193 daemon.go:343: started snapd/2.34.2ubuntu0.1 (series 16; classic
Feb 25 12:32:35 ubuntu systemd[1]: Started Snappy daemon.
Feb 25 12:32:35 ubuntu systemd[1]: Starting Wait until snapd is fully seeded...
Feb 25 12:32:35 ubuntu NetworkManager[942]: <info>  [1551078155.8979 ...
(more)
edit retag flag offensive close merge delete

Comments

Can you make journalctl output the full messages? I think the option is -l (ell).

From what I see, though, there is a problem with collation. Perhaps you have better messages in /var/log/mysql/errorlog.

Bernd Bausch gravatar imageBernd Bausch ( 2019-02-25 00:34:13 -0500 )edit

sorry Bernd it's long, cant be fitted in comment ,how can i post it ??

fadilmohd007@gmail.com gravatar imagefadilmohd007@gmail.com ( 2019-02-25 02:15:23 -0500 )edit

by editing your question.

Bernd Bausch gravatar imageBernd Bausch ( 2019-02-25 02:25:55 -0500 )edit

Ty Bernd I have edited

fadilmohd007@gmail.com gravatar imagefadilmohd007@gmail.com ( 2019-02-25 02:48:35 -0500 )edit

This is probably the root cause:

COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8m

You have to find out what that means. My guess: A typo in the my.cnf file. I wonder what the "m" in "utf8m" is? Did you create the file on Windows and copy it to Linux?

Bernd Bausch gravatar imageBernd Bausch ( 2019-02-25 05:41:54 -0500 )edit