=== Test case: mam_SUITE:same_stanza_id/1 (click for source code)

=== Config value:

    [{watchdog,<0.55660.0>},
     {basic_group,mam_all},
     {configuration,rdbms_cache},
     {mam_meta_opts,#{cache =>
                          #{module => internal,strategy => fifo,
                            number_of_segments => 3,time_to_live => 480},
                      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,backend => rdbms,
                      async_writer =>
                          #{enabled => false,pool_size => 16,batch_size => 30,
                            flush_interval => 2000},
                      full_text_search => true,message_retraction => true,
                      no_stanzaid_element => false,user_prefs_store => rdbms,
                      cache_users => true}},
     {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@d44e762df881.2024-03-18_12.53.29/big_tests.tests.mam_SUITE.logs/run.2024-03-18_13.02.33/mam_suite.same_stanza_id.188930.html"},
     {tc_group_properties,[{name,configurable_archiveid}]},
     {tc_group_path,[[{name,rdbms_cache_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@d44e762df881.2024-03-18_12.53.29/big_tests.tests.mam_SUITE.logs/run.2024-03-18_13.02.33/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_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_muc =>
            #{access => muc,
              host => {prefix,<<"muc.">>},
              max_users => 200,room_shaper => none,http_auth_pool => none,
              hibernate_timeout => 2000,online_backend => mnesia,
              backend => rdbms,history_size => 20,min_presence_interval => 0,
              access_admin => none,access_persistent => all,
              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,
              default_room =>
                  #{public => true,description => <<>>,title => <<>>,
                    persistent => false,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 => <<>>},
              hibernated_room_check_interval => 1000,
              hibernated_room_timeout => 2000,access_create => muc_create,
              load_permanent_rooms_at_startup => false,
              max_room_id => infinity},
        mod_mam =>
            #{cache =>
                  #{module => internal,strategy => fifo,
                    number_of_segments => 3,time_to_live => 480},
              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,
              backend => rdbms,
              async_writer =>
                  #{enabled => false,pool_size => 16,batch_size => 30,
                    flush_interval => 2000},
              full_text_search => true,message_retraction => true,
              no_stanzaid_element => false,user_prefs_store => rdbms,
              cache_users => true},
        mod_mam_rdbms_user => #{pm => true},
        mod_amp => #{},
        mod_mam_rdbms_prefs => #{pm => true},
        mod_disco =>
            #{iqdisc => one_queue,users_can_see_hidden_services => false,
              server_info => [],extra_domains => []},
        mod_presence => #{},
        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,buffer_max => 100,backend => mnesia,
              stale_h =>
                  #{enabled => false,repeat_after => 1800,geriatric => 3600},
              ack_freq => 1,resume_timeout => 600},
        mod_adhoc => #{iqdisc => one_queue,report_commands_node => false},
        mod_mam_pm =>
            #{is_archivable_message => mod_mam_utils,max_result_limit => 50,
              default_result_limit => 50,enforce_simple_queries => false,
              send_message => mod_mam_utils,archive_groupchats => false,
              same_mam_id_for_peers => false,archive_chat_markers => false,
              async_writer =>
                  #{enabled => false,pool_size => 16,batch_size => 30,
                    flush_interval => 2000},
              full_text_search => true,message_retraction => true,
              no_stanzaid_element => false},
        mod_cache_users =>
            #{strategy => fifo,number_of_segments => 5,time_to_live => 2},
        mod_mam_rdbms_arch =>
            #{no_writer => false,delete_domain_limit => infinity,
              db_message_format => mam_message_compressed_eterm,
              db_jid_format => mam_jid_mini},
        mod_bosh =>
            #{backend => mnesia,inactivity => 30,max_pause => 120,
              max_wait => infinity,server_acks => false},
        mod_mam_cache_user =>
            #{module => internal,strategy => fifo,pm => true,
              number_of_segments => 3,time_to_live => 480},
        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@d44e762df881.2024-03-18_12.53.29"

=== Started at 2024-03-18 13:03:52


*** CT 2024-03-18 13:03:52.050 *** View log from node mongooseim@localhost when started🔗 mongooseim@localhost_2271.html
Could not find element props in Config.


*** User 2024-03-18 13:03:52.134 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.135 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='760834cbd04fdd96' from='localhost' version='1.0' xml:lang='en'>

*** User 2024-03-18 13:03:52.135 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.135 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3VubmFtZWRfMjQ2M19zYW1lX3N0YW56YV9pZF8yNDY0AG1hdHlncnlzYQ==</auth>



*** User 2024-03-18 13:03:52.137 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2024-03-18 13:03:52.137 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.137 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='f3801af12a3c64bc' from='localhost' version='1.0' xml:lang='en' to='alice_unnamed_2463_same_stanza_id_2464@localhost'>

*** User 2024-03-18 13:03:52.137 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.138 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<iq type='set' id='bc83dbb22eb733388ecc3bdd6a40abb5'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2024-03-18 13:03:52.138 ***🔗
alicE_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<iq id='bc83dbb22eb733388ecc3bdd6a40abb5' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>alice_unnamed_2463_same_stanza_id_2464@localhost/res1</jid>
	</bind>
</iq>



*** User 2024-03-18 13:03:52.138 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<iq type='set' id='03ec8825eef929d4010d8a266090de21'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-18 13:03:52.139 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<iq from='localhost' to='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' id='03ec8825eef929d4010d8a266090de21' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-18 13:03:52.139 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<presence/>



