=== Test case: gdpr_SUITE:retrieve_mam_pm/1 (click for source code)
=== Config value:
[{mam_backend,rdbms},
{watchdog,<0.14775.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@e84896a28784.2023-12-20_12.31.47/big_tests.tests.gdpr_SUITE.logs/run.2023-12-20_12.33.33/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@e84896a28784.2023-12-20_12.31.47/big_tests.tests.gdpr_SUITE.logs/run.2023-12-20_12.33.33/log_private/"},
{{saved_modules,mongooseim@localhost,<<"localhost">>},
#{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_sic => #{iqdisc => one_queue},
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_disco =>
#{iqdisc => one_queue,users_can_see_hidden_services => false,
server_info => [],extra_domains => []},
mod_presence => #{},
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_adhoc => #{iqdisc => one_queue,report_commands_node => false},
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@e84896a28784.2023-12-20_12.31.47"
=== Started at 2023-12-20 12:33:52
*** User 2023-12-20 12:33:52.280 ***🔗 required modules: [{mod_mam,#{cache => #{module => internal,strategy => fifo, number_of_segments => 3, time_to_live => 480}, is_archivable_message => mod_mam_utils, max_result_limit => 50, default_result_limit => 50, enforce_simple_queries => false, send_message => mod_mam_utils, archive_chat_markers => false,backend => rdbms, pm => #{archive_groupchats => false, same_mam_id_for_peers => false}, async_writer => #{enabled => true,batch_size => 30, flush_interval => 2000,pool_size => 16}, full_text_search => true, message_retraction => true, no_stanzaid_element => false, cache_users => true}}]
*** User 2023-12-20 12:33:52.289 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2023-12-20 12:33:52.289 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='1a07e7ada70989e6' from='localhost' version='1.0' xml:lang='en'>
*** User 2023-12-20 12:33:52.289 ***🔗 alicE_retrieve_mam_pm_727@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 2023-12-20 12:33:52.289 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JldHJpZXZlX21hbV9wbV83MjcAbWF0eWdyeXNh</auth>
*** User 2023-12-20 12:33:52.291 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2023-12-20 12:33:52.291 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2023-12-20 12:33:52.291 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='34888c81bbe2e7a4' from='localhost' version='1.0' xml:lang='en' to='alice_retrieve_mam_pm_727@localhost'>
*** User 2023-12-20 12:33:52.291 ***🔗 alicE_retrieve_mam_pm_727@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 2023-12-20 12:33:52.291 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 out <iq type='set' id='6391fe4f9a479407cbcf72101fe5397f'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2023-12-20 12:33:52.292 ***🔗 alicE_retrieve_mam_pm_727@localhost/res1 in <iq id='6391fe4f9a479407cbcf72101fe5397f' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_retrieve_mam_pm_727@localhost/res1</jid> </bind> </iq>
*** User 2023-12-20 12:33:52.292 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 out <iq type='set' id='e518dfbf283a2c28316809d6237a04b4'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2023-12-20 12:33:52.292 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 in <iq from='localhost' to='alice_retrieve_mam_pm_727@localhost/res1' id='e518dfbf283a2c28316809d6237a04b4' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2023-12-20 12:33:52.292 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 out <presence/>
*** User 2023-12-20 12:33:52.295 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 in <presence from='alice_retrieve_mam_pm_727@localhost/res1' to='alice_retrieve_mam_pm_727@localhost/res1'/>
*** User 2023-12-20 12:33:52.295 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2023-12-20 12:33:52.296 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='a509379613782190' from='localhost' version='1.0' xml:lang='en'>
*** User 2023-12-20 12:33:52.296 ***🔗 bOb_retrieve_mam_pm_727@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 2023-12-20 12:33:52.296 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZXRyaWV2ZV9tYW1fcG1fNzI3AG1ha3JvbGlrYQ==</auth>
*** User 2023-12-20 12:33:52.297 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2023-12-20 12:33:52.298 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 out <stream:stream to='localhost' version='1.0' xml:lang='en' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams'>
*** User 2023-12-20 12:33:52.298 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='6c078a2f7e30cee9' from='localhost' version='1.0' xml:lang='en' to='bob_retrieve_mam_pm_727@localhost'>
*** User 2023-12-20 12:33:52.298 ***🔗 bOb_retrieve_mam_pm_727@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 2023-12-20 12:33:52.298 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 out <iq type='set' id='f75f32d456a290b83552e146fb0add93'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2023-12-20 12:33:52.299 ***🔗 bOb_retrieve_mam_pm_727@localhost/res1 in <iq id='f75f32d456a290b83552e146fb0add93' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_retrieve_mam_pm_727@localhost/res1</jid> </bind> </iq>
*** User 2023-12-20 12:33:52.299 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 out <iq type='set' id='18e241be1662d75ec9ea8c6b33c125fc'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2023-12-20 12:33:52.300 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 in <iq from='localhost' to='bob_retrieve_mam_pm_727@localhost/res1' id='18e241be1662d75ec9ea8c6b33c125fc' type='result'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2023-12-20 12:33:52.300 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 out <presence/>
*** User 2023-12-20 12:33:52.302 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 in <presence from='bob_retrieve_mam_pm_727@localhost/res1' to='bob_retrieve_mam_pm_727@localhost/res1'/>
*** User 2023-12-20 12:33:52.302 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 out <message type='chat' to='bob_retrieve_mam_pm_727@localhost/res1'> <body>1some simple pm message</body> </message>
*** User 2023-12-20 12:33:52.303 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 out <message type='chat' to='alice_retrieve_mam_pm_727@localhost/res1'> <body>2another simple pm message</body> </message>
*** User 2023-12-20 12:33:52.303 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 out <message type='chat' to='bob_retrieve_mam_pm_727@localhost/res1'> <body>3third simple pm message</body> </message>
*** System report during gdpr_SUITE:retrieve_mam_pm/1 in retrieve_personal_data_mam_rdbms 2023-12-20 12:33:52.306 ***🔗 =WARNING REPORT==== 20-Dec-2023::12:33:52.305595 === 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_retrieve_mam_pm_727).[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,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,55,0, 50,0,55,0>>]}]}} user: <<"alice_retrieve_mam_pm_727">> host: <<"localhost">> server: <<"localhost">> what: create_user_archive_failed
*** User 2023-12-20 12:33:54.349 ***🔗 waiting for archive_size is done in 2000 miliseconds
*** User 2023-12-20 12:33:54.350 ***🔗 waiting for archive_size is done in 0 miliseconds
*** User 2023-12-20 12:33:54.643 ***🔗 Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl gdpr retrievePersonalData --domain localhost --resultFilepath retrieve_mam_pm.1703075634350076509.zip --username alice_retrieve_mam_pm_727 Result "{\n \"data\" : {\n \"gdpr\" : {\n \"retrievePersonalData\" : \"Data retrieved\"\n }\n }\n}\n" ExitStatus 0
*** User 2023-12-20 12:33:54.643 ***🔗 ResultString: { "data" : { "gdpr" : { "retrievePersonalData" : "Data retrieved" } } }
*** User 2023-12-20 12:33:54.643 ***🔗 extracting logs retrieve_mam_pm.1703075634350076509.zip.alice_retrieve_mam_pm_727.unzipped
*** User 2023-12-20 12:33:54.934 ***🔗 Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl gdpr retrievePersonalData --domain localhost --resultFilepath retrieve_mam_pm.1703075634644770139.zip --username bob_retrieve_mam_pm_727 Result "{\n \"data\" : {\n \"gdpr\" : {\n \"retrievePersonalData\" : \"Data retrieved\"\n }\n }\n}\n" ExitStatus 0
*** User 2023-12-20 12:33:54.934 ***🔗 ResultString: { "data" : { "gdpr" : { "retrievePersonalData" : "Data retrieved" } } }
*** User 2023-12-20 12:33:54.934 ***🔗 extracting logs retrieve_mam_pm.1703075634644770139.zip.bob_retrieve_mam_pm_727.unzipped
*** User 2023-12-20 12:33:54.935 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 out </stream:stream>
*** User 2023-12-20 12:33:54.936 ***🔗 bob_retrieve_mam_pm_727@localhost/res1 in </stream:stream>
*** User 2023-12-20 12:33:54.936 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 out </stream:stream>
*** User 2023-12-20 12:33:54.936 ***🔗 alice_retrieve_mam_pm_727@localhost/res1 in </stream:stream>
=== Ended at 2023-12-20 12:33:54 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result