Junior2kan
(usa Debian)
Enviado em 11/06/2018 - 17:25h
Sou iniciante em Mysql, o que acontece, eu peguei um VM hyper-v, e copiei o seu hd e joguei em outra VM. Agora o mysql não inicia, vou deixar o texto do log logo abaixo. Estou utilizando o Centos para esse trabalho.
LOG MYSQL
-----------------------------------------------------
/usr/sbin/mysqld[0x95d2cb]
/usr/sbin/mysqld[0x95ef2f]
/usr/sbin/mysqld[0xa3d6bf]
/usr/sbin/mysqld[0xa86240]
/usr/sbin/mysqld[0x9daa88]
/lib64/libpthread.so.0(+0x7e25)[0x7f56dd1c4e25]
/lib64/libc.so.6(clone+0x6d)[0x7f56dbe86bad]
The manual page at
http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
180611 15:54:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
180611 16:14:28 mysqld_safe Logging to '/var/log/mysqld.log'.
180611 16:14:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
2018-06-11 16:14:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca ted. Please use --explicit_defaults_for_timestamp server option (see documentati on for more details).
2018-06-11 16:14:28 0 [Note] /usr/sbin/mysqld (mysqld 5.6.40) starting as proces s 1566 ...
2018-06-11 16:14:28 1566 [Warning] Buffered warning: Changed limits: max_open_fi les: 1024 (requested 5000)
2018-06-11 16:14:28 1566 [Warning] Buffered warning: Changed limits: table_open_ cache: 431 (requested 2000)
2018-06-11 16:14:28 1566 [Note] Plugin 'FEDERATED' is disabled.
2018-06-11 16:14:28 1566 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-11 16:14:28 1566 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-11 16:14:28 1566 [Note] InnoDB: Mutexes and rw_locks use GCC atomic buil tins
2018-06-11 16:14:28 1566 [Note] InnoDB: Memory barrier is not used
2018-06-11 16:14:28 1566 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-11 16:14:28 1566 [Note] InnoDB: Using Linux native AIO
2018-06-11 16:14:28 1566 [Note] InnoDB: Using CPU crc32 instructions
2018-06-11 16:14:28 1566 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-11 16:14:28 1566 [Note] InnoDB: Completed initialization of buffer pool
2018-06-11 16:14:28 1566 [Note] InnoDB: Highest supported file format is Barracu da.
2018-06-11 16:14:28 1566 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-11 16:14:28 1566 [Note] InnoDB: Waiting for purge to start
2018-06-11 16:14:28 1566 [Note] InnoDB: 5.6.40 started; log sequence number 1625 987
2018-06-11 16:14:28 1566 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0b58def0-6db4-11e8-a8e1-00155d010200.
2018-06-11 16:14:28 1566 [Note] Server hostname (bind-address): '*'; port: 3306
2018-06-11 16:14:28 1566 [Note] IPv6 is available.
2018-06-11 16:14:28 1566 [Note] - '::' resolves to '::';
2018-06-11 16:14:28 1566 [Note] Server socket created on IP: '::'.
2018-06-11 16:14:28 1566 [Note] Event Scheduler: Loaded 0 events
2018-06-11 16:14:28 1566 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.40' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Commun ity Server (GPL)