Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-15094

MySQL 5.6 requires columns shorter than 255 when they are indexed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0
    • Component/s: Core VCS

      Description

      Currently on startup this fails:

      Caused by: java.sql.SQLException: Error post creating table: CREATE INDEX `primarytype_idx` ON `hierarchy` (`primarytype`) : Specified key was too long; max key length is 767 bytes
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:245)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:155)
	... 36 more
...

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-7828 Support MySQL directories with UTF-8 database

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-10086 SQLBinaryManager tests fails to create binaries table on MySQL 5.5

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: