ConcourseSuite Support - Discussion - Concursive Corporation

Back to topics

Discuss Installation and Maintenance

Moderator: Matt Rajkowski

Derby DB Error - Can't connect - Please Help!

You need to be logged in to post messages

This question is unanswered

Derby DB Error - Can't connect - Please Help!

11/5/2008 11:26 AM EST

By Blair Sherwood

Mac os x 10.4.11
Tomcat 5.5.26
Concursive Enterprise 5.05
Derby

After installing the most recent security update from Apple we started receiving this error while trying to login to Concursive.

Access: Cannot log transaction changes, maybe trying to write to a read only database.

And then after a second login attempt we get this error:

Access: Database connection error

Obviously there is a problem with concursive accessing the derby db. Any help fixing this error would be extremely appreciated!

Below is the log from catalina.out:

Nov 5, 2008 11:15:16 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 8135 ms
WebdavModuleList-> Adding Accounts to List
WebdavModuleList-> Adding Projects to List
WebdavModuleList-> Adding Documents to List
Shutting down due to severe error.
INFO [com.darkhorseventures.database.ConnectionPool] - Connection has already been returned to pool
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
Login-> Default error: Database connection error
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.logger threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.admin.jobs.LoggerJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
Login-> Default error: Database connection error
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.logger threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.admin.jobs.LoggerJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
---> EmailKey is /Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/keys/email.key
Email Message Fetch failure : java.sql.SQLException: Database connection error
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.logger threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.admin.jobs.LoggerJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.logger threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.admin.jobs.LoggerJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
java.sql.SQLException: Database connection error
---> EmailKey is /Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/keys/email.key
at com.darkhorseventures.database.ConnectionPool.getConnection(Unknown Source)
at org.aspcfs.modules.website.jobs.SitemapGeneratorJob.execute(Unknown Source)
Email Message Fetch failure : java.sql.SQLException: Database connection error
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.siteMapGenerator threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.website.jobs.SitemapGeneratorJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more
INFO [org.quartz.core.JobRunShell] - Job DEFAULT.logger threw a JobExecutionException:
org.quartz.JobExecutionException: Database connection error
at org.aspcfs.modules.admin.jobs.LoggerJob.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

1. 11/5/2008 1:17 PM EST

By Blair Sherwood

Below is the derby.log info. Once again, any help is be greatly appreciated!

2008-11-05 16:15:15.407 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.3.1.4 - (561794): instance c013800d-011d-6d6f-aec2-00000084e1d8
on database directory /Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb

Database Class Loader started - derby.database.classpath=
2008-11-05 16:15:42.375 GMT Thread[http-8080-Processor24,5,main] (XID = 1004878), (SESSIONID = 1), (DATABASE = /Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb), (DRDAID = null), Cleanup action starting
2008-11-05 16:15:42.375 GMT Thread[http-8080-Processor24,5,main] (XID = 1004878), (SESSIONID = 1), (DATABASE = /Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb), (DRDAID = null), Failed Statement is: UPDATE "access" SET last_login = CURRENT_TIMESTAMP, last_ip = ?, hidden = ?, modified = CURRENT_TIMESTAMP, modifiedBy = ? WHERE user_id = ? with 4 parameters begin parameter #1: 192.168.11.6 :end parameter begin parameter #2: 0 :end parameter begin parameter #3: 1 :end parameter begin parameter #4: 1 :end parameter
ERROR XSTB2: Cannot log transaction changes, maybe trying to write to a read only database.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.raw.xact.Xact.logAndDo(Unknown Source)
at org.apache.derby.impl.store.raw.data.LoggableActions.doAction(Unknown Source)
at org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown Source)
at org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.aspcfs.modules.admin.base.User.updateLogin(Unknown Source)
at org.aspcfs.modules.login.actions.Login.executeCommandLogin(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:613)
2008-11-05 16:15:42.383 GMT Thread[http-8080-Processor24,5,main] Shutting down due to severe error.Cannot log transaction changes, maybe trying to write to a read only database.

2008-11-05 16:15:42.384 GMT:
Shutting down instance c013800d-011d-6d6f-aec2-00000084e1d8

New exception raised during cleanup null
java.lang.NullPointerException
at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.flush(Unknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.writePage(Unknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.clean(Unknown Source)
at org.apache.derby.impl.services.cache.CachedItem.clean(Unknown Source)
at org.apache.derby.impl.services.cache.Clock.cleanCache(Unknown Source)
at org.apache.derby.impl.services.cache.Clock.cleanAll(Unknown Source)
at org.apache.derby.impl.services.cache.Clock.shutdown(Unknown Source)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.stop(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.shutdown(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.shutdown(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.shutdown(Unknown Source)
at org.apache.derby.iapi.services.context.SystemContext.cleanupOnError(Unknown Source)
at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.aspcfs.modules.admin.base.User.updateLogin(Unknown Source)
at org.aspcfs.modules.login.actions.Login.executeCommandLogin(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:613)
Cleanup action completed
2008-11-05 16:15:42.414 GMT Thread[Thread-41,5,main] Cleanup action starting
java.sql.SQLException: Failed to start database '/Library/Application Support/CentricCRM/fileLibrary/centric/centric_crm/derbydb', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.aspcfs.utils.DatabaseUtils.getConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.makeNewConnection(Unknown Source)
at com.darkhorseventures.database.ConnectionPool.run(Unknown Source)
at java.lang.Thread.run(Thread.java:613)
Caused by: java.sql.SQLException: Derby system shutdown.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 12 more
Caused by: ERROR XJ015: Derby system shutdown.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
... 12 more

2. 11/7/2008 4:48 PM EST

By Blair Sherwood

With the help of the fantastic support team at Concursive we were able to solve my issue. The problem was with the latest security patch defaulting the derbydb permissions to group admin and read only.

Using the BatChmod app [www.macchampion.com/arbysoft/] I was able to quickly set the derbydb folder and all of its files to [Group: Everyone - Read & Write]. Thats it.

Thank you again for your help.

2 results found