=== Test case: gdpr_SUITE:remove_mam_pm/1 (click for source code)

=== Config value:

    [{mam_backend,rdbms},
     {watchdog,<0.15185.0>},
     {protocol,cli},
     {schema_endpoint,admin},
     {{ejabberd_cwd,mongooseim@localhost},
      "/home/circleci/project/_build/mim1/rel/mongooseim"},
     {preset,"odbc_mssql_mnesia"},
     {mim_data_dir,"/home/circleci/project/big_tests/tests/gdpr_SUITE_data"},
     {tc_logfile,"/home/circleci/project/big_tests/ct_report/ct_run.test@6b1d699de40b.2024-04-24_17.25.59/big_tests.tests.gdpr_SUITE.logs/run.2024-04-24_17.27.45/gdpr_suite.remove_mam_pm.html"},
     {tc_group_properties,[{name,remove_personal_data_mam_rdbms}]},
     {tc_group_path,[[{name,remove_personal_data_mam}],
                     [{name,remove_personal_data}]]},
     {data_dir,"/home/circleci/project/big_tests/_build/default/lib/mongoose_tests/ebin/gdpr_SUITE_data/"},
     {priv_dir,"/home/circleci/project/big_tests/ct_report/ct_run.test@6b1d699de40b.2024-04-24_17.25.59/big_tests.tests.gdpr_SUITE.logs/run.2024-04-24_17.27.45/log_private/"},
     {{saved_modules,mongooseim@localhost,<<"test type">>},
      #{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_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_disco =>
            #{iqdisc => one_queue,server_info => [],extra_domains => [],
              users_can_see_hidden_services => false},
        mod_presence => #{},
        mod_adhoc => #{iqdisc => one_queue,report_commands_node => false},
        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_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}}}]

=== Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@6b1d699de40b.2024-04-24_17.25.59"

=== Started at 2024-04-24 17:28:28
*** CT 2024-04-24 17:28:28.310 *** View log from node mongooseim@localhost when started🔗 mongooseim@localhost_1484.html 


*** User 2024-04-24 17:28:28.398 ***🔗
required modules: [{mod_mam,#{cache =>
                                  #{module => internal,strategy => fifo,
                                    number_of_segments => 3,
                                    time_to_live => 480},
                              send_message => mod_mam_utils,backend => rdbms,
                              pm =>
                                  #{archive_groupchats => false,
                                    same_mam_id_for_peers => false},
                              max_result_limit => 50,
                              default_result_limit => 50,
                              archive_chat_markers => false,
                              enforce_simple_queries => false,
                              full_text_search => true,
                              is_archivable_message => mod_mam_utils,
                              no_stanzaid_element => false,
                              message_retraction => true,
                              async_writer =>
                                  #{enabled => true,pool_size => 16,
                                    batch_size => 30,flush_interval => 2000},
                              cache_users => true}}]




*** User 2024-04-24 17:28:28.407 ***🔗
alicE_remove_mam_pm_765@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 2024-04-24 17:28:28.407 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='c11004816598e9d8' from='domain.example.com' version='1.0' xml:lang='en'>



*** User 2024-04-24 17:28:28.407 ***🔗
alicE_remove_mam_pm_765@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 2024-04-24 17:28:28.407 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JlbW92ZV9tYW1fcG1fNzY1AG1hdHlncnlzYQ==</auth>





*** User 2024-04-24 17:28:28.409 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>





*** User 2024-04-24 17:28:28.409 ***🔗
alicE_remove_mam_pm_765@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 2024-04-24 17:28:28.409 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='c8a52f7b9eeaf205' from='domain.example.com' version='1.0' xml:lang='en' to='alice_remove_mam_pm_765@domain.example.com'>



*** User 2024-04-24 17:28:28.409 ***🔗
alicE_remove_mam_pm_765@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 2024-04-24 17:28:28.409 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 out
<iq type='set' id='3f995dfb44d3b1be846a6d76077d2c08'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>





*** User 2024-04-24 17:28:28.410 ***🔗
alicE_remove_mam_pm_765@domain.example.com/res1 in
<iq id='3f995dfb44d3b1be846a6d76077d2c08' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>alice_remove_mam_pm_765@domain.example.com/res1</jid>
	</bind>
</iq>





*** User 2024-04-24 17:28:28.410 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 out
<iq type='set' id='81f20ac1cf82bff90ddac3f6e879ce3b'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>





*** User 2024-04-24 17:28:28.410 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 in
<iq from='domain.example.com' to='alice_remove_mam_pm_765@domain.example.com/res1' id='81f20ac1cf82bff90ddac3f6e879ce3b' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>





*** User 2024-04-24 17:28:28.410 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 out
<presence/>





*** User 2024-04-24 17:28:28.412 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 in
<presence from='alice_remove_mam_pm_765@domain.example.com/res1' to='alice_remove_mam_pm_765@domain.example.com/res1'/>





*** User 2024-04-24 17:28:28.413 ***🔗
bOb_remove_mam_pm_765@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 2024-04-24 17:28:28.413 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='a7f4ff47423b1a41' from='domain.example.com' version='1.0' xml:lang='en'>



*** User 2024-04-24 17:28:28.413 ***🔗
bOb_remove_mam_pm_765@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 2024-04-24 17:28:28.414 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 out
<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZW1vdmVfbWFtX3BtXzc2NQBtYWtyb2xpa2E=</auth>





*** User 2024-04-24 17:28:28.415 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 in
<success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>





