Hi,
I just test the 6.0.6 version and I saw that the GDPR task doesn't work.
Logs of more than 1 year are stil not anonymized.
In my logs, I have several errors:
[WARN]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.hibernate.engine.jdbc.spi.SqlExceptionHelper:logExceptions:SQL Error: 0, SQLState: 23505
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.hibernate.engine.jdbc.spi.SqlExceptionHelper:logExceptions:ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed »
Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà.
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:1/690:Unhandled Exception in batch : org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:1/690:Unhandled Exception in batch : org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
[...]
Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed »
Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà.
[...]
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
[...]
Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed »
Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà.
[...]
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:Cannot process resource '56cdd551-1940-4384-aebf-f2222155e1fa'
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:Cannot process resource '56cdd551-1940-4384-aebf-f2222155e1fa'
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:CRITICAL ERROR : Batch stopped !
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:CRITICAL ERROR : Batch stopped !
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Critical error for the current task. Task stopped.
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Critical error for the current task. Task stopped.
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Summary : success: 0, skipped: 689, errors: 0, unhandled errors: 1
[ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Summary : success: 0, skipped: 689, errors: 0, unhandled errors: 1
Hi, I just test the 6.0.6 version and I saw that the GDPR task doesn't work. Logs of more than 1 year are stil not anonymized. In my logs, I have several errors: [WARN]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.hibernate.engine.jdbc.spi.SqlExceptionHelper:logExceptions:SQL Error: 0, SQLState: 23505 [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.hibernate.engine.jdbc.spi.SqlExceptionHelper:logExceptions:ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed » Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà. [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:1/690:Unhandled Exception in batch : org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:1/690:Unhandled Exception in batch : org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement [...] Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed » Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà. [...] [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement [...] Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « account_unique_mail_domain_destroyed » Détail : La clé « (domain_id, mail, destroyed)=(1001, xxxx@xxx.xxx, 1) » existe déjà. [...] [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:Cannot process resource '56cdd551-1940-4384-aebf-f2222155e1fa' [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:Cannot process resource '56cdd551-1940-4384-aebf-f2222155e1fa' [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:CRITICAL ERROR : Batch stopped ! [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.runner.impl.BatchRunnerImpl:execute:CRITICAL ERROR : Batch stopped ! [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Critical error for the current task. Task stopped. [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Critical error for the current task. Task stopped. [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Summary : success: 0, skipped: 689, errors: 0, unhandled errors: 1 [ERROR]:org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-10:20230426.040004:org.linagora.linshare.core.batches.impl.GDPRUserBatchImpl:logError:Summary : success: 0, skipped: 689, errors: 0, unhandled errors: 1
How can I solved that?
Best regards,