Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Says running but no connection, restarts contastly #710

Open
riggs498 opened this issue Oct 10, 2024 · 1 comment
Open

Says running but no connection, restarts contastly #710

riggs498 opened this issue Oct 10, 2024 · 1 comment

Comments

@riggs498
Copy link

I have rockylinux8 min install. This is what I am getting.

INFO 2024-10-10 00:29:16,934 2648 [EDEXMain] LRUCacheFactory: Detected and using LRUCacheFactory: camel-caffeine-lrucache
INFO 2024-10-10 00:29:17,098 2649 [EDEXMain] log: EDEX: EDEX - Loaded Filter Patterns from configuredHandlers.xml
INFO 2024-10-10 00:29:17,532 2650 [EDEXMain] Reflections: Reflections took 221 ms to scan 280 urls, producing 41 keys and 3456 values
INFO 2024-10-10 00:29:17,595 2651 [EDEXMain] DatabaseClassAnnotationFinder: EDEX - Found 209 db classes in 303 ms
ERROR 2024-10-10 00:29:51,559 2652 [EDEXMain] SchemaManager: Error processing hibernate objects for plugin com.raytheon.uf.common.gridcoverage
com.raytheon.uf.common.dataplugin.PluginException: Error occurred exporting schema, sql [create table gridcoverage (dtype varchar(31) not null, id int4 not null, crs varchar(2047), dx float8, dy float8, firstgridpointcorner varchar(255), the_geom geometry, la1 float8, lo1 float8, name varchar(255), nx int4, ny int4, spacingunit varchar(255), latin1 float8, latin2 float8, lov float8, majoraxis float8, minoraxis float8, lad float8, la2 float8, latin float8, lo2 float8, primary key (id))]
at com.raytheon.uf.edex.database.plugin.SchemaManager.exportSchema(SchemaManager.java:446) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.plugin.SchemaManager.pluginAdded(SchemaManager.java:232) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.DatabasePluginRegistry.register(DatabasePluginRegistry.java:91) ~[com.raytheon.uf.edex.database.jar:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:648) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:633) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:113) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:702) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:505) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:196) ~[spring-context-5.3.30.jar:5.3.30]
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:748) ~[spring-context-5.3.30.jar:5.3.30]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:564) ~[spring-context-5.3.30.jar:5.3.30]
at com.raytheon.uf.edex.esb.camel.Executor.start(Executor.java:186) ~[com.raytheon.uf.edex.esb.camel.jar:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at com.raytheon.uf.edex.esb.Main.main(Main.java:143) ~[com.raytheon.uf.edex.esb.camel.launcher.jar:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60) ~[wrapperApp.jar:na]
at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43) ~[wrapperApp.jar:na]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1681) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at com.raytheon.uf.edex.database.dao.CoreDao.lambda$18(CoreDao.java:1072) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.AbstractDao$2.doInTransaction(AbstractDao.java:122) ~[com.raytheon.uf.edex.database.jar:na]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.30.jar:5.3.30]
at com.raytheon.uf.edex.database.dao.AbstractDao.supplyInTransaction(AbstractDao.java:119) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.AbstractDao.supplyInTransaction(AbstractDao.java:134) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLUpdate(CoreDao.java:1068) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLUpdate(CoreDao.java:1033) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.plugin.SchemaManager.exportSchema(SchemaManager.java:443) ~[com.raytheon.uf.edex.database.jar:na]
... 52 common frames omitted
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1509) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:298) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1672) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
... 60 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: type "geometry" does not exist
Position: 159
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.26.jar:42.2.26]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
... 64 common frames omitted
INFO 2024-10-10 00:29:51,572 2653 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredRedbook-camel) shutting down
INFO 2024-10-10 00:29:51,575 2654 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,577 2655 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredRedbook-camel) shutdown in 5ms (uptime:)
INFO 2024-10-10 00:29:51,578 2656 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (qcScan-camel) shutting down
INFO 2024-10-10 00:29:51,578 2657 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,579 2658 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (qcScan-camel) shutdown in 1ms (uptime:)
INFO 2024-10-10 00:29:51,579 2659 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (griddednucaps-camel-clustered) shutting down
INFO 2024-10-10 00:29:51,579 2660 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,580 2661 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (griddednucaps-camel-clustered) shutdown in 1ms (uptime:)
INFO 2024-10-10 00:29:51,581 2662 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredAcarsPersistObs) shutting down
INFO 2024-10-10 00:29:51,581 2663 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,581 2664 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredAcarsPersistObs) shutdown in 0ms (uptime:)
INFO 2024-10-10 00:29:51,582 2665 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredManualProc) shutting down
INFO 2024-10-10 00:29:51,582 2666 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,582 2667 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredManualProc) shutdown in 0ms (uptime:)
INFO 2024-10-10 00:29:51,583 2668 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (modelsounding-camel) shutting down
INFO 2024-10-10 00:29:51,583 2669 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,583 2670 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (modelsounding-camel) shutdown in 0ms (uptime:)
INFO 2024-10-10 00:29:51,584 2671 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredNdmProc) shutting down
INFO 2024-10-10 00:29:51,584 2672 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,584 2673 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredNdmProc) shutdown in 0ms (uptime:)
INFO 2024-10-10 00:29:51,585 2674 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (persist-camel) shutting down
INFO 2024-10-10 00:29:51,585 2675 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,586 2676 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (persist-camel) shutdown in 1ms (uptime:)
INFO 2024-10-10 00:29:51,586 2677 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredDatabaseMonitor) shutting down
INFO 2024-10-10 00:29:51,587 2678 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,587 2679 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredDatabaseMonitor) shutdown in 1ms (uptime:)
INFO 2024-10-10 00:29:51,588 2680 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (edexStats-camel) shutting down
INFO 2024-10-10 00:29:51,588 2681 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,588 2682 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (edexStats-camel) shutdown in 0ms (uptime:)
INFO 2024-10-10 00:29:51,589 2683 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredpurgeContext) shutting down
INFO 2024-10-10 00:29:51,589 2684 [EDEXMain] AbstractCamelContext: Routes stopped (total:0 stopped:0)
INFO 2024-10-10 00:29:51,589 2685 [EDEXMain] AbstractCamelContext: Apache Camel 3.14.9 (clusteredpurgeContext) shutdown in 0ms (uptime:)
ERROR 2024-10-10 00:29:51,599 2686 [EDEXMain] Main: Error occurred during startup:
java.lang.reflect.InvocationTargetException: null
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at com.raytheon.uf.edex.esb.Main.main(Main.java:143) ~[com.raytheon.uf.edex.esb.camel.launcher.jar:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60) ~[wrapperApp.jar:na]
at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43) ~[wrapperApp.jar:na]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gfeActivationAsyncIngest' defined in class path resource [res/spring/gfe-spring.xml]: Cannot resolve reference to bean 'gfeSiteActivation' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gridcoverageRegistered' defined in class path resource [res/spring/gridcoverage-common.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.Object]: Factory method 'register' threw exception; nested exception is com.raytheon.uf.common.util.registry.RegistryException: Plugin com.raytheon.uf.common.gridcoverage failed during registration
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:342) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:113) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:702) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:505) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:196) ~[spring-context-5.3.30.jar:5.3.30]
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:748) ~[spring-context-5.3.30.jar:5.3.30]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:564) ~[spring-context-5.3.30.jar:5.3.30]
at com.raytheon.uf.edex.esb.camel.Executor.start(Executor.java:186) ~[com.raytheon.uf.edex.esb.camel.jar:na]
... 11 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gridcoverageRegistered' defined in class path resource [res/spring/gridcoverage-common.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.Object]: Factory method 'register' threw exception; nested exception is com.raytheon.uf.common.util.registry.RegistryException: Plugin com.raytheon.uf.common.gridcoverage failed during registration
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:633) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330) ~[spring-beans-5.3.30.jar:5.3.30]
... 26 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.Object]: Factory method 'register' threw exception; nested exception is com.raytheon.uf.common.util.registry.RegistryException: Plugin com.raytheon.uf.common.gridcoverage failed during registration
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.30.jar:5.3.30]
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:648) ~[spring-beans-5.3.30.jar:5.3.30]
... 44 common frames omitted
Caused by: com.raytheon.uf.common.util.registry.RegistryException: Plugin com.raytheon.uf.common.gridcoverage failed during registration
at com.raytheon.uf.edex.database.DatabasePluginRegistry.register(DatabasePluginRegistry.java:94) ~[com.raytheon.uf.edex.database.jar:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.30.jar:5.3.30]
... 45 common frames omitted
Caused by: com.raytheon.uf.common.dataplugin.PluginException: com.raytheon.uf.common.dataplugin.PluginException: Error occurred exporting schema, sql [create table gridcoverage (dtype varchar(31) not null, id int4 not null, crs varchar(2047), dx float8, dy float8, firstgridpointcorner varchar(255), the_geom geometry, la1 float8, lo1 float8, name varchar(255), nx int4, ny int4, spacingunit varchar(255), latin1 float8, latin2 float8, lov float8, majoraxis float8, minoraxis float8, lad float8, la2 float8, latin float8, lo2 float8, primary key (id))]
at com.raytheon.uf.edex.database.plugin.SchemaManager.pluginAdded(SchemaManager.java:250) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.DatabasePluginRegistry.register(DatabasePluginRegistry.java:91) ~[com.raytheon.uf.edex.database.jar:na]
... 50 common frames omitted
Caused by: com.raytheon.uf.common.dataplugin.PluginException: Error occurred exporting schema, sql [create table gridcoverage (dtype varchar(31) not null, id int4 not null, crs varchar(2047), dx float8, dy float8, firstgridpointcorner varchar(255), the_geom geometry, la1 float8, lo1 float8, name varchar(255), nx int4, ny int4, spacingunit varchar(255), latin1 float8, latin2 float8, lov float8, majoraxis float8, minoraxis float8, lad float8, la2 float8, latin float8, lo2 float8, primary key (id))]
at com.raytheon.uf.edex.database.plugin.SchemaManager.exportSchema(SchemaManager.java:446) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.plugin.SchemaManager.pluginAdded(SchemaManager.java:232) ~[com.raytheon.uf.edex.database.jar:na]
... 51 common frames omitted
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1681) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at com.raytheon.uf.edex.database.dao.CoreDao.lambda$18(CoreDao.java:1072) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.AbstractDao$2.doInTransaction(AbstractDao.java:122) ~[com.raytheon.uf.edex.database.jar:na]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.30.jar:5.3.30]
at com.raytheon.uf.edex.database.dao.AbstractDao.supplyInTransaction(AbstractDao.java:119) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.AbstractDao.supplyInTransaction(AbstractDao.java:134) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLUpdate(CoreDao.java:1068) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLUpdate(CoreDao.java:1033) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.database.plugin.SchemaManager.exportSchema(SchemaManager.java:443) ~[com.raytheon.uf.edex.database.jar:na]
... 52 common frames omitted
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1509) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:298) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1672) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
... 60 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: type "geometry" does not exist
Position: 159
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.26.jar:42.2.26]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130) ~[postgresql-42.2.26.jar:42.2.26]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
... 64 common frames omitted
INFO 2024-10-10 00:29:51,599 2687 [Thread-6] Executor:


  • EDEX ESB is shutting down *

