Our database got corrupted and while trying to restart metabase we got following error
Exception in thread “main” org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index “”"""
Followed instrunctions given in https://github.com/metabase/metabase/issues/5695 but getting column mismatch error
INSERT INTO O_149 VALUES(‘5170510’, ‘0’, ‘0’, ‘1225505296’, ‘254’) [21002-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.message.DbException.get(DbException.java:143)
at org.h2.command.dml.Insert.prepare(Insert.java:266)
at org.h2.command.Parser.prepareCommand(Parser.java:248)
at org.h2.engine.Session.prepareLocal(Session.java:442)
at org.h2.engine.Session.prepareCommand(Session.java:384)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:172)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160)
at org.h2.tools.RunScript.process(RunScript.java:261)
at org.h2.tools.RunScript.process(RunScript.java:191)
at org.h2.tools.RunScript.process(RunScript.java:329)
at org.h2.tools.RunScript.runTool(RunScript.java:142)
at org.h2.tools.RunScript.main(RunScript.java:69)
when I opened sql file, I found table having some records with five columns and others with 3…
If somebody can help us on this, for now we went back to another backup and got it running, but its quite old.
@maz @AndrewMBaines