Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40187

MBM SMB_SEARCH index to long

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 19.0
    • Component/s: Message Bundle Manager
    • Labels:
      None
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      The following error appears in the log:

       

      21-Jun-2018 13:42:12.623 ERROR [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000388: Unsuccessful: create index SMB_SEARCH on SAKAI_MESSAGE_BUNDLE (BASENAME, MODULE_NAME, LOCALE, PROP_NAME)
      21-Jun-2018 13:42:12.624 ERROR [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute (conn:664) Specified key was too long; max key length is 3072 bytes 
      

      Originally the 4 columns were 150 chars which is under the 768 char length for indexes on a utf8mb4 database.

      Using some more reasonable lengths:

      @Column(name = "BASENAME", length = 150, nullable = false)
      @Column(name = "MODULE_NAME", length = 100, nullable = false)
      @Column(name = "LOCALE", length = 32, nullable = false)
      @Column(name = "PROP_NAME", length = 350, nullable = false)

       

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ern Earle R Nietzel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code