Getting error "Table 'exo.JCR_SITEM' doesn't exist"

[paljitender]

While creating group in exo, I am getting beow error,

### Table 'exo.JCR_SITEM' doesn't exist

Please suggest measure to resolve this.

[paljitender]

Attaching the screen shot for the same.

[rdenarie]

Hello,
I think your screenshot was not uploaded.
Can you add the whole log file, from the server start, to the error occurence ?

[paljitender]

Hi @rdenarie

Please find below the the image

[rdenarie]

As requested,
Can you add the whole log file, from the server start, to the error occurence ?

[paljitender]

ERROR JdbcStringBasedStore ISPN008001: Failed clearing cache store
java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorysystem' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
ERROR JdbcStringBasedStore ISPN000252: Error executing parallel store task
java.util.concurrent.ExecutionException: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.purge(JdbcStringBasedStore.java:299)
at org.infinispan.persistence.manager.PersistenceManagerImpl.purgeExpired(PersistenceManagerImpl.java:373)
at org.infinispan.expiration.impl.ExpirationManagerImpl.processExpiration(ExpirationManagerImpl.java:123)
at org.infinispan.expiration.impl.ExpirationManagerImpl$ScheduledTask.run(ExpirationManagerImpl.java:231)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:290)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
... 3 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorysystem' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
... 7 more
ERROR JdbcStringBasedStore ISPN008001: Failed clearing cache store
java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorycollaboration' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
ERROR JdbcStringBasedStore ISPN000252: Error executing parallel store task
java.util.concurrent.ExecutionException: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.purge(JdbcStringBasedStore.java:299)
at org.infinispan.persistence.manager.PersistenceManagerImpl.purgeExpired(PersistenceManagerImpl.java:373)
at org.infinispan.expiration.impl.ExpirationManagerImpl.processExpiration(ExpirationManagerImpl.java:123)
at org.infinispan.expiration.impl.ExpirationManagerImpl$ScheduledTask.run(ExpirationManagerImpl.java:231)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:290)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
... 3 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorycollaboration' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
... 7 more
ERROR JdbcStringBasedStore ISPN008001: Failed clearing cache store
java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorydms_system' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
ERROR JdbcStringBasedStore ISPN000252: Error executing parallel store task
java.util.concurrent.ExecutionException: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.purge(JdbcStringBasedStore.java:299)
at org.infinispan.persistence.manager.PersistenceManagerImpl.purgeExpired(PersistenceManagerImpl.java:373)
at org.infinispan.expiration.impl.ExpirationManagerImpl.processExpiration(ExpirationManagerImpl.java:123)
at org.infinispan.expiration.impl.ExpirationManagerImpl$ScheduledTask.run(ExpirationManagerImpl.java:231)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.infinispan.persistence.spi.PersistenceException: Failed clearing string based JDBC store
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:290)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:274)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
... 3 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'exo.lk_Lrepositorydms_system' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore$1.call(JdbcStringBasedStore.java:284)
... 7 more

[rdenarie]

As requested,
Can you add the whole log file, from the server start, to the error occurence ?

[paljitender]

please find complete file

exoLogs.txt

[rdenarie]

It seems that there is a problem with you database, but as your log doesn't contains the startup part I cannot help you
Can you provide a log file containing the startup part AND the error reproduction ?

Thanks

[paljitender]

this is the log I generated after producing the logs

[paljitender]

application is running on gcp and above log is generated.

Exo is running fine.
Only while creating the group I am getting the error.

[rdenarie]

Some table are missing, but I have not the starting log, in which it should be some clue about the reason theses tables are missing.
Event if eXo runs on GCP, you must have the log of when the server is starting.
whitout that, I will not be able to help you

[paljitender]

dev-exo-logs.txt

Hi @rdenarie ,

Please find startup log that asked. Let me know your input in this.

[rdenarie]

I'm not able to read this file.
When clicking on it, I arrive on github homepage
Can you attach it in another place ?
Thanks

[NancyGuptaa]

This is the whole log file generated when we are trying to replicate the issue.
I can see the log files there are so many tables doesn't exist. So, in my perspective there is some error in MySQL.

So, do you have any suggestion how we can rectify this error.

exo.txt

[rajatjha11]

