=== Test case: gdpr_SUITE:retrieve_mam_pm/1 (click for source code) === Config value: [{mam_backend,rdbms}, {watchdog,<0.15768.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@998557c7e1d1.2022-01-27_12.27.57/big_tests.tests.gdpr_SUITE.logs/run.2022-01-27_12.29.55/gdpr_suite.retrieve_mam_pm.html"}, {tc_group_properties,[{name,retrieve_personal_data_mam_rdbms}]}, {tc_group_path,[[{name,retrieve_personal_data_mam}], [{name,retrieve_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@998557c7e1d1.2022-01-27_12.27.57/big_tests.tests.gdpr_SUITE.logs/run.2022-01-27_12.29.55/log_private/"}, {{saved_modules,mongooseim@localhost,<<"test type">>}, #{mod_adhoc => [],mod_amp => [],mod_bosh => [], mod_cache_users => [{number_of_segments,5},{time_to_live,2}], mod_carboncopy => [],mod_commands => [], mod_disco => [{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"}]}, {welcome_message,{[],[]}}], mod_roster => [{backend,rdbms}], mod_sic => [],mod_stream_management => [], mod_vcard => [{backend,rdbms},{host,{prefix,<<"vjud.">>}}]}}] === Current directory is "/home/circleci/project/big_tests/ct_report/ct_run.test@998557c7e1d1.2022-01-27_12.27.57" === Started at 2022-01-27 12:30:08
*** User 2022-01-27 12:30:08.303 *** required modules: [{mod_mam_meta,[{backend,rdbms}, {pm,[{archive_groupchats,false}]}]}]
*** User 2022-01-27 12:30:08.311 *** alicE_retrieve_mam_pm_685@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-01-27 12:30:08.312 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='ab370ed832458e9b' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-01-27 12:30:08.312 *** alicE_retrieve_mam_pm_685@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-01-27 12:30:08.312 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JldHJpZXZlX21hbV9wbV82ODUAbWF0eWdyeXNh</auth>
*** User 2022-01-27 12:30:08.313 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-01-27 12:30:08.313 *** alicE_retrieve_mam_pm_685@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-01-27 12:30:08.314 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='1ffa0997c54ee4ca' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-01-27 12:30:08.315 *** alicE_retrieve_mam_pm_685@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-01-27 12:30:08.315 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <iq type='set' id='3aa40409c029d00e496f9fa9c30ca923'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-01-27 12:30:08.315 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <iq id='3aa40409c029d00e496f9fa9c30ca923' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alicE_retrieve_mam_pm_685@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-01-27 12:30:08.315 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <iq type='set' id='3fd5fa64c3b1cebc3ffcce032bf31521'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-01-27 12:30:08.316 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <iq type='result' id='3fd5fa64c3b1cebc3ffcce032bf31521'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-01-27 12:30:08.316 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <presence/>
*** User 2022-01-27 12:30:08.318 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in <presence from='alicE_retrieve_mam_pm_685@domain.example.com/res1' to='alice_retrieve_mam_pm_685@domain.example.com/res1' xml:lang='en'/>
*** User 2022-01-27 12:30:08.319 *** bOb_retrieve_mam_pm_685@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-01-27 12:30:08.319 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='17184cfab3d08502' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-01-27 12:30:08.320 *** bOb_retrieve_mam_pm_685@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-01-27 12:30:08.320 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZXRyaWV2ZV9tYW1fcG1fNjg1AG1ha3JvbGlrYQ==</auth>
*** User 2022-01-27 12:30:08.321 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-01-27 12:30:08.321 *** bOb_retrieve_mam_pm_685@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-01-27 12:30:08.321 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='0aae21f57fc80609' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-01-27 12:30:08.321 *** bOb_retrieve_mam_pm_685@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-01-27 12:30:08.321 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out <iq type='set' id='56acad07ee0a2a5cebc14d86c86e441a'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-01-27 12:30:08.322 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <iq id='56acad07ee0a2a5cebc14d86c86e441a' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bOb_retrieve_mam_pm_685@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-01-27 12:30:08.322 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out <iq type='set' id='653477341acd2a6180efa48aa331a295'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-01-27 12:30:08.322 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <iq type='result' id='653477341acd2a6180efa48aa331a295'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-01-27 12:30:08.322 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out <presence/>
*** User 2022-01-27 12:30:08.325 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in <presence from='bOb_retrieve_mam_pm_685@domain.example.com/res1' to='bob_retrieve_mam_pm_685@domain.example.com/res1' xml:lang='en'/>
*** User 2022-01-27 12:30:08.326 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <message to='bOb_retrieve_mam_pm_685@domain.example.com/res1' type='chat'> <body>1some simple pm message</body> </message>
*** User 2022-01-27 12:30:08.326 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out <message to='alicE_retrieve_mam_pm_685@domain.example.com/res1' type='chat'> <body>2another simple pm message</body> </message>
*** User 2022-01-27 12:30:08.326 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out <message to='bOb_retrieve_mam_pm_685@domain.example.com/res1' type='chat'> <body>3third simple pm message</body> </message>
*** System report during gdpr_SUITE:retrieve_mam_pm/1 in retrieve_personal_data_mam_rdbms 2022-01-27 12:30:08.333 *** =WARNING REPORT==== 27-Jan-2022::12:30:08.333160 === 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,25}, [<<97,0,108,0,105,0,99,0,101,0,95,0,114,0,101,0, 116,0,114,0,105,0,101,0,118,0,101,0,95,0,109, 0,97,0,109,0,95,0,112,0,109,0,95,0,54,0,56,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_retrieve_mam_pm_685).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000"}} server: <<"domain.example.com">> user: <<"alice_retrieve_mam_pm_685">> what: create_user_archive_failed
*** User 2022-01-27 12:30:10.639 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data alicE_retrieve_mam_pm_685 domain.example.com retrieve_mam_pm.1643286610379474813.zip Result [] ExitStatus 0
*** User 2022-01-27 12:30:10.640 *** extracting logs retrieve_mam_pm.1643286610379474813.zip.alicE_retrieve_mam_pm_685.unzipped
*** User 2022-01-27 12:30:10.892 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data bOb_retrieve_mam_pm_685 domain.example.com retrieve_mam_pm.1643286610641826969.zip Result [] ExitStatus 0
*** User 2022-01-27 12:30:10.893 *** extracting logs retrieve_mam_pm.1643286610641826969.zip.bOb_retrieve_mam_pm_685.unzipped
*** User 2022-01-27 12:30:10.894 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 out </stream:stream>
*** User 2022-01-27 12:30:10.895 *** bOb_retrieve_mam_pm_685@domain.example.com/res1 in </stream:stream>
*** User 2022-01-27 12:30:10.895 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 out </stream:stream>
*** User 2022-01-27 12:30:10.895 *** alicE_retrieve_mam_pm_685@domain.example.com/res1 in </stream:stream>
=== Ended at 2022-01-27 12:30:10 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result