Re: Request JIRA contributor access

[Andy LoPresto]

I’ve added you to the contributors. Welcome to the project. 

Andy LoPresto
alopre...@apache.org
alopresto.apa...@gmail.com
He/Him
PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4  BACE 3C6E F65B 2F7D EF69

> On Jul 10, 2020, at 10:35 PM, Cuong Nguyen  wrote:
> 
> Hi there,
> 
> I'd like to request for JIRA contributor access on the Nifi project.
> My Github username: ndc629
> 
> Thanks in advance,
> Cuong Nguyen.

Request JIRA contributor access

[Cuong Nguyen]

Hi there,

I'd like to request for JIRA contributor access on the Nifi project.
My Github username: ndc629

Thanks in advance,
Cuong Nguyen.

Re: Urgent: Unable to configure any NiFi processor

[Mike Thomsen]

It looks like the version we're running is pretty old. I just created a
Jira ticket to start the upgrade.

On Sat, Jul 11, 2020 at 7:16 AM Matt Gilman  wrote:

> Mohit,
>
> H2 might offer a utility for repairing a corrupted database. In order to
> get NiFi running again, you should be able to move/rename the audit db
> files and restart. NiFi should recreate them on restart. This database is
> used just to store some metadata about users and flow changes. It is not
> used for managing the actual flow state.
>
> It’s unclear what’s happened to result in a corrupted state. However H2 is
> a library that does get upgraded occasionally. My first thought would be to
> ensure that your always running the latest version of NiFi with the newest
> version of H2 that NiFi’s been upgraded to.
>
> Matt
>
> Sent from my iPhone
>
> > On Jul 11, 2020, at 06:52, Mohit Jain  wrote:
> >
> > Hi Team,
> >
> > It seems like the nifi-flow-audit.h2.db is corrupted. I'm not able to
> > execute the same query on the database directly.
> > Anything I can do to fix this?
> > And what are the scenarios when this might happen again?
> >
> > Regards,
> > Mohit
> >
> >
> >> On Sat, Jul 11, 2020 at 3:03 PM Mohit Jain 
> wrote:
> >>
> >> Hi Team,
> >>
> >> I'm facing a weird issue while trying to configure any NiFi processor:
> >>
> >> org.apache.nifi.admin.dao.DataAccessException:
> >> org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
> >> "CONFIGURE_DETAILS"; SQL statement:
> >> SELECT DISTINCT CD.NAME  FROM CONFIGURE_DETAILS CD
> INNER
> >> JOIN ACTION A ON CD.ACTION_ID = A.ID  WHERE A.SOURCE_ID
> = ?
> >> [50200-176]
> >> at
> >>
> org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
> >>at
> >>
> org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
> >>at
> >>
> org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()
> >>
> >> Complete nifi-user.log is attached in the log.
> >>
> >> Any input would be appreciated.
> >>
> >> Regards,
> >> Mohit
> >>
>

Re: Urgent: Unable to configure any NiFi processor

[Mohit Jain]

Thanks Matt,

Would do that to remove the blocker. I'm still trying to figure out the
root cause of this issue so that it won't happen again in the future.

We faced the same issue in two separate nifi clusters in a day. There is a
java service which extensively uses NiFi rest apis(sometimes refreshes
access tokens frequently), wondering if it has something to do with the
issue.

Any insights would be appreciated.

Thanks,
Mohit



On Sat, Jul 11, 2020 at 4:46 PM Matt Gilman  wrote:

> Mohit,
>
> H2 might offer a utility for repairing a corrupted database. In order to
> get NiFi running again, you should be able to move/rename the audit db
> files and restart. NiFi should recreate them on restart. This database is
> used just to store some metadata about users and flow changes. It is not
> used for managing the actual flow state.
>
> It’s unclear what’s happened to result in a corrupted state. However H2 is
> a library that does get upgraded occasionally. My first thought would be to
> ensure that your always running the latest version of NiFi with the newest
> version of H2 that NiFi’s been upgraded to.
>
> Matt
>
> Sent from my iPhone
>
> > On Jul 11, 2020, at 06:52, Mohit Jain  wrote:
> >
> > Hi Team,
> >
> > It seems like the nifi-flow-audit.h2.db is corrupted. I'm not able to
> > execute the same query on the database directly.
> > Anything I can do to fix this?
> > And what are the scenarios when this might happen again?
> >
> > Regards,
> > Mohit
> >
> >
> >> On Sat, Jul 11, 2020 at 3:03 PM Mohit Jain 
> wrote:
> >>
> >> Hi Team,
> >>
> >> I'm facing a weird issue while trying to configure any NiFi processor:
> >>
> >> org.apache.nifi.admin.dao.DataAccessException:
> >> org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
> >> "CONFIGURE_DETAILS"; SQL statement:
> >> SELECT DISTINCT CD.NAME  FROM CONFIGURE_DETAILS CD
> INNER
> >> JOIN ACTION A ON CD.ACTION_ID = A.ID  WHERE A.SOURCE_ID
> = ?
> >> [50200-176]
> >> at
> >>
> org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
> >>at
> >>
> org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
> >>at
> >>
> org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()
> >>
> >> Complete nifi-user.log is attached in the log.
> >>
> >> Any input would be appreciated.
> >>
> >> Regards,
> >> Mohit
> >>
>

Re: Urgent: Unable to configure any NiFi processor

[Matt Gilman]

Mohit,

