Re: [opensuse-buildservice] obs upload broken (Net::SMTPSyntaxError (501 5.1.3 Bad recipient address syntax)

On 07.05.2012 19:49, "Carsten Höger" wrote:

Hi,

On May 7, 2012 at 7:11 PM "Carsten Höger" wrote:

...

The api logs show:

[INFO |#24729] Parameters: {"comment"=>"checked in by oxbuildpackage", "user"=>"oxbuilduser", "package"=>"open-xchange-imap", "project"=>"open-xchange-nightly", "cmd"=>"commitfilelist"} [INFO |#24729] Sending data [FATAL|#24729] ActiveRecord::StatementInvalid (Mysql::Error: Table 'frontend_production.db_package_kinds' doesn't exist: SELECT * FROM `db_package_kinds` WHERE (`db_package_kinds`.db_package_id = 25086) ):

This was the root cause of the problem. Checking file db/production_structure.sql I found 4 missing tables:

db_package_issues, issues, db_package_kinds and issue_trackers. After I created them manually, I can upload again.

These might not have been created by the db:migrate task, because that one fails:

buildservice:/srv/www/obs/api # RAILS_ENV="production" rake db:migrate ** Erubis 2.6.6 == AddSqlConstraints: migrating ============================================== WARNING: The database is inconsistent, some FOREIGN KEYs (aka CONSTRAINTS) can not be added! please run script/check_database script to fix the data. rake aborted! An error has occurred, all later migrations canceled: uninitialized constant AddSqlConstraints::IllegalMigrationNameError Tasks: TOP => db:migrate (See full trace by running task with --trace)

I don't know how to run script/check_database, it only tries to access frontend_development...

Very similiar to the rake task: RAILS_ENV=production ./script/check_database Greetings, Stephan -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org