Forum: Ruby on Rails ORACLE DESC "table_name" Failure

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
(Guest)
on 2007-03-21 23:57
(Received via mailing list)
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
Berger, Daniel (Guest)
on 2007-03-22 00:14
(Received via mailing list)
> 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:in `columns'

<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.
(Guest)
on 2007-03-22 00:35
(Received via mailing list)
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
Berger, Daniel (Guest)
on 2007-03-22 18:29
(Received via mailing list)
> 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.
Mark (Guest)
on 2007-04-16 23:05
(Received via mailing list)
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?
Seggy U. (Guest)
on 2008-02-12 04:24
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?
Takehiro K. (Guest)
on 2008-02-16 11:37
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
This topic is locked and can not be replied to.