Uploaded image for project: 'S2Graph'
  1. S2Graph
  2. S2GRAPH-90

Specified key was too long error.

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: To Do
    • Major
    • Resolution: Unresolved
    • 0.1.0
    • None
    • None
    • None

    Description

      The following error message is shown when creating table.

      # mysql -uroot < ./s2core/target/scala-2.11/classes/org/apache/s2graph/core/mysqls/schema.sql
      ERROR 1071 (42000) at line 26: Specified key was too long; max key length is 767 bytes
      

      There is restriction for index key length under the default mysql configuration.
      I succeeded creating table after setting some variables. See the following article.

      http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            hjkim Hyoungjun Kim

            Dates

              Created:
              Updated:

              Slack

                Issue deployment