[jboss-jira] [JBoss JIRA] Commented: (JGRP-1345) JDBC_PING fails to initialize table in mysql

[Raúl Raja Martínez (JIRA)]

    [ https://issues.jboss.org/browse/JGRP-1345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614236#comment-12614236 ] 

Raúl Raja Martínez commented on JGRP-1345:
------------------------------------------

Bela, I will keep that in mind for next time. Sanne, I know my workaround is MYSQL specific and I understand you use standard SQL, I thought this issue was only on MYSQL that's why I commented about the workaround. Any standard MySQL installs on Mac like mine are potentially suffering the same issue. In any case I think this should be looked into as this prevents discovery from working and the only way to find out is to have trace turned on. The app silently fails later when it tries to insert data in tables that do not exist.
Thanks for looking into it and getting back to me.

> JDBC_PING fails to initialize table in mysql
> --------------------------------------------
>
>                 Key: JGRP-1345
>                 URL: https://issues.jboss.org/browse/JGRP-1345
>             Project: JGroups
>          Issue Type: Bug
>    Affects Versions: 2.12
>            Reporter: Raúl Raja Martínez
>            Assignee: Sanne Grinovero
>             Fix For: 2.12.2, 3.0
>
>
> JDBC_PING fails to initialize DB table for discover when executing the following SQL:
> CREATE TABLE JGROUPSPING (own_addr varchar(200) NOT NULL, cluster_name varchar(200) NOT NULL, ping_data varbinary(5000) DEFAULT NULL, PRIMARY KEY (own_addr, cluster_name) )
> The statement results in "Specified key was too long; max key length is 1000 bytes"

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira