You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (JIRA)" <ji...@apache.org> on 2017/05/25 14:05:06 UTC
[jira] [Commented] (AIRAVATA-2401) App Catalog database mappings
synchronization failure: Invalid default value for 'UPDATE_TIME'
[ https://issues.apache.org/jira/browse/AIRAVATA-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16024767#comment-16024767 ]
Marcus Christie commented on AIRAVATA-2401:
-------------------------------------------
[~scnakandala],
Can you take a quick look at this? If the mapping synchronization is working for you on MariaDB and this is only a MySQL issue then I think we can close this as WONTFIX.
Thanks,
Marcus
> App Catalog database mappings synchronization failure: Invalid default value for 'UPDATE_TIME'
> ----------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2401
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2401
> Project: Airavata
> Issue Type: Bug
> Components: Application Catalog
> Affects Versions: 0.18
> Reporter: Marcus Christie
> Assignee: Supun Chathuranga Nakandala
>
> Stack trace:
> {noformat}
> 2017-05-25 13:54:34,102 [main] ERROR o.a.a.r.a.s.u.AppCatalogInitUtil - Invalid default value for 'UPDATE_TIME' {stmnt
> 646204091
> ALTER TABLE APPLICATION_DEPLOYMENT ADD DEFAULT_WALLTIME INTEGER } [code=1067, state=42000]
> org.apache.openjpa.persistence.PersistenceException: Invalid default value for 'UPDATE_TIME' {stmnt 646204091
> ALTER TABLE APPLICATION_DEPLOYMENT ADD DEFAULT_WALLTIME INTEGER } [code=1067, state=42000]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455)
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209)
> at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:22
> 7)
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:15
> 4)
> at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60
> )
> at org.apache.airavata.registry.core.app.catalog.util.AppCatalogJPAUtils.getEntityManager(AppCatalogJPAUtils.ja
> va:71)
> at org.apache.airavata.registry.core.app.catalog.resources.GatewayProfileResource.isExists(GatewayProfileResour
> ce.java:362)
> at org.apache.airavata.registry.api.service.util.AppCatalogInitUtil.initializeDB(AppCatalogInitUtil.java:101)
> at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:61)
> at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:149)
> at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:370)
> at org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:219)
> at org.apache.airavata.server.ServerMain.main(ServerMain.java:204)
> ...
> {noformat}
> This is using MySQL instead of MariaDB so this may be a non-issue with MariaDB.
> {noformat}
> [centos@airavata-db ~]$ mysql --version
> mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)