Hi,
We are trying to set up ignition edge 7.9.13 for a project we want to deploy we have ordered a license but it’s not here yet. When trying to add roles to any authentication profile including the default one the server crashes with an internal error and doesn’t recover I need to restart the service for it to come back.
OS: Ubuntu 18.04
Java Version: 8
Ignition version: 7.9.13
INFO | jvm 1 | 2020/03/26 19:40:52 | Caused by: java.sql.SQLException: Connection is locked. Datasource only allows one connection at a time. More information was logged to the gateway console.
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource.getConnection(SingleConnectionDatasource.java:75)
INFO | jvm 1 | 2020/03/26 19:40:52 | at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:111)
INFO | jvm 1 | 2020/03/26 19:40:52 | … 53 common frames omitted
INFO | jvm 1 | 2020/03/26 19:40:52 | W [g.LicenseManager ] [19:40:51]: Unable to update demo time remaining.
INFO | jvm 1 | 2020/03/26 19:40:52 | simpleorm.utils.SException$Jdbc: Opening com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource@6951d08f
INFO | jvm 1 | 2020/03/26 19:40:52 | at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:113)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.localdb.persistence.PersistenceSession.initialize(PersistenceSession.java:31)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.getSession(PersistenceInterfaceImpl.java:62)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.save(PersistenceInterfaceImpl.java:100)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.modules.LicenseManagerImpl.saveTrialTimeRemaining(LicenseManagerImpl.java:863)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.modules.LicenseManagerImpl.shutdown(LicenseManagerImpl.java:203)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.modules.ModuleManagerImpl.shutdown(ModuleManagerImpl.java:1135)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.SRContext.shutdownInternal(SRContext.java:1752)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.SRContext.shutdown(SRContext.java:2426)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.SRContext.onDestroy(SRContext.java:2414)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.apache.wicket.Application.internalDestroy(Application.java:665)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.apache.wicket.protocol.http.WebApplication.internalDestroy(WebApplication.java:613)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.apache.wicket.protocol.http.WicketFilter.destroy(WicketFilter.java:528)
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.bootstrap.SRFilter.destroy(SRFilter.java:85)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.servlet.FilterHolder.destroyInstance(FilterHolder.java:172)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.servlet.FilterHolder.doStop(FilterHolder.java:150)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.servlet.ServletHandler.doStop(ServletHandler.java:226)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.security.SecurityHandler.doStop(SecurityHandler.java:381)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.security.ConstraintSecurityHandler.doStop(ConstraintSecurityHandler.java:456)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.session.SessionHandler.doStop(SessionHandler.java:127)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.ContextHandler.stopContext(ContextHandler.java:819)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.servlet.ServletContextHandler.stopContext(ServletContextHandler.java:355)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.webapp.WebAppContext.stopWebapp(WebAppContext.java:1385)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.webapp.WebAppContext.stopContext(WebAppContext.java:1349)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.ContextHandler.doStop(ContextHandler.java:874)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.servlet.ServletContextHandler.doStop(ServletContextHandler.java:271)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.webapp.WebAppContext.doStop(WebAppContext.java:541)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.stop(ContainerLifeCycle.java:143)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.ContainerLifeCycle.doStop(ContainerLifeCycle.java:161)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.handler.AbstractHandler.doStop(AbstractHandler.java:73)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.server.Server.doStop(Server.java:476)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.component.AbstractLifeCycle.stop(AbstractLifeCycle.java:89)
INFO | jvm 1 | 2020/03/26 19:40:52 | at org.eclipse.jetty.util.thread.ShutdownThread.run(ShutdownThread.java:138)
INFO | jvm 1 | 2020/03/26 19:40:52 | Caused by: java.sql.SQLException: Connection is locked. Datasource only allows one connection at a time. More information was logged to the gateway console.
INFO | jvm 1 | 2020/03/26 19:40:52 | at com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource.getConnection(SingleConnectionDatasource.java:75)
INFO | jvm 1 | 2020/03/26 19:40:52 | at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:111)
INFO | jvm 1 | 2020/03/26 19:40:52 | … 53 common frames omitted
INFO | jvm 1 | 2020/03/26 19:40:52 | I [g.ModuleManager ] [19:40:51]: ModuleManager shut down in 37290ms
INFO | jvm 1 | 2020/03/26 19:40:52 | I [c.i.i.g.g.WSChannelManager ] [19:40:51]: Shutting down GAN channel manager.
INFO | jvm 1 | 2020/03/26 19:40:52 | W [SRContext ] [19:40:51]: Trying to remove servlet “ws-control-servlet”, but map servlet is gone.
INFO | jvm 1 | 2020/03/26 19:40:52 | W [SRContext ] [19:40:51]: Trying to remove servlet “ws-datachannel-servlet”, but map servlet is gone.
INFO | jvm 1 | 2020/03/26 19:40:52 | W [SRContext ] [19:40:51]: Trying to remove servlet “http-datachannel-servlet”, but map servlet is gone.
INFO | jvm 1 | 2020/03/26 19:40:52 | W [SRContext ] [19:40:51]: Trying to remove servlet “http-ping-servlet”, but map servlet is gone.
INFO | jvm 1 | 2020/03/26 19:40:52 | I [Tags ] [19:40:51]: Shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [C.BasicExecutionEngine ] [19:40:51]: Execution engine ‘gateway-tagprovider-edge-sc’ shut down in 0ms
INFO | jvm 1 | 2020/03/26 19:40:52 | I [T.Provider ] [19:40:51]: Tag provider ‘edge’ stopped. tag-provider=edge
INFO | jvm 1 | 2020/03/26 19:40:52 | I [G.OPCManager ] [19:40:51]: OPCManager is shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [G.OPCManager ] [19:40:51]: Shutting down OPC server connection: “Ignition OPC-UA Server”
INFO | jvm 1 | 2020/03/26 19:40:52 | I [G.OPCManager ] [19:40:51]: OPCManager shut down in 0ms
INFO | jvm 1 | 2020/03/26 19:40:52 | I [SessionManager ] [19:40:51]: Shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [ProjectManager ] [19:40:51]: ProjectManager shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [A.N.NotificationManager ] [19:40:51]: Shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [A.S.StorageManager ] [19:40:51]: Shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | I [i.UserSourceManager ] [19:40:51]: Shutting down…
INFO | jvm 1 | 2020/03/26 19:40:52 | E [c.i.i.g.l.s.SingleConnectionDatasource] [19:40:51]: The following stack successfully received a connection. A new attempt was blocked for over 30000 ms
INFO | jvm 1 | 2020/03/26 19:40:52 | java.lang.Throwable: null