Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-72415

Reusing a mysql database user on a new database caused Jira startup to fail with table not found error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Tracked Elsewhere
    • Icon: Low Low
    • None
    • 8.13.6, 8.16.1
    • Installation

      A new install of Jira fails to start due to missed tables.

      Steps to Reproduce

      • Environment:
        MySql 8.0
        JDBC 22
        Jira 8.16.1 binary install
      • Create a new database
      • grant permission to an already existent user
      • Run config.sh to configure jira_home location and configure JDBC connection
      • Test connection -> It will be successful
      • Start Jira

      What was expected

      Jira install and enter the setup mode

      What had happened instead

      Jira did not enter the setup mode and fail as the database is empty (can not find tables)

      Workaround

      • Delete all content of Jira home folder
      • Drop Database, create new user, create new DB, and grant access:
        drop database jiradb816;
        create user 'jira-816'@'localhost' IDENTIFIED BY 'jira-816';
        CREATE DATABASE jiradb816 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
        GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb816.* TO 'jira-816'@'localhost';
        flush privileges;
        

            Unassigned Unassigned
            imurakami@atlassian.com Murakami
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: