Datenbank CCU Historian

Das Langzeitarchiv für HomeMatic

Moderator: Co-Administratoren

Antworten
Manuel.P
Beiträge: 296
Registriert: 13.12.2015, 14:04
Hat sich bedankt: 1 Mal
Danksagung erhalten: 2 Mal

Datenbank CCU Historian

Beitrag von Manuel.P » 12.09.2022, 12:54

Hallo,

ich nutzte die Software auf einem Windwos PC. Seit kurzem dauert es bei einem neustart ewig, bis die Datenbank geladen ist. Manchmal 1-2 Stunden, es steht dauerhaft Connection to database.

Hat jemand eine Lösung?
Nach oben
Manuel.P
Beiträge: 296
Registriert: 13.12.2015, 14:04
Hat sich bedankt: 1 Mal
Danksagung erhalten: 2 Mal

Re: Datenbank CCU Historian

Beitrag von Manuel.P » 13.09.2022, 22:12

Also hier mal der Ablauf beim start

Code: Alles auswählen

2022-09-13 21:27:51|INFO   |CCU-Historian V3.2.0
2022-09-13 21:27:51|INFO   |(C)MDZ (info@ccu-historian.de)
2022-09-13 21:27:52|INFO   |Starting base services
2022-09-13 21:27:52|INFO   |Connecting to database
2022-09-13 22:05:12|INFO   |Starting database web server
2022-09-13 22:05:12|INFO   |Auto detected local address (please check): "IP-Adresse"
2022-09-13 22:05:13|INFO   |Setting up device 1
2022-09-13 22:05:13|INFO   |Creating HM script client for http://"IP-Adresse"/tclrega.exe
2022-09-13 22:05:13|INFO   |Setting up plug-in 1
2022-09-13 22:05:13|INFO   |Configured following interfaces: BidCos-RF, HmIP-RF, SysVar, CUxD
2022-09-13 22:05:13|INFO   |Starting interfaces
2022-09-13 22:05:13|INFO   |Starting BIN-RPC server on port 2099
2022-09-13 22:05:13|INFO   |Starting XML-RPC server on port 2098
2022-09-13 22:05:13|INFO   |Connecting to "IP-Adresse"
2022-09-13 22:05:13|INFO   |Starting historian
2022-09-13 22:05:14|INFO   |Starting web server
2022-09-13 22:05:17|INFO   |Web server port: 80
Heute hat es mal "nur" 30 Minuten gedauert. Ich habe folgende Einstellung gesetzt

Code: Alles auswählen

// CCU-Historian Konfiguration
// 
// Hinweise:
// Kommentarzeilen starten mit zwei Schrägstrichen (//). Alle Zeichen nach den Schrägstrichen
// werden ignoriert. Zeichenketten als Optionswert müssen von einfachen Anführungszeichen (')
// umschlossen sein. Weitere Informationen sind auch im Handbuchs 
// (https://github.com/mdzio/ccu-historian/wiki#konfiguration) zu finden.
//
// Liste der zur Verfügung stehen Konfigurationsoptionen mit ihren jeweiligen Standardwerten:
//
// logSystem.consoleLevel=Level.INFO
// logSystem.fileLevel=Level.OFF
// logSystem.fileName='./ccu-historian-%g.log'
// logSystem.fileLimit=1000000
// logSystem.fileCount=5
// logSystem.binRpcLevel=Level.WARNING
database.dir='./data'
database.name='history'
database.user='sa'
database.password='ccu-historian'
// database.backup=''
database.webEnable=true
database.webPort=8082
database.webAllowOthers=true
// database.tcpEnable=false
// database.tcpPort=9092
// database.tcpAllowOthers=false
// database.pgEnable=false
// database.pgPort=5435
// database.pgAllowOthers=false
// webServer.port=80
// webServer.dir='./webapp'
// webServer.logLevel=Level.WARNING
// webServer.historianAddress=''
// webServer.trendDesigns ... (s.a. https://github.com/mdzio/ccu-historian/wiki#anpassung-der-trend-darstellung)
// webServer.apiKeys=[]
// webServer.menuLinks ... (s.a. https://github.com/mdzio/ccu-historian/wiki#eigene-verweise-auf-web-seiten)
// webServer.corsOrigin='*'
// webServer.showLastValue=false
// historian.metaCycle=3600000 // 1 Stunde
// historian.bufferCount=5000
// historian.bufferTime=0 
// historian.defaultDisabled=false
// historian.defaultHidden=false
// devices.historianBinRpcPort=2099
// devices.historianXmlRpcPort=2098
// devices.historianAddress=null // null: eigene IP-Adresse automatisch ermitteln
// base.scriptDir='.'
// 
// Für jede Zentrale bzw. jedes Gerät müssen folgende zwei Optionen gesetzt werden
// (s.a. https://github.com/mdzio/ccu-historian/wiki#konfiguration-der-angeschlossenen-ger%C3%A4te):
// devices.device<Nr.>.type=<CCU1, CCU2 oder BINRPC> 
// devices.device<Nr.>.address='<IP-Adresse>'
//
// Optional können noch folgende Optionen gesetzt werden:
// devices.device<Nr.>.plugin<Nr.>.type=<CUXD oder HMWLGW>
// devices.device<Nr.>.sysVarDataCycle=30000
// devices.device<Nr.>.reinitTimeout=300000
// devices.device<Nr.>.writeAccess=false
// devices.device<Nr.>.watchdogProgram=''
// devices.device<Nr.>.watchdogCycle=300000 // 5 Minuten
// Bei Anbindung von mehreren Zentralen muss ein Präfix je Zentrale gesetzt werden!
// devices.device<Nr.>.prefix=''
//
// Es muss im Folgenden mindestens eine Zentrale bzw. Gerät konfiguriert werden:

