Automatic deletion of person visits should not performed one by by one [5]

[syntakker]

Problem Description

In automatic deletion of persons, person visits are deleted one by one. This can cause considerable load on the system. From top:

    PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND                                                                                                                                                                                            
1156215 70        20   0 7612468   1.5g   1.5g R  96.3   4.7 485:20.73 postgres

Inspection of the debug log shows that after an initial call to batch deletion, each visit is deleted individually at a frequency of several hundred milliseconds per entry:

2022-06-29 10:25:37,412 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: VisitService.deletePersonVisits with parameters '[[87a17bc8-16f8-42c4-8053-f510629dcadf, 0fc0a262-c0bf-460c-ae3c-9a6ba3c55fa2, b6f62411-22cb-459a-927a-984b359f0165, 1f7
d174b-6567-40e9-a0d2-7dc34d1cfbcd, 12e1c3c0-8aa8-4653-9f9d-84945696e579, 0f3e8d14-143c-482f-8198-f59b4e7120ce, 439dfb9b-acf4-4ae6-88a9-09ffdaed8324, 43d0a25e-42f0-48d6-a701-c69f0b1d0495, 0f8f9d9c-2b4c-4cef-8258-0818921715cc, 598555e9-94af-41f8-bc66-036d6b45a4b1, d90f6e71
-b396-4c4b-b3ad-55bf0e4d67e0, 218ade43-1319-4f21-b6de-396b9cb2bbcf, 175cd9d6-cce0-442c-aec5-e811efe053ae, 8b8e7a44-2865-4ede-a34a-6d690d39fed1, c08463a4-79a2-43df-ad8e-92601235a7b2, bb0f05c2-fffb-44bd-845a-cc177666c9b2, 90046857-b80a-41b4-87e7-9722df401d95, d3e9c24b-10e6
-4b7d-acc4-63c26b5a7a0a, 1db9c7a6-bc04-4d26-bda7-5de6c6db7f7e, ef1299d5-7cb6-481d-a8fb-82eefdd63536, 16e7adbf-6b55-474b-9e17-310ce38335bd, 6a434ae7-4784-4d7d-b6a0-5d2c9698da59, 8f1f9150-c6b1-428f-b143-2a12c5452e3b, 0d958f47-e6ca-44e3-8d1d-083bc60efd57, aed78624-29bf-4cfb
-abcb-796cffc1d21d, 4df832c9-b57e-4492-98e4-0e9339d5c222, 49d55562-a5c5-42f8-979f-bec8cb60ccd7, 9164402a-c812-4098-a4b7-1983571951a4, f3c986d2-8aa4-4e7e-8d17-9232c13bb80e, 8ebc21ee-67a8-49b6-a1e9-edafd95c53fd, 42c537ff-ec81-4ff1-abfc-ae2286b755fb, 14f9ead9-9926-4c48-9293
-12816ba2f95c, 32ba2803-f373-40a9-9b0d-270ed5352580, dbc3cb5e-56b8-468a-8cae-cd0950784b97, 5689fa43-1d0c-4155-9ed6-318f055ff992, 21be349b-7ef0-46b8-89e1-23a39e9487c6, 0ecf88f6-ee44-4621-8640-97288c94f4e2, cd51329a-242d-43dc-bef5-3dc30c77b687, 269bfe3d-9e62-44d6-b938-b8fa
dc50fc49, 74b1615b-d48e-4e56-9870-c673766e8d45, e5c93091-5416-4d08-a991-3d94ed135109, b3faf141-cd90-466c-8f26-ba4fcd6a4448, 357a8dbf-641c-4da4-8f45-cc95deb32a2e, 5096e53c-bafc-4be0-8004-08d842cbc151, dd37c137-1661-47d5-9013-f02eef33366c, 913e7040-6256-4ae5-a7a6-9808fb5ca
1fd, 0abacf7b-e77c-4c9f-b728-f3d3444dbee6, d1c7cd37-63db-41dd-bc49-7dbd31bb1edd, 27490a6c-1295-4a87-afc8-b0b7c77ef0e0, b20f7954-5d1d-41e2-af46-fb4c374f8a3b, 4ebcc771-7c5e-4067-9835-808b0f2477a8, 873ee615-c134-4eec-8464-51651b9b06f8, 64fa18d4-1046-484d-bdf7-bf0850b30bed, 
adfbfe97-7803-4c7b-9e11-a9748e3d27c2, d8fed6db-04a7-4f86-b762-9f5421099d46, 841c5baf-8e35-4a8f-9be9-a5a9cb012240, 534594cd-9d46-4666-8307-9d63b32360d5, f2fba053-b2a2-4ce4-b29b-2b9b3a8f3f8a, 7b8832cf-6805-4714-ba87-14edcfbae986, e22cede7-236b-44d2-8350-17a8bfb013b0, 8b728
307-8317-40bb-b93f-fd62108ece17, 1c675cdb-37a7-4d8f-b9af-9c2c9bc2f563, a04b4219-88ec-4ab0-a942-9cdce5f9fd45, e19b25cf-035c-4c52-bf47-80c617cdaa5a, fe3f0191-30e6-43e1-9bea-fad9ec811596, aeb21cad-7c25-49e0-8536-d63a34fb3f07, 1730c713-7dd7-4fb5-bbb1-1a7c265906cb, 1d31f3ae-f
727-44c5-ba50-ceb4a680ab55, bc9512dd-712b-4c30-8667-f8ae4a76aab7, 203705a3-0a0e-4b60-8396-ec9805233887, 2316c784-e565-4e78-9fee-90e2db484f25, e2be8108-4fb8-45b6-ba47-a210c9bebb11, 607f6d69-7d64-4c04-8f4e-6310bdde8e11, 9a450f22-1e0e-4b87-a614-4401dbd8c680, 15a30d07-f0be-4
fda-a7f1-3f37bc895226, 1eb33196-ceb7-4f17-8c7b-244a75f4e13f, 31bf2838-69c9-41f3-8332-ff75e89f0f7a, 19d94876-acf3-4d9d-b9c2-2e23a6c0247c, 97b9e070-887b-42cd-ba35-05d065b3012d, c1ce18f3-9feb-46c7-a9ea-e11d22cea82f, 57188e7f-6762-4e80-b72d-ecceee458f2a, a7590f08-eae9-4024-9
be5-dd45b1b73b28, ed4cf025-8b27-42a0-a2af-19e0e6109c11, aada1ef8-68a9-43f9-829e-25d609b356a8, 4ef971e7-31ae-41e5-b20d-b3f5a9372373, 8e2d45d9-91b6-43ea-9565-b2971ba36bb8, d74817a6-5785-46e9-83ab-97160ba0857a, 681e99ea-853d-4d4b-98f2-886c1ab9cad7, ffe12415-5e88-4662-8e1b-d
950f85ce6ad, c22236ea-73aa-43f5-8e6d-76ca3206d744, 9cb707ff-6ad3-408c-8136-120028fdd4cb, 17ab2a34-a811-4496-b6d1-e8768cd2ed37, 95f151fd-3025-4a8f-b0d6-0844802a4c9d, 7d8ce3be-2c2a-4aa7-accf-1e0a980efda2, f0e90368-7d27-4ae2-adb8-63e9695e13ce, 9d25661f-1721-49f5-9263-24ef0d
f00fbb, 6b9cdd76-ff5b-4445-bd15-1435940d8d36, 8f639459-445e-4e89-85c1-caef5a4cacd4, 50c7fad8-ab6b-4eb1-86a9-624430a589ab, 78987d00-ba8d-4566-8427-04e5286dba8e, 9a412a0e-f85e-4b9d-8dc5-89ed482ba0c1, bd488324-a586-4835-ab14-8c2a8ac220e7, e35c1a6c-8c90-4220-97f7-6b5c29f2d5f
e, 2b2e3693-2dc5-4890-9932-814a1036fb8d, bd146b83-c450-48f6-b5d5-ea151a77308d, 82e9ee52-46da-4591-9095-97a5593bec3f, eca3513b-c2a5-4305-945c-3a99c0fe9ac5, 32cec862-79ad-476c-9c97-4a10bc249d77, 6dcaee37-ef28-4ede-9d2f-31bb7d994d95, ca7904da-b55d-4ab0-ab70-34260446ef55, eb
b0fbe2-4c1e-4f3f-a458-935878e7420e, 6e114a9a-fa99-482c-b479-147e489f624c, 0441b080-aa6b-4a5c-a4af-9894d8fe185f, ddad44b6-7c7e-4c2b-9f8e-e5a028542de0, 34965cdd-6a46-4cd7-913a-a9e7791f8a52, 09d8bf9f-6a8e-43d4-af14-c5c75d0f336f, 69060733-bfc9-439a-8048-0dc8690624bf, c02da9f
2-c4f9-4032-8d4f-691418c6c091, 0866539f-5b25-4fff-856b-2553e38f10f4, 5668aa4f-3386-474e-bdaf-74e1fa3d987e, e3bb24c0-c809-4576-a56b-c14e19e8f4bc, 0a46492d-7d68-45fa-96af-20e4e66edfbf, 5d4571df-397d-457f-a02d-437475781049, 43a57d0b-a07c-427e-b6af-21ceedcf7220, ef0b05a3-1e1
d-49a3-9397-e0d205af7af7, 41c3fd3d-a364-4892-9735-4cc08307d297, b768b18b-e41a-49b4-88f7-1cfe6a18e2f9, 5a81b8c6-c046-4bd4-8ec7-76633c175a9a, 8b07244a-2ee5-4f71-a285-8cc61e6a44cd, 3340ae4c-7858-4aef-938e-9b9bd572d831, 670e0df3-9eaf-4c9f-bdfb-173ed3839ccc, 7099c90e-c2ff-499
b-9f26-86d0038fb8e3, 5ca56abc-360d-4ce3-848b-afb63b6a7ce2, 85148e1d-d7a6-4510-8c77-c6a459d292af, a661313e-4b79-43d9-bbb8-3e7f5bbfdaf3, 6806ab1f-b389-4749-826f-bcfc98354adc, 494135d6-5975-442e-964f-b980db8bd930, b9c436d2-bab3-495d-95e3-626c5c3fddd2, b638b3aa-e2d6-4572-8db
a-0de6e81afd8b, ca6f5b7e-4cbc-4026-9581-a636d2171a65, a92d36a2-b953-4a1e-96bc-a10a419289bc, 40a86050-010a-425f-b0c1-8784ea82f294, 66ca75fa-e7b7-4426-8165-a12b109c56a6, 569c238d-fb89-4e24-bc03-286dc6d72cad, 2f1b68ea-36b7-47fd-af82-c071f4d306f8, fae9bf98-eef2-4fbc-b258-a60
cf1f50e87, 003cd7c6-e339-45eb-9083-10eafe00b5b4, 3480f486-bf82-400d-81ec-46c5fcead5f0, 5d862e4f-23c5-498c-a48d-0a2024f67daa, 05e93d61-390f-4ba7-a834-a4fa9c37c5af, 3f297654-7de9-4d07-9d52-aff03cf9efdd, 1aae64db-ae4c-430d-89ad-89efc7559630, 91788eef-86f5-4893-ae7b-5e21e061
5b3a, bddcbf79-8b98-4652-a48a-96d7e5a79f1d, 6a1c4c4a-0229-42b0-8f3d-43c0d58ba4c9, 515a8dab-8ed9-4b8a-b077-08de5ea5904c, fa38a6e8-5a7b-4888-adfe-b5add68dfd0d, 8644bed9-59cf-41e4-9b12-e22369bdf72d, b93afbac-974e-4c72-94f8-677d1016a10f, da56e734-f81a-4dd7-b44c-1f50cf830b32,
 07bbc6ae-9d5d-4930-8430-2c3cfb883f8f, 68bcdb2d-31c2-44f1-b05c-a7c108c51548, 059534c6-9ab7-4768-b6ff-27009342aab1, 8da0dcba-46e9-46e9-a0c6-31807f762d1b, 92705df9-6d27-4562-8b87-b04df9fb8fca, d21dac12-a236-4ecd-b90b-2174090195f8, 9bd7c987-3c94-42dd-97bf-db20494ca953, cba0b8a6-8868-426c-92d6-94683e90e4a4, 3c036ec9-e7fc-4a85-a16c-277a580c8a52, a1c01003-91ad-4b69-9c6d-4e3f18358768, 630bc1b8-076f-4be7-81d6-e5af3069c804, 5e3195ef-bb35-45b3-8307-2dafc99ccf92, 2fb6cd66-b254-4215-b696-b6e30566b552, 0d953575-5afc-4ba8-b8a2-3a312c6fca37, c4ee6b73-7a09-4cd4-9990-388aeddf2c8b, af82d770-d3c3-4475-90b7-8b9ca6033c07, ec910db4-70c1-4ed3-b8a2-b8519389b02f, 2d80615e-de20-4b60-9da7-f8cd57c2d994, d33c2425-7203-4c09-81c2-51a7f8af75fc, 4e9f1b03-12ea-4002-b006-86bd17bc0fed, 6284355c-9ef3-4c84-8e59-8ebb9d76f02b, 973d2efd-f471-4d3d-9af1-fd84b3a30993, 409a058c-e012-4ea4-8645-f046577ad9cf, 528be853-23b2-4899-9257-021dd48d5064, 4d3b0d41-cb42-47f3-9093-69b3a1e227f3, db68e329-c04c-46f9-8dd9-a38aada9d011, 5090ab02-071f-4179-9da7-4af08b143e68, dbba859a-11bb-43b4-8a9f-3517af46a18a, 5cb8c51d-9a20-422a-aace-370cc5a286a6, 6ef95dbb-cee7-4b80-a936-7e0ef54b2b2f, e3324f33-04ca-4565-a901-1d0e36ad4ffb, b68b2b89-bc4d-4ed8-8d31-b014133c64b9, 159a7994-d03c-4a66-b7fe-687d58b89cd7, c73ad581-d744-4b74-af3d-df370c38213a, 052e730d-a34d-411b-9fa8-96862f94a5e5, e2d392d8-f7c5-4e4d-8c50-c00722238189, 517771ff-8488-4578-be48-2426b59cdb47, 7b866f64-6aab-483b-994b-198cb32ce8ab, 17b62421-ad59-4761-b231-3835fe0f8d9b, f058b417-e60b-4cbf-b964-586516e1b177]]'
