MAX_TRANSACTION_RESTARTS SQL transaction restarts exceeded

-define(MAX_TRANSACTION_RESTARTS, 10).

此配置在ejabberd ejabberd_odbc.erl中

 

=ERROR REPORT==== 2010-12-04 08:27:52 ===

E(<0.345.0>:ejabberd_odbc:387) : SQL transaction restarts exceeded

** Restarts: 2

** Last abort reason: "query timed out"

** Stacktrace: [{ejabberd_odbc,sql_query_t,1},

                {odbc_queries,'-get_and_del_spool_msg_t/2-fun-0-',1},

                {ejabberd_odbc,outer_transaction,3},

                {ejabberd_odbc,session_established,3},

                {p1_fsm,handle_msg,10},

                {proc_lib,init_p_do_apply,3}]

** When State == {state,<0.347.0>,mysql,30000,"testrsa.igrslabdns.com",

                        1000000000000,

                        {0,{[],[]}}}