// Typ der Zentrale: CCU1 oder CCU2
devices.device1.type=CCU3
// IP-Adresse der Zentrale
devices.device1.address='"IP-Adresse"'

// Falls CUxD verwendet wird, die Kommentarzeichen (//) vor folgender Zeile entfernen:
devices.device1.plugin1.type=CUXD

// Falls das HomeMatic Wired LAN Gateway verwendet wird, die Kommentarzeichen (//) vor 
// folgender Zeile entfernen:
// devices.device1.plugin1.type=HMWLGW

// Falls CUxD UND das HMWLGW verwendet wird, die Kommentarzeichen (//) vor folgenden
// zwei Zeilen entfernen:
// devices.device1.plugin1.type=CUXD
// devices.device1.plugin2.type=HMWLGW

// Zum Freischalten der Web-Links zu den Beispiel-Web-Seiten, die Kommentarzeichen (//) vor folgenden
// zwei Zeilen entfernen:
webServer.menuLinks.link1.text='H2-HighChart'
webServer.menuLinks.link1.address='/custom/h2-highchart/H2-HighChart.gy'
// webServer.menuLinks.link2.text='Beispiel 1 - Vorjahresvergleich'
// webServer.menuLinks.link2.address='/custom/example1.gy'
eventuell Sieht ja hier jemand einen Fehler, meine Datenbank ist halt auch 2,5 GB groß, aber eigentlich habe ich überall gelesen, dass dies egal ist und nur das Speichermedium die große beschränkt.

Ich nutze die Version 3.2.0
Nach oben
Manuel.P
Beiträge: 296
Registriert: 13.12.2015, 14:04
Hat sich bedankt: 1 Mal
Danksagung erhalten: 2 Mal

Re: Datenbank CCU Historian

Beitrag von Manuel.P » 14.09.2022, 04:11

Jetzt kam eine Fehlermeldung...

Code: Alles auswählen

2022-09-13 22:09:33|INFO   |CCU-Historian V3.2.0
2022-09-13 22:09:33|INFO   |(C)MDZ (info@ccu-historian.de)
2022-09-13 22:09:35|INFO   |Starting base services
2022-09-13 22:09:35|INFO   |Connecting to database
2022-09-14 00:59:05|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 00:59:05|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database$_closure1.doCall(Database.groovy:64)
        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:64)
        at mdz.ccuhistorian.DatabaseSystem.<init>(DatabaseSystem.groovy:54)
        at mdz.ccuhistorian.HistorianSystem.<init>(HistorianSystem.groovy:34)
        at mdz.ccuhistorian.Main.start(Main.groovy:100)
        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: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 24 more
