Attention:
The frontline support team will be unavailable to answer questions until May27th 2019. We will be back soon after. Thank you for your patience and we apologize for any inconvenience!

Call catching - Cromwell exhausts all connection to mysqld

Anyone experienced leaky Cromwell when call-catching with mysql table? Even after extending max_connections to 5000 it complains, i.e. I can only run a single Cromwell run at a time.

mysql --socket=../socket -u root
ERROR 1040 (HY000): Too many connections

Any suggestions?

Answers

  • RuchiRuchi Member, Broadie, Moderator, Dev admin

    Hey @dplichta,

    Just so I understand better -- are you trying to use the same mysql DB between multiple Cromwell instances?

  • dplichtadplichta Member

    Hi @Ruchi,

    Yes, in the early few days of me playing with cromwell+wdl I did exactly that, until for this and other reasons (cromwell exhausing max. number of processes allowed in the system) I switched to cromwell server.

    Thanks for getting back on this,

    Damian

  • RuchiRuchi Member, Broadie, Moderator, Dev admin

    Hey Damian,

    You might want to try setting the key maxConnection to something to restrict Cromwell from taking up too many connections:

    database {
      # mysql example
      profile = "slick.jdbc.MySQLProfile$"
      db {
        driver = "com.mysql.jdbc.Driver"
        url ="jdbc:mysql://mysql...."
        user = "..."
        password = "..."
        maxConnections = "<number-of-your-choice>"
      }
    }
    
Sign In or Register to comment.