Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-3086

Data source rejected establishment of connection, message from server: "Too many connections" error with mySQL and RAILO 4.2.1

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 4.2.1.000
    • Fix Version/s: 4.3.0.000, 4.2.1.001
    • Labels:
      None
    • Environment:

      OS: Window 7
      Database : MySQL 5.6 with maximum connection limit 151

    • Steps to Reproduce:
      Hide

      issue appear only on heavy load, I think jMeter will do the job for reproducing issue, for more detail please see below blog entry.

      http://www.isummation.com/blog/data-source-rejected-establishment-of-connection-message-from-server-too-many-connections-error-with-mysql-and-railo-421/

      Show
      issue appear only on heavy load, I think jMeter will do the job for reproducing issue, for more detail please see below blog entry. http://www.isummation.com/blog/data-source-rejected-establishment-of-connection-message-from-server-too-many-connections-error-with-mysql-and-railo-421/
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      You can avoid this issue if you limit number of connection at datasource property and keep setting below mysql allowed maximum connection.
      You may need to adjust number based on how many databases available in your database server and any other application/datasource doing connection with same server.

      Show
      You can avoid this issue if you limit number of connection at datasource property and keep setting below mysql allowed maximum connection. You may need to adjust number based on how many databases available in your database server and any other application/datasource doing connection with same server.

      Description

      Basically issue wasn't appearing on 4.1.x version but it is in 4.2.x.
      I have mysql 5.5 with connection limit of 151 but it should appear all mysql database whenever it hits that number.

      I have tried to explain full issue in below blog entry with all tested cases.
      http://www.isummation.com/blog/data-source-rejected-establishment-of-connection-message-from-server-too-many-connections-error-with-mysql-and-railo-421/

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                thecfguy Pritesh Patel
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: