ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 184237

calendar_today

Updated On:

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 will release the lock.