Support Questions

Find answers, ask questions, and share your expertise

PutSQL with errors

avatar
Master Guru

I have 60,000 flow files in a PutSQL processor and I know the SQL is invalid and it is failing in chunks and waiting 1 second and moving through. I was able to empty out all the backed up queues, but this processor is slowly parsing these failed files.

I want to purge them out, how can I do this? It's a waste to wait knowing all these will fail.

1 ACCEPTED SOLUTION

avatar

The easiest way is to stop NiFi, delete all files in the content and flowfile repositories, then restart NiFi.

View solution in original post

1 REPLY 1

avatar

The easiest way is to stop NiFi, delete all files in the content and flowfile repositories, then restart NiFi.