=== Test case: mam_SUITE:same_stanza_id/1 (click for source code) === Config value: [{watchdog,<0.41882.0>}, {basic_group,mam_all}, {configuration,rdbms}, {mam_meta_opts,#{cache => #{module => internal,strategy => fifo, number_of_segments => 3,time_to_live => 480}, backend => rdbms,send_message => mod_mam_utils, max_result_limit => 50, is_archivable_message => mod_mam_utils, default_result_limit => 50, enforce_simple_queries => false, archive_chat_markers => false,full_text_search => true, message_retraction => true, pm => #{archive_groupchats => false, same_mam_id_for_peers => false}, async_writer => #{enabled => false,batch_size => 30, flush_interval => 2000,pool_size => 16}, no_stanzaid_element => false,user_prefs_store => rdbms, cache_users => false}}, {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@944609fad30e.2024-03-21_07.35.17/big_tests.tests.mam_SUITE.logs/run.2024-03-21_07.44.19/mam_suite.same_stanza_id.html"}, {tc_group_properties,[{name,configurable_archiveid}]}, {tc_group_path,[[{name,rdbms_mam_all},parallel]]}, {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@944609fad30e.2024-03-21_07.35.17/big_tests.tests.mam_SUITE.logs/run.2024-03-21_07.44.19/log_private/"}, {config_backup,#{[shaper,fast] => {ok,#{max_rate => 50000}}, [shaper,mam_shaper] => {ok,#{max_rate => 1}}, [shaper,normal] => {ok,#{max_rate => 1000}}, [{access,<<"localhost">>},max_user_sessions] => {ok,[#{value => 10,acl => all}]}}}, {{saved_modules,mongooseim@localhost,<<"localhost">>}, #{mod_vcard => #{matches => 30, host => {prefix,<<"vjud.">>}, search => true,iqdisc => parallel,backend => rdbms}, mod_roster => #{iqdisc => one_queue,backend => rdbms,versioning => false, store_current_id => false}, mod_muc => #{access => muc, host => {prefix,<<"muc.">>}, max_users => 200,room_shaper => none,http_auth_pool => none, hibernate_timeout => 2000,history_size => 20, hibernated_room_check_interval => 1000, hibernated_room_timeout => 2000,backend => rdbms, access_create => muc_create,access_admin => none, access_persistent => all, default_room => #{public => true,description => <<>>,persistent => false, title => <<>>,password => <<>>,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 => <<>>,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_sic => #{iqdisc => one_queue}, 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_mam => #{cache => #{module => internal,strategy => fifo, number_of_segments => 3,time_to_live => 480}, backend => rdbms,send_message => mod_mam_utils, max_result_limit => 50,is_archivable_message => mod_mam_utils, default_result_limit => 50,enforce_simple_queries => false, archive_chat_markers => false,full_text_search => true, message_retraction => true, pm => #{archive_groupchats => false, same_mam_id_for_peers => false}, async_writer => #{enabled => false,batch_size => 30,flush_interval => 2000, pool_size => 16}, no_stanzaid_element => false,user_prefs_store => rdbms, cache_users => false}, mod_amp => #{},mod_presence => #{}, mod_mam_rdbms_user => #{pm => true}, mod_mam_rdbms_prefs => #{pm => true}, 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_mam_pm => #{send_message => mod_mam_utils,max_result_limit => 50, is_archivable_message => mod_mam_utils, default_result_limit => 50,enforce_simple_queries => false, archive_chat_markers => false,archive_groupchats => false, full_text_search => true,message_retraction => true, async_writer => #{enabled => false,batch_size => 30,flush_interval => 2000, pool_size => 16}, no_stanzaid_element => false,same_mam_id_for_peers => false}, mod_adhoc => #{iqdisc => one_queue,report_commands_node => false}, mod_mam_rdbms_arch => #{db_message_format => mam_message_compressed_eterm, db_jid_format => mam_jid_mini,no_writer => false, delete_domain_limit => infinity}, 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,<<"localhost">>}, {password,<<"matygrysa">>}]}, {bob,[{username,<<"bOb">>}, {server,<<"localhost">>}, {password,<<"makrolika">>}]}, {kate,[{username,<<"kate">>}, {server,<<"localhost">>}, {password,<<"makrowe;p">>}]}, {carol,[{username,<<"carol">>}, {server,<<"localhost">>}, {password,<<"jinglebells">>}, {transport,escalus_bosh}, {path,<<"/http-bind">>}, {port,5280}]}]}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@944609fad30e.2024-03-21_07.35.17" === Started at 2024-03-21 07:44:23
Could not find element props in Config.
*** User 2024-03-21 07:44:23.891 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-03-21 07:44:23.892 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='4c47b3dc84a6b7cf' from='localhost' version='1.0' xml:lang='en'>
*** User 2024-03-21 07:44:23.892 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/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-03-21 07:44:23.892 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3VubmFtZWRfMTc3MV9zYW1lX3N0YW56YV9pZF8xNzcyAG1hdHlncnlzYQ==</auth>
*** User 2024-03-21 07:44:23.894 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-03-21 07:44:23.894 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-03-21 07:44:23.895 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='ad2e48b9ee71787b' from='localhost' version='1.0' xml:lang='en' to='alice_unnamed_1771_same_stanza_id_1772@localhost'>
*** User 2024-03-21 07:44:23.896 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/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-03-21 07:44:23.896 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 out <iq type='set' id='d040c73ec0ffb5494400dfcb8c97a9ee'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-03-21 07:44:23.897 ***🔗 alicE_unnamed_1771_same_stanza_id_1772@localhost/res1 in <iq id='d040c73ec0ffb5494400dfcb8c97a9ee' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_unnamed_1771_same_stanza_id_1772@localhost/res1</jid> </bind> </iq>
*** User 2024-03-21 07:44:23.897 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 out <iq type='set' id='d2a364f472c28ea9a30230d6a119e697'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-03-21 07:44:23.898 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 in <iq from='localhost' to='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' id='d2a364f472c28ea9a30230d6a119e697' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-03-21 07:44:23.898 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 out <presence/>
*** User 2024-03-21 07:44:23.901 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 in <presence from='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' to='alice_unnamed_1771_same_stanza_id_1772@localhost/res1'/>
*** User 2024-03-21 07:44:23.902 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-03-21 07:44:23.902 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='30a0f485f87f7cdc' from='localhost' version='1.0' xml:lang='en'>
*** User 2024-03-21 07:44:23.903 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/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-03-21 07:44:23.903 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl91bm5hbWVkXzE3NzFfc2FtZV9zdGFuemFfaWRfMTc3MgBtYWtyb2xpa2E=</auth>
*** User 2024-03-21 07:44:23.905 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-03-21 07:44:23.905 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2024-03-21 07:44:23.905 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='7440ee7fa1a83862' from='localhost' version='1.0' xml:lang='en' to='bob_unnamed_1771_same_stanza_id_1772@localhost'>
*** User 2024-03-21 07:44:23.906 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/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-03-21 07:44:23.906 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 out <iq type='set' id='42bb7fa0426a6665c4a1d131338a57c0'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-03-21 07:44:23.907 ***🔗 bOb_unnamed_1771_same_stanza_id_1772@localhost/res1 in <iq id='42bb7fa0426a6665c4a1d131338a57c0' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_unnamed_1771_same_stanza_id_1772@localhost/res1</jid> </bind> </iq>
*** User 2024-03-21 07:44:23.907 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 out <iq type='set' id='0176f34c9b03a3a08eaff6b859d79c25'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-03-21 07:44:23.908 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 in <iq from='localhost' to='bob_unnamed_1771_same_stanza_id_1772@localhost/res1' id='0176f34c9b03a3a08eaff6b859d79c25' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-03-21 07:44:23.908 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 out <presence/>
*** User 2024-03-21 07:44:23.911 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 in <presence from='bob_unnamed_1771_same_stanza_id_1772@localhost/res1' to='bob_unnamed_1771_same_stanza_id_1772@localhost/res1'/>
*** User 2024-03-21 07:44:23.912 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 out <message type='chat' to='bob_unnamed_1771_same_stanza_id_1772@localhost/res1'> <body>OH, HAI!</body> </message>
*** System report during mam_SUITE:same_stanza_id/1 in configurable_archiveid 2024-03-21 07:44:23.916 ***🔗 =WARNING REPORT==== 21-Mar-2024::07:44:23.915855 === 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 (localhost, alice_unnamed_1771_same_stanza_id_1772).[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,9}, [<<108,0,111,0,99,0,97,0,108,0,104,0,111,0,115,0, 116,0>>]}, {{sql_wlongvarchar,38}, [<<97,0,108,0,105,0,99,0,101,0,95,0,117,0,110, 0,110,0,97,0,109,0,101,0,100,0,95,0,49,0,55, 0,55,0,49,0,95,0,115,0,97,0,109,0,101,0,95, 0,115,0,116,0,97,0,110,0,122,0,97,0,95,0, 105,0,100,0,95,0,49,0,55,0,55,0,50,0>>]}]}} user: <<"alice_unnamed_1771_same_stanza_id_1772">> host: <<"localhost">> server: <<"localhost">> what: create_user_archive_failed
*** User 2024-03-21 07:44:24.021 ***🔗 waiting for archive_size is done in 100 miliseconds
*** User 2024-03-21 07:44:24.021 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 out <iq type='set' id='18d6ae80c5f8b1c83a24dbb12b7f1135'> <query xmlns='urn:xmpp:mam:1' queryid='q1'/> </iq>
*** User 2024-03-21 07:44:24.024 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 in <message from='alice_unnamed_1771_same_stanza_id_1772@localhost' to='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' id='376bb2ae-6c86-49c1-acc9-5fc49471c5d6'> <result queryid='q1' xmlns='urn:xmpp:mam:1' id='C516S10B1301'> <forwarded xmlns='urn:xmpp:forward:0'> <delay xmlns='urn:xmpp:delay' stamp='2024-03-21T07:44:23.912588Z' from='alice_unnamed_1771_same_stanza_id_1772@localhost/res1'/> <message from='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' xmlns='jabber:client' type='chat' to='bob_unnamed_1771_same_stanza_id_1772@localhost/res1'> <body>OH, HAI!</body> </message> </forwarded> </result> </message>
*** User 2024-03-21 07:44:24.025 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 in <iq from='alice_unnamed_1771_same_stanza_id_1772@localhost' to='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' id='18d6ae80c5f8b1c83a24dbb12b7f1135' type='result'> <fin xmlns='urn:xmpp:mam:1' complete='true'> <set xmlns='http://jabber.org/protocol/rsm'> <first index='0'>C516S10B1301</first> <last>C516S10B1301</last> <count>1</count> </set> </fin> </iq>
*** User 2024-03-21 07:44:24.025 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 in <message from='alice_unnamed_1771_same_stanza_id_1772@localhost/res1' to='bob_unnamed_1771_same_stanza_id_1772@localhost/res1' type='chat'> <body>OH, HAI!</body> <stanza-id by='bob_unnamed_1771_same_stanza_id_1772@localhost' id='C516S10B1301' xmlns='urn:xmpp:sid:0'/> </message>
*** User 2024-03-21 07:44:24.025 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 out </stream:stream>
*** User 2024-03-21 07:44:24.025 ***🔗 bob_unnamed_1771_same_stanza_id_1772@localhost/res1 in </stream:stream>
*** User 2024-03-21 07:44:24.026 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 out </stream:stream>
*** User 2024-03-21 07:44:24.026 ***🔗 alice_unnamed_1771_same_stanza_id_1772@localhost/res1 in </stream:stream>
=== Ended at 2024-03-21 07:44:24 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result