Opened 3 years ago

Closed 3 years ago

#11806 closed Bug/Something is broken (fixed)

'interoc_crm' has exceeded the 'max_user_connections' resource

Reported by: Jackrabbit Owned by: JaimeV
Priority: High Component: Tech
Keywords: Cc:
Sensitive: no

Description

Trying to access CiviCRM this afternoon and got this error dump while trying to send an email blast. Please help. Thanks.

Initialization Error
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => simpleHandler
        )

    [code] => -24
    [message] => DB Error: connect failed
    [mode] => 16
    [debug_info] =>  [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resource (current value: 25)]
    [type] => DB_Error
    [user_info] =>  [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resource (current value: 25)]
    [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resource (current value: 25)]"]
)
backTrace

#0 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/CRM/Core/Error.php(227): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::simpleHandler(Object(DB_Error))
#2 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: connect failed", -24, 16, (Array:2), " [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resou...")
#4 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-24, 16, (Array:2), " [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resou...")
#5 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -24, NULL, NULL, " [nativecode=User 'interoc_crm' has exceeded the 'max_user_connections' resou...", "DB_Error", TRUE)
#6 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB/mysql.php(252): DB_common->raiseError(-24, NULL, NULL, NULL, "User 'interoc_crm' has exceeded the 'max_user_connections' resource (current ...")
#7 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB.php(558): DB_mysql->connect((Array:10), FALSE)
#8 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB/DataObject.php(2294): DB::connect("mysql://interoc_crm:5Pm6BGFskq6RCJ6v6Ger1e@localhost/interoc_crm_civi?new_lin...")
#9 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB/DataObject.php(2526): DB_DataObject->_connect()
#10 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/packages/DB/DataObject.php(411): DB_DataObject->_build_condition((Array:8))
#11 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/CRM/Core/BAO/ConfigSetting.php(202): DB_DataObject->find(TRUE)
#12 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/CRM/Core/Config.php(404): CRM_Core_BAO_ConfigSetting::retrieve((Array:0))
#13 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/CRM/Core/Config.php(197): CRM_Core_Config->_initVariables()
#14 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/drupal/civicrm.module(337): CRM_Core_Config::singleton()
#15 /home/members/interoccupynet/sites/crm.interoccupy.net/web/sites/all/modules/civicrm/drupal/modules/civicrmtheme/civicrmtheme.module(113): civicrm_initialize()
#16 [internal function](): civicrmtheme_custom_theme()
#17 /usr/local/share/drupal-7.43/includes/module.inc(951): call_user_func_array("civicrmtheme_custom_theme", (Array:0))
#18 /usr/local/share/drupal-7.43/includes/menu.inc(1758): module_invoke_all("custom_theme")
#19 /usr/local/share/drupal-7.43/includes/menu.inc(1780): menu_get_custom_theme(TRUE)
#20 /usr/local/share/drupal-7.43/includes/common.inc(5259): menu_set_custom_theme()
#21 /usr/local/share/drupal-7.43/includes/bootstrap.inc(2266): _drupal_bootstrap_full()
#22 /usr/local/share/drupal-7.43/index.php(20): drupal_bootstrap(7)
#23 {main}

Change History (6)

comment:1 Changed 3 years ago by JaimeV

--

Last edited 3 years ago by JaimeV (previous) (diff)

comment:2 Changed 3 years ago by Jackrabbit

We don't have anything to do with the New Press. Is there something that can be done about this? Can the New Press people get contacted? Is it really necessary to update the site index every hour? Can we request that this be set to once a day on off hours?

Last edited 3 years ago by Jackrabbit (previous) (diff)

comment:3 Changed 3 years ago by JaimeV

Sorry that comment was meant for another ticket.

On molina, the main interoccupy.net site seemed to be receiving repeated brute force login attempts. That may have had something to do with the error you received earlier. We are working on a way to ban repeat offending ip's for longer periods of time. Are you still having problems with the crm.interoccupy.net site?

comment:4 Changed 3 years ago by JaimeV

Owner: set to JaimeV
Status: newassigned

comment:5 Changed 3 years ago by JaimeV

Resolution: fixed
Status: assignedfeedback

comment:6 Changed 3 years ago by automatic

Status: feedbackclosed

No news is good news (we hope)! Given the lack of feedback, we think this ticket can be closed.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.