mysql锁等待超时,实际数据库磁盘不足

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2019-03-04 11:17:12.636 [XNIO-2 task-31] ERROR c.g.u.b.impl.UserInfoServiceImpl-[UserServiceInfoImpl.login] [登陆异常]:org.springframework.dao.CannotAcquireLockException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update user   set login_time = ?   where   user_name = ? or phone = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: 
; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: 
2019-03-04 11:17:12.637 [XNIO-2 task-31] ERROR c.g.u.facade.UserServiceFacade-[UserService.login]-[系统异常原因：null]
java.lang.NullPointerException: null
        at com.gjmctp.usercenter.facade.UserServiceFacade.login(UserServiceFacade.java:113)
        at sun.reflect.GeneratedMethodAccessor760.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
2019-03-04 11:17:17.155 [XNIO-2 task-3] DEBUG c.g.u.mapper.UserMapper.findByParams-==>  Preparing: select id, customer_no, name, gender,area_no, phone, cert_no, cert_type,login_num,login_time, user_name, password, mail, forum_id, operator, status, make_date, make_time, modify_date, modify_time, standby,uuid,ed_state,photo_md5,invited from user WHERE phone = ? and ed_state = ? 
2019-03-04 11:17:17.155 [XNIO-2 task-3] DEBUG c.g.u.mapper.UserMapper.findByParams-==> Parameters: 13918910424(String), E(String)
2019-03-04 11:17:17.156 [XNIO-2 task-3] DEBUG c.g.u.mapper.UserMapper.findByParams-<==      Total: 1

1
2
3
4
5
6
7
8
9
10
select * from information_schema.innodb_trx;

select * from information_schema.INNODB_LOCKS;

select * from information_schema.INNODB_LOCK_WAITS;


select trx_mysql_thread_id from information_schema.innodb_trx it 
JOIN information_schema.INNODB_LOCK_WAITS ilw 
on ilw.blocking_trx_id = it.trx_id;