thr3ads.net - Rails - ORACLE DESC "table

If this information is useful, please help other people find it:
Share via:

karl.trout-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

2007-Mar-21 21:53 UTC

ORACLE DESC "table_name" Failure

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


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Berger, Daniel

2007-Mar-21 22:10 UTC

head link

Re: ORACLE DESC "table_name" Failure

> -----Original Message-----
> From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org 
> [mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org] On Behalf
Of
> karl.trout-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
> Sent: Wednesday, March 21, 2007 3:54 PM
> To: Ruby on Rails: Talk
> Subject: [Rails] ORACLE DESC "table_name" Failure
> 
> 
> 
> 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'' 
<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.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

karl.trout-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

2007-Mar-21 22:35 UTC

head link

Re: ORACLE DESC "table_name" Failure

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


On Mar 21, 6:10 pm, "Berger, Daniel"
<Daniel.Ber...-6vC2hAQLr78AvxtiuMwx3w@public.gmane.org>
wrote:> > -----Original Message-----
> > From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
> > [mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org] On
Behalf Of
> > karl.tr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
> > Sent: Wednesday, March 21, 2007 3:54 PM
> > To: Ruby on Rails: Talk
> > Subject: [Rails] ORACLE DESC "table_name" Failure
>
> > 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''
>
> <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.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Berger, Daniel

2007-Mar-22 16:20 UTC

head link

Re: ORACLE DESC "table_name" Failure

> -----Original Message-----
> From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org 
> [mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org] On Behalf
Of
> karl.trout-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
> Sent: Wednesday, March 21, 2007 4:36 PM
> To: Ruby on Rails: Talk
> Subject: [Rails] Re: ORACLE DESC "table_name" Failure
>
> 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.
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.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Mark

2007-Apr-16 19:04 UTC

head link

Re: ORACLE DESC "table_name" Failure

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?

On Mar 22, 12:20 pm, "Berger, Daniel"
<Daniel.Ber...-6vC2hAQLr78AvxtiuMwx3w@public.gmane.org>
wrote:> > -----Original Message-----
> > From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
> > [mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org] On
Behalf Of
> > karl.tr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
> > Sent: Wednesday, March 21, 2007 4:36 PM
> > To: Ruby on Rails: Talk
> > Subject: [Rails] Re:ORACLEDESC "table_name" Failure
>
> > 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.
>
> What version ofOracleclient 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.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Seggy Umboh

2008-Feb-12 02:24 UTC

head link

Re: ORACLE DESC "table_name" Failure

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?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Takehiro Kubo

2008-Feb-16 09:37 UTC

head link

Re: ORACLE DESC "table_name" Failure

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
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Possibly Parallel Threads

Search for more maybe matching threads

Rails - Mar 2007 - ORACLE DESC "table_name" Failure

ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Re: ORACLE DESC "table_name" Failure

Possibly Parallel Threads