Fehlermeldung "File corrupted in chunk" beim Komprimieren

Das Langzeitarchiv für HomeMatic

Moderator: Co-Administratoren

Antworten
PaulM
Beiträge: 79
Registriert: 16.02.2015, 17:05
Hat sich bedankt: 1 Mal

Fehlermeldung "File corrupted in chunk" beim Komprimieren

Beitrag von PaulM » 13.01.2019, 22:48

File corrupted in chunk XYZ

Ausgangslage
Raspberrymatic aktuelle Version mit CCU-Historian 2.0.0 als Addon
Datenbank auf USB mit 16 GB mit ext4 formatiert
Datenbankgröße rund 2 GB, obwohl erst mit Daten von etwa 3-4 Wochen in Betrieb

Dies ist meine Konfigurationsdatei:

Code: Alles auswählen

[code]logSystem.fileLevel=Level.INFO
logSystem.fileName='./ccu-historian-%g.log'
logSystem.fileLimit=10000000
logSystem.fileCount=5
database.dir='/media/usb0/ccu-historian/'
database.name='history'
database.user='sa'
database.password='ccu-historian'
database.backup='/media/usb0/ccu-historian/backup/backup-historian-%Y-%M-%D.zip'
database.webEnable=true
database.webPort=8083
database.webAllowOthers=true
webServer.port=8082
webServer.dir='/usr/local/addons/ccu-historian/ccu-historian/webapp'
webServer.logLevel=Level.INFO
webServer.historianAddress='192.168.XX.YY'
historian.metaCycle=3600000 // 1 Stunde
historian.bufferCount=5000
historian.bufferTime=3600000 // 1 Stunde
devices.device1.writeAccess=true
devices.device1.type=CCU2
devices.device1.address='192.168.XX.YY'
devices.device1.plugin1.type=CUXD
[/code]

Wegen der Datenbankgröße habe ich als erstes die Datenpunktkonfiguration angepasst, teilweise mit Vorverarbeitung

Versuche die Datenbank via PuTTY/SSH zu komprimieren sind fehlgeschlagen (PuTTY Ausgabe):
# cd /usr/local/addons/ccu-historian/ccu-historian
# /usr/local/etc/config/rc.d/ccu-historian start
# ps|grep ccu-historian|grep -v grep
11677 root 1h58 /opt/java/bin/java -Xmx512m -Djava.util.prefs.userRoot=/usrlocal/addons/ccu-historian -Djava.util.prefs.systemRoot=/usr/local/addons/ccu-historian -jar /usr/local/addons/ccu-historian/ccu-historian/ccu-historian.jar -config /usr/local/addons/ccu-historian/ccu-historian.config -loglevel off
# tail /var/log/ccu-historian-*.log
tail: can't open '/var/log/ccu-historian-*.log': No such file or directory
tail: no files
# /usr/local/etc/config/rc.d/ccu-historian stop
# /opt/java/bin/java -jar ccu-historian.jar -config ../ccu-historian.config -recalc
2019-01-13 22:01:05|INFO |CCU-Historian V2.0.0
2019-01-13 22:01:05|INFO |(C)MDZ (info@ccu-historian.de)
2019-01-13 22:01:06|INFO |Starting base services
2019-01-13 22:01:06|INFO |Connecting to database
2019-01-13 22:01:14|INFO |Starting database web server
2019-01-13 22:01:14|INFO |Starting recalculation of compressed data points
2019-01-13 22:01:15|INFO |Summary: 0 entries from 0 dropped (0.0 %); 0 seconds
2019-01-13 22:01:15|INFO |Recalculation completed

# /opt/java/bin/java -jar ccu-historian.jar -config ../ccu-historian.config -compact
2019-01-13 22:01:37|INFO |CCU-Historian V2.0.0
2019-01-13 22:01:37|INFO |(C)MDZ (info@ccu-historian.de)
2019-01-13 22:01:39|INFO |Starting base services
2019-01-13 22:01:39|INFO |Starting compaction of database
2019-01-13 22:04:23|SEVERE |Exception: General error: "java.lang.IllegalStateException: File corrupted in chunk 342774, expected page length 4..256, got 1667632740 [1.4.197/6]"; SQL statement:
SCRIPT DROP TO 'temp.sql' [50000-197]
2019-01-13 22:04:23|SEVERE |Detail: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 342774, expected page length 4..256, got 1667632740 [1.4.197/6]"; SQL statement: SCRIPT DROP TO 'temp.sql' [50000-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:307)
at org.h2.command.Command.executeQuery(Command.java:216)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:227)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205)
at org.h2.tools.Script.process(Script.java:139)
at org.h2.tools.Script.process(Script.java:119)
at org.h2.tools.Script.runTool(Script.java:100)
at org.h2.tools.Script.main(Script.java:45)
at mdz.ccuhistorian.Database.compact(Database.groovy:451)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1$_closure2.doCall(OfflineMaintenanceSystem.groovy:41)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1$_closure2.call(OfflineMaintenanceSystem.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.OfflineMaintenanceSystem$_closure1.doCall(OfflineMaintenanceSystem.groovy:41)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1.call(OfflineMaintenanceSystem.groovy)
Caused by: java.lang.IllegalStateException: File corrupted in chunk 342774, expected page length 4..256, got 1667632740 [1.4.197/6]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:870)
at org.h2.mvstore.Page.read(Page.java:652)
at org.h2.mvstore.Page.read(Page.java:186)
at org.h2.mvstore.MVStore.readPage(MVStore.java:1936)
at org.h2.mvstore.MVMap.readPage(MVMap.java:698)
at org.h2.mvstore.Page.getChildPage(Page.java:208)
at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150)
at org.h2.mvstore.Cursor.next(Cursor.java:50)
at org.h2.mvstore.db.TransactionStore$TransactionMap$2.fetchNext(TransactionStore.java:1509)
at org.h2.mvstore.db.TransactionStore$TransactionMap$2.next(TransactionStore.java:1559)
at org.h2.mvstore.db.TransactionStore$TransactionMap$2.next(TransactionStore.java:1494)
at org.h2.mvstore.db.MVPrimaryIndex$MVStoreCursor.next(MVPrimaryIndex.java:404)
at org.h2.command.dml.ScriptCommand.generateInsertValues(ScriptCommand.java:409)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:300)
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
at org.h2.command.Command.executeQuery(Command.java:202)
... 14 more
# /usr/local/etc/config/rc.d/ccu-historian start

hat jemand eine Idee was zu tun ist ?

Danke
Paul
Mit Mut und Entschlossenheit gegen Intoleranz

Mathias
Beiträge: 962
Registriert: 03.11.2010, 10:25
Wohnort: Aachen
Danksagung erhalten: 1 Mal
Kontaktdaten:

Re: Fehlermeldung "File corrupted in chunk" beim Komprimieren

Beitrag von Mathias » 15.01.2019, 22:49

Eventuell hilft das Recover-Werkzeuge. Eine Anleitung ist hier zu finden.

Gruß
Mathias

Antworten

Zurück zu „CCU-Historian“