Redmine

Hi everyone,

I've recently stumbled on a weird problem that I can't seem to pin-point. Any help would be greatly appreciated as it is a bit annoying.

Description¶

I've recently installed a new instance of Redmine on one of my virtual servers (I actually run 3 instances for 3 different domains on 3 different physical hosts) and everything seemed to be going just fine until yesterday when I attempted to create an issue with a particularly long description and got a "500 Internal Server Error" back.

Now I've checked permissions & logs and everything seems to be configured properly (I mean I've created issues, projects, wiki pages, users, workflows, trackers, etc... With no particular problem until this post and can still create/update/delete previous issues provided their length stays under approximately 2000 chars (saying approximately because this value seems to vary (+/- 10 characters).

Now the weird part is that the issue is actually saved with the entire content in the PostgreSQL "issues" table, there are no error/warnings messages in any of the logs and the issue is listed in Redmine when I navigate away from the 500 error page to the Issues tab. When I try to view the content though it brings me back to the error page.

Environment¶

OS - Debian Wheezy

    3.2.51-vs2.3.2.16-beng #1 SMP Sat Sep 28 12:19:09 BST 2013 x86_64 GNU/Linux

Apache

    Server version: Apache/2.2.22 (Debian)
    Server built:   Mar  4 2013 22:05:16
    Server's Module Magic Number: 20051115:30
    Server loaded:  APR 1.4.6, APR-Util 1.4.1
    Compiled using: APR 1.4.6, APR-Util 1.4.1
    Architecture:   64-bit
    Server MPM:     Prefork
      threaded:     no
        forked:     yes (variable process count)
    Server compiled with....
     -D APACHE_MPM_DIR="server/mpm/prefork" 
     -D APR_HAS_SENDFILE
     -D APR_HAS_MMAP
     -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D DYNAMIC_MODULE_LIMIT=128
     -D HTTPD_ROOT="/etc/apache2" 
     -D SUEXEC_BIN="/usr/lib/apache2/suexec" 
     -D DEFAULT_PIDLOG="/var/run/apache2.pid" 
     -D DEFAULT_SCOREBOARD="logs/apache_runtime_status" 
     -D DEFAULT_LOCKFILE="/var/run/apache2/accept.lock" 
     -D DEFAULT_ERRORLOG="logs/error_log" 
     -D AP_TYPES_CONFIG_FILE="mime.types" 
     -D SERVER_CONFIG_FILE="apache2.conf" 

Passenger

    Phusion Passenger version 4.0.19

PostgreSQL

    psql (PostgreSQL) 9.2.5

Ruby

       ruby-2.0.0-p247 [ x86_64 ]
    =* ruby-head [ x86_64 ]

Rails

    Rails 3.2.13

Gem - 2.1.5

    Local Gems
    actionmailer (4.0.0, 3.2.13)
    actionpack (4.0.0, 3.2.13)
    activemodel (4.0.0, 3.2.13)
    activerecord (4.0.0, 3.2.13)
    activerecord-deprecated_finders (1.0.3)
    activeresource (3.2.13)
    activesupport (4.0.0, 3.2.13)
    arel (4.0.0, 3.0.2)
    atomic (1.1.14)
    bigdecimal (1.2.1)
    builder (3.1.4, 3.0.0)
    bundler (1.3.5)
    bundler-unload (1.0.2)
    coderay (1.0.9)
    daemon_controller (1.1.5)
    erubis (2.7.0)
    executable-hooks (1.2.3)
    hike (1.2.3)
    i18n (0.6.5, 0.6.1)
    io-console (0.4.2)
    journey (1.0.4)
    jquery-rails (2.0.3)
    json (1.8.0, 1.7.7)
    mail (2.5.4)
    mime-types (1.25)
    minitest (4.7.5)
    multi_json (1.8.0)
    net-ldap (0.3.1)
    passenger (4.0.19)
    pg (0.17.0)
    polyglot (0.3.3)
    psych (2.0.1)
    rack (1.5.2, 1.4.5)
    rack-cache (1.2)
    rack-openid (1.3.1)
    rack-ssl (1.3.3)
    rack-test (0.6.2)
    rails (4.0.0, 3.2.13)
    railties (4.0.0, 3.2.13)
    rake (10.1.0, 0.9.6)
    rdoc (4.1.0.preview.1, 3.12.2)
    rmagick (2.13.2)
    ruby-openid (2.3.0)
    rubygems-bundler (1.3.3)
    rvm (1.11.3.8)
    sprockets (2.10.0, 2.2.2)
    sprockets-rails (2.0.0)
    test-unit (2.1.0.0)
    thor (0.18.1)
    thread_safe (0.1.3)
    tilt (1.4.1)
    treetop (1.4.15)
    tzinfo (0.3.37)

RAILS_ENV=production script/about

    Environment:
      Redmine version                2.3.3.stable.12195
      Ruby version                   2.1.0-p-1 (2013-10-02) [x86_64-linux]
      Rails version                  3.2.13
      Environment                    production
      Database adapter               PostgreSQL
    Redmine plugins:
      no plugin installed

Logs¶

PostgreSQL - shows nothing

Production.log

[Sat Oct 19 09:44:11 2013] [info] Initial (No.1) HTTPS request received for child 0 (server redmine.inmtxx.net:443)
178.192.162.181 - - [19/Oct/2013:09:44:11 +0200] "POST /projects/qjet/issues HTTP/1.1" 302 1653 "https://redmine.inmtxx.net/projects/qjet/issues/new" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0" 
[Sat Oct 19 09:44:11 2013] [info] Subsequent (No.2) HTTPS request received for child 0 (server redmine.inmtxx.net:443)
178.192.162.181 - - [19/Oct/2013:09:44:11 +0200] "GET /issues/41 HTTP/1.1" 500 980 "https://redmine.inmtxx.net/projects/qjet/issues/new" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0" 

Thanks in advance for any pointer / workaround / explanation

Best,
Jean-Samuel