*** User 2024-04-24 17:28:28.415 ***🔗
bOb_remove_mam_pm_765@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 2024-04-24 17:28:28.415 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 in
<stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='3613b18bbaa64d29' from='domain.example.com' version='1.0' xml:lang='en' to='bob_remove_mam_pm_765@domain.example.com'>



*** User 2024-04-24 17:28:28.415 ***🔗
bOb_remove_mam_pm_765@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 2024-04-24 17:28:28.415 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 out
<iq type='set' id='f4d0dba4913a2b77976732fff6cf1979'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<resource>res1</resource>
	</bind>
</iq>





*** User 2024-04-24 17:28:28.416 ***🔗
bOb_remove_mam_pm_765@domain.example.com/res1 in
<iq id='f4d0dba4913a2b77976732fff6cf1979' type='result'>
	<bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>
		<jid>bob_remove_mam_pm_765@domain.example.com/res1</jid>
	</bind>
</iq>





*** User 2024-04-24 17:28:28.416 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 out
<iq type='set' id='05f3f7bf37e437e9223f5543a2ffac5b'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>





*** User 2024-04-24 17:28:28.416 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 in
<iq from='domain.example.com' to='bob_remove_mam_pm_765@domain.example.com/res1' id='05f3f7bf37e437e9223f5543a2ffac5b' type='result'>
	<session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>
</iq>





*** User 2024-04-24 17:28:28.416 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 out
<presence/>





*** User 2024-04-24 17:28:28.419 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 in
<presence from='bob_remove_mam_pm_765@domain.example.com/res1' to='bob_remove_mam_pm_765@domain.example.com/res1'/>





*** User 2024-04-24 17:28:28.419 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 out
<message type='chat' to='bob_remove_mam_pm_765@domain.example.com/res1'>
	<body>1remove_mam_pm message</body>
</message>





*** User 2024-04-24 17:28:28.419 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 out
<message type='chat' to='alice_remove_mam_pm_765@domain.example.com/res1'>
	<body>2remove_mam_pm message message</body>
</message>





*** User 2024-04-24 17:28:28.419 ***🔗
alice_remove_mam_pm_765@domain.example.com/res1 out
<message type='chat' to='bob_remove_mam_pm_765@domain.example.com/res1'>
	<body>3remove_mam_pm message message</body>
</message>





*** System report during gdpr_SUITE:remove_mam_pm/1 in remove_personal_data_mam_rdbms 2024-04-24 17:28:28.423 ***🔗
=WARNING REPORT==== 24-Apr-2024::17:28:28.422289 ===
    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_remove_mam_pm_765).[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,23},
                           [<<97,0,108,0,105,0,99,0,101,0,95,0,114,0,101,
                              0,109,0,111,0,118,0,101,0,95,0,109,0,97,0,
                              109,0,95,0,112,0,109,0,95,0,55,0,54,0,53,0>>]}]}}
    user: <<"alice_remove_mam_pm_765">>
    host: <<"test type">>
    server: <<"domain.example.com">>
    what: create_user_archive_failed




*** User 2024-04-24 17:28:30.465 ***🔗
waiting for archive_size is done in 2000 miliseconds



*** User 2024-04-24 17:28:30.466 ***🔗
waiting for archive_size is done in 0 miliseconds



*** User 2024-04-24 17:28:30.751 ***🔗
Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl  account removeUser --user alice_remove_mam_pm_765@domain.example.com/res1
Result "{\n  \"data\" : {\n    \"account\" : {\n      \"removeUser\" : {\n        \"message\" : \"User alice_remove_mam_pm_765@domain.example.com/res1 successfully unregistered\",\n        \"jid\" : \"alice_remove_mam_pm_765@domain.example.com/res1\"\n      }\n    }\n  }\n}\n"
ExitStatus 0



*** User 2024-04-24 17:28:30.751 ***🔗
ResultString:
{
  "data" : {
    "account" : {
      "removeUser" : {
        "message" : "User alice_remove_mam_pm_765@domain.example.com/res1 successfully unregistered",
        "jid" : "alice_remove_mam_pm_765@domain.example.com/res1"
      }
    }
  }
}




*** User 2024-04-24 17:28:30.756 ***🔗
waiting for timeout is done in 0 miliseconds



*** User 2024-04-24 17:28:31.074 ***🔗
Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl  gdpr retrievePersonalData --domain domain.example.com --resultFilepath remove_mam_pm.1713979710756181239.zip --username bob_remove_mam_pm_765
Result "{\n  \"data\" : {\n    \"gdpr\" : {\n      \"retrievePersonalData\" : \"Data retrieved\"\n    }\n  }\n}\n"
ExitStatus 0



*** User 2024-04-24 17:28:31.074 ***🔗
ResultString:
{
  "data" : {
    "gdpr" : {
      "retrievePersonalData" : "Data retrieved"
    }
  }
}




*** User 2024-04-24 17:28:31.074 ***🔗
extracting logs remove_mam_pm.1713979710756181239.zip.bob_remove_mam_pm_765.unzipped



*** User 2024-04-24 17:28:31.076 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 out
</stream:stream>



*** User 2024-04-24 17:28:31.076 ***🔗
bob_remove_mam_pm_765@domain.example.com/res1 in
</stream:stream>

*** CT 2024-04-24 17:28:31.093 *** View log from node mongooseim@localhost when finished🔗
mongooseim@localhost_1485.html





=== Ended at 2024-04-24 17:28:31
=== successfully completed test case
=== === Returned value: ok






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



Copyright © 2024 Open Telecom Platform

Updated: Wed Apr 24 2024 17:28:28