500 Internal Server Error

Added by Erich Rockman over 11 years ago

Intermittently getting this. Any help would be appreciated.

Processing IssuesController#index (for 192.168.10.181 at 2010-05-11 17:17:24) [GET]
Parameters: {"project_id"=>"jrsupport", "action"=>"index", "controller"=>"issues"}
SQL (0.0ms) PGError: could not receive data from server: Socket operation on non-socket (0x00002736/10038)
: SELECT max("settings".updated_on) AS max_updated_on FROM "settings" 

ActiveRecord::StatementInvalid (PGError: could not receive data from server: Socket operation on non-socket (0x00002736/10038)
: SELECT max("settings".updated_on) AS max_updated_on FROM "settings" ):
app/models/setting.rb:151:in `check_cache'
app/controllers/application_controller.rb:54:in `user_setup'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:76:in `pre_process'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:74:in `catch'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:74:in `pre_process'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:57:in `process'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/connection.rb:42:in `receive_data'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/backends/base.rb:57:in `start'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/server.rb:156:in `start'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/controllers/controller.rb:80:in `start'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:177:in `send'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:177:in `run_command'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/lib/thin/runner.rb:143:in `run!'
C:/ruby/lib/ruby/gems/1.8/gems/thin-1.2.7-x86-mingw32/bin/thin:6
c:/ruby/bin/thin:19:in `load'
c:/ruby/bin/thin:19

Rendering C:/redmine-0.9.4/public/500.html (500 Internal Server Error)

Replies (2)

RE: 500 Internal Server Error - Added by Felix Schäfer over 11 years ago

I think it's more of a problem of the ruby to pg binding, see if they can help you with that (home of the pg gem is http://rubygems.org/gems/pg).

RE: 500 Internal Server Error - Added by Pei-Tang Huang over 9 years ago

I have exactly the same issue... after I replaced mongrel with thin!

Does anyone know how to resolve this issue?

ActiveRecord::StatementInvalid (PGError: could not receive data from server: Socket operation on non-socket (0x00002736/10038)
: SELECT max("settings".updated_on) AS max_updated_on FROM "settings" ):
  app/models/setting.rb:152:in `check_cache'
  app/controllers/application_controller.rb:86:in `user_setup'
  thin (1.3.1) lib/thin/connection.rb:80:in `pre_process'
  thin (1.3.1) lib/thin/connection.rb:78:in `catch'
  thin (1.3.1) lib/thin/connection.rb:78:in `pre_process'
  thin (1.3.1) lib/thin/connection.rb:53:in `process'
  thin (1.3.1) lib/thin/connection.rb:38:in `receive_data'
  eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
  eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
  thin (1.3.1) lib/thin/backends/base.rb:61:in `start'
  thin (1.3.1) lib/thin/server.rb:159:in `start'
  thin (1.3.1) lib/thin/controllers/controller.rb:86:in `start'
  thin (1.3.1) lib/thin/runner.rb:185:in `send'
  thin (1.3.1) lib/thin/runner.rb:185:in `run_command'
  thin (1.3.1) lib/thin/runner.rb:151:in `run!'
  thin (1.3.1) bin/thin:6
  C:/App/Ruby187/bin/thin:19:in `load'
  C:/App/Ruby187/bin/thin:19

(1-2/2)