现象
所有数据无法写入, 写入被锁定, 报错"LOCK_WRITE_GROWTH "
### Cause: java.sql.SQLException: The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement
; uncategorized SQLException; SQL state [HY000]; error code [1290]; The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement; nested exception is java.sql.SQLException: The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement
原因
应该是阿里云的一个保护策略,空间剩余不足时,禁止数据写入,保障可读状态。
查数据,删表没问题,更新和插入不行。
解决方案
- 升级数据库空间.
- 删除一些没有用的数据.
- 用 flush privileges.