Thank you @badlop for your

amoghsingh — Wed, 18 Jan 2017 15:07:12 +0000

Thank you @badlop for your really helpful answer. Thanks you once again.

There are two error reports,

badlop — Wed, 18 Jan 2017 09:54:59 +0000

There are two error reports, and looking at their times, they see independent.

The first is when logging in and getting the user roster subscriptions, ejabberd finds some problem processing one them.

The second is that MySQL complains with the error "#22001Data too long for column 'xml' at row 1". It seems ejabberd tries to repeat the query ten times, but of course Mysql always aborts the transactions as they are similarly problematic. From what I see, there are columns called 'xml' in the Mysql table 'spool' used by mod_offline and the table 'archive' used by mod_mam.

It seems some user is sending such a big stanza to other user, that it is bigger than what the Mysql table is designed.

ejabberd - Comments for "450 SQL transaction restarts exceeded ** Restarts: 10"

Thank you @badlop for your

There are two error reports,