=== Test case: gdpr_SUITE:retrieve_mam_pm/1 (click for source code)
=== Config value:
[{mam_backend,rdbms},
{watchdog,<0.16227.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.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@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:05:50
*** User 2022-05-25 09:05:50.393 ***
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:05:50.407 *** alicE_retrieve_mam_pm_708@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:05:50.407 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='50851f427ac4bbce' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:05:50.407 *** alicE_retrieve_mam_pm_708@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:05:50.407 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JldHJpZXZlX21hbV9wbV83MDgAbWF0eWdyeXNh</auth>
*** User 2022-05-25 09:05:50.409 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-05-25 09:05:50.409 *** alicE_retrieve_mam_pm_708@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:05:50.409 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='32c3cfe41382bba4' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:05:50.409 *** alicE_retrieve_mam_pm_708@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:05:50.409 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 out <iq type='set' id='3d11a334e6887a471fc0a1499a9044bd'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-05-25 09:05:50.410 *** alicE_retrieve_mam_pm_708@domain.example.com/res1 in <iq id='3d11a334e6887a471fc0a1499a9044bd' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alice_retrieve_mam_pm_708@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-05-25 09:05:50.410 *** alice_retrieve_mam_pm_708@domain.example.com/res1 out <iq type='set' id='a6da502179048c136a06478f7cd3804d'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:05:50.411 *** alice_retrieve_mam_pm_708@domain.example.com/res1 in <iq type='result' id='a6da502179048c136a06478f7cd3804d'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:05:50.411 *** alice_retrieve_mam_pm_708@domain.example.com/res1 out <presence/>
*** User 2022-05-25 09:05:50.413 *** alice_retrieve_mam_pm_708@domain.example.com/res1 in <presence from='alice_retrieve_mam_pm_708@domain.example.com/res1' to='alice_retrieve_mam_pm_708@domain.example.com/res1' xml:lang='en'/>
*** User 2022-05-25 09:05:50.414 *** bOb_retrieve_mam_pm_708@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:05:50.414 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='b8a00eefe6cc324d' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:05:50.415 *** bOb_retrieve_mam_pm_708@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:05:50.415 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZXRyaWV2ZV9tYW1fcG1fNzA4AG1ha3JvbGlrYQ==</auth>
*** User 2022-05-25 09:05:50.416 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-05-25 09:05:50.416 *** bOb_retrieve_mam_pm_708@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:05:50.416 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='ca8636786cb96f03' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-05-25 09:05:50.416 *** bOb_retrieve_mam_pm_708@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:05:50.417 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 out <iq type='set' id='ff03d1c7b5929971a799f4261fda15b0'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-05-25 09:05:50.417 *** bOb_retrieve_mam_pm_708@domain.example.com/res1 in <iq id='ff03d1c7b5929971a799f4261fda15b0' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bob_retrieve_mam_pm_708@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-05-25 09:05:50.417 *** bob_retrieve_mam_pm_708@domain.example.com/res1 out <iq type='set' id='bb5b9193f04da73bbb5c41209e422331'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:05:50.417 *** bob_retrieve_mam_pm_708@domain.example.com/res1 in <iq type='result' id='bb5b9193f04da73bbb5c41209e422331'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-05-25 09:05:50.418 *** bob_retrieve_mam_pm_708@domain.example.com/res1 out <presence/>
*** User 2022-05-25 09:05:50.420 *** bob_retrieve_mam_pm_708@domain.example.com/res1 in <presence from='bob_retrieve_mam_pm_708@domain.example.com/res1' to='bob_retrieve_mam_pm_708@domain.example.com/res1' xml:lang='en'/>
*** User 2022-05-25 09:05:50.420 *** alice_retrieve_mam_pm_708@domain.example.com/res1 out <message to='bob_retrieve_mam_pm_708@domain.example.com/res1' type='chat'> <body>1some simple pm message</body> </message>
*** User 2022-05-25 09:05:50.420 *** bob_retrieve_mam_pm_708@domain.example.com/res1 out <message to='alice_retrieve_mam_pm_708@domain.example.com/res1' type='chat'> <body>2another simple pm message</body> </message>
*** User 2022-05-25 09:05:50.420 *** alice_retrieve_mam_pm_708@domain.example.com/res1 out <message to='bob_retrieve_mam_pm_708@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-05-25 09:05:50.423 ***
=WARNING REPORT==== 25-May-2022::09:05:50.422728 ===
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,55,0,48,0,
56,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_708).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000"}}
server: <<"domain.example.com">>
user: <<"alice_retrieve_mam_pm_708">>
what: create_user_archive_failed
*** User 2022-05-25 09:05:52.669 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data alice_retrieve_mam_pm_708 domain.example.com retrieve_mam_pm.1653469552473993595.zip Result [] ExitStatus 0
*** User 2022-05-25 09:05:52.669 *** extracting logs retrieve_mam_pm.1653469552473993595.zip.alice_retrieve_mam_pm_708.unzipped
*** User 2022-05-25 09:05:52.869 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data bob_retrieve_mam_pm_708 domain.example.com retrieve_mam_pm.1653469552670574804.zip Result [] ExitStatus 0
*** User 2022-05-25 09:05:52.870 *** extracting logs retrieve_mam_pm.1653469552670574804.zip.bob_retrieve_mam_pm_708.unzipped
*** User 2022-05-25 09:05:52.870 *** bob_retrieve_mam_pm_708@domain.example.com/res1 out </stream:stream>
*** User 2022-05-25 09:05:52.871 *** bob_retrieve_mam_pm_708@domain.example.com/res1 in </stream:stream>
*** User 2022-05-25 09:05:52.871 *** alice_retrieve_mam_pm_708@domain.example.com/res1 out </stream:stream>
*** User 2022-05-25 09:05:52.871 *** alice_retrieve_mam_pm_708@domain.example.com/res1 in </stream:stream>
=== Ended at 2022-05-25 09:05:52 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result