Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-3830

Crowd throws database table errors upon initial setup

    XMLWordPrintable

Details

    Description

      Atlassian Update - 8 June 2020

      Hello everyone,

      We have recently reviewed this issue and the overall interest in the problem. As the issue hasn't collect votes, watchers, comments, or support cases from many customers during its lifetime, it's very low on our priority list, and will not be fixed in the foreseeable future. That's why we've decided to resolve it as Timed Out.

      Although we're aware the issue is still important to those of you who were involved in the conversations around it, we want to be clear in managing your expectations. The Crowd team is focusing on issues that have broad impact and high value, reflected by the number of comments, votes, support cases, and customers interested. Please consult the Atlassian Bugfix Policy for more details.

      We understand how disappointing this decision may be, but we hope you'll appreciate our transparent approach and communication.

      Atlassian will continue to watch this issue for further updates, so please feel free to share your thoughts in the comments.

      Thank you,

      Crowd Team

      Crowd is throwing some strange database errors about creating tables and foreign keys as the ones below:

      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] HHH000389: Unsuccessful: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_mapping
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Table not found: CWD_APP_DIR_GROUP_MAPPING in statement [
          alter table cwd_app_dir_group_mapping]
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] HHH000389: Unsuccessful: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_app
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Table not found: CWD_APP_DIR_GROUP_MAPPING in statement [
          alter table cwd_app_dir_group_mapping]
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] HHH000389: Unsuccessful: alter table cwd_app_dir_group_mapping drop constraint fk_app_dir_group_dir
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Table not found: CWD_APP_DIR_GROUP_MAPPING in statement [
          alter table cwd_app_dir_group_mapping]
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] HHH000389: Unsuccessful: alter table cwd_app_dir_mapping drop constraint fk_app_dir_app
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Table not found: CWD_APP_DIR_MAPPING in statement [
          alter table cwd_app_dir_mapping]
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] HHH000389: Unsuccessful: alter table cwd_app_dir_mapping drop constraint fk_app_dir_dir
      http-bio-8095-exec-25 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Table not found: CWD_APP_DIR_MAPPING in statement [
          alter table cwd_app_dir_mapping]
      

      Crowd starts normally though.

      This started to happen in crowd 2.7.x and also happens when using external databases. On Crowd 2.6.x the error is not reproducible.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rgadami Rodrigo Girardi Adami
            Votes:
            5 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: