Re: PgAgent daemon terminated itself when it was running atime-consuming job.
| От | Neel Patel |
|---|---|
| Тема | Re: PgAgent daemon terminated itself when it was running atime-consuming job. |
| Дата | |
| Msg-id | CACCA4P3dZR4WLcymZ2MFPHM5ab4eYW2mm0+XM55AT1hg5DkiLQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | PgAgent daemon terminated itself when it was running a time-consuming job. (Eugene Wang <eugenewangfw@gmail.com>) |
| Ответы |
Re: PgAgent daemon terminated itself when it was running atime-consuming job.
|
| Список | pgadmin-support |
Hi,
Can you please share the pgAgent logs in debug mode ? If possible, also share the job details or screenshots so that we can reproduce at our end.
Thanks,
Neel Patel
On Thu, Sep 6, 2018 at 11:30 PM, Eugene Wang <eugenewangfw@gmail.com> wrote:
My environment is Ubuntu 16.04 LTS, Postgres 9.6.8 with PgAgent 4.0 installed and setup successfully.I tried to use a PgAgent Job to pull data from a MySQL table using FDW on a routine basis in order to keep a updated copy of the mysql table. This job has two steps. When I run those steps directly, the first one would take less than 30 mins and the second one usually takes 44 minutes. However, when I try to run it with PgAgent, my logs showed me that only the first step was finished, and PgAgent daemon was terminated during this job and it would never execute the second step.Is there a solution on this issue? If it is beyond the capability of PgAgent, what solution would help me? the system cron? I really like the feature of PgAgent that steps could be executed one by one if the previous is done, so I would hope I could just set up some configuration and get this fixed.Thank you.Yujie Wang (Welcome to call me Eugene, for your pronunciation convenience)GIS DeveloperConnected2fiber
В списке pgadmin-support по дате отправления: