Sonerezh / sonerezh

A self-hosted, web-based application to stream your music, everywhere.
https://www.sonerezh.bzh
GNU Affero General Public License v3.0
767 stars 122 forks source link

Artist view slow after upgrade from 1.1.3 ( Illegal offset type in I18n.php) #369

Open butlerfr opened 5 years ago

butlerfr commented 5 years ago

Hello

After upgrading sonerezh from v1.1.3 to v1.2.5, I'm facing an issue with the artist tab.

It's much slower than before the upgrade and take 1CPU for many seconds.

With strace I found many call to the error log (and the path off the log): [pid 10330] write(33, "2019-04-18 16:11:20 Warning: War"..., 1831) = 1831 [pid 10330] close(33) = 0 [pid 10330] access("/var/www/sonerezh/app/tmp/logs/error.log", F_OK) = 0 [pid 10330] stat("/var/www/sonerezh/app/tmp/logs/error.log", {st_mode=S_IFREG|0644, st_size=2023534, ...}) = 0 [pid 10330] lstat("/var/www/sonerezh/app/tmp/logs/error.log", {st_mode=S_IFREG|0644, st_size=2023534, ...}) = 0 [pid 10330] open("/var/www/sonerezh/app/tmp/logs/error.log", O_WRONLY|O_CREAT|O_APPEND, 0666) = 33 [pid 10330] fstat(33, {st_mode=S_IFREG|0644, st_size=2023534, ...}) = 0 [pid 10330] lseek(33, 0, SEEK_CUR) = 0 [pid 10330] lseek(33, 0, SEEK_CUR) = 0 [pid 10330] write(33, "2019-04-18 16:11:20 Warning: War"..., 1831) = 1831 [pid 10330] close(33) = 0 [pid 10330] access("/var/www/sonerezh/app/tmp/logs/error.log", F_OK) = 0 [pid 10330] stat("/var/www/sonerezh/app/tmp/logs/error.log", {st_mode=S_IFREG|0644, st_size=2025365, ...}) = 0 [pid 10330] lstat("/var/www/sonerezh/app/tmp/logs/error.log", {st_mode=S_IFREG|0644, st_size=2025365, ...}) = 0 [pid 10330] open("/var/www/sonerezh/app/tmp/logs/error.log", O_WRONLY|O_CREAT|O_APPEND, 0666) = 33

Dans le fichiers de logs je trouve de nombreuses erreurs php: 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in isset or empty in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 234] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:11:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:12:50 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:13:36 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:16:33 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:17:34 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 235] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 238] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 447] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 448] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 240] 2019-04-18 16:21:01 Warning: Warning (2): Illegal offset type in [/var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php, line 260]

ll /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php -rw------- 1 www-data www-data 22K juil. 1 2018 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/I18n/I18n.php

Did I miss something in the upgrade process? (https://www.sonerezh.bzh/user-guides/how-to-upgrade.html) mv sonerezh sonerezh.old wget https://www.sonerezh.bzh/downloads/latest.tar.gz tar -zxf latest.tar.gz rm latest.tar.gz cp -a sonerezh.old/app/Config/database.php sonerezh/app/Config/database.php cp -a sonerezh.old/app/Config/email.php sonerezh/app/Config/email.php chmod -R 600 sonerezh chmod -R u+X sonerezh chown -R www-data:www-data sonerezh

+clean cache and db

butlerfr commented 4 years ago

for information, after a fresh install on debian10 this bug doesn't occur anymore.

may be something wrong with debian8 or php5.6-fpm...