AnsweredAssumed Answered

Consulta: PostgreSQL

Question asked by nalvarez_colescba on Aug 3, 2018
Latest reply on Aug 7, 2018 by nalvarez_colescba

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

Outcomes