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

Setup wizard does not create all tables when using MyISAM with MySQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Medium
    • None
    • 2.3.2
    • Database
    • None
    • CentOS 6.0, MySQL Server 5.1.52

    Description

      Going through the setup wizard I got an exception when trying to set the Deployment title, Session timeout, and Base URL.

      Error displayed:
      "could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]

      {name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}

      ] "

      From tomcat logs:
      2011-08-18 21:33:17,363 http-8095-3 ERROR [console.action.setup.Options] could not load an entity: [com.atlassian.crowd.model.property.Property#compo
      nent[key,name]

      {name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.at
      lassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}

      ]
      org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key
      ,name]

      {name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.
      crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}

      ]
      (blah blah blah)
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
      ... 114 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crowd.cwd_property' doesn't exist

      Looking at the database:

      mysql> use crowd;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      mysql> show tables;
      ----------------------------

      Tables_in_crowd

      ----------------------------

      cwd_app_dir_group_mapping
      cwd_app_dir_mapping
      cwd_app_dir_operation
      cwd_application
      cwd_application_address
      cwd_application_alias
      cwd_application_attribute
      cwd_directory
      cwd_directory_attribute
      cwd_directory_operation
      cwd_group
      cwd_membership
      cwd_token
      cwd_user
      cwd_user_credential_record
      hibernate_unique_key

      ----------------------------
      16 rows in set (0.00 sec)

      I'm using MyISAM, the hibernate dialect is MySQLDialect. My guess is that the schema creation code didn't create all the tables.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              94b9ea98a2fc Jesse Callaway
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: