Stone, Matthew A
2009-Mar-19 14:32 UTC
[Backgroundrb-devel] Issue starting backgroundrb server (with Oracle)
Hello All, 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. When I run ./script/backgroundrb start I get the following error: /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) 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. Also, I saw that there may be an issue with oracle adapter with a SELECT ... FOR UPDATE statement locking rows here: http://kseebaldt.blogspot.com/2007/11/synchronizing-using-active-record.html The comment points to this occurring with backgroundrb. I would appreciate any help that you all can provide. Thanks, Matt Stone -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20090319/20edf682/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 3852 bytes Desc: not available URL: <http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20090319/20edf682/attachment.bin>
Don McClean
2009-Mar-19 15:26 UTC
[Backgroundrb-devel] Issue starting backgroundrb server (with Oracle)
An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20090319/183e95c2/attachment.html> -------------- next part -------------- An embedded and charset-unspecified text was scrubbed... Name: brdb_job_queue.rb URL: <http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20090319/183e95c2/attachment.pl>