Web登录失败 Possibly consider using a shortermaxLifetime value Caused by: com.mysql.cj.jdbc.exceptions.

Question

Web登录失败 Possibly consider using a shortermaxLifetime value Caused by: com.mysql.cj.jdbc.exceptions.

Closed this issue 2 months ago · 2 comments

Web登录失败 Possibly consider using a shortermaxLifetime value

Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restart transactionat

Answer 1 · 2024-05-06T02:25:16.000Z

用户反馈，登录页面异常。

建议先重启数据库容器

#除shakespeare-java-exe-python以外的服务
docker-compose -f /opt/shakespeare/docker-compose.yml  stop hg_db
docker-compose -f /opt/shakespeare/docker-compose.yml  start hg_db

Answer 2 · 2024-05-06T06:02:21.000Z

2024-05-06 9:31:16 1583 [Warning] mysqld: Disk is full writing './mysql-bin.002002' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
磁盘空间不足导致mysql crash了