H2 might offer a utility for repairing a corrupted database. In order to get 
NiFi running again, you should be able to move/rename the audit db files and 
restart. NiFi should recreate them on restart. This database is used just to 
store some metadata about users and flow changes. It is not used for managing 
the actual flow state. 

It’s unclear what’s happened to result in a corrupted state. However H2 is a 
library that does get upgraded occasionally. My first thought would be to 
ensure that your always running the latest version of NiFi with the newest 
version of H2 that NiFi’s been upgraded to.

Matt

Sent from my iPhone

> On Jul 11, 2020, at 06:52, Mohit Jain  wrote:
> 
> Hi Team,
> 
> It seems like the nifi-flow-audit.h2.db is corrupted. I'm not able to
> execute the same query on the database directly.
> Anything I can do to fix this?
> And what are the scenarios when this might happen again?
> 
> Regards,
> Mohit
> 
> 
>> On Sat, Jul 11, 2020 at 3:03 PM Mohit Jain  wrote:
>> 
>> Hi Team,
>> 
>> I'm facing a weird issue while trying to configure any NiFi processor:
>> 
>> org.apache.nifi.admin.dao.DataAccessException:
>> org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
>> "CONFIGURE_DETAILS"; SQL statement:
>> SELECT DISTINCT CD.NAME  FROM CONFIGURE_DETAILS CD INNER
>> JOIN ACTION A ON CD.ACTION_ID = A.ID  WHERE A.SOURCE_ID = ?
>> [50200-176]
>> at
>> org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
>>at
>> org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
>>at
>> org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()
>> 
>> Complete nifi-user.log is attached in the log.
>> 
>> Any input would be appreciated.
>> 
>> Regards,
>> Mohit
>> 

Re: Urgent: Unable to configure any NiFi processor

[Mohit Jain]

Hi Team,

It seems like the nifi-flow-audit.h2.db is corrupted. I'm not able to
execute the same query on the database directly.
Anything I can do to fix this?
And what are the scenarios when this might happen again?

Regards,
Mohit


On Sat, Jul 11, 2020 at 3:03 PM Mohit Jain  wrote:

> Hi Team,
>
> I'm facing a weird issue while trying to configure any NiFi processor:
>
> org.apache.nifi.admin.dao.DataAccessException:
> org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
> "CONFIGURE_DETAILS"; SQL statement:
> SELECT DISTINCT CD.NAME  FROM CONFIGURE_DETAILS CD INNER
> JOIN ACTION A ON CD.ACTION_ID = A.ID  WHERE A.SOURCE_ID = ?
> [50200-176]
>  at
> org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
> at
> org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
> at
> org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()
>
> Complete nifi-user.log is attached in the log.
>
> Any input would be appreciated.
>
> Regards,
> Mohit
>

Urgent: Unable to configure any NiFi processor

[Mohit Jain]

Hi Team,

I'm facing a weird issue while trying to configure any NiFi processor:

org.apache.nifi.admin.dao.DataAccessException:
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
"CONFIGURE_DETAILS"; SQL statement:
SELECT DISTINCT CD.NAME  FROM CONFIGURE_DETAILS CD INNER
JOIN ACTION A ON CD.ACTION_ID = A.ID  WHERE A.SOURCE_ID = ?
[50200-176]
 at
org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
at
org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
at
org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()

Complete nifi-user.log is attached in the log.

Any input would be appreciated.

Regards,
Mohit
2020-07-11 09:06:53,063 ERROR [NiFi Web Server-28918] 
o.a.n.w.a.c.AdministrationExceptionMapper 
org.apache.nifi.admin.service.AdministrationException: 
org.apache.nifi.admin.dao.DataAccessException: org.h2.jdbc.JdbcSQLException: 
Timeout trying to lock table "CONFIGURE_DETAILS"; SQL statement:
SELECT DISTINCT CD.NAME FROM CONFIGURE_DETAILS CD INNER JOIN ACTION A ON 
CD.ACTION_ID = A.ID WHERE A.SOURCE_ID = ? [50200-176]. Returning Internal 
Server Error response.
org.apache.nifi.admin.service.AdministrationException: 
org.apache.nifi.admin.dao.DataAccessException: org.h2.jdbc.JdbcSQLException: 
Timeout trying to lock table "CONFIGURE_DETAILS"; SQL statement:
SELECT DISTINCT CD.NAME FROM CONFIGURE_DETAILS CD INNER JOIN ACTION A ON 
CD.ACTION_ID = A.ID WHERE A.SOURCE_ID = ? [50200-176]
at 
org.apache.nifi.admin.service.impl.StandardAuditService.getPreviousValues(StandardAuditService.java:102)
at 
org.apache.nifi.web.StandardNiFiServiceFacade.getComponentHistory(StandardNiFiServiceFacade.java:4537)
at 
org.apache.nifi.web.StandardNiFiServiceFacade$$FastClassBySpringCGLIB$$358780e0.invoke()
at 
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:84)
at 
org.apache.nifi.web.NiFiServiceFacadeLock.proceedWithReadLock(NiFiServiceFacadeLock.java:155)
at 
org.apache.nifi.web.NiFiServiceFacadeLock.getLock(NiFiServiceFacadeLock.java:120)
at sun.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
at 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
at 
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
at 
org.apache.nifi.web.StandardNiFiServiceFacade$$EnhancerBySpringCGLIB$$c0d134ca.getComponentHistory()
at 
org.apache.nifi.web.api.FlowResource.getComponentHistory(FlowResource.java:2548)
at sun.reflect.GeneratedMethodAccessor1088.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76)
at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148)
at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191)
at 
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:200)
at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103)
at 
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:493)
at