Hi,
I think this issue was resolved in version 1.4.179, see the changelog entry:
- Databases created with version 1.3.175 and earlier that contained
foreign keys in combination with multi-column indexes could not be opened
in some cases. This was due to a bugfix in version 1.3.176: Referential
integrity constraints sometimes used the wrong index.
I suggest to use a recent version of H2, but append ;mv_store=false to
the database URL.
Worst case, you would need to export the database to a SQL script with an
old version, and re-created it from the script in the new version.
Regards,
Thomas
On Fri, May 22, 2015 at 6:29 PM, Carson carsonhuang2...@gmail.com wrote:
Hi,
I'm new to H2, and I have to work with an pre-existing h2 database. So
basically, when I first access the database through the console, I manage
to log in. However, after disconnecting, and trying to re-access it, I get
the following error:
Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX;
SQL statement:
ALTER TABLE PUBLIC.PPT_TEMPLATE ADD CONSTRAINT PUBLIC.CONSTRAINT_21
FOREIGN KEY(ID_TEMPLATE) REFERENCES PUBLIC.PPT_TEMPLATE(ID_TEMPLATE)
NOCHECK [23505-176]
The only way for to re-access it is to get a fresh copy in git, but
everytime, after I access it, I won't be able to re-access it... Can anyone
pinpoint me to where I may be able to solve this issue?
My database version is 1.3.176 (I took the version shown on the tab when I
open the database through the H2 console tab)
My URL is: jdbc:h2:C:\Users\Carson\db\PPT_DB;CIPHER=AES
--
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.