Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-419

Socket creation failed due 24, Too many open files.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.1
    • Fix Version/s: 2.0.0
    • Component/s: readconnroute
    • Labels:
      None
    • Environment:
      Debian 7.9, VM under KVM, 8 vCPUs/8GB RAM (designed sql LB type) - deb package involved : maxscale-1.2.1-1.deb_wheezy.x86_64.deb

      Description

      Hi,

      This might be a stupid thread but I'll take a shoot on it.

      I have the max scale production environment described into MXS-415 ticket.
      Under high load over database connections (many frontend servers connecting to the database Loadbalancer) - regularity is 1 per day - I get the maxscale error log filled with :

      2015-10-21 16:53:03 Error : Failed to create Read Connection Router session.
      2015-10-21 16:53:03 Error : Failed to create Read Connection Router session.
      2015-10-21 16:53:03 Error: Establishing connection to backend server 10.200.100.153:3306 failed.
      Socket creation failed due 24, Too many open files.
      2015-10-21 16:53:03 Error: Establishing connection to backend server 10.200.100.152:3306 failed.
      Socket creation failed due 24, Too many open files.
      2015-10-21 16:53:03 Error : Failed to create Read Connection Router session.
      2015-10-21 16:53:03 Error: Establishing connection to backend server 10.200.100.151:3306 failed.
      Socket creation failed due 24, Too many open files.
      2015-10-21 16:53:03 Error : Failed to create Read Connection Router session.

      Now, I have set before and let it run for one day into /etc/security/limits.conf:

      • soft nofile 65535
      • hard nofile 65535

      after which I have restarted the maxscale daemon to pick-up the change.

      Question is (didn't do it but I am going to test now as a last resort) should there be included into the init script before daemon start-up the ulimit -HSn 65535 value by default in the standard rpm/deb build the ulimit setting ?

      I suppose other folks are using maxsclae in deployments where the load is quite big.

      Thanks,
      Alex

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            avladulescu Alex Vladulescu
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: