[chef] Re: Re: Rails db:migrate fails via knife, succeeds when run directly

[Toby Johnson < >]

Thanks Vladimir; my apologies, I meant to mention that Ruby is installed with rbenv, but using a "global" setup at /opt/rbenv and not in a home directory.

I am setting up RAILS_ENV to production using the "environment" command in the deploy_revision resource.

My database.yml is a symlink to the "shared" one at /var/www/shared/config/database.yml. That file has restrictive permissions (owner root:nginx with ug+r; or 0440), while all directories from /var/www below have owner root:nginx and permissions u+rwx,g+rx; or 0750).

One point of confusion I have, is which user actually runs the "rake db:migrate" command? I didn't see anywhere to set this using the deploy cookbook.

On Mon, Feb 17, 2014 at 11:20 PM, Vladimir Skubriev < " target="_blank"> > wrote:

This is permission issue.

Or may be environment variables do not setup correctly.

I don't know application cookbook. But I has a question: where is the ruby installed with it (in home or system ruby)?

2014-02-18 6:51 GMT+04:00 Toby Johnson < " target="_blank"> >:

I'm using the deploy cookbook to deploy a Rails app (nginx + passenger). I'm running "bundle exec rake db:migrate --trace" during the migration step, after the database is created. Many times this step will fail with:

ERROR: deploy_revision[/var/www] (_site::deploy line 39) had an error: Chef::Exceptions::Exec: bundle exec rake db:migrate --trace returned 1, expected 0

It is very frustrating because it will sometimes succeed but often will fail. It seems like more often, when I run via knife ssh ("knife ssh 'fqdn:xxx*' 'sudo chef-client'), it will fail at the above step, then I ssh into the actual box, start a shell as root ("sudo su -") then run chef-client and it will succeed.

I see that the unix error code "1" means a permissions issue; is that what I'm facing here or is rake (er, bundle I guess) just using this as a generic error return code? Any way I can get a more specific reason as to why the migrate is failing?

The chef-stacktrace.out file doesn't give any more specific info about the actual db:migrate failure.

--

Faithfully yours,

CVision Lab System Administrator

Vladmir Skubriev