Uploaded image for project: 'Sentry (Retired)'
  1. Sentry (Retired)
  2. SENTRY-1614

DB schema key is too long for MySQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Not A Problem
    • 2.0.0
    • None
    • Sentry
    • None

    Description

      When a schema tool is used to initialize sentry database schema we observing issue and the initialization of schema fails. Here are the details of the failure.

      Error: Specified key was too long; max key length is 767 bytes

      Error: Specified key was too long; max key length is 767 bytes (state=42000,code=1071)
Closing: 0: jdbc:mysql://192.168.56.103/sentry_db1
org.apache.sentry.core.common.exception.SentryUserException: Schema initialization FAILED! Metastore state would be inconsistent !!
*** Sentry schemaTool failed ***

      Attachments

        1. SENTRY-1614.001-sentry-ha-redesign.patch
          22 kB
          Krishna Kalyan
        2. SENTRY-1614.002-sentry-ha-redesign.patch
          13 kB
          Krishna Kalyan

        Issue Links

          is blocked by

          Sub-task - The sub-task of the issue SENTRY-1690 sql changed needed for AUTHZ_PATH table

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          relates to

          Sub-task - The sub-task of the issue SENTRY-1593 Implement client failover for Generic and NN clients

          • Blocker - Blocks development and/or testing work, production could not run
          • Resolved
          links to

          Web Link Code review Link

          Activity

            People

              kkalyan Krishna Kalyan
              kkalyan Krishna Kalyan
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: