(OperationalError) (1040, 'Too many connections') None None

Hi There,

Suddenly i get the following error on my Privacyidea Server:
(OperationalError) (1040, ‘Too many connections’) None None

Do you have any clue as to what the problem is?

Privacyidea version: 2.12.1-1trusty

/var/log/privacyidea/privacyidea.log
[2016-06-17
14:44:56,799][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:44:57,459][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,473][392][140122980845312][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,474][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,477][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,480][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,480][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,494][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /realm/’, ‘serial’: None}
[2016-06-17
14:44:57,484][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,496][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /smtpserver/’, ‘serial’: None}
[2016-06-17
14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /radiusserver/’, ‘serial’: None}
[2016-06-17
14:44:57,524][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,525][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: None, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /system/’, ‘serial’: None}
[2016-06-17
14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:45:00,241][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:00,250][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:00,251][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: u’MySQL_Local’, ‘administrator’: u’admin’, ‘realm’: None,
‘success’: True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:45:06,050][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /machineresolver/’, ‘serial’: None}
[2016-06-17
14:45:06,351][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,372][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /realm/’, ‘serial’: None}
[2016-06-17
14:45:06,376][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,380][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /smtpserver/’, ‘serial’: None}
[2016-06-17
14:45:06,396][392][140122989238016][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,399][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,400][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /radiusserver/’, ‘serial’: None}
[2016-06-17
14:45:06,412][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,413][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: None, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /system/’, ‘serial’: None}
[2016-06-17
14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’, ‘client_user_agent’:
‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’, ‘action_detail’: ‘’,
‘action’: ‘GET /resolver/’, ‘serial’: None}

Hi Johan,

I have not seen this error, yet.

But it might be probably connected to this:
http://flask-sqlalchemy.pocoo.org/2.1/config/

The SQL Server settings and the TIMEOUT/RECYCLE of the sqlalchemy should
configured to fit.

Kind regards
CorneliusAm Freitag, den 17.06.2016, 06:19 -0700 schrieb jmdeking:

Everytime i login to the webportal i see the amount of mysql processes
grow and not getting killed. Not sure what i can do to remedy this.

@Cornelius, do you have any clue?

