ORACLE DESC "table_name" Failure

Rails
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:incolumns’
/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:incolumn_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:inall_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:ineach’
/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:inall_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:inlist’
/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:inperform_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:inperform_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:inmeasure’
/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:inperform_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:inprocess_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:inprocess’
/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:indispatch’
/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:insynchronize’
/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:inprocess_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:inprocess_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:ininitialize’
/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:inrun’
/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:innew’
/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:inrun’
/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:inrun’
/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:inrun’
/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:inload’
/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:inload’
/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:inrequire’
/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:innew_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:ingem_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

I am getting “DESC CYCLEMSTR” failed; does it exist?
/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:incolumns’

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

is on a new load
cycle_desc varchar2(50) y
any ideas are helpful.
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

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?

6

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?

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