1.使用软件DBeaver,连接MySQL
2.表建立在本地数据库中,数据库大小如下
1月20号,在对里面的数据进行清洗以后,1月22晚上对表进行操作,就会出现下面的错误
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.
请问是哪里出了问题呀,求大神解答,笔芯!
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…