<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/xhtml; charset=utf-8">
</head>
<body><div style="font-family: sans-serif;"><div class="markdown" style="white-space: normal;">
<p dir="auto">Hi there</p>
<p dir="auto">We have done the upgrade to 6.4.0 and IXP Manager has become super sluggish.</p>
<p dir="auto">At first glance it looked like a sql issue since its maxing the CPU</p>
<p dir="auto">| 1069 | ixpmanager | localhost:60482 | ixpmanager | Execute | 29 | Searching rows for update | update <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">telescope_entries</code> set <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">should_display_on_index</code> = 0 where <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">type</code> = 'exception' and <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">family_ | | 1615 | ixpmanager | localhost:54808 | ixpmanager | Execute | 17 | Searching rows for update | update </code>telescope_entries<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">set</code>should_display_on_index<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 0 where</code>type<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 'exception' and</code>family_ |<br>
| 1730 | ixpmanager | localhost:40512 | ixpmanager | Execute | 4 | Searching rows for update | update <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">telescope_entries</code> set <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">should_display_on_index</code> = 0 where <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">type</code> = 'exception' and <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">family_ | | 1732 | ixpmanager | localhost:58554 | ixpmanager | Sleep | 0 | | NULL | | 1846 | ixpmanager | localhost:53594 | ixpmanager | Execute | 32 | Searching rows for update | update </code>telescope_entries<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">set</code>should_display_on_index<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 0 where</code>type<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 'exception' and</code>family_ |<br>
| 1967 | ixpmanager | localhost:38140 | ixpmanager | Execute | 38 | Searching rows for update | update <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">telescope_entries</code> set <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">should_display_on_index</code> = 0 where <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">type</code> = 'exception' and <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">family_ | | 1968 | ixpmanager | localhost:38150 | ixpmanager | Execute | 35 | Searching rows for update | update </code>telescope_entries<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">set</code>should_display_on_index<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 0 where</code>type<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 'exception' and</code>family_ |<br>
| 1970 | ixpmanager | localhost:37878 | ixpmanager | Execute | 23 | Searching rows for update | update <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">telescope_entries</code> set <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">should_display_on_index</code> = 0 where <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">type</code> = 'exception' and <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">family_ | | 1973 | ixpmanager | localhost:60866 | ixpmanager | Execute | 1 | Searching rows for update | update </code>telescope_entries<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">set</code>should_display_on_index<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 0 where</code>type<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 'exception' and</code>family_ |<br>
| 1975 | ixpmanager | localhost:60882 | ixpmanager | Execute | 40 | updating | update <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">telescope_entries</code> set <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">should_display_on_index</code> = 0 where <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">type</code> = 'exception' and <code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">family_ | | 1976 | ixpmanager | localhost:60894 | ixpmanager | Execute | 34 | Searching rows for update | update </code>telescope_entries<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">set</code>should_display_on_index<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 0 where</code>type<code style="margin: 0 0; padding: 0 0.25em; border-radius: 3px; background-color: #F7F7F7;">= 'exception' and</code>family_ |</p>
<p dir="auto">After digging around some more, there seems to be a lot of errors in the logs, and any command we run seems to generate the below error</p>
<p dir="auto">PHP Warning: Undefined array key "driver" in /srv/ixpmanager/vendor/laravel/framework/src/Illuminate/Log/LogManager.php on line 213<br>
PHP Warning: Undefined array key "driver" in /srv/ixpmanager/vendor/laravel/framework/src/Illuminate/Log/LogManager.php on line 217<br>
PHP Deprecated: ucfirst(): Passing null to parameter #1 ($string) of type string is deprecated in /srv/ixpmanager/vendor/laravel/framework/src/Illuminate/Log/LogManager.php on line 217<br>
PHP Warning: Undefined array key "driver" in /srv/ixpmanager/vendor/laravel/framework/src/Illuminate/Log/LogManager.php on line 223</p>
<p dir="auto">Ive checked, the APP_LOG is either daily or single (I tried both)</p>
<p dir="auto">And Ive cleared the caches in case.</p>
<p dir="auto">PHP version</p>
<p dir="auto">@portal:/srv/ixpmanager# php -v<br>
PHP 8.1.28 (cli) (built: May 23 2024 12:32:40) (NTS)<br>
Copyright (c) The PHP Group<br>
Zend Engine v4.1.28, Copyright (c) Zend Technologies<br>
with Zend OPcache v8.1.28, Copyright (c), by Zend Technologies</p>
<p dir="auto">Anyone have an idea?</p>
<p dir="auto">Kind regards</p>
<p dir="auto">Edd</p>
</div>
</div>
</body>
</html>