Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

PutSQL if Node die

avatar
Contributor

Hi All,

I have the theoretical question.

What happened if PutSQL sent the request to SQL server and exactly in this time Node failed(die/power shutdown).

PutSQL did not receive the answer from the SQL server if rows were inserted or not.

What does happen in this way? Will this rows be sent one more time? or will be sent to fail connection?

Or something else will happen?

Thanks

1 ACCEPTED SOLUTION

avatar
Super Mentor
@Ilya Li

-

Each NiFi processor component must complete its execution before the triggering FlowFile is routed to one of the outbound relationships from the incoming connection.
-

Using you example:
the PutSQL processor would execute based on an incoming Flow or batch of incoming FlowFiles. Should NiFi completely die in the middle of the scheduled execution. Upon NiFi recover the FlowFile or Batch of Flowfiles would still be located on incoming connection to the putSQL processor and the same execution would occur again.

-

Thank you,

Matt

-

When an "Answer" addresses/solves your question, please select "Accept" beneath that answer. This encourages user participation in this forum.

View solution in original post

1 REPLY 1

avatar
Super Mentor
@Ilya Li

-

Each NiFi processor component must complete its execution before the triggering FlowFile is routed to one of the outbound relationships from the incoming connection.
-

Using you example:
the PutSQL processor would execute based on an incoming Flow or batch of incoming FlowFiles. Should NiFi completely die in the middle of the scheduled execution. Upon NiFi recover the FlowFile or Batch of Flowfiles would still be located on incoming connection to the putSQL processor and the same execution would occur again.

-

Thank you,

Matt

-

When an "Answer" addresses/solves your question, please select "Accept" beneath that answer. This encourages user participation in this forum.