INFO 2024-10-10 00:29:51,599 2688 [Thread-6] Executor: Contexts never started, skipping context shutdown
INFO 2024-10-10 00:29:51,599 2689 [Thread-6] Executor:


  • EDEX ESB is shut down *
  • Total time to shutdown: 0ms
  • EDEX ESB uptime: 38.8s

INFO 2024-10-10 00:29:54,655 4593 [main] Main:


  • AWIPS II EDEX ESB Platform *
  • Version: 23.4.1-0.3 *
  • redhat Company *
    ------------------------------------------------
  • Build Date : 07-24-2024 *
  • Build Time : 02:42:41 UTC *
  • Build System: d4d5a0a30d08 *

INFO 2024-10-10 00:29:54,656 4594 [main] Main: EDEX_VERSION: 23.4.1
INFO 2024-10-10 00:29:54,664 4595 [EDEXMain] Executor: EDEX run configuration: ingest
INFO 2024-10-10 00:29:54,664 4596 [EDEXMain] Executor: EDEX site configuration: ILN
INFO 2024-10-10 00:29:54,830 4597 [EDEXMain] Executor:

@tiffanycmeyer13
Copy link
Contributor

tiffanycmeyer13 commented Oct 10, 2024

Can you try changing your site to OAX instead of ILN and restart EDEX to see what happens?

Also, if you could provide your install log that would be helpful (It should be in either /tmp or /awips2/dev)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants