• Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 3.3.0
    • 2.8
    • Performance
    • The Crowd Server installed is integrated with an Oracle 11r2 Database. The setup done with the Crowd setup Wizard on a clean server and empty database.

      Tracking the log-file in Crowd tells an error on hibernate.tool.hbm2ddl.SchemaUpdate:
      HHH000388: Unsuccessful: create index idx_expirable_user_token_key on cwd_expirable_user_token (token)
      ...
      [hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01408: such column list already indexed
      _tell the create index was unsuccessful.

      The solution or workaround in included in the attachment.

            [CWD-4242] ERROR [hibernate.tool.hbm2ddl.SchemaUpdate]

            Since Crowd 3.3.0 liquibase is used exclusively for database schema upgrades. As hbm2ddl is not being used anymore, this issue has become obsolete.

            Jakub Podeszwik (Inactive) added a comment - Since Crowd 3.3.0 liquibase is used exclusively for database schema upgrades. As hbm2ddl is not being used anymore, this issue has become obsolete.

            Similar error with sqlserver , but with a higher level..

            Violation of UNIQUE KEY constraint 'uk_app_dir_group'. Cannot insert duplicate key in object 'dbo.cwd_app_dir_group_mapping'. The duplicate key value is (196609, myvalue).], SQL: insert into cwd_app_dir_group_mapping (app_dir_mapping_id, application_id, directory_id, group_name, id) values (?, ?, ?, ?, ?)

            fabrizio galletti added a comment - Similar error with sqlserver , but with a higher level.. Violation of UNIQUE KEY constraint 'uk_app_dir_group'. Cannot insert duplicate key in object 'dbo.cwd_app_dir_group_mapping'. The duplicate key value is (196609, myvalue).], SQL: insert into cwd_app_dir_group_mapping (app_dir_mapping_id, application_id, directory_id, group_name, id) values (?, ?, ?, ?, ?)

            Hi team,

            We are also facing the similar issue. could you please provide an update on the same issue.

            Mohit Saraf added a comment - Hi team, We are also facing the similar issue. could you please provide an update on the same issue.

            Priya Rai added a comment -

            Hi Team, We too are getting this error in our Crowd 2.9.1 and Crowd service stops too frequently.

            Any help is appreciated.

            Priya Rai added a comment - Hi Team, We too are getting this error in our Crowd 2.9.1 and Crowd service stops too frequently. Any help is appreciated.

            We are getting the same error. The issue doesn't seem to have an immediate negative effect..

            crowd03_1 | 2017-01-13 12:48:26,343 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] HHH000388: Unsuccessful: create index idx_expirable_user_token_key on cwd_expirable_user_token (token)
            crowd03_1 | 2017-01-13 12:48:26,344 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01408: such column list already indexed
            crowd03_1 | 2017-01-13 12:48:26,378 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] HHH000388: Unsuccessful: create index idx_webhook_url_app on cwd_webhook (endpoint_url, application_id)
            crowd03_1 | 2017-01-13 12:48:26,379 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01408: such column list already indexed
            

            A patch in a future release would be appreciated. 

            Justin Isler added a comment - We are getting the same error. The issue doesn't seem to have an immediate negative effect.. crowd03_1 | 2017-01-13 12:48:26,343 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] HHH000388: Unsuccessful: create index idx_expirable_user_token_key on cwd_expirable_user_token (token) crowd03_1 | 2017-01-13 12:48:26,344 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01408: such column list already indexed crowd03_1 | 2017-01-13 12:48:26,378 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] HHH000388: Unsuccessful: create index idx_webhook_url_app on cwd_webhook (endpoint_url, application_id) crowd03_1 | 2017-01-13 12:48:26,379 localhost-startStop-1 ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01408: such column list already indexed A patch in a future release would be appreciated. 

            We have a similar issue. We just upgraded from Crowd 2.7.1 to 2.8.3 (we are using the war deployment with on a Debian Jessie with Tomcat7 & OpenJDK7 in combination with Oracle 11Gr2 and LDAP). Are there any news regarding this issue?

            Joachim Sengenberger added a comment - We have a similar issue. We just upgraded from Crowd 2.7.1 to 2.8.3 (we are using the war deployment with on a Debian Jessie with Tomcat7 & OpenJDK7 in combination with Oracle 11Gr2 and LDAP). Are there any news regarding this issue?

            Hi Caspar,

            You may share the workaround with the rest of the world.

            Gert

            Gert Kuivenhoven added a comment - Hi Caspar, You may share the workaround with the rest of the world. Gert

            Thanks for the bug report g.kuivenhoven@rijnland.net. Is it okay if we open this up to the rest of the world so they can use the workaround as well?

            On the actual issue, the relevant snippet from our hibernate config is

            <property name="token" column="token" type="string" not-null="true" length="255" unique-key="uk_expirable_user_token"
                              index="idx_expirable_user_token_key"/>
            

            We also have a similar situation (index and unique key constraint on the same column) in at least one other case, the column group_name in the table cwd_app_dir_group_mapping, with unique-key="uk_app_dir_group" and index="idx_app_dir_group_group_dir". Did you get any errors for those? (That table/column has been around for an extra year.)

            Caspar Krieger (Inactive) added a comment - Thanks for the bug report g.kuivenhoven@rijnland.net . Is it okay if we open this up to the rest of the world so they can use the workaround as well? On the actual issue, the relevant snippet from our hibernate config is <property name= "token" column= "token" type= "string" not- null = " true " length= "255" unique-key= "uk_expirable_user_token" index= "idx_expirable_user_token_key" /> We also have a similar situation (index and unique key constraint on the same column) in at least one other case, the column group_name in the table cwd_app_dir_group_mapping , with unique-key="uk_app_dir_group" and index="idx_app_dir_group_group_dir" . Did you get any errors for those? (That table/column has been around for an extra year.)

              Unassigned Unassigned
              0ce727b9bfc7 Gert Kuivenhoven
              Affected customers:
              3 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: