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:04:04 UTC
[jira] [Created] (AIRAVATA-2401) App Catalog database mappings
synchronization failure: Invalid default value for 'UPDATE_TIME'
Marcus Christie created AIRAVATA-2401:
-----------------------------------------
Summary: 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)