FileReader is very slow to start when recycling services from the Enforce console

Products

• Data Loss Prevention Network Monitor
• Data Loss Prevention

Issue/Introduction

You notice that Network Monitor servers on Linux with a Napatech card installed are very slow (around 15 minutes) to start the Filereader service when recycling the services from the Enforce console. 

FileReader0.log


Date: 26/03/2019 12:42:55
Class: org.hibernate.engine.jdbc.spi.SqlExceptionHelper
Method: logExceptions
Level: ERROR
Message:  Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused (Connection refused).)

Also: 

Class: com.vontu.messaging.FileReaderSetup
Method: initialize
Level: SEVERE
Message:  (DETECTION.3) Failed to initialize Detection

java.lang.ExceptionInInitializerError

    at com.vontu.discover.remediation.detection.DiscoverServerRemediationDetectionConfiguration.getCatalogEntryService(DiscoverServerRemediationDetectionConfiguration.java:106)

    at com.vontu.discover.remediation.detection.DiscoverServerRemediationDetectionSubsystem.<init>(DiscoverServerRemediationDetectionSubsystem.java:47)

    at com.vontu.discover.InductorContext.initializeRemediationManager(InductorContext.java:214)

    at com.vontu.discover.InductorContext.initialize(InductorContext.java:100)

    at com.vontu.discover.InductorContext.initialize(InductorContext.java:82)

    at com.vontu.discover.DiscoverInductor.start(DiscoverInductor.java:235)

    at com.vontu.messaging.induction.InductorPool.start(InductorPool.java:163)

    at com.vontu.messaging.FileReader.start(FileReader.java:458)

    at com.vontu.messaging.FileReaderSetup.initialize(FileReaderSetup.java:105)

    at com.vontu.messaging.FileReader.main(FileReader.java:297)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in com.vontu.config.jpapersistence.JpaPersistenceSpringConfiguration: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution    ... 26 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused (Connection refused).)

 

Resolution

Workaround: 

Restarting the services via a shell script, or by rebooting the server allows the FileReader to start in a timely manner.