Problem with obs-server appliance

Hello,

I’m trying to setup the own build service using appliance obs-server.i686-1.7.0-Build3.14-raw.bz2 I tried various builds of appliance from 3.9 -3.14 with almost the same results.

GUI looks working there are just missing build status for added packages in package details.

After some investigation I found one failing cron job:

cd /srv/www/obs/webui/ && RAILS_ENV=production rake --trace jobs:render24

here is error message after trace turned on:

rake aborted!
SQLite3::SQLException: unable to open database file: INSERT INTO “delayed_jobs” (“failed_at”, “locked_by”, “created_at”, “handler”, “updated_at”, “priority”, “r un_at”, “attempts”, “locked_at”, “last_error”) VALUES(NULL, NULL, ‘2010-02-23 10 :00:05’, ‘— !ruby/object:DelayedPlots
hours: 24
‘, ‘2010-02-23 10:00:05’, 0, ‘2010-02-23 10:00:05’, 0, NULL, NULL)
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/abstract_adapter.rb:219:in log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/sqlite_adapter.rb:172:in execute’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/sqlite_adapter.rb:417:in catch_schema_changes' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/sqlite_adapter.rb:172:in execute’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/abstract/database_statements.rb:259:in insert_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/sqlite_adapter.rb:186:in insert_sql’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/abstract/database_statements.rb:44:in insert_without_query_dirty' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/abstract/query_cache.rb:18:in insert’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2908:in create_without_timestamps' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/timestamp.rb:53 :in create_without_callbacks’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:26 6:in create' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2874:in create_or_update_without_callbacks’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:25 0:in create_or_update' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2538:in save_without_validation’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/validations.rb: 1078:in save_without_dirty' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/dirty.rb:79:in save_without_transactions’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :229:in send' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :229:in with_transaction_returning_status’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adap ters/abstract/database_statements.rb:136:in transaction' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :182:in transaction’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :228:in with_transaction_returning_status' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :196:in save’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :208:in rollback_active_record_state!' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb :196:in save’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:723:in create' /usr/lib/ruby/gems/1.8/gems/delayed_job-1.8.4/lib/delayed/job.rb:117:in enqueue ’
/srv/www/obs/webui/lib/tasks/delayed_job.rake:5
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in execute’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in execute’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in invoke_with_call_chai n' /usr/lib/ruby/1.8/monitor.rb:242:in synchronize’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in invoke_with_call_chai n' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in invoke’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in top_level’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in top_level’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in standard_exception_h andling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in top_level’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in standard_exception_h andling’
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 /usr/bin/rake:19:in load’
/usr/bin/rake:19
(in /srv/www/obs/webui)
** Invoke jobs:render24 (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute jobs:render24

It looks like SQLite have problem accessing/creating the database.

As I’m not familiar with ruby not even rails I have no idea where the search for the problem.

Anybody could point me what could be the problem?

Many thanks
Dibo

do a

chown lighttpd.lighttpd /srv/www/obs/webui/db

to fix the issue. It will be fixed in 1.7.2 release.