[ejabberd] Error when moving a user to another group

Evgeniy Khramtsov xramtsov at gmail.com
Mon Feb 1 05:41:24 MSK 2010


Yann Leboulanger wrote:
> Yann Leboulanger wrote:
>   
>> Hi,
>>
>> I use ejabberd 2.1.1 with MySQL to store rosters. Since I upgraded to
>> 2.1.1, I have an error when I change the groups of my contacts:
>>
>> =ERROR REPORT==== 2010-01-26 22:20:36 ===
>> E(<0.16553.7>:ejabberd_odbc:317) : SQL transaction restarts exceeded
>> ** Restarts: 10
>> ** Last abort reason: "#23000Duplicate entry 'MY_USERNAME-CONTACT_JID'
>> for key 'i_rosteru_user_jid'"
>> ** Stacktrace: [{ejabberd_odbc,sql_query_t,1},
>>                 {odbc_queries,update_roster,5},
>>                 {mod_roster_odbc,'-process_item_set/3-fun-0-',7},
>>                 {ejabberd_odbc,outer_transaction,3},
>>                 {ejabberd_odbc,handle_call,3},
>>                 {gen_server,handle_msg,5},
>>                 {proc_lib,init_p_do_apply,3}]
>> ** When State == {state,<0.16554.7>,mysql}
>>
>> It happens only in one of my 2 domain hosted on this server.
>>
>> Any idea what could be the reason?
>>
>> Thanks for your help!
>>     
>
> No idea? That's really annoying to not be able to change the group of a
> contact :/
>
>   

Enable logging in MySQL to see what happens. It is hard to say anything 
without SQL logs.

-- 
Regards,
Evgeniy Khramtsov, ProcessOne.
xmpp:xram at jabber.ru.



More information about the ejabberd mailing list