Uploaded image for project: 'Jenkins'
  1. Jenkins
  2. JENKINS-54784

Database creation failure on MySQL 5.5: "ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes"

XMLWordPrintable

      https://github.com/jenkinsci/pipeline-maven-plugin/blob/pipeline-maven-3.6.1/jenkins-plugin/src/main/resources/sql/mysql/01_migration.sql

      CREATE UNIQUE INDEX IDX_JENKINS_JOB on JENKINS_JOB (JENKINS_MASTER_ID, FULL_NAME);

ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

      See https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

      MySQL 5.5 and 5.6 are limited to 767 bytes on indexes when version 5.7+ supports much more, see details

            cleclerc Cyrille Le Clerc
            cleclerc Cyrille Le Clerc
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: