You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by pradeep tharthius <th...@gmail.com> on 2022/08/19 21:54:42 UTC

H12 database lock issue in NIFI

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: 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

Re: H12 database lock issue in NIFI

Posted by Mark Payne <ma...@hotmail.com>.
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 <th...@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

Re: H12 database lock issue in NIFI

Posted by Mike Thomsen <mi...@gmail.com>.
> is there any professional services help provided for nifi ?

Cloudera provides great support (I'm not a Cloudera employee). They would
be a good option. Another option would be to try updating to 1.16.X or
1.17. I think somewhere in there, the H2 version was updated so you might
get a better version of H2 in there.

On Fri, Aug 19, 2022 at 6:01 PM pradeep tharthius <th...@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: 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
>
>
>

Re: H12 database lock issue in NIFI

Posted by Jim Halfpenny <ji...@source321.com>.
Hi,
Stackable offers professional support for NiFi (https://stackable.tech/) as
part of Stackable Data Platform. Unfortunately I cannot see the image with
the error message, are you able to paste the text of the error message into
your email?

Kind regards,
Jim

On 19 Aug 2022, at 22:54, pradeep tharthius <th...@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: 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