Defect #14706

Sometimes pages are slow

Added by Gareth Evans almost 8 years ago. Updated almost 8 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution: Affected version:2.3.2

Description

Firstly, sorry for the weird subject - it's the only way I can describe this.

I've recently upgraded my redmine from 1.3.x to 2.3.2.
We're using a bitnami VM as I know very little about rails or supporting technology.

Initially, we were using mysql as the database (which ships with the bitnami install) and we noticed that the app would sometimes "hang" for periods of time when loading pages.
I migrated it from mysql to sqlserver (as we have one in the office that serves our other dev systems) by copying the schema and data then updating database.yml and page load time dropped overall.
It's worth noting that we are also using SVN repository integration pointing at an external beanstalkapp SVN (cloud)

What I'm seeing is that sometimes the redmine instance just won't load a page for ages. It will just sit there and sometimes may show the "an error has occurred"
I've grabbed a copy of the last 1000 lines of production.log and attached it to this issue.
Most of the time everything will be fast and snappy but then occassionally, we'll get this (from production.log)
Completed 200 OK in 506885ms (Views: 1515.8ms | ActiveRecord: 1271.4ms)
Note the really huge page load time but the low active record and views load times.

@
Environment:
Redmine version 2.3.2.stable
Ruby version 1.9.3-p448 (2013-06-27) [x86_64-linux]
Rails version 3.2.13
Environment production
Database adapter SQLServer
Redmine plugins:
no plugin installed

svn, version 1.7.5 (r1336830)
compiled Jul 12 2013, 12:41:27

@

production.1000.log - last 1000 lines of production.log (57.5 KB) Gareth Evans, 2013-08-19 02:34

gem-list.txt Magnifier (2.47 KB) Gareth Evans, 2013-08-19 23:16

History

#1 Updated by Etienne Massip almost 8 years ago

Looks like your server is restarting each time you got such response times, what server are you using?

#2 Updated by Gareth Evans almost 8 years ago

It's the bitnami virtual machine installed onto an esxi server.
The VM doesn't appear to be restarting as the other machines hosted on the same physical hardware are still up.

It's apache2 webserver, I think it uses passenger phusion?
By server do you mean the apache2 process?

Apache/2.4.4 (Unix), Phusion Passenger version 4.0.2
Looking at ps output, there are 10 instances of apache2 running at the current time, but redmine has been used recently. Would I see that process go away or the .ruby.bin process?

#3 Updated by Gareth Evans almost 8 years ago

Gem list attached

#4 Updated by Etienne Massip almost 8 years ago

Gareth Evans wrote:

It's apache2 webserver, I think it uses passenger phusion?
By server do you mean the apache2 process?

Yes, either Apache server instance or Passenger application instance.
Each time you see the line Connecting to database specified by database.yml in the log file, the instance is restarting, and it matches the huge delays you got.

Apache/2.4.4 (Unix), Phusion Passenger version 4.0.2
Looking at ps output, there are 10 instances of apache2 running at the current time, but redmine has been used recently. Would I see that process go away or the .ruby.bin process?

I don't know well Passenger and I can't help you on this, sorry.

Also available in: Atom PDF