[ejabberd] Error when moving a user to another group

Yann Leboulanger asterix at lagaule.org
Wed Jan 27 00:25:23 MSK 2010


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},
** 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!

More information about the ejabberd mailing list