2022-06-29 10:25:37,425 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 13 ms: VisitService.deletePersonVisits
2022-06-29 10:25:37,429 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,430 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,431 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,431 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,433 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: ManualMessageLogService.getByPersonUuid with parameters '[87a17bc8-16f8-42c4-8053-f510629dcadf]'
2022-06-29 10:25:37,434 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: ManualMessageLogService.getByPersonUuid
2022-06-29 10:25:37,435 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: VisitService.deletePersonVisits with parameters '[[87a17bc8-16f8-42c4-8053-f510629dcadf]]'
2022-06-29 10:25:37,436 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: VisitService.deletePersonVisits
2022-06-29 10:25:37,437 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,437 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,438 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditLogServiceBean.receiveChanges with parameters '[de.symeda.auditlog.api.ChangeEvent@60c171f6]'
2022-06-29 10:25:37,439 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: AuditLogServiceBean.receiveChanges
2022-06-29 10:25:37,440 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,440 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,441 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,441 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,442 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditLogServiceBean.receiveChanges with parameters '[de.symeda.auditlog.api.ChangeEvent@58bb0216]'
2022-06-29 10:25:37,443 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditLogServiceBean.receiveChanges
2022-06-29 10:25:37,444 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,444 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,445 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditLogServiceBean.receiveChanges with parameters '[de.symeda.auditlog.api.ChangeEvent@6480f2ea]'
2022-06-29 10:25:37,446 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: AuditLogServiceBean.receiveChanges
2022-06-29 10:25:37,770 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,771 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,772 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: AuditContextProducer.getCurrentlyLoggedInUser with parameters 'null'
2022-06-29 10:25:37,772 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 0 ms: AuditContextProducer.getCurrentlyLoggedInUser
2022-06-29 10:25:37,773 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: ManualMessageLogService.getByPersonUuid with parameters '[0fc0a262-c0bf-460c-ae3c-9a6ba3c55fa2]'
2022-06-29 10:25:37,774 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: ManualMessageLogService.getByPersonUuid
2022-06-29 10:25:37,774 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: VisitService.deletePersonVisits with parameters '[[0fc0a262-c0bf-460c-ae3c-9a6ba3c55fa2]]'
2022-06-29 10:25:37,775 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 1 ms: VisitService.deletePersonVisits
...

