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

=== Config value:

    [{watchdog,<0.46159.0>},
     {basic_group,mam_all},
     {configuration,rdbms_async_pool},
     {wait_for_parallel_writer,[pm]},
     {mam_meta_opts,#{cache =>
                          #{module => internal,strategy => fifo,
                            number_of_segments => 3,time_to_live => 480},
                      send_message => mod_mam_utils,backend => rdbms,
                      max_result_limit => 50,
                      is_archivable_message => mod_mam_utils,
                      pm =>
                          #{archive_groupchats => false,
                            same_mam_id_for_peers => false},
                      default_result_limit => 50,
                      archive_chat_markers => false,
                      enforce_simple_queries => false,
                      full_text_search => true,no_stanzaid_element => false,
                      async_writer =>
                          #{enabled => true,batch_size => 30,
                            flush_interval => 1,pool_size => 16},
                      message_retraction => true,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@d091d39a81d0.2024-03-08_08.59.35/big_tests.tests.mam_SUITE.logs/run.2024-03-08_09.09.57/mam_suite.same_stanza_id.127106.html"},
     {tc_group_properties,[{name,configurable_archiveid}]},
     {tc_group_path,[[{name,rdbms_async_pool_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@d091d39a81d0.2024-03-08_08.59.35/big_tests.tests.mam_SUITE.logs/run.2024-03-08_09.09.57/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,backend => rdbms,iqdisc => parallel},
        mod_roster =>
            #{backend => rdbms,iqdisc => one_queue,versioning => false,
              store_current_id => false},
        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_amp => #{},
        mod_muc =>
            #{access => muc,
              host => {prefix,<<"muc.">>},
              backend => rdbms,max_users => 200,room_shaper => none,
              http_auth_pool => none,hibernate_timeout => 2000,
              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 => <<>>,persistent => false,
                    title => <<>>,password => <<>>,anonymous => true,
                    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,
                    affiliations => [],subject => <<>>,subject_author => <<>>},
              online_backend => mnesia,hibernated_room_check_interval => 1000,
              hibernated_room_timeout => 2000,access_create => muc_create,
              load_permanent_rooms_at_startup => false,
              max_room_id => infinity},
        mod_presence => #{},
        mod_mam =>
            #{cache =>
                  #{module => internal,strategy => fifo,
                    number_of_segments => 3,time_to_live => 480},
              send_message => mod_mam_utils,backend => rdbms,
              max_result_limit => 50,is_archivable_message => mod_mam_utils,
              pm =>
                  #{archive_groupchats => false,
                    same_mam_id_for_peers => false},
              default_result_limit => 50,archive_chat_markers => false,
              enforce_simple_queries => false,full_text_search => true,
              no_stanzaid_element => false,
              async_writer =>
                  #{enabled => true,batch_size => 30,flush_interval => 1,
                    pool_size => 16},
              message_retraction => true,user_prefs_store => rdbms,
              cache_users => false},
        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_rdbms_arch =>
            #{db_message_format => mam_message_compressed_eterm,
              no_writer => true,delete_domain_limit => infinity,
              db_jid_format => mam_jid_mini},
        mod_adhoc => #{iqdisc => one_queue,report_commands_node => false},
        mod_mam_pm =>
            #{send_message => mod_mam_utils,max_result_limit => 50,
              is_archivable_message => mod_mam_utils,
              default_result_limit => 50,archive_chat_markers => false,
              enforce_simple_queries => false,full_text_search => true,
              no_stanzaid_element => false,archive_groupchats => false,
              same_mam_id_for_peers => false,
              async_writer =>
                  #{enabled => true,batch_size => 30,flush_interval => 1,
                    pool_size => 16},
              message_retraction => true},
        mod_mam_rdbms_arch_async =>
            #{enabled => true,batch_size => 30,flush_interval => 1,
              pool_size => 16},
        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}}},
     {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@d091d39a81d0.2024-03-08_08.59.35"

=== Started at 2024-03-08 09:10:21


*** CT 2024-03-08 09:10:21.872 *** View log from node mongooseim@localhost when started🔗 mongooseim@localhost_2245.html
Could not find element props in Config.


*** User 2024-03-08 09:10:21.920 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.920 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='2f7795c2f4e60b2f' from='localhost' version='1.0' xml:lang='en'>

*** User 2024-03-08 09:10:21.921 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.921 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3VubmFtZWRfMTk5N19zYW1lX3N0YW56YV9pZF8xOTk4AG1hdHlncnlzYQ==</auth>



*** User 2024-03-08 09:10:21.922 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2024-03-08 09:10:21.922 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.922 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='7496dd071fb5e68e' from='localhost' version='1.0' xml:lang='en' to='alice_unnamed_1997_same_stanza_id_1998@localhost'>

*** User 2024-03-08 09:10:21.923 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.923 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<iq type='set' id='cc3bcc7b259f7ce167660ea8fbae093a'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2024-03-08 09:10:21.923 ***🔗
alicE_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<iq id='cc3bcc7b259f7ce167660ea8fbae093a' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>alice_unnamed_1997_same_stanza_id_1998@localhost/res1</jid>
	</bind>
</iq>



*** User 2024-03-08 09:10:21.923 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<iq type='set' id='dad25405970c5593c4ec6d30d1cf3a0f'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-08 09:10:21.924 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<iq from='localhost' to='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' id='dad25405970c5593c4ec6d30d1cf3a0f' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-08 09:10:21.924 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<presence/>



*** User 2024-03-08 09:10:21.926 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<presence from='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' to='alice_unnamed_1997_same_stanza_id_1998@localhost/res1'/>



*** User 2024-03-08 09:10:21.927 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.927 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='d9d1facaf77db2d0' from='localhost' version='1.0' xml:lang='en'>

*** User 2024-03-08 09:10:21.928 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.928 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl91bm5hbWVkXzE5OTdfc2FtZV9zdGFuemFfaWRfMTk5OABtYWtyb2xpa2E=</auth>



*** User 2024-03-08 09:10:21.929 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>



*** User 2024-03-08 09:10:21.929 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.930 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='996c3e9c500fac88' from='localhost' version='1.0' xml:lang='en' to='bob_unnamed_1997_same_stanza_id_1998@localhost'>

*** User 2024-03-08 09:10:21.930 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@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-08 09:10:21.930 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<iq type='set' id='a126c1f422880a616738c388b3c9977d'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>



*** User 2024-03-08 09:10:21.930 ***🔗
bOb_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<iq id='a126c1f422880a616738c388b3c9977d' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>bob_unnamed_1997_same_stanza_id_1998@localhost/res1</jid>
	</bind>
</iq>



*** User 2024-03-08 09:10:21.931 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<iq type='set' id='1a98909cf6c022ef3f251254dfc0a280'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-08 09:10:21.931 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<iq from='localhost' to='bob_unnamed_1997_same_stanza_id_1998@localhost/res1' id='1a98909cf6c022ef3f251254dfc0a280' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>



*** User 2024-03-08 09:10:21.932 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<presence/>



*** User 2024-03-08 09:10:21.934 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<presence from='bob_unnamed_1997_same_stanza_id_1998@localhost/res1' to='bob_unnamed_1997_same_stanza_id_1998@localhost/res1'/>



*** User 2024-03-08 09:10:21.934 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<message type='chat' to='bob_unnamed_1997_same_stanza_id_1998@localhost/res1'>
	<body>OH, HAI!</body>
</message>



*** System report during mam_SUITE:same_stanza_id/1 in configurable_archiveid 2024-03-08 09:10:21.939 ***🔗
=WARNING REPORT==== 8-Mar-2024::09:10:21.939058 ===
    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_1997_same_stanza_id_1998).[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,57,
                              0,57,0,55,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,57,0,57,0,56,0>>]}]}}
    user: <<"alice_unnamed_1997_same_stanza_id_1998">>
    host: <<"localhost">>
    server: <<"localhost">>
    what: create_user_archive_failed


