Да, это изучу. Макс что может быть - 500клиентов запрашивают по 1000 файлов, mp3 шки... по 3-10мб
Но тут я еще почитаю, как rclone проводит запрос/сравнение файлов
Есть новая инфа)) переход на 1Гб у сервака, вместо 100мб вроде решил проблему. По крайней мере по подключениям на https...
сеть поглядел, там много пиков с 300-400мб... скоростью. Клиенты качают файло...
http же щас тупит секунд 30, потом тож норм заходит. Вот тут не ясно
излазил уже логи...
nginx - 1192 open socket #675 left in connection 651, как следствие закрывает коннект
php-fpm - пусто
spoiler
fpm is running, pid 68669
[18-Nov-2021 22:13:37] NOTICE: ready to handle connections
[18-Nov-2021 22:13:37] NOTICE: systemd monitor interval set to 10000ms
[18-Nov-2021 22:13:51] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
Апач - тоже ничего особенного
spoiler
[Thu Nov 18 22:16:06.277675 2021] [mpm_prefork:notice] [pid 69425] AH00163: Apache/2.4.51 (Debian) OpenSSL/1.1.1k configured -- resuming normal operations
[Thu Nov 18 22:16:06.277739 2021] [core:notice] [pid 69425] AH00094: Command line: '/usr/sbin/apache2'
[Thu Nov 18 22:16:28.380875 2021] [mpm_prefork:error] [pid 69425] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
[Thu Nov 18 22:18:57.248773 2021] [mpm_prefork:notice] [pid 69425] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Nov 18 22:18:59.045654 2021] [mpm_prefork:notice] [pid 70323] AH00163: Apache/2.4.51 (Debian) OpenSSL/1.1.1k configured -- resuming normal operations
[Thu Nov 18 22:18:59.045691 2021] [core:notice] [pid 70323] AH00094: Command line: '/usr/sbin/apache2'
[Thu Nov 18 22:19:17.021603 2021] [mpm_prefork:error] [pid 70323] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
Вот смущает, в логах базы...
spoiler
2021-11-18 22:51:25.680 MSK [73927] nextcloud@nextclouddb ERROR: deadlock detected
2021-11-18 22:51:25.680 MSK [73927] nextcloud@nextclouddb DETAIL: Process 73927 waits for ExclusiveLock on tuple (10,53) of relation 22064 of database 21542; blocked by process 74883.
Process 74883 waits for ShareLock on transaction 1156347; blocked by process 74821.
Process 74821 waits for ShareLock on transaction 1156393; blocked by process 73927.
Process 73927: UPDATE "oc_file_locks" SET "lock" = "lock" - '1' WHERE ("key" IN ($1, $2, $3, $4)) AND ("lock" > 0)
Process 74883: UPDATE "oc_file_locks" SET "lock" = "lock" + 1, "ttl" = $1 WHERE "key" = $2 AND "lock" >= 0
Process 74821: UPDATE "oc_file_locks" SET "lock" = "lock" - '1' WHERE ("key" IN ($1, $2, $3, $4)) AND ("lock" > 0)
2021-11-18 22:51:25.680 MSK [73927] nextcloud@nextclouddb HINT: See server log for query details.
2021-11-18 22:51:25.680 MSK [73927] nextcloud@nextclouddb STATEMENT: UPDATE "oc_file_locks" SET "lock" = "lock" - '1' WHERE ("key" IN ($1, $2, $3, $4)) AND ("lock" > 0)
Ну и видимо вот эта ошибка во втором логе апача...
spoiler
[php:error] [pid 70728] [client 62.32.73.98:49608] PHP Fatal error: Uncaught PDOException: SQLSTATE[40P01]: Deadlock detected: 7 ERROR: deadlock detected\nDETAIL: Process 74899 waits for ShareLock on transaction 1157279; blocked by process 75008.\nProcess 75008 waits for ShareLock on transaction 1157067; blocked by process 74899.\nHINT: See server log for query details.\nCONTEXT: while rechecking updated tuple (4,118) in relation "oc_file_locks" in /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:92\nStack trace:\n#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(92): PDOStatement->execute()\n#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1163): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\n#2 /var/www/html/nextcloud/lib/private/DB/Connection.php(267): Doctrine\\DBAL\\Connection->executeStatement()\n#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(354): OC\\DB\\Connection->executeStatement()\n#4 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/html/nextcloud/lib/private/Lock/DBLockingProvider.php(310): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 [internal function]: OC\\Lock\\DBLockingProvider->releaseAll()\n#7 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: SQLSTATE[40P01]: Deadlock detected: 7 ERROR: deadlock detected\nDETAIL: Process 74899 waits for ShareLock on transaction 1157279; blocked by process 75008.\nProcess 75008 waits for ShareLock on transaction 1157067; blocked by process 74899.\nHINT: See server log for query details.\nCONTEXT: while rechecking updated tuple (4,118) in relation "oc_file_locks" in /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:26\nStack trace:\n#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(94): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1163): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\n#2 /var/www/html/nextcloud/lib/private/DB/Connection.php(267): Doctrine\\DBAL\\Connection->executeStatement()\n#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(354): OC\\DB\\Connection->executeStatement()\n#4 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/html/nextcloud/lib/private/Lock/DBLockingProvider.php(310): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 [internal function]: OC\\Lock\\DBLockingProvider->releaseAll()\n#7 {main}\n\nNext Doctrine\\DBAL\\Exception\\DeadlockException: An exception occurred while executing a query: SQLSTATE[40P01]: Deadlock detected: 7 ERROR: deadlock detected\nDETAIL: Process 74899 waits for ShareLock on transaction 1157279; blocked by process 75008.\nProcess 75008 waits for ShareLock on transaction 1157067; blocked by process 74899.\nHINT: See server log for query details.\nCONTEXT: while rechecking updated tuple (4,118) in relation "oc_file_locks" in /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:37\nStack trace:\n#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter->convert()\n#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\\DBAL\\Connection->handleDriverException()\n#2 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1173): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()\n#3 /var/www/html/nextcloud/lib/private/DB/Connection.php(267): Doctrine\\DBAL\\Connection->executeStatement()\n#4 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(354): OC\\DB\\Connection->executeStatement()\n#5 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#6 /var/www/html/nextcloud/lib/private/Lock/DBLockingProvider.php(310): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#7 [internal function]: OC\\Lock\\DBLockingProvider->releaseAll()\n#8 {main}\n thrown in /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php on line 37
Но тут я еще почитаю, как rclone проводит запрос/сравнение файлов