airavata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus Christie (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRAVATA-2401) App Catalog database mappings synchronization failure: Invalid default value for 'UPDATE_TIME'
Date Tue, 06 Jun 2017 19:13:18 GMT

    [ https://issues.apache.org/jira/browse/AIRAVATA-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16039480#comment-16039480
] 

Marcus Christie commented on AIRAVATA-2401:
-------------------------------------------

I worked around this by doing the following
{noformat}
MySQL [master_app_catalog]> alter table APPLICATION_DEPLOYMENT MODIFY COLUMN UPDATE_TIME
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ;
MySQL [master_app_catalog]> alter table COMPUTE_RESOURCE MODIFY COLUMN UPDATE_TIME TIMESTAMP
NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ;
{noformat}

> 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)

Mime
View raw message