Foren
Lock wait timeout exceeded; try restarting transaction
AA CC, geändert vor 12 Jahren.
Lock wait timeout exceeded; try restarting transaction
Junior Member Beiträge: 38 Beitrittsdatum: 31.05.11 Neueste Beiträge
Hi,
i create a create account hook.
Into method onAfertCreate, i inserte this code above
The instruction ArgUserLocalServiceUtil.addArgUser(argouser); throw Lock wait timeout exceeded; try restarting transaction .
Why ?
in onAfertCreate the transaction for insert liferay user is still open ?
I'm using MySql
What i had to do ?
Is very urgent please help me.
i create a create account hook.
Into method onAfertCreate, i inserte this code above
ArgUser argouser;
User user = ((User)model);
argouser = ArgUserLocalServiceUtil.createArgUser((int)CounterLocalServiceUtil.increment(ArgUser.class.getName()));
argouser.setLruserId(user.getUserId());
ArgUserLocalServiceUtil.addArgUser(argouser);
The instruction ArgUserLocalServiceUtil.addArgUser(argouser); throw Lock wait timeout exceeded; try restarting transaction .
Why ?
in onAfertCreate the transaction for insert liferay user is still open ?
I'm using MySql
What i had to do ?
Is very urgent please help me.
Mika Koivisto, geändert vor 12 Jahren.
RE: Lock wait timeout exceeded; try restarting transaction
Liferay Legend Beiträge: 1519 Beitrittsdatum: 07.08.06 Neueste Beiträge
You should use a ServiceWrapper instead of ModelListener. When the model listener is invoked the transaction is still open. The transaction is committed after the addUser() service call returns (without throwing an exception).
AA CC, geändert vor 12 Jahren.
RE: Lock wait timeout exceeded; try restarting transaction
Junior Member Beiträge: 38 Beitrittsdatum: 31.05.11 Neueste Beiträge
The i had to create a service with a new servicebuilter that remaps UserTable?
Mika Koivisto, geändert vor 12 Jahren.
RE: Lock wait timeout exceeded; try restarting transaction
Liferay Legend Beiträge: 1519 Beitrittsdatum: 07.08.06 Neueste Beiträge
Just create a hook plugin that defines a service hook in liferay-hook.xml and extends UserLocalServiceWrapper class and overrides addUser() method.