ruby-on-rails - 突然在 UsersController#create 中得到 Errno::ECONNREFUSED

Question

我无法再将数据保存到我的数据库并得到 Errno::ECONNREFUSED in UsersController#create和 Connection refused - connect(2) .这是在我重新启动我的 Mac 之后，但之前已经重新启动没有问题。它看起来是应用程序和数据库之间的连接错误，但我不知道如何修复它。

数据库.yml

development:
  adapter: postgresql
  encoding: unicode
  database: store_development
  pool: 5
  username: name
  password:

创建 Action

  def create
    @user = User.new(user_params)
    if @user.save
      sign_in @user
      UserMailer.signup_confirmation(@user).deliver
        redirect_to root_url, :flash => {notice: "Welcome" }
    else
        render 'new'
    end
  end

它在 user.save 行失败，这让我相信这是一个连接错误。

日志文件

Started POST "/users" for 127.0.0.1 at 2013-12-18 15:23:13 -0500
Processing by UsersController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"ZVHiD1fD/wYiTU8zg80BzGih8+VLPyOzPr16Himrv5M=", "user"=>{"name"=>"test", "email"=>"test@example.com", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]"}, "commit"=>"Create my account"}
  [1m[35m (0.3ms)[0m  BEGIN
  [1m[36mUser Exists (0.3ms)[0m  [1mSELECT 1 AS one FROM "users" WHERE LOWER("users"."email") = LOWER('test@example.com') LIMIT 1[0m
  [1m[35mSQL (0.5ms)[0m  INSERT INTO "users" ("created_at", "email", "name", "password_digest", "remember_token", "updated_at") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"  [["created_at", Wed, 18 Dec 2013 20:23:13 UTC +00:00], ["email", "test@example.com"], ["name", "test"], ["password_digest", "$2a$10$G03yjEWWIsDJMHGOyDEOp.ACJnYGLXBEfHH0upJYTjeXlNxg6OK/i"], ["remember_token", "a622fb4b8a79d61fb3e7201d00658a3364882f36"], ["updated_at", Wed, 18 Dec 2013 20:23:13 UTC +00:00]]
  [1m[36m (0.2ms)[0m  [1mROLLBACK[0m
Completed 500 Internal Server Error in 73ms

Errno::ECONNREFUSED (Connection refused - connect(2)):
  app/controllers/users_controller.rb:34:in `create'

我可以轻松进入 store_development 数据库，我已经通过运行启动了服务器

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

如果我运行停止命令，这就是我得到的:

pg_ctl -D /usr/local/var/postgres stop -s -m fast
pg_ctl: server does not shut down

编辑附加信息:我的应用程序可以访问当前存在的所有数据。我无法将新数据写入数据库。我无法创建或更新返回连接被拒绝错误的属性。

Answer 1

我发现了问题。

系统重启后，我没有再次启动 ElasticSearch。连接被拒绝是因为无法运行 ElasticSearch 服务器，而不是我的 Postgres 服务器。