[#MMB-1751] Explicit index on unique field results error in hsql. - MMBase

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 1.9.0
Fix Version/s: 1.9.6
Component/s: Core

Description:

Hide
mmbasegroups from context security:
<field name="name">
      <gui>
        <guiname xml:lang="en">Name</guiname>
        <guiname xml:lang="nl">Naam</guiname>
        <guiname xml:lang="eo">Nomo</guiname>
      </gui>
      <editor>
        <positions>
          <list>1</list>
        </positions>
      </editor>
      <datatype base="eline" xmlns="http://www.mmbase.org/xmlns/datatypes" >
        <unique value="true" />
        <required value="true" enforce="never" />
        <maxLength value="32" />
      </datatype>
    </field>

....
<indexlist>
    <index name="name" unique="true"><indexfield name="name" /></index>
  </indexlist>


results:

16:52:44,382 WAR 14189 kb mmbase.module.core.MMBase localhost init.373 - HTML root not yet known. MachineName will not be correct yet.
16:52:54,068 ERR 51093 kb mmbase.module.core.MMObjectBuilder sepio/ create.553 - Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)] in query:ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)org.mmbase.storage.StorageException: Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)] in query:ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2815)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2782)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:2106)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1995)
        at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:550)
        at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:430)
        at org.mmbase.security.implementation.cloudcontext.builders.Groups.init(Groups.java:46)
        at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:885)
        at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:862)
        at org.mmbase.module.core.MMBase.init(MMBase.java:409)
        at org.mmbase.module.Module.startModule(Module.java:168)
        at org.mmbase.module.Module.startModules(Module.java:386)
        at org.mmbase.module.Module.checkModules(Module.java:451)
        at org.mmbase.module.Module.getModule(Module.java:424)
        at org.mmbase.module.Module.getModule(Module.java:435)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:637)
        at org.mmbase.bridge.implementation.BasicCloudContext.check(BasicCloudContext.java:84)
        at org.mmbase.bridge.implementation.BasicCloudContext.assertUp(BasicCloudContext.java:244)
        at org.mmbase.util.ThreadPools$3.run(ThreadPools.java:110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
        at org.mmbase.util.ThreadPools$1.run(ThreadPools.java:80)
java.sql.SQLException: Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
        at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:57)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2809)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2782)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:2106)
        at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1995)
        at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:550)
        at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:430)
        at org.mmbase.security.implementation.cloudcontext.builders.Groups.init(Groups.java:46)
        at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:885)
        at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:862)
        at org.mmbase.module.core.MMBase.init(MMBase.java:409)
        at org.mmbase.module.Module.startModule(Module.java:168)
        at org.mmbase.module.Module.startModules(Module.java:386)
        at org.mmbase.module.Module.checkModules(Module.java:451)
        at org.mmbase.module.Module.getModule(Module.java:424)
        at org.mmbase.module.Module.getModule(Module.java:435)
        at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:637)
        at org.mmbase.bridge.implementation.BasicCloudContext.check(BasicCloudContext.java:84)
        at org.mmbase.bridge.implementation.BasicCloudContext.assertUp(BasicCloudContext.java:244)
        at org.mmbase.util.ThreadPools$3.run(ThreadPools.java:110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
        at org.mmbase.util.ThreadPools$1.run(ThreadPools.java:80)

Show
mmbasegroups from context security: <field name="name">       <gui>         <guiname xml:lang="en">Name</guiname>         <guiname xml:lang="nl">Naam</guiname>         <guiname xml:lang="eo">Nomo</guiname>       </gui>       <editor>         <positions>           <list>1</list>         </positions>       </editor>       <datatype base="eline" xmlns="http://www.mmbase.org/xmlns/datatypes" >         <unique value="true" />         <required value="true" enforce="never" />         <maxLength value="32" />       </datatype>     </field> .... <indexlist>     <index name="name" unique="true"><indexfield name="name" /></index>   </indexlist>    results: 16:52:44,382 WAR 14189 kb mmbase.module.core.MMBase localhost init.373 - HTML root not yet known. MachineName will not be correct yet. 16:52:54,068 ERR 51093 kb mmbase.module.core.MMObjectBuilder sepio/ create.553 - Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)] in query:ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)org.mmbase.storage.StorageException: Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)] in query:ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2815)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2782)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:2106)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1995)         at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:550)         at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:430)         at org.mmbase.security.implementation.cloudcontext.builders.Groups.init(Groups.java:46)         at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:885)         at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:862)         at org.mmbase.module.core.MMBase.init(MMBase.java:409)         at org.mmbase.module.Module.startModule(Module.java:168)         at org.mmbase.module.Module.startModules(Module.java:386)         at org.mmbase.module.Module.checkModules(Module.java:451)         at org.mmbase.module.Module.getModule(Module.java:424)         at org.mmbase.module.Module.getModule(Module.java:435)         at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:637)         at org.mmbase.bridge.implementation.BasicCloudContext.check(BasicCloudContext.java:84)         at org.mmbase.bridge.implementation.BasicCloudContext.assertUp(BasicCloudContext.java:244)         at org.mmbase.util.ThreadPools$3.run(ThreadPools.java:110)         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)         at java.lang.Thread.run(Thread.java:595)         at org.mmbase.util.ThreadPools$1.run(ThreadPools.java:80) java.sql.SQLException: Constraint already exists in statement [ALTER TABLE MMBASETESTS_MMBASEGROUPS ADD CONSTRAINT MMBASETESTS_MMBASEGROUPS_NAME_IDX UNIQUE (NAME)]         at org.hsqldb.jdbc.Util.sqlException(Unknown Source)         at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)         at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)         at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:57)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.createIndex(DatabaseStorageManager.java:2809)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:2782)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.createTable(DatabaseStorageManager.java:2106)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1995)         at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:550)         at org.mmbase.module.core.MMObjectBuilder.init(MMObjectBuilder.java:430)         at org.mmbase.security.implementation.cloudcontext.builders.Groups.init(Groups.java:46)         at org.mmbase.module.core.MMBase.initBuilder(MMBase.java:885)         at org.mmbase.module.core.MMBase.initBuilders(MMBase.java:862)         at org.mmbase.module.core.MMBase.init(MMBase.java:409)         at org.mmbase.module.Module.startModule(Module.java:168)         at org.mmbase.module.Module.startModules(Module.java:386)         at org.mmbase.module.Module.checkModules(Module.java:451)         at org.mmbase.module.Module.getModule(Module.java:424)         at org.mmbase.module.Module.getModule(Module.java:435)         at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:637)         at org.mmbase.bridge.implementation.BasicCloudContext.check(BasicCloudContext.java:84)         at org.mmbase.bridge.implementation.BasicCloudContext.assertUp(BasicCloudContext.java:244)         at org.mmbase.util.ThreadPools$3.run(ThreadPools.java:110)         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)         at java.lang.Thread.run(Thread.java:595)         at org.mmbase.util.ThreadPools$1.run(ThreadPools.java:80)

Activity

Ascending order - Click to sort in descending order

No work has yet been logged on this issue.

People

Assignee:

Michiel Meeuwissen

Reporter:

Michiel Meeuwissen
Votes:

0

Watchers:

0

Dates

Created:

2008-12-16 16:57

Updated:

2011-02-08 17:11

Resolved:

2011-02-08 17:11