pgAgent Crash on WinXP

Started by Howard Coleabout 19 years ago3 messagesgeneral
Jump to latest
#1Howard Cole
howardnews@selestial.com

Hi,

I have recently started using the pgAgent and I am having some issues
with the agent service crashing.

The job that I am running has two steps:

1. A vacuum.

2. Backup, which executes the following
"c:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p
5432 -U postgres -F p -b -v --encoding=SQL_ASCII -f
"d:\hq\backup\daily.backup" "hq"

Both steps appear to work, and the backup is created, and according to
pgAdminIII, both steps are complete. However the status of the overall
job is still "Running" according to pgAdmin, and the service has crashed.

This is the error that I get in the application log:

Faulting application pgAgent.exe, version 1.6.2.99, faulting module
pgAgent.exe, version 1.6.2.99, fault address 0x000050fd.

Any Ideas?

#2Dave Page
dpage@pgadmin.org
In reply to: Howard Cole (#1)
Re: pgAgent Crash on WinXP

Howard Cole wrote:

Hi,

I have recently started using the pgAgent and I am having some issues
with the agent service crashing.

The job that I am running has two steps:

1. A vacuum.

2. Backup, which executes the following
"c:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p
5432 -U postgres -F p -b -v --encoding=SQL_ASCII -f
"d:\hq\backup\daily.backup" "hq"

Both steps appear to work, and the backup is created, and according to
pgAdminIII, both steps are complete. However the status of the overall
job is still "Running" according to pgAdmin, and the service has crashed.

This is the error that I get in the application log:

Faulting application pgAgent.exe, version 1.6.2.99, faulting module
pgAgent.exe, version 1.6.2.99, fault address 0x000050fd.

Please try v1.6.3 - there was a bug fixed that might well cause this crash.

Regards, Dave.

#3Howard Cole
howardnews@selestial.com
In reply to: Dave Page (#2)
Re: pgAgent Crash on WinXP

Dave Page wrote:

Please try v1.6.3 - there was a bug fixed that might well cause this
crash.

Regards, Dave.

Thanks Dave. I think that has fixed it.