topic Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84679#M57024 <HTML><HEAD></HEAD><BODY><P>Arquivo de Log</P><P>2017-11-16 09:52:18,968 INFO&nbsp; [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco' with user 'alfresco'.<BR />2017-11-16 09:52:19,687 INFO&nbsp; [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 9.3.6<BR />2017-11-16 09:52:29,844 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]<BR />2017-11-16 09:52:29,891 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete<BR />2017-11-16 09:52:29,906 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes<BR />2017-11-16 09:52:37,016 INFO&nbsp; [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl<BR />2017-11-16 09:52:37,016 INFO&nbsp; [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js<BR />2017-11-16 09:52:38,907 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2017-11-16 09:52:38,922 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete<BR />2017-11-16 09:52:38,985 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco, UserName=alfresco, PostgreSQL Native Driver<BR />2017-11-16 09:52:38,985 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.<BR />2017-11-16 09:52:43,506 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] No changes were made to the schema.<BR />2017-11-16 10:02:46,708 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed<BR />org.alfresco.error.AlfrescoRuntimeException: 10160000 Bootstrap failed<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:362)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:723)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.FutureTask.run(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.Thread.run(Unknown Source)<BR />Caused by: org.springframework.jdbc.UncategorizedSQLException: <BR />### Error querying database.&nbsp; Cause: org.postgresql.util.PSQLException: ERRO: missing chunk number 0 for toast value 215023 in pg_toast_2619<BR />### The error may exist in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml<BR />### The error may involve alfresco.node.select_StoreRootNodeByRef-Inline<BR />### The error occurred while setting parameters<BR />### SQL: select&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as version,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as store_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.protocol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as protocol,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.identifier&nbsp;&nbsp;&nbsp; as identifier,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.uuid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as uuid,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.type_qname_id&nbsp; as type_qname_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.locale_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as locale_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.acl_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as acl_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txn.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as txn_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txn.change_txn_id&nbsp;&nbsp; as txn_change_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_creator&nbsp; as audit_creator,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_created&nbsp; as audit_created,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_modifier as audit_modifier,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_modified as audit_modified,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_accessed&nbsp; as audit_accessed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alf_store store&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join alf_node node on (store.root_node_id = node.id)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join alf_transaction txn on (txn.id = node.transaction_id)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.protocol = ? and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.identifier = ?<BR />### Cause: org.postgresql.util.PSQLException: ERRO: missing chunk number 0 for toast value 215023 in pg_toast_2619<BR />; uncategorized SQLException for SQL []; SQL state [XX000]; error code [0]; ERRO: missing chunk number 0 for toast value 215023 in pg_toast_2619; nested exception is org.postgresql.util.PSQLException: ERRO: missing chunk number 0 for toast value 215023 in pg_toast_2619<BR />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)<BR />&nbsp;&nbsp; &nbsp;at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)<BR />&nbsp;&nbsp; &nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy6.selectOne(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectStoreRootNode(NodeDAOImpl.java:291)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$RootNodesCacheCallbackDAO.findByKey(AbstractNodeDAOImpl.java:890)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$RootNodesCacheCallbackDAO.findByKey(AbstractNodeDAOImpl.java:875)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.cache.lookup.EntityLookupCache.getByKey(EntityLookupCache.java:321)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.exists(AbstractNodeDAOImpl.java:746)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.exists(DbNodeServiceImpl.java:189)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.lock.mem.LockableAspectInterceptor.invoke(LockableAspectInterceptor.java:226)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy13.exists(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy13.exists(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:224)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy34.exists(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy13.exists(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)<BR />&nbsp;&nbsp; &nbsp;at com.sun.proxy.$Proxy13.exists(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.performBootstrap(ImporterBootstrap.java:701)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:372)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:71)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:351)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:355)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:358)<BR />&nbsp;&nbsp; &nbsp;... 24 more<BR />Caused by: org.postgresql.util.PSQLException: ERRO: missing chunk number 0 for toast value 215023 in pg_toast_2619<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)<BR />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:412)<BR />&nbsp;&nbsp; &nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)<BR />&nbsp;&nbsp; &nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.reflect.Method.invoke(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)<BR />&nbsp;&nbsp; &nbsp;... 85 more<BR />2017-11-16 10:02:51,693 WARN&nbsp; [org.springframework.web.context.support.XmlWebApplicationContext] [localhost-startStop-1] Exception thrown from ApplicationListener handling ContextClosedEvent<BR />java.lang.NullPointerException<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:58)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)<BR />&nbsp;&nbsp; &nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:185)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1049)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1010)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:586)<BR />&nbsp;&nbsp; &nbsp;at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:143)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5063)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5719)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)<BR />&nbsp;&nbsp; &nbsp;at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1877)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.FutureTask.run(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<BR />&nbsp;&nbsp; &nbsp;at java.lang.Thread.run(Unknown Source)<BR />2017-11-16 10:02:52,739 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'solrSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:52,739 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'activitiesSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:52,739 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2017-11-16 10:02:52,739 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2017-11-16 10:02:52,989 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'locksSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:52,989 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'propertyValueSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:52,989 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'auditSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:53,005 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'contentSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession<BR />2017-11-16 10:02:53,021 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]<BR />2017-11-16 10:02:53,021 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]<BR />2017-11-16 10:02:53,021 WARN&nbsp; [org.springframework.beans.factory.support.DisposableBeanAdapter] [localhost-startStop-1] Invocation of destroy method 'close' failed on bean with name 'repoSqlSessionTemplate': java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession</P></BODY></HTML> Thu, 16 Nov 2017 12:36:10 GMT rick_souza 2017-11-16T12:36:10Z Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84679#M57024 Arquivo de Log2017-11-16 09:52:18,968 INFO&nbsp; [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco' with user 'alfresco'.2017-11-16 09:52:19,687 INFO&nbsp; [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 9 Thu, 16 Nov 2017 12:36:10 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84679#M57024 rick_souza 2017-11-16T12:36:10Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84680#M57025 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Pelo que encontrei pesquisando essa mensagem de erro, o que parece ser é que o seu banco de dados se corrompeu por algum motivo. Ou seja, não é um erro DO Alfresco.</P><P>Veja:&nbsp;<A class="link-titled" href="https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/" title="https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/" rel="nofollow noopener noreferrer">PostgreSQL – Missing chunk 0 for toast value in pg_toast – The little things about databases….</A>&nbsp;</P><P></P><P>O mais seguro seria reverter um backup do ambiente íntegro antes de aparecerem tais erros.</P><P></P><P>Você fez alguma&nbsp;alteração o Alfresco?</P><P>Por acaso teve alguma falha de disco ou de energia?</P></BODY></HTML> Thu, 16 Nov 2017 16:50:22 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84680#M57025 douglascrp 2017-11-16T16:50:22Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84681#M57026 <HTML><HEAD></HEAD><BODY><P>Obrigado pela Resposta Douglas, eu tentei fazer uma configuração para editar arquivos online no Alfresco, daí eu eu achei uma tutorial pedindo para executar um script nesta pasta \Alfresco\bin\apply_amps.bat, depois disso meu alfresco nem carregava a pagina de Login. Como trabalho com maquina virtual, peguei meu backup da maquina virtual que tinha e subi novamente, aí parou de aceitar os usuarios, ele carrega a pagina para colocar usuario e senha, mas não reconhece nenhum usuario, inclusive o admin.</P></BODY></HTML> Thu, 16 Nov 2017 17:17:32 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84681#M57026 rick_souza 2017-11-16T17:17:32Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84682#M57027 <HTML><HEAD></HEAD><BODY><P>Por acaso o seu "backup da máquina virtual" era um snapshot?</P><P>Você&nbsp;criou esse backup copiando a máquina enquanto estava com o Alfresco rodando?</P><P></P><P>Minha sugestão para você é, caso não tenha informações importantes nesse servidor (ainda um teste), que você comece do zero, removendo o conteúdo e o banco de dados existentes.</P><P>Se não for possível, o ideal é usar um backup válido para restaurar.</P><P></P><P>Agora, se nenhuma das duas opções forem válidas, aí creio que você está com um problema sério nas mãos.</P></BODY></HTML> Thu, 16 Nov 2017 17:39:25 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84682#M57027 douglascrp 2017-11-16T17:39:25Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84683#M57028 <HTML><HEAD></HEAD><BODY><P>Eu faço a copia do disco virtual completo, e o banco de dados é o meu de produção. quando voce fala começar do zero seria fazer uma nova instalação do Alfresco ou só de um novo banco de dados? Eu consigo recuperar os arquivos qua estavam no antigo?</P></BODY></HTML> Thu, 16 Nov 2017 18:03:06 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84683#M57028 rick_souza 2017-11-16T18:03:06Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84684#M57029 <HTML><HEAD></HEAD><BODY><P>Sim, estou falando de uma nova instalação.</P><P>Se você não tem um backup válido para fazer um restore, então você também não tem o que é necessário para recuperar os documentos da instalação antiga.</P></BODY></HTML> Fri, 17 Nov 2017 02:06:19 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84684#M57029 douglascrp 2017-11-17T02:06:19Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84685#M57030 <HTML><HEAD></HEAD><BODY><P>Bom dia Douglas!</P><P>E se eu efetuar um backup no banco de dados da minha maquina virtual antes de ocorrer a corrupção, acha que é possivel recuperar pelo menos os arquivos?</P></BODY></HTML> Fri, 17 Nov 2017 10:43:31 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84685#M57030 rick_souza 2017-11-17T10:43:31Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84686#M57031 <HTML><HEAD></HEAD><BODY><P>Somente o backup do banco de dados não basta.</P><P>Um backup completo do Alfresco é composto de banco de dados, arquivos de conteúdo e os arquivos de configuração/addons.</P><P>Se você tem tudo isso em mãos, porque não executar um restore completo?</P></BODY></HTML> Sat, 18 Nov 2017 17:04:29 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84686#M57031 douglascrp 2017-11-18T17:04:29Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84687#M57032 <HTML><HEAD></HEAD><BODY><P>Hummm, entendi Douglas. Eu subi um backup da minha maquina virtual e o Alfresco voltou. Muito obrigado pelo tempo e pelas informações @Douglas.C.R.Paes. Gostaria de saber se esse programa de backup que voce é desenvolvedor só funciona em Linux, pois a minha versão é em windows. Se não pode me indicar um software para eu fazer backup com essa estrutura que voce disse?</P></BODY></HTML> Mon, 20 Nov 2017 11:18:59 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84687#M57032 rick_souza 2017-11-20T11:18:59Z Re: Bom dia Pessoal, meu alfresco paraou de aceitar login, incluisive dos internos, não sei mais o que fazer.... https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84688#M57033 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Se você está falando do BART, então sim.</P><P>Pode ser que funcione no Windows caso você use o Cygwin por exemplo, mas isso não foi testado, e por isso, não é suportado.</P><P></P><P>Para o Windows, você vai precisar escrever um script por conta própria, ou usar algo que alguém tenha disponibilizado.</P><P>Eu tenho isto aqui, que talvez te sirva como ponto de partipada para uma solução customizada: <A class="link-titled" href="https://gist.github.com/douglascrp/135ce592d29a0aa8ad2adc62a07b1047" title="https://gist.github.com/douglascrp/135ce592d29a0aa8ad2adc62a07b1047" rel="nofollow noopener noreferrer">A simple incremental backup script for Alfresco on Windows · GitHub</A>&nbsp;</P></BODY></HTML> Mon, 20 Nov 2017 18:46:14 GMT https://connect.hyland.com/t5/alfresco-archive/bom-dia-pessoal-meu-alfresco-paraou-de-aceitar-login-incluisive/m-p/84688#M57033 douglascrp 2017-11-20T18:46:14Z