<HTML>
<HEAD>
<TITLE>Issue starting backgroundrb server (with Oracle)</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hello All,<BR>
<BR>
I’ve recently started trying to use backgroundrb and I’m running into an issue with starting the server. I’m running OSX (leopard) and rails 2.0.2 with an oracle database. <BR>
When I run ./script/backgroundrb start I get the following error: <BR>
/Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log': OCIError: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM event_tracking.bdrb_job_queues WHERE ( worker_name = 'upload_invitees_worker' AND taken = 0 AND scheduled_at <= '2009-03-19 13:38:04' ) ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 FOR UPDATE (ActiveRecord::StatementInvalid)<BR>
<BR>
I’ve read in a few places that when using Oracle it may be a good idea to remove the lines that say allow_concurrency = true, and I’ve done that.<BR>
<BR>
Also, I saw that there may be an issue with oracle adapter with a SELECT ... FOR UPDATE statement locking rows here: <a href="http://kseebaldt.blogspot.com/2007/11/synchronizing-using-active-record.html">http://kseebaldt.blogspot.com/2007/11/synchronizing-using-active-record.html</a> The comment points to this occurring with backgroundrb.<BR>
<BR>
I would appreciate any help that you all can provide.<BR>
<BR>
Thanks,<BR>
Matt Stone</SPAN></FONT>
</BODY>
</HTML>