ORACLE DESC "table_name" Failure

rubyonrails-talk
1

I am getting "DESC CYCLEMSTR" failed; does it exist? errors on a table named CYCLEMSTR in Oracle every 3 out of 4 trys to do a simple find(:all) on the table. It is a legacy table that only contains 12 rows of join information.

I don't understand why it works one out of every 4 or 5 times help please.

trace:

(eval):3:in `describe' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/connection_adapters/oracle_adapter.rb:316:in `columns' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:763:in `columns' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:776:in `column_names' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:789:in `column_methods_hash' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:1263:in `all_attributes_exists?' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/inflector.rb:250:in `all?' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:1263:in `each' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:1263:in `all?' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:1263:in `all_attributes_exists?' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/ active_record/base.rb:1197:in `method_missing' app/controllers/periods_controller.rb:13:in `list' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/base.rb:1095:in `send' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/base.rb:1095:in `perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/filters.rb:632:in `call_filter' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/filters.rb:619:in `perform_action_without_benchmark' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/rescue.rb:83:in `perform_action' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/base.rb:430:in `send' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/base.rb:430:in `process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/filters.rb:624:in `process_without_session_management_support' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/session_management.rb:114:in `process' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.13.2/lib/ action_controller/base.rb:330:in `process' /usr/local/lib/ruby/gems/1.8/gems/rails-1.2.2/lib/dispatcher.rb:41:in `dispatch' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb: 78:in `process' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb: 76:in `synchronize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb: 76:in `process' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:618:in `process_client' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `each' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `process_client' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `initialize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `new' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `initialize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `new' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/ configurator.rb:271:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/ configurator.rb:270:in `each' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/ configurator.rb:270:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails: 127:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb: 211:in `run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:243 /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:488:in `load' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:488:in `load' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:342:in `new_constants_in' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:488:in `load' /usr/local/lib/ruby/gems/1.8/gems/rails-1.2.2/lib/commands/servers/ mongrel.rb:60 /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:495:in `require' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:342:in `new_constants_in' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.1/lib/ active_support/dependencies.rb:495:in `require' /usr/local/lib/ruby/gems/1.8/gems/rails-1.2.2/lib/commands/server.rb: 39 /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' script/server:3

This is driving me mad. -trout

2

<snip>

Hm, let's start here. Can you provide us some more information?

What version of Rails? What version of ruby-oci8? (if you happen to know) What version of Oracle? What platform are you calling from? Can you paste the results of a "DESC CYCLEMSTR" from sqlplus? If not, can you at least tell us if there are any unusual column types in the table?

Regards,

Dan

This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.

3

Thanks dan everything is on a new load

RUBY 1.8.5 (i686-linux Rails 1.2.2 OCI8 ruby-oci8-1.0.0-rc1 hmmm...

CYCLEMSTR does exist and returns data every 1/5 times I refresh the page. heres the structure

cycle_id varchar2(32) dm_id varchar2(32) cycle_desc varchar2(50) y start_date date y end_date date y

It seems that when I actually hit the database for a set of rows (from a different table) that I get a better response i.e. 1/5 times it fails.

this table is used to populate the form select drop down for which cycle to query for in another table.

any ideas are helpful.

-Trout

4

What version of Oracle client and server?

At this point I think I would try setting up a standalone ActiveRecord code snippet and see how that runs:

require 'rubygems' require 'active_record'

ActiveRecord::Base.establish_connection(    :adapter => "oracle",    :database => "your_db",    :username => "your_username",    :password => "your_password" )

class Cyclemstr < ActiveRecord::Base    set_table_name :cyclemstr    set_primary_key "cyclemstr_id" # If it's not just "id" end

Then try your query and see what happens:

Cyclemstr.find(:all, :conditions => [your_conditions_here])

Regards,

Dan

This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.

5

I get this error as well. It happens to me when I have allow_concurrency set to true. has anyone seen this or seen a fix for this?

6

Yes it happens to me too when I use ferret_server or backgroundrb, both of which use allow_concurrency = true!

I just narrowed it down to this line a few minutes ago, and a search on ruby-oci8 found this thread. Man if only I'd found this thread before, would've saved a couple weeks of mystery!

Any solution to this? Or just have to turn off allow_concurrency?

7

Seggy Umboh wrote:

Yes it happens to me too when I use ferret_server or backgroundrb, both of which use allow_concurrency = true!

I just narrowed it down to this line a few minutes ago, and a search on ruby-oci8 found this thread. Man if only I'd found this thread before, would've saved a couple weeks of mystery!

Any solution to this? Or just have to turn off allow_concurrency?

http://dev.rubyonrails.org/ticket/11134