=== Test case: gdpr_SUITE:remove_mam_pm/1 (click for source code) === Config value: [{mam_backend,rdbms}, {watchdog,<0.15069.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@0d9462abd854.2024-04-10_12.44.09/big_tests.tests.gdpr_SUITE.logs/run.2024-04-10_12.45.51/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@0d9462abd854.2024-04-10_12.44.09/big_tests.tests.gdpr_SUITE.logs/run.2024-04-10_12.45.51/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_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_amp => #{},mod_presence => #{}, mod_disco => #{iqdisc => one_queue,users_can_see_hidden_services => false, server_info => [],extra_domains => []}, mod_adhoc => #{iqdisc => one_queue,report_commands_node => false}, mod_stream_management => #{buffer => true,ack => true, stale_h => #{enabled => false,repeat_after => 1800,geriatric => 3600}, backend => mnesia,buffer_max => 100,ack_freq => 1, resume_timeout => 600}, mod_cache_users => #{strategy => fifo,number_of_segments => 5,time_to_live => 2}, mod_bosh => #{backend => mnesia,inactivity => 30,max_pause => 120, max_wait => infinity,server_acks => false}, mod_carboncopy => #{iqdisc => no_queue}}}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@0d9462abd854.2024-04-10_12.44.09" === Started at 2024-04-10 12:46:31
*** User 2024-04-10 12:46:32.013 ***🔗 required modules: [{mod_mam,#{cache => #{module => internal,strategy => fifo, number_of_segments => 3, time_to_live => 480}, send_message => mod_mam_utils, max_result_limit => 50, async_writer => #{enabled => true,pool_size => 16, batch_size => 30,flush_interval => 2000}, 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,backend => rdbms, full_text_search => true, no_stanzaid_element => false, message_retraction => true, cache_users => true}}]
*** User 2024-04-10 12:46:32.031 ***🔗 alicE_remove_mam_pm_753@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-10 12:46:32.032 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='3eb8426d20864582' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2024-04-10 12:46:32.032 ***🔗 alicE_remove_mam_pm_753@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-10 12:46:32.032 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JlbW92ZV9tYW1fcG1fNzUzAG1hdHlncnlzYQ==</auth>
*** User 2024-04-10 12:46:32.033 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-04-10 12:46:32.033 ***🔗 alicE_remove_mam_pm_753@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-10 12:46:32.033 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='cdb5513b89812988' from='domain.example.com' version='1.0' xml:lang='en' to='alice_remove_mam_pm_753@domain.example.com'>
*** User 2024-04-10 12:46:32.034 ***🔗 alicE_remove_mam_pm_753@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-10 12:46:32.034 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 out <iq type='set' id='27a6a89eb16a4f391bf9f9f292ccf8ee'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-04-10 12:46:32.034 ***🔗 alicE_remove_mam_pm_753@domain.example.com/res1 in <iq id='27a6a89eb16a4f391bf9f9f292ccf8ee' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_remove_mam_pm_753@domain.example.com/res1</jid> </bind> </iq>
*** User 2024-04-10 12:46:32.034 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 out <iq type='set' id='e9ab850ece6dbfe7d94cd3f2df4d4381'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 12:46:32.035 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 in <iq from='domain.example.com' to='alice_remove_mam_pm_753@domain.example.com/res1' id='e9ab850ece6dbfe7d94cd3f2df4d4381' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 12:46:32.035 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 out <presence/>
*** User 2024-04-10 12:46:32.039 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 in <presence from='alice_remove_mam_pm_753@domain.example.com/res1' to='alice_remove_mam_pm_753@domain.example.com/res1'/>
*** User 2024-04-10 12:46:32.040 ***🔗 bOb_remove_mam_pm_753@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-10 12:46:32.040 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='63b4aa7e0e461e49' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2024-04-10 12:46:32.040 ***🔗 bOb_remove_mam_pm_753@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-10 12:46:32.040 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZW1vdmVfbWFtX3BtXzc1MwBtYWtyb2xpa2E=</auth>
*** User 2024-04-10 12:46:32.042 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2024-04-10 12:46:32.042 ***🔗 bOb_remove_mam_pm_753@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-10 12:46:32.042 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='c1dd25de88840b8e' from='domain.example.com' version='1.0' xml:lang='en' to='bob_remove_mam_pm_753@domain.example.com'>
*** User 2024-04-10 12:46:32.042 ***🔗 bOb_remove_mam_pm_753@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-10 12:46:32.042 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 out <iq type='set' id='bc7dad89b86473a3e25c56e973b4c0d8'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2024-04-10 12:46:32.043 ***🔗 bOb_remove_mam_pm_753@domain.example.com/res1 in <iq id='bc7dad89b86473a3e25c56e973b4c0d8' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_remove_mam_pm_753@domain.example.com/res1</jid> </bind> </iq>
*** User 2024-04-10 12:46:32.043 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 out <iq type='set' id='d565582ff25c765c6bed438032d6bd02'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 12:46:32.043 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 in <iq from='domain.example.com' to='bob_remove_mam_pm_753@domain.example.com/res1' id='d565582ff25c765c6bed438032d6bd02' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2024-04-10 12:46:32.043 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 out <presence/>
*** User 2024-04-10 12:46:32.046 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 in <presence from='bob_remove_mam_pm_753@domain.example.com/res1' to='bob_remove_mam_pm_753@domain.example.com/res1'/>
*** User 2024-04-10 12:46:32.046 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 out <message type='chat' to='bob_remove_mam_pm_753@domain.example.com/res1'> <body>1remove_mam_pm message</body> </message>
*** User 2024-04-10 12:46:32.046 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 out <message type='chat' to='alice_remove_mam_pm_753@domain.example.com/res1'> <body>2remove_mam_pm message message</body> </message>
*** User 2024-04-10 12:46:32.046 ***🔗 alice_remove_mam_pm_753@domain.example.com/res1 out <message type='chat' to='bob_remove_mam_pm_753@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-10 12:46:32.049 ***🔗 =WARNING REPORT==== 10-Apr-2024::12:46:32.049287 === 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_753).[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,53,0,51,0>>]}]}} user: <<"alice_remove_mam_pm_753">> host: <<"test type">> server: <<"domain.example.com">> what: create_user_archive_failed
*** User 2024-04-10 12:46:34.194 ***🔗 waiting for archive_size is done in 2100 miliseconds
*** User 2024-04-10 12:46:34.195 ***🔗 waiting for archive_size is done in 0 miliseconds
*** User 2024-04-10 12:46:34.538 ***🔗 Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl account removeUser --user alice_remove_mam_pm_753@domain.example.com/res1 Result "{\n \"data\" : {\n \"account\" : {\n \"removeUser\" : {\n \"message\" : \"User alice_remove_mam_pm_753@domain.example.com/res1 successfully unregistered\",\n \"jid\" : \"alice_remove_mam_pm_753@domain.example.com/res1\"\n }\n }\n }\n}\n" ExitStatus 0
*** User 2024-04-10 12:46:34.538 ***🔗 ResultString: { "data" : { "account" : { "removeUser" : { "message" : "User alice_remove_mam_pm_753@domain.example.com/res1 successfully unregistered", "jid" : "alice_remove_mam_pm_753@domain.example.com/res1" } } } }
*** User 2024-04-10 12:46:34.542 ***🔗 waiting for timeout is done in 0 miliseconds
*** User 2024-04-10 12:46:34.896 ***🔗 Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl gdpr retrievePersonalData --domain domain.example.com --resultFilepath remove_mam_pm.1712753194542760201.zip --username bob_remove_mam_pm_753 Result "{\n \"data\" : {\n \"gdpr\" : {\n \"retrievePersonalData\" : \"Data retrieved\"\n }\n }\n}\n" ExitStatus 0
*** User 2024-04-10 12:46:34.896 ***🔗 ResultString: { "data" : { "gdpr" : { "retrievePersonalData" : "Data retrieved" } } }
*** User 2024-04-10 12:46:34.896 ***🔗 extracting logs remove_mam_pm.1712753194542760201.zip.bob_remove_mam_pm_753.unzipped
*** User 2024-04-10 12:46:34.897 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 out </stream:stream>
*** User 2024-04-10 12:46:34.898 ***🔗 bob_remove_mam_pm_753@domain.example.com/res1 in </stream:stream>
=== Ended at 2024-04-10 12:46:34 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result