No luck ....

After the unpack and db move I still get same issue:

2018-07-24 08:10:07,951 INFO [main] [org.mycontroller.standalone.StartApp:113] MyController.org server started in [1231838] ms
2018-07-24 08:11:05,600 ERROR [Quartz_Scheduler_Worker-8] [org.mycontroller.standalone.db.dao.MetricsDoubleTypeDeviceDaoImpl:334] Unable to execute countOf query
org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "type: 230". Possible solution: use the recovery tool; SQL statement:
SELECT * FROM metrics_double_type_device WHERE ((timestamp > 1532368338687 AND timestamp <= 1532368398687 ) AND aggregationType = 0 ) [90030-194]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.mvstore.db.ValueDataType.readValue(ValueDataType.java:608)
at org.h2.mvstore.db.ValueDataType.readValue(ValueDataType.java:561)
at org.h2.mvstore.db.ValueDataType.read(ValueDataType.java:171)
at org.h2.mvstore.db.TransactionStore$VersionedValueType.read(TransactionStore.java:1644)
at org.h2.mvstore.Page.read(Page.java:711)
at org.h2.mvstore.Page.read(Page.java:195)
at org.h2.mvstore.MVStore.readPage(MVStore.java:1952)

How can I backup the database?
Isn't this the 9 Gig DB?

My system has been running for a long time (still version 0.0.3-SNAPSHOT).
Recently I noticed that it has become very slow.
After a brief review I noticed that the database seems to be >9Gigs (9047543808 Jul 21 08:47 mycontroller.mv.db) and
the log mentions the following:

2018-07-21 08:44:19,242 ERROR [Quartz_Scheduler_Worker-6] [org.mycontroller.standalone.metrics.MetricsAggregationBase:66] Error,
java.sql.SQLException: Could not run raw execute statement DELETE FROM metrics_double_type_device WHERE aggregationType=1 AND timestamp <= 1532133798687 
	at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25)
	at com.j256.ormlite.dao.BaseDaoImpl.executeRaw(BaseDaoImpl.java:686)
	at org.mycontroller.standalone.metrics.MetricsAggregationBase.aggregateAndInsertForBucketDuration(MetricsAggregationBase.java:63)
	at org.mycontroller.standalone.metrics.MetricsAggregationBase.executeBucketByBucket(MetricsAggregationBase.java:80)
	at org.mycontroller.standalone.metrics.MetricsAggregationBase.runAggregation(MetricsAggregationBase.java:175)
	at org.mycontroller.standalone.metrics.jobs.MetricsAggregationJob.doRun(MetricsAggregationJob.java:51)
	at org.knowm.sundial.Job.execute(Job.java:57)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:178)
	at org.quartz.core.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:515)
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "type: 230". Possible solution: use the recovery tool; SQL statement:
DELETE FROM metrics_double_type_device  WHERE aggregationType=1 AND timestamp <= 1532133798687  [90030-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.mvstore.db.ValueDataType.readValue(ValueDataType.java:608)
	at org.h2.mvstore.db.ValueDataType.readValue(ValueDataType.java:561)
	at org.h2.mvstore.db.ValueDataType.read(ValueDataType.java:171)
	at org.h2.mvstore.db.TransactionStore$VersionedValueType.read(TransactionStore.java:1644)
	at org.h2.mvstore.Page.read(Page.java:711)

Trying using the H2 Runscript to execute this is not possible since it complains that the
metrics_double_type_device does not exist.
Running the backup from within the mycontroller fails, purging does not seem to work.

Any suggestions on how to recover from this situation and upgrade the system?

Is it possible to use the backup of one instance and restore it on a new instance.

I want to migrate from my raspberry to a ubuntu server...but seem to be having migration errors when starting up after backup-restore.
2016-07-19 12:11:25,363 ERROR [main] [org.mycontroller.standalone.db.DataBaseUtils:115] Migration exception,
org.flywaydb.core.api.FlywayException: Schema "PUBLIC" contains a failed migration to version 1.02.08 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:196) ~[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]....

thx

Wim

@jkandasa
Thx,... got it to work

@Werwolfx said:

Git commit:branch
77b3dafa436fbf5a5a64a705607b874a5c0c35f0:development

Hey,

Did you ever get this iframe to work?

Hi,

I have some more questions wrt the firmware upgrade.

• How does the firmware upgrade work if the node is mostly sleeping? Do I need to make sure the node is not sleeping, keep it awake during the update?
• How can I troubleshoot the firmware update, I see the message that it is sending the stream, but I only see one message but not the whole stream?

thx

How does the automatic node ID distribution within MYController work?

When I add a new sensor ( no previous node ID) with the configuration that it does not have a fixed nodeID (set to AUTO).
It broadcasts and expects the controller to hand out a nodeID;

Can I (admin) controle which nodeID that sensor will get (maybe based on nodeName+Type+version)?

Is there anything special that needs to be done on the sensor node to allow over-the-air firmware upgrade from MYcontroller?

I uploaded a hex file (compiled within sketch), added it to a node, triggered it.
I do see the message go out , but the node does not do an update.

@jkandasa
The values from the pulse is a float.

I'll add it to github