db connection issues in production but not in dev mode

rubyonrails-talk
1

We have an application Ruby on rails, which fires a number of queries to the database. I Suspect it is connection timeout error or something

When we run the application in development mode, it works as expected. However when we switch to Production mode, we get the following error in Postgre console:

2

Forgot to mention:

There are 4 asynchronous queries being fired. Out of these 3 get fired and result is achieved as expected, however the 4th query doesnt produce any result

There are no exceptions thrown neither any log created. However in Postgre Sql console the stack trace is as previously mentioned.

Yani Yen wrote:

3

Yani Yen wrote:

We have an application Ruby on rails, which fires a number of queries to the database. I Suspect it is connection timeout error or something

When we run the application in development mode, it works as expected. However when we switch to Production mode, we get the following error in Postgre console: -------------------------- LOG: could not receive data from client: No connection could be made because th e target machine actively refused it.

LOG: unexpected EOF on client connection ------------------------

Entries in database.yml file are as follows:

development:   adapter: jdbcpostgresql   database: microblogging   username: databaseusername   password: databasepassword   pool: 15   timeout: 15000

production:   adapter: jdbcpostgresql   database: microblogging   username: databaseusername   password: databasepassword   pool: 15   timeout: 15000

Environment: Jruby version 1.5.0 Rails version 2.3.5 Postgre SQL database Internal WEBrick server

This won't solve your problem, but it's a VERY BAD practice to have development and production point to the same DB. You really should be able to play around in your dev sandbox without jeopardizing production data.

Best,

4

Thank you, that was a mistake made by me while writing here my production database is microblogging_production.

The postgreSQL database version 8.3.7

Gem list :

*** LOCAL GEMS ***

actionmailer (2.3.5) actionpack (2.3.5) activerecord (2.3.5) activerecord-jdbc-adapter (0.9.7, 0.9.2) activerecord-jdbcmysql-adapter (0.9.2) activerecord-jdbcpostgresql-adapter (0.9.7) activeresource (2.3.5) activesupport (2.3.5) columnize (0.3.1) jdbc-mysql (5.0.4) jdbc-postgres (8.4.701) jruby-jars (1.5.0) jruby-openssl (0.7) jruby-rack (1.0.0) mysql (2.8.1) rack (1.0.1) rails (2.3.5) rake (0.8.7) rspec (1.3.0, 1.2.9) ruby-debug (0.10.3) ruby-debug-base (0.10.3.2) rubyzip (0.9.4) sources (0.0.1) warbler (1.0.3)

Thank you.

Marnen Laibow-Koser wrote:

5

Hi, my postgreSQl error went by changing the postgres adapter to 8.3.604..

Thanks...