Error while restoring database- Followed instructions provided on github but still getting error


#1

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