Backgroundrb devel - Dec 2008 - Cant stop backgroundrb server

I just got backgroundrb today and i set it up just fine. Then I tried  
running a test method with it to see if it worked. Well now I''m  
getting an infinite number of MySQL queries and I dont know why. They  
look like this

SQL (0.000408)   BEGIN
  BdrbJobQueue Load (0.002150)   SELECT * FROM `bdrb_job_queues` WHERE  
( worker_name = ''alerts_worker'' AND taken = 0 AND scheduled_at
<=
''2008-12-22 19:47:24'' ) LIMIT 1 FOR UPDATE
  SQL (0.000272)   COMMIT

  SQL (0.000387)   BEGIN
  BdrbJobQueue Load (0.001915)   SELECT * FROM `bdrb_job_queues` WHERE  
( worker_name = ''alerts_worker'' AND taken = 0 AND scheduled_at
<=
''2008-12-22 19:47:29'' ) LIMIT 1 FOR UPDATE
  SQL (0.000242)   COMMIT

it does this every 5 seconds. I typed script/backgroundrb stop and i  
get this error

/Users/CRL00265/Documents/stratedirectory/vendor/plugins/backgroundrb/ 
lib/backgroundrb/bdrb_start_stop.rb:6:in `getpgid'': No such process  
(Errno::ESRCH)
	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:6:in `kill_process''
	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `stop''
	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `each''
	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `stop''
	from script/backgroundrb:36

I changed my backgroundrb.yml file to point away from the server, I  
deleted the method it called,  I restarted my server, nothing seems to  
stop the insanity. Can anyone give me a clue as to how I''m supposed to
go about doing this?

Dear Mark,

The loop is perfectly normal as its the way to look for the persistent  
job in your database so it could be scheduled and executed.

The error I am not quite sure about- it seems can''t find the pid.

William Yeung

On 23 Dec 2008, at 4:03 AM, Mark Capodagli wrote:
> I just got backgroundrb today and i set it up just fine. Then I  
> tried running a test method with it to see if it worked. Well now  
> I''m getting an infinite number of MySQL queries and I dont know
why.
> They look like this
>
> SQL (0.000408)   BEGIN
> BdrbJobQueue Load (0.002150)   SELECT * FROM `bdrb_job_queues` WHERE  
> ( worker_name = ''alerts_worker'' AND taken = 0 AND
scheduled_at <=
> ''2008-12-22 19:47:24'' ) LIMIT 1 FOR UPDATE
> SQL (0.000272)   COMMIT
>
> SQL (0.000387)   BEGIN
> BdrbJobQueue Load (0.001915)   SELECT * FROM `bdrb_job_queues` WHERE  
> ( worker_name = ''alerts_worker'' AND taken = 0 AND
scheduled_at <=
> ''2008-12-22 19:47:29'' ) LIMIT 1 FOR UPDATE
> SQL (0.000242)   COMMIT
>
> it does this every 5 seconds. I typed script/backgroundrb stop and i  
> get this error
>
> /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
> backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:6:in `getpgid'':
No
> such process (Errno::ESRCH)
> 	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
> backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:6:in
`kill_process''
> 	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
> backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `stop''
> 	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
> backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `each''
> 	from /Users/CRL00265/Documents/stratedirectory/vendor/plugins/ 
> backgroundrb/lib/backgroundrb/bdrb_start_stop.rb:56:in `stop''
> 	from script/backgroundrb:36
>
> I changed my backgroundrb.yml file to point away from the server, I  
> deleted the method it called,  I restarted my server, nothing seems  
> to stop the insanity. Can anyone give me a clue as to how I''m  
> supposed to go about doing this?
> _______________________________________________
> Backgroundrb-devel mailing list
> Backgroundrb-devel at rubyforge.org
> http://rubyforge.org/mailman/listinfo/backgroundrb-devel