Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.7k views
in Technique[技术] by (71.8m points)

Mysql:SQL 错误 [08S01]: Communications link failure

1.使用软件DBeaver,连接MySQL
2.表建立在本地数据库中,数据库大小如下
image.png
1月20号,在对里面的数据进行清洗以后,1月22晚上对表进行操作,就会出现下面的错误
image.png

Communications link failure### 问题描述


### 问题出现的环境背景及自己尝试过哪些方法


### 相关代码
粘贴代码文本(请勿用截图)


### 你期待的结果是什么?实际看到的错误信息又是什么?

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

3.查看日志错误:mysqld.local.err

(base) ola@macbook-pro-2 ~ % sudo tail /usr/local/mysql/data/mysqld.local.err

Password:
information that should help you find out what is causing the crash.
2021-01-22T15:12:07.972542Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.20) starting as process 969
2021-01-22T15:12:07.977003Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
2021-01-22T15:12:07.994423Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-01-22T15:12:08.234782Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-01-22T15:12:08.327254Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
2021-01-22T15:12:08.338089Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2021-01-22T15:12:08.347697Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2021-01-22T15:12:08.417527Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-01-22T15:12:08.434938Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.20'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server - GPL.

请问是哪里出了问题呀,求大神解答,笔芯!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...