[MASSMAIL]Cron not running

Поиск
Список
Период
Сортировка
От Lok P
Тема [MASSMAIL]Cron not running
Дата
Msg-id CAKna9VY8nbwczgD3A22wrxWmnv-0PFWP3t681zt3Fgxp237PsQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cron not running
Список pgsql-general
Hello All,
In RDS postgres(version 15.4), we have scheduled partition maintenance through pg_partman and it's scheduled through pg_cron as below. The same script has been executed in dev and test environments, and we are seeing the cron job is scheduled in both environments because we see one record in table cron.job.

But we are not seeing any entries in cron.job_run_details for the test database and also partitions are not getting created/dropped as we have expected on the test database. So it means it's not running in one of the databases. Wondering why it is so, if we are missing anything? How to debug this issue ,find the cause if it's failing internally for some reason and fix it ?

select partman.create_parent(
   p_parent_table := 'TAB1',
   p_control := 'part_col',
   p_type := 'native',
   p_interval := '1 day',
   p_premake := 5,
   p_start_partition => '2024-02-01 00:00:00'
);

update partman.part_config set infinite_time_partitions = 'true' , retention = '1 months', retention_keep_table='true', retention_keep_index='true'
where parent_table = 'TAB1';

SELECT cron.schedule('@daily',partman.run_maintenance());

Regards
Lok

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Grants and privileges issue
Следующее
От: sud
Дата:
Сообщение: Re: Grants and privileges issue