0.0.3.Final pre-release - volunteers required to test

Tetnobic

With the last release : Application information: [Version:0.0.3.Final-SNAPSHOT, Database version:1.03.05 - 2016 Nov 18, Built on:2017-01-16T22:09:06+0530, Git commit:21d0b3a52ab32e475afb53e0a832146ca678b015:development]

when I try to restore database, I have this in log :

2017-01-17 09:52:35,950 INFO [main] [org.mycontroller.standalone.StartApp:108] MyController.org server started in [54734] ms
2017-01-17 09:57:45,673 INFO [Acme.Utils.ThreadPool(5)-PooledThread: Acme.Serve.Serve$ServeConnection@197cc8d] [org.mycontroller.standalone.api.BackupApi:219] Restore triggered.
2017-01-17 09:57:48,682 INFO [Thread-15] [org.mycontroller.standalone.backup.Restore:69] About to restore a backup, BackupFile(name=on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, canonicalPath=/mycontroller/backup/on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, timestamp=1484642759000, size=65615)
[Tue Jan 17 09:57:48 CET 2017] Accept: java.net.SocketException: Socket closed
2017-01-17 09:57:49,097 WARN [MyController.org Shutdown-Hook] [org.knowm.sundial.SundialJobScheduler:140] Scheduler has not yet been created!!! Call "createScheduler" first.
2017-01-17 09:57:49,117 INFO [MyController.org Shutdown-Hook] [org.mycontroller.standalone.AppShutdownHook:36] Bye, Have a nice day! See you soon

And nothing is restored...
Do you have an idea ?
Thanks

jkandasa

@Tetnobic ~~Can you try with latest SNAPSHOT version? We might have fix for this issue.~~

I am sorry, you are already with latest. Can you send your backup file. Let me try locally? jkandasa at gmail dot com

Tetnobic

@jkandasa No problem, sended

Tetnobic

@jkandasa
Problem with mail, you can download the backup file here :
**....

Tetnobic

If I backup the "empty" new release, and try to restore, same problem....
I think the problem not comes from my backup file

jkandasa

@Tetnobic I do not see any problem, It is perfectly working for me.However, I have uploaded SNAPSHOT version with my current source code. After the restore, I see all the data.

2017-01-17 15:26:03,009 INFO [main] [org.mycontroller.standalone.StartApp:108] MyController.org server started in [4092] ms
2017-01-17 15:26:36,309 INFO [Acme.Utils.ThreadPool(1)-PooledThread: Acme.Serve.Serve$ServeConnection@59212887] [org.mycontroller.standalone.api.BackupApi:219] Restore triggered.
2017-01-17 15:26:39,312 INFO [Thread-15] [org.mycontroller.standalone.backup.Restore:69] About to restore a backup, BackupFile(name=on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, canonicalPath=/home/jkandasa/Downloads/on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, timestamp=1484646665000, size=65615)
[Tue Jan 17 15:26:39 IST 2017] Accept: java.net.SocketException: Socket closed
2017-01-17 15:26:39,581 INFO [Thread-15] [org.mycontroller.standalone.mqttbroker.MoquetteMqttBroker:66] MQTT Broker has been stopped successfully
2017-01-17 15:26:39,948 INFO [Thread-15] [org.mycontroller.standalone.db.DataBaseUtils:285] Database restore completed. Database url:jdbc:h2:file:../conf/mycontroller;MVCC=TRUE, Restored file name:/storage/work/projects/mycontroller-org/mycontroller/dist/target/mycontroller/bin/tmp/on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06/database_backup.zip
2017-01-17 15:26:40,096 INFO [Thread-15] [org.mycontroller.standalone.backup.Restore:153] Restore completed successfully. Start 'MyController.org' server manually
2017-01-17 15:26:40,100 WARN [MyController.org Shutdown-Hook] [org.knowm.sundial.SundialJobScheduler:140] Scheduler has not yet been created!!! Call "createScheduler" first.
2017-01-17 15:26:40,100 INFO [MyController.org Shutdown-Hook] [org.mycontroller.standalone.AppShutdownHook:36] Bye, Have a nice day! See you soon

Tetnobic

@jkandasa
I try your last SNAPSHOT
It works !!

