# New Edge 7.9.13 install on Ubuntu 18.04 not allowing us to create roles

**URL:** <https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [March 26, 2020, 7:57pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462 "2020-03-26T19:57:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shawn.Schwark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn.schwark/32/14045_2.png) [@Shawn.Schwark](https://forum.inductiveautomation.com/u/Shawn.Schwark)\
**Post date:** [March 26, 2020, 7:57pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462/1 "2020-03-26T19:57:14Z")

</div>

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](mailto: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

---

<div class="post-metadata">

**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:** [March 26, 2020, 7:58pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462/2 "2020-03-26T19:58:47Z")

</div>

Same issue as here, I think: [Ignition Edge: Adding new users/roles gateway locks up](http://forum.inductiveautomation.com/t/ignition-edge-adding-new-users-roles-gateway-locks-up/33266/3?u=kevin.herron)

Unfortunately it sounds like rolling back to 7.9.12 until 7.9.14 is released is the only option.

---

<div class="post-metadata">

**Author:** ![Shawn.Schwark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn.schwark/32/14045_2.png) [@Shawn.Schwark](https://forum.inductiveautomation.com/u/Shawn.Schwark)\
**Post date:** [March 26, 2020, 8:12pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462/3 "2020-03-26T20:12:09Z")

</div>

Thank you I did not see that post ill just use 7.9.12 for now and idea when 7.9.14 will be released?

---

<div class="post-metadata">

**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:** [March 26, 2020, 8:14pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462/4 "2020-03-26T20:14:26Z")

</div>

7.9 releases are spaced fairly far apart these days, looks like it’s currently scheduled for April 28 😔

---

<div class="post-metadata">

**Author:** ![Shawn.Schwark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shawn.schwark/32/14045_2.png) [@Shawn.Schwark](https://forum.inductiveautomation.com/u/Shawn.Schwark)\
**Post date:** [March 26, 2020, 9:19pm UTC](https://forum.inductiveautomation.com/t/new-edge-7-9-13-install-on-ubuntu-18-04-not-allowing-us-to-create-roles/33462/5 "2020-03-26T21:19:46Z")

</div>

Ok no worries i ended up installing 7.9.12 making all the changes to the roles i needed then upgraded to 7.9.13 and working good for now
