Hi,
Yesterday the following error occured:
org.h2.jdbc.JdbcSQLException: User XIAM already exists; SQL statement:
CREATE USER XIAM SALT '232b01e2e43cdda0' HASH
'301ee8952f753b79441bdba7e24c6c0851d10238dafb2efaf6074a6b7c594f75'
ADMIN [90033-105]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.command.ddl.CreateUser.update(CreateUser.java:69)
at org.h2.engine.MetaRecord.execute(MetaRecord.java:87)
at org.h2.engine.Database.open(Database.java:556)
at org.h2.engine.Database.<init>(Database.java:207)
at org.h2.engine.Engine.openSession(Engine.java:57)
at org.h2.engine.Engine.openSession(Engine.java:126)
at org.h2.engine.Engine.getSession(Engine.java:109)
at org.h2.engine.SessionFactoryEmbedded.createSession
(SessionFactoryEmbedded.java:17)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer
(SessionRemote.java:251)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:229)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
at org.h2.Driver.connect(Driver.java:54)
We 're using H2 together with a Jetty server, and I think the database
got corrupted when restarting Jetty. Removing the index file did not
have any effect. In the end, we had to replace a back-up to get H2 up-
and-running again.
Unfortunately, some data has been lost in the process. Because it was
a test environment, it was not that important. But we don 't want
these things to happen in production :)
First of all, is there any way to prevent these errors from happening
in the future?
And second, is it possible to resolve from these errors, and keep
using the H2 database?
Thanks,
Peter
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
