You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@predictionio.apache.org by "Naoki Takezoe (JIRA)" <ji...@apache.org> on 2018/09/22 11:59:00 UTC

[jira] [Updated] (PIO-169) Constraint problem in MySQL

     [ https://issues.apache.org/jira/browse/PIO-169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Naoki Takezoe updated PIO-169:
------------------------------
    Summary: Constraint problem in MySQL  (was: Foreign key problem in MySQL)

> Constraint problem in MySQL
> ---------------------------
>
>                 Key: PIO-169
>                 URL: https://issues.apache.org/jira/browse/PIO-169
>             Project: PredictionIO
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 0.13.0
>            Reporter: Naoki Takezoe
>            Priority: Major
>
> 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]
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)