2022-09-14 00:59:06|INFO   |Auto detected local address (please check): 192.168.170.101
2022-09-14 00:59:06|INFO   |Setting up device 1
2022-09-14 00:59:06|INFO   |Creating HM script client for http://192.168.170.40:8181/tclrega.exe
2022-09-14 00:59:07|INFO   |Setting up plug-in 1
2022-09-14 00:59:07|INFO   |Configured following interfaces: BidCos-RF, HmIP-RF, SysVar, CUxD
2022-09-14 00:59:07|INFO   |Starting interfaces
2022-09-14 00:59:07|INFO   |Starting BIN-RPC server on port 2099
2022-09-14 00:59:07|INFO   |Starting XML-RPC server on port 2098
2022-09-14 00:59:08|INFO   |Connecting to 192.168.170.40:8701
2022-09-14 00:59:09|INFO   |Starting historian
2022-09-14 00:59:09|INFO   |Starting web server
2022-09-14 00:59:09|INFO   |Connecting to database
2022-09-14 00:59:12|INFO   |Web server port: 80
2022-09-14 01:00:54|SEVERE |Error updating data point storage
2022-09-14 01:00:54|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:00:54|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:00:54|INFO   |Connecting to database
2022-09-14 01:02:01|SEVERE |Error updating data point storage
2022-09-14 01:02:01|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:02:01|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:02:01|INFO   |Connecting to database
2022-09-14 01:03:09|SEVERE |Error updating data point storage
2022-09-14 01:03:09|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:03:09|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:03:09|INFO   |Connecting to database
2022-09-14 01:04:16|SEVERE |Error updating data point storage
2022-09-14 01:04:16|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:04:16|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:04:16|INFO   |Connecting to database
2022-09-14 01:05:24|SEVERE |Error updating data point storage
2022-09-14 01:05:24|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:05:24|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:05:24|INFO   |Connecting to database
2022-09-14 01:06:38|INFO   |Connecting to database
2022-09-14 01:06:38|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:06:38|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPointsOfInterface(Database.groovy:336)
        at mdz.ccuhistorian.ExtendedStorage.getDataPointsOfInterface(ExtendedStorage.groovy:54)
        at mdz.ccuhistorian.Historian.update(Historian.groovy:153)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.groovy:115)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.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.Historian$_updateDataPointMeta_closure4.doCall(Historian.groovy:111)
        at mdz.ccuhistorian.Historian.updateDataPointMeta(Historian.groovy:110)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.groovy:104)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.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.Historian.run(Historian.groovy:103)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 24 more
2022-09-14 01:07:46|SEVERE |Error updating data point storage
2022-09-14 01:07:46|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:07:46|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:07:46|INFO   |Connecting to database
2022-09-14 01:08:54|SEVERE |Error updating data point storage
2022-09-14 01:08:54|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:08:54|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:08:54|INFO   |Connecting to database
2022-09-14 01:10:02|SEVERE |Error updating data point storage
2022-09-14 01:10:02|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:10:02|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:10:02|INFO   |Connecting to database
2022-09-14 01:11:09|SEVERE |Error updating data point storage
2022-09-14 01:11:09|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:11:09|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:11:09|INFO   |Connecting to database
2022-09-14 01:12:23|INFO   |Connecting to database
2022-09-14 01:12:23|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:12:23|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPointsOfInterface(Database.groovy:336)
        at mdz.ccuhistorian.ExtendedStorage.getDataPointsOfInterface(ExtendedStorage.groovy:54)
        at mdz.ccuhistorian.Historian.update(Historian.groovy:153)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.groovy:115)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.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.Historian$_updateDataPointMeta_closure4.doCall(Historian.groovy:111)
        at mdz.ccuhistorian.Historian.updateDataPointMeta(Historian.groovy:110)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.groovy:104)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.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.Historian.run(Historian.groovy:103)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 24 more
2022-09-14 01:13:31|SEVERE |Error updating data point storage
2022-09-14 01:13:31|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:13:31|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPoint(Database.groovy:353)
        at mdz.ccuhistorian.ExtendedStorage.getDataPoint(ExtendedStorage.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:45)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 23 more
