Re: PgAgent daemon terminated itself when it was running a time-consuming job.

2018-11-19 Thread Neel Patel
Hi, On Thu, Nov 15, 2018 at 11:49 PM Eugene Wang wrote: > Hi Neel, > > Please just ignore the NOTICE messages, those were there for making sure > no table is using the same names of temporary table. Also, these messages > were issued in the first job step while the issue happened at the beginning

Re: PgAgent daemon terminated itself when it was running a time-consuming job.

2018-11-15 Thread Eugene Wang
Hi Neel, Please just ignore the NOTICE messages, those were there for making sure no table is using the same names of temporary table. Also, these messages were issued in the first job step while the issue happened at the beginning of the second job step. See below logs: Tue Nov 13 11:50:17 2018

Re: PgAgent daemon terminated itself when it was running a time-consuming job.

2018-11-14 Thread Neel Patel
Hi, >From the logs, job is executing but it looks like some schema is missing while executing job. See below logs. NOTICE: table "md_entity_raw" does not exist, skipping Tue Nov 13 11:40:58 2018 DEBUG: Sleeping... NOTICE: table "md_entity_location_raw" does not exist, skipping Is it exists ?

Re: PgAgent daemon terminated itself when it was running a time-consuming job.

2018-11-13 Thread Eugene Wang
Hi Neel and PgAdmin, Finally, I have come back on this issue now. Thank you Neel for replying. I tried to reproduce this issue in debug mode in the first time, but it then got passed. Now, in the second time, I am able to reproduce this error in DEBUG modes. Before I showed you the logs, let me br

Re: PgAgent daemon terminated itself when it was running a time-consuming job.

2018-09-06 Thread Neel Patel
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 wrote: > My environment is Ubuntu 16.04 LTS, Postgres 9.6.8 with PgAgent 4.0 > i

PgAgent daemon terminated itself when it was running a time-consuming job.

2018-09-06 Thread Eugene Wang
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 directl

PgAgent daemon terminated itself when it was running a time-consuming job.

2018-09-06 Thread Eugene Wang
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 directl