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

Question
1

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}

2

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
Getting help – privacyID3A.

For professional services and consultancy regarding two factor
authentication please visit
One Time Services - NetKnights - IT-Sicherheit - Zwei-Faktor-Authentisierung - Verschlüsselung

In an enterprise environment you should get a SERVICE LEVEL AGREEMENT
which suites your needs for SECURITY, AVAILABILITY and LIABILITY:
privacyIDEA Support Level

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)

3

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}