2017-11-23 11:58:52.306 [error] <0.24525.0>@mod_pubsub:transaction_retry:3601 transaction return internal error: {aborted,"#42S22Unknown column 'plugin' in 'field list'"}
2017-11-23 11:58:52.312 [error] <0.24525.0>@ejabberd_hooks:safe_apply:383 Hook c2s_terminated crashed when running mod_pubsub:on_user_offline/2:
** Reason = {error,{badmatch,{error,{stanza_error,wait,500,<<>>,'internal-server-error',[{text,<<"en">>,<<"Database failure">>}],[]}}},[{mod_pubsub,'-purge_offline/1-fun-0-',[{file,"src/mod_pubsub.erl"},{line,3763}],4},{lists,foldl,[{file,"lists.erl"},{line,1263}],3},{mod_pubsub,purge_offline,[{file,"src/mod_pubsub.erl"},{line,3752}],1},{mod_pubsub,on_user_offline,[{file,"src/mod_pubsub.erl"},{line,589}],2},{ejabberd_hooks,safe_apply,[{file,"src/ejabberd_hooks.erl"},{line,380}],4},{ejabberd_hooks,run_fold1,[{file,"src/ejabberd_hooks.erl"},{line,364}],4},{xmpp_stream_in,terminate,[{file,"src/xmpp_stream_in.erl"},{line,383}],2},{xmpp_stream_in,stop,[{file,"src/xmpp_stream_in.erl"},{line,138}],1}]}
** Arguments = [#{stop_reason => {stream,reset},tls_options => [compression_none,{protocol_options,<<"no_sslv3|cipher_server_preference|no_compression">>},{ciphers,<<"ECDH:DH:!3DES:!aNULL:!NULL:!MEDIUM@STRENGTH">>},{dhfile,<<"/home/xmpp/server/etc/ejabberd/dhparams.pem">>},{certfile,<<"/home/xmpp/server/etc/ejabberd/ejabberd.pem">>}],sockmod => ejabberd_socket,zlib => true,mgmt_timeout => 300,mgmt_stanzas_out => 0,mod => ejabberd_c2s,stream_state => disconnected,ip => {{0,0,0,0,0,65535,49320,257},45388},sid => {{1511,434730,20319},<0.24525.0>},pres_last => {presence,<<>>,available,<<"en">>,{jid,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<"760407732687161753731698">>,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<"760407732687161753731698">>},{jid,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<>>,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<>>},undefined,[],undefined,[{vcard_xupdate,{<<>>,<<>>},<<>>}],#{ip => {0,0,0,0,0,65535,49320,257}}},csi_queue => {0,#{}},stream_header_sent => true,mgmt_max_timeout => 300,stream_restarted => true,shaper => c2s_shaper,pres_timestamp => {1511,434731,92889},stream_authenticated => true,mgmt_ack_timeout => 60000,lserver => <<"emevth.no-ip.biz">>,auth_module => ejabberd_auth_sql,stream_timeout => infinity,csi_state => active,caps_resources => {3,{{<<"thorsten">>,<<"emevth.no-ip.biz">>,<<"tablet">>},{caps,<<"http://conversations.im">>,<<"w8y3u6600pkkcIZfZL5FMx1NqKY=">>,<<"sha-1">>,[]},{{<<"thorsten">>,<<"emevth.no-ip.biz">>,<<"pix-art messenger">>},{caps,<<"http://conversations.im">>,<<"eS7uil8j+XMa/qMo7/ihL0DcZmg=">>,<<"sha-1">>,[]},{{<<"thorsten">>,<<"emevth.no-ip.biz">>,<<"Vacuum-IM">>},{caps,<<"http://vacuum-im.googlecode.com">>,<<"nvOfScxvX/KRll5e2pqmMEBIls0=">>,<<"sha-1">>,[]},nil,nil},nil},nil}},pres_a => {0,nil},lang => <<"en">>,conn => c2s_tls,server => <<"emevth.no-ip.biz">>,stream_compressed => false,tls_verify => false,mgmt_queue_type => ram,stream_encrypted => true,stream_version => {1,0},mgmt_max_queue => 2500,mgmt_stanzas_in => 0,socket_monitor => #Ref<0.0.262145.48480>,stream_direction => in,user => <<"home-assistant">>,stream_id => <<"16810222477614555137">>,tls_enabled => true,access => c2s,xmlns => <<"jabber:client">>,owner => <0.24525.0>,jid => {jid,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<"760407732687161753731698">>,<<"home-assistant">>,<<"emevth.no-ip.biz">>,<<"760407732687161753731698">>},tls_required => false,mgmt_resend => if_offline,socket => {socket_state,fast_tls,{tlssock,#Port<0.37728>,<<>>},<0.24524.0>},resource => <<"760407732687161753731698">>,mgmt_state => inactive,mgmt_stanzas_req => 0},normal]