*** User 2024-03-18 13:03:52.142 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<presence from='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' to='alice_unnamed_2463_same_stanza_id_2464@localhost/res1'/>



*** User 2024-03-18 13:03:52.143 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.143 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='89a22e7e914bab83' from='localhost' version='1.0' xml:lang='en'>

*** User 2024-03-18 13:03:52.143 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.143 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl91bm5hbWVkXzI0NjNfc2FtZV9zdGFuemFfaWRfMjQ2NABtYWtyb2xpa2E=</auth>



*** User 2024-03-18 13:03:52.145 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2024-03-18 13:03:52.145 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.145 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='50f7da5aae036a2b' from='localhost' version='1.0' xml:lang='en' to='bob_unnamed_2463_same_stanza_id_2464@localhost'>

*** User 2024-03-18 13:03:52.145 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@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-18 13:03:52.146 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<iq type='set' id='9dda5c44d8196adccea0c87c364ee98e'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2024-03-18 13:03:52.146 ***🔗
bOb_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<iq id='9dda5c44d8196adccea0c87c364ee98e' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>bob_unnamed_2463_same_stanza_id_2464@localhost/res1</jid>
	</bind>
</iq>



*** User 2024-03-18 13:03:52.146 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<iq type='set' id='de5c50a5aa33660e843b341bd9d67f9b'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-18 13:03:52.147 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<iq from='localhost' to='bob_unnamed_2463_same_stanza_id_2464@localhost/res1' id='de5c50a5aa33660e843b341bd9d67f9b' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-18 13:03:52.147 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<presence/>



*** User 2024-03-18 13:03:52.150 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<presence from='bob_unnamed_2463_same_stanza_id_2464@localhost/res1' to='bob_unnamed_2463_same_stanza_id_2464@localhost/res1'/>



*** User 2024-03-18 13:03:52.151 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<message type='chat' to='bob_unnamed_2463_same_stanza_id_2464@localhost/res1'>
	<body>OH, HAI!</body>
</message>



*** System report during mam_SUITE:same_stanza_id/1 in configurable_archiveid 2024-03-18 13:03:52.157 ***🔗
=WARNING REPORT==== 18-Mar-2024::13:03:52.157363 ===
    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_2463_same_stanza_id_2464).[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,50,0,52,
                              0,54,0,51,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,50,0,52,0,54,0,52,0>>]}]}}
    user: <<"alice_unnamed_2463_same_stanza_id_2464">>
    host: <<"localhost">>
    server: <<"localhost">>
    what: create_user_archive_failed


*** User 2024-03-18 13:03:52.161 ***🔗
waiting for archive_size is done in 0 miliseconds

*** User 2024-03-18 13:03:52.161 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 out
<iq type='set' id='6ee3a76b4958be844235ecdc2c55c43e'>
	<query xmlns='urn:xmpp:mam:1' queryid='q1'/>
</iq>



*** User 2024-03-18 13:03:52.184 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<message from='alice_unnamed_2463_same_stanza_id_2464@localhost' to='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' id='e289cca9-7d59-4b2e-99e5-e06e4e9c4b43'>
	<result queryid='q1' xmlns='urn:xmpp:mam:1' id='C4VEVKVATSO1'>
		<forwarded xmlns='urn:xmpp:forward:0'>
			<delay xmlns='urn:xmpp:delay' stamp='2024-03-18T13:03:52.151795Z' from='alice_unnamed_2463_same_stanza_id_2464@localhost/res1'/>
			<message from='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' xmlns='jabber:client' type='chat' to='bob_unnamed_2463_same_stanza_id_2464@localhost/res1'>
				<body>OH, HAI!</body>
			</message>
		</forwarded>
	</result>
</message>



*** User 2024-03-18 13:03:52.184 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<iq from='alice_unnamed_2463_same_stanza_id_2464@localhost' to='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' id='6ee3a76b4958be844235ecdc2c55c43e' type='result'>
	<fin xmlns='urn:xmpp:mam:1' complete='true'>
		<set xmlns='http://jabber.org/protocol/rsm'>
			<first index='0'>C4VEVKVATSO1</first>
			<last>C4VEVKVATSO1</last>
			<count>1</count>
		</set>
	</fin>
</iq>



*** User 2024-03-18 13:03:52.184 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 in
<message from='alice_unnamed_2463_same_stanza_id_2464@localhost/res1' to='bob_unnamed_2463_same_stanza_id_2464@localhost/res1' type='chat'>
	<body>OH, HAI!</body>
	<stanza-id by='bob_unnamed_2463_same_stanza_id_2464@localhost' id='C4VEVKVATSO1' xmlns='urn:xmpp:sid:0'/>
</message>



*** User 2024-03-18 13:03:52.184 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 out
</stream:stream>

*** User 2024-03-18 13:03:52.185 ***🔗
bob_unnamed_2463_same_stanza_id_2464@localhost/res1 in
</stream:stream>

*** User 2024-03-18 13:03:52.185 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 out
</stream:stream>

*** User 2024-03-18 13:03:52.185 ***🔗
alice_unnamed_2463_same_stanza_id_2464@localhost/res1 in
</stream:stream>
*** CT 2024-03-18 13:03:52.190 *** View log from node mongooseim@localhost when finished🔗 mongooseim@localhost_2271.html



=== Ended at 2024-03-18 13:03:52
=== successfully completed test case
=== === Returned value: ok


Test run history | Top level test index | Latest test result