On Friday, June 17, 2016 at 3:11:39 PM UTC+2, jmdeking wrote:
Strange i saw a lot of mysqld processes in htop.

    I changed mysql.allow_persistent = On
    in /etc/php5/apache2/php.ini to mysql.allow_persistent = Off
    and restarted apache2 the procesess are gone and the errors
    too.
    
    
    Gonna monitor if the problem is gone.
    
    
    If anyone got a clue on what happend please let me know.
    
    
    
    On Friday, June 17, 2016 at 2:50:13 PM UTC+2, jmdeking wrote:
            Hi There,
            
            
            Suddenly i get the following error on my Privacyidea
            Server: (OperationalError) (1040, 'Too many
            connections') None None
            
            
            Do you have any clue as to what the problem is?
            
            
            Privacyidea version: 2.12.1-1trusty
            
            
            /var/log/privacyidea/privacyidea.log
            
            [2016-06-17
            14:44:56,799][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /resolver/', 'serial': None}
            [2016-06-17
            14:44:57,459][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,473][392][140122980845312][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,474][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,477][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,480][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,480][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,494][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /realm/', 'serial': None}
            [2016-06-17
            14:44:57,484][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,496][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /smtpserver/', 'serial': None}
            [2016-06-17
            14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /radiusserver/', 'serial': None}
            [2016-06-17
            14:44:57,524][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,525][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': None, 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /system/', 'serial': None}
            [2016-06-17
            14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /resolver/', 'serial': None}
            [2016-06-17
            14:45:00,241][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:00,250][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:00,251][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': u'MySQL_Local', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /resolver/<resolver>', 'serial': None}
            [2016-06-17
            14:45:06,050][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /machineresolver/', 'serial': None}
            [2016-06-17
            14:45:06,351][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,372][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /realm/', 'serial': None}
            [2016-06-17
            14:45:06,376][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,380][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /smtpserver/', 'serial': None}
            [2016-06-17
            14:45:06,396][392][140122989238016][INFO][privacyidea.lib.auditmodules.sqlaudit:158] OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,399][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,400][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /radiusserver/', 'serial': None}
            [2016-06-17
            14:45:06,412][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,413][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': None, 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /system/', 'serial': None}
            [2016-06-17
            14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:255] exception OperationalError("(OperationalError) (1040, 'Too many connections')",)
            [2016-06-17
            14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:256] DATA: {'info': '', 'administrator': u'admin', 'realm': None, 'success': True, 'privacyidea_server': 'privacyidea.changed.ch', 'client_user_agent': 'chrome', 'client': '10.200.200.183', 'user': '', 'action_detail': '', 'action': 'GET /resolver/', 'serial': None}


Please read the blog post about getting help
https://www.privacyidea.org/getting-help/.

For professional services and consultancy regarding two factor
authentication please visit
https://netknights.it/en/leistungen/one-time-services/

In an enterprise environment you should get a SERVICE LEVEL AGREEMENT
which suites your needs for SECURITY, AVAILABILITY and LIABILITY:
https://netknights.it/en/leistungen/service-level-agreements/

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.
Visit this group at https://groups.google.com/group/privacyidea.
To view this discussion on the web visit
https://groups.google.com/d/msgid/privacyidea/ee0916e8-3695-42fc-85ff-04e6bf99ba4c%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)

Strange i saw a lot of mysqld processes in htop.

I changed mysql.allow_persistent = On in /etc/php5/apache2/php.ini
to mysql.allow_persistent = Off and restarted apache2 the procesess are
gone and the errors too.

Gonna monitor if the problem is gone.

If anyone got a clue on what happend please let me know.On Friday, June 17, 2016 at 2:50:13 PM UTC+2, jmdeking wrote:

Hi There,

Suddenly i get the following error on my Privacyidea Server:
(OperationalError) (1040, ‘Too many connections’) None None

Do you have any clue as to what the problem is?

Privacyidea version: 2.12.1-1trusty

/var/log/privacyidea/privacyidea.log
[2016-06-17
14:44:56,799][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:44:57,459][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,473][392][140122980845312][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,474][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,477][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,480][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:44:57,480][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,494][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /realm/’, ‘serial’: None}
[2016-06-17
14:44:57,484][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,496][392][140122980845312][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /smtpserver/’, ‘serial’: None}
[2016-06-17
14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,522][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /radiusserver/’, ‘serial’: None}
[2016-06-17
14:44:57,524][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,525][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: None, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /system/’, ‘serial’: None}
[2016-06-17
14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:44:57,538][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:45:00,241][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:00,250][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:00,251][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: u’MySQL_Local’, ‘administrator’: u’admin’, ‘realm’: None,
‘success’: True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /resolver/’, ‘serial’: None}
[2016-06-17
14:45:06,050][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,054][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /machineresolver/’, ‘serial’: None}
[2016-06-17
14:45:06,351][392][140123200538368][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,372][392][140123217331968][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,375][392][140123200538368][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /realm/’, ‘serial’: None}
[2016-06-17
14:45:06,376][392][140123225724672][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,380][392][140123006023424][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,395][392][140123217331968][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /smtpserver/’, ‘serial’: None}
[2016-06-17
14:45:06,396][392][140122989238016][INFO][privacyidea.lib.auditmodules.sqlaudit:158]
OperationalError("(OperationalError) (1040, ‘Too many connections’)",)
[2016-06-17
14:45:06,399][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,400][392][140123225724672][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /radiusserver/’, ‘serial’: None}
[2016-06-17
14:45:06,412][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,413][392][140123006023424][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: None, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /system/’, ‘serial’: None}
[2016-06-17
14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:255]
exception OperationalError("(OperationalError) (1040, ‘Too many
connections’)",)
[2016-06-17
14:45:06,435][392][140122989238016][ERROR][privacyidea.lib.auditmodules.sqlaudit:256]
DATA: {‘info’: ‘’, ‘administrator’: u’admin’, ‘realm’: None, ‘success’:
True, ‘privacyidea_server’: ‘privacyidea.changed.ch’,
‘client_user_agent’: ‘chrome’, ‘client’: ‘10.200.200.183’, ‘user’: ‘’,
‘action_detail’: ‘’, ‘action’: ‘GET /resolver/’, ‘serial’: None}