The mailing list for listmasters using Sympa

[Gonzalo Palacios Goicolea <address@concealed>]

Hi All,

After upgrading sympa from 6.2.16 to 6.2.52 we've noticed that the use of database is bigger. It seems that the origin are the tasks that manage the inclusion of subscribers from local files (include_file). Every time one of this tasks is run, the field "inclusion_ext_subscriber" on subscriber_table is updated for all the list subscribers. Before upgrading I think these tasks were done on a file, but now it's updated to the database. My question is, how can I manage the time interval between each update?

Now every list is updated on a non-regular basis, but about every 15-25 minutes:

Jan 28 03:48:48 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 04:05:49 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 04:26:11 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 04:46:19 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 05:07:19 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 05:34:23 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 05:54:25 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 06:14:24 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 06:34:44 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 06:57:44 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 07:15:01 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 07:35:39 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 07:43:18 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 08:01:34 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 08:25:30 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 08:54:51 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 09:05:43 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 09:29:47 listas4 task_manager[2821]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>
Jan 28 09:49:13 listas2 task_manager[2832]: notice Sympa::Spindle::ProcessRequest::_twist() Processing Sympa::Request <action="include;address@concealed;role=member>

Thanks and best regards

--
Gonzalo Palacios Goicolea
U.T de Infraestructura de Equipos Centrales
Tecnologías de la Información
Universidad Autónoma de Madrid • Campus de Cantoblanco