New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Fresh install won't work with 0.0.3.Alpha2 (Migration Exception) #230
Comments
@mozzbozz i don't see this issue. can you post your os and java version details. also post if have changed DB settings. |
My OS and kernel versions: pi@raspberrypi ~ $ uname -a
Linux raspberrypi 4.1.7+ #817 PREEMPT Sat Sep 19 15:25:36 BST 2015 armv6l GNU/Linux
pi@raspberrypi ~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Raspbian
Description: Raspbian GNU/Linux 8.0 (jessie)
Release: 8.0
Codename: jessie I could workaround this issue now: First I installed EDIT: Sorry, forgot to mention my java version: pi@raspberrypi ~ $ java -version
java version "1.8.0_65"
Java(TM) SE Runtime Environment (build 1.8.0_65-b17)
Java HotSpot(TM) Client VM (build 25.65-b01, mixed mode) |
Well, after restoring my backup, I get a similar error message again...: 2016-08-02 20:46:25,732 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-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.execute(Flyway.java:1418) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.migrate(Flyway.java:1006) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.db.DataBaseUtils.loadDatabase(DataBaseUtils.java:113) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startServices(StartApp.java:243) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:106) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.main(StartApp.java:93) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
2016-08-02 20:46:37,789 ERROR [main] [org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl:254] unable to get all items
org.h2.jdbc.JdbcSQLException: Feld "lastSeen" nicht gefunden
Column "lastSeen" not found [42122-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.h2.message.DbException.get(DbException.java:178) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.h2.message.DbException.get(DbException.java:154) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3122) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:182) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:90) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:815) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:283) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:201) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.mapped.MappedQueryForId.execute(MappedQueryForId.java:38) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.field.FieldType.assignField(FieldType.java:558) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:71) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:283) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:201) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.mapped.MappedQueryForId.execute(MappedQueryForId.java:38) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.field.FieldType.assignField(FieldType.java:558) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:71) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:270) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:161) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.stmt.StatementExecutor.queryForAll(StatementExecutor.java:118) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at com.j256.ormlite.dao.BaseDaoImpl.queryForAll(BaseDaoImpl.java:241) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:252) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.db.migration.V1_02_08__2016_Jul_01.migrate(V1_02_08__2016_Jul_01.java:74) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.resolver.jdbc.JdbcMigrationExecutor.execute(JdbcMigrationExecutor.java:45) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.execute(Flyway.java:1418) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.migrate(Flyway.java:1006) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.db.DataBaseUtils.loadDatabase(DataBaseUtils.java:118) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startServices(StartApp.java:243) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:106) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.main(StartApp.java:93) [mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
2016-08-02 20:46:37,804 ERROR [main] [org.flywaydb.core.internal.command.DbMigrate:52] Migration of schema "PUBLIC" to version 1.02.08 failed! Please restore backups and roll back database and code!
2016-08-02 20:46:37,902 ERROR [main] [org.mycontroller.standalone.StartApp:95] Unable to start application, refer error log,
org.flywaydb.core.api.FlywayException: Migration failed !
at org.flywaydb.core.internal.resolver.jdbc.JdbcMigrationExecutor.execute(JdbcMigrationExecutor.java:47) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.execute(Flyway.java:1418) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.Flyway.migrate(Flyway.java:1006) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.db.DataBaseUtils.loadDatabase(DataBaseUtils.java:118) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startServices(StartApp.java:243) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:106) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.mycontroller.standalone.StartApp.main(StartApp.java:93) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
Caused by: java.lang.NullPointerException: null
at org.mycontroller.standalone.db.migration.V1_02_08__2016_Jul_01.migrate(V1_02_08__2016_Jul_01.java:75) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
at org.flywaydb.core.internal.resolver.jdbc.JdbcMigrationExecutor.execute(JdbcMigrationExecutor.java:45) ~[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]
... 17 common frames omitted
Exception in thread "MyController.org Shutdown-Hook" java.lang.NullPointerException
at Acme.Serve.Serve.stopBackground(Serve.java:684)
at org.jboss.resteasy.plugins.server.tjws.TJWSServletServer.stop(TJWSServletServer.java:184)
at org.mycontroller.standalone.StartApp.stopHTTPWebServer(StartApp.java:216)
at org.mycontroller.standalone.StartApp.stopServices(StartApp.java:288)
at org.mycontroller.standalone.AppShutdownHook$1.run(AppShutdownHook.java:34) |
@mozzbozz I tried in my raspberry PI and I'm unable to reproduce this issue. I do not have installed desktop and my versions as follows,
I do not see any issue, I tested with
|
Thank you for your effort! I've manually added the gateway, sensors and stuff again, so I didn't need to apply the backup. Now everything is working (and wow, the interface, just everything is way more polished and functional than I thought it would be in an alpha release, so great work 👍 - just didn't want to always only mention the negative things ;) ). I'm not closing this issue for now as I want to do some more debugging in the next few days - the information given in your last post will be helpful I think!
Ok, so MyController will recreate the file then? Great, I think that might help me with debugging.
That's something I will certainly try. Also I noticed I hadn't installed a lot of updates since the Raspberry Pi (BTW, it's a modell B rev 2.0) lied around for a while... Maybe that already helps. But first I will need to find an empty SD-card so I don't break my working system while experimenting... |
@mozzbozz Thank you!
Every time you have to add your gateway manually. To add available sensors and nodes automatically, you can select your gateway and click on
Yes, MyController will recreate the file( |
Unable to reproduce this issue, closing now. We can reopen later if this issue exists. |
Well, I have no idea what went wrong. Now after my new SD-card arrived, I installed a fresh Raspbian, configured the locales etc., installed Oracle Java and followed the exact same steps in the installation instructions again. Everything works fine now... Sorry and thank you for your effort! So yes, this issue can be closed. |
Afterwards I tried a 0.0.3.Alpha1 fresh install which works without any problems.
Anyway, here's the error log:
The text was updated successfully, but these errors were encountered: