# Log Error: SQLiteAppenderReader **URL:** \ **Category:** Ignition\ **Created:** [April 16, 2024, 1:29pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887 "2024-04-16T13:29:43Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [April 16, 2024, 1:29pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/1 "2024-04-16T13:29:43Z")
Hello, I get an error in my Ignition gateway more than 10 times every hour. The the logger name is "SQLiteAppenderReader" and the message is "Error executing query against logs database". What is the cause of this? I suspect it is the internal database since I have not added any SQLite databases myself. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7b9b750d1e00dd58d9d8f77a947384bcd26fd3a7.png) Here is the Call stack: ```auto java.sql.SQLException: Unable to build a valid query with the parameters provided. at com.inductiveautomation.ignition.gateway.logging.SQLiteAppenderReader.buildPrepStatement(SQLiteAppenderReader.java:129) at com.inductiveautomation.ignition.gateway.logging.SQLiteAppenderReader.query(SQLiteAppenderReader.java:154) at com.inductiveautomation.ignition.gateway.logging.GatewayLoggingManagerImpl.queryLogEvents(GatewayLoggingManagerImpl.java:144) at com.inductiveautomation.ignition.gateway.web.pages.status.routes.LoggingRoutes.getLogs(LoggingRoutes.java:561) at com.inductiveautomation.ignition.gateway.dataroutes.Route.service(Route.java:254) at com.inductiveautomation.ignition.gateway.dataroutes.RouteGroupImpl.service(RouteGroupImpl.java:61) at com.inductiveautomation.ignition.gateway.dataroutes.RouteGroupCollectionServlet.serviceInternal(RouteGroupCollectionServlet.java:59) at com.inductiveautomation.ignition.gateway.dataroutes.AbstractRouteGroupServlet.service(AbstractRouteGroupServlet.java:38) at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1410) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764) at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:131) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:578) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:223) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1383) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1305) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) at com.inductiveautomation.catapult.handlers.RemoteHostNameLookupHandler.handle(RemoteHostNameLookupHandler.java:121) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:301) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:51) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) at org.eclipse.jetty.server.Server.handle(Server.java:563) at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100) at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:934) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1078) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked) at org.sqlite.core.DB.newSQLException(DB.java:1141) at org.sqlite.core.DB.newSQLException(DB.java:1152) at org.sqlite.core.DB.throwex(DB.java:1112) at org.sqlite.core.NativeDB.prepare_utf8(Native Method) at org.sqlite.core.NativeDB.prepare(NativeDB.java:117) at org.sqlite.core.DB.prepare(DB.java:267) at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:44) at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30) at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:25) at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:155) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:135) at com.inductiveautomation.ignition.gateway.logging.SQLiteAppenderReader.buildPrepStatement(SQLiteAppenderReader.java:110) .. 48 common frames omitted ``` ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [April 16, 2024, 1:32pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/2 "2024-04-16T13:32:07Z")
Does a Gateway restart resolve this? ---
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [April 16, 2024, 1:33pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/3 "2024-04-16T13:33:55Z")
No, I restarted the Ignition process 10 min ago, and these messages started coming as soon as it was ready. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [April 16, 2024, 1:34pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/4 "2024-04-16T13:34:58Z")
Ok. Maybe try stopping the service, deleting the `logs/system_logs.idb` file (or moving/saving it somewhere), and starting it again. If that doesn't work give support a call. ---
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [April 16, 2024, 1:37pm UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/5 "2024-04-16T13:37:20Z")
OK, I will try that. Thank you for the quick response! ---
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [April 17, 2024, 7:42am UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/6 "2024-04-17T07:42:50Z")
Thanks, it worked. ---
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [April 18, 2024, 8:59am UTC](https://forum.inductiveautomation.com/t/log-error-sqliteappenderreader/88887/7 "2024-04-18T08:59:07Z")
The problem has now started appearing again, and looks the same as before. I dont think I have got the error the last two days, but today, I suddenly got two in a row (50 seconds apart). What kind of data is stored in the file? The same logs as in Status-\>Diagnostics-\>Logs? I see the loglist flashing right before the error appears in the log.