Gateway Log doesn't show any logs even though it says that many are in there

I’m seeing the above whenever I go into my Gateway logs. It says I have over 7000 log items, but none of them show up. There’s no filtering going on, I haven’t even looked at this page until now since installing this Gateway.

Are any errors showing in the browser’s console?

DevTools failed to parse SourceMap: http://localhost:8088/web/status/twotiermenu.js.map
DevTools failed to parse SourceMap: http://localhost:8088/web/status/GatewayBreadcrumb.js.map
DevTools failed to parse SourceMap: http://localhost:8088/web/status/trialbar.js.map
DevTools failed to parse SourceMap: http://localhost:8088/web/status/logviewer.js.map

These are the only items that show up in the console log.

Can you enable devtools and see what’s coming in on the ‘Network’ tab? Also, check the /logs/ directory on the gateway machine - it could be (somewhat ironically) that an error message is occurring in the function that’s meant to retrieve the logs, which is only being logged into those same logs. If you’re not sure what you’re looking at, just post the wrapper.log file here.

wrapper.zip (278.9 KB)

I’ve had to compress the wrapper.log file since it was about 7MB.

In the Network tab in the devtools there don’t seem to be any errors, just a lot of requests for “trial”.

These “trial” requests continue for a very long time.

Yep, error is with the logging system:

INFO   | jvm 1    | 2019/06/13 13:54:07 | E [c.i.i.g.l.SQLiteAppenderReader] [18:54:07]: Error executing query against logs database. route-group=status, route-path=/logs
INFO   | jvm 1    | 2019/06/13 13:54:07 | java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.sqlite.core.DB.newSQLException(DB.java:890)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.sqlite.core.DB.newSQLException(DB.java:901)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.sqlite.core.DB.execute(DB.java:810)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.sqlite.jdbc3.JDBC3PreparedStatement.executeQuery(JDBC3PreparedStatement.java:68)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.logging.SQLiteAppenderReader.executePrepStatement(SQLiteAppenderReader.java:97)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.logging.SQLiteAppenderReader.query(SQLiteAppenderReader.java:170)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.logging.GatewayLoggingManagerImpl.queryLogEvents(GatewayLoggingManagerImpl.java:144)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.web.pages.status.routes.LoggingRoutes.getLogs(LoggingRoutes.java:561)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.dataroutes.Route.service(Route.java:247)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.dataroutes.RouteGroupImpl.service(RouteGroupImpl.java:49)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at com.inductiveautomation.ignition.gateway.dataroutes.DataServlet.service(DataServlet.java:87)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:852)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.Server.handle(Server.java:530)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:347)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:256)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:382)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:708)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:626)
INFO   | jvm 1    | 2019/06/13 13:54:07 | 	at java.base/java.lang.Thread.run(Unknown Source)

You can safely delete the system_logs.idb file in the /logs/ directory (you’ll obviously lose the currently logged events, but they’re also duplicated into the wrapper.log files). The log file won’t recreate until you restart the gateway, though.

3 Likes

That fixed it! Thank you!

1 Like

Is there any way to do this without resting the service?

Thanks

No.