Uploaded image for project: 'PredictionIO (Retired)'
  1. PredictionIO (Retired)
  2. PIO-169

Index creation problem in MySQL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.13.0
    • None
    • Core
    • None

    Description

      In the following situation, database initialization process causes SQLSyntaxErrorException.

      • MySQL with utf8mb4 as the default charset
      • INDEX option is enabled

      I guess this exception is caused here: https://github.com/apache/predictionio/blob/49b64ee1538bdba7b6c5958773fa7908ee9f80a2/storage/jdbc/src/main/scala/org/apache/predictionio/data/storage/jdbc/JDBCLEvents.scala#L72

      Originaly, this problem was reported on the users list: https://lists.apache.org/thread.html/71d645b0c877fd5063981d814505ece28d15e6b8e2403a6692822734@%3Cuser.predictionio.apache.org%3E

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            takezoe Naoki Takezoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: