|
Re: [CDO] - Not compatible with mySql 5.6 ? [message #1402573 is a reply to message #1402262] |
Thu, 17 July 2014 07:10 |
Esteban Dugueperoux Messages: 472 Registered: July 2009 |
Senior Member |
|
|
Hi Bernard,
Indeed this is problematic, could you raise a bugzilla to track this
issue on CDO side.
Best Regards.
Le 16/07/2014 21:26, Bernard SARTER a écrit :
> Hi,
>
> I've a CDO server (in sync with Luna), that works fine with mySql 5.5.
>
> By moving to mySql 5.6, the start of the server fails with following
> stack trace:
>
> org.eclipse.net4j.db.DBException: Specified key was too long; max key
> length is 767 bytes --> CREATE INDEX I1405538039238_12 ON
> CDO_EXTERNAL_REFS (URI(1024))
> at org.eclipse.net4j.db.DBUtil.execute(DBUtil.java:830)
> at org.eclipse.net4j.spi.db.DBAdapter.createIndex(DBAdapter.java:472)
> at org.eclipse.net4j.spi.db.DBAdapter$1.visit(DBAdapter.java:402)
> at
> org.eclipse.net4j.internal.db.ddl.delta.DBIndexDelta.doAccept(DBIndexDelta.java:153)
>
> at
> org.eclipse.net4j.internal.db.ddl.delta.DBDelta.accept(DBDelta.java:89)
> at
> org.eclipse.net4j.internal.db.ddl.delta.DBDelta.accept(DBDelta.java:98)
> at
> org.eclipse.net4j.internal.db.ddl.delta.DBDelta.accept(DBDelta.java:98)
> at org.eclipse.net4j.spi.db.DBAdapter.updateSchema(DBAdapter.java:420)
> at
> org.eclipse.net4j.internal.db.DBSchemaTransaction.run(DBSchemaTransaction.java:124)
>
> at
> org.eclipse.net4j.internal.db.DBSchemaTransaction.run(DBSchemaTransaction.java:1)
>
> at org.eclipse.net4j.db.DBUtil.execute(DBUtil.java:796)
> at
> org.eclipse.net4j.internal.db.DBSchemaTransaction.commit(DBSchemaTransaction.java:99)
>
> at
> org.eclipse.net4j.internal.db.DBDatabase.updateSchema(DBDatabase.java:129)
> at
> org.eclipse.emf.cdo.server.internal.db.ExternalReferenceManager.doActivate(ExternalReferenceManager.java:192)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at
> org.eclipse.emf.cdo.server.internal.db.LongIDHandler.doActivate(LongIDHandler.java:263)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
>
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:638)
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
>
> at
> org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1726)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
>
> at
> org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
>
> at
> org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
>
> at
> org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:277)
>
> at
> org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:188)
>
> at
> org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:160)
>
>
> The config file is simple:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <cdoServer>
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036" />
>
> <repository name="repo1">
> <property name="overrideUUID"
> value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f" />
> <property name="supportingAudits" value="true" />
>
> <store type="db">
> <mappingStrategy type="horizontal">
> <property name="qualifiedNames" value="false" />
> <property name="toManyReferences"
> value="ONE_TABLE_PER_REFERENCE" />
> <property name="toOneReferences"
> value="LIKE_ATTRIBUTES" />
> </mappingStrategy>
>
> <dbAdapter name="mysql" />
> <dataSource
> class="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
> url="jdbc:mysql://localhost/my_db" user="root"
> password="****" />
>
> </store>
> </repository>
> </cdoServer>
> This seems to be linked to a "change" in mySql behaviour between 5.5 and
> 5.6, see here: http://bugs.mysql.com/bug.php?id=71613
>
> It's not clear to me if Oracle is willing to consider this "change" as a
> bug or not.
>
> I'll investigate for a workaround by changing mySql settings, but I'm
> also wondering if there is a chance to workaround or fix the problem
> inside CDO (which I would prefer) ....
>
> Best regards,
> Bernard.
>
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.01892 seconds