UAA on Compose for MySQL


Paul Bakare
 

Hi,

Caught something looking like a bug when UAA is faced with a clustered MySQL. Error details below:

2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT Migration V2_4_1__Zonify_Group_Memberships.sql failed

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT Statement  : UPDATE group_membership SET identity_zone_id = (SELECT identity_zone_id FROM users where users.id = group_membership.member_id)

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     ... 49 common frames omitted

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT Statement  : UPDATE group_membership SET identity_zone_id = (SELECT identity_zone_id FROM users where users.id = group_membership.member_id)

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.Flyway$1.execute(Flyway.java:971) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.flywaydb.core.Flyway.execute(Flyway.java:1464) ~[flyway-core-4.2.0.jar!/:na]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT Caused by: java.sql.SQLException: (conn:32607) The table does not comply with the requirements by an external plugin.

   2018-05-11T22:06:17.47+0100 [APP/PROC/WEB/0] OUT     at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77) ~[mariadb-java-client-1.5.9.jar!/:na]



--
Odeyemi 'Kayode O.
http://ng.linkedin.com/in/kayodeodeyemi. t: @charyorde