CCU-Historian V2.4.0 + Datenbank komprimieren

[nuiler]

Ich wollte die Datenbank komprimieren nach folgender Anleitung unter Raspberrymatic

viewtopic.php?f=38&t=45169

dazu habe ich folgende Befehle angewendet.

cd /usr/local/addons/ccu-historian/ccu-historian
/usr/local/etc/config/rc.d/ccu-historian stop

doch schon bei dem Befehl
/opt/java/bin/java -jar ccu-historian.jar -config ../ccu-historian.config -recalc
taucht eine Fehlermledung auf


root@homematic-raspi:/usr/local/addons/ccu-historian/ccu-historian# /opt/java/bin/java -jar ccu-historian.jar -config ../ccu
-historian.config -recalc
2020-06-18 08:57:41|INFO |CCU-Historian V2.4.0
2020-06-18 08:57:41|INFO |(C)MDZ (info@ccu-historian.de)
2020-06-18 08:57:44|INFO |Starting base services
2020-06-18 08:57:45|INFO |Connecting to database
2020-06-18 08:57:46|SEVERE |Exception: Database may be already in use: null. Possible solutions: close all other connection( s); use the server mode [90020-199]
2020-06-18 08:57:46|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: null . Possible solutions: close all other connection(s); use the server mode [90020-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:617)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:194)
at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:193)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:173)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:95)
at org.h2.engine.Database.getPageStore(Database.java:2739)
at org.h2.engine.Database.open(Database.java:769)
at org.h2.engine.Database.openDatabase(Database.java:319)
at org.h2.engine.Database.<init>(Database.java:313)
at org.h2.engine.Engine.openSession(Engine.java:69)
at org.h2.engine.Engine.openSession(Engine.java:201)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:178)
at org.h2.engine.Engine.createSession(Engine.java:161)
at org.h2.engine.Engine.createSession(Engine.java:31)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:169)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:148)
at org.h2.Driver.connect(Driver.java:69)
at mdz.ccuhistorian.Database.connect(Database.groovy:78)
at mdz.ccuhistorian.Database$_closure1.doCall(Database.groovy:71)
at mdz.ccuhistorian.Database$_closure1.doCall(Database.groovy)
at mdz.Exceptions.lambda$0(Exceptions.java:84)
at mdz.Exceptions.catchToLog(Exceptions.java:74)
at mdz.Exceptions.catchToLog(Exceptions.java:84)
at mdz.ccuhistorian.Database.<init>(Database.groovy:71)
at mdz.ccuhistorian.DatabaseSystem.<init>(DatabaseSystem.groovy:33)
at mdz.ccuhistorian.MaintenanceSystem.<init>(MaintenanceSystem.groovy:40)
at mdz.ccuhistorian.Main.start(Main.groovy:94)
at mdz.ccuhistorian.Main$_run_closure4.doCall(Main.groovy:77)
at mdz.ccuhistorian.Main$_run_closure4.doCall(Main.groovy)
at mdz.Exceptions.lambda$0(Exceptions.java:84)
at mdz.Exceptions.catchToLog(Exceptions.java:74)
at mdz.Exceptions.catchToLog(Exceptions.java:84)
at mdz.ccuhistorian.Main.run(Main.groovy:77)
at mdz.ccuhistorian.Main.main(Main.groovy:45)
Caused by: java.lang.IllegalStateException: The file is locked: nio:/media/usb1/ccu-historian/history.mv.db [1.4.199/7]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:883)
at org.h2.mvstore.FileStore.open(FileStore.java:172)
at org.h2.mvstore.MVStore.<init>(MVStore.java:390)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:3343)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:162)
... 31 more
2020-06-18 08:57:46|INFO |Starting recalculation of compressed data points
2020-06-18 08:57:46|INFO |Connecting to database
2020-06-18 08:57:46|SEVERE |Exception: Database may be already in use: null. Possible solutions: close all other connection( s); use the server mode [90020-199]
2020-06-18 08:57:46|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: null . Possible solutions: close all other connection(s); use the server mode [90020-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:617)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:194)
at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:193)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:173)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:95)
at org.h2.engine.Database.getPageStore(Database.java:2739)
at org.h2.engine.Database.open(Database.java:769)
at org.h2.engine.Database.openDatabase(Database.java:319)
at org.h2.engine.Database.<init>(Database.java:313)
at org.h2.engine.Engine.openSession(Engine.java:69)
at org.h2.engine.Engine.openSession(Engine.java:201)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:178)
at org.h2.engine.Engine.createSession(Engine.java:161)
at org.h2.engine.Engine.createSession(Engine.java:31)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:169)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:148)
at org.h2.Driver.connect(Driver.java:69)
at mdz.ccuhistorian.Database.connect(Database.groovy:78)
at mdz.ccuhistorian.Database.getDataPoints(Database.groovy:236)
at mdz.ccuhistorian.ExtendedStorage.getDataPoints(ExtendedStorage.groovy:44)
at mdz.ccuhistorian.MaintenanceSystem.recalculate(MaintenanceSystem.groovy:57)
at mdz.ccuhistorian.MaintenanceSystem$_closure1$_closure5.doCall(MaintenanceSystem.groovy:49)
at mdz.ccuhistorian.MaintenanceSystem$_closure1$_closure5.doCall(MaintenanceSystem.groovy)
at mdz.Exceptions.lambda$0(Exceptions.java:84)
at mdz.Exceptions.catchToLog(Exceptions.java:74)
at mdz.Exceptions.catchToLog(Exceptions.java:84)
at mdz.ccuhistorian.MaintenanceSystem$_closure1.doCall(MaintenanceSystem.groovy:49)
at mdz.ccuhistorian.MaintenanceSystem$_closure1.doCall(MaintenanceSystem.groovy)
Caused by: java.lang.IllegalStateException: The file is locked: nio:/media/usb1/ccu-historian/history.mv.db [1.4.199/7]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:883)
at org.h2.mvstore.FileStore.open(FileStore.java:172)
at org.h2.mvstore.MVStore.<init>(MVStore.java:390)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:3343)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:162)
... 25 more

Anscheinend greift noch ein Prozess darauf zu. Wie kann ich die Datenbank dennoch komprimieren?

Ich verwende Raspberrymatic in der Version 3.51.6.20200613.

[Baxxy]

Wie kann ich die Datenbank dennoch komprimieren?

Vermutlich bist du einfach zu ungeduldig. Es dauert etwas bis der Historian gestoppt ist.
Nach...

Code: Alles auswählen

/usr/local/etc/config/rc.d/ccu-historian stop

einfach mal ne Minute warten und dann mit...

Code: Alles auswählen

/opt/java/bin/java -jar ccu-historian.jar -config ../ccu-historian.config -recalc

weitermachen.

Klappt bei mir immer.

Grüße
Baxxy

[fant]

Hallo zusammen,

wie lange dauert denn das Recalc? Ich bekomme das hier:

Code: Alles auswählen

ccuhistorian@homematicdienste:~/ccu-historian$ jjava -jar ./ccu-historian.jar -config ./ccu-historian.config -recalc
2024-01-18 10:45:18|INFO   |CCU-Historian V3.3.0
2024-01-18 10:45:18|INFO   |(C)MDZ (info@ccu-historian.de)
2024-01-18 10:45:18|INFO   |Starting base services
2024-01-18 10:45:19|INFO   |Connecting to database

Seit einer halben Stunde passiert jetzt gar nichts mehr. Muss das so?

Hawedieehre.
Fant