[ejabberd] Migration from 2.* to 14.* trouble with pgsql

Christophe Romain cromain at process-one.net
Mon Oct 6 12:36:33 MSK 2014


Hello

-- Yiorgis Gozadinos [2014-10-06 10:08:19 +0200]:

>10:03:23.303 [error] transaction return internal error:
>{aborted,{undef,[{node_flat_odbc_odbc,options,[],[]},{nodetree_tree_odbc,raw_to_node,2,[{file,"src/nodetree_tree_odbc.erl"},{line,357}]},{mod_pubsub_odbc,tree_call,3,[{file,"src/mod_pubsub_odbc.erl"},{line,4778}]},{mod_pubsub_odbc,'-transaction/4-fun-0-',3,[{file,"src/mod_pubsub_odbc.erl"},{line,4821}]},{ejabberd_odbc,execute_bloc,1,[{file,"src/ejabberd_odbc.erl"},{line,435}]},{ejabberd_odbc,run_sql_cmd,4,[{file,"src/ejabberd_odbc.erl"},{line,351}]},{p1_fsm,handle_msg,10,[{file,"src/p1_fsm.erl"},{line,581}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,239}]}]}}


this is due to improvements in the way pubsub handles plugin.
you should manually alter pubsub_node table, buy quering the type, and replace
all "flat_odbc" to "flat", "pep_odbc" to "pep", and so for every kind of
*_odbc plugin you may have used in 2.1.x. then start ejabberd.


More information about the ejabberd mailing list