Nextcloud Hub 4 Nextcloud Office "internal server error"

satsuma · July 29, 2023, 10:22am

Nextcloud version (eg, 20.0.5): Nextcloud Hub 4 (26.0.4) All-In-One.
Operating system and version (eg, Ubuntu 20.04): Linux 5.15.0-78-generic x86_64
Apache or nginx version (eg, Apache 2.4.25): not disclosed in admin UI > System. Via ssh, httpd not installed on server (would it see inside the docker images anyway?)
PHP version (eg, 7.4): 8.1.21

The issue you are facing:

Used Nextcloud AIO to install/activate Nextcloud Office. Initial signs were encouraging, resulting in one spreadsheet being readable in a web browser. But an attempted edit in the sheet resulted in a false entry (the edit entered “test”, the resulting data was " 2"). Then the image of the sheet corrupted (a series of purple, green and black fine vertical lines, obscuring the image of the sheet). Then the browser screen went white, except for the text “Internal server error”.

SSH access to the server was still active, so sudo reboot and the browser interface returned.

Second attempt to edit the same sheet resulted in “internal server error” upon opening the sheet.

ssh sudo reboot again.

The third attempt was to create a new spreadsheet from the browser. The mouse click commands appeared accepted, but the browser’s circle-of-dispair just continued. Refreshed the browser = “Internal server error.”

ssh sudo reboot again. Browser back to normal.

Is this the first time you’ve seen this error? Yes. First time Nextcloud Office installed/activated.

The output of your Nextcloud log in Admin > Logging:

These are the latest series of errors listed. The datetime co-incides with the “Internal server error”.


