ERROR XSDB6: Another instance of Derby may have already booted the database

Products

• Data Loss Prevention Endpoint Prevent
• Data Loss Prevention Network Prevent for Email
• Data Loss Prevention Network Discover
• Data Loss Prevention Network Protect
• Data Loss Prevention Endpoint Discover

Issue/Introduction

Symantec Data Loss Prevention (DLP)

Filereader restarts with alerts, "FileReader was restarted because it wasn't responding" or "FileReader restarts excessively".

INFO | jvm 1 | 2016/06/15 04:00:28 | Caused by: java.sql.SQLException: Failed to start database 'CSV_LOOKUP_DATABASE', see the next exception for details.
INFO | jvm 1 | 2016/06/15 04:00:28 | at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
INFO | jvm 1 | 2016/06/15 04:00:28 | at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
INFO | jvm 1 | 2016/06/15 04:00:28 | ... 43 more
INFO | jvm 1 | 2016/06/15 04:00:28 | Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database G:\Vontu\Protect\bin\CSV_LOOKUP_DATABASE.
INFO | jvm 1 | 2016/06/15 04:00:28 | at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

INFO | jvm 1 | 2016/05/04 04:00:28 | Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database G:\Vontu\Protect\bin\CSV_LOOKUP_DATABASE.
INFO | jvm 1 | 2016/05/04 04:00:28 | at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 

Cause

There are two known causes:

1. Two JVM instances are trying to contact the same Derby database, which is not allowed.

2. The Derby database shut down ungracefully and the lock on it was not released.

Resolution

Restarting the machine that is hosting the Enforce Server will release the lock.