O MySQL Daemon falhou ao iniciar no centos

Question

Instalei o MySQL 5.7 no meu CentOS e tentei iniciar o serviço, mas isso gera esse erro.

MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

mysqld.log contém

2016-05-19T06:49:42.595371Z mysqld_safe Starting mysqld daemon with databases fr                                             om /var/lib/mysql
2016-05-19T06:49:42.726232Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is                                              deprecated. Please use --explicit_defaults_for_timestamp server option (see doc                                             umentation for more details).
2016-05-19T06:49:42.726437Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12) starting a                                             s process 6511 ...
2016-05-19T06:49:42.729712Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-05-19T06:49:42.729734Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic                                              builtins
2016-05-19T06:49:42.729740Z 0 [Note] InnoDB: Uses event mutexes
2016-05-19T06:49:42.729746Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is                                              used for memory barrier
2016-05-19T06:49:42.729752Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-19T06:49:42.729759Z 0 [Note] InnoDB: Using Linux native AIO
2016-05-19T06:49:42.729980Z 0 [Note] InnoDB: Number of pools: 1
2016-05-19T06:49:42.730080Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-05-19T06:49:42.736659Z 0 [Note] InnoDB: Initializing buffer pool, total siz                                             e = 128M, instances = 1, chunk size = 128M
2016-05-19T06:49:42.744976Z 0 [Note] InnoDB: Completed initialization of buffer                                              pool
2016-05-19T06:49:42.746579Z 0 [Note] InnoDB: If the mysqld execution user is aut                                             horized, page cleaner thread priority can be changed. See the man page of setpri                                             ority().
2016-05-19T06:49:42.758283Z 0 [Note] InnoDB: Highest supported file format is Ba                                             rracuda.
2016-05-19T06:49:42.773498Z 0 [Note] InnoDB: Creating shared tablespace for temp                                             orary tables
2016-05-19T06:49:42.773597Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12                                              MB. Physically writing the file full; Please wait ...
2016-05-19T06:49:42.868794Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-05-19T06:49:42.869616Z 0 [Note] InnoDB: 96 redo rollback segment(s) found.                                              96 redo rollback segment(s) are active.
2016-05-19T06:49:42.869630Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are                                              active.
2016-05-19T06:49:42.870091Z 0 [Note] InnoDB: Waiting for purge to start
2016-05-19T06:49:42.920263Z 0 [Note] InnoDB: 5.7.12 started; log sequence number                                              47501023
2016-05-19T06:49:42.920461Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-05-19T06:49:42.920730Z 0 [Warning] System table 'plugin' is expected to be                                              transactional.
2016-05-19T06:49:42.921136Z 0 [Warning] Gtid table is not ready to be used. Tabl                                             e 'mysql.gtid_executed' cannot be opened.
2016-05-19T06:49:42.921212Z 0 [Warning] Failed to set up SSL because of the foll                                             owing SSL library error: SSL context is not usable without certificate and priva                                             te key
2016-05-19T06:49:42.921371Z 0 [Note] Server hostname (bind-address): '*'; port:                                              3306
2016-05-19T06:49:42.921426Z 0 [Note] IPv6 is available.
2016-05-19T06:49:42.921438Z 0 [Note]   - '::' resolves to '::';
2016-05-19T06:49:42.921446Z 0 [Note] Server socket created on IP: '::'.
2016-05-19T06:49:42.921635Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/li                                             b/mysql/ib_buffer_pool
2016-05-19T06:49:42.921792Z 0 [Note] InnoDB: Buffer pool(s) load completed at 16                                             0519 12:19:42
2016-05-19T06:49:42.923348Z 0 [Warning] Failed to open optimizer cost constant t                                             ables

2016-05-19T06:49:42.923623Z 0 [ERROR] Fatal error: mysql.user table is damaged.                                              Please run mysql_upgrade.
2016-05-19T06:49:42.923679Z 0 [ERROR] Aborting

