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 <mo...@open-insights.com> 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 >
