[opensuse-buildservice] List All Projects: Application error 500
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? -- Andreas Herrmann Heinlein Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030 / 40 50 51 - 45 Fax: 030 / 40 50 51 - 19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin
On 10/18/13 13:12, Andreas Herrmann 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?
Here's the list of updates done: 2013-10-18 11:01:16|install|bundle-lang-common-ar|12.2-2.2.4|noarch||openSUSE:12.2|b5c0ad04737c3f5f14152dd89a1af1408c698dbec0d523b13f923be2bb7a2541 2013-10-18 11:01:19|install|site-config|0.2-6.5.1|x86_64||openSUSE:12.2|f7698fa4936848022c2126140fa5a152849c3cf00e67dcbfaa1401fd1f8d139e 2013-10-18 11:01:19|install|build-initvm|2012.07.19-1.4.1|x86_64||openSUSE:12.2:Update|38d2f3b22914c2acf981229b082ea948f692e8f24babb64e455d07a58d32962c 2013-10-18 11:01:22|install|gpg2|2.0.19-2.17.1|x86_64||openSUSE:12.2:Update|6dab6b02bf171789c60bd1d8732e2ec40eb035725172d8536c80c95fcf00eee0 2013-10-18 11:01:23|install|libmysqlclient18|5.5.33-1.17.1|x86_64||openSUSE:12.2:Update|d08217675eb5ecc137032400fc14cfd28983617c4fee2b64006c19ebb0ae341f 2013-10-18 11:01:24|install|make|3.82-151.9.1|x86_64||openSUSE:12.2:Update|b64f320fde90f6bde3b2e2dfead74371adb937b49a33124100b0beb3f922149d 2013-10-18 11:01:26|install|systemd|44-10.21.1|x86_64||openSUSE:12.2:Update|03251db910dc731544d759b965a6c87a506b47fdc4c2970a123a1b3bb0a4d5a5 # 2013-10-18 11:01:34 timezone-2013f-1.36.1.x86_64.rpm installed ok # Additional rpm output: # WARNING: Not updating /etc/localtime with new zone file # 2013-10-18 11:01:34|install|timezone|2013f-1.36.1|x86_64||openSUSE:12.2:Update|d5c391545dc3c4fb83d6b54c8e4b70f73330e59f211e68f5bc95cd373aea962e 2013-10-18 11:01:34|install|mysql-community-server-errormessages|5.5.33-1.17.1|x86_64||openSUSE:12.2:Update|63dce61d4046e7c14e1759470a3dbcd8c9bf08163e4129ee96dbff5556574d4a 2013-10-18 11:01:36|install|mysql-community-server-client|5.5.33-1.17.1|x86_64||openSUSE:12.2:Update|214af2e0f335f633407c26a22df83375fd3f981c36eb748f1eb3ffe389ec04ab # 2013-10-18 11:02:03 mysql-community-server-5.5.33-1.17.1.x86_64.rpm installed ok # Additional rpm output: # Shutting down service MySQL ..done # Starting service MySQL ..done # 2013-10-18 11:02:03|install|mysql-community-server|5.5.33-1.17.1|x86_64||openSUSE:12.2:Update|b3b48b6cd79a8bc3bd1ed4fe8ab1f42266668f458739e00d29304bb29c6e05a1 -- Andreas Herrmann Heinlein Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030 / 40 50 51 - 45 Fax: 030 / 40 50 51 - 19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin
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
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
On Fri, 18 Oct 2013 15:50:59 +0200
Stefan Botter
unfortunately my post to this list from Sep 11th, 12:56 CEST is not in the list archive...
Just to correct myself my mail is in the archive: http://lists.opensuse.org/opensuse-buildservice/2013-09/msg00084.html 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
On 10/18/13 15:50, Stefan Botter wrote:
There are (at least) two database entries missing after an update to 2.4 from a previous OBS installation.
It was an update within 2.4. The installation is just one some days old: obs-server.x86_64-2.4.4-Build2.12-vmx.tar.bz2 I believe this can happen to everyone who is doing an "zypper ref;zypper up" those days... :-( Andreas -- Andreas Herrmann Heinlein Support GmbH Linux: Akademie - Support - Hosting http://www.heinlein-support.de Tel: 030 / 40 50 51 - 45 Fax: 030 / 40 50 51 - 19 Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin
On 10/18/13 16:26, Andreas Herrmann wrote:
On 10/18/13 15:50, Stefan Botter wrote:
There are (at least) two database entries missing after an update to 2.4 from a previous OBS installation.
It was an update within 2.4. The installation is just one some days old: obs-server.x86_64-2.4.4-Build2.12-vmx.tar.bz2
I believe this can happen to everyone who is doing an "zypper ref;zypper up" those days... :-(
Andreas
Nope, false alarm. I deleted the "deleted" Project by hand and triggerd the error :-) Andreas
participants (2)
-
Andreas Herrmann
-
Stefan Botter