=== Test case: mam_SUITE:pm_failed_to_decode_message_in_database/1 (click for source code)
=== Config value:
[{basic_group,impl_specific},
{configuration,rdbms_easy},
{mam_meta_opts,#{cache =>
#{module => internal,strategy => fifo,
number_of_segments => 3,time_to_live => 480},
backend => rdbms,
pm =>
#{archive_groupchats => false,
same_mam_id_for_peers => false},
is_archivable_message => mod_mam_utils,
max_result_limit => 50,default_result_limit => 50,
enforce_simple_queries => false,
send_message => mod_mam_utils,
archive_chat_markers => false,full_text_search => true,
message_retraction => true,db_jid_format => mam_jid_rfc,
db_message_format => mam_message_xml,
async_writer =>
#{enabled => false,batch_size => 30,pool_size => 16,
flush_interval => 2000},
no_stanzaid_element => false,user_prefs_store => rdbms,
cache_users => false}},
{watchdog,<0.45190.0>},
{mod_offline_loaded,false},
{escalus_user_db,{module,escalus_ejabberd}},
{preset,"odbc_mssql_mnesia"},
{mim_data_dir,"/home/circleci/project/big_tests/tests/mam_SUITE_data"},
{tc_logfile,"/home/circleci/project/big_tests/ct_report/ct_run.test@46a395f8a8b0.2024-04-10_14.24.25/big_tests.tests.mam_SUITE.logs/run.2024-04-10_14.33.01/mam_suite.pm_failed_to_decode_message_in_database.30853.html"},
{tc_group_properties,[{name,rdbms_easy_impl_specific}]},
{tc_group_path,[]},
{data_dir,"/home/circleci/project/big_tests/_build/default/lib/mongoose_tests/ebin/mam_SUITE_data/"},
{priv_dir,"/home/circleci/project/big_tests/ct_report/ct_run.test@46a395f8a8b0.2024-04-10_14.24.25/big_tests.tests.mam_SUITE.logs/run.2024-04-10_14.33.01/log_private/"},
{config_backup,#{[shaper,fast] => {ok,#{max_rate => 50000}},
[shaper,mam_shaper] => {ok,#{max_rate => 1}},
[shaper,normal] => {ok,#{max_rate => 1000}},
[{access,<<"test type">>},max_user_sessions] =>
{ok,[#{value => 10,acl => all}]}}},
{{saved_modules,mongooseim@localhost,<<"test type">>},
#{mod_vcard =>
#{matches => 30,
host => {prefix,<<"vjud.">>},
search => true,backend => rdbms,iqdisc => parallel},
mod_roster =>
#{backend => rdbms,iqdisc => one_queue,versioning => false,
store_current_id => false},
mod_muc =>
#{access => muc,
host => {prefix,<<"groupchats.">>},
max_users => 200,room_shaper => none,http_auth_pool => none,
hibernate_timeout => 2000,backend => rdbms,history_size => 20,
hibernated_room_check_interval => 1000,
hibernated_room_timeout => 2000,access_create => muc_create,
access_admin => none,access_persistent => all,
default_room =>
#{public => true,description => <<>>,persistent => false,
title => <<>>,password => <<>>,subject => <<>>,
allow_change_subj => true,allow_query_users => true,
allow_private_messages => true,
allow_visitor_status => true,
allow_visitor_nickchange => true,public_list => true,
moderated => true,members_by_default => true,
members_only => false,allow_user_invites => false,
allow_multiple_sessions => false,
password_protected => false,anonymous => true,
max_users => 200,maygetmemberlist => [],logging => false,
affiliations => [],subject_author => <<>>},
load_permanent_rooms_at_startup => false,
max_room_id => infinity,online_backend => mnesia,
min_presence_interval => 0,max_users_admin_threshold => 5,
user_message_shaper => none,user_presence_shaper => none,
min_message_interval => 0,max_user_conferences => 10,
max_room_name => infinity,max_room_desc => infinity},
mod_register =>
#{access => register,iqdisc => one_queue,
registration_watchers => [],password_strength => 0,
ip_access => [{allow,"127.0.0.0/8"},{deny,"0.0.0.0/0"}]},
mod_sic => #{iqdisc => one_queue},
mod_amp => #{},mod_presence => #{},
mod_disco =>
#{iqdisc => one_queue,server_info => [],extra_domains => [],
users_can_see_hidden_services => false},
mod_muc_log =>
#{dirname => room_jid,outdir => "/tmp/muclogs",
file_format => html,css_file => false,timezone => local,
spam_prevention => true,
top_link => {"/","Home"},
access_log => muc,dirtype => subdirs},
mod_stream_management =>
#{buffer => true,ack => true,backend => mnesia,
stale_h =>
#{enabled => false,repeat_after => 1800,geriatric => 3600},
buffer_max => 100,ack_freq => 1,resume_timeout => 600},
mod_adhoc => #{iqdisc => one_queue,report_commands_node => false},
mod_cache_users =>
#{strategy => fifo,number_of_segments => 5,time_to_live => 2},
mod_bosh =>
#{backend => mnesia,inactivity => 30,max_pause => 120,
max_wait => infinity,server_acks => false},
mod_carboncopy => #{iqdisc => no_queue}}},
{escalus_users,[{alice,[{username,<<"alicE">>},
{server,<<"domain.example.com">>},
{host,<<"localhost">>},
{password,<<"matygrysa">>}]},
{bob,[{username,<<"bOb">>},
{server,<<"domain.example.com">>},
{host,<<"localhost">>},
{password,<<"makrolika">>}]},
{kate,[{username,<<"kate">>},
{server,<<"domain.example.com">>},
{host,<<"localhost">>},
{password,<<"makrowe;p">>}]},
{carol,[{username,<<"carol">>},
{server,<<"domain.example.com">>},
{host,<<"localhost">>},
{password,<<"jinglebells">>},
{transport,escalus_bosh},
{path,<<"/http-bind">>},
{port,5280}]}]}]
=== Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@46a395f8a8b0.2024-04-10_14.24.25"
=== Started at 2024-04-10 14:33:22
*** User 2024-04-10 14:33:22.967 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <stream:stream to='domain.example.com' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-04-10 14:33:22.967 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='8f9ccb9724fa344b' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2024-04-10 14:33:22.967 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:features> <register xmlns='http://jabber.org/features/iq-register'/> <starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/> <mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'> <mechanism>SCRAM-SHA-256</mechanism> <mechanism>PLAIN</mechanism> </mechanisms> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2024-04-10 14:33:22.967 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3BtX2ZhaWxlZF90b19kZWNvZGVfbWVzc2FnZV9pbl9kYXRhYmFzZV8xOTMzAG1hdHlncnlzYQ==</auth>
*** User 2024-04-10 14:33:22.969 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-04-10 14:33:22.969 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <stream:stream to='domain.example.com' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-04-10 14:33:22.969 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='5b3c940ab95678f5' from='domain.example.com' version='1.0' xml:lang='en' to='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com'>
*** User 2024-04-10 14:33:22.969 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:features> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'/> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2024-04-10 14:33:22.969 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <iq type='set' id='8df992420abed659044416738e9315da'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-04-10 14:33:22.970 ***🔗 alicE_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <iq id='8df992420abed659044416738e9315da' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1</jid> </bind> </iq>
*** User 2024-04-10 14:33:22.970 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <iq type='set' id='242bb929812bc6cb151da030edd3ea8d'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 14:33:22.970 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <iq from='domain.example.com' to='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' id='242bb929812bc6cb151da030edd3ea8d' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 14:33:22.970 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <presence/>
*** User 2024-04-10 14:33:22.972 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <presence from='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' to='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1'/>
*** User 2024-04-10 14:33:22.973 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <stream:stream to='domain.example.com' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-04-10 14:33:22.973 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='a9f0f36f78d252f0' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2024-04-10 14:33:22.973 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:features> <register xmlns='http://jabber.org/features/iq-register'/> <starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/> <mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'> <mechanism>SCRAM-SHA-256</mechanism> <mechanism>PLAIN</mechanism> </mechanisms> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2024-04-10 14:33:22.973 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9wbV9mYWlsZWRfdG9fZGVjb2RlX21lc3NhZ2VfaW5fZGF0YWJhc2VfMTkzMwBtYWtyb2xpa2E=</auth>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <stream:stream to='domain.example.com' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='d827d878d98c7498' from='domain.example.com' version='1.0' xml:lang='en' to='bob_pm_failed_to_decode_message_in_database_1933@domain.example.com'>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <stream:features> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'/> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <iq type='set' id='ada510d29acb32097f7d057f66807477'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-04-10 14:33:22.975 ***🔗 bOb_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <iq id='ada510d29acb32097f7d057f66807477' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1</jid> </bind> </iq>
*** User 2024-04-10 14:33:22.975 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <iq type='set' id='120f7b66c5ccbd8ce5ea0c44f0a505d5'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 14:33:22.976 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <iq from='domain.example.com' to='bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' id='120f7b66c5ccbd8ce5ea0c44f0a505d5' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 14:33:22.976 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <presence/>
*** User 2024-04-10 14:33:22.978 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <presence from='bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' to='bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1'/>
*** User 2024-04-10 14:33:22.978 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <message type='chat' to='bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1'> <body>Hi</body> </message>
*** System report during mam_SUITE:pm_failed_to_decode_message_in_database/1 in rdbms_easy_impl_specific 2024-04-10 14:33:22.983 ***🔗 =WARNING REPORT==== 10-Apr-2024::14:33:22.982579 === reason: {error,#{reason => "[FreeTDS][SQL Server]Violation of UNIQUE KEY constraint 'mam_server_user$uc_mam_server_user_name'. Cannot insert duplicate key in object 'dbo.mam_server_user'. The duplicate key value is (domain.example.com, alice_pm_failed_to_decode_message_in_database_1933).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000", odbc_query => <<"INSERT INTO mam_server_user (server, user_name) VALUES (?, ?)">>, odbc_params => [{{sql_wlongvarchar,18}, [<<100,0,111,0,109,0,97,0,105,0,110,0,46,0,101,0, 120,0,97,0,109,0,112,0,108,0,101,0,46,0,99,0, 111,0,109,0>>]}, {{sql_wlongvarchar,50}, [<<97,0,108,0,105,0,99,0,101,0,95,0,112,0,109, 0,95,0,102,0,97,0,105,0,108,0,101,0,100,0, 95,0,116,0,111,0,95,0,100,0,101,0,99,0,111, 0,100,0,101,0,95,0,109,0,101,0,115,0,115,0, 97,0,103,0,101,0,95,0,105,0,110,0,95,0,100, 0,97,0,116,0,97,0,98,0,97,0,115,0,101,0,95, 0,49,0,57,0,51,0,51,0>>]}]}} user: <<"alice_pm_failed_to_decode_message_in_database_1933">> host: <<"test type">> server: <<"domain.example.com">> what: create_user_archive_failed
*** User 2024-04-10 14:33:22.985 ***🔗 waiting for archive_size is done in 0 miliseconds
Could not find element props in Config.
*** User 2024-04-10 14:33:22.993 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out <iq type='set' id='a01dd446b027b72d5a424d6ad038c258'> <query xmlns='urn:xmpp:mam:1' queryid='q'/> </iq>
*** User 2024-04-10 14:33:22.998 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <message from='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com' to='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' id='13577147-d6fa-4337-ba2e-20b1fb2064f6'> <result queryid='q' xmlns='urn:xmpp:mam:1' id='C5DUTES9VPO1'> <forwarded xmlns='urn:xmpp:forward:0'> <delay xmlns='urn:xmpp:delay' stamp='2024-04-10T14:33:22.978791Z' from='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1'/> <message from='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' xmlns='jabber:client' type='error'> <error code='500' type='wait'> <internal-server-error xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/> <text xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'>Failed to decode message in database</text> </error> <body>Failed to decode message in database</body> </message> </forwarded> </result> </message>
*** User 2024-04-10 14:33:22.998 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in <iq from='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com' to='alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1' id='a01dd446b027b72d5a424d6ad038c258' type='result'> <fin xmlns='urn:xmpp:mam:1' complete='true'> <set xmlns='http://jabber.org/protocol/rsm'> <first index='0'>C5DUTES9VPO1</first> <last>C5DUTES9VPO1</last> <count>1</count> </set> </fin> </iq>
*** User 2024-04-10 14:33:22.998 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out </stream:stream>
*** User 2024-04-10 14:33:22.998 ***🔗 bob_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in </stream:stream>
*** User 2024-04-10 14:33:22.998 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 out </stream:stream>
*** User 2024-04-10 14:33:22.999 ***🔗 alice_pm_failed_to_decode_message_in_database_1933@domain.example.com/res1 in </stream:stream>
=== Ended at 2024-04-10 14:33:23 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result