- Backup with SCRIPT TO ... and (in a new database) RUNSCRIPT FROM (with last stabel 197) - Still the same error message when I try to update (with snapshot 197):
Feature not supported: "SYS_ID:0:org.h2.mvstore.db.MVSecondaryIndex@53f5f2fa" [50100-197] HYC00/ 50100 (Hilfe) <http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c50100> org.h2.jdbc.JdbcSQLException: Feature not supported: "SYS_ID:0:org.h2.mvstore.db.MVSecondaryIndex@53f5f2fa" [50100-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:394 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=394&build=197> ) at org.h2.message.DbException.get(DbException.java:182 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=182&build=197> ) at org.h2.message.DbException.get(DbException.java:158 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=158&build=197> ) at org.h2.message.DbException.getUnsupportedException(DbException.java: 231 <http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=231&build=197> ) at org.h2.index.BaseIndex.getRow(BaseIndex.java:451 <http://h2database.com/html/source.html?file=org/h2/index/BaseIndex.java&line=451&build=197> ) at org.h2.engine.Database.updateMeta(Database.java:1723 <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=1723&build=197> ) at org.h2.command.ddl.Analyze.analyzeTable(Analyze.java:136 <http://h2database.com/html/source.html?file=org/h2/command/ddl/Analyze.java&line=136&build=197> ) at org.h2.engine.Session.commit(Session.java:657 <http://h2database.com/html/source.html?file=org/h2/engine/Session.java&line=657&build=197> ) at org.h2.command.Command.stop(Command.java:158 <http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=158&build=197> ) at org.h2.command.CommandContainer.stop(CommandContainer.java:123 <http://h2database.com/html/source.html?file=org/h2/command/CommandContainer.java&line=123&build=197> ) at org.h2.command.Command.executeUpdate(Command.java:303 <http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=303&build=197> ) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=233&build=197> ) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:1114 <http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=1114&build=197> ) at org.h2.server.web.WebApp.getResult(WebApp.java:1386 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1386&build=197> ) at org.h2.server.web.WebApp.query(WebApp.java:1061 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1061&build=197> ) at org.h2.server.web.WebApp$1.next(WebApp.java:1023 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1023&build=197> ) at org.h2.server.web.WebApp$1.next(WebApp.java:1010 <http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1010&build=197> ) at org.h2.server.web.WebThread.process(WebThread.java:165 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=165&build=197> ) at org.h2.server.web.WebThread.run(WebThread.java:90 <http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=90&build=197> ) at java.base/java.lang.Thread.run(Unknown Source) On Friday, 27 July 2018 14:24:27 UTC+1, Evgenij Ryazanov wrote: > > I'll try to reproduce it, but right now it looks like your database was > already damaged. Meta index should be a MVDelegateIndex, not > a MVSecondaryIndex. > > I think it's reasonable to export database into an SQL script and load > this script into a new database. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
