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

=== Config value:

    [{watchdog,<0.43956.0>},
     {basic_group,mam_all},
     {configuration,rdbms_easy},
     {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,
                      db_message_format => mam_message_xml,
                      db_jid_format => mam_jid_rfc,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@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.68099.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@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,
              db_message_format => mam_message_xml,
              db_jid_format => mam_jid_rfc,cache_users => false},
        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_xml,
              db_jid_format => mam_jid_rfc},
        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@d44e762df881.2024-03-18_12.53.29"

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


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


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

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



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



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

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



*** User 2024-03-18 13:02:52.578 ***🔗
alicE_unnamed_1898_same_stanza_id_1899@localhost/res1 in
<iq id='3bce4b409efdba747fce9ab91cb6b099' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>alice_unnamed_1898_same_stanza_id_1899@localhost/res1</jid>
	</bind>
</iq>



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



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



*** User 2024-03-18 13:02:52.579 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 out
<presence/>



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



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

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



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



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

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



*** User 2024-03-18 13:02:52.586 ***🔗
bOb_unnamed_1898_same_stanza_id_1899@localhost/res1 in
<iq id='7cbf35f1d92ba4934770b6a2b4e1596d' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>bob_unnamed_1898_same_stanza_id_1899@localhost/res1</jid>
	</bind>
</iq>



*** User 2024-03-18 13:02:52.586 ***🔗
bob_unnamed_1898_same_stanza_id_1899@localhost/res1 out
<iq type='set' id='3247e46e89efea100f043d2db2c66e1f'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



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



*** User 2024-03-18 13:02:52.587 ***🔗
bob_unnamed_1898_same_stanza_id_1899@localhost/res1 out
<presence/>



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



*** User 2024-03-18 13:02:52.591 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 out
<message type='chat' to='bob_unnamed_1898_same_stanza_id_1899@localhost/res1'>
	<body>OH, HAI!</body>
</message>



*** System report during mam_SUITE:same_stanza_id/1 in configurable_archiveid 2024-03-18 13:02:52.603 ***🔗
=WARNING REPORT==== 18-Mar-2024::13:02:52.602840 ===
    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_1898_same_stanza_id_1899).[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,56,
                              0,57,0,56,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,56,0,57,0,57,0>>]}]}}
    user: <<"alice_unnamed_1898_same_stanza_id_1899">>
    host: <<"localhost">>
    server: <<"localhost">>
    what: create_user_archive_failed


*** User 2024-03-18 13:02:52.709 ***🔗
waiting for archive_size is done in 100 miliseconds

*** User 2024-03-18 13:02:52.709 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 out
<iq type='set' id='03ffce5d8240f4c036c2037c663243bb'>
	<query xmlns='urn:xmpp:mam:1' queryid='q1'/>
</iq>



*** User 2024-03-18 13:02:52.715 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 in
<message from='alice_unnamed_1898_same_stanza_id_1899@localhost' to='alice_unnamed_1898_same_stanza_id_1899@localhost/res1' id='e47f2950-0a74-4e86-9c7e-fb0f0ea95fe9'>
	<result queryid='q1' xmlns='urn:xmpp:mam:1' id='C4VEV6OTUS81'>
		<forwarded xmlns='urn:xmpp:forward:0'>
			<delay xmlns='urn:xmpp:delay' stamp='2024-03-18T13:02:52.591985Z' from='alice_unnamed_1898_same_stanza_id_1899@localhost/res1'/>
			<message from='alice_unnamed_1898_same_stanza_id_1899@localhost/res1' xmlns='jabber:client' type='chat' to='bob_unnamed_1898_same_stanza_id_1899@localhost/res1'>
				<body>OH, HAI!</body>
			</message>
		</forwarded>
	</result>
</message>



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



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



*** User 2024-03-18 13:02:52.716 ***🔗
bob_unnamed_1898_same_stanza_id_1899@localhost/res1 out
</stream:stream>

*** User 2024-03-18 13:02:52.716 ***🔗
bob_unnamed_1898_same_stanza_id_1899@localhost/res1 in
</stream:stream>

*** User 2024-03-18 13:02:52.716 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 out
</stream:stream>

*** User 2024-03-18 13:02:52.716 ***🔗
alice_unnamed_1898_same_stanza_id_1899@localhost/res1 in
</stream:stream>
*** CT 2024-03-18 13:02:52.730 *** View log from node mongooseim@localhost when finished🔗 mongooseim@localhost_2163.html



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


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