installation question - missing file #326

gch-meoss · 2024-07-31T14:42:55Z

gch-meoss
Jul 31, 2024

Hello !

It is the first time I must deploy a georchestra instance and I have some difficulties.

my environment :
Ubuntu 22.04
Docker version : 24.0.7
Firefox version : 128.0.2

Has explained in the README I have clone the repo, switched to release 24.0 and run the docker compose without any modifications.

I open https://georchestra-127-0-1-1.traefik.me/ but i cannot login, when I click on "Connexion" nothing append...

when I click on "Catalogue", "Visualiseur", "Applications" or "Services" I have a 404 pages from nginx (1.26.1)

when I check the browser console I have this :

and obviously some errors in js console

Is this the cause of my problem? am i missing something ? in configuration ?

thanks your very much for your support

Answered by edevosc2c

Jan 9, 2025

This has been fixed. You need to use the latest docker-compose file. There is no dependency on "docker" folder name anymore.

View full answer

gch-meoss · 2024-07-31T14:49:20Z

gch-meoss
Jul 31, 2024
Author

more over container ogc-api-records-1 it restarts in a loop (org.postgresql.util.PSQLException: ERROR: column language0_.isdefault does not exist)

here are these logs :

2024-07-31 14:46:58.645  INFO 1 --- [           main] o.f.g.ogcapi.records.OgcApiRecordApp     : The following profiles are active: standalone
2024-07-31 14:47:00.540  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-07-31 14:47:01.111  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 559ms. Found 45 JPA repository interfaces.
2024-07-31 14:47:02.094  INFO 1 --- [           main] o.s.cloud.context.scope.GenericScope     : BeanFactory id=efd288dc-9d4c-3561-97d5-2023051f43cc
2024-07-31 14:47:02.772  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2024-07-31 14:47:02.788  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2024-07-31 14:47:02.789  INFO 1 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.41]
2024-07-31 14:47:02.903  INFO 1 --- [           main] o.a.c.c.C.[.[.[/ogc-api-records]         : Initializing Spring embedded WebApplicationContext
2024-07-31 14:47:02.903  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 4188 ms
2024-07-31 14:47:03.558  INFO 1 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: gn-cloud-persistent-default]
2024-07-31 14:47:03.627  INFO 1 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.27.Final
2024-07-31 14:47:03.797  INFO 1 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2024-07-31 14:47:04.048  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : ogc-api-records - Starting...
2024-07-31 14:47:04.377  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : ogc-api-records - Start completed.
2024-07-31 14:47:04.441  INFO 1 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
2024-07-31 14:47:07.465  INFO 1 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2024-07-31 14:47:07.481  INFO 1 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'gn-cloud-persistent-default'
2024-07-31 14:47:08.401  WARN 1 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2024-07-31 14:47:09.840  INFO 1 --- [           main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 2 endpoint(s) beneath base path '/actuator'
2024-07-31 14:47:10.001  WARN 1 --- [           main] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42703
2024-07-31 14:47:10.001 ERROR 1 --- [           main] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: column language0_.isdefault does not exist
  Position: 34
2024-07-31 14:47:10.011  WARN 1 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'localeResolver' defined in class path resource [org/fao/geonet/ogcapi/records/MvcConfigurer.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.LocaleResolver]: Factory method 'localeResolver' threw exception; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2024-07-31 14:47:10.018  INFO 1 --- [           main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'gn-cloud-persistent-default'
2024-07-31 14:47:10.019  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : ogc-api-records - Shutdown initiated...
2024-07-31 14:47:10.029  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : ogc-api-records - Shutdown completed.
2024-07-31 14:47:10.034  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2024-07-31 14:47:10.075  INFO 1 --- [           main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2024-07-31 14:47:10.093 ERROR 1 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'localeResolver' defined in class path resource [org/fao/geonet/ogcapi/records/MvcConfigurer.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.LocaleResolver]: Factory method 'localeResolver' threw exception; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:657) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:485) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.8.RELEASE.jar:2.3.8.RELEASE]
        at org.fao.geonet.ogcapi.records.OgcApiRecordApp.main(OgcApiRecordApp.java:27) ~[classes/:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[workspace/:na]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) ~[workspace/:na]
        at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[workspace/:na]
        at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[workspace/:na]
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.LocaleResolver]: Factory method 'localeResolver' threw exception; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:652) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        ... 28 common frames omitted
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
        at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281) ~[spring-orm-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) ~[spring-orm-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:531) ~[spring-orm-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:154) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:178) ~[spring-data-jpa-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at com.sun.proxy.$Proxy184.findAll(Unknown Source) ~[na:na]
        at org.fao.geonet.ogcapi.records.MvcConfigurer.localeResolver(MvcConfigurer.java:95) ~[classes/:na]
        at org.fao.geonet.ogcapi.records.MvcConfigurer$$EnhancerBySpringCGLIB$$ad54a8dd.CGLIB$localeResolver$2(<generated>) ~[classes/:na]
        at org.fao.geonet.ogcapi.records.MvcConfigurer$$EnhancerBySpringCGLIB$$ad54a8dd$$FastClassBySpringCGLIB$$bebde0f9.invoke(<generated>) ~[classes/:na]
        at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.fao.geonet.ogcapi.records.MvcConfigurer$$EnhancerBySpringCGLIB$$ad54a8dd.localeResolver(<generated>) ~[classes/:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        ... 29 common frames omitted
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.doQuery(Loader.java:948) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.doList(Loader.java:2832) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.Loader.list(Loader.java:2659) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.query.Query.getResultList(Query.java:165) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:355) ~[spring-data-jpa-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:78) ~[spring-data-jpa-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
        at org.springframework.data.repository.core.support.ImplementationInvocationMetadata.invoke(ImplementationInvocationMetadata.java:72) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:382) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:205) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:550) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:155) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:130) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) ~[spring-data-commons-2.3.6.RELEASE.jar:2.3.6.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        ... 47 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column language0_.isdefault does not exist
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.18.jar:42.2.18]
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) ~[postgresql-42.2.18.jar:42.2.18]
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.4.5.jar:na]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        ... 84 common frames omitted