2022-09-14 01:13:31|INFO   |Connecting to database
2022-09-14 01:14:46|INFO   |Connecting to database
2022-09-14 01:14:46|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
2022-09-14 01:14:46|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:212)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:145)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
        at org.h2.Driver.connect(Driver.java:59)
        at mdz.ccuhistorian.Database.connect(Database.groovy:71)
        at mdz.ccuhistorian.Database.getDataPointsOfInterface(Database.groovy:336)
        at mdz.ccuhistorian.ExtendedStorage.getDataPointsOfInterface(ExtendedStorage.groovy:54)
        at mdz.ccuhistorian.Historian.browse(Historian.groovy:126)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.groovy:113)
        at mdz.ccuhistorian.Historian$_updateDataPointMeta_closure4$_closure13.doCall(Historian.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.Historian$_updateDataPointMeta_closure4.doCall(Historian.groovy:111)
        at mdz.ccuhistorian.Historian.updateDataPointMeta(Historian.groovy:110)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.groovy:104)
        at mdz.ccuhistorian.Historian$_run_closure3.doCall(Historian.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.Historian.run(Historian.groovy:103)
Caused by: org.h2.mvstore.MVStoreException: File is corrupted - unable to recover a valid set of chunks [2.1.214/6]
        at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
        at org.h2.mvstore.MVStore.readStoreHeader(MVStore.java:1038)
        at org.h2.mvstore.MVStore.<init>(MVStore.java:463)
        at org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
        at org.h2.mvstore.db.Store.<init>(Store.java:136)
        ... 24 more
2022-09-14 01:15:53|SEVERE |Error updating data point storage
2022-09-14 01:15:53|SEVERE |Exception: Datei fehlerhaft beim Lesen des Datensatzes: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". M÷gliche L÷sung: Recovery Werkzeug verwenden
File corrupted while reading record: "C:/Program Files (x86)/ccu-historian-3.2.0-bin/data/history.mv.db". Possible solution: use the recovery tool [90030-214]
Nach oben
Mathias
Beiträge: 1796
Registriert: 03.11.2010, 10:25
System: CCU
Wohnort: Aachen
Hat sich bedankt: 58 Mal
Danksagung erhalten: 262 Mal
Kontaktdaten:
Kontaktdaten von Mathias

Re: Datenbank CCU Historian

Beitrag von Mathias » 14.09.2022, 18:27

Die Datenbankdatei ist wohl defekt. Also am besten ein Backup zurückspielen.

Ansonsten kann das Recovery-Werkzeug vielleicht helfen.
Nach oben
Manuel.P
Beiträge: 296
Registriert: 13.12.2015, 14:04
Hat sich bedankt: 1 Mal
Danksagung erhalten: 2 Mal

Re: Datenbank CCU Historian

Beitrag von Manuel.P » 14.09.2022, 19:06

Wenn ich jetzt mit einer neuen leeren Datenbank anfange, kann ich irgend wie die daten von Anfang an komprimieren ?
Nach oben
Matthias K.
Beiträge: 1172
Registriert: 14.02.2016, 12:32
System: Alternative CCU (auf Basis OCCU)
Wohnort: Heidenheim
Hat sich bedankt: 57 Mal
Danksagung erhalten: 226 Mal

Re: Datenbank CCU Historian

Beitrag von Matthias K. » 14.09.2022, 19:20

Ja, z.B. per Skript automatisch auf allen (sinnvollen) Datenpunkte setzen: https://github.com/mdzio/ccu-historian/ ... ompression
Nach oben
Benutzeravatar
Baxxy
Beiträge: 10845
Registriert: 18.12.2018, 15:45
System: Alternative CCU (auf Basis OCCU)
Hat sich bedankt: 609 Mal
Danksagung erhalten: 2229 Mal

Re: Datenbank CCU Historian

Beitrag von Baxxy » 14.09.2022, 19:38

Ich kann noch empfehlen vor dem ersten Start die Option...

Code: Alles auswählen

historian.defaultDisabled=true
...in der Config zu setzen.

Dann wird zwar erstmal gar nichts aufgezeichnet, aber m.E. ist es besser die wirklich benötigten DP's dann händisch zu aktivieren als die vielen unnötigen DP's zu deaktivieren.
Nach oben
Antworten

Zurück zu „CCU-Historian“