With 1.4.179 I am facing this problem
Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX";
SQL statement:
ALTER TABLE PUBLIC.TABACCOUNT ADD CONSTRAINT
PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO FOREIGN KEY(PARENTACCOUNTNO) INDEX
PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO_INDEX_D REFERENCES
PUBLIC.TABACCOUNT(ACCOUNTNO) INDEX PUBLIC.PRIMARY_KEY_DC6 NOCHECK
[23505-179]
<http://192.168.43.206:8082/login.do?jsessionid=3a9c7be376a442f869ae96c77692d959#>
23505/23505 (Help)
<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c23505>
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
"PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE PUBLIC.TABACCOUNT ADD CONSTRAINT
PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO FOREIGN KEY(PARENTACCOUNTNO) INDEX
PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO_INDEX_D REFERENCES
PUBLIC.TABACCOUNT(ACCOUNTNO) INDEX PUBLIC.PRIMARY_KEY_DC6 NOCHECK
[23505-179]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345
<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=345&build=179>)
at org.h2.message.DbException.get(DbException.java:179
<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=179&build=179>)
at org.h2.message.DbException.get(DbException.java:155
<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=155&build=179>)
at
org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:165
<http://h2database.com/html/source.html?file=org/h2/index/PageDataIndex.java&line=165&build=179>)
at org.h2.index.PageDataIndex.add(PageDataIndex.java:143
<http://h2database.com/html/source.html?file=org/h2/index/PageDataIndex.java&line=143&build=179>)
at org.h2.store.PageStore.addMeta(PageStore.java:1812
<http://h2database.com/html/source.html?file=org/h2/store/PageStore.java&line=1812&build=179>)
at org.h2.index.PageBtreeIndex.<init>(PageBtreeIndex.java:63
<http://h2database.com/html/source.html?file=org/h2/index/PageBtreeIndex.java&line=63&build=179>)
at org.h2.table.RegularTable.addIndex(RegularTable.java:234
<http://h2database.com/html/source.html?file=org/h2/table/RegularTable.java&line=234&build=179>)
at
org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:287
<http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAddConstraint.java&line=287&build=179>)
at
org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:236
<http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAddConstraint.java&line=236&build=179>)
at
org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:72
<http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAddConstraint.java&line=72&build=179>)
at org.h2.engine.MetaRecord.execute(MetaRecord.java:58
<http://h2database.com/html/source.html?file=org/h2/engine/MetaRecord.java&line=58&build=179>)
at org.h2.engine.Database.open(Database.java:729
<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=729&build=179>)
at org.h2.engine.Database.openDatabase(Database.java:263
<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=263&build=179>)
at org.h2.engine.Database.<init>(Database.java:257
<http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=257&build=179>)
at org.h2.engine.Engine.openSession(Engine.java:58
<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=58&build=179>)
at org.h2.engine.Engine.openSession(Engine.java:165
<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=165&build=179>)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:143
<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=143&build=179>)
at org.h2.engine.Engine.createSession(Engine.java:126
<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=126&build=179>)
at org.h2.engine.Engine.createSession(Engine.java:26
<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=26&build=179>)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:335
<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=335&build=179>)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107
<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=107&build=179>)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91
<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=91&build=179>)
at org.h2.Driver.connect(Driver.java:72
<http://h2database.com/html/source.html?file=org/h2/Driver.java&line=72&build=179>)
at org.h2.server.web.WebServer.getConnection(WebServer.java:682
<http://h2database.com/html/source.html?file=org/h2/server/web/WebServer.java&line=682&build=179>)
at org.h2.server.web.WebApp.login(WebApp.java:957
<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=957&build=179>)
at org.h2.server.web.WebApp.process(WebApp.java:211
<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=211&build=179>)
at org.h2.server.web.WebApp.processRequest(WebApp.java:170
<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=170&build=179>)
at org.h2.server.web.WebThread.process(WebThread.java:137
<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=137&build=179>)
at org.h2.server.web.WebThread.run(WebThread.java:93
<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=179>)
at java.lang.Thread.run(Unknown Source)
On Monday, June 2, 2014 9:46:18 PM UTC+5:30, Thomas Mueller wrote:
>
> Hi,
>
> I finally found and fixed the problem now. This problem will be fixed in
> the next release. One workaround is to not upgrade to version 1.3.176 if
> the database was created with an earlier version. Another workaround is to
> export the database file to a SQL script and re-create it.
>
> Regards,
> Thomas
>
>
>
> On Wed, May 28, 2014 at 4:42 PM, Nick99 <nail.a...@gmail.com <javascript:>
> > wrote:
>
>> Same problem.
>>
>> 1.
>> The database was created in CREATE_BUILD 170, then was used with 1.3.174.
>> I've tried using 1.4.178 on that database in Hibernate-based product - got
>>
>> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
>> "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:[...]
>>
>> 1.3.175 works ok on that db. 1.3.176 is not.
>>
>> 2.
>> Opening the db in 1.3.176 Console produces this (table names removed):
>>
>> Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX";
>> SQL statement:
>> ALTER TABLE PUBLIC.-------------- ADD CONSTRAINT
>> PUBLIC.FK28D9808AF98221CA FOREIGN KEY(JESID) REFERENCES
>> PUBLIC.--------------(ID) NOCHECK [23505-176] 23505/23505 (Help)
>>
>>
>> On Monday, May 26, 2014 10:33:05 AM UTC+3, Germano Rizzo wrote:
>>>
>>> Provided here
>>> <https://groups.google.com/forum/?hl=it#!topic/h2-database/lNp80bgbvBY>.
>>> Thanks!
>>>
>>> Il giorno giovedì 22 maggio 2014 17:43:18 UTC+2, Thomas Mueller ha
>>> scritto:
>>>>
>>>> Hi
>>>>
>>>> I would need a reproducible test case, or the database file.
>>>>
>>>> Regards, Thomas
>>>>
>>>> On Thursday, May 22, 2014, jack jin <supe...@gmail.com> wrote:
>>>>
>>>>> when I upgrade to 1.3.176,I have the same problem. the old version h2
>>>>> is works fine with the db file
>>>>>
>>>>> On Tuesday, May 6, 2014 5:00:52 PM UTC+8, Germano Rizzo wrote:
>>>>>>
>>>>>> Hi Thomas,
>>>>>> so your opinion is that all the db's are corrupted? The
>>>>>> strange thing is, they fail to open only with the latest stable version.
>>>>>> Every other version I tried works fine, and this configuration have
>>>>>> worked
>>>>>> in 40 installations for 3 years now, across different versions of H2. Do
>>>>>> you want me to start another thread?
>>>>>>
>>>>>> Germano
>>>>>>
>>>>>> Il giorno martedì 6 maggio 2014 07:59:45 UTC+2, Thomas Mueller ha
>>>>>> scritto:
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> If you are using LOCK_MODE=0;UNDO_LOG=0 then you need to be aware
>>>>>>> of the risks. See the FAQ and the documentation.
>>>>>>>
>>>>>>> Please use different email subjects for different problems.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Thomas
>>>>>>>
>>>>>>>
>>>>>>> On Monday, May 5, 2014, mano <german...@gmail.com> wrote:
>>>>>>>
>>>>>>>> mano wrote
>>>>>>>> > Opening it with version 1.3.168 will give the error.
>>>>>>>>
>>>>>>>> Sorry, I meant 1.3.176.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> View this message in context: http://h2-database.66688.n3.na
>>>>>>>> bble.com/Unique-index-or-primary-key-violation-SYS-ID-ON-
>>>>>>>> PUBLIC-SYS-ID-23505-168-using-1-3-168-tp4028700p4029078.html
>>>>>>>> Sent from the H2 Database mailing list archive at Nabble.com.
>>>>>>>>
>>>>>>>
>
--
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.