2017-01-17 11:21:22,144 INFO [Acme.Utils.ThreadPool(4)-PooledThread: Acme.Serve.Serve$ServeConnection@1084a4e] [org.mycontroller.standalone.api.BackupApi:219] Restore triggered.
2017-01-17 11:21:25,163 INFO [Thread-15] [org.mycontroller.standalone.backup.Restore:69] About to restore a backup, BackupFile(name=on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, canonicalPath=/home/pi/workspace_domotic/MyController/mycontroller/backup/on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06.zip, timestamp=1484648459000, size=65615)
[Tue Jan 17 11:21:25 CET 2017] Accept: java.net.SocketException: Socket closed
2017-01-17 11:21:25,524 INFO [Thread-15] [org.mycontroller.standalone.mqttbroker.MoquetteMqttBroker:66] MQTT Broker has been stopped successfully
2017-01-17 11:21:28,259 WARN [MyController.org Shutdown-Hook] [org.knowm.sundial.SundialJobScheduler:140] Scheduler has not yet been created!!! Call "createScheduler" first.
2017-01-17 11:21:28,290 INFO [MyController.org Shutdown-Hook] [org.mycontroller.standalone.AppShutdownHook:36] Bye, Have a nice day! See you soon
2017-01-17 11:21:35,797 INFO [Thread-15] [org.mycontroller.standalone.db.DataBaseUtils:285] Database restore completed. Database url:jdbc:h2:file:../conf/mycontroller;MVCC=TRUE, Restored file name:/home/pi/workspace_domotic/MyController/mycontroller/bin/tmp/on-demand_mc_backup_h2db_embedded-2017_01_17-09_35_06/database_backup.zip
2017-01-17 11:21:35,817 INFO [Thread-15] [org.mycontroller.standalone.backup.Restore:153] Restore completed successfully. Start 'MyController.org' server manually

Data retore complete log message is show 7 seconds after shutdown message log, but it works

Sorry for the inconvenience
And many thanks for your reactivity

jkandasa

@Tetnobic

Data retore complete log message is show 7 seconds after shutdown message log, but it works

Looks like taking some time to restore on your machine.
However, the following message says shutdown complete. Which leads confusion for you. I will sync these messages. Thank you! No worries

2017-01-17 11:21:28,290 INFO [MyController.org Shutdown-Hook] [org.mycontroller.standalone.AppShutdownHook:36] Bye, Have a nice day! See you soon

jkandasa

@Tetnobic fixed this restore issue on the slow environment too. Thanks to reporting this issue. This is a nice catch! Updated changes on SNAPSHOT build.

https://github.com/mycontroller-org/mycontroller/commit/14c791726b833905ce5ecc69853e2fca1b33b361

Ghydda

Hi,

Just downloaded latest snapshot uploaded today of 0.0.3-final.
I am unable to login. The login screen just sits there, reporting no errors.
Can somebody confirm this?

Thanks.

jkandasa

@Ghydda I do not face any issue. Working as expected. Can you check mycontroller/log/mycontroller.log, and clear your browser cache.

rgavrilovic

Hi
I have an issue with this 0.0.3-Final (snapshot from feb 13). My nodes are battery powered and on the node details the battery graph can only display the last 6 hours.
Changing the view to last week or last month does not change the graph.
Changing the default interval in the metrics configuration also has no impact.
On Alpha2 the dropdown list also had no action but the default interval from the metrics configuration was taken into account.
Thanks

jkandasa

@rgavrilovic Thanks to report this issue. This issue recently fixed on https://github.com/mycontroller-org/mycontroller/issues/359 Kindly download latest SNAPSHOT and test it.

rgavrilovic

Thanks, that fixed my issue.
After the update I could not login (wrong username/password) even with a cleared cache and browser restarted. I had to apply the password recovery solution from https://github.com/mycontroller-org/mycontroller/issues/233
I did not had that login problem when updating from 0.0.3Alpha2 to 0.0.3Final from feb 12.

jkandasa

@rgavrilovic I never face this issue. Can you share your backup database. I can test it locally.

rgavrilovic

I made again the same migration multiple times without facing the same issue. It does not seem to be related to the backup.
On my first migration I untar the snapshot then started mycontroller. I then remembered I have to disable https and change the default port so I stopped mycontroller a few seconds after.
I guess the database migration triggered on first launch was not finished and the database was altered. I see many database exceptions in the logs.
I have reproduced a database corruption with a fresh install. start then stop within 3 seconds. On my RPI3 the db migration left the database corrupted and mycontroller was unable to restart.
I don't know if you can prevent a shutdown during db initialization/migration. If you can't I take the full responsibility of this bad user behaviour !

jkandasa

@rgavrilovic We cannot hold stop. Hence user has to care this issue. Thanks to report in detail.

edwardb

How can I change the database to mysql?
there is no documentation for this yet?

jkandasa

@edwardb Yes, there is no document for this yet. But it is simple. You can change it on mycontroller/conf/mycontroller.properties.

In the recent version, I have introduced back-end metric support. Currently, supports for InfluxDB

edwardb

What would be the properties needed for mysql?
Could you give me an example?
Thanks,

0.0.3.Final pre-release - volunteers required to test

0

547

524

3.4k