pgadmin not processing scheduled jobs

Поиск
Список
Период
Сортировка
От Robert Young
Тема pgadmin not processing scheduled jobs
Дата
Msg-id c3df65eb0810241342u5f91731aubfaf839fd8416b2b@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgadmin not processing scheduled jobs  ("Robert Young" <robbyoung21@gmail.com>)
Список pgsql-admin
I've ran the pgagent.sql script against my database.  I've started the pgagent as you can see...

  501  3107  1219   0   0:00.06 ttys000    0:00.12 pgagent -f -l 2 host=localhost dbname=mydb user=myuser

pgagent output shows...

laptop:~ ryoung$ pgagent -f -l 2 host=localhost dbname=mydb user=myuser
DEBUG: Creating primary connection
DEBUG: Creating DB connection: host=localhost dbname=mydb user=myuser
DEBUG: Database sanity check
DEBUG: Clearing zombies
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
DEBUG: Clearing inactive connections
DEBUG: Connection stats: total - 1, free - 0, deleted - 0
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
DEBUG: Clearing inactive connections
DEBUG: Connection stats: total - 1, free - 0, deleted - 0
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
DEBUG: Clearing inactive connections
........

as you can see, no jobs to run are found.

here is the pgagent.pga_job table.  Notice that the jobagentid is null as well as the joblastrun field.

mydb=# select * from pgagent.pga_job;
 jobid | jobjclid | jobname | jobdesc | jobhostagent | jobenabled |          jobcreated          |          jobchanged          | jobagentid |          jobnextrun           | joblastrun
-------+----------+---------+---------+--------------+------------+------------------------------+------------------------------+------------+-------------------------------+------------
     1 |        1 | test    |         | 127.0.0.1    | t          | 2008-10-24 11:04:40.86785-06 | 2008-10-24 11:04:40.86785-06 |            | 2008-10-24 12:56:49.378361-06 |


here is the output from the pgagent.pga_jobagent table.  As you can see, the agent is set in this table.

mydb=# select * from pgagent.pga_jobagent;
 jagpid |         jaglogintime          |       jagstation       
--------+-------------------------------+-------------------------
   3108 | 2008-10-24 12:55:26.271553-06 | laptop.movenetworks.com

pgagent.pga_schedule table output.

mydb=# select * from pgagent.pga_schedule;
 jscid | jscjobid | jscname | jscdesc | jscenabled |        jscstart        | jscend |                                                        jscminutes                                                         |                     jschours                      |   jscweekdays   |                           jscmonthdays                            |         jscmonths        
-------+----------+---------+---------+------------+------------------------+--------+---------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+-----------------+-------------------------------------------------------------------+---------------------------
     1 |        1 | 1       |         | t          | 2008-10-24 11:05:00-06 |        | {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f} | {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f} | {f,f,f,f,f,f,f} | {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f} | {f,f,f,f,f,f,f,f,f,f,f,f}
(1 row)


pgagent.pga_step table output.

mydb=# select * from pgagent.pga_jobstep;
 jstid | jstjobid | jstname |       jstdesc       | jstenabled | jstkind |                jstcode                 | jstdbname | jstonerror | jscnextrun
-------+----------+---------+---------------------+------------+---------+----------------------------------------+-----------+------------+------------
     1 |        1 | 1       | 2008-10-15 00:00:00 | t          | s       | update db_version set push_dt = now(); | mydb    | f          |

Everything looks accurate to me.  If I click on the 'run now' link in pgadmin3 it updates the date on the job table, but it still finds no jobs to run.

Any help would be appreciated.

Thanks




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

Предыдущее
От: Alexander Stanier
Дата:
Сообщение: Change in logging behaviour between 8.1 and 8.2
Следующее
От: "Robert Young"
Дата:
Сообщение: Re: pgadmin not processing scheduled jobs