Urgent: Facing issue while trying to open a NiFi processor

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Urgent: Facing issue while trying to open a 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(<generated>)

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

Any input would be appreciated.

Regards,
Mohit

nifi-issue.txt (65K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Urgent: Facing issue while trying to open a 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 2:48 PM Mohit Jain <[hidden email]> 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(<generated>)

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

Any input would be appreciated.

Regards,
Mohit