Native Memory Tracking:

Total: reserved=248708645365, committed=3159740917
-                 Java Heap (reserved=239142436864, committed=2650800128)
                            (mmap: reserved=239142436864, committed=2650800128)

-                     Class (reserved=90484236, committed=88555020)
                            (classes #16316)
                            (  instance classes #15243, array classes #1073)
                            (malloc=2403852 #39639)
                            (mmap: reserved=88080384, committed=86151168)
                            (  Metadata:   )
                            (    reserved=88080384, committed=86151168)
                            (    used=84869400)
                            (    free=1281768)
                            (    waste=0 =0.00%)

-                    Thread (reserved=64320760, committed=2471160)
                            (thread #61)
                            (stack: reserved=64049152, committed=2199552)
                            (malloc=212184 #368)
                            (arena=59424 #108)

-                      Code (reserved=256370376, committed=38938312)
                            (malloc=2737864 #10515)
                            (mmap: reserved=253632512, committed=36200448)

-                        GC (reserved=8982498788, committed=206441956)
                            (malloc=68984292 #10750)
                            (mmap: reserved=8913514496, committed=137457664)

-                  Compiler (reserved=140589570, committed=140589570)
                            (malloc=68642 #1499)
                            (arena=140520928 #83)

-                  Internal (reserved=514214, committed=514214)
                            (malloc=481446 #1428)
                            (mmap: reserved=32768, committed=32768)

-                    Symbol (reserved=20912088, committed=20912088)
                            (malloc=18907048 #233031)
                            (arena=2005040 #1)

-    Native Memory Tracking (reserved=4912168, committed=4912168)
                            (malloc=15832 #191)
                            (tracking overhead=4896336)

-               Arena Chunk (reserved=5078400, committed=5078400)
                            (malloc=5078400)

-                   Tracing (reserved=97, committed=97)
                            (malloc=97 #5)

-                   Logging (reserved=4572, committed=4572)
                            (malloc=4572 #192)

-                 Arguments (reserved=19056, committed=19056)
                            (malloc=19056 #495)

-                    Module (reserved=273816, committed=273816)
                            (malloc=273816 #2520)

-              Synchronizer (reserved=222168, committed=222168)
                            (malloc=222168 #1839)

-                 Safepoint (reserved=8192, committed=8192)
                            (mmap: reserved=8192, committed=8192)

0 replies

f-necas · 2024-07-31T15:00:03Z

f-necas
Jul 31, 2024
Collaborator

Hi @gch-meoss !

Thanks for trying geOrchestra ! Did you clone this repo with submodules ?

For ogc-api-records it's a known issue. The image tag have to be updated to 4.2.8-0 version : geonetwork/gn-cloud-ogc-api-records-service:4.2.8-0.

0 replies

jeanmi151 · 2024-07-31T15:02:58Z

jeanmi151
Jul 31, 2024
Collaborator

yes (about the submodules ) try this command :
git submodule update --init --recursive
in the same time i am testing 24.0 branch to see if it works for me

0 replies

gch-meoss · 2024-07-31T15:04:27Z

gch-meoss
Jul 31, 2024
Author

I think yes, I used the following cmd : git clone --recurse-submodules https://github.com/georchestra/docker.git and there is content in the folder "config" and "resources/static"

0 replies

f-necas · 2024-07-31T15:09:29Z

f-necas
Jul 31, 2024
Collaborator

Did you execute git pull --recurse-submodules after switching branch ?

In default.properties file the domain name should be like : domainName=${FQDN}

0 replies

jeanmi151 · 2024-07-31T15:13:07Z

jeanmi151
Jul 31, 2024
Collaborator

You can also try directly this url : https://georchestra-127-0-1-1.traefik.me/login
also you can try to start over with : docker compose down -v && docker compose up -d

0 replies

gch-meoss · 2024-07-31T15:14:57Z

gch-meoss
Jul 31, 2024
Author

I runned the cmd with this result :

Fetching submodule config
Fetching submodule resources/static
Already up to date.

and i find domainName=${FQDN} in the default.properties file

0 replies

f-necas · 2024-07-31T15:25:20Z

f-necas
Jul 31, 2024
Collaborator

We can have a call on IRC if you want, to help you get started.

Anyway if it's not a submodule problem, we can have a look in gateway container to check if there's something wrong.

0 replies

edevosc2c · 2024-07-31T15:27:45Z

edevosc2c
Jul 31, 2024
Collaborator

Make sure the directory name is called "docker". See #214 for more info

0 replies

gch-meoss · 2024-07-31T15:32:55Z

gch-meoss
Jul 31, 2024
Author

Sure ! Thx (I just doesn't speak very well english !)

You can also try directly this url : https://georchestra-127-0-1-1.traefik.me/login also you can try to start over with : docker compose down -v && docker compose up -d

with the URL https://georchestra-127-0-1-1.traefik.me/login -> 404 !

(thx you very well for your support)

0 replies

gch-meoss · 2024-07-31T15:38:20Z

gch-meoss
Jul 31, 2024
Author

Make sure the directory name is called "docker". See #214 for more info

indeed I cloned the repo in a folder with a custom name I try this !

0 replies

gch-meoss · 2024-07-31T15:48:48Z

gch-meoss
Jul 31, 2024
Author

You are my hero! That was it! problem solved!

thanks to all, for your quick and efficient responses

0 replies

edevosc2c · 2025-01-09T10:04:10Z

edevosc2c
Jan 9, 2025
Collaborator

This has been fixed. You need to use the latest docker-compose file. There is no dependency on "docker" folder name anymore.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

installation question - missing file #326

{{title}}

Replies: 13 comments

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

installation question - missing file #326

gch-meoss Jul 31, 2024

Replies: 13 comments

gch-meoss Jul 31, 2024 Author

f-necas Jul 31, 2024 Collaborator

jeanmi151 Jul 31, 2024 Collaborator

gch-meoss Jul 31, 2024 Author

f-necas Jul 31, 2024 Collaborator

jeanmi151 Jul 31, 2024 Collaborator

gch-meoss Jul 31, 2024 Author

f-necas Jul 31, 2024 Collaborator

edevosc2c Jul 31, 2024 Collaborator

gch-meoss Jul 31, 2024 Author

gch-meoss Jul 31, 2024 Author

gch-meoss Jul 31, 2024 Author

edevosc2c Jan 9, 2025 Collaborator

gch-meoss
Jul 31, 2024

gch-meoss
Jul 31, 2024
Author

f-necas
Jul 31, 2024
Collaborator

jeanmi151
Jul 31, 2024
Collaborator

gch-meoss
Jul 31, 2024
Author

f-necas
Jul 31, 2024
Collaborator

jeanmi151
Jul 31, 2024
Collaborator

gch-meoss
Jul 31, 2024
Author

f-necas
Jul 31, 2024
Collaborator

edevosc2c
Jul 31, 2024
Collaborator

gch-meoss
Jul 31, 2024
Author

gch-meoss
Jul 31, 2024
Author

gch-meoss
Jul 31, 2024
Author

edevosc2c
Jan 9, 2025
Collaborator