JCM

I still have to take care of this issue every 3 month

I dont see why this is a database problem. Once I restart the nextcloud docker everything works fine until the next day...

I have Nextcloud up and running for some years now. It is paired with a mariadb. For some days now I have to restart the nextcloud container every day, because it can not connect to the db anymore. Both containers are up to date. I could not figure out any reason for that. The mariadb container doesn't have any errors in its logs but the nextcloud container does. Like I said: restarting the nextcloud container fixes the problem, but it occures again every day. Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Operation timed out in /app/www/public/lib/private/DB/Connection.php:155 Stack trace: #0 /app/www/public/3rdparty/doctrine/dbal/src/Connection.php(453): OC\DB\Connection->connect() #1 /app/www/public/3rdparty/doctrine/dbal/src/Connection.php(411): Doctrine\DBAL\Connection->getDatabasePlatformVersion() #2 /app/www/public/3rdparty/doctrine/dbal/src/Connection.php(318): Doctrine\DBAL\Connection->detectDatabasePlatform() #3 /app/www/public/lib/private/DB/ConnectionAdapter.php(200): Doctrine\DBAL\Connection->getDatabasePlatform() #4 /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php(121): OC\DB\ConnectionAdapter->getDatabasePlatform() #5 /app/www/public/lib/private/AppConfig.php(1237): OC\DB\QueryBuilder\QueryBuilder->expr() #6 /app/www/public/lib/private/AppConfig.php(262): OC\AppConfig->loadConfig() #7 /app/www/public/lib/private/AppConfig.php(1378): OC\AppConfig->searchValues() #8 /app/www/public/lib/private/App/AppManager.php(131): OC\AppConfig->getValues() #9 /app/www/public/lib/private/App/AppManager.php(152): OC\App\AppManager->getInstalledAppsValues() #10 /app/www/public/lib/private/legacy/OC_App.php(234): OC\App\AppManager->getInstalledApps() #11 /app/www/public/lib/private/AppFramework/Bootstrap/Coordinator.php(90): OC_App::getEnabledApps() #12 /app/www/public/lib/base.php(706): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration() #13 /app/www/public/lib/base.php(1181): OC::init() #14 /app/www/public/cron.php(58): require_once('...') #15 {main}

I have the exact same issue and your fix helped me successfully renew my certificates manually. Sadly I have no permanent solution for this. I will take a look into this again in May 😉

I have the exact same issue and I can not login. [app ] [9/6/2023] [1:43:57 PM] [Migrate ] › ℹ info Current database version: none [app ] [9/6/2023] [1:43:58 PM] [Global ] › ✖ error Command failed: pip install --no-cache-dir certbot-dns-route53==$(certbot --version | grep -Eo '[0-9](\.[0-9]+)+') [app ] An unexpected error occurred: [app ] pkg_resources.ContextualVersionConflict: (urllib3 2.0.4 (/usr/lib/python3.10/site-packages), Requirement.parse('urllib3<1.27,>=1.25.4'), {'botocore'}) [app ] Ask for help or search for solutions at https://community.letsencrypt.org. See the logfile /tmp/certbot-log-ka2_ng49/log or re-run Certbot with -v for more details. [app ] ERROR: Could not find a version that satisfies the requirement certbot-dns-route53== (from versions: 0.15.0.dev0, 0.15.0, 0.16.0, 0.17.0, 0.18.0, 0.18.1, 0.18.2, 0.19.0, 0.20.0, 0.21.0, 0.21.1, 0.22.0, 0.22.1, 0.22.2, 0.23.0, 0.24.0, 0.25.0, 0.25.1, 0.26.0, 0.26.1, 0.27.0, 0.27.1, 0.28.0, 0.29.0, 0.29.1, 0.30.0, 0.30.1, 0.30.2, 0.31.0, 0.32.0, 0.33.0, 0.33.1, 0.34.0, 0.34.1, 0.34.2, 0.35.0, 0.35.1, 0.36.0, 0.37.0, 0.37.1, 0.37.2, 0.38.0, 0.39.0, 0.40.0, 0.40.1, 1.0.0, 1.1.0, 1.2.0, 1.3.0, 1.4.0, 1.5.0, 1.6.0, 1.7.0, 1.8.0, 1.9.0, 1.10.0, 1.10.1, 1.11.0, 1.12.0, 1.13.0, 1.14.0, 1.15.0, 1.16.0, 1.17.0, 1.18.0, 1.19.0, 1.20.0, 1.21.0, 1.22.0, 1.23.0, 1.24.0, 1.25.0, 1.26.0, 1.27.0, 1.28.0, 1.29.0, 1.30.0, 1.31.0, 1.32.0, 2.0.0, 2.1.0, 2.2.0, 2.3.0, 2.4.0, 2.5.0, 2.6.0) [app ] ERROR: No matching distribution found for certbot-dns-route53== How did you kill the certbot process?

Did that a min ago. No change

Interesting. I don't use any antivir plugins in my browser and the adblocker is disabled for the unraid page. I also tried it in an private firefox session without any plugin enabled but with the same behavior. If you need more information, please ask.

Oh sry. No. I use Firefox 111.0.1 on Windows 11 I checked with MS Edge and it works fine.

The "stats" page is constantly refreshing. I cant click on anything because it reloads every 0,5s or so. Verision 2023.02.14 on Unraid Version: 6.11.5