[horde] Horde 5.2.22 performance issues

[Louis-Philippe Allard]

Hello maillist,

I am experiencing severe performance issues on a Horde 5.2.22 setup  
running on Rocky Linux.  Everything is extremely slow (just opening  
horde takes 30sec or more, creating tasks takes 10-20sec, etc)...   
This issue started about 6 months ago and AFAIK its getting worst.

PHP 7.2.34 (cli) (built: Nov 15 2021 08:11:05) ( NTS )
  Copyright (c) 1997-2018 The PHP Group
  Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
      with Zend OPcache v7.2.34, Copyright (c) 1999-2018, by Zend Technologies

Looking at /var/log/horde.log I see these:

   2022-10-26T10:03:22-04:00 WARN: HORDE PHP ERROR:  
mysqli::__construct(): php_network_getaddresses: getaddrinfo failed:  
Name or service not known [pid 1380 on line 135 of  
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
   2022-10-26T10:03:22-04:00 WARN: HORDE PHP ERROR:  
mysqli::__construct(): (HY000/2002): php_network_getaddresses:  
getaddrinfo failed: Name or service not known [pid 1380 on line 135 of  
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
   2022-10-26T10:03:22-04:00 EMERG: HORDE Connect failed: (2002)  
php_network_getaddresses: getaddrinfo failed: Name or service not  
known [pid 1380 on line 138 of  
"/usr/share/pear/Horde/Db/Adapter/Mysqli.php"

I am not sure what Horde is trying to connect to, or where is the  
issue.  The Rocky Linux VM on which Horde runs has pretty much free  
access to the web.  Is it possible to see what address Horde is trying  
to reach when it complains that "Name or service not known"???  That  
would help troubleshooting if this is somehow related to firewalling  
issues,  or MYSQL server issues.....

Then I see these in the logs when I work with Nag, albeit everything  
seems fine from my POV:

  2022-10-26T10:10:30-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Horde_Form_Type_country::init($prompt = NULL) should be compatible  
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 1304 on  
line 0 of "/usr/share/pear/Horde/Form/Type.php"]
  2022-10-26T10:10:30-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Nag_Form_Task::renderActive() should be compatible with  
Horde_Form::renderActive($renderer = NULL, $vars = NULL, $action = '',  
$method = 'get', $enctype = NULL, $focus = true) [pid 1304 on line 17  
of "/var/www/html/horde/nag/lib/Form/Task.php"]
  2022-10-26T10:10:57-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Horde_Form_Type_country::init($prompt = NULL) should be compatible  
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 1305 on  
line 0 of "/usr/share/pear/Horde/Form/Type.php"]
  2022-10-26T10:10:57-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Nag_Form_Task::renderActive() should be compatible with  
Horde_Form::renderActive($renderer = NULL, $vars = NULL, $action = '',  
$method = 'get', $enctype = NULL, $focus = true) [pid 1305 on line 17  
of "/var/www/html/horde/nag/lib/Form/Task.php"]
  2022-10-26T10:10:57-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Horde_Form_Type_country::init($prompt = NULL) should be compatible  
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 1380 on  
line 0 of "/usr/share/pear/Horde/Form/Type.php"]
  2022-10-26T10:10:57-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Nag_Form_Task::renderActive() should be compatible with  
Horde_Form::renderActive($renderer = NULL, $vars = NULL, $action = '',  
$method = 'get', $enctype = NULL, $focus = true) [pid 1380 on line 17  
of "/var/www/html/horde/nag/lib/Form/Task.php"]
  2022-10-26T10:11:16-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Horde_Form_Type_country::init($prompt = NULL) should be compatible  
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 1761 on  
line 0 of "/usr/share/pear/Horde/Form/Type.php"]
  2022-10-26T10:11:16-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Nag_Form_Task::renderActive() should be compatible with  
Horde_Form::renderActive($renderer = NULL, $vars = NULL, $action = '',  
$method = 'get', $enctype = NULL, $focus = true) [pid 1761 on line 17  
of "/var/www/html/horde/nag/lib/Form/Task.php"]
  2022-10-26T10:11:17-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Horde_Form_Type_country::init($prompt = NULL) should be compatible  
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 1303 on  
line 0 of "/usr/share/pear/Horde/Form/Type.php"]
  2022-10-26T10:11:17-04:00 WARN: HORDE [nag] PHP ERROR: Declaration  
of Nag_Form_Task::renderActive() should be compatible with  
Horde_Form::renderActive($renderer = NULL, $vars = NULL, $action = '',  
$method = 'get', $enctype = NULL, $focus = true) [pid 1303 on line 17  
of "/var/www/html/horde/nag/lib/Form/Task.php"]

Same type of errors with Whups:

   2022-10-26T10:18:04-04:00 WARN: HORDE [whups] PHP ERROR:  
Declaration of Horde_Form_Type_country::init($prompt = NULL) should be  
compatible with Horde_Form_Type_enum::init($values, $prompt = NULL)  
[pid 1380 on line 0 of "/usr/share/pear/Horde/Form/Type.php"]
   2022-10-26T10:18:33-04:00 WARN: HORDE [whups] PHP ERROR:  
Declaration of Horde_Form_Type_country::init($prompt = NULL) should be  
compatible with Horde_Form_Type_enum::init($values, $prompt = NULL)  
[pid 1761 on line 0 of "/usr/share/pear/Horde/Form/Type.php"]
   2022-10-26T10:18:33-04:00 WARN: HORDE [whups] PHP ERROR:  
Declaration of Whups_Form_Ticket_CreateStepThree::validate(&$vars,  
$canAutoFill = false) should be compatible with  
Horde_Form::validate($vars = NULL, $canAutoFill = false) [pid 1761 on  
line 0 of  
"/var/www/html/horde/whups/lib/Form/Ticket/CreateStepThree.php"]
   2022-10-26T10:18:36-04:00 WARN: HORDE [whups] PHP ERROR:  
Declaration of Horde_Form_Type_country::init($prompt = NULL) should be  
compatible with Horde_Form_Type_enum::init($values, $prompt = NULL)  
[pid 1307 on line 0 of "/usr/share/pear/Horde/Form/Type.php"]
   2022-10-26T10:18:36-04:00 WARN: HORDE [whups] PHP ERROR:  
Declaration of Whups_Form_Ticket_CreateStepThree::validate(&$vars,  
$canAutoFill = false) should be compatible with  
Horde_Form::validate($vars = NULL, $canAutoFill = false) [pid 1307 on  
line 0 of  
"/var/www/html/horde/whups/lib/Form/Ticket/CreateStepThree.php"]
    

Thanks!
  Louis-Philippe Allard
lp.allard.1 at gmail.com
Sent using Horde Groupware on GNU/Linux