Dort habe ich per backupscript ein Backup erstellt.
Auf meinem Windowsrechner die Version 3.3.1 entpackt und dort per runscript backup ein Restore versucht.
Beim ersten Versuch blieb der Import stehen weil im backup File
Code: Alles auswählen
CREATE DOMAIN "REGPROC" AS VARCHAR_IGNORECASE;
Nachdem ich diese Zeile geändert habe
Code: Alles auswählen
CREATE DOMAIN "REGPROC" ;
Mit der Fehlemeldung kann ich aber wenig anfangen.
Heißt was soll mir diese Fehlermeldung sagen. Welche Zeile hat wo einen Fehler?
Code: Alles auswählen
2023-05-15 14:07:04|INFO |Starting base services
2023-05-15 14:07:05|INFO |Running script backupdb on database
2023-05-15 14:07:05|SEVERE |Exception: Allgemeiner Fehler: "java.lang.NullPointerException"
General error: "java.lang.NullPointerException"; SQL statement:
RUNSCRIPT FROM 'backupdb' FROM_1X [50000-214]
2023-05-15 14:07:05|SEVERE |Detail: org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "java.lang.NullPointerException"
General error: "java.lang.NullPointerException"; SQL statement:
RUNSCRIPT FROM 'backupdb' FROM_1X [50000-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:554)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.message.DbException.convert(DbException.java:395)
at org.h2.command.Command.executeUpdate(Command.java:264)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:252)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
at org.h2.tools.RunScript.processRunscript(RunScript.java:273)
at org.h2.tools.RunScript.runTool(RunScript.java:137)
at org.h2.tools.RunScript.main(RunScript.java:66)
at mdz.ccuhistorian.Database.runScript(Database.groovy:596)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1$_closure2.doCall(OfflineMaintenanceSystem.groovy:39)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1$_closure2.doCall(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:39)
at mdz.ccuhistorian.OfflineMaintenanceSystem$_closure1.doCall(OfflineMaintenanceSystem.groovy)
Caused by: java.lang.NullPointerException
at org.h2.util.ParserUtil.getTokenType(ParserUtil.java:679)
at org.h2.util.ParserUtil.isKeyword(ParserUtil.java:621)
at org.h2.command.Parser.isKeyword(Parser.java:5927)
at org.h2.command.Parser.readIfDataType1(Parser.java:6126)
at org.h2.command.Parser.readIfDataType(Parser.java:6087)
at org.h2.command.Parser.parseCreateDomain(Parser.java:7102)
at org.h2.command.Parser.parseCreate(Parser.java:6749)
at org.h2.command.Parser.parsePrepared(Parser.java:763)
at org.h2.command.Parser.parse(Parser.java:689)
at org.h2.command.Parser.parse(Parser.java:661)
at org.h2.command.Parser.prepare(Parser.java:537)
at org.h2.engine.SessionLocal.prepare(SessionLocal.java:581)
at org.h2.engine.SessionLocal.prepare(SessionLocal.java:565)
at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:103)
at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:70)
at org.h2.command.CommandContainer.update(CommandContainer.java:169)
at org.h2.command.Command.executeUpdate(Command.java:252)
... 13 more