部署后老是出错，错误信息如下：
Started GET "/admin/buildings" for 112.234.125.127 at 2012-09-01 09:24:47 +0000
Processing by Admin::BuildingsController#index as HTML
Completed 500 Internal Server Error in 1ms
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_schemas(false))
):
app/controllers/admin/buildings_controller.rb:5:in `index'
网上搜的好像根本搜不到。时不时的会出现这种错误。看似和数据库有关，但是又不想更换数据库。希望各位给个解决方案。
#2 楼 @pongyo 里面提到的方案正解！我稍后整理一下。终于解决了。
WU Jun 5 months ago
A simple note:
pg gem uses prepare statement in production env by default, which is different from MySQL.
This can be an issue if you are using unicorn. You may got PGError: ERROR: prepared statement "a3" already exists after several requests.
To solve this, make sure each unicorn process uses its own database connection by adding this to unicorn config file:
===================================
after_fork do |server, worker|
ActiveRecord::Base.establish_connection
end
===================================
Hope this helps :)
