Re: Time series aggregation

Hi Dave,

I use to shutdown the postgresql server by stopping the service, followed by that pgAgent server is automatically
stopped. 

However I am getting the following error message in service logger, while shutdown server.

Postgresql Service error message

The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found. The local computer may not have the
necessaryregistry information or message DLL files to display messages from a remote computer. You may be able to use
the/AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part
ofthe event: FATAL:  terminating connection due to administrator command 

Pgadmin error message

Failed to query jobs table!

The PostgreSQL Scheduling Agent - pgAgent service terminated unexpectedly.  It has done this 7 time(s).

It looks like pgAgent is not properly shutdown as you said.

Would you please help me how do I resolve this issue.

Thanks & Regards,
Ramkumar


-----Original Message-----
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Wednesday, June 27, 2012 9:44 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Time series aggregation

On Wed, Jun 27, 2012 at 11:44 AM, Yelai, Ramkumar IN BLR STS <ramkumar.yelai@siemens.com> wrote:
> Thanks Dave.
>
> I have reset the pgagent.pga_job.jobnextrun when server restarts, however it will be reset by pgAgent, when it
starts.
>
> Following are the steps, I have done.
>
> 1. Around 2:45 PM, I have stopped the server 2. I have started the
> server at 4:03 PM and I reset the jobnextrun ( from pgAdmin UI ) to 3:00PM.
> 3. Soon I started the pgAgent at 4:04PM, the jobnextrun is changed to 4:04 PM and it run once.
>
> Here, I lost the 2:00 PM to 3:00 PM aggregation.

The only way I can see for that to happen is if the agent is killed whilst the job is being processed. That will cause
thejob's nextrun time to be reset during zombie clearance when the agent restarts. In the normal case, the job will be
runas soon as the agent enters the main processing loop, where it will select all jobs with nextrun <= 
now() and process them immediately.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company