Gateway 7.8.0 backup 7.8.2 restore unsuccessful

I have a problem with gateway backup and restore from version 7.8.0 to 7.8.2

My procedure was:

  • make a gateway backup on 7.8.0
  • upgrade to 7.8.2
  • make a gateway restore on 7.8.2

The restore is done on the server (gateway) computer by the command:

sudo /usr/local/bin/ignition/gwcmd -s /home/arhiv/Ignition/Ignition-backup-20160320-1149.gwbk

and I am getting the following response:

Warning! All data in this Gateway will be overwritten! The Gateway will also restart. OK to proceed? [y/n] y
Gateway is not responding to restoration request.
Restoration success message was not received from the Gateway. Will attempt to place a __restore.gwbk file in the data folder.
invalid stored block lengths
/home/arhiv/Ignition

I am on a linux box (Ubuntu 14.04 LTS)

If I restart the gateway I can see the restoration was partly successful: the project are there. The tags however are missing completely.

I would take a look at /var/log/ignition/wrapper.log and see if any errors are present in the log during restoration. Can you post any found errors here?

I found something in the logs that migt be preventing the default tag provider to work.

Here is the excerpt…

Transition to SQLite problem?

INFO | jvm 2 | 2016/03/25 20:39:29 | ERROR [Provider[default] ] [20:39:28,968]: Error starting tag provider ‘default’
INFO | jvm 2 | 2016/03/25 20:39:29 | simpleorm.utils.SException$Jdbc: Preparing 'SELECT SQLTagAlarmProp.AlarmId, SQLTagAlarmProp.TagId, SQLTagAlarmProp.Name, SQLTagAlarmProp.IntVal, SQLTagAlarmProp.StrVal, SQLTagAlarmProp.DoubleVal,
SQLTagAlarmProp.BindType FROM SQLTagAlarmProp WHERE SQLTagAlarmProp.AlarmId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ’
INFO | jvm 2 | 2016/03/25 20:39:29 | at simpleorm.sessionjdbc.SQueryExecute.prepareStatement(SQueryExecute.java:132)
INFO | jvm 2 | 2016/03/25 20:39:29 | at simpleorm.sessionjdbc.SQueryExecute.executeQuery(SQueryExecute.java:58)
INFO | jvm 2 | 2016/03/25 20:39:29 | at simpleorm.sessionjdbc.SSessionJdbc.queryNoFlush(SSessionJdbc.java:489)
INFO | jvm 2 | 2016/03/25 20:39:29 | at simpleorm.sessionjdbc.SSessionJdbc.query(SSessionJdbc.java:498)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.query(PersistenceInterfaceImpl.java:146)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.tagproviders.internal.InternalTagStore._loadTags(InternalTagStore.java:1975)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.tagproviders.internal.InternalTagStore.loadTags(InternalTagStore.java:1706)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.tagproviders.internal.InternalTagStore.loadEverything(InternalTagStore.java:299)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.tagproviders.internal.InternalTagStore.startup(InternalTagStore.java:280)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.providers.AbstractStoreBasedTagProvider.internalStartup(AbstractStoreBasedTagProvider.java:268)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.providers.AbstractStoreBasedTagProvider.startup(AbstractStoreBasedTagProvider.java:1246)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.providers.RedundantProviderWrapper.startup(RedundantProviderWrapper.java:42)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.sqltags.SQLTagsManagerImpl.startup(SQLTagsManagerImpl.java:159)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.SRContext.startupInternal(SRContext.java:1265)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:232)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.SRContext.asyncInit(SRContext.java:982)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.SRContext.access$200(SRContext.java:256)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.gateway.SRContext$2.run(SRContext.java:710)
INFO | jvm 2 | 2016/03/25 20:39:29 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:537)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
INFO | jvm 2 | 2016/03/25 20:39:29 | at java.lang.Thread.run(Thread.java:745)
INFO | jvm 2 | 2016/03/25 20:39:29 | Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (too many SQL variables)

Hi,

Yes, this unfortunately was caught in time for 7.7.8, but not 7.8.2. I’ve put a patch up here that you can use until 7.8.3 is available: download
(It just involves stopping the gateway and replacing 2 files)

Regards,