# Edge Ver 8.1.31 Backup issue

**URL:** <https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533>\
**Category:** Ignition\
**Created:** [August 29, 2023, 10:27pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533 "2023-08-29T22:27:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith\_Magill](https://avatars.discourse-cdn.com/v4/letter/k/85e7bf/32.png) [@Keith\_Magill](https://forum.inductiveautomation.com/u/Keith_Magill)\
**Post date:** [August 29, 2023, 10:27pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/1 "2023-08-29T22:27:54Z")

</div>

For some reason the link to [http://localhost:8088/system/backup/partial](http://localhost:8088/system/backup/partial)  
fails. Says it is not available?

This is on a VMWARE development Windows 10 Pro OS

I cannot make any backups to move the Edge project to its runtime machine...

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 29, 2023, 10:41pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/2 "2023-08-29T22:41:53Z")

</div>

Look in your gateway log for errors while the gateway attempted to construct the backup. (Lack of disk space, lack of memory, perhaps.)

---

<div class="post-metadata">

**Author:** ![Keith\_Magill](https://avatars.discourse-cdn.com/v4/letter/k/85e7bf/32.png) [@Keith\_Magill](https://forum.inductiveautomation.com/u/Keith_Magill)\
**Post date:** [August 29, 2023, 11:15pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/3 "2023-08-29T23:15:27Z")

</div>

There is 187 GB on the hard drive..

Log file contains this

> java.io.IOException: Error creating backup.
> 
> at com.inductiveautomation.ignition.gateway.localdb.sqlite.SQLiteDBManager.backupDatabase(SQLiteDBManager.java:476)
> 
> at com.inductiveautomation.ignition.gateway.servlets.BackupServlet.generateBackup(BackupServlet.java:176)
> 
> at com.inductiveautomation.ignition.gateway.servlets.BackupServlet.doBackup(BackupServlet.java:161)
> 
> at com.inductiveautomation.ignition.gateway.servlets.BackupServlet.doGet(BackupServlet.java:429)
> 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:503)
> 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
> 
> at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86)
> 
> 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:1384)
> 
> 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:1306)
> 
> 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:969)
> 
> at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)
> 
> at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)
> 
> at java.base/java.lang.Thread.run(Unknown Source)
> 
> Caused by: org.sqlite.SQLiteException: [SQLITE\_CANTOPEN] Unable to open the database file (Restore failed)
> 
> at org.sqlite.core.DB.newSQLException(DB.java:1179)
> 
> at org.sqlite.ExtendedCommand$BackupCommand.execute(ExtendedCommand.java:106)
> 
> at org.sqlite.jdbc3.JDBC3Statement.lambda$executeLargeUpdate$2(JDBC3Statement.java:122)
> 
> at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454)
> 
> at org.sqlite.jdbc3.JDBC3Statement.executeLargeUpdate(JDBC3Statement.java:115)
> 
> at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:102)
> 
> at com.inductiveautomation.ignition.gateway.localdb.DelegatingDataSource$DelegatingConnection$DelegatingStatement.executeUpdate(DelegatingDataSource.java:421)
> 
> at com.inductiveautomation.ignition.gateway.localdb.AbstractDBInterface.runUpdateQuery(AbstractDBInterface.java:222)
> 
> at com.inductiveautomation.ignition.gateway.localdb.sqlite.SQLiteDBManager.backupDatabase(SQLiteDBManager.java:468)
> 
> ... 47 common frames omitted

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 29, 2023, 11:18pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/4 "2023-08-29T23:18:04Z")

</div>

> [@Keith\_Magill](#):
>
> Caused by: org.sqlite.SQLiteException: [SQLITE\_CANTOPEN] Unable to open the database file (Restore failed)

That's ugly. You should contact support.

---

<div class="post-metadata">

**Author:** ![Keith\_Magill](https://avatars.discourse-cdn.com/v4/letter/k/85e7bf/32.png) [@Keith\_Magill](https://forum.inductiveautomation.com/u/Keith_Magill)\
**Post date:** [August 29, 2023, 11:42pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/5 "2023-08-29T23:42:41Z")

</div>

Interesting for sure....  
Is there a manual way I can backup the Edge project??

---

<div class="post-metadata">

**Author:** ![Keith\_Magill](https://avatars.discourse-cdn.com/v4/letter/k/85e7bf/32.png) [@Keith\_Magill](https://forum.inductiveautomation.com/u/Keith_Magill)\
**Post date:** [August 29, 2023, 11:44pm UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/6 "2023-08-29T23:44:13Z")

</div>

I didn't install SQLite... Is that installed with the EDGE installation?  
On the Ignition Gateway projects I install SQL separately

---

<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:** [August 30, 2023, 12:29am UTC](https://forum.inductiveautomation.com/t/edge-ver-8-1-31-backup-issue/78533/7 "2023-08-30T00:29:37Z")

</div>

SQLite is a SQL-compatible single-file database used by Ignition internally for, among other things, the internal database used to store all gateway configuration. You don't have to install it; it's built in to Ignition.

That error Phil highlighted suggests something's gone _very_ wrong with the SQLite process. I've never seen it before. You should really contact support.

You could try using the gateway command line utility ([gwcmd](https://docs.inductiveautomation.com/display/DOC81/Gateway+Command-line+Utility+-+gwcmd)), but I have no reason to think it would do any better than the web UI here.
