enoch85
commented
2 years ago Just got an internal server error, and directly checked the logs and got this:
Logs can be read above with stack trace.
Closed enoch85 closed 2 years ago
enoch85
commented
2 years ago Just got an internal server error, and directly checked the logs and got this:
Logs can be read above with stack trace.
enoch85
commented
2 years ago Some more logs, this is from PostgreSQL.
2022-06-15 09:45:22.532 CEST [205418] ncadmin@nextcloud_db LOG: could not receive data from client: Connection reset by peer
2022-06-15 09:47:46.734 CEST [1453] LOG: server process (PID 205439) was terminated by signal 9: Killed
2022-06-15 09:47:46.734 CEST [1453] DETAIL: Failed process was running: SELECT "c"."addressbookid", "c"."carddata", "c"."uri" FROM "oc_cards" "c" WHERE "c"."id" IN ($1)
2022-06-15 09:47:46.746 CEST [1453] LOG: terminating any other active server processes
2022-06-15 09:47:46.746 CEST [205471] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.746 CEST [205471] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.746 CEST [205471] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.746 CEST [205456] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.746 CEST [205456] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.746 CEST [205456] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.750 CEST [205200] WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.750 CEST [205200] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.750 CEST [205200] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.767 CEST [205434] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.767 CEST [205434] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.767 CEST [205434] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.768 CEST [205441] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.768 CEST [205441] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.768 CEST [205441] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.768 CEST [205435] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.768 CEST [205435] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.768 CEST [205435] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.768 CEST [205440] ncadmin@nextcloud_db WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.768 CEST [205440] ncadmin@nextcloud_db DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.768 CEST [205440] ncadmin@nextcloud_db HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.773 CEST [205472] WARNING: terminating connection because of crash of another server process
2022-06-15 09:47:46.773 CEST [205472] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2022-06-15 09:47:46.773 CEST [205472] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-06-15 09:47:46.812 CEST [205484] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.812 CEST [205477] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.812 CEST [205475] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.812 CEST [205476] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.812 CEST [205480] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.812 CEST [205474] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.814 CEST [205483] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.814 CEST [205482] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.815 CEST [205473] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.815 CEST [205478] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.820 CEST [205481] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.831 CEST [205479] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.831 CEST [205485] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.832 CEST [205486] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.832 CEST [205487] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.836 CEST [205488] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.842 CEST [205489] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.843 CEST [205490] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.847 CEST [1453] LOG: all server processes terminated; reinitializing
2022-06-15 09:47:46.934 CEST [205491] LOG: database system was interrupted; last known up at 2022-06-15 09:39:21 CEST
2022-06-15 09:47:46.936 CEST [205492] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.936 CEST [205493] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.937 CEST [205494] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.941 CEST [205495] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.942 CEST [205496] ncadmin@nextcloud_db FATAL: the database system is in recovery mode
2022-06-15 09:47:46.983 CEST [205491] LOG: database system was not properly shut down; automatic recovery in progress
2022-06-15 09:47:46.987 CEST [205491] LOG: redo starts at 6F/BB2ECAE8
2022-06-15 09:47:46.993 CEST [205491] LOG: invalid record length at 6F/BB350FE0: wanted 24, got 0
2022-06-15 09:47:46.993 CEST [205491] LOG: redo done at 6F/BB350FA8
2022-06-15 09:47:47.024 CEST [1453] LOG: database system is ready to accept connections
2022-06-15 09:57:57.698 CEST [205602] ncadmin@nextcloud_db LOG: could not receive data from client: Connection reset by peer
2022-06-15 09:58:13.493 CEST [1453] LOG: server process (PID 205616) was terminated by signal 9: Killed
2022-06-15 09:58:13.493 CEST [1453] DETAIL: Failed process was running: SELECT "c"."addressbookid", "c"."carddata", "c"."uri" FROM "oc_cards" "c" WHERE "c"."id" IN ($1)
2022-06-15 09:58:13.501 CEST [1453] LOG: terminating any other active server processes
2022-06-15 09:58:13.511 CEST [205500] WARNING: terminating connection because of crash of another server process
2022-06-15 09:58:13.511 CEST [205500] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.I think this is interessting:
2022-06-15 09:47:46.734 CEST [1453] DETAIL: Failed process was running: SELECT "c"."addressbookid", "c"."carddata", "c"."uri" FROM "oc_cards" "c" WHERE "c"."id" IN ($1)I also did some more digging, and it actually seems like I use to little RAM. I tried raising it now by 100% and see if it helps. I'll leave this open until it's confirmed working.
enoch85
commented
2 years ago cc @ChristophWurst since you are the contacts dev, right?
enoch85
commented
2 years ago Closing as it now works again. Sorry for the noise.
oneumyvakin
commented
1 year ago @enoch85 Have you find the reason of this issue?
enoch85
commented
1 year ago I actually don't remember. I made some ninja stuff on my contacts DB some time ago to solve another problem, and that made all my errors go away. 🥷
Reporting as Feautre since the bug reporting is broken:
Description
Since upgrading to Ubuntu 22.04 including PostgreSQL 14 I get strange errors in the log. Above that my "online-checker" tool (Statuscake) reports that the server is down from time to time.
Load times are much higher, and it's in general behaving really really strange. I know that PostgreSQL 14 isn't officially supported yet, but I thought I shed some light on it here.
Steps
OS and server
Ubuntu 22.04 PostgreSQL 14 PHP 8.1
Config
Config
``` root@cloud:~# nextcloud_occ config:list { "system": { "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost", "192.168.15.111", "cloud.danielhansson.nu", "office.danielhansson.nu" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "24.0.1.1", "overwrite.cli.url": "https:\/\/cloud.danielhansson.nu\/", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "remember_login_cookie_lifetime": "1800", "log_rotate_size": "10485760", "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "forwarded_for_headers": [ "HTTP_X_FORWARDED", "HTTP_FORWARDED_FOR" ], "overwriteprotocol": "https", "htaccess.RewriteBase": "\/", "loglevel": "2", "log_type": "file", "logfile": "\/var\/log\/nextcloud\/nextcloud.log", "logtimezone": "Europe\/Stockholm", "maintenance": false, "mail_smtpsecure": "ssl", "mail_sendmailmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "trashbin_retention_obligation": "auto, 180", "activity_expire_days": 60, "filelocking.enabled": true, "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "timeout": 0.5, "dbindex": 0, "password": "***REMOVED SENSITIVE VALUE***" }, "enable_previews": true, "preview_max_x": "2048", "preview_max_y": "2048", "jpeg_quality": "60", "default_phone_region": "se", "memcache.local": "\\OC\\Memcache\\Redis", "theme": "", "enabledPreviewProviders": { "11": "OC\\Preview\\PNG", "12": "OC\\Preview\\JPEG", "13": "OC\\Preview\\GIF", "14": "OC\\Preview\\BMP", "15": "OC\\Preview\\MarkDown", "16": "OC\\Preview\\MP3", "17": "OC\\Preview\\TXT", "18": "OC\\Preview\\Movie" }, "preview_max_memory": 256, "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "app_install_overwrite": [ "issuetemplate" ] }, "apps": { "accessibility": { "types": "", "enabled": "yes", "installed_version": "1.10.0" }, "activity": { "types": "filesystem", "enabled": "yes", "installed_version": "2.16.0" }, "analytics": { "installed_version": "3.0.0", "types": "", "enabled": "no" }, "backgroundjob": { "lastjob": "31638" }, "bookmarks": { "types": "", "enabled": "yes", "privacy.enableScraping": "true", "previews.webshot.url": "", "previews.screenshotmachine.key": "", "installed_version": "10.4.0", "performance.maxBookmarksperAccount": "", "previews.screenly.token": "", "previews.screenly.url": "" }, "calendar": { "types": "", "enabled": "yes", "installed_version": "3.3.1" }, "circles": { "loopback_tmp_path": "\/", "migration_22_1": "1", "installed_version": "23.0.0", "enabled": "no", "types": "filesystem,dav", "loopback_tmp_scheme": "https", "migration_22": "1", "migration_run": "0", "maintenance_run": "0", "maintenance_update": "{\"maximum\":3,\"3\":1640382002,\"2\":1640383801,\"1\":1640383801,\"4\":1640311202,\"5\":1639796401}" }, "cloud_federation_api": { "types": "filesystem", "enabled": "yes", "installed_version": "1.7.0" }, "comments": { "types": "logging", "enabled": "yes", "installed_version": "1.14.0" }, "contacts": { "types": "dav", "enabled": "yes", "installed_version": "4.1.1" }, "contactsinteraction": { "types": "dav", "enabled": "yes", "installed_version": "1.5.0" }, "core": { "installedat": "1555244080.653", "vendor": "nextcloud", "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php", "public_files": "files_sharing\/public.php", "backgroundjobs_mode": "cron", "shareapi_enforce_links_password": "no", "shareapi_default_expire_date": "yes", "shareapi_expire_after_n_days": "14", "lastcron": "1654942503", "oc.integritycheck.checker": "[]", "scss.variables": "db81cddf52fdb3c8ca1e4c859e214124", "enterpriseLogoChecked": "yes", "emailTestSuccessful": "1", "theming.variables": "41545bc493ea402b7a9b19b640ab406b", "moveavatarsdone": "yes", "previewsCleanedUp": "1", "lastupdateResult": "[]", "lastupdatedat": "1654884120" }, "dashboard": { "enabled": "no", "installed_version": "7.1.0", "types": "" }, "dav": { "types": "filesystem", "enabled": "yes", "buildCalendarSearchIndex": "yes", "chunks_migrated": "1", "builtSocialSearchIndex": "yes", "buildCalendarReminderIndex": "yes", "regeneratedBirthdayCalendarsForYearFix": "yes", "installed_version": "1.22.0" }, "extract": { "types": "", "enabled": "no", "installed_version": "1.3.2" }, "federatedfilesharing": { "types": "", "enabled": "yes", "installed_version": "1.14.0" }, "federation": { "types": "authentication", "enabled": "yes", "installed_version": "1.14.0" }, "files": { "types": "filesystem", "enabled": "yes", "cronjob_scan_files": "500", "default_quota": "500 GB", "installed_version": "1.19.0" }, "files_antivirus": { "av_path": "\/usr\/bin\/clamscan", "types": "filesystem,dav", "av_mode": "socket", "av_socket": "\/var\/run\/clamav\/clamd.ctl", "av_host": "", "av_port": "0", "av_cmd_options": "", "av_infected_action": "only_log", "av_max_file_size": "-1", "av_stream_max_length": "1048576000", "installed_version": "3.2.2", "enabled": "no" }, "files_pdfviewer": { "types": "", "enabled": "yes", "installed_version": "2.5.0" }, "files_rightclick": { "types": "", "enabled": "yes", "installed_version": "1.3.0" }, "files_sharing": { "types": "filesystem", "enabled": "yes", "lookupServerEnabled": "yes", "installed_version": "1.16.2" }, "files_texteditor": { "types": "", "enabled": "no", "installed_version": "2.8.0" }, "files_trashbin": { "types": "filesystem,dav", "enabled": "yes", "installed_version": "1.14.0" }, "files_versions": { "types": "filesystem,dav", "enabled": "yes", "installed_version": "1.17.0" }, "files_videoplayer": { "types": "", "enabled": "yes", "installed_version": "1.13.0" }, "firstrunwizard": { "types": "logging", "enabled": "yes", "installed_version": "2.13.0" }, "gallery": { "types": "", "installed_version": "18.4.0", "enabled": "no" }, "impersonate": { "types": "", "installed_version": "1.11.0", "enabled": "yes" }, "integration_github": { "enabled": "no", "types": "", "installed_version": "1.0.2" }, "issuetemplate": { "types": "", "installed_version": "0.7.0", "enabled": "no" }, "logreader": { "types": "", "enabled": "yes", "levels": "00111", "installed_version": "2.9.0" }, "lookup_server_connector": { "types": "authentication", "enabled": "yes", "installed_version": "1.12.0" }, "mail": { "installed_version": "1.11.7", "types": "", "enabled": "no" }, "maps": { "enabled": "yes", "installed_version": "0.1.10", "types": "filesystem", "lastAddressLookup": "1642173287" }, "nextcloud_announcements": { "types": "logging", "enabled": "no", "installed_version": "1.6.0", "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200" }, "notes": { "types": "", "enabled": "yes", "installed_version": "4.3.1" }, "notifications": { "types": "logging", "enabled": "yes", "installed_version": "2.12.0" }, "notify_push": { "installed_version": "0.1.6", "types": "filesystem", "enabled": "no", "cookie": "***REMOVED SENSITIVE VALUE***" }, "oauth2": { "types": "authentication", "enabled": "yes", "installed_version": "1.12.0" }, "password_policy": { "installed_version": "1.14.0", "enabled": "yes", "types": "authentication" }, "phonetrack": { "installed_version": "0.7.0", "types": "", "enabled": "yes" }, "photos": { "installed_version": "1.6.0", "types": "", "enabled": "yes" }, "preview": { "jpeg_quality": "60" }, "previewgenerator": { "types": "filesystem", "squareSizes": "32 256", "widthSizes": "256 384", "heightSizes": "256", "installed_version": "5.0.0", "enabled": "yes" }, "privacy": { "readableLocation": "se", "types": "", "enabled": "yes", "installed_version": "1.8.0" }, "provisioning_api": { "types": "prevent_group_restriction", "enabled": "yes", "installed_version": "1.14.0" }, "recommendations": { "enabled": "no", "installed_version": "0.4.0", "types": "" }, "richdocuments": { "enabled": "yes", "public_wopi_url": "https:\/\/office.danielhansson.nu", "wopi_url": "https:\/\/office.danielhansson.nu", "types": "prevent_group_restriction", "installed_version": "6.1.0" }, "serverinfo": { "types": "", "enabled": "yes", "cached_count_storages": "20", "installed_version": "1.14.0", "cached_count_filecache": "2807194" }, "settings": { "installed_version": "1.6.0", "types": "", "enabled": "yes" }, "sharebymail": { "types": "filesystem", "enabled": "yes", "enforcePasswordProtection": "yes", "installed_version": "1.14.0" }, "spreed": { "has_reference_id": "yes", "types": "dav,prevent_group_restriction", "signaling_ticket_secret": "***REMOVED SENSITIVE VALUE***", "project_access_invalidated": "1", "stun_servers": "***REMOVED SENSITIVE VALUE***", "turn_servers": "***REMOVED SENSITIVE VALUE***", "enabled": "yes", "installed_version": "14.0.2" }, "support": { "installed_version": "1.0.0", "types": "", "enabled": "no" }, "survey_client": { "types": "", "enabled": "yes", "last_sent": "1654309806", "installed_version": "1.12.0", "last_report": "{\"id\":\"oc0n3tt2orgh\",\"items\":[[\"server\",\"version\",\"24.0.1.1\"],[\"server\",\"code\",\"other\"],[\"server\",\"enable_avatars\",\"yes\"],[\"server\",\"enable_previews\",\"yes\"],[\"server\",\"memcache.local\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"memcache.distributed\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"asset-pipeline.enabled\",\"no\"],[\"server\",\"filelocking.enabled\",\"yes\"],[\"server\",\"memcache.locking\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"debug\",\"no\"],[\"server\",\"cron\",\"cron\"],[\"php\",\"version\",\"7.4.3\"],[\"php\",\"memory_limit\",-1],[\"php\",\"max_execution_time\",0],[\"php\",\"upload_max_filesize\",2097152],[\"database\",\"type\",\"pgsql\"],[\"database\",\"version\",\"PostgreSQL 13.7 (Ubuntu 13.7-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit\"],[\"database\",\"size\",3184718383],[\"apps\",\"support\",\"disabled\"],[\"apps\",\"password_policy\",\"1.14.0\"],[\"apps\",\"nextcloud_announcements\",\"disabled\"],[\"apps\",\"analytics\",\"disabled\"],[\"apps\",\"cloud_federation_api\",\"1.7.0\"],[\"apps\",\"files_versions\",\"1.17.0\"],[\"apps\",\"lookup_server_connector\",\"1.12.0\"],[\"apps\",\"comments\",\"1.14.0\"],[\"apps\",\"files_texteditor\",\"disabled\"],[\"apps\",\"gallery\",\"disabled\"],[\"apps\",\"files\",\"1.19.0\"],[\"apps\",\"mail\",\"disabled\"],[\"apps\",\"oauth2\",\"1.12.0\"],[\"apps\",\"user_migration\",\"1.0.4\"],[\"apps\",\"sharebymail\",\"1.14.0\"],[\"apps\",\"maps\",\"0.1.10\"],[\"apps\",\"integration_github\",\"disabled\"],[\"apps\",\"files_trashbin\",\"1.14.0\"],[\"apps\",\"federation\",\"1.14.0\"],[\"apps\",\"dashboard\",\"disabled\"],[\"apps\",\"phonetrack\",\"0.7.0\"],[\"apps\",\"tasks\",\"disabled\"],[\"apps\",\"recommendations\",\"disabled\"],[\"apps\",\"workflowengine\",\"2.6.0\"],[\"apps\",\"issuetemplate\",\"disabled\"],[\"apps\",\"theming\",\"1.15.0\"],[\"apps\",\"files_rightclick\",\"1.3.0\"],[\"apps\",\"photos\",\"1.6.0\"],[\"apps\",\"privacy\",\"1.8.0\"],[\"apps\",\"settings\",\"1.6.0\"],[\"apps\",\"text\",\"3.5.1\"],[\"apps\",\"viewer\",\"1.8.0\"],[\"apps\",\"weather_status\",\"1.4.0\"],[\"apps\",\"impersonate\",\"1.11.0\"],[\"apps\",\"dav\",\"1.22.0\"],[\"apps\",\"files_sharing\",\"1.16.2\"],[\"apps\",\"previewgenerator\",\"5.0.0\"],[\"apps\",\"firstrunwizard\",\"2.13.0\"],[\"apps\",\"notifications\",\"2.12.0\"],[\"apps\",\"systemtags\",\"1.14.0\"],[\"apps\",\"accessibility\",\"1.10.0\"],[\"apps\",\"contactsinteraction\",\"1.5.0\"],[\"apps\",\"files_antivirus\",\"disabled\"],[\"apps\",\"federatedfilesharing\",\"1.14.0\"],[\"apps\",\"files_pdfviewer\",\"2.5.0\"],[\"apps\",\"files_videoplayer\",\"1.13.0\"],[\"apps\",\"logreader\",\"2.9.0\"],[\"apps\",\"provisioning_api\",\"1.14.0\"],[\"apps\",\"serverinfo\",\"1.14.0\"],[\"apps\",\"survey_client\",\"1.12.0\"],[\"apps\",\"twofactor_backupcodes\",\"1.13.0\"],[\"apps\",\"updatenotification\",\"1.14.0\"],[\"apps\",\"user_status\",\"1.4.0\"],[\"apps\",\"richdocuments\",\"6.1.0\"],[\"apps\",\"circles\",\"disabled\"],[\"apps\",\"activity\",\"2.16.0\"],[\"apps\",\"extract\",\"disabled\"],[\"apps\",\"notes\",\"4.3.1\"],[\"apps\",\"notify_push\",\"disabled\"],[\"apps\",\"bookmarks\",\"10.3.1\"],[\"apps\",\"spreed\",\"14.0.2\"],[\"apps\",\"calendar\",\"3.3.1\"],[\"apps\",\"contacts\",\"4.1.1\"],[\"stats\",\"num_files\",2805561],[\"stats\",\"num_users\",10],[\"stats\",\"num_storages\",20],[\"stats\",\"num_storages_local\",1],[\"stats\",\"num_storages_home\",10],[\"stats\",\"num_storages_other\",9],[\"stats\",\"num_comments\",216],[\"stats\",\"num_comment_markers\",0],[\"stats\",\"num_systemtags\",0],[\"stats\",\"num_systemtags_mappings\",0],[\"files_sharing\",\"num_shares\",32],[\"files_sharing\",\"num_shares_user\",10],[\"files_sharing\",\"num_shares_groups\",1],[\"files_sharing\",\"num_shares_link\",21],[\"files_sharing\",\"num_shares_link_no_password\",21],[\"files_sharing\",\"num_fed_shares_sent\",0],[\"files_sharing\",\"num_fed_shares_received\",2],[\"files_sharing\",\"permissions_0_17\",1],[\"files_sharing\",\"permissions_0_31\",6],[\"files_sharing\",\"permissions_3_17\",14],[\"files_sharing\",\"permissions_0_19\",2],[\"files_sharing\",\"permissions_0_23\",1],[\"files_sharing\",\"permissions_1_19\",1],[\"files_sharing\",\"permissions_3_1\",5],[\"files_sharing\",\"permissions_3_15\",2],[\"encryption\",\"enabled\",\"no\"],[\"encryption\",\"default_module\",\"no\"]]}" }, "systemtags": { "types": "logging", "enabled": "yes", "installed_version": "1.14.0" }, "tasks": { "types": "", "installed_version": "0.14.2", "enabled": "no" }, "text": { "types": "dav", "enabled": "yes", "installed_version": "3.5.1" }, "theming": { "types": "logging", "productName": "Nextcloud HanssonIT VM", "installed_version": "1.15.0", "name": "Hansson Cloud", "cachebuster": "2", "enabled": "yes" }, "twofactor_backupcodes": { "types": "", "enabled": "yes", "installed_version": "1.13.0" }, "updatenotification": { "types": "", "maps": "0.1.10", "phonetrack": "0.7.0", "enabled": "yes", "tasks": "0.13.6", "mail": "1.11.7", "notes": "4.3.1", "issuetemplate": "0.7.0", "files_antivirus": "3.2.2", "notify_groups": "[]", "impersonate": "1.6.1", "files_rightclick": "0.15.1", "text": "1.0.2", "previewgenerator": "5.0.0", "contacts": "4.1.1", "extract": "1.3.1", "spreed": "14.0.2", "richdocuments": "6.1.0", "installed_version": "1.14.0", "bookmarks": "10.4.0", "integration_github": "1.0.0", "update_check_errors": "0", "calendar": "3.3.1", "core": "23.0.4.1" }, "user_migration": { "installed_version": "1.0.4", "types": "", "enabled": "yes" }, "user_status": { "types": "", "enabled": "yes", "installed_version": "1.4.0" }, "viewer": { "types": "", "enabled": "yes", "installed_version": "1.8.0" }, "weather_status": { "types": "", "enabled": "yes", "installed_version": "1.4.0" }, "workflowengine": { "types": "filesystem", "enabled": "yes", "installed_version": "2.6.0" } } } ```Apps
Apps
``` Enabled: - accessibility: 1.10.0 - activity: 2.16.0 - bookmarks: 10.4.0 - calendar: 3.3.1 - cloud_federation_api: 1.7.0 - comments: 1.14.0 - contacts: 4.1.1 - contactsinteraction: 1.5.0 - dav: 1.22.0 - federatedfilesharing: 1.14.0 - federation: 1.14.0 - files: 1.19.0 - files_pdfviewer: 2.5.0 - files_rightclick: 1.3.0 - files_sharing: 1.16.2 - files_trashbin: 1.14.0 - files_versions: 1.17.0 - files_videoplayer: 1.13.0 - firstrunwizard: 2.13.0 - impersonate: 1.11.0 - logreader: 2.9.0 - lookup_server_connector: 1.12.0 - maps: 0.1.10 - notes: 4.3.1 - notifications: 2.12.0 - oauth2: 1.12.0 - password_policy: 1.14.0 - phonetrack: 0.7.0 - photos: 1.6.0 - previewgenerator: 5.0.0 - privacy: 1.8.0 - provisioning_api: 1.14.0 - richdocuments: 6.1.0 - serverinfo: 1.14.0 - settings: 1.6.0 - sharebymail: 1.14.0 - spreed: 14.0.2 - survey_client: 1.12.0 - systemtags: 1.14.0 - text: 3.5.1 - theming: 1.15.0 - twofactor_backupcodes: 1.13.0 - updatenotification: 1.14.0 - user_migration: 1.0.4 - user_status: 1.4.0 - viewer: 1.8.0 - weather_status: 1.4.0 - workflowengine: 2.6.0 Disabled: - admin_audit - circles: 23.0.0 - dashboard: 7.1.0 - encryption - files_external - nextcloud_announcements: 1.6.0 - recommendations: 0.4.0 - support: 1.0.0 - user_ldap ```Logs
Nextcloud log
``` OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 296: OC\DB\Exceptions\DbalException::wrap() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1141: OC\DB\QueryBuilder\QueryBuilder->executeQuery() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1032: OCA\DAV\CardDAV\CardDavBackend->searchByAddressBookIds() /var/www/nextcloud/apps/dav/lib/CardDAV/AddressBookImpl.php - line 121: OCA\DAV\CardDAV\CardDavBackend->search() /var/www/nextcloud/lib/private/ContactsManager.php - line 73: OCA\DAV\CardDAV\AddressBookImpl->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 259: OC\ContactsManager->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 225: OCA\FederatedFileSharing\Notifier->getDisplayNameFromContact() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 184: OCA\FederatedFileSharing\Notifier->getDisplayName() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 128: OCA\FederatedFileSharing\Notifier->createRemoteUser() /var/www/nextcloud/lib/private/Notification/Manager.php - line 376: OCA\FederatedFileSharing\Notifier->prepare() /var/www/nextcloud/apps/notifications/lib/Controller/EndpointController.php - line 111: OC\Notification\Manager->prepare() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 225: OCA\Notifications\Controller\EndpointController->listNotifications() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 133: OC\AppFramework\Http\Dispatcher->executeController() /var/www/nextcloud/lib/private/AppFramework/App.php - line 172: OC\AppFramework\Http\Dispatcher->dispatch() /var/www/nextcloud/lib/private/Route/Router.php - line 298: OC\AppFramework\App::main() /var/www/nextcloud/ocs/v1.php - line 62: OC\Route\Router->match() /var/www/nextcloud/ocs/v2.php - line 23: require_once("/var/www/nextcloud/ocs/v1.php") Orsakad av Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780: Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719: Doctrine\DBAL\Connection->handleDriverException() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1067: Doctrine\DBAL\Connection->convertExceptionDuringQuery() /var/www/nextcloud/lib/private/DB/Connection.php - line 261: Doctrine\DBAL\Connection->executeQuery() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 345: OC\DB\Connection->executeQuery() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 294: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1141: OC\DB\QueryBuilder\QueryBuilder->executeQuery() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1032: OCA\DAV\CardDAV\CardDavBackend->searchByAddressBookIds() /var/www/nextcloud/apps/dav/lib/CardDAV/AddressBookImpl.php - line 121: OCA\DAV\CardDAV\CardDavBackend->search() /var/www/nextcloud/lib/private/ContactsManager.php - line 73: OCA\DAV\CardDAV\AddressBookImpl->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 259: OC\ContactsManager->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 225: OCA\FederatedFileSharing\Notifier->getDisplayNameFromContact() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 184: OCA\FederatedFileSharing\Notifier->getDisplayName() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 128: OCA\FederatedFileSharing\Notifier->createRemoteUser() /var/www/nextcloud/lib/private/Notification/Manager.php - line 376: OCA\FederatedFileSharing\Notifier->prepare() /var/www/nextcloud/apps/notifications/lib/Controller/EndpointController.php - line 111: OC\Notification\Manager->prepare() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 225: OCA\Notifications\Controller\EndpointController->listNotifications() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 133: OC\AppFramework\Http\Dispatcher->executeController() /var/www/nextcloud/lib/private/AppFramework/App.php - line 172: OC\AppFramework\Http\Dispatcher->dispatch() /var/www/nextcloud/lib/private/Route/Router.php - line 298: OC\AppFramework\App::main() /var/www/nextcloud/ocs/v1.php - line 62: OC\Route\Router->match() /var/www/nextcloud/ocs/v2.php - line 23: require_once("/var/www/nextcloud/ocs/v1.php") Orsakad av Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94: Doctrine\DBAL\Driver\PDO\Exception::new() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1057: Doctrine\DBAL\Driver\PDO\Statement->execute() /var/www/nextcloud/lib/private/DB/Connection.php - line 261: Doctrine\DBAL\Connection->executeQuery() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 345: OC\DB\Connection->executeQuery() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 294: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1141: OC\DB\QueryBuilder\QueryBuilder->executeQuery() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1032: OCA\DAV\CardDAV\CardDavBackend->searchByAddressBookIds() /var/www/nextcloud/apps/dav/lib/CardDAV/AddressBookImpl.php - line 121: OCA\DAV\CardDAV\CardDavBackend->search() /var/www/nextcloud/lib/private/ContactsManager.php - line 73: OCA\DAV\CardDAV\AddressBookImpl->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 259: OC\ContactsManager->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 225: OCA\FederatedFileSharing\Notifier->getDisplayNameFromContact() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 184: OCA\FederatedFileSharing\Notifier->getDisplayName() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 128: OCA\FederatedFileSharing\Notifier->createRemoteUser() /var/www/nextcloud/lib/private/Notification/Manager.php - line 376: OCA\FederatedFileSharing\Notifier->prepare() /var/www/nextcloud/apps/notifications/lib/Controller/EndpointController.php - line 111: OC\Notification\Manager->prepare() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 225: OCA\Notifications\Controller\EndpointController->listNotifications() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 133: OC\AppFramework\Http\Dispatcher->executeController() /var/www/nextcloud/lib/private/AppFramework/App.php - line 172: OC\AppFramework\Http\Dispatcher->dispatch() /var/www/nextcloud/lib/private/Route/Router.php - line 298: OC\AppFramework\App::main() /var/www/nextcloud/ocs/v1.php - line 62: OC\Route\Router->match() /var/www/nextcloud/ocs/v2.php - line 23: require_once("/var/www/nextcloud/ocs/v1.php") Orsakad av PDOException: SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92: PDOStatement->execute() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1057: Doctrine\DBAL\Driver\PDO\Statement->execute() /var/www/nextcloud/lib/private/DB/Connection.php - line 261: Doctrine\DBAL\Connection->executeQuery() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 345: OC\DB\Connection->executeQuery() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 294: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1141: OC\DB\QueryBuilder\QueryBuilder->executeQuery() /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 1032: OCA\DAV\CardDAV\CardDavBackend->searchByAddressBookIds() /var/www/nextcloud/apps/dav/lib/CardDAV/AddressBookImpl.php - line 121: OCA\DAV\CardDAV\CardDavBackend->search() /var/www/nextcloud/lib/private/ContactsManager.php - line 73: OCA\DAV\CardDAV\AddressBookImpl->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 259: OC\ContactsManager->search() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 225: OCA\FederatedFileSharing\Notifier->getDisplayNameFromContact() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 184: OCA\FederatedFileSharing\Notifier->getDisplayName() /var/www/nextcloud/apps/federatedfilesharing/lib/Notifier.php - line 128: OCA\FederatedFileSharing\Notifier->createRemoteUser() /var/www/nextcloud/lib/private/Notification/Manager.php - line 376: OCA\FederatedFileSharing\Notifier->prepare() /var/www/nextcloud/apps/notifications/lib/Controller/EndpointController.php - line 111: OC\Notification\Manager->prepare() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 225: OCA\Notifications\Controller\EndpointController->listNotifications() /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 133: OC\AppFramework\Http\Dispatcher->executeController() /var/www/nextcloud/lib/private/AppFramework/App.php - line 172: OC\AppFramework\Http\Dispatcher->dispatch() /var/www/nextcloud/lib/private/Route/Router.php - line 298: OC\AppFramework\App::main() /var/www/nextcloud/ocs/v1.php - line 62: OC\Route\Router->match() /var/www/nextcloud/ocs/v2.php - line 23: require_once("/var/www/nextcloud/ocs/v1.php") Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 7 no connection to the server /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780: Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719: Doctrine\DBAL\Connection->handleDriverException() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1067: Doctrine\DBAL\Connection->convertExceptionDuringQuery() /var/www/nextcloud/lib/private/DB/Connection.php - line 261: Doctrine\DBAL\Connection->executeQuery() /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 345: OC\DB\Connection->executeQuery() /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/lib/private/Files/Cache/StorageGlobal.php - line 80: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 98: OC\Files\Cache\StorageGlobal->getStorageInfo() /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 76: OC\Files\Cache\Storage::getStorageById() /var/www/nextcloud/lib/private/Files/Cache/Cache.php - line 121: OC\Files\Cache\Storage->__construct() /var/www/nextcloud/lib/private/Files/Storage/Common.php - line 340: OC\Files\Cache\Cache->__construct() /var/www/nextcloud/lib/private/Files/View.php - line 1338: OC\Files\Storage\Common->getCache() /var/www/nextcloud/lib/private/Files/View.php - line 1390: OC\Files\View->getCacheEntry() /var/www/nextcloud/lib/private/Files/Node/Root.php - line 205: OC\Files\View->getFileInfo() <