Instalei o MySQL 5.7 no meu CentOS e tentei iniciar o serviço mas deu 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
Responder1
O log do MySQL está informando o problema com bastante clareza.
Instalei o MySQL 5.7 no meu CentOS […]
2016-05-19T06:49:42.923623Z 0 [ERRO] Erro fatal: a tabela mysql.user está danificada. Por favor execute mysql_upgrade. 19-05-2016T06:49:42.923679Z 0 [ERRO] Abortando
Você não instalou o MySQL. Vocêatualizou um existenteInstalação do MySQL, sem atualizar os esquemas do banco de dados para o que a versão 5.7 espera.
E como essas pessoas…
… você descobrirá que o MySQL não gostará de seus bancos de dados e se recusará a iniciá-los até que você os atualize para o novo esquema.
Vitalijus Ryzakovas dizbasta reinstalar todo o banco de dados com o utilitário de instalação, perdendo todos os dados anteriores.
Reindl Harald dizsercuidado com os repositórios CentOS. Xe ecoa o conselho da própria Oracle deatualizar apenas um nível de versão por vez.
A pessoa de cujo repositório M. Harald estava falando,Remi Collet, dizpara fazer o downgrade para a versão antiga do MySQL mais uma vez, despeje todo o conjunto de dados em arquivo, atualize mais uma vez e restaure a partir do dump.
A Oracle descreve os métodos de atualização e de restauração de despejo no documento, sendo o primeiro umatualização no locale sendo este último umatualização lógica.
Leitura adicional
- Atualizando 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.
Responder2
não há espaço deixado no dispositivo
também pode significar que a partição está sem 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 comprimento zero em algum lugar que você não conhece. Infelizmente, não conheço uma maneira fácil de encontrar esse tipo de coisa. A execução find / -xdev
imprimiria o nome de cada arquivo e diretório na partição. Você pode encontrar algum diretório suspeito cheio de arquivos vazios.
Eu tentei uma vez quando tinha mais de milhões de inodes usados.
encontrar . -type f -nome sess_* -delete
Atualizar
tente estas etapas:
mysqld_safe –skip-grant-tables –user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysqld restart
Responder3
chown mysql:mysql /var/lib/mysql
chmod 700 /var/lib/mysql
chkconfig --level 345 mysql on
service mysqld start