*** User 2024-03-08 09:10:21.943 ***🔗
waiting for archive_size is done in 0 miliseconds

*** User 2024-03-08 09:10:21.943 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 out
<iq type='set' id='18f2894cfb10a0a7d4c040fe0f106519'>
	<query xmlns='urn:xmpp:mam:1' queryid='q1'/>
</iq>



*** User 2024-03-08 09:10:21.948 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<message from='alice_unnamed_1997_same_stanza_id_1998@localhost' to='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' id='fbd073f3-5413-4b47-97f7-7c9ea468db54'>
	<result queryid='q1' xmlns='urn:xmpp:mam:1' id='C4P2HV0VNC81'>
		<forwarded xmlns='urn:xmpp:forward:0'>
			<delay xmlns='urn:xmpp:delay' stamp='2024-03-08T09:10:21.934513Z' from='alice_unnamed_1997_same_stanza_id_1998@localhost/res1'/>
			<message from='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' xmlns='jabber:client' type='chat' to='bob_unnamed_1997_same_stanza_id_1998@localhost/res1'>
				<body>OH, HAI!</body>
			</message>
		</forwarded>
	</result>
</message>



*** User 2024-03-08 09:10:21.948 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<iq from='alice_unnamed_1997_same_stanza_id_1998@localhost' to='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' id='18f2894cfb10a0a7d4c040fe0f106519' type='result'>
	<fin xmlns='urn:xmpp:mam:1' complete='true'>
		<set xmlns='http://jabber.org/protocol/rsm'>
			<first index='0'>C4P2HV0VNC81</first>
			<last>C4P2HV0VNC81</last>
			<count>1</count>
		</set>
	</fin>
</iq>



*** User 2024-03-08 09:10:21.948 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 in
<message from='alice_unnamed_1997_same_stanza_id_1998@localhost/res1' to='bob_unnamed_1997_same_stanza_id_1998@localhost/res1' type='chat'>
	<body>OH, HAI!</body>
	<stanza-id by='bob_unnamed_1997_same_stanza_id_1998@localhost' id='C4P2HV0VNC81' xmlns='urn:xmpp:sid:0'/>
</message>



*** User 2024-03-08 09:10:21.948 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 out
</stream:stream>

*** User 2024-03-08 09:10:21.948 ***🔗
bob_unnamed_1997_same_stanza_id_1998@localhost/res1 in
</stream:stream>

*** User 2024-03-08 09:10:21.948 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 out
</stream:stream>

*** User 2024-03-08 09:10:21.949 ***🔗
alice_unnamed_1997_same_stanza_id_1998@localhost/res1 in
</stream:stream>
*** CT 2024-03-08 09:10:21.953 *** View log from node mongooseim@localhost when finished🔗 mongooseim@localhost_2245.html



=== Ended at 2024-03-08 09:10:21
=== successfully completed test case
=== === Returned value: ok


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