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

=== Config value:

    [{watchdog,<0.42177.0>},
     {basic_group,mam_all},
     {configuration,rdbms_easy},
     {mam_meta_opts,#{cache =>
                          #{module => internal,strategy => fifo,
                            number_of_segments => 3,time_to_live => 480},
                      backend => rdbms,max_result_limit => 50,
                      send_message => mod_mam_utils,
                      db_message_format => mam_message_xml,
                      pm =>
                          #{archive_groupchats => false,
                            same_mam_id_for_peers => false},
                      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,db_jid_format => mam_jid_rfc,
                      async_writer =>
                          #{enabled => false,pool_size => 16,batch_size => 30,
                            flush_interval => 2000},
                      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@9f12fc69b406.2023-11-17_15.10.18/big_tests.tests.mam_SUITE.logs/run.2023-11-17_15.18.15/mam_suite.same_stanza_id.82307.html"},
     {tc_group_properties,[{name,configurable_archiveid}]},
     {tc_group_path,[[{name,rdbms_easy_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@9f12fc69b406.2023-11-17_15.10.18/big_tests.tests.mam_SUITE.logs/run.2023-11-17_15.18.15/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_amp => #{},
        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_mam =>
            #{cache =>
                  #{module => internal,strategy => fifo,
                    number_of_segments => 3,time_to_live => 480},
              backend => rdbms,max_result_limit => 50,
              send_message => mod_mam_utils,
              db_message_format => mam_message_xml,
              pm =>
                  #{archive_groupchats => false,
                    same_mam_id_for_peers => false},
              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,db_jid_format => mam_jid_rfc,
              async_writer =>
                  #{enabled => false,pool_size => 16,batch_size => 30,
                    flush_interval => 2000},
              no_stanzaid_element => false,user_prefs_store => rdbms,
              cache_users => false},
        mod_mam_rdbms_prefs => #{pm => true},
        mod_presence => #{},
        mod_mam_rdbms_user => #{pm => true},
        mod_disco =>
            #{iqdisc => one_queue,users_can_see_hidden_services => false,
              server_info => [],extra_domains => []},
        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_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_mam_pm =>
            #{max_result_limit => 50,send_message => mod_mam_utils,
              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,archive_groupchats => false,
              same_mam_id_for_peers => false,
              async_writer =>
                  #{enabled => false,pool_size => 16,batch_size => 30,
                    flush_interval => 2000},
              no_stanzaid_element => false},
        mod_adhoc => #{iqdisc => one_queue,report_commands_node => false},
        mod_mam_rdbms_arch =>
            #{db_message_format => mam_message_xml,no_writer => false,
              delete_domain_limit => infinity,db_jid_format => mam_jid_rfc},
        mod_bosh =>
            #{backend => mnesia,inactivity => 30,max_pause => 120,
              max_wait => infinity,server_acks => false},
        mod_cache_users =>
            #{strategy => fifo,number_of_segments => 5,time_to_live => 2},
        mod_carboncopy => #{iqdisc => no_queue},
        mod_muc =>
            #{access => muc,
              host => {prefix,<<"groupchats.">>},
              backend => rdbms,online_backend => mnesia,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,access_create => muc_create,
              access_admin => none,access_persistent => all,
              default_room =>
                  #{public => true,description => <<>>,persistent => false,
                    title => <<>>,password => <<>>,subject => <<>>,
                    anonymous => true,affiliations => [],
                    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,max_users => 200,
                    maygetmemberlist => [],logging => false,
                    subject_author => <<>>},
              load_permanent_rooms_at_startup => false,
              max_room_id => infinity,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}}},
     {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@9f12fc69b406.2023-11-17_15.10.18"

=== Started at 2023-11-17 15:18:31


*** CT 2023-11-17 15:18:31.425 *** View log from node mongooseim@localhost when started🔗 mongooseim@localhost_2256.html
Could not find element props in Config.


*** User 2023-11-17 15:18:31.557 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.557 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='a896097c512ba1e1' from='domain.example.com' version='1.0' xml:lang='en'>

*** User 2023-11-17 15:18:31.558 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.558 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3VubmFtZWRfMTc5Nl9zYW1lX3N0YW56YV9pZF8xNzk3AG1hdHlncnlzYQ==</auth>



*** User 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='2e184434124b8bda' from='domain.example.com' version='1.0' xml:lang='en' to='alice_unnamed_1796_same_stanza_id_1797@domain.example.com'>

*** User 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<iq type='set' id='099b5c60f2bfa682af08d1280d8bc612'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2023-11-17 15:18:31.559 ***🔗
alicE_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<iq id='099b5c60f2bfa682af08d1280d8bc612' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1</jid>
	</bind>
</iq>



*** User 2023-11-17 15:18:31.560 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<iq type='set' id='daa7324f1bd4e2e53d628e0c3c343b0e'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2023-11-17 15:18:31.560 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<iq from='domain.example.com' to='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' id='daa7324f1bd4e2e53d628e0c3c343b0e' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2023-11-17 15:18:31.560 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<presence/>



*** User 2023-11-17 15:18:31.562 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<presence from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' to='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1'/>



*** User 2023-11-17 15:18:31.562 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.563 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='3ce0b774bc7ba37f' from='domain.example.com' version='1.0' xml:lang='en'>

*** User 2023-11-17 15:18:31.563 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.563 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl91bm5hbWVkXzE3OTZfc2FtZV9zdGFuemFfaWRfMTc5NwBtYWtyb2xpa2E=</auth>



*** User 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='438473b973292dc5' from='domain.example.com' version='1.0' xml:lang='en' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com'>

*** User 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@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 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<iq type='set' id='c0245fb219bd7b6f737048790d88c4ec'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2023-11-17 15:18:31.564 ***🔗
bOb_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<iq id='c0245fb219bd7b6f737048790d88c4ec' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1</jid>
	</bind>
</iq>



*** User 2023-11-17 15:18:31.564 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<iq type='set' id='e077088e0ed58eaedd8bd5c23858b3d6'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2023-11-17 15:18:31.565 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<iq from='domain.example.com' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' id='e077088e0ed58eaedd8bd5c23858b3d6' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2023-11-17 15:18:31.565 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<presence/>



*** User 2023-11-17 15:18:31.567 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<presence from='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1'/>



*** User 2023-11-17 15:18:31.567 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<message type='chat' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1'>
	<body>OH, HAI!</body>
</message>



*** System report during mam_SUITE:same_stanza_id/1 in configurable_archiveid 2023-11-17 15:18:31.575 ***🔗
=WARNING REPORT==== 17-Nov-2023::15:18:31.575060 ===
    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_unnamed_1796_same_stanza_id_1797).[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,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,57,0,54,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,57,0,55,0>>]}]}}
    user: <<"alice_unnamed_1796_same_stanza_id_1797">>
    host: <<"test type">>
    server: <<"domain.example.com">>
    what: create_user_archive_failed


