I solved my problem by downgrading to h2-1.3.172.jar 1.3.176 or 1.3.178 wouldn't open my database "Unique index or primary key violation" 1.3.172 opens it just fine. Maybe try the same
Le mercredi 21 mai 2014 19:47:54 UTC+2, Ospeleo a écrit : > > hi, > it is the same error message I have reported on this subject, posted > today: > https://groups.google.com/d/msg/h2-database/iPAECUAML4Y/70PkSslWInQJ > > I access my database via my application/ Works great. I want to manipulate > the table. The same error than yours. > > > Le mercredi 21 mai 2014 14:30:57 UTC+2, Benoit HELIE a écrit : >> >> 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.<init>(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.<init>(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.<init>(JdbcConnection.java:107) >> at org.h2.jdbc.JdbcConnection.<init>(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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
