Bug日记

LettuceConnectionFactory was destroyed and cannot be used anymore

（可跳过，成功率低）file->Invalidate Caches->Clear VCS log->Incalidate and Restart，然后重启项目

若上述未解决，直接重启电脑再次进入项目后可正常运行。

原因：网上有说法是redis连接方案的问题。

清除缓存后项目一直卡在indexing......

打开C盘 -> 用户 -> 用户名 -> AppData -> Local -> JetBrains -> IntelliJIedaxxxx.x，在这个目录下删除caches和index两个文件夹，然后重启idea。我在这里执行一次没有效果，弄了三次恢复了。

RESP连接失败

虚拟机关闭防火墙：systemctl stop firewalld

No qualifying bean of type ' ' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}

因为使用mp忘记为Service接口添加实现类

idea新建包不分层

点击左侧导航栏顶部与Project同行的设置按钮 -> TreeAppearance -> 取消Compact Middle Packages

OpenJDK 64-Bit Server VM warning: Options -Xverify:none and -noverify were deprecated in JDK 13 and will likely be removed in a future release.

(JDK17)Run -> Edit Configuration -> Modify options -> 勾选Disable launch optimization

com.intellij.util.io.PersistentEnumeratorBase$CorruptedException: PersistentEnumerator storage

(idea2021)C:\Users\当前用户\AppData\Local\JetBrains\IntelliJIdea2021.3\compile-server

打开上述路径，删除出现错误的项目文件夹后再次重启idea。

ps：重启报错，因为idea未构建完成重启，导致文件损失。

Cannot delete or update a parent row: a foreign key constraint fails 

关闭外键约束检查 => SET foreign_key_checks = 0;  
执行删除或更新命令 => detele from table where ;
开启外键约束检查 => SET foreign_key_checks = 1;

ps:数据或表拥有主外键关系

Source must refer to an existing file, got ......

再次点击install即可

Host  192.168.163.1  is not allowed to connect to this MySQL server.

1.mysql -u root -p，进入mysql客户端

2. use mysql; 

3.输入 SELECT Host, User, authentication_string FROM mysql.user;

4.update user set authentication_string=PASSWORD('123456'),plugin='mysql_native_password' where user='root';

连接成功

mysql登录报错ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)，忘记密码

1.输入打开vim /etc/my.cnf文件，在[mysqld]下一行添加：skip-grant-tables（登录时跳过权限检查）

2.重启MySQL服务：sudo systemctl restart mysqld

3.修改密码

输入mysql -u root -p；登录mysql

输入：set password for ‘root’@‘localhost’=password(‘xxxx’);

(出现：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement  输入：flush privileges;  再次输入：set password for ‘root’@‘localhost’=password(‘xxxx’);)

4.exit退出

启动MySQL出现：Redirecting to /bin/systemctl start mysqld.service Failed to start mysqld.service: Unit not found.

http://t.csdnimg.cn/JFIrm

虚拟机MySQL一直出现（注意：这里是循环出现这个问题，如果是第一次只用使用：docker rm 容器ID（那一串数字））：docker: Error response from daemon: Conflict. The container name "/mysql" is already in use by container "946e100d8cbf1825a36619dcc16c2c2b4e7bfd31781cd408ecf0e31e5d52a0dd". You have to remove (or rename) that container to be able to reuse that name.

经过一下午的rm，才查询到原因是MySQL开启了进程守护，就会一直占用，杀不完，根本杀不完，所以只用执行一句语句就好，关闭MySQL进程守护:

service mysqld stop