[AIRAVATA-2401] App Catalog database mappings synchronization failure: Invalid default value for 'UPDATE_TIME'

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.18
• Component/s: Application Catalog
• Assignee: Supun Nakandala
• Reporter: Marcus Christie
• Created: 25/May/17 14:03
• Updated: 06/Jun/17 19:14
• Resolved: 06/Jun/17 19:14

Description

Stack trace:

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

This is using MySQL instead of MariaDB so this may be a non-issue with MariaDB.

[centos@airavata-db ~]$ mysql --version
mysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using  EditLine wrapper