Hi @rdenarie,
we are getting these logs while creating spaces, please suggest some solution regarding same

2024-02-21 11:09:53,508 | WARN | Uncaught REST Service Exception [o.e.s.rest.impl.DefaultExceptionMapper<http-nio-0.0.0.0-8080-exec-27>]
java.lang.RuntimeException: Error while creating group for space test
at org.exoplatform.social.core.space.impl.SpaceServiceImpl.createSpace(SpaceServiceImpl.java:415)
at org.exoplatform.social.rest.impl.space.SpaceRestResourcesV1.createSpace(SpaceRestResourcesV1.java:294)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker$1.run(DefaultMethodInvoker.java:192)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:188)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:181)
at org.exoplatform.services.rest.impl.RequestDispatcher.invokeResourceMethod(RequestDispatcher.java:630)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:567)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:507)
at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:143)
at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:100)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.JSFAjaxRedirectFilter.doFilter(JSFAjaxRedirectFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:129)
at org.exoplatform.account.setup.web.AccountSetupFilter.doFilter(AccountSetupFilter.java:47)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.webconferencing.server.filter.SessionFilter.doFilter(SessionFilter.java:58)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.services.filters.sessionProvider.ThreadLocalACLSessionProviderInitializedFilter.doFilter(ThreadLocalACLSessionProviderInitializedFilter.java:45)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.oauth.filter.OAuthAbstractFilter.doFilter(OAuthAbstractFilter.java:61)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.push.filter.AuthenticationHeaderFilter.doFilter(AuthenticationHeaderFilter.java:69)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter.java:79)
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.localization.LocalizationFilter.doFilter(LocalizationFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.ConversationStateUpdateFilter.doFilter(ConversationStateUpdateFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:153)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.security.oauth.webapi.OAuthDelegateFilter.doFilter(OAuthDelegateFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.sso.integration.SSODelegateFilter.doFilter(SSODelegateFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalContainerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.portal.init.PortalCheckInitFilter.doFilter(PortalCheckInitFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.gatein.sso.integration.SSODelegateValve.invoke(SSODelegateValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.gatein.sso.agent.tomcat.ServletAccessValve.invoke(ServletAccessValve.java:55)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.exoplatform.social.core.space.SpaceException: javax.jcr.InvalidItemStateException: [collaboration] ADD NODE. Parent not found. Item []:1[]Groups:1[]spaces:1, ID: cb5b95d90a20070c4fe36ef1f7ca5fe5, ParentID: cb34dcf40a20070a45ebdfba60fefb21. Cause >>>> Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): [collaboration] ADD NODE. Parent not found. Item []:1[]Groups:1[]spaces:1, ID: cb5b95d90a20070c4fe36ef1f7ca5fe5, ParentID: cb34dcf40a20070a45ebdfba60fefb21. Cause >>>> Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID))
at org.exoplatform.social.core.space.SpaceUtils.createGroup(SpaceUtils.java:831)
at org.exoplatform.social.core.space.impl.SpaceServiceImpl.createSpace(SpaceServiceImpl.java:413)
... 94 common frames omitted
Caused by: javax.jcr.InvalidItemStateException: [collaboration] ADD NODE. Parent not found. Item []:1[]Groups:1[]spaces:1, ID: cb5b95d90a20070c4fe36ef1f7ca5fe5, ParentID: cb34dcf40a20070a45ebdfba60fefb21. Cause >>>> Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID))
at org.exoplatform.services.jcr.impl.core.SessionDataManager.commit(SessionDataManager.java:1584)
at org.exoplatform.services.jcr.impl.core.ItemImpl.save(ItemImpl.java:706)
at org.exoplatform.services.jcr.impl.core.SessionImpl.save(SessionImpl.java:1146)
at org.exoplatform.services.cms.listeners.NewGroupListener.buildGroupStructure(NewGroupListener.java:153)
at org.exoplatform.services.cms.listeners.NewGroupListener.buildGroupStructure(NewGroupListener.java:139)
at org.exoplatform.services.cms.listeners.NewGroupListener.preSave(NewGroupListener.java:75)
at org.exoplatform.services.organization.idm.GroupDAOImpl.preSave(GroupDAOImpl.java:712)
at org.exoplatform.services.organization.idm.GroupDAOImpl.addChild(GroupDAOImpl.java:118)
at org.exoplatform.services.organization.idm.cache.CacheableGroupHandlerImpl.addChild(CacheableGroupHandlerImpl.java:104)
at org.exoplatform.social.core.space.SpaceUtils.createGroup(SpaceUtils.java:826)
... 95 common frames omitted
Caused by: org.exoplatform.services.jcr.impl.storage.JCRInvalidItemStateException: [collaboration] ADD NODE. Parent not found. Item []:1[]Groups:1[]spaces:1, ID: cb5b95d90a20070c4fe36ef1f7ca5fe5, ParentID: cb34dcf40a20070a45ebdfba60fefb21. Cause >>>> Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID)): Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID))
at org.exoplatform.services.jcr.impl.storage.jdbc.SQLExceptionHandler.handleAddException(SQLExceptionHandler.java:134)
at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:795)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.add(CQJDBCStorageConnection.java:778)
at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:1200)
at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:813)
at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:421)
at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.doSave(CacheableWorkspaceDataManager.java:1147)
at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$10.run(CacheableWorkspaceDataManager.java:1090)
at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$10.run(CacheableWorkspaceDataManager.java:1087)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:1086)
at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:1050)
at org.exoplatform.services.jcr.impl.dataflow.persistent.ShareableSupportedWorkspaceDataManager.save(ShareableSupportedWorkspaceDataManager.java:176)
at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:345)
at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:280)
at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:487)
at org.exoplatform.services.jcr.impl.core.SessionDataManager.commit(SessionDataManager.java:1573)
... 104 common frames omitted
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (exo.JCR_SITEM, CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY (PARENT_ID) REFERENCES JCR_SITEM (ID))
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at jdk.internal.reflect.GeneratedMethodAccessor319.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
at jdk.proxy3/jdk.proxy3.$Proxy119.executeUpdate(Unknown Source)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.executeUpdate(CQJDBCStorageConnection.java:2080)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.SingleDbJDBCConnection.addNodeRecord(SingleDbJDBCConnection.java:286)
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.MySQLSingleDbJDBCConnection.addNodeRecord(MySQLSingleDbJDBCConnection.java:142)
at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:781)
... 119 common frames omitted

