If you’re running into H2 lock issues, in my experience, it usually means that you have a NiFi process still running somewhere. Recommend that you run “ps -ef | grep nifi”, ideally as root user (and maybe nifi user or whatever user you typically launch nifi from) to ensure that there’s currently no nifi process running.
Thanks -Mark On Aug 19, 2022, at 5:54 PM, pradeep tharthius <tharthi...@gmail.com<mailto:tharthi...@gmail.com>> wrote: Hi Team, We are using NIFI for our ETL transformation needs in our application . The version we have is Nifi 1.15.1 . we have been hit with a roadblock with an issue where nifi crashes with a write lock on the H2 database . Please see the error below , [image.png] We have tried using H2 in server mode but that did not resolve the issue . Any suggestions or guidance you can share based on similar experiences ? any help is appreciated , and is there any professional services help provided for nifi ? Please advise Regards, Tharthiusp