topic Consulta: PostgreSQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84568#M56945 <HTML><HEAD></HEAD><BODY><P>Muy buenos dias a todos. Disculpen la miolestia, estoy viendo el log de la base de datos de alfresco (Alfresco Community 5.2) y veo que tengo alrededor de 2500 referencias al autovacuum de una tabla de <SPAN style="color: #ff0000;"><STRONG>alfresco:&nbsp;alfresco.public.alf_lock</STRONG></SPAN></P><P></P><P>A continuacion un fragmente de mi archivo de log:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>2018-07-31 20:56:51.172 -03 [19816] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 20:57:51.175 -03 [19835] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 20:58:51.160 -03 [19853] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 20:58:51.194 -03 [19853] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.03 s<BR />2018-07-31 20:59:51.188 -03 [19871] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:00:51.175 -03 [19895] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:00:51.201 -03 [19895] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:01:51.182 -03 [19928] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:01:51.207 -03 [19928] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:02:51.211 -03 [19946] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:03:51.197 -03 [19965] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:03:51.232 -03 [19965] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.03 s<BR />2018-07-31 21:04:51.226 -03 [20025] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:05:51.208 -03 [20044] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:05:51.234 -03 [20044] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:06:51.219 -03 [20064] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:06:51.244 -03 [20064] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:07:51.248 -03 [20097] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:08:51.233 -03 [20119] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:08:51.267 -03 [20119] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.03 s<BR />2018-07-31 21:09:51.262 -03 [20140] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:10:51.248 -03 [20164] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:10:51.274 -03 [20164] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:12:51.281 -03 [20202] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:12:51.303 -03 [20202] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:13:51.289 -03 [20219] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:14:51.273 -03 [20237] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:14:51.300 -03 [20237] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:15:51.303 -03 [20257] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:16:51.289 -03 [20275] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />2018-07-31 21:16:51.315 -03 [20275] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:17:51.317 -03 [20294] LOG: automatic analyze of table "alfresco.public.alf_lock" system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s<BR />2018-07-31 21:18:51.303 -03 [20312] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0<BR />&nbsp;</P></BLOCKQUOTE><P>Alguno podria orientarme de que puede estar pasando, esto lo tengo todos los días, todo el día en el log, por lo que entiendo, o intento entender, no puede nunca terminar el AV en esa tabla.&nbsp;</P><P></P><P>Desde ya muchas gracias, saludos...</P></BODY></HTML> Fri, 03 Aug 2018 12:52:46 GMT nalvarez_colesc 2018-08-03T12:52:46Z Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84568#M56945 Muy buenos dias a todos. Disculpen la miolestia, estoy viendo el log de la base de datos de alfresco (Alfresco Community 5.2) y veo que tengo alrededor de 2500 referencias al autovacuum de una tabla de alfresco:&nbsp;alfresco.public.alf_lockA continuacion un fragmente de mi archivo de log:2018-07-31 20:5 Fri, 03 Aug 2018 12:52:46 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84568#M56945 nalvarez_colesc 2018-08-03T12:52:46Z Re: Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84569#M56946 <HTML><HEAD></HEAD><BODY><P>Nadie???????</P></BODY></HTML> Tue, 07 Aug 2018 11:26:33 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84569#M56946 nalvarez_colesc 2018-08-07T11:26:33Z Re: Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84570#M56947 <HTML><HEAD></HEAD><BODY><P>Eso es simplemente un <STRONG>LOG</STRONG>&nbsp;y simplemente indica que no hay entradas en la tabla. Nada más.</P><P></P><P>¿Qué te preocupa exactamente?</P></BODY></HTML> Tue, 07 Aug 2018 12:10:48 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84570#M56947 angelborroy 2018-08-07T12:10:48Z Re: Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84571#M56948 <HTML><HEAD></HEAD><BODY><P>Hola Angel, buen dia !!!!! Me preocupa ver tantas entradas en el log, y no sabia que significaba. es normal????? No tengo que preocuparme por verla siempre en el log????</P></BODY></HTML> Tue, 07 Aug 2018 12:16:35 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84571#M56948 nalvarez_colesc 2018-08-07T12:16:35Z Re: Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84572#M56949 <HTML><HEAD></HEAD><BODY><P>Es una tabla que suele estar vacía (almacena los bloqueos de nodos y esto suele ser temporal), por lo que el hecho de que el proceso de AUTOVACUUM no haya podido vaciarla de tuplas inservibles no debería ser preocupante.</P><P></P><P>¿Has mirado alguna vez con detenimiento los logs de Alfresco Repositorio a nivel de detalle? Eso te daría para más de una noche de insomnio... <IMG src="https://connect.hyland.com/legacyfs/online/alfresco/emoticons/grin.png" /></P></BODY></HTML> Tue, 07 Aug 2018 12:23:22 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84572#M56949 angelborroy 2018-08-07T12:23:22Z Re: Consulta: PostgreSQL https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84573#M56950 <HTML><HEAD></HEAD><BODY><P>Jajajajajajajaja !!!!!!!!!!! Dios por favor NO.... Estoy recien iniciando en alfresco y con lo que tengo ya me sobra, sueño con alfresco&nbsp; &nbsp;=S&nbsp; &nbsp;Que seria de mi vida laboral sin tus respuestas Angel !!!!! Cuando venis a Argentina a dar alguna charla ????</P></BODY></HTML> Tue, 07 Aug 2018 12:26:53 GMT https://connect.hyland.com/t5/alfresco-archive/consulta-postgresql/m-p/84573#M56950 nalvarez_colesc 2018-08-07T12:26:53Z