=== Test case: gdpr_SUITE:remove_mam_pm/1 (click for source code)
=== Config value:
[{mam_backend,rdbms},
{watchdog,<0.16214.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@88d84ff17c71.2022-03-04_11.16.52/big_tests.tests.gdpr_SUITE.logs/run.2022-03-04_11.18.52/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@88d84ff17c71.2022-03-04_11.16.52/big_tests.tests.gdpr_SUITE.logs/run.2022-03-04_11.18.52/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@88d84ff17c71.2022-03-04_11.16.52"
=== Started at 2022-03-04 11:19:34
*** User 2022-03-04 11:19:34.254 ***
required modules: [{mod_mam_meta,[{backend,rdbms},
{pm,[{archive_groupchats,false}]}]}]
*** User 2022-03-04 11:19:34.259 *** alicE_remove_mam_pm_696@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-03-04 11:19:34.260 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='99597e72067d98b6' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-03-04 11:19:34.260 *** alicE_remove_mam_pm_696@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-03-04 11:19:34.260 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGFsaWNFX3JlbW92ZV9tYW1fcG1fNjk2AG1hdHlncnlzYQ==</auth>
*** User 2022-03-04 11:19:34.261 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-03-04 11:19:34.261 *** alicE_remove_mam_pm_696@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-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='c76ad54d87bb9315' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@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-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <iq type='set' id='802362f654ad4e9dd020a4526aebdf42'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <iq id='802362f654ad4e9dd020a4526aebdf42' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>alicE_remove_mam_pm_696@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <iq type='set' id='54b7cd1e589a7f287446e24ea70db25b'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-03-04 11:19:34.262 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <iq type='result' id='54b7cd1e589a7f287446e24ea70db25b'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-03-04 11:19:34.263 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <presence/>
*** User 2022-03-04 11:19:34.266 *** alicE_remove_mam_pm_696@domain.example.com/res1 in <presence from='alicE_remove_mam_pm_696@domain.example.com/res1' to='alice_remove_mam_pm_696@domain.example.com/res1' xml:lang='en'/>
*** User 2022-03-04 11:19:34.266 *** bOb_remove_mam_pm_696@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-03-04 11:19:34.267 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='4bba6618a315adb4' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-03-04 11:19:34.267 *** bOb_remove_mam_pm_696@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-03-04 11:19:34.267 *** bOb_remove_mam_pm_696@domain.example.com/res1 out <auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>AGJPYl9yZW1vdmVfbWFtX3BtXzY5NgBtYWtyb2xpa2E=</auth>
*** User 2022-03-04 11:19:34.269 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <success xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>
*** User 2022-03-04 11:19:34.269 *** bOb_remove_mam_pm_696@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-03-04 11:19:34.269 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='8709fe6e3f85c1b1' from='domain.example.com' version='1.0' xml:lang='en'>
*** User 2022-03-04 11:19:34.269 *** bOb_remove_mam_pm_696@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-03-04 11:19:34.269 *** bOb_remove_mam_pm_696@domain.example.com/res1 out <iq type='set' id='4560cfb7a23567e2ac15a423f278fe97'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <resource>res1</resource> </bind> </iq>
*** User 2022-03-04 11:19:34.270 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <iq id='4560cfb7a23567e2ac15a423f278fe97' type='result'> <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'> <jid>bOb_remove_mam_pm_696@domain.example.com/res1</jid> </bind> </iq>
*** User 2022-03-04 11:19:34.270 *** bOb_remove_mam_pm_696@domain.example.com/res1 out <iq type='set' id='6595173794fd2f586d4aa0aab4540bc5'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-03-04 11:19:34.271 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <iq type='result' id='6595173794fd2f586d4aa0aab4540bc5'> <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/> </iq>
*** User 2022-03-04 11:19:34.271 *** bOb_remove_mam_pm_696@domain.example.com/res1 out <presence/>
*** User 2022-03-04 11:19:34.273 *** bOb_remove_mam_pm_696@domain.example.com/res1 in <presence from='bOb_remove_mam_pm_696@domain.example.com/res1' to='bob_remove_mam_pm_696@domain.example.com/res1' xml:lang='en'/>
*** User 2022-03-04 11:19:34.274 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <message to='bOb_remove_mam_pm_696@domain.example.com/res1' type='chat'> <body>1remove_mam_pm message</body> </message>
*** User 2022-03-04 11:19:34.274 *** bOb_remove_mam_pm_696@domain.example.com/res1 out <message to='alicE_remove_mam_pm_696@domain.example.com/res1' type='chat'> <body>2remove_mam_pm message message</body> </message>
*** User 2022-03-04 11:19:34.274 *** alicE_remove_mam_pm_696@domain.example.com/res1 out <message to='bOb_remove_mam_pm_696@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-03-04 11:19:34.279 ***
=WARNING REPORT==== 4-Mar-2022::11:19:34.278894 ===
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,54,0,57,0,54,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_696).[FreeTDS][SQL Server]The statement has been terminated. SQLSTATE IS: 01000"}}
server: <<"domain.example.com">>
user: <<"alice_remove_mam_pm_696">>
what: create_user_archive_failed
*** User 2022-03-04 11:19:36.520 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl unregister alicE_remove_mam_pm_696 domain.example.com Result "User alicE_remove_mam_pm_696@domain.example.com successfully unregistered\n" ExitStatus 0
*** User 2022-03-04 11:19:36.772 *** Execute /home/circleci/project/_build/mim1/rel/mongooseim/bin/mongooseimctl retrieve_personal_data bOb_remove_mam_pm_696 domain.example.com remove_mam_pm.1646392776522820060.zip Result [] ExitStatus 0
*** User 2022-03-04 11:19:36.773 *** extracting logs remove_mam_pm.1646392776522820060.zip.bOb_remove_mam_pm_696.unzipped
*** User 2022-03-04 11:19:36.773 *** bOb_remove_mam_pm_696@domain.example.com/res1 out </stream:stream>
*** User 2022-03-04 11:19:36.774 *** bOb_remove_mam_pm_696@domain.example.com/res1 in </stream:stream>
=== Ended at 2022-03-04 11:19:36 === successfully completed test case === === Returned value: ok
Test run history | Top level test index | Latest test result