question Re: NiFi Crash after runing chain of lookups in Support Questions

NiFi Crash after runing chain of lookups

jarviszzzz — Thu, 11 Jan 2024 06:14:34 GMT

Hi all,

My nifi crash for some reasons that I could not figure out, can anyone helps?

1. A chain of lookups that I have, the table being looked up contains around 50,000,000 rows

2. After running some node, it crashed like this:

3. After this, I relogged into NiFi to see what error happened:

My Lookup service setup:

I can provide more details upon request.

Please help!!!Thanks

Re: NiFi Crash after runing chain of lookups

VidyaSargur — Thu, 11 Jan 2024 11:17:58 GMT

@jarviszzzz, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi @cotopaul @SAMSAL @TimothySpann experts who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: NiFi Crash after runing chain of lookups

TimothySpann — Thu, 11 Jan 2024 16:05:01 GMT

How many nodes? How much RAM and CPUs per node? Which version of NiFi? Which version of JDK?

I recommend 128GB RAM, 32cores, 6 nodes+, JDK 21.

Also for that many rows you probably want to use a real database and not the tiny cache server. I would say Redis could work.

Re: NiFi Crash after runing chain of lookups

jarviszzzz — Fri, 12 Jan 2024 02:47:15 GMT

Dear Timothy,

I actually figured out the reason why it crash, so I change my local pc to a CPU server.

Below is the Pics for CPU and RAM:

I am actually using two server for this NiFi operation, one is holding Mysql Server, another one is for NiFi.

However, It still shows slowness for running the lookup processor. How can I make it faster? Thank you so much.

Please let me know if any other information that you need

Re: NiFi Crash after runing chain of lookups

TimothySpann — Fri, 12 Jan 2024 16:19:35 GMT

make sure you are running 1.24 or 2.0 nifi.

Add more connections in your pool, maybe 32

make sure you mysql has enough ram and cores, also make sur eyou have a fast network between them

restart after you update the conf/bootstrap.conf

java.arg.2=-Xms64G
java.arg.3=-Xmx128G

change lookup

Re: NiFi Crash after runing chain of lookups

jarviszzzz — Wed, 17 Jan 2024 02:26:57 GMT

Hi Timothy,

Thank you so much for helping. I also made some changes (adding index, change data types etc.,) for mysql database. Now, it ran much faster than before