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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 2.3.2
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Environment:

      CentOS 6.0, MySQL Server 5.1.52

    • Last commented by user?:
      true

      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

              • Votes:
                2 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Last commented:
                  5 years, 9 weeks, 4 days ago