[DRE-maint] Bug#702291: redmine: Huge memory footprint with Apache-Passanger-Redmine install

[Parragh Szabolcs]

Package: redmine
Version: 2.2.3+dfsg1-1~precise+1
Severity: important

Dear Maintainer,
*** Please consider answering these questions, where appropriate ***

   * What led up to the situation?
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
   * What was the outcome of this action?
   * What outcome did you expect instead?

*** End of the template - remove these lines ***


-- System Information:
Debian Release: wheezy/sid
  APT prefers precise-updates
  APT policy: (500, 'precise-updates'), (500, 'precise-security'), (500, 'precise'), (100, 'precise-backports')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-38-generic (SMP w/1 CPU core)
Locale: LANG=hu_HU.UTF-8, LC_CTYPE=hu_HU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages redmine depends on:
ii  bundler                     1.1.4-5~precise+1
ii  dbconfig-common             1.8.47
ii  debconf [debconf-2.0]       1.5.42ubuntu1
ii  redmine-pgsql               2.2.3+dfsg1-1~precise+1
ii  ruby                        4.8
ii  ruby-coderay                1.0.6-2~precise+1
ii  ruby-fastercsv              1.5.5-1~precise+1
ii  ruby-net-ldap               0.3.1-1~precise+1
ii  ruby-openid                 2.1.8debian-5~precise+1
ii  ruby-rack                   1.4.1-1~precise+4
ii  ruby-rack-openid            1.3.1-1~precise+1
ii  ruby-rails-3.2              3.2.12-1~precise+1
ii  ruby1.8 [ruby-interpreter]  1.8.7.352-2ubuntu1.1

Versions of packages redmine recommends:
ii  libfcgi-ruby1.8 [libfcgi-ruby]    0.8.8-1
ii  libfcgi-ruby1.9.1 [libfcgi-ruby]  0.8.8-1
ii  ruby-passenger                    3.0.13debian-1~precise+1

Versions of packages redmine suggests:
ii  bzr           <none>
ii  cvs           <none>
ii  darcs         <none>
ii  git           <none>
ii  mercurial     <none>
ii  ruby-rmagick  2.13.1-5build1
ii  subversion    1.6.17dfsg-3ubuntu3

-- debconf information excluded

Basic redmine install, with default data only + 1 empty project. 

This is a separate instance (default doesn't run), installed as a cp-r of
/usr/share/redmine.

TOP output after pushing redmine for 2 mins.

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
 6508 www-data  20   0  295m 120m 2828 S  0.0 12.2   0:03.52 ruby               
11602 www-data  20   0  295m 120m 2808 S  0.0 12.1   0:03.41 ruby               
11591 www-data  20   0  293m 118m 2744 S  0.0 12.0   0:01.93 ruby               
11585 www-data  20   0  290m 118m 5748 S  0.0 11.9   0:04.50 ruby               
11597 www-data  20   0  291m 116m 2756 S  0.0 11.8   0:01.37 ruby             

Apache config:

<VirtualHost *:443>

  ServerName x.y.hu
  RailsEnv  production
  PassengerAppRoot /data/www/pojo/content.x-y.hu/redmine
  SetEnv X_DEBIAN_SITEID "myredmine"
  Alias "/plugin_assets/" /var/cache/redmine/myredmine/plugin_assets/
  DocumentRoot /data/www/pojo/content.x-y.hu/redmine
  <Directory "/data/www/pojo/content.x-y.hu/redmine">
    Order allow,deny
    Allow from all
  </Directory>

...

Other:

* no debugging configure
* no real change in any configs, only localhost smtp:

root at oberon ~ > diff -r /usr/share/redmine
/data/www/pojo/content.x-y.hu/redmine
21:07:21
Only in /data/www/pojo/content.x-y.hu/redmine/config:
additional_environment.rb
Only in /data/www/pojo/content.x-y.hu/redmine/config:
configuration.yml
diff -r /usr/share/redmine/config/environments/production.rb
/data/www/pojo/content.x-y.hu/redmine/config/environments/production.rb
31c31
<   config.active_support.deprecation = :log
---
>   config.active_support.deprecation = :notify
Only in /data/www/pojo/content.x-y.hu/redmine/db: schema.rb
Only in /data/www/pojo/content.x-y.hu/redmine: files
Only in /data/www/pojo/content.x-y.hu/redmine: log
Only in /data/www/pojo/content.meta-pojo.hu/redmine/public: log
Only in /data/www/pojo/content.meta-pojo.hu/redmine/public: tmp


---

btw: .js files are missing, dead links for these files:

 root at oberon ~ > ls -l /usr/share/redmine/public/javascripts/controls.js
lrwxrwxrwx 1 root root 45 febr  13 09:17 /usr/share/redmine/public/javascripts/controls.js -> /../../../javascript/scriptaculous/controls.js
-- which doesn't exist!

same for:
/usr/share/redmine/public/javascripts/dragdrop.js
/usr/share/redmine/public/javascripts/effects.js
/usr/share/redmine/public/javascripts/prototype.js
-- shouldn't something have installed these?

Thanks,
Szabolcs