Task Engine Error Post server start

[shrikant_nikam]

I am facing below error post sever start

ERROR [Task-master-poll] [DefaultTaskService] Caught exception while polling pending tasks. java.lang.IllegalStateException: Duplicate key PT0.003S at java.util.stream.Collectors.lambda$throwingMerger$0(Collectors.java:133) ~[?:1.8.0_191]

Its filling logs very much , is anyone faced similar issue ?

[gaurav11]

Hi Srikant,

There 2 options.

1. You can re-initialize the system.

2. You need to run query in DB "select * from tasks_aux_workers; and if there are multiple results delete it the same. and update the system.

[Eddy_]

This solution worked for us as well. We experienced it after a faulty cluster setup.

[former_member822013]

I have faced this issue today, it's about task engine problem.So I have checked standard processing extension code and I solved this issue like that:

1-)Run the query in hac SQL tab => SELECT * FROM tasks_aux_workers (I saw 5 records)

2-)After that run => DELETE FROM tasks_aux_workers

In the end, the task engine works successfully

[Eddy_]

thanks for sharing!

[former_member740121]

The same is happening for us in y2105 and y2205, it's rare but with fatal consequences as the whole task engine stops working. We use the same solution as proposed above by deleting the content `task_aux_workers` table, but why does it happen at all? Looks like the problem was introduced by AuxiliaryTablesTasksProvider Strategy for Fetching Tasks. The solution is obviously not cluster safe.