반응형 IT Development/MySql1 [SOLVED]java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction 에러 메세지 java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction Cause The problem usually happens when a query is taking too long (maybe because the server is too busy). 자세한 것은 http://www.percona.com/blog/2012/03/27/innodbs-gap-locks/ 사이트를 참조 #유닉스계열의 경우 /etc/my.conf 등록후 재시작 # 윈도우의 경우 my.ini [mysqld] innodb_lock_wait_timeout = 500 transaction-isolation = READ-COMMITTED 2016. 4. 20. 이전 1 다음 반응형