Mailinglist Archive: opensuse-buildservice (145 mails)

< Previous Next >
Re: [opensuse-buildservice] List All Projects: Application error 500
Hi Andreas,

unfortunately my post to this list from Sep 11th, 12:56 CEST is not in
the list archive...


On Fri, 18 Oct 2013 13:12:49 +0200
Andreas Herrmann <a.herrmann@xxxxxxxxxxxxxxxxxxx> wrote:

Hi there,

after updating OBS 2.4 (zypper ref; zypper up) I just get an
application error 500, when I want to list all projects in the webui.
'osc list' still works

==> /srv/www/obs/api/log/production.log <==
[INFO |# 3196] Processing by WebuiController#all_projects as XML
[INFO |# 3196] iChain user extracted from header: adm_ahe
[INFO |# 3196] Completed 500 Internal Server Error in 57ms
[FATAL|# 3196] NoMethodError (undefined method `id' for nil:NilClass):
app/controllers/webui_controller.rb:270:in `all_projects'
config/initializers/wrap_parameters.rb:35:in `call'

==> /srv/www/obs/webui/log/production.log <==
[FATAL|# 2680] ActiveXML::Transport::Error
(#<Net::HTTPInternalServerError:0x000000059b46f0>):
lib/activexml/transport.rb:461:in `handle_response'
lib/activexml/transport.rb:400:in `http_do'
app/models/api_details.rb:26:in `find'
app/controllers/project_controller.rb:39:in `list'
app/controllers/project_controller.rb:35:in `list_public'

Any ideas?


My answer from Sep 11th:


... and I thought, that I was the sole user running into that
problem!

There are (at least) two database entries missing after an update to 2.4
from a previous OBS installation.

Add the two entries in the projects and repositories table:
root# mysql -u root -p[database password] api_production
mysql> insert into projects
(id,name,title,description,created_at,updated_at) values
('2','deleted',NULL,NULL,now(),now());
mysql> insert into repositories

(id,db_project_id,name,remote_project_name,rebuild,block,linkedbuild,hostsystem_id)
values ('1','1','deleted',NULL,NULL,NULL,NULL,NULL);
mysql> quit

You of course may want to check, that there are no entries with the
same id's are in the tables already.


The update process does not cover these entries, as they are most
probably so basic, that they are expected to be there.




PLEASE check the wrapped lines for the insert statements above.

Greetings,

Stefan
--
Stefan Botter
Network Manager

Jacobs University Bremen gGmbH
Campus Ring 1 | 28759 Bremen | Germany

Commercial registry: Amtsgericht Bremen, HRB 18117
President & Geschäftsführer: Prof. Dr. Heinz-Otto Peitgen
Provost & Geschäftsführerin: Prof. Dr.-Ing. Katja Windt
Chair Board of Governors: Prof. Dr. Karin Lochte

< Previous Next >
References