=== Test case: gdpr_SUITE:remove_mam_pm/1 (click for source code) === Config value: [{mam_backend,rdbms}, {watchdog,<0.16643.0>}, {{ejabberd_cwd,mongooseim@localhost}, "/home/circleci/project/_build/mim1/rel/mongooseim"}, {mim_data_dir,"/home/circleci/project/big_tests/tests/gdpr_SUITE_data"}, {preset,"odbc_mssql_mnesia"}, {tc_logfile,"/home/circleci/project/big_tests/ct_report/ct_run.test@f0b09cc3aef4.2022-05-25_09.03.38/big_tests.tests.gdpr_SUITE.logs/run.2022-05-25_09.05.39/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@f0b09cc3aef4.2022-05-25_09.03.38/big_tests.tests.gdpr_SUITE.logs/run.2022-05-25_09.05.39/log_private/"}, {{saved_modules,mongooseim@localhost,<<"test type">>}, #{mod_adhoc => #{iqdisc => one_queue,report_commands_node => false}, mod_amp => #{}, mod_bosh => #{backend => mnesia,inactivity => 30,max_pause => 120, max_wait => infinity,server_acks => false}, mod_cache_users => #{number_of_segments => 5,strategy => fifo,time_to_live => 2}, mod_carboncopy => #{iqdisc => no_queue}, mod_commands => #{}, mod_disco => #{extra_domains => [],iqdisc => one_queue,server_info => [], users_can_see_hidden_services => false}, mod_muc_commands => #{},mod_muc_light_commands => #{}, mod_register => #{access => register, ip_access => [{allow,"127.0.0.0/8"},{deny,"0.0.0.0/0"}], iqdisc => one_queue,password_strength => 0, registration_watchers => []}, mod_roster => #{backend => rdbms,iqdisc => one_queue,store_current_id => false, versioning => false}, mod_sic => #{iqdisc => one_queue}, mod_stream_management => #{ack => true,ack_freq => 1,backend => mnesia,buffer => true, buffer_max => 100,resume_timeout => 600, stale_h => #{enabled => false,geriatric => 3600,repeat_after => 1800}}, mod_vcard => #{backend => rdbms, host => {prefix,<<"vjud.">>}, iqdisc => parallel,matches => 30,search => true}}}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@f0b09cc3aef4.2022-05-25_09.03.38" === Started at 2022-05-25 09:06:16
*** User 2022-05-25 09:06:16.255 *** required modules: [{mod_mam_meta,#{archive_chat_markers => false, async_writer => #{batch_size => 30,enabled => true, flush_interval => 2000, pool_size => 16}, backend => rdbms, cache => #{module => internal, number_of_segments => 3, strategy => fifo,time_to_live => 480}, cache_users => true, default_result_limit => 50, full_text_search => true, is_archivable_message => mod_mam_utils, max_result_limit => 50, message_retraction => true, no_stanzaid_element => false, pm => #{archive_groupchats => false, same_mam_id_for_peers => false}, send_message => mod_mam_utils}}]
*** User 2022-05-25 09:06:16.262 *** alicE_remove_mam_pm_725@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 2022-05-25 09:06:16.263 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='a769a218f9376377' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:06:16.263 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <stream:features> <starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/> <compression xmlns='http://jabber.org/features/compress'> <method>zlib</method> </compression> <mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'> <mechanism>SCRAM-SHA-256</mechanism> <mechanism>PLAIN</mechanism> </mechanisms> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2022-05-25 09:06:16.264 *** alicE_remove_mam_pm_725@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JlbW92ZV9tYW1fcG1fNzI1AG1hdHlncnlzYQ==</auth>
*** User 2022-05-25 09:06:16.265 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-05-25 09:06:16.265 *** alicE_remove_mam_pm_725@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 2022-05-25 09:06:16.266 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='c194c350873b5b26' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:06:16.266 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <stream:features> <compression xmlns='http://jabber.org/features/compress'> <method>zlib</method> </compression> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'/> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2022-05-25 09:06:16.266 *** alicE_remove_mam_pm_725@domain.example.com/res1 out <iq type='set' id='0d8ec17fac02e0e837208025c3d6b5ce'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-05-25 09:06:16.266 *** alicE_remove_mam_pm_725@domain.example.com/res1 in <iq id='0d8ec17fac02e0e837208025c3d6b5ce' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_remove_mam_pm_725@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-05-25 09:06:16.266 *** alice_remove_mam_pm_725@domain.example.com/res1 out <iq type='set' id='1103f8f634ca504220302cacc883beb2'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:06:16.266 *** alice_remove_mam_pm_725@domain.example.com/res1 in <iq type='result' id='1103f8f634ca504220302cacc883beb2'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:06:16.266 *** alice_remove_mam_pm_725@domain.example.com/res1 out <presence/>
*** User 2022-05-25 09:06:16.270 *** alice_remove_mam_pm_725@domain.example.com/res1 in <presence from='alice_remove_mam_pm_725@domain.example.com/res1' to='alice_remove_mam_pm_725@domain.example.com/res1' xml:lang='en'/>
*** User 2022-05-25 09:06:16.270 *** bOb_remove_mam_pm_725@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 2022-05-25 09:06:16.271 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='4b5a65c207bdfbb6' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:06:16.271 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <stream:features> <starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/> <compression xmlns='http://jabber.org/features/compress'> <method>zlib</method> </compression> <mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'> <mechanism>SCRAM-SHA-256</mechanism> <mechanism>PLAIN</mechanism> </mechanisms> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2022-05-25 09:06:16.271 *** bOb_remove_mam_pm_725@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZW1vdmVfbWFtX3BtXzcyNQBtYWtyb2xpa2E=</auth>
*** User 2022-05-25 09:06:16.272 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-05-25 09:06:16.272 *** bOb_remove_mam_pm_725@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 2022-05-25 09:06:16.272 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='151454105af82a13' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:06:16.272 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <stream:features> <compression xmlns='http://jabber.org/features/compress'> <method>zlib</method> </compression> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'/> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> <register xmlns='http://jabber.org/features/iq-register'/> <amp xmlns='http://jabber.org/feature/amp'/> <sm xmlns='urn:xmpp:sm:3'/> </stream:features>
*** User 2022-05-25 09:06:16.273 *** bOb_remove_mam_pm_725@domain.example.com/res1 out <iq type='set' id='bdfa1e28a02c8a9cc3aa2a836aff6a36'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-05-25 09:06:16.273 *** bOb_remove_mam_pm_725@domain.example.com/res1 in <iq id='bdfa1e28a02c8a9cc3aa2a836aff6a36' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_remove_mam_pm_725@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-05-25 09:06:16.273 *** bob_remove_mam_pm_725@domain.example.com/res1 out <iq type='set' id='bc560b09683d8c058cb67839fffd5527'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:06:16.273 *** bob_remove_mam_pm_725@domain.example.com/res1 in <iq type='result' id='bc560b09683d8c058cb67839fffd5527'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:06:16.273 *** bob_remove_mam_pm_725@domain.example.com/res1 out <presence/>
*** User 2022-05-25 09:06:16.277 *** bob_remove_mam_pm_725@domain.example.com/res1 in <presence from='bob_remove_mam_pm_725@domain.example.com/res1' to='bob_remove_mam_pm_725@domain.example.com/res1' xml:lang='en'/>
*** User 2022-05-25 09:06:16.278 *** alice_remove_mam_pm_725@domain.example.com/res1 out <message to='bob_remove_mam_pm_725@domain.example.com/res1' type='chat'> <body>1remove_mam_pm message</body> </message>
*** User 2022-05-25 09:06:16.278 *** bob_remove_mam_pm_725@domain.example.com/res1 out <message to='alice_remove_mam_pm_725@domain.example.com/res1' type='chat'> <body>2remove_mam_pm message message</body> </message>
*** User 2022-05-25 09:06:16.278 *** alice_remove_mam_pm_725@domain.example.com/res1 out <message to='bob_remove_mam_pm_725@domain.example.com/res1' type='chat'> <body>3remove_mam_pm message message</body> </message>
*** System report during gdpr_SUITE:remove_mam_pm/1 in remove_personal_data_mam_rdbms 2022-05-25 09:06:16.282 *** =WARNING REPORT==== 25-May-2022::09:06:16.281804 === host: <<"test type">> reason: {error,#{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,50,0,53,0>>]}], odbc_query => <<"INSERT INTO mam_server_user (server, user_name) VALUES (?, ?)">>, 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_725).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000"}} server: <<"domain.example.com">> user: <<"alice_remove_mam_pm_725">> what: create_user_archive_failed
*** User 2022-05-25 09:06:18.529 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl unregister alice_remove_mam_pm_725 domain.example.com Result "User alice_remove_mam_pm_725@domain.example.com successfully unregistered\n" ExitStatus 0
*** User 2022-05-25 09:06:18.741 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data bob_remove_mam_pm_725 domain.example.com remove_mam_pm.1653469578533174821.zip Result [] ExitStatus 0
*** User 2022-05-25 09:06:18.742 *** extracting logs remove_mam_pm.1653469578533174821.zip.bob_remove_mam_pm_725.unzipped
*** User 2022-05-25 09:06:18.743 *** bob_remove_mam_pm_725@domain.example.com/res1 out </stream:stream>
*** User 2022-05-25 09:06:18.743 *** bob_remove_mam_pm_725@domain.example.com/res1 in </stream:stream>
=== Ended at 2022-05-25 09:06:18 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result