Travamento ao tentar reinstalar banco de dados

1. Travamento ao tentar reinstalar banco de dados

João Victor Oliveira Marques
Johnliveira

(usa Ubuntu)

Enviado em 22/01/2020 - 16:54h

Tive alguns problemas com o MySQL, uma alternativa que eu não tinha testado ainda era reinstalar ele.
Dei um sudo apt remove no mesmo e depois instalei novamente...
Porém ele fica travado nisso:

Configurando mysql-server-8.0 (8.0.18-0ubuntu0.19.10.1) ...
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 3669




  


2. Re: Travamento ao tentar reinstalar banco de dados

Daniel Lara Souza
danniel-lara

(usa Fedora)

Enviado em 23/01/2020 - 10:56h


posta ai o log

/var/log/mysql/error.log


3. Re: Travamento ao tentar reinstalar banco de dados

João Victor Oliveira Marques
Johnliveira

(usa Ubuntu)

Enviado em 23/01/2020 - 20:39h

2020-01-23T20:28:53.434671Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 1283
2020-01-23T23:29:08.827095Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-01-23T23:29:09.302790Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18-0ubuntu0.19.10.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-01-23T23:29:09.590196Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-01-23T23:29:40.667681Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-0ubuntu0.19.10.1) (Ubuntu).
2020-01-23T23:29:42.181163Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 1804
2020-01-23T23:29:44.605077Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-01-23T23:29:44.662305Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-01-23T23:29:44.706992Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18-0ubuntu0.19.10.1' socket: '/tmp/tmp.cIP2j4k6fZ/mysqld.sock' port: 0 (Ubuntu).
2020-01-23T23:29:44.952810Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2020-01-23T23:29:44.952906Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2020-01-23T23:29:46.104576Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-0ubuntu0.19.10.1) (Ubuntu).
2020-01-23T23:29:46.809138Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-0ubuntu0.19.10.1) starting as process 1866
2020-01-23T23:29:49.471174Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-01-23T23:29:49.527991Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-01-23T23:29:49.572546Z 6 [ERROR] [MY-000061] [Server] 1396 Operation ALTER USER failed for 'root'@'localhost'.
2020-01-23T23:29:49.572820Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18-0ubuntu0.19.10.1' socket: '/tmp/tmp.l6IknUQal4/mysqld.sock' port: 3306 (Ubuntu).
2020-01-23T23:29:49.808179Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock'
2020-01-23T23:29:49.808287Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060



4. Re: Travamento ao tentar reinstalar banco de dados

Rodrigo
omag0

(usa Debian)

Enviado em 24/01/2020 - 11:18h

Faz assim. Desinstala esse banco, e instala via docker.
https://hub.docker.com/_/mysql

Mas aqui pode estar uma solução para o seu problema
https://stackoverflow.com/questions/34954455/mysql-daemon-lock-issue






Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner
Linux banner
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts