Issues when starting as service, crash if started from command line after some hours

Support
#1

Every once and awhile, after >12 hours, I have to restart Foreman
because it doesn't work anymore
(We're sorry, but something went wrong.)

Another problem: I can start from the CLI, but I receive the above
error page immediately if I try to use the service script.

Versions
rubygem-rails-2.1.1-2.el5
foreman-0.1.6-2

#2

can you find out the error message from /var/log/foreman/production.log?

btw: rubygem-rails package is not required (and it is very old).

Ohad

··· On Mon, Nov 22, 2010 at 9:46 AM, PieterB wrote:

Every once and awhile, after >12 hours, I have to restart Foreman
because it doesn’t work anymore
(We’re sorry, but something went wrong.)

Another problem: I can start from the CLI, but I receive the above
error page immediately if I try to use the service script.

Versions
rubygem-rails-2.1.1-2.el5
foreman-0.1.6-2

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.comforeman-users%2Bunsubscribe@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

#3

First, I thought it had something to do with SQLite because I've some
locking issues. Maybe mysql or postrges is better for ~ 60 hosts :slight_smile:
==> SQLite3::SQLException: unable to open database file:

Or is it the (old) Ruby version on RH5?

But why does it fail every time i try to use the init script…

This error maybe helps?

Completed in 416ms (View: 360, DB: 24) | 200 OK [http://…/]
/!\ FAILSAFE /!\ Tue Nov 23 14:56:21 +0100 2010
Status: 500 Internal Server Error
SQLite3::SQLException: unable to open database file: UPDATE
"sessions" SET "data" =
'BAh7CjoUbGFzdF9jb250cm9sbGVyIgpob3N0czobY29udHJvbGxlcl9hY3Rp
dmVfdGFic3sJIg9zdGF0aXN0aWNzIgAiEGZhY3RfdmFsdWVzIgAi2tlbiIxVW9aZHljVFV1U3U3ejR3eW1ZRGdrNk5NRXBK
MzFBQU9WUUdPMWVVUjFiQT06CXVzZXJpBg==
', "updated_at" = '2010-11-23 13:56:21' WHERE "id" = 4467
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract_adapter.rb:219:in log' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:172:inexecute'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/sqlite_adapter.rb:417:in catch_schema_changes' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:172:inexecute'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/database_statements.rb:265:in
update_sql' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:176:inupdate_sql'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/database_statements.rb:49:in
update_without_query_dirty' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/query_cache.rb:18:inupdate'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2883:in update_without_lock' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ locking/optimistic.rb:70:inupdate_without_dirty'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
dirty.rb:146:in update_without_timestamps' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ callbacks.rb:282:inupdate'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2874:in create_or_update_without_callbacks' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ callbacks.rb:250:increate_or_update'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2538:in save_without_validation' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ validations.rb:1078:insave_without_dirty'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
dirty.rb:79:in save_without_transactions' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:229:insend'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:229:in with_transaction_returning_status' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/database_statements.rb:136:intransaction'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:182:in transaction' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:228:inwith_transaction_returning_status'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:196:in save' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:208:inrollback_active_record_state!'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:196:in save' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ session_store.rb:300:inset_session'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:1448:in silence' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ session_store.rb:297:inset_session'
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
session/abstract_store.rb:132:in call' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ query_cache.rb:29:incall'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/query_cache.rb:34:in cache' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ query_cache.rb:9:incache'
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
query_cache.rb:28:in call' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/connection_pool.rb:361:incall'
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
failsafe.rb:26:in call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:incall'
/usr/lib/ruby/1.8/thread.rb:135:in synchronize' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:incall'
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
dispatcher.rb:106:in call' /usr/share/foreman/vendor/rails/railties/lib/rails/rack/static.rb: 31:incall'
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in
call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:ineach'
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/ content_length.rb:13:incall'
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/handler/
webrick.rb:50:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:inservice'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run' /usr/lib/ruby/1.8/webrick/server.rb:173:instart_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in start' /usr/lib/ruby/1.8/webrick/server.rb:162:instart_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in start' /usr/lib/ruby/1.8/webrick/server.rb:92:ineach'
/usr/lib/ruby/1.8/webrick/server.rb:92:in start' /usr/lib/ruby/1.8/webrick/server.rb:23:instart'
/usr/lib/ruby/1.8/webrick/server.rb:82:in start' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/handler/ webrick.rb:14:inrun'
/usr/share/foreman/vendor/rails/railties/lib/commands/server.rb:
111
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire'
/usr/share/foreman/script/server:3

··· On 22 nov, 09:03, Ohad Levy wrote: > can you find out the error message from /var/log/foreman/production.log? > > btw: rubygem-rails package is not required (and it is very old). > > Ohad > > On Mon, Nov 22, 2010 at 9:46 AM, PieterB wrote: > > Every once and awhile, after >12 hours, I have to restart Foreman > > because it doesn't work anymore > > (We're sorry, but something went wrong.) > > > Another problem: I can start from the CLI, but I receive the above > > error page immediately if I try to use the service script. > > > Versions > > rubygem-rails-2.1.1-2.el5 > > foreman-0.1.6-2 > > > -- > > You received this message because you are subscribed to the Google Groups > > "Foreman users" group. > > To post to this group, send email to foreman-users@googlegroups.com. > > To unsubscribe from this group, send email to > > foreman-users+unsubscribe@googlegroups.com > > . > > For more options, visit this group at > >http://groups.google.com/group/foreman-users?hl=en.
#4

very simple :slight_smile:
the user which runs foreman (foreman?) does not have permissions to the
database directory / file.
chown foreman -R db ?

Ohad

··· On Tue, Nov 23, 2010 at 4:00 PM, PieterB wrote:

First, I thought it had something to do with SQLite because I’ve some
locking issues. Maybe mysql or postrges is better for ~ 60 hosts :slight_smile:
==> SQLite3::SQLException: unable to open database file:

Or is it the (old) Ruby version on RH5?

But why does it fail every time i try to use the init script…

This error maybe helps?

Completed in 416ms (View: 360, DB: 24) | 200 OK [http://…/]
/!\ FAILSAFE /!\ Tue Nov 23 14:56:21 +0100 2010
Status: 500 Internal Server Error
SQLite3::SQLException: unable to open database file: UPDATE
"sessions" SET “data” =
'BAh7CjoUbGFzdF9jb250cm9sbGVyIgpob3N0czobY29udHJvbGxlcl9hY3Rp

dmVfdGFic3sJIg9zdGF0aXN0aWNzIgAiEGZhY3RfdmFsdWVzIgAi2tlbiIxVW9aZHljVFV1U3U3ejR3eW1ZRGdrNk5NRXBK
MzFBQU9WUUdPMWVVUjFiQT06CXVzZXJpBg==
’, “updated_at” = ‘2010-11-23 13:56:21’ WHERE “id” = 4467
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract_adapter.rb:219:in log' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:172:inexecute’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/sqlite_adapter.rb:417:in catch_schema_changes' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:172:inexecute’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/database_statements.rb:265:in
update_sql' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/sqlite_adapter.rb:176:inupdate_sql’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/database_statements.rb:49:in
update_without_query_dirty' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/query_cache.rb:18:inupdate’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2883:in update_without_lock' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ locking/optimistic.rb:70:inupdate_without_dirty’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
dirty.rb:146:in update_without_timestamps' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ callbacks.rb:282:inupdate’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2874:in create_or_update_without_callbacks' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ callbacks.rb:250:increate_or_update’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:2538:in save_without_validation' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ validations.rb:1078:insave_without_dirty’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
dirty.rb:79:in save_without_transactions' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:229:insend’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:229:in with_transaction_returning_status' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/database_statements.rb:136:intransaction’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:182:in transaction' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:228:inwith_transaction_returning_status’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:196:in save' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ transactions.rb:208:inrollback_active_record_state!’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
transactions.rb:196:in save' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ session_store.rb:300:inset_session’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
base.rb:1448:in silence' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ session_store.rb:297:inset_session’
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
session/abstract_store.rb:132:in call' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ query_cache.rb:29:incall’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
connection_adapters/abstract/query_cache.rb:34:in cache' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ query_cache.rb:9:incache’
/usr/share/foreman/vendor/rails/activerecord/lib/active_record/
query_cache.rb:28:in call' /usr/share/foreman/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/connection_pool.rb:361:incall’
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
failsafe.rb:26:in call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:incall’
/usr/lib/ruby/1.8/thread.rb:135:in synchronize' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/lock.rb:11:incall’
/usr/share/foreman/vendor/rails/actionpack/lib/action_controller/
dispatcher.rb:106:in call' /usr/share/foreman/vendor/rails/railties/lib/rails/rack/static.rb: 31:incall’
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in
call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:ineach’
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
call' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/ content_length.rb:13:incall’
/usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/handler/
webrick.rb:50:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:inservice’
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run' /usr/lib/ruby/1.8/webrick/server.rb:173:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start' /usr/lib/ruby/1.8/webrick/server.rb:162:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:95:in start' /usr/lib/ruby/1.8/webrick/server.rb:92:ineach’
/usr/lib/ruby/1.8/webrick/server.rb:92:in start' /usr/lib/ruby/1.8/webrick/server.rb:23:instart’
/usr/lib/ruby/1.8/webrick/server.rb:82:in start' /usr/share/foreman/vendor/gems/rack-1.0.1/lib/rack/handler/ webrick.rb:14:inrun’
/usr/share/foreman/vendor/rails/railties/lib/commands/server.rb:
111
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
/usr/share/foreman/script/server:3

On 22 nov, 09:03, Ohad Levy ohadl...@gmail.com wrote:

can you find out the error message from /var/log/foreman/production.log?

btw: rubygem-rails package is not required (and it is very old).

Ohad

On Mon, Nov 22, 2010 at 9:46 AM, PieterB pieter.ba...@gmail.com wrote:

Every once and awhile, after >12 hours, I have to restart Foreman
because it doesn’t work anymore
(We’re sorry, but something went wrong.)

Another problem: I can start from the CLI, but I receive the above
error page immediately if I try to use the service script.

Versions
rubygem-rails-2.1.1-2.el5
foreman-0.1.6-2

–
You received this message because you are subscribed to the Google
Groups

“Foreman users” group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.comforeman-users%2Bunsubscribe@googlegroups.com
<foreman-users%2Bunsubscribe@googlegroups.comforeman-users%2Bunsubscribe@googlegroups.com

.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.comforeman-users%2Bunsubscribe@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.