Purge job is not working in ConnectALL 3.7 with MYSQL

Products

• ConnectALL
• ConnectAll On-Prem
• ConnectAll SaaS

Issue/Introduction

Steps to Reproduce:

1. Setup the purge job by enabling it via ../ConnectALL/Core/conf/ConnectAll.properties
2. Update the schedule as per need.
3. Setup purgeTableDetails.json if not done already.
4. Restart scheduler service and wait for the job to run.

 

Expected Results: 

Respective table data should be purged as per configured values.

 

Actual Results: 

Job runs but records in poll_details table are not purged. Below error can be seen in jobs.log. Complete logs attached.

ERROR 2025-03-21 11:00:00,290 [-1379664529 | jobs |  |  | {}][(connectall-flows) thread #92 - JmsConsumer[jobQ]] com.go2group.connectall.housekeeping.DBDataHouseKeeper: Exception occurs while executing the purge query delete from poll_details where poll_details_id not in (select distinct p.poll_details_id from poll_details p, record_transaction_details r where p.poll_details_id = r.poll_id) and  polled_time < ?  due to 
java.sql.SQLException: You can't specify target table 'poll_details' for update in FROM clause

 

Environment

3.7.x

Cause

DE168102

Resolution

Investigation Underway