Error

lei_xiao · November 24, 2015, 11:47am

After I created a user, the user column has been stuck, without any account
of.
After what had prompted. Restart the service just fine.

QueuePool limit of size 5 overflow 10 reached, connection timed out,
timeout 30

cornelinux · November 24, 2015, 1:50pm

Hi,

unfortunately I can not make anything with your hints.

Managing the users from within privacyIDEA was originally ment for
smaller installations.

Anyway, you might play around in the code with some parameters.

See
http://docs.sqlalchemy.org/en/latest/core/pooling.html

You might add some parameters to this line:

github.com

privacyidea/privacyidea/blob/master/privacyidea/lib/resolvers/SQLIdResolver.py#L565


      
              password = "" # nosec B105 # default parameter
              conParams = ""
              if param.get("Port"):
                  port = ":{0!s}".format(param.get("Port"))
              if param.get("Password"):
                  password = ":{0!s}".format(param.get("Password"))
              if param.get("conParams"):
                  conParams = "?{0!s}".format(param.get("conParams"))
              connect_string = "{0!s}://{1!s}{2!s}{3!s}{4!s}{5!s}/{6!s}{7!s}".format(param.get("Driver") or "",
                                                         param.get("User") or "",
                                                         password,
                                                         "@" if (param.get("User")
                                                                 or
                                                                 password) else "",
                                                         param.get("Server") or "",
                                                         port,
                                                         param.get("Database") or "",
                                                         conParams)
              return connect_string
          
          @classmethod

The default is:
pool_size=5, max_overflow=10, timeout=30

The pool size and max_overflow probably should fit the web servers
worker processes.

We could add configurable values…

Kind regards
CorneliusAm Dienstag, den 24.11.2015, 03:47 -0800 schrieb lei xiao:

After I created a user, the user column has been stuck, without any
account of.
After what had prompted. Restart the service just fine.

QueuePool limit of size 5 overflow 10 reached, connection timed out,
timeout 30

–
You received this message because you are subscribed to the Google
Groups “privacyidea” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to privacyidea+unsubscribe@googlegroups.com.
To post to this group, send email to privacyidea@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/privacyidea/d9fb449b-962d-4d43-88c3-436e50485603%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

–
Cornelius Kölbel
@cornelinux
+49 151 2960 1417

NetKnights GmbH
http://www.netknights.it
Landgraf-Karl-Str. 19, 34131 Kassel, Germany
Tel: +49 561 3166797, Fax: +49 561 3166798

Amtsgericht Kassel, HRB 16405
Geschäftsführer: Cornelius Kölbel

signature.asc (836 Bytes)