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
[email protected]
http://rubyforge.org/mailman/listinfo/backgroundrb-devel

_______________________________________________
Backgroundrb-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/backgroundrb-devel

Reply via email to