Consulta: PostgreSQL

cancel
Showing results for 
Search instead for 
Did you mean: 
nalvarez_colesc
Active Member II

Consulta: PostgreSQL

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: alfresco.public.alf_lock

A continuacion un fragmente de mi archivo de log:

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
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
2018-07-31 20:58:51.160 -03 [19853] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:00:51.175 -03 [19895] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
2018-07-31 21:01:51.182 -03 [19928] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:03:51.197 -03 [19965] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:05:51.208 -03 [20044] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
2018-07-31 21:06:51.219 -03 [20064] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:08:51.233 -03 [20119] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:10:51.248 -03 [20164] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
2018-07-31 21:12:51.281 -03 [20202] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:14:51.273 -03 [20237] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:16:51.289 -03 [20275] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
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
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
2018-07-31 21:18:51.303 -03 [20312] LOG: automatic vacuum of table "alfresco.public.alf_lock": index scans: 0
 

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. 

Desde ya muchas gracias, saludos...

5 Replies
nalvarez_colesc
Active Member II

Re: Consulta: PostgreSQL

Nadie???????

angelborroy
Alfresco Employee

Re: Consulta: PostgreSQL

Eso es simplemente un LOG y simplemente indica que no hay entradas en la tabla. Nada más.

¿Qué te preocupa exactamente?

Hyland Developer Evangelist
nalvarez_colesc
Active Member II

Re: Consulta: PostgreSQL

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????

angelborroy
Alfresco Employee

Re: Consulta: PostgreSQL

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.

¿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...

Hyland Developer Evangelist
nalvarez_colesc
Active Member II

Re: Consulta: PostgreSQL

Jajajajajajajaja !!!!!!!!!!! Dios por favor NO.... Estoy recien iniciando en alfresco y con lo que tengo ya me sobra, sueño con alfresco   =S   Que seria de mi vida laboral sin tus respuestas Angel !!!!! Cuando venis a Argentina a dar alguna charla ????