[ejabberd] logged errors for sql and unknown

Mark Keisler grimm26 at gmail.com
Fri Feb 4 17:58:29 MSK 2011


I'm running ejabberd 2.1.1 with erlang R13B02 and postgresql 8.2.7.  I'm
seeing these errors in the log:

=ERROR REPORT==== 2011-01-26 03:18:49 ===
E(<0.260.0>:ejabberd_odbc:317) : SQL transaction restarts exceeded
** Restarts: 10
** Last abort reason: [{severity,'ERROR'},
                       {code,"23505"},
                       {message,"duplicate key violates unique constraint
\"rostergroups_pkey\""},
                       {file,"nbtinsert.c"},
                       {line,277},
                       {routine,"_bt_check_unique"}]
** Stacktrace: [{ejabberd_odbc,sql_query_t,1},
                {lists,foreach,2},
                {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.261.0>,pgsql}

and

=ERROR REPORT==== 2011-02-04 09:16:05 ===
** State machine <0.10731.42> terminating
** Last event in was {xmlstreamelement,
                         {xmlelement,"auth",
                             [{"xmlns","urn:ietf:params:xml:ns:xmpp-sasl"},
                              {"mechanism","PLAIN"}],
                             [{xmlcdata,

<<"bmpkODc2QGphYmJlci5zb3VyY2Vmb3JnZS5tb3QuY29tAG5qZDg3NgAzbVBvdzNyZWQ=">>}]}}
** When State == wait_for_feature_request
**      Data  == {state,
                     {socket_state,tls,
                         {tlssock,#Port<0.788275>,#Port<0.788277>},
                         <0.10730.42>},

ejabberd_socket,#Ref<0.0.181.160951>,false,"1703264358",
                     {sasl_state,"jabber","jabber.mydomain.com",[],
                         #Fun<ejabberd_c2s.1.70264870>,
                         #Fun<ejabberd_c2s.2.94090657>,
                         #Fun<ejabberd_c2s.3.82359008>,undefined,undefined},
                     c2s,c2s_shaper,false,true,false,true,
                     [verify_none,{certfile,"/etc/jabber/ssl.pem"}],
                     false,undefined,[],"jabber.mydomain.com",[],
                     undefined,
                     {0,nil},
                     {0,nil},
                     {0,nil},
                     {0,nil},
                     undefined,undefined,undefined,false,
                     {userlist,none,[],false},
                     unknown,unknown,
                     {{10,22,80,101},1340},
                     "en"}
** Reason for termination =
** {noproc,{gen_server,call,[<0.10730.42>,reset_stream]}}


I'm not sure why either of these are happening.  I don't even know what the
second one means, really.  Any ideas?

-- 
Mark
Tact is the ability to tell a man he has an open mind when he has a hole in
his head.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20110204/94514b7d/attachment.html>


More information about the ejabberd mailing list