Login

travisbotello · 11-14-2017, 12:57 AM

I am still stuck here. I altered database table according to man page (added primary key) and also checked for extensive session/ajax use, which is not the case. Especially not on the overview/index page that I am using for reference.

For further testing I copied both CI apps to a PHP 7.0 environment and there I don't have these request delays.

Is it possible that these issues are related to Third Party Add-Ons, or modules that use code that isn't supposed to work well with PHP 7.1+? I am having some slowlog entries without session files as well:

Code:
[14-Nov-2017 08:23:40] WARNING: [pool www] child 25464, script '/usr/share/nginx/www/ci/index.php' (request: "GET /index.php") executing too slow (6.277512 sec), logging

Code:
[14-Nov-2017 08:23:40]  [pool www] pid 25464

script_filename = /usr/share/nginx/www/ci/index.php

[0x00007fda53413f00] query() /usr/share/nginx/www/ci/system/database/drivers/pdo/pdo_driver.php:184

[0x00007fda53413e90] _execute() /usr/share/nginx/www/ci/system/database/DB_driver.php:791

[0x00007fda53413e20] simple_query() /usr/share/nginx/www/ci/system/database/DB_driver.php:654

[0x00007fda53413cf0] query() /usr/share/nginx/www/ci/system/database/DB_query_builder.php:1378

[0x00007fda53413c50] get() /usr/share/nginx/www/ci/application/models/User.php:169

[0x00007fda53413be0] profile_info() /usr/share/nginx/www/ci/application/models/User.php:186

[0x00007fda53413b40] avatar_url() /usr/share/nginx/www/ci/application/third_party/MX/Loader.php(353) : eval()'d code:46

[0x00007fda53413340] [INCLUDE_OR_EVAL]() /usr/share/nginx/www/ci/application/third_party/MX/Loader.php:353

[0x00007fda53413230] _ci_load() /usr/share/nginx/www/ci/application/core/MY_Loader.php:19

[0x00007fda53413160] view() /usr/share/nginx/www/ci/application/modules/sidebar/controllers/Sidebar.php:53

[0x00007fda534130d0] top_header() /usr/share/nginx/www/ci/application/third_party/MX/Modules.php:71

[0x00007fda53412fe0] run() /usr/share/nginx/www/ci/application/third_party/MX/Loader.php(353) : eval()'d code:112

[0x00007fda534127b0] [INCLUDE_OR_EVAL]() /usr/share/nginx/www/ci/application/third_party/MX/Loader.php:353

[0x00007fda534126a0] _ci_load() /usr/share/nginx/www/ci/system/core/Loader.php:503

[0x00007fda53412620] file() /usr/share/nginx/www/ci/application/modules/layouts/libraries/Template.php:701

[0x00007fda534124c0] _load_view() /usr/share/nginx/www/ci/application/modules/layouts/libraries/Template.php:259

[0x00007fda534123d0] build() /usr/share/nginx/www/ci/application/modules/welcome/controllers/Welcome.php:54

[0x00007fda53412340] index() /usr/share/nginx/www/ci/system/core/CodeIgniter.php:532

[0x00007fda534120f0] [INCLUDE_OR_EVAL]() /usr/share/nginx/www/ci/index.php:331

The MariaDB Slowlog doesn't have a related entry to this stack...
Maybe it is a server issues, but the fact that I am running a lot of other applications on this PHP 7.1 server as well without any issues I assume it is related to CI in some way.