I started testing the 1.3.159 release of H2. After one day (using
MULTI_THREADED=TRUE) the db crashed.
I already reported that failure for older releases of H2 but I was not
able to reproduce it in a simple test case up to now. So I tried to
recover the database using the recover tool. This worked without
problems but running the recovery script failed with the following
problem:
08-16 09:32:41 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: Versuche, einen zweiten Primärschlüssel
zu definieren
Attempt to define a second primary key; SQL statement:
CREATE PRIMARY KEY IF NOT EXISTS INFORMATION_SCHEMA.PRIMARY_KEY_F ON
INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ) [90017-159]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.message.DbException.get(DbException.java:135)
at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:83)
at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:
66)
at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:
45)
at org.h2.command.CommandContainer.update(CommandContainer.java:71)
at org.h2.command.Command.executeUpdate(Command.java:212)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at org.h2.server.web.WebApp.getResult(WebApp.java:1311)
at org.h2.server.web.WebApp.query(WebApp.java:1001)
at org.h2.server.web.WebApp$1.next(WebApp.java:964)
at org.h2.server.web.WebApp$1.next(WebApp.java:967)
at org.h2.server.web.WebThread.process(WebThread.java:166)
at org.h2.server.web.WebThread.run(WebThread.java:93)
at java.lang.Thread.run(Unknown Source)
Any ideas what's wrong there?
Uli
--
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.
