Project

General

Profile

Actions
Copy link

Defect #31363

closed

500 Internal Server Error

Added by haobin li over 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Email notifications
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Duplicate
Affected version:
4.0.3

Description

The number of users is about 40. So the [ActionMailer::DeliveryJob] will send lots of mails when a user commit an issuse.
The web will display "500 Internal Server Error",but the committing action is taking effect.

Files

Download all files
production1.log (38.7 KB) production1.log haobin li, 2019-05-14 03:26
production2.log (23.1 KB) production2.log haobin li, 2019-05-14 03:26
20190514093011.png (13.9 KB) 20190514093011.png haobin li, 2019-05-14 03:30
production 3.log (11.4 KB) production 3.log haobin li, 2019-05-14 04:45

Related issues

Is duplicate of Redmine - Defect #31241: intermittent 500s ActiveRecord::ConnectionTimeoutErrorClosed

Actions
Actions
Copy link
 #1

Updated by haobin li over 5 years ago

From version 4.0.0 to v4.0.3,the issue always exist.

Actions
Copy link
 #2

Updated by bill auger over 5 years ago

this look like the same issue i reported a few weeks ago

https://www.redmine.org/issues/31241

Actions
Copy link
 #3

Updated by haobin li over 5 years ago

ActiveRecord::ConnectionTimeoutError (could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use):

5 secconds is too short.Which file/parameter couled be setted about this timer?

Actions
Copy link
 #4

Updated by Go MAEDA over 5 years ago

Could you paste the environment information? You can find it on admin/info page.

Actions
Copy link
 #5

Updated by haobin li over 5 years ago

Go MAEDA wrote:

Could you paste the environment information? You can find it on admin/info page.

Information

Redmine 4.0.3.stable

Default administrator account changed
Attachments directory writable
Plugin assets directory writable (./public/plugin_assets)
RMagick available (optional)
ImageMagick convert available (optional)

Environment:
  Redmine version                4.0.3.stable
  Ruby version                   2.6.0-p0 (2018-12-25) [x86_64-linux]
  Rails version                  5.2.2.1
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Subversion                     1.7.14
  Git                            1.8.3.1
  Filesystem                     
Redmine plugins:
  no plugin installed
Actions
Copy link
 #6

Updated by pasquale [:dedalus] about 5 years ago

It sound the same issue of #32314 where I have detected the magic number equals to 30

Actions
Copy link
 #7

Updated by jianmin Zhang over 4 years ago

Have you solved this problem？ I have the same problem when I use:

Completed 500 Internal Server Error in 5004ms (ActiveRecord: 0.0ms)

ActiveRecord::ConnectionTimeoutError (could not obtain a connection from the pool within 5.000 seconds (waited 5.003 seconds); all pooled connections were in use):

Actions
Copy link
 #8

Updated by bill auger over 4 years ago

i have no solution; but instead, i have changed the 500 page to read: "sorry, server is overloaded - please wait while we reconnect you ..."; and added a meta-refresh - it is super tacky; but it has stopped the complaints for now

Actions
Copy link
 #9

Updated by bill auger over 4 years ago

FWIW - i just noticed this ticket is categorized as "Email notifications"; while my ticket #31241 is categorized "Database" - these are almost certainly duplicates though

Actions
Copy link
 #10

Updated by Marius BĂLTEANU over 4 years ago

  • Is duplicate of Defect #31241: intermittent 500s ActiveRecord::ConnectionTimeoutError added
Actions
Copy link
 #11

Updated by Marius BĂLTEANU over 4 years ago

  • Status changed from New to Closed
  • Resolution set to Duplicate

I'm closing this in the favour of #31241, I've added some notes there.

Actions
Copy link

Also available in: Atom PDF