Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-26990

All table add the primary key in the Artifactory database

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None

      Description

      Problem description:

      When we use the MySQL innodb group cluster, all tables in the database must have the primary key which is mandatory. But now the database has three tables does not has the primary key in default, it is build_promotions, node_events_tmp, tasks.

      build_promotions and node_events_tmp can use the build_id and tmp_event_id to create the primary key.  But the task table seems like no column to be the primary key

      Possible workaround: 

      Not use the group cluster, use the master-slave model.

      What is the expected behavior? 

      All tables need to have the primary key that is best. At least, the table task needs to have an id column.

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            mengk Meng Ke
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: