Thread: pgAgent service problem
Hi,
I met frequent situations when pgAgent service stops on windows xp, with the
folowing log:
Faulting application pgAgent.exe, version 1.6.2.99, faulting module pgAgent.exe, version 1.6.2.99,
faultaddress 0x000050fd.
Then I have to restart pgagent service and it runs well.
What is the problem ?
TIA,
Sabin
Sabin Coanda wrote: > Hi, > > I met frequent situations when pgAgent service stops on windows xp, with the > folowing log: > > Faulting application pgAgent.exe, version 1.6.2.99, > faulting module pgAgent.exe, version 1.6.2.99, > fault address 0x000050fd. > > Then I have to restart pgagent service and it runs well. > > What is the problem ? No idea, noone ever reported such a crash before. Can you supply a level 2 (debug) log from when the crash occurs? A pg_dump of your pgagent schema would help as well. Regards, Dave
... > No idea, noone ever reported such a crash before. Can you supply a level > 2 (debug) log from when the crash occurs? A pg_dump of your pgagent > schema would help as well. > > Regards, Dave Hi Dave, I just captured the significant event log sequence and I attached it. However, I found that sometimes it runs well at the same job step. The step command is the following: "C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -F p -v -U postgres -d -D -f "C:\Program Files\PostgreSQL\8.2\data\bak\dipDB_%DATE:~0,2%%DATE:~3,2%%DATE:~6,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.sql" "dbTest_local" Regards, Sabin begin 666 0703161530_pgagentEvent.zip M4$L#!!0````(`#Q\<#;P:D%#9 $``,P#```O````,#<M,#,M,38@179E;G0@ M3&]G<R\P-S S,38Q-3,P7W!G86=E;G1%=F5N="YT>'2MDEUKPC 4AJ\C^!_. MI8)DB46+!2_JQT!P>N%V)XRT/:W=:A*2=/-JOWVI'R"[&E0"(0G)\S[D'#ZF M+*!#QD+"1U' (LY)K'55IL*52L+2&&7(9>YQQOK$3XQLGF*RBV>K#7D6=>5* M68"X>Z6+N$#I*)YP`%]H;'/(Z9@.Z60R@/SVYJBRNL)_70>190:M!7;R`FS$ M\HQV._RO/AN1*XVL9*[,\2Q$-DHBN==>GC"MSPXV-:5VD)<51C"/]HOM_.UE M^</W5B2EW*^W\WB]\]M7/.J]+D0P&U/GE\%[2!/A'N+@.>D!K$,-(?2T, Y4 M#A\J@:#?(F!7(6K/I[3-5^V<]VDLO4\$00M27%6JZ1#/DO@-J9(2TW/#. 69 M<"(1UG>#LJ[PI6X1-#=XB5G,[E(B.'ATTT=3/@PI\X,#U!;-])8)62+%$:>/ M=&C*Z Y^EX&_?JEJ&^X!T\^&>X79YO-,+;N=7U!+`0(4`!0````(`#Q\<#;P M:D%#9 $``,P#```O``````````$`( `````````P-RTP,RTQ-B!%=F5N="!, M;V=S+S W,#,Q-C$U,S!?<&=A9V5N=$5V96YT+G1X=%!+!08``````0`!`%T` (``"Q`0`````` ` end
... > No idea, noone ever reported such a crash before. Can you supply a level > 2 (debug) log from when the crash occurs? A pg_dump of your pgagent > schema would help as well. > > Regards, Dave Hi Dave, I just captured the significant event log sequence and I attached it. However, I found that sometimes it runs well at the same job step. The step command is the following: "C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -F p -v -U postgres -d -D -f "C:\Program Files\PostgreSQL\8.2\data\bak\dipDB_%DATE:~0,2%%DATE:~3,2%%DATE:~6,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.sql" "dbTest_local" Regards, Sabin begin 666 0703161530_pgagentEvent.zip M4$L#!!0````(`#Q\<#;P:D%#9 $``,P#```O````,#<M,#,M,38@179E;G0@ M3&]G<R\P-S S,38Q-3,P7W!G86=E;G1%=F5N="YT>'2MDEUKPC 4AJ\C^!_. MI8)DB46+!2_JQT!P>N%V)XRT/:W=:A*2=/-JOWVI'R"[&E0"(0G)\S[D'#ZF M+*!#QD+"1U' (LY)K'55IL*52L+2&&7(9>YQQOK$3XQLGF*RBV>K#7D6=>5* M68"X>Z6+N$#I*)YP`%]H;'/(Z9@.Z60R@/SVYJBRNL)_70>190:M!7;R`FS$ M\HQV._RO/AN1*XVL9*[,\2Q$-DHBN==>GC"MSPXV-:5VD)<51C"/]HOM_.UE M^</W5B2EW*^W\WB]\]M7/.J]+D0P&U/GE\%[2!/A'N+@.>D!K$,-(?2T, Y4 M#A\J@:#?(F!7(6K/I[3-5^V<]VDLO4\$00M27%6JZ1#/DO@-J9(2TW/#. 69 M<"(1UG>#LJ[PI6X1-#=XB5G,[E(B.'ATTT=3/@PI\X,#U!;-])8)62+%$:>/ M=&C*Z Y^EX&_?JEJ&^X!T\^&>X79YO-,+;N=7U!+`0(4`!0````(`#Q\<#;P M:D%#9 $``,P#```O``````````$`( `````````P-RTP,RTQ-B!%=F5N="!, M;V=S+S W,#,Q-C$U,S!?<&=A9V5N=$5V96YT+G1X=%!+!08``````0`!`%T` (``"Q`0`````` ` end
Sabin Coanda wrote: > ... >> No idea, noone ever reported such a crash before. Can you supply a level >> 2 (debug) log from when the crash occurs? A pg_dump of your pgagent >> schema would help as well. >> >> Regards, Dave > > Hi Dave, > > I just captured the significant event log sequence and I attached it. > However, I found that sometimes it runs well at the same job step. > > The step command is the following: > "C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -F p -v -U > postgres -d -D -f "C:\Program > Files\PostgreSQL\8.2\data\bak\dipDB_%DATE:~0,2%%DATE:~3,2%%DATE:~6,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.sql" > "dbTest_local" I think I've fixed the bug - can I email you a .exe to try? Regards, Dave.
> > I think I've fixed the bug - can I email you a .exe to try? > > Regards, Dave. > Yes, please Regards, Sabin