# \[IGN-4941\]Error thrown while attempting to cleanup stale schema records

**URL:** <https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [April 6, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105 "2022-04-06T13:12:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![houfa\_zhu](https://avatars.discourse-cdn.com/v4/letter/h/50afbb/32.png) [@houfa\_zhu](https://forum.inductiveautomation.com/u/houfa_zhu)\
**Post date:** [April 6, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105/1 "2022-04-06T13:12:22Z")

</div>

Some error shows on the log periodically. would someone see this before and know how it could be solved? Thanks.

java.sql.SQLNonTransientConnectionException: connection exception: closed  
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)  
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)  
at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)  
at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)  
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:301)  
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:301)  
at com.inductiveautomation.ignition.gateway.localdb.DelegatingDataSource$DelegatingConnection.prepareStatement(DelegatingDataSource.java:281)  
at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.cleanupSchemas(AbstractDatasourceStore.java:462)  
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:582)  
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source)  
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.base/java.lang.Thread.run(Unknown Source)  
Caused by: org.hsqldb.HsqlException: connection exception: closed  
at org.hsqldb.error.Error.error(Unknown Source)  
at org.hsqldb.error.Error.error(Unknown Source)  
at org.hsqldb.Session.execute(Unknown Source)  
… 13 common frames omitted

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [April 6, 2022, 2:55pm UTC](https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105/2 "2022-04-06T14:55:54Z")

</div>

This error is coming to Ignition from the database. Here's what [the Javadocs](https://docs.oracle.com/javase/8/docs/api/java/sql/SQLNonTransientConnectionException.html) say about this error:

> The subclass of [`SQLException`](https://docs.oracle.com/javase/8/docs/api/java/sql/SQLException.html) thrown for the SQLState class value ' _08_ ', or under vendor-specified conditions. This indicates that the connection operation that failed will not succeed if the operation is retried without the cause of the failure being corrected.

> Please consult your driver vendor documentation for the vendor-specified conditions for which this `Exception` may be thrown.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 6, 2022, 4:31pm UTC](https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105/3 "2022-04-06T16:31:04Z")

</div>

This is an error happening due to a maintenance task against the ‘disk cache’ portion of store and forward. It’s on our list to investigate, but should be safe to ignore.

---

<div class="post-metadata">

**Author:** ![houfa\_zhu](https://avatars.discourse-cdn.com/v4/letter/h/50afbb/32.png) [@houfa\_zhu](https://forum.inductiveautomation.com/u/houfa_zhu)\
**Post date:** [April 6, 2022, 4:47pm UTC](https://forum.inductiveautomation.com/t/ign-4941-error-thrown-while-attempting-to-cleanup-stale-schema-records/58105/4 "2022-04-06T16:47:40Z")

</div>

thanks for the information. hopefully we can come up with some solution in the future but for now we will just ignore it.