Involvement of AuditContextProducer.getCurrentlyLoggedInUser around the actual time gap in the log may indicate that this gap is caused by the issue addressed in #9577.

In comparison, PersonService is logging calls once per batch, the log inbetween these calls being filled with the calls to VisitService:

$ grep PersonService configurations/payara/sormas/logs/application.debug

2022-06-29 10:32:26,705 TRACE   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Started: PersonService.deletePermanentByUuids with parameters '[[8a3043d1-496e-4c5a-bd41-72952b39a590, 3964a008-d9ee-418e-a690-3955741445b3, bd246070-19d0-4807-9186-ba2fc588abf8, 800c543b-e47b-4c72-bec9-07e920eb4b59, d8f52ef2-284c-4287-b868-f00c18ba4686, 145b9983-c047-4677-a835-5918a1106889, 6b676fc7-54a7-4747-899a-7ae3302d4ef9, 8555b3f1-a803-412c-9691-dfa28af6d2ff, 03099150-c988-4cba-bdcb-d7dd0e7c9b0c, c3ebab48-039b-4232-989b-055e3f654761, f38da97c-954a-4559-a4ae-88f6e76afa5a, a75ee198-ae86-4809-990d-3b3cc43f1e71, 8374ad17-f964-4ff6-be18-7dce22d1c054, 1bc0f69f-8f65-46ac-948d-4b026976ff95, 13735c8e-ab42-4ac1-9c54-9808ba30b525, 8e4802a7-8984-4878-926d-b5396dc9a986, c60b7a05-2985-4764-9244-a9aeb6397a7b, add91e9f-06b4-48ad-af04-b6113f51dfc6, 777cb924-7098-4010-8c9c-b64e29aa13e8, 4404f430-3e99-4d88-b659-e0688151e4e2, 92aaaed9-6841-48e0-87ce-aded9d4451e6, 774679f9-3dbc-4448-bb86-2cb99f29a2cc, c104be7a-560c-4f9f-b13a-915089678f15, 54f272c2-3b72-4d59-8bd1-a5f78eb0e7f2, e9497d07-e3b3-4e43-bea1-c4f4ff7fd009, 6c37d258-0593-46c0-9a26-3ee9ca1c1143, c2f10055-6980-474d-94f7-2c9c3c0a917b, c04e8650-712c-492c-87fa-f10ab996873e, 7f719598-9ef5-4787-8801-5083036a456b, b5f549fa-57e8-439c-b4f2-fab440b23278, c533fe1a-0ca8-42bc-a045-a0d3b4bb2838, 024ddd06-b6d0-47b5-a888-c1336d8759c4, c5d36e1d-f769-42f6-a129-9a9f89260410, 65bb604c-6fc4-4cfb-9e3f-bcbb5317ecbb, fd5c3a11-9919-4514-9c06-321405c673b6, ae49732b-e7ad-46b3-b83f-49cc5f7aa333, e1dfb0d3-bc81-4342-8e0f-049a82473dc5, 7c21aaa4-ce57-4963-8470-9dd6a0a1a1b9, 999c9ca7-e826-44a0-bd9e-2cd64cf859c9, 9eb0ee42-664a-40f2-858e-5682bf85454e, aaac0661-0f64-4668-9cad-5bdb336c79bb, ae3cf374-cc5a-423d-bd6e-840aeadcdcaf, 6188f81a-9543-41e5-9b83-8b0eb08682da, bc6bf8de-294a-435c-afb1-e906294c11f1, c8b1c967-f65a-480c-add5-2bd4d3005353, 73ef0812-8bef-4f88-8f98-a88fa41cfe68, f50f783c-4685-4c34-879e-43eed5f04b00, 9954dfbd-b787-44e1-82f9-756bb52a962c, 777b81d0-b192-4ad8-af2e-520404bed321, 60113395-393d-4338-981d-78cdc44f4497, a2e0c5e2-f07b-4d4c-9802-573c4148f168, db25cd49-f229-497e-af41-e91514e971b5, b1c1a7d4-a49b-4dd0-ace5-9ea90ae7a979, 10813551-4c01-4cc3-805c-81a828cfb445, b3174804-11c7-4aad-8e91-981c4a05cd30, a2f00e76-957a-41e5-88e5-e1168c3edd47, 396c705d-0bc5-4b9a-b49c-eb220fedc0a0, e35037d2-7c37-46f9-a29e-5b71eb337d67, 54aaac02-529a-4ec1-ba1a-c21e17858433, cb6ca5ee-45fd-41a0-9256-b77371d432b4, d9355845-69f3-42dd-86cd-75d81b322dff, ec57e061-e564-4349-9711-c960ce7e58fd, f4d26226-9962-4fb0-94bb-5baf5a6d0cdb, 61689dcb-373b-4a94-ad67-41ab15aae62f, 835f3955-cb50-4974-9cdc-8b873abc69fa, 2860a4ce-816c-44d0-8655-453eab840b6b, baa327bd-4507-4b13-a075-7d7c989b1738, d29d8294-e7ac-4d5a-8995-4a7fc5743572, 615d14c1-a97f-4d4f-b025-136d7e6bdfc3, 077af446-6b33-41a5-9093-0da8f21a6ac5, 1d233612-7558-4e75-8a48-37e344b5dd58, 400cf2ed-710c-4b68-ba36-f484e7bd4501, bc2c762e-12cf-46f3-afb0-388b5ba4870f, cc299e60-6567-4b1e-8e34-1ea79beab39d, c57e0d7d-51ba-4423-85ab-ed1d31597a42, 27b4c747-67ac-4a45-bbc8-cf0454d8ab14, 5ac30ba8-c439-473e-8f51-7d29aa9b77d8, cbe1a8d8-1c25-4b10-80b8-4597eb4699a2, 57638083-d497-4c43-91c0-6628d626107f, 4315727a-4b8e-4305-bb59-4575930ce3d4, efc5af42-dbef-43bd-bef6-5b94d7a10919, a20b617a-7dd5-4d65-90a8-fe82423368c1, 146e70b5-797d-4f3c-9bdf-012090624766, a1026153-b0b7-49f6-90f9-6108541134c1, be4d3020-d64d-4753-98fd-4038aaea0df1, cf459dc2-a55c-408b-aa4b-39e8e1eac443, 938d70af-5e69-4468-b4aa-e7d6356326c1, 4779467e-d1cd-48ef-9ed6-caf623b5af3c, 56744daa-c156-4d8e-aa6b-dd32dd706bba, 2071f006-1eb2-47b5-a5e2-e89029a835ff, 92647e29-5679-4c13-95bd-69d6e99bdfc6, 4402cade-43e6-4b6b-83fe-025499735298, 3c922e5e-d8a1-4ee5-8cc8-9052c26a080d, 301fc791-5eeb-431f-a6e2-2afca64f50bc, df7cbaec-b340-4552-8867-c0c3aa2983d7, 26e55a45-21af-4531-be9d-5f642aa71d24, d3197189-1e8d-40c9-b884-002ca77434e1, f0b499f7-02d5-41e8-bd9c-356df52590c1, a5b792d2-8ef2-4649-9a65-0266d0174276, 1420b6a5-508f-4fc0-89d9-a3231890b983, a445b465-ad8e-4568-adbb-4785f727bac2, e74c45e1-2692-45ae-bb93-162db1a154cb, 12043cbf-a529-433b-8975-9a39801448f6, 5eb7648c-7b2b-4316-be12-ae50caf95365, 09e7bcd3-3b9d-46f0-8563-ca467718744c, 27b140ce-a71d-4a2c-a6df-e4d6a1af2c46, 28e59a76-9718-4b1c-8c58-281746c99557, 10a5590b-5e0c-431d-8376-8ada33acd00b, a55b4d46-418f-45f1-a6b9-be78693799aa, b6eefa39-b1a6-4e2b-953c-207d949b6f6a, dd472ea9-5e3b-4e31-b5c5-c92353842a5f, 6dedd14f-76e4-4d96-a1e9-3589080597e3, 094d2c78-6b91-42b0-99de-9ea5062138c8, de3b6da7-fbe5-4a0b-8406-3296945d5c9d, 3596a659-62a2-4320-89b5-0bb92b6cdc8f, 8f4b3bf1-26f6-44d7-ab30-691ffda5aad3, 721ee4a1-c35b-4fbf-a123-75602ea72049, 5a0060b7-d5cb-46b0-8484-c1b5c92cf71d, 475e004f-915f-4446-8cef-f0c610e7154d, 7d8cd838-feed-4aa9-b8cd-0d487512b53a, 1b9135dc-0041-4d5b-8c51-4b9d4189e44b, 18766cca-a307-4231-9a33-eced184718a6, 5430ccf8-8c9c-4b62-a8e2-0240183f6eb6, 98e3ec66-4b8b-4410-9bd1-33f6a301a82a, 1d50ac17-229d-48d2-ae2e-4c04d6cd2304, 82267d03-112c-4a6e-b77a-d1ebf7eeb5ef, 2ffdb7e1-42df-441a-8c1d-25f38084ab8a, 6803eaad-2444-46ce-aea6-ecad104a399f, 1e6ba3d6-7992-4421-ac10-5cec99689c70, 14fb10b5-3120-424a-8503-3601267dacb0, 4a7d1575-ca93-44e0-8afd-b1d8fa0decdc, 3b41ab4b-f678-47fe-8986-343f0e3b6fe4, ce6a6c40-adc2-4826-827d-a57bc4bce180, 3b8ba40a-2b99-4c10-9ee9-c7ee30614f8a, 4a2a76c8-6639-4af3-8c44-499c592bda92, d2641bdc-aefe-4b57-a87a-f2ae1505296e, 5851fa27-e0ed-4d05-8ef6-9e33ca4aefaa, a4115ae3-cb41-4ffa-b167-f7c1021482f6, 64809032-68f5-49d5-a987-84cf50f8ad9e, 92d11f7b-9470-4677-a264-a269b1f40d1d, be82ede2-9cf8-46da-affa-38615023a93f, c8eea08f-d0a1-4819-ad68-08820c93b99d, 72d54e0d-1f9e-4b04-8b3f-0d623f021296, eaf103f0-27a6-441e-84ce-1f967d9028c5, 9fc41553-a759-4e32-9114-e98babf67d47, 5ba41963-9efa-44d1-b49b-4116d7b9e4d4, 539a38dd-0afb-4ed2-9a6d-b5545dc0cfa2, 3536771a-be34-4dcf-bafc-d8a71e4d6938, 9014bfab-cd6e-4bd0-be73-453d5fe1cac8, 090e76a9-b759-4f02-b595-bf0a2cc259a3, c9d9e421-a02f-4b3b-81bd-efefa3ca1277, 847bb6c7-5bcd-4c85-82b9-f83194104c21, 30d6f599-d794-452f-90e6-e284147b2b40, f95aa7bc-e4f0-4d3a-8cc5-27d6d6958585, 2369f6fb-e4e6-4959-9e41-a10c9a645c3f, e4c292e6-67c1-4603-a9f6-65a6b1c6e4f2, 523bedd7-021c-4e6a-b3bd-812ad5af42bf, 2558dcf6-ae93-4b82-baba-898ae3880d1a, aa030888-a92d-4954-93bb-24cb567e4412, 0dd9325e-39d7-4203-96d6-d84e5290a7a5, e077510f-bf06-45a9-9418-54555143c2b0, 50148a6b-4782-4011-b484-19c19b61b44c, 21ac8558-512f-4e5d-b567-bcc2df03e379, 3912a0ea-5778-4872-8deb-5876558112f7, a0ed72c0-d4f8-4831-91b3-0deaeed9ec81, 357451ea-2358-4433-b40e-79ac447edbf3, a1f92923-17b0-46c9-9225-e60fb255b98e, 6f9418e1-a75d-4b5b-91a7-02679adb50ae, 73abb489-9d88-4212-9f32-a2e5c487b336, 09bfec90-73fa-4020-a4f0-b1a2356aa312, d834e720-efac-45eb-ac92-3cfaefbad03b, fdf4fbb2-4a5f-447d-9026-b895c117df00, 307d894d-f597-4c85-a595-1d3f5bbe89b2, 07974b4f-c1ea-424c-9218-4c10d85c3f3f, 4ccbae5e-44c5-4dd9-be19-6c6c0684dbd5, 8d52adf2-e74c-4f58-bc03-744b2a43824b, cbb35a25-ba76-4323-8009-2dee19080cc0, cce96b63-94c1-448f-a46c-9ccc25518bea, e1cb01bd-d78e-4592-bfa7-1831d565dbf5, 8e026645-ce17-4e6c-88c3-2a633b1ab29e, bd0ad14e-e38a-4c6d-b49f-f13d1674255e, f94bd214-4728-4dee-b89f-80716630ed1d, 61e4c72e-d1c9-45b0-9412-a8fd526c36cd, e917579e-f488-49f9-9601-c1207cb6c5f6, 8dc31b31-32b2-4633-be29-6ba23e79610b, 81645626-4874-4e65-b1be-3e624430cf69, df718b0a-7743-4ad1-9df9-9a46cce1883f, e6a0ef71-ab4e-49ca-9442-a9d51079db82, faba1d98-3111-4ffe-8f98-33db426b70b8, 1db0a183-f4ef-4886-9e4e-c102a4b85498, 0ad514af-5ae8-4cfd-bc05-3726aa108345, 1732cb71-64ec-4b84-86cd-813750d3cf2f, fef1625e-90ce-460c-b0ac-fd0c19dd8400, 9594fe87-7109-41e9-a894-8db8febd9e72, 8a7292c4-4222-4c71-a25a-138192d987f3, 562e73ae-9b1b-4a3e-8ace-fa4286246dfe, 35db4153-2cb5-41ee-a7d1-2f0069ae24d6, aaa70fe1-4fc1-4773-adaa-7d7965e7224e, b2bf31a4-a83f-4912-b6d1-14b090d507dc, 09b5f7ba-33d7-4b44-b759-90d949f7e2a2]]'
2022-06-29 10:33:31,359 DEBUG   __ejb-thread-pool13 d.s.s.b.u.PerformanceLoggingInterceptor - Finished in 64654 ms: PersonService.deletePermanentByUuids

Proposed Change

Visits should not be deleted individually, but in a single sql request per batch, as is appears to be done in PersonService.deletePermanentByUuids.

Acceptance Criteria

Implementation Details

Additional Information

SORMAS-Version: 1.74.0-SNAPSHOT

[StefanKock]

I moved this ticket to the Product Backlog for next sprint.

[roxanamlendea]

I'm reopening the ticket because when the Contact/Case is permanently deleted, the Person Visit is also deleted, but the Symptoms still remain in the DB.

[roxanamlendea]

Verified ticket on local setup using the latest version of Sormas 1.76.0-SNAPSHOT (ca4b9c5).