Thread: BUG #7983: Problem with pgAgent.
The following bug has been logged on the website: Bug reference: 7983 Logged by: Marcelo Nunes Email address: marcelo_matheus@oi.com.br PostgreSQL version: 9.1.4 Operating system: Linux Red Hat 6 Description: = Hello, good afternoon. When trying to run a batch in pgAgent the following error occurs. DEBUG: Checking for jobs to run = DEBUG: Sleeping... sh: /tmp/pga_GvQxqM/5_9.scr: Permission denied DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... I have no idea what may be happening. The / tmp is allowed for everyone. Thanks, Marcelo Nunes
On Fri, Mar 22, 2013 at 5:12 AM, <marcelo_matheus@oi.com.br> wrote: > run a batch in pgAgent the following error occurs. > > DEBUG: Checking for jobs to run > DEBUG: Sleeping... sh: /tmp/pga_GvQxqM/5_9.scr: Permission denied > DEBUG: Clearing inactive connections > DEBUG: Connection stats: total - 1, free - 0, deleted - 0 > DEBUG: Checking for jobs to run > DEBUG: Sleeping... > > I have no idea what may be happening. The / tmp is allowed for everyone. > Isn't this bug something related with pgAdmin? You should perhaps report this bug to their dedicated ML instead: http://www.pgadmin.org/support/list.php -- Michael
On Thu, Mar 21, 2013 at 8:12 PM, <marcelo_matheus@oi.com.br> wrote: > The following bug has been logged on the website: > > Bug reference: 7983 > Logged by: Marcelo Nunes > Email address: marcelo_matheus@oi.com.br > PostgreSQL version: 9.1.4 > Operating system: Linux Red Hat 6 > Description: > > Hello, good afternoon. > > When trying to run a batch in pgAgent the following error occurs. > > DEBUG: Checking for jobs to run > DEBUG: Sleeping... sh: /tmp/pga_GvQxqM/5_9.scr: Permission denied > DEBUG: Clearing inactive connections > DEBUG: Connection stats: total - 1, free - 0, deleted - 0 > DEBUG: Checking for jobs to run > DEBUG: Sleeping... > > I have no idea what may be happening. The / tmp is allowed for everyone. Is /tmp mounted with the noexec option? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Hello, Dave. The pemiss=C3=B5es of / tmp are: [root@vmpjebdh /]# ls -ld /tmp drwxrwxrwt. 18 root root 4096 Mar 22 12:29 /tmp Thanks, Marcelo Matheus -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7= 983-Problem-with-pgAgent-tp5749215p5749296.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
On Fri, Mar 22, 2013 at 11:58 AM, Marcelo Matheus <marcelo_matheus@oi.com.br> wrote: > Hello, Dave. > > The pemiss=C3=B5es of / tmp are: > > [root@vmpjebdh /]# ls -ld /tmp > drwxrwxrwt. 18 root root 4096 Mar 22 12:29 /tmp Right, but is it mounted with noexec? Look at the output from the mount com= mand. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Good afternoon, Dave. The output of led mount brings the following about the / tmp: /dev/mapper/vg_vmpjebdh2-LogVol01 on /tmp type ext4 (rw,noexec,nosuid,nodev,noat ime) Thanks, Marcelo Matheus -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7983-Problem-with-pgAgent-tp5749215p5749308.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
Hi On Fri, Mar 22, 2013 at 2:23 PM, Marcelo Matheus <marcelo_matheus@oi.com.br> wrote: > Good afternoon, Dave. > > The output of led mount brings the following about the / tmp: > > /dev/mapper/vg_vmpjebdh2-LogVol01 on /tmp type ext4 > (rw,noexec,nosuid,nodev,noat > ime) That's likely the issue then - you need to mount /tmp without the noexec option for pgAgent to be able to work. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Good afternoon, Dave. That was it, bingo! Thank you for your help. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7983-Problem-with-pgAgent-tp5749215p5749598.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.