Lock wait timeout exceeded

[happenedIn]

When calling

Enforcer casbinEnforcer = new Enforcer();
casbinEnforcer.addRoleForUser(user, role);

I get lock wait timeout.

Why are there updates following an insert statement in this code?

hibernate-adapter/src/main/java/org/casbin/adapter/HibernateAdapter.java

Line 258 in 484cf88

session.createSQLQuery("UPDATE casbin_rule SET v1 = null WHERE v1 = 'null'").executeUpdate();

[local] 2025-01-03 16:37:05.084 DEBUG [http-nio-8080-exec-4] TransactionImpl    - On TransactionImpl creation, JpaCompliance#isJpaTransactionComplianceEnabled == false
[local] 2025-01-03 16:37:05.084 DEBUG [http-nio-8080-exec-4] TransactionImpl    - begin
[local] 2025-01-03 16:37:05.171 DEBUG [http-nio-8080-exec-4] SQL    - INSERT INTO casbin_rule (id,ptype,v0,v1,v2,v3,v4,v5) VALUES (4, 'g','userA','role_api','null','null','null','null')
[local] 2025-01-03 16:37:11.821 DEBUG [http-nio-8080-exec-4] SQL    - UPDATE casbin_rule SET v1 = null WHERE v1 = 'null'
[local] 2025-01-03 16:38:02.831 WARN [http-nio-8080-exec-4] ErrorPacket    - Error: 1205-HY000: Lock wait timeout exceeded; try restarting transaction
[local] 2025-01-03 16:38:02.835 ERROR [http-nio-8080-exec-4] SqlExceptionHelper    - (conn=40) Lock wait timeout exceeded; try restarting transaction
[local] 2025-01-03 16:39:39.340 DEBUG [http-nio-8080-exec-4] TransactionImpl    - committing

[hsluoyz]

@tangyang9464 @imp2002