sneha sriram created NIFI-9257:
----------------------------------
Summary: ExecuteSQLRecord processor doesn't honor the max wait
time config when set to 5mins
Key: NIFI-9257
URL: https://issues.apache.org/jira/browse/NIFI-9257
Project: Apache NiFi
Issue Type: Bug
Components: Extensions
Affects Versions: 1.12.1
Environment: software platform
Reporter: sneha sriram
For postgres function/SQL which take longer to run(~more than 5 min),
Assume SQL takes 8 min to complete, so to avoid query getting killed by
ExecuteSQLRecord processor ( with Max Wait time = 5 min), need to increase Max
Wait time > 8 min. So updated Max Wait time = 10 mins
* ExecuteSQLRecord processor receives flow files from incoming queue
* ExecuteSQLRecord processor triggers/submit postgres functions/SQL to aurora
postgres server
* If aurora postgres function/SQL is taking longer to process(~more than 5
min), *ExecuteSQLRecord processor is getting stuck in running state,* even
after postgres function/SQL completes its execution on aurora postgres server
* It stays in running stuck state indefinitely
* All downstream processors are not getting any flow files to run
* This issue was observed with different postgres functions and SQLs
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