[rajatjha11]

Hi @rdenarie, this is same issue that @paljitender mentioned.
We have setup eXo on GKE(Google Kubernetes Engine) with Docker Version. Exo Community Version 6.4. We are using MySQL database.
Please find attached logs file.
exo-error-logs.txt

[rdenarie]

Hello,

Can you provide your docker-compose file ?

In addition, can you describe how the differents component are deployed on GKE ? I do not have too much knowledge about that environment.
Do you provide the docker compose to google, which start all containers ?
Did you split the docker compose for having a docker compose for database, a docker compose for exo, and so ?

Is it a fresh installation, in which the space creation always fails ? Or it is an installation which work in the past and suddently fail to create spaces ?

Thnks for precisions

[rajatjha11]

Hi @rdenarie, this is a fresh installation. I am sharing the file having deployment of eXo platform, mysql, mongo, elasticsearch & nginx which I used to deploy for eXo setup. I used the official image of eXo platform. Sometimes we are able to create spaces, users and group but sometimes not, the service is not stable.
exo-deployment-all.txt

[rajatjha11]

Hi @rdenarie, did you get chance to look into the issue ?

[rajatjha11]

Hi @rdenarie, we are getting these errors frequently

2024-03-07 07:17:52,741 | ERROR | Can't find Container with ids: 204,205 [o.e.p.m.j.service.JDBCModelStorageImpl<http-nio-0.0.0.0-8080-exec-4>]
2024-03-07 07:17:52,742 | ERROR | Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null [exo.kernel.commons.LazyList<http-nio-0.0.0.0-8080-exec-4>]
java.lang.NullPointerException: Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:598)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:578)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildPortalData(JDBCModelStorageImpl.java:950)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:298)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:293)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at java.base/java.util.AbstractList$SubList$1.next(AbstractList.java:848)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:165)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:157)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at org.exoplatform.portal.mop.navigation.NavigationStoreImpl.loadNavigations(NavigationStoreImpl.java:227)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceImpl.loadNavigations(JDBCNavigationServiceImpl.java:59)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceWrapper.loadNavigations(JDBCNavigationServiceWrapper.java:54)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNavigations(UserPortalImpl.java:233)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNodes(UserPortalImpl.java:303)
at org.exoplatform.portal.mop.rest.NavigationRest.getNavigations(NavigationRest.java:230)
at org.exoplatform.portal.mop.rest.NavigationRest.getSiteTypeNavigations(NavigationRest.java:137)
at jdk.internal.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker$1.run(DefaultMethodInvoker.java:192)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:188)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:181)
at org.exoplatform.services.rest.impl.RequestDispatcher.invokeSubResourceMethod(RequestDispatcher.java:657)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:602)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:507)
at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:143)
at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:100)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.JSFAjaxRedirectFilter.doFilter(JSFAjaxRedirectFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:129)
at org.exoplatform.account.setup.web.AccountSetupFilter.doFilter(AccountSetupFilter.java:47)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.webconferencing.server.filter.SessionFilter.doFilter(SessionFilter.java:58)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.services.filters.sessionProvider.ThreadLocalACLSessionProviderInitializedFilter.doFilter(ThreadLocalACLSessionProviderInitializedFilter.java:45)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.oauth.filter.OAuthAbstractFilter.doFilter(OAuthAbstractFilter.java:61)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.push.filter.AuthenticationHeaderFilter.doFilter(AuthenticationHeaderFilter.java:69)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter.java:79)
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.localization.LocalizationFilter.doFilter(LocalizationFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.ConversationStateUpdateFilter.doFilter(ConversationStateUpdateFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:153)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.security.oauth.webapi.OAuthDelegateFilter.doFilter(OAuthDelegateFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.sso.integration.SSODelegateFilter.doFilter(SSODelegateFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalContainerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.portal.init.PortalCheckInitFilter.doFilter(PortalCheckInitFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.gatein.sso.integration.SSODelegateValve.invoke(SSODelegateValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.gatein.sso.agent.tomcat.ServletAccessValve.invoke(ServletAccessValve.java:55)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:840)
2024-03-07 07:17:52,743 | ERROR | Cannot load resource at index 0 [exo.kernel.commons.LazyList<http-nio-0.0.0.0-8080-exec-4>]
java.lang.IllegalStateException: Cannot load resource at index 0
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:126)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at java.base/java.util.AbstractList$SubList$1.next(AbstractList.java:848)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:165)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:157)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at org.exoplatform.portal.mop.navigation.NavigationStoreImpl.loadNavigations(NavigationStoreImpl.java:227)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceImpl.loadNavigations(JDBCNavigationServiceImpl.java:59)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceWrapper.loadNavigations(JDBCNavigationServiceWrapper.java:54)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNavigations(UserPortalImpl.java:233)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNodes(UserPortalImpl.java:303)
at org.exoplatform.portal.mop.rest.NavigationRest.getNavigations(NavigationRest.java:230)
at org.exoplatform.portal.mop.rest.NavigationRest.getSiteTypeNavigations(NavigationRest.java:137)
at jdk.internal.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker$1.run(DefaultMethodInvoker.java:192)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:188)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:181)
at org.exoplatform.services.rest.impl.RequestDispatcher.invokeSubResourceMethod(RequestDispatcher.java:657)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:602)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:507)
at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:143)
at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:100)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.JSFAjaxRedirectFilter.doFilter(JSFAjaxRedirectFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:129)
at org.exoplatform.account.setup.web.AccountSetupFilter.doFilter(AccountSetupFilter.java:47)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.webconferencing.server.filter.SessionFilter.doFilter(SessionFilter.java:58)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.services.filters.sessionProvider.ThreadLocalACLSessionProviderInitializedFilter.doFilter(ThreadLocalACLSessionProviderInitializedFilter.java:45)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.oauth.filter.OAuthAbstractFilter.doFilter(OAuthAbstractFilter.java:61)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.push.filter.AuthenticationHeaderFilter.doFilter(AuthenticationHeaderFilter.java:69)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter.java:79)
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.localization.LocalizationFilter.doFilter(LocalizationFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.ConversationStateUpdateFilter.doFilter(ConversationStateUpdateFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:153)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.security.oauth.webapi.OAuthDelegateFilter.doFilter(OAuthDelegateFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.sso.integration.SSODelegateFilter.doFilter(SSODelegateFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalContainerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.portal.init.PortalCheckInitFilter.doFilter(PortalCheckInitFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.gatein.sso.integration.SSODelegateValve.invoke(SSODelegateValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.gatein.sso.agent.tomcat.ServletAccessValve.invoke(ServletAccessValve.java:55)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.lang.NullPointerException: Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:598)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:578)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildPortalData(JDBCModelStorageImpl.java:950)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:298)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:293)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
... 105 common frames omitted
2024-03-07 07:17:52,743 | ERROR | java.lang.IllegalStateException: Cannot load resource at index 0 [o.e.p.mop.navigation.NavigationStoreImpl<http-nio-0.0.0.0-8080-exec-4>]
2024-03-07 07:17:52,811 | ERROR | Can't find Container with ids: 272,271 [o.e.p.m.j.service.JDBCModelStorageImpl<http-nio-0.0.0.0-8080-exec-27>]
2024-03-07 07:17:52,814 | ERROR | Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null [exo.kernel.commons.LazyList<http-nio-0.0.0.0-8080-exec-27>]
java.lang.NullPointerException: Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:598)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:578)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildPortalData(JDBCModelStorageImpl.java:950)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:298)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:293)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at java.base/java.util.AbstractList$SubList$1.next(AbstractList.java:848)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:165)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:157)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at org.exoplatform.portal.mop.navigation.NavigationStoreImpl.loadNavigations(NavigationStoreImpl.java:227)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceImpl.loadNavigations(JDBCNavigationServiceImpl.java:59)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceWrapper.loadNavigations(JDBCNavigationServiceWrapper.java:54)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNavigations(UserPortalImpl.java:233)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNodes(UserPortalImpl.java:303)
at org.exoplatform.portal.mop.rest.NavigationRest.getNavigations(NavigationRest.java:230)
at org.exoplatform.portal.mop.rest.NavigationRest.getSiteTypeNavigations(NavigationRest.java:137)
at jdk.internal.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker$1.run(DefaultMethodInvoker.java:192)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:188)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:181)
at org.exoplatform.services.rest.impl.RequestDispatcher.invokeSubResourceMethod(RequestDispatcher.java:657)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:602)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:507)
at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:143)
at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:100)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.JSFAjaxRedirectFilter.doFilter(JSFAjaxRedirectFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:129)
at org.exoplatform.account.setup.web.AccountSetupFilter.doFilter(AccountSetupFilter.java:47)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.webconferencing.server.filter.SessionFilter.doFilter(SessionFilter.java:58)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.services.filters.sessionProvider.ThreadLocalACLSessionProviderInitializedFilter.doFilter(ThreadLocalACLSessionProviderInitializedFilter.java:45)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.oauth.filter.OAuthAbstractFilter.doFilter(OAuthAbstractFilter.java:61)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.push.filter.AuthenticationHeaderFilter.doFilter(AuthenticationHeaderFilter.java:69)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter.java:79)
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.localization.LocalizationFilter.doFilter(LocalizationFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.ConversationStateUpdateFilter.doFilter(ConversationStateUpdateFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:153)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.security.oauth.webapi.OAuthDelegateFilter.doFilter(OAuthDelegateFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.sso.integration.SSODelegateFilter.doFilter(SSODelegateFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalContainerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.portal.init.PortalCheckInitFilter.doFilter(PortalCheckInitFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.gatein.sso.integration.SSODelegateValve.invoke(SSODelegateValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.gatein.sso.agent.tomcat.ServletAccessValve.invoke(ServletAccessValve.java:55)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:840)
2024-03-07 07:17:52,815 | ERROR | Cannot load resource at index 10 [exo.kernel.commons.LazyList<http-nio-0.0.0.0-8080-exec-27>]
java.lang.IllegalStateException: Cannot load resource at index 10
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:126)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at java.base/java.util.AbstractList$SubList$1.next(AbstractList.java:848)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:165)
at org.exoplatform.portal.config.DataStorageImpl$Bilto$1.load(DataStorageImpl.java:157)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
at java.base/java.util.AbstractList$Itr.next(AbstractList.java:371)
at org.exoplatform.portal.mop.navigation.NavigationStoreImpl.loadNavigations(NavigationStoreImpl.java:227)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceImpl.loadNavigations(JDBCNavigationServiceImpl.java:59)
at org.exoplatform.portal.mop.navigation.JDBCNavigationServiceWrapper.loadNavigations(JDBCNavigationServiceWrapper.java:54)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNavigations(UserPortalImpl.java:233)
at org.exoplatform.portal.mop.user.UserPortalImpl.getNodes(UserPortalImpl.java:303)
at org.exoplatform.portal.mop.rest.NavigationRest.getNavigations(NavigationRest.java:230)
at org.exoplatform.portal.mop.rest.NavigationRest.getSiteTypeNavigations(NavigationRest.java:137)
at jdk.internal.reflect.GeneratedMethodAccessor387.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker$1.run(DefaultMethodInvoker.java:192)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:188)
at org.exoplatform.services.rest.impl.method.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:181)
at org.exoplatform.services.rest.impl.RequestDispatcher.invokeSubResourceMethod(RequestDispatcher.java:657)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:602)
at org.exoplatform.services.rest.impl.RequestDispatcher.dispatch(RequestDispatcher.java:507)
at org.exoplatform.services.rest.impl.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:143)
at org.exoplatform.services.rest.servlet.RestServlet.onService(RestServlet.java:100)
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHttpServlet.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.JSFAjaxRedirectFilter.doFilter(JSFAjaxRedirectFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:129)
at org.exoplatform.account.setup.web.AccountSetupFilter.doFilter(AccountSetupFilter.java:47)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.webconferencing.server.filter.SessionFilter.doFilter(SessionFilter.java:58)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.services.filters.sessionProvider.ThreadLocalACLSessionProviderInitializedFilter.doFilter(ThreadLocalACLSessionProviderInitializedFilter.java:45)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.oauth.filter.OAuthAbstractFilter.doFilter(OAuthAbstractFilter.java:61)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.push.filter.AuthenticationHeaderFilter.doFilter(AuthenticationHeaderFilter.java:69)
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doFilter(ExtensibleFilter.java:106)
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter.java:79)
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.rest.servlet.RestEncodingFilter.doFilter(RestEncodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.portal.application.localization.LocalizationFilter.doFilter(LocalizationFilter.java:145)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.ConversationStateUpdateFilter.doFilter(ConversationStateUpdateFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilter(SetCurrentIdentityFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:153)
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.security.oauth.webapi.OAuthDelegateFilter.doFilter(OAuthDelegateFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.sso.integration.SSODelegateFilter.doFilter(SSODelegateFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalContainerFilter.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.gatein.portal.init.PortalCheckInitFilter.doFilter(PortalCheckInitFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitializedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.gatein.sso.integration.SSODelegateValve.invoke(SSODelegateValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.gatein.sso.agent.tomcat.ServletAccessValve.invoke(ServletAccessValve.java:55)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.lang.NullPointerException: Cannot invoke "org.exoplatform.portal.jdbc.entity.ContainerEntity.getProperties()" because "srcContainer" is null
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:598)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildChildren(JDBCModelStorageImpl.java:578)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.buildPortalData(JDBCModelStorageImpl.java:950)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:298)
at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl$2.load(JDBCModelStorageImpl.java:293)
at org.exoplatform.commons.utils.LazyList.get(LazyList.java:120)
... 105 common frames omitted
2024-03-07 07:17:52,815 | ERROR | java.lang.IllegalStateException: Cannot load resource at index 10 [o.e.p.mop.navigation.NavigationStoreImpl<http-nio-0.0.0.0-8080-exec-27>]

[rdenarie]

Hi and sorry for the late reply.

In fact, few weeks ago, we started to make some R&D and run eXo on K8s, but we find some problems like the one you describe.
Sometimes, containers like DB are not reachable and it make instability in the platform.
As we are in very first steps around that, I'm not able to provide you a solution to run eXo on Kubernetes.

As far as we have a functionnal configuration, I'll notify you.

Thanks