[no app in context] Error: OC\AppFramework\Utility\QueryNotFoundException: Could not resolve listener! Class "listener" does not exist at <<closure>>

 0. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve("listener")
 1. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("listener", true)
 2. /var/www/html/lib/private/AppFramework/DependencyInjection/DIContainer.php line 468
    OC\ServerContainer->query("listener", true)
 3. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\AppFramework\DependencyInjection\DIContainer->query("listener")
 4. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 56
    OC\AppFramework\Utility\SimpleContainer->get("listener")
 5. <<closure>>
    OC\AppFramework\Bootstrap\FunctionInjector->OC\AppFramework\Bootstrap\{closure}("*** sensitive parameters replaced ***")
 6. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 66
    array_map(["Closure"], [["ReflectionPar ... ]])
 7. /var/www/html/lib/private/AppFramework/Bootstrap/BootContext.php line 50
    OC\AppFramework\Bootstrap\FunctionInjector->injectFn([["OCA\\NotifyPu ... "])
 8. /var/www/html/custom_apps/notify_push/lib/AppInfo/Application.php line 70
    OC\AppFramework\Bootstrap\BootContext->injectFn([["OCA\\NotifyPu ... "])
 9. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\NotifyPush\AppInfo\Application->boot(["OC\\AppFramewo ... "])
10. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("notify_push")
11. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("notify_push")
12. /var/www/html/lib/private/Files/SetupManager.php line 132
    OC_App::loadApps(["filesystem"])
13. /var/www/html/lib/private/Files/SetupManager.php line 351
    OC\Files\SetupManager->setupBuiltinWrappers()
14. /var/www/html/lib/private/Files/SetupManager.php line 391
    OC\Files\SetupManager->setupRoot()
15. /var/www/html/lib/private/Files/Mount/Manager.php line 95
    OC\Files\SetupManager->setupForPath("/appdata_ocbd3dwa1q7r/js/core")
16. /var/www/html/lib/private/Files/View.php line 1390
    OC\Files\Mount\Manager->find("/appdata_ocbd3dwa1q7r/js/core")
17. /var/www/html/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo("/appdata_ocbd3dwa1q7r/js/core", false)
18. <<closure>>
    OC\Files\Node\Root->get("/appdata_ocbd3dwa1q7r/js/core")
19. /var/www/html/lib/private/Files/Node/LazyFolder.php line 73
    call_user_func_array([["OC\\Files\\Node\\Root"],"get"], ["appdata_ocbd3dwa1q7r/js/core"])
20. /var/www/html/lib/private/Files/Node/LazyFolder.php line 150
    OC\Files\Node\LazyFolder->__call("get", ["appdata_ocbd3dwa1q7r/js/core"])
21. /var/www/html/lib/private/Files/AppData/AppData.php line 132
    OC\Files\Node\LazyFolder->get("appdata_ocbd3dwa1q7r/js/core")
22. /var/www/html/lib/private/Template/JSCombiner.php line 87
    OC\Files\AppData\AppData->getFolder("core")
23. /var/www/html/lib/private/Template/JSResourceLocator.php line 120
    OC\Template\JSCombiner->process("/var/www/html", "core/js/merged-template-prepend.json", "core")
24. /var/www/html/lib/private/Template/JSResourceLocator.php line 72
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/var/www/html", "core/js/merged-template-prepend.json")
25. /var/www/html/lib/private/Template/ResourceLocator.php line 73
    OC\Template\JSResourceLocator->doFind("core/js/merged-template-prepend")
26. /var/www/html/lib/private/TemplateLayout.php line 377
    OC\Template\ResourceLocator->find(["core/js/common ... "])
27. /var/www/html/lib/private/TemplateLayout.php line 222
    OC\TemplateLayout::findJavascriptFiles(["core/js/common ... "])
28. /var/www/html/lib/private/legacy/OC_Template.php line 182
    OC\TemplateLayout->__construct("error", "")
29. /var/www/html/lib/private/Template/Base.php line 132
    OC_Template->fetchPage()
30. /var/www/html/lib/private/legacy/OC_Template.php line 331
    OC\Template\Base->printPage()
31. /var/www/html/index.php line 74
    OC_Template::printExceptionErrorPage(["Doctrine\\DBAL\\Exception"], 500)

GET /apps/files_versions/preview?file=%2FShared%2Fsync(accs)%2FInventory%20larder.ods&version=1687544573
from 90.255.226.53 at 2023-07-28T12:38:44+00:00

-----

[no app in context] Error: OC\AppFramework\Utility\QueryNotFoundException: Could not resolve externalMountProvider! Class "externalMountProvider" does not exist at <<closure>>

 0. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve("externalMountProvider")
 1. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("externalMountProvider", true)
 2. /var/www/html/lib/private/AppFramework/DependencyInjection/DIContainer.php line 468
    OC\ServerContainer->query("externalMountProvider", true)
 3. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\AppFramework\DependencyInjection\DIContainer->query("externalMountProvider")
 4. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 56
    OC\AppFramework\Utility\SimpleContainer->get("externalMountProvider")
 5. <<closure>>
    OC\AppFramework\Bootstrap\FunctionInjector->OC\AppFramework\Bootstrap\{closure}("*** sensitive parameters replaced ***")
 6. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 66
    array_map(["Closure"], [["ReflectionPar ... "])
 7. /var/www/html/lib/private/AppFramework/Bootstrap/BootContext.php line 50
    OC\AppFramework\Bootstrap\FunctionInjector->injectFn([["OCA\\Files_Sh ... "])
 8. /var/www/html/apps/files_sharing/lib/AppInfo/Application.php line 117
    OC\AppFramework\Bootstrap\BootContext->injectFn([["OCA\\Files_Sh ... "])
 9. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\Files_Sharing\AppInfo\Application->boot(["OC\\AppFramewo ... "])
10. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("files_sharing")
11. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("files_sharing")
12. /var/www/html/lib/private/Files/SetupManager.php line 132
    OC_App::loadApps(["filesystem"])
13. /var/www/html/lib/private/Files/SetupManager.php line 351
    OC\Files\SetupManager->setupBuiltinWrappers()
14. /var/www/html/lib/private/Files/SetupManager.php line 391
    OC\Files\SetupManager->setupRoot()
15. /var/www/html/lib/private/Files/Mount/Manager.php line 95
    OC\Files\SetupManager->setupForPath("/appdata_ocbd3dwa1q7r/js/core")
16. /var/www/html/lib/private/Files/View.php line 1390
    OC\Files\Mount\Manager->find("/appdata_ocbd3dwa1q7r/js/core")
17. /var/www/html/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo("/appdata_ocbd3dwa1q7r/js/core", false)
18. <<closure>>
    OC\Files\Node\Root->get("/appdata_ocbd3dwa1q7r/js/core")
19. /var/www/html/lib/private/Files/Node/LazyFolder.php line 73
    call_user_func_array([["OC\\Files\\Node\\Root"],"get"], ["appdata_ocbd3dwa1q7r/js/core"])
20. /var/www/html/lib/private/Files/Node/LazyFolder.php line 150
    OC\Files\Node\LazyFolder->__call("get", ["appdata_ocbd3dwa1q7r/js/core"])
21. /var/www/html/lib/private/Files/AppData/AppData.php line 132
    OC\Files\Node\LazyFolder->get("appdata_ocbd3dwa1q7r/js/core")
22. /var/www/html/lib/private/Template/JSCombiner.php line 87
    OC\Files\AppData\AppData->getFolder("core")
23. /var/www/html/lib/private/Template/JSResourceLocator.php line 120
    OC\Template\JSCombiner->process("/var/www/html", "core/js/merged-template-prepend.json", "core")
24. /var/www/html/lib/private/Template/JSResourceLocator.php line 72
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/var/www/html", "core/js/merged-template-prepend.json")
25. /var/www/html/lib/private/Template/ResourceLocator.php line 73
    OC\Template\JSResourceLocator->doFind("core/js/merged-template-prepend")
26. /var/www/html/lib/private/TemplateLayout.php line 377
    OC\Template\ResourceLocator->find(["core/js/common ... "])
27. /var/www/html/lib/private/TemplateLayout.php line 222
    OC\TemplateLayout::findJavascriptFiles(["core/js/common ... "])
28. /var/www/html/lib/private/legacy/OC_Template.php line 182
    OC\TemplateLayout->__construct("error", "")
29. /var/www/html/lib/private/Template/Base.php line 132
    OC_Template->fetchPage()
30. /var/www/html/lib/private/legacy/OC_Template.php line 331
    OC\Template\Base->printPage()
31. /var/www/html/index.php line 74
    OC_Template::printExceptionErrorPage(["Doctrine\\DBAL\\Exception"], 500)

GET /apps/files_versions/preview?file=%2FShared%2Fsync(accs)%2FInventory%20larder.ods&version=1687544573
from 90.255.226.53 at 2023-07-28T12:38:43+00:00


-------------


[no app in context] Error: OCP\AppFramework\QueryException: Could not resolve OCA\Files_Versions\Versions\IVersionManager! Class can not be instantiated at <<closure>>

 0. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve("OCA\\Files_Vers ... r")
 1. /var/www/html/lib/private/AppFramework/DependencyInjection/DIContainer.php line 493
    OC\AppFramework\Utility\SimpleContainer->query("OCA\\Files_Vers ... r")
 2. /var/www/html/lib/private/AppFramework/DependencyInjection/DIContainer.php line 465
    OC\AppFramework\DependencyInjection\DIContainer->queryNoFallback("OCA\\Files_Vers ... r")
 3. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\AppFramework\DependencyInjection\DIContainer->query("OCA\\Files_Vers ... r")
 4. /var/www/html/apps/files_versions/lib/AppInfo/Application.php line 148
    OC\AppFramework\Utility\SimpleContainer->get("OCA\\Files_Vers ... r")
 5. /var/www/html/apps/files_versions/lib/AppInfo/Application.php line 135
    OCA\Files_Versions\AppInfo\Application->loadBackend([["OCP\\Files\\S ... "], ["OC\\AppFramewo ... "], ["OC\\AppFramework\\ScopedPsrLogger"])
 6. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 66
    OCA\Files_Versions\AppInfo\Application->registerVersionBackends(["OC\\AppFramewo ... "], ["OC\\App\\AppManager"], ["OC\\AppFramework\\ScopedPsrLogger"])
 7. /var/www/html/lib/private/AppFramework/Bootstrap/BootContext.php line 50
    OC\AppFramework\Bootstrap\FunctionInjector->injectFn(["Closure"])
 8. /var/www/html/apps/files_versions/lib/AppInfo/Application.php line 125
    OC\AppFramework\Bootstrap\BootContext->injectFn(["Closure"])
 9. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\Files_Versions\AppInfo\Application->boot(["OC\\AppFramewo ... "])
10. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("files_versions")
11. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("files_versions")
12. /var/www/html/apps/dav/lib/AppInfo/Application.php line 205
    OC_App::loadApps(["dav"])
13. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\DAV\AppInfo\Application->boot(["OC\\AppFramewo ... "])
14. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("dav")
15. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("dav")
16. /var/www/html/lib/private/Files/SetupManager.php line 132
    OC_App::loadApps(["filesystem"])
17. /var/www/html/lib/private/Files/SetupManager.php line 351
    OC\Files\SetupManager->setupBuiltinWrappers()
18. /var/www/html/lib/private/Files/SetupManager.php line 391
    OC\Files\SetupManager->setupRoot()
19. /var/www/html/lib/private/Files/Mount/Manager.php line 95
    OC\Files\SetupManager->setupForPath("/appdata_ocbd3dwa1q7r/js/core")
20. /var/www/html/lib/private/Files/View.php line 1390
    OC\Files\Mount\Manager->find("/appdata_ocbd3dwa1q7r/js/core")
21. /var/www/html/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo("/appdata_ocbd3dwa1q7r/js/core", false)
22. <<closure>>
    OC\Files\Node\Root->get("/appdata_ocbd3dwa1q7r/js/core")
23. /var/www/html/lib/private/Files/Node/LazyFolder.php line 73
    call_user_func_array([["OC\\Files\\Node\\Root"],"get"], ["appdata_ocbd3dwa1q7r/js/core"])
24. /var/www/html/lib/private/Files/Node/LazyFolder.php line 150
    OC\Files\Node\LazyFolder->__call("get", ["appdata_ocbd3dwa1q7r/js/core"])
25. /var/www/html/lib/private/Files/AppData/AppData.php line 132
    OC\Files\Node\LazyFolder->get("appdata_ocbd3dwa1q7r/js/core")
26. /var/www/html/lib/private/Template/JSCombiner.php line 87
    OC\Files\AppData\AppData->getFolder("core")
27. /var/www/html/lib/private/Template/JSResourceLocator.php line 120
    OC\Template\JSCombiner->process("/var/www/html", "core/js/merged-template-prepend.json", "core")
28. /var/www/html/lib/private/Template/JSResourceLocator.php line 72
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/var/www/html", "core/js/merged-template-prepend.json")
29. /var/www/html/lib/private/Template/ResourceLocator.php line 73
    OC\Template\JSResourceLocator->doFind("core/js/merged-template-prepend")
30. /var/www/html/lib/private/TemplateLayout.php line 377
    OC\Template\ResourceLocator->find(["core/js/common ... "])
31. /var/www/html/lib/private/TemplateLayout.php line 222
    OC\TemplateLayout::findJavascriptFiles(["core/js/common ... "])
32. /var/www/html/lib/private/legacy/OC_Template.php line 182
    OC\TemplateLayout->__construct("error", "")
33. /var/www/html/lib/private/Template/Base.php line 132
    OC_Template->fetchPage()
34. /var/www/html/lib/private/legacy/OC_Template.php line 331
    OC\Template\Base->printPage()
35. /var/www/html/index.php line 74
    OC_Template::printExceptionErrorPage(["Doctrine\\DBAL\\Exception"], 500)

GET /apps/files_versions/preview?file=%2FShared%2Fsync(accs)%2FInventory%20larder.ods&version=1687544573
from 90.255.226.53 at 2023-07-28T12:38:43+00:00

------------

[no app in context] Error: OC\AppFramework\Utility\QueryNotFoundException: Could not resolve trashManager! Class "trashManager" does not exist at <<closure>>

 0. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 142
    OC\AppFramework\Utility\SimpleContainer->resolve("trashManager")
 1. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("trashManager", true)
 2. /var/www/html/lib/private/AppFramework/DependencyInjection/DIContainer.php line 468
    OC\ServerContainer->query("trashManager", true)
 3. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\AppFramework\DependencyInjection\DIContainer->query("trashManager")
 4. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 56
    OC\AppFramework\Utility\SimpleContainer->get("trashManager")
 5. <<closure>>
    OC\AppFramework\Bootstrap\FunctionInjector->OC\AppFramework\Bootstrap\{closure}("*** sensitive parameters replaced ***")
 6. /var/www/html/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 66
    array_map(["Closure"], [["ReflectionPar ... "])
 7. /var/www/html/lib/private/AppFramework/Bootstrap/BootContext.php line 50
    OC\AppFramework\Bootstrap\FunctionInjector->injectFn([["OCA\\Files_Tr ... "])
 8. /var/www/html/apps/files_trashbin/lib/AppInfo/Application.php line 61
    OC\AppFramework\Bootstrap\BootContext->injectFn([["OCA\\Files_Tr ... "])
 9. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\Files_Trashbin\AppInfo\Application->boot(["OC\\AppFramewo ... "])
10. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("files_trashbin")
11. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("files_trashbin")
12. /var/www/html/apps/dav/lib/AppInfo/Application.php line 205
    OC_App::loadApps(["dav"])
13. /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php line 200
    OCA\DAV\AppInfo\Application->boot(["OC\\AppFramewo ... "])
14. /var/www/html/lib/private/legacy/OC_App.php line 213
    OC\AppFramework\Bootstrap\Coordinator->bootApp("dav")
15. /var/www/html/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("dav")
16. /var/www/html/lib/private/Files/SetupManager.php line 132
    OC_App::loadApps(["filesystem"])
17. /var/www/html/lib/private/Files/SetupManager.php line 351
    OC\Files\SetupManager->setupBuiltinWrappers()
18. /var/www/html/lib/private/Files/SetupManager.php line 391
    OC\Files\SetupManager->setupRoot()
19. /var/www/html/lib/private/Files/Mount/Manager.php line 95
    OC\Files\SetupManager->setupForPath("/appdata_ocbd3dwa1q7r/js/core")
20. /var/www/html/lib/private/Files/View.php line 1390
    OC\Files\Mount\Manager->find("/appdata_ocbd3dwa1q7r/js/core")
21. /var/www/html/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo("/appdata_ocbd3dwa1q7r/js/core", false)
22. <<closure>>
    OC\Files\Node\Root->get("/appdata_ocbd3dwa1q7r/js/core")
23. /var/www/html/lib/private/Files/Node/LazyFolder.php line 73
    call_user_func_array([["OC\\Files\\Node\\Root"],"get"], ["appdata_ocbd3dwa1q7r/js/core"])
24. /var/www/html/lib/private/Files/Node/LazyFolder.php line 150
    OC\Files\Node\LazyFolder->__call("get", ["appdata_ocbd3dwa1q7r/js/core"])
25. /var/www/html/lib/private/Files/AppData/AppData.php line 132
    OC\Files\Node\LazyFolder->get("appdata_ocbd3dwa1q7r/js/core")
26. /var/www/html/lib/private/Template/JSCombiner.php line 87
    OC\Files\AppData\AppData->getFolder("core")
27. /var/www/html/lib/private/Template/JSResourceLocator.php line 120
    OC\Template\JSCombiner->process("/var/www/html", "core/js/merged-template-prepend.json", "core")
28. /var/www/html/lib/private/Template/JSResourceLocator.php line 72
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/var/www/html", "core/js/merged-template-prepend.json")
29. /var/www/html/lib/private/Template/ResourceLocator.php line 73
    OC\Template\JSResourceLocator->doFind("core/js/merged-template-prepend")
30. /var/www/html/lib/private/TemplateLayout.php line 377
    OC\Template\ResourceLocator->find(["core/js/common ... "])
31. /var/www/html/lib/private/TemplateLayout.php line 222
    OC\TemplateLayout::findJavascriptFiles(["core/js/common ... "])
32. /var/www/html/lib/private/legacy/OC_Template.php line 182
    OC\TemplateLayout->__construct("error", "")
33. /var/www/html/lib/private/Template/Base.php line 132
    OC_Template->fetchPage()
34. /var/www/html/lib/private/legacy/OC_Template.php line 331
    OC\Template\Base->printPage()
35. /var/www/html/index.php line 74
    OC_Template::printExceptionErrorPage(["Doctrine\\DBAL\\Exception"], 500)

GET /apps/files_versions/preview?file=%2FShared%2Fsync(accs)%2FInventory%20larder.ods&version=1687544573
from 90.255.226.53 at 2023-07-28T12:38:43+00:00

--------


[index] Error: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "nextcloud-aio-database" (172.18.0.4), port 5432 failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections at <<closure>>

 0. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1531
    OC\DB\Connection->connect()
 1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1029
    Doctrine\DBAL\Connection->getWrappedConnection()
 2. /var/www/html/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery("SELECT * FROM \"oc_appconfig\"", [], [], null)
 3. /var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery("SELECT * FROM \"oc_appconfig\"", [], [])
 4. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/html/lib/private/AppConfig.php line 418
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/html/lib/private/AppConfig.php line 184
    OC\AppConfig->loadConfigValues()
 7. /var/www/html/lib/private/AppConfig.php line 374
    OC\AppConfig->getApps()
 8. /var/www/html/lib/private/legacy/OC_App.php line 976
    OC\AppConfig->getValues(false, "installed_version")
 9. /var/www/html/lib/private/Server.php line 731
    OC_App::getAppVersions()
10. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 171
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
11. /var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php line 122
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
12. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 138
    Pimple\Container->offsetGet("OC\\Memcache\\Factory")
13. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("OC\\Memcache\\Factory", true)
14. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\ServerContainer->query("OC\\Memcache\\Factory")
15. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 193
    OC\AppFramework\Utility\SimpleContainer->get("OC\\Memcache\\Factory")
16. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
17. /var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php line 118
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
18. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 138
    Pimple\Container->offsetGet("OCP\\ICacheFactory")
19. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("OCP\\ICacheFactory", true)
20. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\ServerContainer->query("OCP\\ICacheFactory")
21. /var/www/html/lib/private/Server.php line 1112
    OC\AppFramework\Utility\SimpleContainer->get("OCP\\ICacheFactory")
22. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 171
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
23. /var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php line 122
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
24. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 138
    Pimple\Container->offsetGet("OCP\\Lock\\ILockingProvider")
25. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("OCP\\Lock\\ILockingProvider", true)
26. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\ServerContainer->query("OCP\\Lock\\ILockingProvider")
27. /var/www/html/lib/private/Server.php line 2067
    OC\AppFramework\Utility\SimpleContainer->get("OCP\\Lock\\ILockingProvider")
28. /var/www/html/lib/private/Files/View.php line 119
    OC\Server->getLockingProvider()
29. /var/www/html/lib/private/Server.php line 465
    OC\Files\View->__construct()
30. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 171
    OC\Server->OC\{closure}("*** sensitive parameters replaced ***")
31. /var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php line 122
    OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}("*** sensitive parameters replaced ***")
32. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 138
    Pimple\Container->offsetGet("OC\\Files\\Node\\HookConnector")
33. /var/www/html/lib/private/ServerContainer.php line 171
    OC\AppFramework\Utility\SimpleContainer->query("OC\\Files\\Node\\HookConnector", true)
34. /var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php line 65
    OC\ServerContainer->query("OC\\Files\\Node\\HookConnector")
35. /var/www/html/lib/private/Server.php line 1469
    OC\AppFramework\Utility\SimpleContainer->get("OC\\Files\\Node\\HookConnector")
36. /var/www/html/lib/base.php line 632
    OC\Server->boot()
37. /var/www/html/lib/base.php line 1174
    OC::init()
38. /var/www/html/index.php line 34
    require_once("/var/www/html/lib/base.php")

GET /apps/files_versions/preview?file=%2FShared%2Fsync(accs)%2FInventory%20larder.ods&version=1687544573
from 90.255.226.53 at 2023-07-28T12:38:43+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

Can’t see /path/to/nextcloud in the AIO installation.

The output of your Apache/nginx/system log in /var/log/____:

No such files in /var/log/ in this AIO instance.

szaimen · July 29, 2023, 11:35am

Hi, see Internal error server · nextcloud/all-in-one · Discussion #3056 · GitHub

satsuma · July 29, 2023, 4:06pm

What is the path to config.php?

user@server:~$ ls /
bin dev home lib32 libx32 media opt root sbin srv tmp var
boot etc lib lib64 lost+found mnt proc run snap sys usr
user@server:~$

szaimen · July 30, 2023, 12:19am

See GitHub - nextcloud/all-in-one: Nextcloud AIO stands for Nextcloud All-in-One and provides easy deployment and maintenance with most features included in this one Nextcloud instance.

satsuma · July 30, 2023, 1:23pm

Thank you for your prompt reply.

Sadly, it had either no, or insufficient, effect. Testing log below.

202307301205Z Nextcloud AIO running normally, reports “Your containers are up to date.”

202307301207Z sudo docker run -it --rm --volume nextcloud_aio_nextcloud:/var/www/html:rw alpine sh -c “apk add --no-cache nano && nano /var/www/html/config/config.php”

202307301209Z nano reports “persistent” not found. Added string as instructed as a sibling of property ‘dbuser’. Saved, re-loaded, nano succesfully found “persistent”.

202307301211Z sudo reboot. Wait.

202307301215Z ssh login successful. Server is alive.

202307301216Z web interface login successful, as admin user. AIO web interface reports all containers running (Apache, Database, Nextcloud, Notify Push, Redis, Collabora).

202307301218Z log out of web interface as admin.

202307301219Z log into web interface as user.

202307301219Z at https://nextcloud.(hostname)/apps/dashboard/#/, recommend files includes two .md files and at least two .ods files. (Note: it took a few seconds for the icons to appear to the left of the filenames).

202307301221Z On web interface, opened one of the .md files, to test basic server operation without Nextcloud Office. Server asked which version to use, “current” or “saved”, opted for “saved” as this is the latest version. Added new text, “Test edit” to end of file.

202307301223Z On Android app, opened file. No question about “current” or “saved”; Android app correctly produces the latest version, with the test edit. Suffixed “thanks” to test edit.

202307301225Z On web interface, refreshed https://nextcloud.(hostname)/apps/dashboard/#/ . Re-opened .md file. No current v saved question; file opened in web interface, looks normal.

202307301228Z On web interface, opened an .ods file. File opens in browser window. Looks encouraging.

202307301231Z Test edit into a cell. App entry bar updates immediately as normal, but the local area of the main pane is now obscured by green/purple fuzz (ss202307301230Z nextcloud office ods screen fuzz.png). The fuzz changes shape when the focus moves between the browser and other local apps (e.g. the text editor used to record this log).

202307301232Z Hit return to accept test edit into the cell. Fuzz disappears (!), it now looks like the cell has been correctly edited.

202307301233Z Repeat test for a second cell. Same fuzz happens, “ss202307301235Z nextcloud office ods screen fuzz v2.png” and “ss202307301237Z nextcloud office ods screen fuzz v2a.png”. Hit return. Extended test to edit this second cell. Again, no fuzz until the user starts to type something. Again, when the fuzz appears, it’s different (“ss202307301240Z nextcloud office ods screen fuzz v3”).

202307301241Z Browser screen notes, “Last saved 1m ago”. This is normal, and encouraging. Closed browser child window (x in the top-left corner). Browser returns to https://nextcloud.(hostname)/apps/dashboard/#/ .

202307301242Z the next test is to create a file from within the file structure via the web interface. On navigating through the folder structure by mouse, the server returns multiple errors, “ss202307301243Z this directory is unavailable.png”.

202307301245Z invoked command by mouse to create a new spreadsheet, named “test new sheet.ods”. No change to screen. Server is still alive. Used the find facility to find “test”, found one unrelated file. Finding: new sheet did not create.

202307301248Z navigated back to folder structure. Screen goes barmy: endless errors stream down the right-hand side of the screen, “ss202307301251Z this directory is unavailable en masse.png”.

202307301251Z closed browser window. Logged in again as the same user. Internal server error, “ss202307301254Z internal server error.png”.

202307301254Z ssh is still active. In the time it took to document the above screenshots, test whether server has recovered. Yes, it has: successful login to web interface by the user, landed at https://nextcloud.(hostname)/apps/dashboard/. Attempt to navigate folder structure by mouse: browser accepted command, but no results after 20 seconds.

202307301258Z User attempted to log out via web interface by mouse. Browser accepted command, but no response. Refreshed browser. Browser accepted command, but no response.

202307301301Z ssh is still active. Closed browser.

202307301402Z Attempted to log into web interface as admin user. Browser received no response. Attempted to log into AIO interface directly, which successfully returned the “this login is blocked since Nextcloud is running”.

202307301305Z Via ssh, sudo docker stop nextcloud-aio-apache.

202307301306Z Successfully logged into AIO web interface. Container Apache is stopped, the others are running. Stopped all containers. Wait.

202307301208Z Via AIO web interface, started all containers. Wait.

202307301309Z AIO web interface reports all containers started. Logged out of AIO web interface.

202307301310Z Successfully logged into Nextcloud web interface as admin user. https://nextcloud.(hostname)/settings/admin/overview reports two security & setup warning (both of which are normal): i) no email service configured; ii) no default phone region set.

202307301312Z https://nextcloud.(hostname)/settings/admin/logging reports no entries for the above. The latest entries are dated 202307291449Z. The last entry was:

[richdocuments] Error: GuzzleHttp\Exception\ConnectException: cURL error 35: OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to nextcloud.(hostname):443  (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://nextcloud.(hostname)/hosting/capabilities at <<closure>>

 0. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php line 158
    GuzzleHttp\Handler\CurlFactory::createRejection("*** sensitive parameters replaced ***")
 1. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php line 110
    GuzzleHttp\Handler\CurlFactory::finishError(["GuzzleHttp\\Handler\\CurlHandler"], "*** sensitive parameters replaced ***", ["GuzzleHttp\\Handler\\CurlFactory"])
 2. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Handler/CurlHandler.php line 47
    GuzzleHttp\Handler\CurlFactory::finish(["GuzzleHttp\\Handler\\CurlHandler"], "*** sensitive parameters replaced ***", ["GuzzleHttp\\Handler\\CurlFactory"])
 3. /var/www/html/lib/private/Http/Client/DnsPinMiddleware.php line 114
    GuzzleHttp\Handler\CurlHandler->__invoke("*** sensitive parameters replaced ***", "*** sensitive parameters replaced ***")
 4. /var/www/html/3rdparty/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php line 35
    OC\Http\Client\DnsPinMiddleware->OC\Http\Client\{closure}("*** sensitive parameters replaced ***")
 5. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Middleware.php line 31
    GuzzleHttp\PrepareBodyMiddleware->__invoke("*** sensitive parameters replaced ***", "*** sensitive parameters replaced ***")
 6. /var/www/html/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php line 71
    GuzzleHttp\Middleware::GuzzleHttp\{closure}("*** sensitive parameters replaced ***")
 7. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Middleware.php line 63
    GuzzleHttp\RedirectMiddleware->__invoke("*** sensitive parameters replaced ***", "*** sensitive parameters replaced ***")
 8. /var/www/html/3rdparty/guzzlehttp/guzzle/src/HandlerStack.php line 75
    GuzzleHttp\Middleware::GuzzleHttp\{closure}("*** sensitive parameters replaced ***")
 9. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Client.php line 331
    GuzzleHttp\HandlerStack->__invoke("*** sensitive parameters replaced ***", "*** sensitive parameters replaced ***")
10. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Client.php line 168
    GuzzleHttp\Client->transfer("*** sensitive parameters replaced ***", "*** sensitive parameters replaced ***")
11. /var/www/html/3rdparty/guzzlehttp/guzzle/src/Client.php line 187
    GuzzleHttp\Client->requestAsync("*** sensitive parameters replaced ***")
12. /var/www/html/lib/private/Http/Client/Client.php line 226
    GuzzleHttp\Client->request("*** sensitive parameters replaced ***", "https://nextclo ... s", ["/mnt/ncdata/fi ... e])
13. /var/www/html/custom_apps/richdocuments/lib/Service/CapabilitiesService.php line 135
    OC\Http\Client\Client->get("https://nextclo ... s", [45,[true]])
14. /var/www/html/custom_apps/richdocuments/lib/Backgroundjobs/ObtainCapabilities.php line 40
    OCA\Richdocuments\Service\CapabilitiesService->refetch()
15. /var/www/html/lib/private/BackgroundJob/Job.php line 54
    OCA\Richdocuments\Backgroundjobs\ObtainCapabilities->run(null)
16. /var/www/html/lib/private/BackgroundJob/TimedJob.php line 60
    OC\BackgroundJob\Job->execute(["OC\\BackgroundJob\\JobList"], ["OC\\Log"])
17. /var/www/html/cron.php line 152
    OC\BackgroundJob\TimedJob->execute(["OC\\BackgroundJob\\JobList"], ["OC\\Log"])

at 2023-07-29T15:49:03+00:00

202307301316Z Tidy-up testing part 1. On Android app, Nextcloud successfully launches the edited .ods file. All three edits in both cells are visible.

202307301317Z Tidy-up testing part 2. On desktop, Nextcloud sync agent launched. Successfully launched the edited .ods file. All three edits in both cells are visible.

202307301419Z Bundle up above test documentation and paste into community ticket.

What is the next step?

ss202307301230Z nextcloud office ods screen fuzz
ss202307301235Z nextcloud office ods screen fuzz v2
ss202307301237Z nextcloud office ods screen fuzz v2a
ss202307301240Z nextcloud office ods screen fuzz v3
ss202307301243Z this directory is unavailable

satsuma · August 2, 2023, 1:50pm

The server has just successfully uploaded some jpg files via the Android app. Then, when attempting to save an .md file from a desktop to the server via the desktop sync app, the file did not sync on the server to become visible on the Android app.

The desktop sync agent, and the web browser portal, both report “internal server error”.

So this means the server is unstable in some way. Nextcloud Office didn’t trigger this “internal server error”, but the errors have only appeared since installing Nextcloud Office via the AIO interface.

In the time taken to type this entry, the server has righted itself: the Android app just synced the new .md file on its file browser and the normal browser interface appears. But the .md file doesn’t show in the Android app. Instead, the Android app reports, “Malformed server configuration.” Very bizarre.

satsuma · August 3, 2023, 12:26pm

Here is the AIO log, don’t know whether it helps. I did a sudo reboot at 1406 02Aug2023.

How do I get PHP and Apache logs from AIO?

Trying to fix docker.sock permissions internally...
Adding internal www-data to group ping
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
{"level":"info","ts":1690546991.066341,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
[Fri Jul 28 12:23:11.077675 2023] [mpm_event:notice] [pid 100:tid 139785394309960] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[Fri Jul 28 12:23:11.078677 2023] [core:notice] [pid 100:tid 139785394309960] AH00094: Command line: 'httpd -D FOREGROUND'
[28-Jul-2023 12:23:11] NOTICE: fpm is running, pid 104
[28-Jul-2023 12:23:11] NOTICE: ready to handle connections
Deleting duplicate sessions
[28-Jul-2023 12:45:41] NOTICE: Terminating ...
[28-Jul-2023 12:45:41] NOTICE: exiting, bye-bye!
[Fri Jul 28 12:45:45.248101 2023] [mpm_event:notice] [pid 100:tid 139785394309960] AH00491: caught SIGTERM, shutting down
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
{"level":"info","ts":1690548413.2569067,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
[Fri Jul 28 12:46:53.323888 2023] [mpm_event:notice] [pid 93:tid 140698928229192] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[Fri Jul 28 12:46:53.325913 2023] [core:notice] [pid 93:tid 140698928229192] AH00094: Command line: 'httpd -D FOREGROUND'
[28-Jul-2023 12:46:53] NOTICE: fpm is running, pid 97
[28-Jul-2023 12:46:53] NOTICE: ready to handle connections
[28-Jul-2023 13:02:01] NOTICE: Terminating ...
[28-Jul-2023 13:02:01] NOTICE: exiting, bye-bye!
[Fri Jul 28 13:02:05.577036 2023] [mpm_event:notice] [pid 93:tid 140698928229192] AH00491: caught SIGTERM, shutting down
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
{"level":"info","ts":1690549420.452508,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
[28-Jul-2023 13:03:40] NOTICE: fpm is running, pid 97
[28-Jul-2023 13:03:40] NOTICE: ready to handle connections
[Fri Jul 28 13:03:40.532624 2023] [mpm_event:notice] [pid 93:tid 140464585825096] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[Fri Jul 28 13:03:40.533091 2023] [core:notice] [pid 93:tid 140464585825096] AH00094: Command line: 'httpd -D FOREGROUND'
{"level":"error","ts":1690550281.0020094,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.009681,"max_duration":2592000}
{"level":"error","ts":1690550341.004241,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.011913605,"max_duration":2592000}
{"level":"error","ts":1690589483.9387698,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.005671196,"max_duration":2592000}
{"level":"error","ts":1690589543.9480367,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.014937618,"max_duration":2592000}
{"level":"error","ts":1690596580.1436927,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.009967804,"max_duration":2592000}
{"level":"error","ts":1690596640.1495395,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.01581754,"max_duration":2592000}
Deleted Images:
untagged: nextcloud/aio-nextcloud@sha256:999ebf29ca1eb0936dee548f11050f1e074310588e93c159bd78073bd9151ca3
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
untagged: nextcloud/aio-notify-push@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
untagged: nextcloud/aio-watchtower@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
untagged: nextcloud/aio-postgresql@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
untagged: nextcloud/aio-redis@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
untagged: nextcloud/aio-apache@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]

untagged: nextcloud/aio-borgbackup@sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]
deleted: sha256:[...]


Total reclaimed space: 959.2MB
[29-Jul-2023 15:47:45] NOTICE: Terminating ...
[29-Jul-2023 15:47:45] NOTICE: exiting, bye-bye!
[Sat Jul 29 15:47:48.679102 2023] [mpm_event:notice] [pid 93:tid 140464585825096] AH00491: caught SIGTERM, shutting down
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
{"level":"info","ts":1690645726.1269703,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
[29-Jul-2023 15:48:46] NOTICE: fpm is running, pid 97
[29-Jul-2023 15:48:46] NOTICE: ready to handle connections
[Sat Jul 29 15:48:46.155089 2023] [mpm_event:notice] [pid 93:tid 140557124414280] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[Sat Jul 29 15:48:46.157016 2023] [core:notice] [pid 93:tid 140557124414280] AH00094: Command line: 'httpd -D FOREGROUND'
{"level":"error","ts":1690685343.2341936,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.017738491,"max_duration":2592000}
{"level":"error","ts":1690685403.239932,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.023478565,"max_duration":2592000}
Total reclaimed space: 0B
Deleting duplicate sessions
[30-Jul-2023 12:11:39] NOTICE: Terminating ...
[30-Jul-2023 12:11:39] NOTICE: exiting, bye-bye!
[Sun Jul 30 12:11:42.046154 2023] [mpm_event:notice] [pid 93:tid 140557124414280] AH00491: caught SIGTERM, shutting down
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
[Sun Jul 30 12:13:50.880227 2023] [mpm_event:notice] [pid 92:tid 140703028644680] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[30-Jul-2023 12:13:50] NOTICE: fpm is running, pid 96
[30-Jul-2023 12:13:50] NOTICE: ready to handle connections
[Sun Jul 30 12:13:50.888482 2023] [core:notice] [pid 92:tid 140703028644680] AH00094: Command line: 'httpd -D FOREGROUND'
{"level":"info","ts":1690719230.931868,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
Deleting duplicate sessions
Deleting duplicate sessions
{"level":"error","ts":1690770317.1991186,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.01265895,"max_duration":2592000}
{"level":"error","ts":1690770377.2018337,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.015384922,"max_duration":2592000}
Total reclaimed space: 0B
{"level":"error","ts":1690795219.2199824,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.001838825,"max_duration":2592000}
{"level":"error","ts":1690795279.2225542,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.004410061,"max_duration":2592000}
{"level":"error","ts":1690818183.9997447,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.013954065,"max_duration":2592000}
{"level":"error","ts":1690818244.0029821,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.0173859,"max_duration":2592000}
{"level":"error","ts":1690851634.221834,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.010345325,"max_duration":2592000}
{"level":"error","ts":1690851694.2236714,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.012186009,"max_duration":2592000}
{"level":"error","ts":1690856728.5892434,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.000987048,"max_duration":2592000}
{"level":"error","ts":1690856788.5906892,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.002429748,"max_duration":2592000}
{"level":"error","ts":1690860874.7437284,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.010867294,"max_duration":2592000}
{"level":"error","ts":1690860934.7491412,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.01643854,"max_duration":2592000}
Total reclaimed space: 0B
{"level":"error","ts":1690942705.3943768,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.023687876,"max_duration":2592000}
{"level":"error","ts":1690942765.3974338,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.026750507,"max_duration":2592000}
Total reclaimed space: 0B
{"level":"error","ts":1690954606.2163448,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.007079223,"max_duration":2592000}
{"level":"error","ts":1690954666.2198477,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.010728155,"max_duration":2592000}
{"level":"error","ts":1690976872.1512766,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.007216737,"max_duration":2592000}
{"level":"error","ts":1690976932.15527,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.011589813,"max_duration":2592000}
Deleting duplicate sessions
NOTICE: PHP message: 404 Not Found
Type: Slim\Exception\HttpNotFoundException

4
Message: Not found.
File: /var/www/docker-aio/php/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php
Line: 76
Trace: #0 /var/www/docker-aio/php/vendor/slim/slim/Slim/Routing/RouteRunner.php(56): Slim\Middleware\RoutingMiddleware->performRouting(Object(GuzzleHttp\Psr7\ServerRequest))
#1 /var/www/docker-aio/php/vendor/slim/csrf/src/Guard.php(476): Slim\Routing\RouteRunner->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#2 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Slim\Csrf\Guard->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Slim\Routing\RouteRunner))
#3 /var/www/docker-aio/php/vendor/slim/twig-view/src/TwigMiddleware.php(115): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#4 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Views\TwigMiddleware->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#5 /var/www/docker-aio/php/src/Middleware/AuthMiddleware.php(38): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#6 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): AIO\Middleware\AuthMiddleware->__invoke(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#7 /var/www/docker-aio/php/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#8 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#9 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#10 /var/www/docker-aio/php/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#11 /var/www/docker-aio/php/vendor/slim/slim/Slim/App.php(183): Slim\App->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#12 /var/www/docker-aio/php/public/index.php(181): Slim\App->run()
#13 {main}
Tips: To display error details in HTTP response set "displayErrorDetails" to true in the ErrorHandler constructor.
[02-Aug-2023 14:06:49] NOTICE: Terminating ...
[02-Aug-2023 14:06:49] NOTICE: exiting, bye-bye!
[Wed Aug 02 14:06:54.461677 2023] [mpm_event:notice] [pid 92:tid 140703028644680] AH00491: caught SIGTERM, shutting down
e[0;92mInitial startup of Nextcloud All-in-One complete!
You should be able to open the Nextcloud AIO Interface now on port 8080 of this server!
E.g. https://internal.ip.of.this.server:8080

If your server has port 80 and 8443 open and you point a domain to your server, you can get a valid certificate automatically by opening the Nextcloud AIO Interface via:
https://your-domain-that-points-to-this-server.tld:8443e[0m
[02-Aug-2023 14:09:12] NOTICE: fpm is running, pid 97
[02-Aug-2023 14:09:12] NOTICE: ready to handle connections
[Wed Aug 02 14:09:12.076184 2023] [mpm_event:notice] [pid 92:tid 139887931853640] AH00489: Apache/2.4.57 (Unix) OpenSSL/3.1.1 configured -- resuming normal operations
[Wed Aug 02 14:09:12.086302 2023] [core:notice] [pid 92:tid 139887931853640] AH00094: Command line: 'httpd -D FOREGROUND'
{"level":"info","ts":1690985352.1120508,"msg":"using provided configuration","config_file":"/Caddyfile","config_adapter":""}
{"level":"error","ts":1691006858.8000333,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.023815496,"max_duration":2592000}
{"level":"error","ts":1691006918.8036048,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.027409631,"max_duration":2592000}
{"level":"error","ts":1691025327.7497532,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.012518969,"max_duration":2592000}
{"level":"error","ts":1691025387.7553582,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.018125388,"max_duration":2592000}
{"level":"error","ts":1691031117.1502275,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":1,"retrying_in":60,"elapsed":0.001074761,"max_duration":2592000}
{"level":"error","ts":1691031177.1542702,"logger":"tls.obtain","msg":"will retry","error":"[IPADDRESS] Obtain: subject does not qualify for a public certificate: IPADDRESS","attempt":2,"retrying_in":120,"elapsed":60.005116585,"max_duration":2592000}
Total reclaimed space: 0B
Deleting duplicate sessions

satsuma · August 4, 2023, 12:56pm

Another instance of the server failing, with slightly different symptoms.

Normal access to an .md file on the Android app. Closed file.
After 3 minutes, re-opened the file. Android reports, “Taking longer than expected,” but ultimately loaded nothing.
After 30 minutes, used a desktop browser to access https://(hostname). No response from server at all.
Used desktop browser to access AIO UI directly. Successfully got to the “The login is blocked since Nextcloud is running” message.
Successful ssh access to server. Server is alive, but not all the services are.
In ssh, sudo docker stop nextcloud-aio-apache.
Successfully logged into AIO UI. The containers are all up to date. The container apache is stopped; the other containers are running (database, nextcloud, notify push, redis, collabora). The incremental log is:

Total reclaimed space: 0B
Deleting duplicate sessions
NOTICE: PHP message: 404 Not Found
Type: Slim\Exception\HttpNotFoundException

4
Message: Not found.
File: /var/www/docker-aio/php/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php
Line: 76
Trace: #0 /var/www/docker-aio/php/vendor/slim/slim/Slim/Routing/RouteRunner.php(56): Slim\Middleware\RoutingMiddleware->performRouting(Object(GuzzleHttp\Psr7\ServerRequest))
#1 /var/www/docker-aio/php/vendor/slim/csrf/src/Guard.php(476): Slim\Routing\RouteRunner->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#2 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(168): Slim\Csrf\Guard->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Slim\Routing\RouteRunner))
#3 /var/www/docker-aio/php/vendor/slim/twig-view/src/TwigMiddleware.php(115): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#4 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Views\TwigMiddleware->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#5 /var/www/docker-aio/php/src/Middleware/AuthMiddleware.php(38): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#6 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(269): AIO\Middleware\AuthMiddleware->__invoke(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#7 /var/www/docker-aio/php/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#8 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(GuzzleHttp\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#9 /var/www/docker-aio/php/vendor/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#10 /var/www/docker-aio/php/vendor/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#11 /var/www/docker-aio/php/vendor/slim/slim/Slim/App.php(183): Slim\App->handle(Object(GuzzleHttp\Psr7\ServerRequest))
#12 /var/www/docker-aio/php/public/index.php(181): Slim\App->run()
#13 {main}
Tips: To display error details in HTTP response set "displayErrorDetails" to true in the ErrorHandler constructor.
{"level":"error","ts":1691117425.3663988,"logger":"tls.obtain","msg":"will retry","error":"[(ipaddr)] Obtain: subject does not qualify for a public certificate: (ipaddr)","attempt":1,"retrying_in":60,"elapsed":0.007460422,"max_duration":2592000}
{"level":"error","ts":1691117485.3730125,"logger":"tls.obtain","msg":"will retry","error":"[(ipaddr)] Obtain: subject does not qualify for a public certificate: (ipaddr)","attempt":2,"retrying_in":120,"elapsed":60.014098871,"max_duration":2592000}
Total reclaimed space: 0B
{"level":"error","ts":1691125551.8590221,"logger":"tls.obtain","msg":"will retry","error":"[(ipaddr)] Obtain: subject does not qualify for a public certificate: (ipaddr)","attempt":1,"retrying_in":60,"elapsed":0.015259699,"max_duration":2592000}
{"level":"error","ts":1691125611.8670957,"logger":"tls.obtain","msg":"will retry","error":"[(ipaddr)] Obtain: subject does not qualify for a public certificate: (ipaddr)","attempt":2,"retrying_in":120,"elapsed":60.023334233,"max_duration":2592000}
Deleting duplicate sessions

In AIO UI, stopped all containers.
In AIO UI, started all containers. All reported as running.
Log out of AIO UI.
Test access via desktop browser to https://(hostname). 1st attempt failed: Firefox reported, “An error occurred during a connection to… site could be busy…” 2nd attempt worked.
Desktop sync app had shown offline, now resumed online status.

What causes this instability?

satsuma · August 5, 2023, 1:15pm

Another recurrence! This time, took a photo on the Android, uploaded it via the Nextcloud Android app, app reports that the file landed “seconds ago”, but no thumbnail image appeared. Uh-oh.

Desktop sync app has detected a change, but was waiting for data. Nothing arrived.

Desktop browser UI failed to reach the login screen.

AIO UI was locked, so, once again, in ssh, sudo docker stop nextcloud-aio-apache. Logs seem to show a recurrence of this ticket’s prior entry Some file/resource is not found?

While at the AIO UI, stopped all containers, deselected Nextcloud Office and re-started all remaining containes (apache, Database, Nextcloud, Notify Push, Redis). Will the server become from stable, or will remain as unstable as it has been this week?

Side note: the Redis container has the following log entry:

Memory overcommit is disabled but necessary for safe operation
See https://github.com/nextcloud/all-in-one/discussions/1731 how to enable overcommit
1:C 05 Aug 2023 14:10:32.639 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
1:C 05 Aug 2023 14:10:32.639 # Redis version=7.0.12, bits=64, commit=00000000, modified=0, pid=1, just started
1:C 05 Aug 2023 14:10:32.639 # Configuration loaded
1:M 05 Aug 2023 14:10:32.642 # Server initialized
1:M 05 Aug 2023 14:10:32.642 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.

The other log entries all look like a normal start-up happened.

satsuma · August 13, 2023, 4:42pm

8 days after uninstalling Nextcloud Office via AIO, the server has been stable and usable throughout, without interruption. No internal server errors reported.

So the root cause of all of the above symptoms looks like it might be related to Nextcloud Office.