2016-05-19T06:49:42.923691Z 0 [Note] Binlog end
2016-05-19T06:49:42.923731Z 0 [Note] Shutting down plugin 'ngram'
2016-05-19T06:49:42.923741Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-19T06:49:42.923746Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-05-19T06:49:42.923750Z 0 [Note] Shutting down plugin 'partition'
2016-05-19T06:49:42.923754Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-19T06:49:42.923815Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-05-19T06:49:42.923822Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-19T06:49:42.923826Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACE                                             S'
2016-05-19T06:49:42.923829Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_CO                                             LS'
2016-05-19T06:49:42.923833Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-19T06:49:42.923841Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-19T06:49:42.923844Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-19T06:49:42.923848Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-19T06:49:42.923851Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS                                             '
2016-05-19T06:49:42.923855Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-19T06:49:42.923858Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE                                             '
2016-05-19T06:49:42.923862Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE                                             '
2016-05-19T06:49:42.923865Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-19T06:49:42.923870Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELET                                             ED'
2016-05-19T06:49:42.923873Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-19T06:49:42.923877Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STO                                             PWORD'
2016-05-19T06:49:42.923880Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-19T06:49:42.923883Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INF                                             O'
2016-05-19T06:49:42.923887Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_ST                                             ATS'
2016-05-19T06:49:42.923890Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LR                                             U'
2016-05-19T06:49:42.923893Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-19T06:49:42.923897Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_                                             RESET'
2016-05-19T06:49:42.923900Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-19T06:49:42.923903Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-19T06:49:42.923907Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-19T06:49:42.923910Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-19T06:49:42.923913Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-19T06:49:42.923917Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-19T06:49:42.923920Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-19T06:49:42.923923Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-19T06:49:42.923927Z 0 [Note] Shutting down plugin 'InnoDB'
2016-05-19T06:49:42.923971Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-05-19T06:49:42.924055Z 0 [Note] InnoDB: Starting shutdown...
2016-05-19T06:49:43.024521Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/                                             mysql/ib_buffer_pool
2016-05-19T06:49:43.024711Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 16                                             0519 12:19:43
2016-05-19T06:49:44.541254Z 0 [Note] InnoDB: Shutdown completed; log sequence nu                                             mber 47501042
2016-05-19T06:49:44.542642Z 0 [Note] InnoDB: Removed temporary tablespace data f                                             ile: "ibtmp1"
2016-05-19T06:49:44.542655Z 0 [Note] Shutting down plugin 'CSV'
2016-05-19T06:49:44.542666Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-19T06:49:44.542671Z 0 [Note] Shutting down plugin 'MyISAM'
2016-05-19T06:49:44.542687Z 0 [Note] Shutting down plugin 'MEMORY'
2016-05-19T06:49:44.542697Z 0 [Note] Shutting down plugin 'sha256_password'
2016-05-19T06:49:44.542702Z 0 [Note] Shutting down plugin 'mysql_native_password                                             '
2016-05-19T06:49:44.542816Z 0 [Note] Shutting down plugin 'binlog'
2016-05-19T06:49:44.542996Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2016-05-19T06:49:44.549488Z mysqld_safe mysqld from pid file /var/run/mysqld/mys                                             qld.pid ended

df -hT dá:

Filesystem                    Type   Size  Used Avail Use% Mounted on
/dev/mapper/vg_livecd-lv_root ext4   6.7G  5.4G  1.2G  83% /
tmpfs                         tmpfs  435M   68K  435M   1% /dev/shm
/dev/sda1                     ext4   485M   40M  420M   9% /boot

    

Answer 1

O log do MySQL está lhe contando o problema, claramente.

I installed MySQL 5.7 in my CentOS […]

2016-05-19T06:49:42.923623Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
2016-05-19T06:49:42.923679Z 0 [ERROR] Aborting

Você não instalou o MySQL. Você atualizou uma instalação existente do MySQL, sem atualizar os esquemas do banco de dados para o que a versão 5.7 espera.

E como essas pessoas ...

• link
• link

... você descobre que o MySQL não vai gostar de seus bancos de dados e se recusará a começar com eles até que você os atualize para o novo esquema.

Vitalijus Ryzakovas diz para apenas reinstalar o banco de dados inteiro com o utilitário de instalação, perdendo todos os dados anteriores.

Reindl Harald diz que deve ser cuidadoso com os repositórios do CentOS . Xe ecoa o próprio conselho da Oracle para atualizar apenas um nível de lançamento de cada vez .

A pessoa cujo repositório M. Harald estava falando, Remi Collet, diz para fazer o downgrade para o versão antiga do MySQL mais uma vez, despejar todo o banco de dados definido para arquivo, atualizar mais uma vez e restaurar a partir do despejo.

O Oracle descreve os métodos de upgrade e dump-restore no doco, sendo o anterior um upgrade no local e o último sendo um upgrade lógico .

Leitura adicional

• Atualizando o MySQL . Manual de Referência do MySQL. 5.7. Corporação Oracle.
• mysql_upgrade . Manual de Referência do MySQL. 5.7. Corporação Oracle.
• mysqldump . Manual de Referência do MySQL. 5.7. Corporação Oracle.

Answer 2

no space left on the device

também pode significar que a partição está fora de inodes. Use df -i para verificar o uso do inode.

É incomum ficar sem inodes, então é possível que você tenha algum diretório cheio de arquivos pequenos ou de tamanho zero em algum lugar que você não conhece. Infelizmente, não conheço uma maneira fácil de encontrar esse tipo de coisa. Executar find / -xdev imprimiria o nome de todos os arquivos e diretórios na partição. Você pode conseguir localizar um diretório suspeito cheio de arquivos vazios.

Eu tentei uma vez quando eu tinha mais de milhões de inodes usados.

find . -type f -name sess_* -delete

Atualizar

experimente estes passos:

mysqld_safe –skip-grant-tables –user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysqld restart

    

Answer 3

chown mysql:mysql /var/lib/mysql
chmod 700 /var/lib/mysql
chkconfig --level 345 mysql on
service mysqld start