*** User 2023-11-17 15:18:31.679 ***🔗
waiting for archive_size is done in 100 miliseconds

*** User 2023-11-17 15:18:31.680 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
<iq type='set' id='f25962ec28638c0ae83f24d4ff503dbf'>
	<query xmlns='urn:xmpp:mam:1' queryid='q1'/>
</iq>



*** User 2023-11-17 15:18:31.682 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<message from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com' to='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' id='186a189f-1ec9-43c4-a139-4060c734294b'>
	<result queryid='q1' xmlns='urn:xmpp:mam:1' id='C2IQKOMGKH01'>
		<forwarded xmlns='urn:xmpp:forward:0'>
			<delay xmlns='urn:xmpp:delay' stamp='2023-11-17T15:18:31.567940Z' from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1'/>
			<message from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' xmlns='jabber:client' type='chat' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1'>
				<body>OH, HAI!</body>
			</message>
		</forwarded>
	</result>
</message>



*** User 2023-11-17 15:18:31.683 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<iq from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com' to='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' id='f25962ec28638c0ae83f24d4ff503dbf' type='result'>
	<fin xmlns='urn:xmpp:mam:1' complete='true'>
		<set xmlns='http://jabber.org/protocol/rsm'>
			<first index='0'>C2IQKOMGKH01</first>
			<last>C2IQKOMGKH01</last>
			<count>1</count>
		</set>
	</fin>
</iq>



*** User 2023-11-17 15:18:31.683 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
<message from='alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' to='bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1' type='chat'>
	<body>OH, HAI!</body>
	<stanza-id by='bob_unnamed_1796_same_stanza_id_1797@domain.example.com' id='C2IQKOMGKH01' xmlns='urn:xmpp:sid:0'/>
</message>



*** User 2023-11-17 15:18:31.683 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
</stream:stream>

*** User 2023-11-17 15:18:31.683 ***🔗
bob_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
</stream:stream>

*** User 2023-11-17 15:18:31.683 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 out
</stream:stream>

*** User 2023-11-17 15:18:31.683 ***🔗
alice_unnamed_1796_same_stanza_id_1797@domain.example.com/res1 in
</stream:stream>
*** CT 2023-11-17 15:18:31.735 *** View log from node mongooseim@localhost when finished🔗 mongooseim@localhost_2257.html



=== Ended at 2023-11-17 15:18:31
=== successfully completed test case
=== === Returned value: ok


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