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

Yiorgis Gozadinos ggozad at crypho.com
Mon Oct 6 12:08:19 MSK 2014


Hey,

I am trying to finally move a 2.1.13 installation to the 14.07 release.
My trouble starts with pubsub and odbc using Postgres. Aside from that I
can authenticate properly, and see that users created are stored in the db
as well.

When trying to query or create nodes (anything pubsub really) I get the
following on my logs.

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}]}]}}

I also tried to compile https://github.com/processone/pgsql and copied the
.beam files over to /lib/ejabberd/ebin but it does not seem to make any
difference.

I would really appreciate any help as this is the last thing stopping me
from migrating.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20141006/b7dc6beb/attachment.html>


More information about the ejabberd mailing list