-----Original Message----- From: Srinidhi B [mailto:srinidhi@novell.com] Sent: Saturday, July 07, 2012 7:15 AM To: Malcolm Fernandes; opensuse-buildservice@opensuse.org Subject: Re: [opensuse-buildservice] Rebuild time broken in OBS 2.3.1

...

...

...

On 7/7/2012 at 06:05 AM, "Malcolm Fernandes" wrote: We are using a local OBS instance (2.3.1 appliance) and the rebuild_time feature seems to be broken when we upgraded from OBS 2.1.

It worked for us in OBS 2.1

Yes. There are a couple of (trivial) patches that I never sent to this list and neither did I send pull requests on github. Sorry about that.

...

Status: 500 Internal Server Error Mysql::Error: MySQL server has gone away: UPDATE `sessions` SET `data` =

Let's start with this one...

"Mysql server has gone away" shows up because the webui code "forks" out the mkddistats process. When this forked process finishes, the db connection is also closed. To avoid this, you can add the following in config/database.yml under your current environment (usually, production):

production: adapter: mysql .... reconnect: true

References: http://stackoverflow.com/questions/8913476/using-fork-in-ruby-on-rails- for-creating-parallel-process

I didn't want to change the webui sources, so used the (highest rated) solution from:

http://stackoverflow.com/questions/100631/mysql-server-has-gone-away- with-rails

Next problem would need source change in webui. In app/controllers/project_controller.rb, you'll find a function called rebuild_time_png. I had to comment the first line of that function:

redirect_to :action => "list_public" and return unless request.xhr?

I did this because from reading the sources inside views, I couldn't see anyway this function being called via an AJAX call. That's why this page would render the project list page every time.

I don't think you need any more changes to get the rebuild time page to render correctly. I'll try to send these changes via pull requests soon.

Thanks, made these changes locally and it works now. Cheers, Mal -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org