search

Meeds-io / meeds

The Meeds Association provides its members with an employee recognition software implementation. The employee recognition software is fueled by the Meeds ERC-20 tokens.
https://meeds.io
GNU Lesser General Public License v3.0
283 stars 9 forks source link

[Migration][Psql] Error at startup after migration from 1.2.5 to 1.3.x #692

Closed rdenarie closed 1 year ago

rdenarie commented 1 year ago

Steps to reproduce

Steps to reproduce the behavior:

  1. Start a fresh install on meeds-1.2.5 wit psql database
  2. Perform a migration to meeds-1.3.4

Current behaviour There are a lot of error in logs : 2023-02-15 16:38:55,952 | ERROR | Bad value for type long : \xaced00057372002e6f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e506f72746c6574c08d96e4b5dcb1280200024c0007656e747269657374000f4c6a6176612f7574696c2f4d61703b4c0005737461746571007e00017870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00017870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000873657474696e6773737200316f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e507265666572656e6365393df6d24ea95b950200035a0008726561644f6e6c794c00046e616d657400124c6a6176612f6c616e672f537472696e673b4c000676616c7565737400104c6a6176612f7574696c2f4c6973743b78700071007e0007737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c69737471007e000a7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000017704000000017404dd7b0a202020202020202020202020202020202020226f6666736574223a20302c0a2020202020202020202020202020202020202266696c74657273223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a20226f7065726174696f6e222c0a202020202020202020202020202020202020202020202274797065223a2022455155414c222c0a202020202020202020202020202020202020202020202276616c7565537472696e67223a20226c6f67696e220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020227469746c65223a202244697374696e6374206c6f67696e73222c0a202020202020202020202020202020202020226167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d2c0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a202020202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a2020202020202020202020202020202020202278417869734167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020226d756c7469706c65436861727473223a2066616c73652c0a2020202020202020202020202020202020202279417869734167677265676174696f6e223a207b0a2020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a20202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a2020202020202020202020202020202020207d2c0a20202020202020202020202020202020202022636861727454797065223a2022626172222c0a202020202020202020202020202020202020226c696d6974223a20300a202020202020202020202020202020207d7871007e00117871007e0006 [o.h.engine.jdbc.spi.SqlExceptionHelper

] 2023-02-15 16:38:55,953 | ERROR | Error while processing transactional method. [o.e.c.p.impl.ExoTransactionalAspect
] java.lang.reflect.UndeclaredThrowableException: null at jdk.proxy3/jdk.proxy3.$Proxy117.find(Unknown Source) at org.exoplatform.commons.persistence.impl.GenericDAOJPAImpl.find(GenericDAOJPAImpl.java:66) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find_aroundBody0(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure1.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById_aroundBody10(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure11.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.cleanDeletedComponents(JDBCModelStorageImpl.java:757) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.save(JDBCModelStorageImpl.java:169) at org.exoplatform.portal.config.DataStorageImpl.save(DataStorageImpl.java:81) at org.exoplatform.portal.mop.importer.PageImporter.perform(PageImporter.java:102) at org.exoplatform.portal.config.NewPortalConfigListener.createPage(NewPortalConfigListener.java:484) at org.exoplatform.portal.config.NewPortalConfigListener.initPageDB(NewPortalConfigListener.java:412) at org.exoplatform.portal.config.NewPortalConfigListener.run(NewPortalConfigListener.java:222) at org.exoplatform.portal.config.UserPortalConfigService.start(UserPortalConfigService.java:601) at jdk.internal.reflect.GeneratedMethodAccessor241.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.container.LifecycleVisitor.traverse(LifecycleVisitor.java:103) at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:166) at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:309) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:638) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:645) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:781) at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:360) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:50) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:48) at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:291) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:48) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:37) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:772) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) Caused by: java.lang.reflect.InvocationTargetException: null at jdk.internal.reflect.GeneratedMethodAccessor280.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.commons.persistence.impl.EntityManagerHolder$ExoEntityManagerInvocationHandler.invoke(EntityManagerHolder.java:67) ... 66 common frames omitted Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3430) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3357) ... 70 common frames omitted Caused by: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:357) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:269) at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:80) at org.hibernate.loader.plan.exec.internal.EntityLoadQueryDetails$EntityLoaderRowReader.readRow(EntityLoadQueryDetails.java:288) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractRows(ResultSetProcessorImpl.java:157) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:94) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285) at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4521) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4511) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:571) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:539) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:327) at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:118) at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1226) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1215) at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:201) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2830) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2763) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3395) ... 71 common frames omitted Caused by: org.postgresql.util.PSQLException: Bad value for type long : \xaced00057372002e6f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e506f72746c6574c08d96e4b5dcb1280200024c0007656e747269657374000f4c6a6176612f7574696c2f4d61703b4c0005737461746571007e00017870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00017870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000873657474696e6773737200316f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e507265666572656e6365393df6d24ea95b950200035a0008726561644f6e6c794c00046e616d657400124c6a6176612f6c616e672f537472696e673b4c000676616c7565737400104c6a6176612f7574696c2f4c6973743b78700071007e0007737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c69737471007e000a7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000017704000000017404dd7b0a202020202020202020202020202020202020226f6666736574223a20302c0a2020202020202020202020202020202020202266696c74657273223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a20226f7065726174696f6e222c0a202020202020202020202020202020202020202020202274797065223a2022455155414c222c0a202020202020202020202020202020202020202020202276616c7565537472696e67223a20226c6f67696e220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020227469746c65223a202244697374696e6374206c6f67696e73222c0a202020202020202020202020202020202020226167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d2c0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a202020202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a2020202020202020202020202020202020202278417869734167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020226d756c7469706c65436861727473223a2066616c73652c0a2020202020202020202020202020202020202279417869734167677265676174696f6e223a207b0a2020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a20202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a2020202020202020202020202020202020207d2c0a20202020202020202020202020202020202022636861727454797065223a2022626172222c0a202020202020202020202020202020202020226c696d6974223a20300a202020202020202020202020202020207d7871007e00117871007e0006 at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:3196) at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2379) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:466) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:452) at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doExtract(BlobTypeDescriptor.java:48) at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243) at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3214) at org.hibernate.persister.entity.Loadable.hydrate(Loadable.java:94) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:342) ... 95 common frames omitted 2023-02-15 16:38:55,953 | ERROR | Error while processing transactional method. [o.e.c.p.impl.ExoTransactionalAspect
] java.lang.reflect.UndeclaredThrowableException: null at jdk.proxy3/jdk.proxy3.$Proxy117.find(Unknown Source) at org.exoplatform.commons.persistence.impl.GenericDAOJPAImpl.find(GenericDAOJPAImpl.java:66) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find_aroundBody0(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure1.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById_aroundBody10(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure11.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.cleanDeletedComponents(JDBCModelStorageImpl.java:757) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.save(JDBCModelStorageImpl.java:169) at org.exoplatform.portal.config.DataStorageImpl.save(DataStorageImpl.java:81) at org.exoplatform.portal.mop.importer.PageImporter.perform(PageImporter.java:102) at org.exoplatform.portal.config.NewPortalConfigListener.createPage(NewPortalConfigListener.java:484) at org.exoplatform.portal.config.NewPortalConfigListener.initPageDB(NewPortalConfigListener.java:412) at org.exoplatform.portal.config.NewPortalConfigListener.run(NewPortalConfigListener.java:222) at org.exoplatform.portal.config.UserPortalConfigService.start(UserPortalConfigService.java:601) at jdk.internal.reflect.GeneratedMethodAccessor241.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.container.LifecycleVisitor.traverse(LifecycleVisitor.java:103) at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:166) at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:309) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:638) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:645) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:781) at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:360) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:50) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:48) at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:291) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:48) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:37) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:772) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) Caused by: java.lang.reflect.InvocationTargetException: null at jdk.internal.reflect.GeneratedMethodAccessor280.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.commons.persistence.impl.EntityManagerHolder$ExoEntityManagerInvocationHandler.invoke(EntityManagerHolder.java:67) ... 66 common frames omitted Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3430) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3357) ... 70 common frames omitted Caused by: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:357) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:269) at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:80) at org.hibernate.loader.plan.exec.internal.EntityLoadQueryDetails$EntityLoaderRowReader.readRow(EntityLoadQueryDetails.java:288) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractRows(ResultSetProcessorImpl.java:157) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:94) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285) at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4521) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4511) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:571) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:539) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:327) at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:118) at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1226) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1215) at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:201) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2830) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2763) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3395) ... 71 common frames omitted Caused by: org.postgresql.util.PSQLException: Bad value for type long : \xaced00057372002e6f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e506f72746c6574c08d96e4b5dcb1280200024c0007656e747269657374000f4c6a6176612f7574696c2f4d61703b4c0005737461746571007e00017870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00017870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000873657474696e6773737200316f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e507265666572656e6365393df6d24ea95b950200035a0008726561644f6e6c794c00046e616d657400124c6a6176612f6c616e672f537472696e673b4c000676616c7565737400104c6a6176612f7574696c2f4c6973743b78700071007e0007737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c69737471007e000a7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000017704000000017404dd7b0a202020202020202020202020202020202020226f6666736574223a20302c0a2020202020202020202020202020202020202266696c74657273223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a20226f7065726174696f6e222c0a202020202020202020202020202020202020202020202274797065223a2022455155414c222c0a202020202020202020202020202020202020202020202276616c7565537472696e67223a20226c6f67696e220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020227469746c65223a202244697374696e6374206c6f67696e73222c0a202020202020202020202020202020202020226167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d2c0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a202020202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a2020202020202020202020202020202020202278417869734167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020226d756c7469706c65436861727473223a2066616c73652c0a2020202020202020202020202020202020202279417869734167677265676174696f6e223a207b0a2020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a20202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a2020202020202020202020202020202020207d2c0a20202020202020202020202020202020202022636861727454797065223a2022626172222c0a202020202020202020202020202020202020226c696d6974223a20300a202020202020202020202020202020207d7871007e00117871007e0006 at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:3196) at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2379) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:466) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:452) at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doExtract(BlobTypeDescriptor.java:48) at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243) at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3214) at org.hibernate.persister.entity.Loadable.hydrate(Loadable.java:94) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:342) ... 95 common frames omitted 2023-02-15 16:38:55,954 | ERROR | NewPortalConfig error: null [o.e.p.config.NewPortalConfigListener
] java.lang.reflect.UndeclaredThrowableException: null at jdk.proxy3/jdk.proxy3.$Proxy117.find(Unknown Source) at org.exoplatform.commons.persistence.impl.GenericDAOJPAImpl.find(GenericDAOJPAImpl.java:66) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find_aroundBody0(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure1.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.find(WindowDAOImpl.java:19) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById_aroundBody10(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl$AjcClosure11.run(WindowDAOImpl.java:1) at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) at org.exoplatform.commons.persistence.impl.ExoTransactionalAspect.around(ExoTransactionalAspect.java:89) at org.exoplatform.portal.mop.jdbc.dao.WindowDAOImpl.deleteById(WindowDAOImpl.java:69) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.cleanDeletedComponents(JDBCModelStorageImpl.java:757) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.save(JDBCModelStorageImpl.java:169) at org.exoplatform.portal.config.DataStorageImpl.save(DataStorageImpl.java:81) at org.exoplatform.portal.mop.importer.PageImporter.perform(PageImporter.java:102) at org.exoplatform.portal.config.NewPortalConfigListener.createPage(NewPortalConfigListener.java:484) at org.exoplatform.portal.config.NewPortalConfigListener.initPageDB(NewPortalConfigListener.java:412) at org.exoplatform.portal.config.NewPortalConfigListener.run(NewPortalConfigListener.java:222) at org.exoplatform.portal.config.UserPortalConfigService.start(UserPortalConfigService.java:601) at jdk.internal.reflect.GeneratedMethodAccessor241.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.container.LifecycleVisitor.traverse(LifecycleVisitor.java:103) at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:166) at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:309) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:638) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:645) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:781) at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:360) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:50) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:48) at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:291) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:48) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:37) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:772) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) Caused by: java.lang.reflect.InvocationTargetException: null at jdk.internal.reflect.GeneratedMethodAccessor280.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.commons.persistence.impl.EntityManagerHolder$ExoEntityManagerInvocationHandler.invoke(EntityManagerHolder.java:67) ... 66 common frames omitted Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3430) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3357) ... 70 common frames omitted Caused by: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey[org.exoplatform.portal.jdbc.entity.WindowEntity#118] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:357) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:269) at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:80) at org.hibernate.loader.plan.exec.internal.EntityLoadQueryDetails$EntityLoaderRowReader.readRow(EntityLoadQueryDetails.java:288) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractRows(ResultSetProcessorImpl.java:157) at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:94) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285) at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4521) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4511) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:571) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:539) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:327) at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:118) at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1226) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1215) at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:201) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2830) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2763) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2807) at org.hibernate.internal.SessionImpl.find(SessionImpl.java:3395) ... 71 common frames omitted Caused by: org.postgresql.util.PSQLException: Bad value for type long : \xaced00057372002e6f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e506f72746c6574c08d96e4b5dcb1280200024c0007656e747269657374000f4c6a6176612f7574696c2f4d61703b4c0005737461746571007e00017870737200256a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654d6170f1a5a8fe74f507420200014c00016d71007e00017870737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000873657474696e6773737200316f72672e65786f706c6174666f726d2e706f7274616c2e706f6d2e7370692e706f72746c65742e507265666572656e6365393df6d24ea95b950200035a0008726561644f6e6c794c00046e616d657400124c6a6176612f6c616e672f537472696e673b4c000676616c7565737400104c6a6176612f7574696c2f4c6973743b78700071007e0007737200266a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c654c697374fc0f2531b5ec8e100200014c00046c69737471007e000a7872002c6a6176612e7574696c2e436f6c6c656374696f6e7324556e6d6f6469666961626c65436f6c6c656374696f6e19420080cb5ef71e0200014c0001637400164c6a6176612f7574696c2f436f6c6c656374696f6e3b7870737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a657870000000017704000000017404dd7b0a202020202020202020202020202020202020226f6666736574223a20302c0a2020202020202020202020202020202020202266696c74657273223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a20226f7065726174696f6e222c0a202020202020202020202020202020202020202020202274797065223a2022455155414c222c0a202020202020202020202020202020202020202020202276616c7565537472696e67223a20226c6f67696e220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020227469746c65223a202244697374696e6374206c6f67696e73222c0a202020202020202020202020202020202020226167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d2c0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a202020202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a2020202020202020202020202020202020202278417869734167677265676174696f6e73223a205b0a20202020202020202020202020202020202020207b0a20202020202020202020202020202020202020202020226669656c64223a202274696d657374616d70222c0a202020202020202020202020202020202020202020202274797065223a202244415445222c0a2020202020202020202020202020202020202020202022696e74657276616c223a2022646179222c0a2020202020202020202020202020202020202020202022736f7274446972656374696f6e223a2022617363220a20202020202020202020202020202020202020207d0a2020202020202020202020202020202020205d2c0a202020202020202020202020202020202020226d756c7469706c65436861727473223a2066616c73652c0a2020202020202020202020202020202020202279417869734167677265676174696f6e223a207b0a2020202020202020202020202020202020202020226669656c64223a2022757365724964222c0a20202020202020202020202020202020202020202274797065223a202243415244494e414c495459220a2020202020202020202020202020202020207d2c0a20202020202020202020202020202020202022636861727454797065223a2022626172222c0a202020202020202020202020202020202020226c696d6974223a20300a202020202020202020202020202020207d7871007e00117871007e0006 at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:3196) at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2379) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:466) at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:452) at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doExtract(BlobTypeDescriptor.java:48) at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243) at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3214) at org.hibernate.persister.entity.Loadable.hydrate(Loadable.java:94) at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:342) ... 95 common frames omitted 2023-02-15 16:38:55,966 | ERROR | ERROR: column "customization" is of type bytea but expression is of type oid Hint: You will need to rewrite or cast the expression. Position: 192 [o.h.engine.jdbc.spi.SqlExceptionHelper
] 2023-02-15 16:38:55,967 | ERROR | NewPortalConfig error: Error while committing the transaction [o.e.p.config.NewPortalConfigListener
] javax.persistence.RollbackException: Error while committing the transaction at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:81) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104) at org.exoplatform.commons.persistence.impl.GenericDAOJPAImpl.create_aroundBody1$advice(GenericDAOJPAImpl.java:100) at org.exoplatform.commons.persistence.impl.GenericDAOJPAImpl.create(GenericDAOJPAImpl.java:1) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.saveChildren(JDBCModelStorageImpl.java:542) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.saveChildren(JDBCModelStorageImpl.java:557) at org.exoplatform.portal.mop.jdbc.service.JDBCModelStorageImpl.save(JDBCModelStorageImpl.java:171) at org.exoplatform.portal.config.DataStorageImpl.save(DataStorageImpl.java:81) at org.exoplatform.portal.mop.importer.PageImporter.perform(PageImporter.java:102) at org.exoplatform.portal.config.NewPortalConfigListener.createPage(NewPortalConfigListener.java:484) at org.exoplatform.portal.config.NewPortalConfigListener.initPageDB(NewPortalConfigListener.java:412) at org.exoplatform.portal.config.NewPortalConfigListener.run(NewPortalConfigListener.java:222) at org.exoplatform.portal.config.UserPortalConfigService.start(UserPortalConfigService.java:601) at jdk.internal.reflect.GeneratedMethodAccessor241.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.container.LifecycleVisitor.traverse(LifecycleVisitor.java:103) at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:166) at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:309) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:638) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.PortalContainer.start(PortalContainer.java:645) at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:781) at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:360) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:50) at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:48) at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:291) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:48) at org.exoplatform.platform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:37) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:772) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:65) ... 58 common frames omitted Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908) at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1402) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:493) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3285) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2420) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:449) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ... 57 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: column "customization" is of type bytea but expression is of type oid Hint: You will need to rewrite or cast the expression. Position: 192 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:134) at jdk.internal.reflect.GeneratedMethodAccessor242.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.$Proxy118.executeUpdate(Unknown Source) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ... 77 common frames omitted 2023-02-15 16:38:56,411 | INFO | The JCR will throw an exception anytime we will try to use a dead session. [exo.jcr.component.core.SessionImpl
] 2023-02-15 16:38:56,441 | INFO | Create node with alias 'eXoApplications' 'collaboration:/exo:applications' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,444 | INFO | Create node with alias 'eXoServices' 'collaboration:/exo:services' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,445 | INFO | Create node with alias 'usersPath' 'collaboration:/Users' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,446 | INFO | Create node with alias 'groupsPath' 'collaboration:/Groups' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,447 | INFO | Create node with alias 'exoECMSystemPath' 'dms-system:/exo:ecm' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,448 | INFO | Create node with alias 'exoTaxoTreesDefinitionPath' 'dms-system:/exo:ecm/exo:taxonomyTrees/definition' [e.j.c.ext.NodeHierarchyCreatorImpl
] 2023-02-15 16:38:56,449 | INFO | Create node with alias 'exoTaxoTreesStoragePath' 'dms-system:/exo:ecm/exo:taxonomyTrees/storage' [e.j.c.ext.NodeHierarchyCreatorImpl
]

srenault-meeds commented 1 year ago

Done or still in progress @rdenarie ?

rdenarie commented 1 year ago

Hello, It is fixed