程序问答   发布时间:2022-06-02  发布网站:大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了ActiveRecord :: StatementInvalid。PG错误大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。

如何解决ActiveRecord :: StatemenTinvalid。PG错误?

开发过程中遇到ActiveRecord :: StatemenTinvalid。PG错误的问题如何解决?下面主要结合日常开发的经验,给出你关于ActiveRecord :: StatemenTinvalid。PG错误的解决方法建议,希望对你解决ActiveRecord :: StatemenTinvalid。PG错误有所启发或帮助;

它所需要的只是

 task "resque:setup" => :environment do
  #ENV['QUEUE'] = '*'

  Resque.before_fork = Proc.new { ActiveRecord::Base.establish_connection }
 end

在您的resque.rake文件中

解决方法

我正在尝试从Project使用的模型中找到一个项目,Project.find(id)但这给了我ActiveRecord::StatemenTinvalid错误

全程跟踪

 PG::Error: ERROR: prepared statement "a1" already exists : SELECT COUNT(*) FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind in ('v','r') AND c.relname = $1 AND n.nspname = ANY (current_scheR_841_11845@as(false))
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:1180:in `prepare'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:1180:in `prepare_statement'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:1144:in `exec_cache'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-     3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:664:in `block in exec_query'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activesupport-3.2.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:662:in `exec_query'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/POSTGResql_adapter.rb:797:in `table_exists?'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/connection_adapters/scheR_841_11845@a_cache.rb:30:in `table_exists?'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/model_scheR_841_11845@a.rb:223:in `table_exists?'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/attribute_methods/priMary_key.rb:75:in `get_priMary_key'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/attribute_methods/priMary_key.rb:60:in `reset_priMary_key'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/attribute_methods/priMary_key.rb:49:in `priMary_key'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/model_scheR_841_11845@a.rb:230:in `block in columns'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/model_scheR_841_11845@a.rb:228:in `map'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/model_scheR_841_11845@a.rb:228:in `columns'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/model_scheR_841_11845@a.rb:237:in `columns_hash'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/relation/delegation.rb:7:in `columns_hash'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/relation/finder_methods.rb:330:in `find_one'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/relation/finder_methods.rb:311:in `find_with_ids'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/relation/finder_methods.rb:107:in `find'
/home/deploy/.rvm/gems/ruby-1.9.2-p290@submit_contactPL/gems/activerecord-3.2.2/lib/active_record/querying.rb:5:in `find'
/home/deploy/submit_contactPL/app/workers/php_worker.rb:5:in `perform'

的第5行php_worker

 project = Project.find(project_id)

可能是什么问题?您可以在上面遮一下光吗?可能的解决方案是什么

大佬总结

以上是大佬教程为你收集整理的ActiveRecord :: StatementInvalid。PG错误全部内容,希望文章能够帮你解决ActiveRecord :: StatementInvalid。PG错误所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。