Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

mysql 5.7 error after using cloudera recommended my.cnf config

Solved Go to solution

mysql 5.7 error after using cloudera recommended my.cnf config

Contributor

Hi there,

 

I have installed Mysql 5.7 as external DB for cloudera setup, however after using the recommeded my.cnf config, the mysql database could not start.

 

https://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_mysql.html

 

The error shown is after starting mysql:

Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

 

● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: start-limit) since Wed 2017-11-22 06:26:28 PST; 19s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 5401 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 5380 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 5035 (code=exited, status=0/SUCCESS)

 

The systemctl status mysqld shows following:
Nov 22 06:26:28 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1
Nov 22 06:26:28 localhost.localdomain systemd[1]: Failed to start MySQL Server.
Nov 22 06:26:28 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
Nov 22 06:26:28 localhost.localdomain systemd[1]: mysqld.service failed.
Nov 22 06:26:28 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling restart.
Nov 22 06:26:28 localhost.localdomain systemd[1]: start request repeated too quickly for mysqld.service
Nov 22 06:26:28 localhost.localdomain systemd[1]: Failed to start MySQL Server.
Nov 22 06:26:28 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
Nov 22 06:26:28 localhost.localdomain systemd[1]: mysqld.service failed.

 

journalctl -xe shows following:

-- Unit mysqld.service has begun starting up.
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.979624Z
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.980614Z
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.981890Z
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.981910Z
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.981943Z
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: 2017-11-22T14:29:17.981993Z
Nov 22 06:29:17 localhost.localdomain systemd[1]: mysqld.service: control proces
Nov 22 06:29:17 localhost.localdomain mysqld[5593]: Initialization of mysqld fai
Nov 22 06:29:17 localhost.localdomain systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Nov 22 06:29:17 localhost.localdomain systemd[1]: Unit mysqld.service entered fa
Nov 22 06:29:17 localhost.localdomain systemd[1]: mysqld.service failed.
Nov 22 06:29:18 localhost.localdomain systemd[1]: mysqld.service holdoff time ov
Nov 22 06:29:18 localhost.localdomain systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.

 

 

Has anyone got the same error?

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Master Collaborator
Do you have this directory created?
Are the permissions correctly set on this path?
5 REPLIES 5
Highlighted

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Super Guru

@ronnie10,

 

Hi,

 

The errors you have presented are all at the systemd level and only tell us that mysql didn't start.  I'd check the mysql log files for clues as to why the start failed so we can get an idea of what the problem is.

 

-Ben

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Contributor
I have checked the log under /var/log/mysqld.log, it was empty.

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Contributor

@bgooley

 

Hi Ben,

 

I have done a few trial and error, the initial my.cnf was ok to start the mysql.

 

Once I change the my.cnf to Cloudera recommended settings, it will crash.

 

I need to comment out from the cnf file then only it will work, will this affect anything?

#log_bin=/var/lib/mysql/mysql_binary_log

 

 

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Master Collaborator
Do you have this directory created?
Are the permissions correctly set on this path?

Re: mysql 5.7 error after using cloudera recommended my.cnf config

Contributor

Thanks for the reply, after I rebooted the OS, the mysql will not start again.