Bug #92476 Mysql Sql Service doesn't start because consume much CPU time
Submitted: 18 Sep 2018 11:02 Modified: 24 Sep 2018 7:06
Reporter: xxxxxxxxxxx yyyyyyyyyyyyyy Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:8.0.12-1 OS:Fedora (28)
Assigned to: CPU Architecture:Any (x64)

[18 Sep 2018 11:02] xxxxxxxxxxx yyyyyyyyyyyyyy
Description:
Description of problem: 

mysql sql from mysql repo doesnt' start 

Version-Release number of selected component (if applicable): 

mysql-workbench-community-8.0.12-1.fc28.x86_64 
mysql-shell-8.0.12-1.fc28.x86_64 
mysql-community-client-8.0.12-1.fc28.x86_64 
mysql80-community-release-fc28-1.noarch 
mysql-community-libs-8.0.12-1.fc28.x86_64 
mysql-community-common-8.0.12-1.fc28.x86_64 
mysql-community-server-8.0.12-1.fc28.x86_64 
mysql-connector-python3-8.0.12-1.fc28.x86_64 
mysql-connector-python-8.0.12-1.fc28.x86_64 
mysql-connector-java-8.0.12-1.fc28.noarch 

Additional info: 

sudo systemctl start mysqld 

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

sudo systemctl status mysqld 

● mysqld.service - MySQL Server 
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) 
Active: failed (Result: exit-code) since Sat 2018-09-15 16:33:21 CEST; 36s ago 
Docs: man:mysqld(8) 
http://dev.mysql.com/doc/refman/en/using-systemd.html 
Process: 31229 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE) 
Process: 31207 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) 
Main PID: 31229 (code=exited, status=1/FAILURE) 
Status: "SERVER_BOOTING" 
Error: 2 (No such file or directory) 
CPU: 6.472s 

sep 15 16:33:11 localhost-localdomain systemd[1]: Starting MySQL Server... 
sep 15 16:33:21 localhost-localdomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE 
sep 15 16:33:21 localhost-localdomain systemd[1]: mysqld.service: Failed with result 'exit-code'. 
sep 15 16:33:21 localhost-localdomain systemd[1]: Failed to start MySQL Server. 
sep 15 16:33:21 localhost-localdomain systemd[1]: mysqld.service: Consumed 6.472s CPU time 

journalctl -xe 

-- Subject: Resources consumed by unit runtime 
-- Defined-By: systemd 
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel 
-- 
-- The unit mysqld.service completed and consumed the indicated resources. 
sep 15 16:33:21 localhost-localdomain sudo[31199]: pam_unix(sudo:session): session closed for user root 
sep 15 16:33:21 localhost-localdomain audit[31199]: USER_END pid=31199 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_close grantors=pam_keyinit,pam_limit$ 
sep 15 16:33:21 localhost-localdomain audit[31199]: CRED_DISP pid=31199 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_unix acct="root" exe="$ 
sep 15 16:33:37 localhost-localdomain audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=fprintd comm="systemd" exe="/usr/lib/systemd/systemd" hostnam$ 
sep 15 16:33:37 localhost-localdomain systemd[1]: fprintd.service: Consumed 44ms CPU time 
-- Subject: Resources consumed by unit runtime 
-- Defined-By: systemd 
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel 
-- 
-- The unit fprintd.service completed and consumed the indicated resources. 
sep 15 16:33:57 localhost-localdomain audit[31309]: USER_ACCT pid=31309 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:accounting grantors=pam_unix,pam_localus$ 
sep 15 16:33:57 localhost-localdomain sudo[31309]: hhlp : TTY=pts/1 ; PWD=/home/hhlp ; USER=root ; COMMAND=/usr/bin/systemctl status mysqld 
sep 15 16:33:57 localhost-localdomain audit[31309]: USER_CMD pid=31309 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/hhlp" cmd=73797374656D63746C207374617$ 
sep 15 16:33:57 localhost-localdomain audit[31309]: CRED_REFR pid=31309 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_env,pam_fprintd acct="$ 

these original bugs about mysql version 8 reported by me 

https://bugzilla.redhat.com/show_bug.cgi?id=1629380

https://bugzilla.redhat.com/show_bug.cgi?id=1628815 
https://bugzilla.redhat.com/show_bug.cgi?id=1628814 
https://bugzilla.redhat.com/show_bug.cgi?id=1540946 

Regards.,

How to repeat:
How reproducible: 

every single time - always 

Steps to Reproduce: 

1. sudo systemctl start mysqld 
2. sudo systemctl status mysqld 
3. journalctl -xe
[18 Sep 2018 13:49] MySQL Verification Team
Thank you for the bug report. Please describe how you did the install?. Thanks.
[18 Sep 2018 13:53] MySQL Verification Team
Please attach here the error log file too. Thanks.
[18 Sep 2018 14:59] xxxxxxxxxxx yyyyyyyyyyyyyy
I follow the mysql original instalation step from here :

https://dev.mysql.com/doc/mysql-repo-excerpt/8.0/en/linux-installation-yum-repo.html

thx
[18 Sep 2018 15:00] xxxxxxxxxxx yyyyyyyyyyyyyy
Please attach here the error log file too. Thanks.

what log file? can you explain to me what you need?

thx
[18 Sep 2018 16:14] MySQL Verification Team
Install Process and start

Attachment: 92476.txt (text/plain), 10.20 KiB.

[18 Sep 2018 16:18] MySQL Verification Team
Thank you for the feedback. I attached a file with all the install process and server start. The log error I meant is: /var/log/mysqld.log please check it maybe you will be able to find what it was wrong for you.
[19 Sep 2018 7:01] xxxxxxxxxxx yyyyyyyyyyyyyy
this is the log , is a new instalation and i don't have tables in it :

2018-09-19T06:50:58.669769Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.12) starting as process 8290                        
2018-09-19T06:51:00.324137Z 1 [ERROR] [MY-011092] [Server] Upgrading the data dictionary from dictionary version '1' is not supported.       
2018-09-19T06:51:00.324585Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.                                            
2018-09-19T06:51:00.324725Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-09-19T06:51:01.308132Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.12)  MySQL Community Server - GPL.
[24 Sep 2018 7:06] xxxxxxxxxxx yyyyyyyyyyyyyy
It's wasn't a fresh install I install it from 8.0 what i DID, i don't have any table in it

delete /var/lib/mysql

and started sucesfull

thx...