Hi
I would need a reproducible test case. Or could you send me the database
file?
Regards, Thomas
On Wednesday, May 21, 2014, Benoit HELIE wrote:
> I'm using H2 console to open a database.
> When opening the first time the database, I'm able to see the different
> tables of the database and execute SQL scripts.
>
> When I try to open it a second time, I always have the following error :
>
> Unique index or primary key violation: "PRIMARY KEY ON .PAGE_INDEX";
> SQL statement:
> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT
> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES
> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-176] 23505/23505 (Help)
> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
> "PRIMARY KEY ON .PAGE_INDEX"; SQL statement:
> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT
> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES
> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-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.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:166)
> at org.h2.index.PageDataIndex.add(PageDataIndex.java:144)
> at org.h2.store.PageStore.addMeta(PageStore.java:1808)
> at org.h2.index.PageBtreeIndex.(PageBtreeIndex.java:64)
> at org.h2.table.RegularTable.addIndex(RegularTable.java:235)
> at
> org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:280)
> at
> org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:205)
> at
> org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:73)
> at org.h2.engine.MetaRecord.execute(MetaRecord.java:59)
> at org.h2.engine.Database.open(Database.java:719)
> at org.h2.engine.Database.openDatabase(Database.java:260)
> at org.h2.engine.Database.(Database.java:254)
> at org.h2.engine.Engine.openSession(Engine.java:57)
> at org.h2.engine.Engine.openSession(Engine.java:164)
> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142)
> at org.h2.engine.Engine.createSession(Engine.java:125)
> at org.h2.engine.Engine.createSession(Engine.java:27)
> at
> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:331)
> at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:107)
> at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:91)
> at org.h2.Driver.connect(Driver.java:74)
> at org.h2.server.web.WebServer.getConnection(WebServer.java:684)
> at org.h2.server.web.WebApp.login(WebApp.java:958)
> at org.h2.server.web.WebApp.process(WebApp.java:212)
> at org.h2.server.web.WebApp.processRequest(WebApp.java:171)
> at org.h2.server.web.WebThread.process(WebThread.java:138)
> at org.h2.server.web.WebThread.run(WebThread.java:94)
> at java.lang.Thread.run(Unknown Source)
>
> The database is used for a test management tool which I want to update.
> Anyone could help ?
>
> Best regards
>
> --
> 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
> h2-database+unsubscr...@googlegroups.com
> .
> To post to this group, send email to
> h2-database@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
