Closed bambita closed 5 years ago
Hmm. You have a few issues with your setup:
1) General error: 1712 Index oc_calendar_resources is corrupted
I would try to recreate the indexes for table calendar_resources. https://github.com/nextcloud/server/blob/b7de6d7a24f76c91dffe1644c4b24e0a27b43c14/apps/dav/lib/Migration/Version1005Date20180530124431.php#L76-L78
2) [Sun Mar 17 10:34:18.280791 2019] [core:notice] [pid 909] AH00052: child pid 1864 exit signal Segmentation fault (11)
Check your apache2 and/or php-fpm error logs. Something is wrong ;)
Thanks. You can close the case. Issue was in Apache. It was upgraded from 2.2 to 2.4. Some adjustment was needed...
https://wiki.apache.org/httpd/ClientDeniedByServerConfiguration
I cannot connect external storage SMB/CIFS
Steps to reproduce
Expected behaviour
Connected and working external storage.
Actual behaviour
In GUI I am getting red exclamation mark, in browser console I can see net::ERR_EMPTY_RESPONSE
Server configuration
**Operating system: Linux raspberrypi 4.14.98-v7+
**Web server: Apache/2.4.25 (Raspbian)
**Database: mysql Ver 15.1 Distrib 10.1.37-MariaDB, for debian-linux-gnueabihf (armv8l) using readline 5.2
**PHP version: PHP 7.0.33-0+deb9u3
**Nextcloud version: 15.0.5
**Updated from an older Nextcloud/ownCloud or fresh install:updated from 15.0.4
**Where did you install Nextcloud from: auto update from Web GUI
Signing status:
Signing status
``` No errors have been found. ```List of activated apps:
App list
``` Enabled: - activity: 2.8.2 - cloud_federation_api: 0.1.0 - comments: 1.5.0 - dav: 1.8.1 - federatedfilesharing: 1.5.0 - federation: 1.5.0 - files: 1.10.0 - files_external: 1.6.0 - files_pdfviewer: 1.4.0 - files_sharing: 1.7.0 - files_texteditor: 2.7.0 - files_trashbin: 1.5.0 - files_versions: 1.8.0 - files_videoplayer: 1.4.0 - firstrunwizard: 2.4.0 - gallery: 18.2.0 - logreader: 2.0.0 - lookup_server_connector: 1.3.0 - nextcloud_announcements: 1.4.0 - notifications: 2.3.0 - oauth2: 1.3.0 - password_policy: 1.5.0 - previewgenerator: 2.1.0 - provisioning_api: 1.5.0 - serverinfo: 1.5.0 - sharebymail: 1.5.0 - support: 1.0.0 - theming: 1.6.0 - twofactor_backupcodes: 1.4.1 - updatenotification: 1.5.0 - workflowengine: 1.5.0 Disabled: - accessibility - admin_audit - encryption - survey_client - systemtags - user_ldap ```Nextcloud configuration:
Config report
``` { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.mydomain.cz" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/cloud.mydomain.cz", "dbtype": "mysql", "version": "15.0.5.3", "installed": true, "maintenance": false, "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "theme": "", "loglevel": 2, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpauthtype": "LOGIN", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpsecure": "ssl", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***" } } ```**Are you using external storage, if yes which one: Yes, SMB on local network
**Are you using encryption: no
**Are you using an external user-backend, if yes which one: no
LDAP configuration (delete this part if not used)
LDAP config
``` N/A ```Client configuration
**Browser:Latest chrome or firefox
**Operating system: Windows 10
Logs
Web server error log
Web server error log
``` [Sun Mar 17 10:26:22.748578 2019] [authz_core:error] [pid 1755] [client 192.168.1.157:49733] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:26:23.799424 2019] [core:notice] [pid 909] AH00052: child pid 1808 exit signal Segmentation fault (11) [Sun Mar 17 10:34:14.002651 2019] [authz_core:error] [pid 1864] [client 192.168.1.157:50198] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:34:15.277350 2019] [core:notice] [pid 909] AH00052: child pid 1866 exit signal Segmentation fault (11) [Sun Mar 17 10:34:17.718536 2019] [authz_core:error] [pid 1868] [client 192.168.1.157:50201] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:34:18.280791 2019] [core:notice] [pid 909] AH00052: child pid 1864 exit signal Segmentation fault (11) [Sun Mar 17 10:34:19.282006 2019] [core:notice] [pid 909] AH00052: child pid 1815 exit signal Segmentation fault (11) [Sun Mar 17 10:34:20.283193 2019] [core:notice] [pid 909] AH00052: child pid 1806 exit signal Segmentation fault (11) [Sun Mar 17 10:34:20.283330 2019] [core:notice] [pid 909] AH00052: child pid 1868 exit signal Segmentation fault (11) [Sun Mar 17 10:34:20.283409 2019] [core:notice] [pid 909] AH00052: child pid 1869 exit signal Segmentation fault (11) [Sun Mar 17 10:34:26.080549 2019] [authz_core:error] [pid 1912] [client 192.168.1.157:50217] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:34:27.303469 2019] [core:notice] [pid 909] AH00052: child pid 1755 exit signal Segmentation fault (11) [Sun Mar 17 10:34:28.322062 2019] [core:notice] [pid 909] AH00052: child pid 1814 exit signal Segmentation fault (11) [Sun Mar 17 10:34:28.322260 2019] [core:notice] [pid 909] AH00052: child pid 1908 exit signal Segmentation fault (11) [Sun Mar 17 10:34:28.322309 2019] [core:notice] [pid 909] AH00052: child pid 1912 exit signal Segmentation fault (11) [Sun Mar 17 10:34:28.322354 2019] [core:notice] [pid 909] AH00052: child pid 1913 exit signal Segmentation fault (11) [Sun Mar 17 10:34:29.323502 2019] [core:notice] [pid 909] AH00052: child pid 1813 exit signal Segmentation fault (11) [Sun Mar 17 10:34:29.323748 2019] [core:notice] [pid 909] AH00052: child pid 1867 exit signal Segmentation fault (11) [Sun Mar 17 10:36:38.916075 2019] [authz_core:error] [pid 1925] [client 192.168.1.157:50346] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:36:40.462473 2019] [core:notice] [pid 909] AH00052: child pid 1922 exit signal Segmentation fault (11) [Sun Mar 17 10:36:53.500694 2019] [core:notice] [pid 909] AH00052: child pid 1935 exit signal Segmentation fault (11) [Sun Mar 17 10:37:04.817821 2019] [authz_core:error] [pid 1923] [client 192.168.1.157:50377] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:37:05.519828 2019] [core:notice] [pid 909] AH00052: child pid 1921 exit signal Segmentation fault (11) [Sun Mar 17 10:37:06.531121 2019] [core:notice] [pid 909] AH00052: child pid 1918 exit signal Segmentation fault (11) [Sun Mar 17 10:37:06.531377 2019] [core:notice] [pid 909] AH00052: child pid 1923 exit signal Segmentation fault (11) [Sun Mar 17 10:37:06.531438 2019] [core:notice] [pid 909] AH00052: child pid 1926 exit signal Segmentation fault (11) [Sun Mar 17 10:37:07.532598 2019] [core:notice] [pid 909] AH00052: child pid 1933 exit signal Segmentation fault (11) [Sun Mar 17 10:37:08.248638 2019] [authz_core:error] [pid 1936] [client 192.168.1.157:50381] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:37:09.549028 2019] [core:notice] [pid 909] AH00052: child pid 1924 exit signal Segmentation fault (11) [Sun Mar 17 10:37:19.332312 2019] [authz_core:error] [pid 1925] [client 192.168.1.157:50401] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:37:20.597243 2019] [core:notice] [pid 909] AH00052: child pid 1944 exit signal Segmentation fault (11) [Sun Mar 17 10:37:20.597522 2019] [core:notice] [pid 909] AH00052: child pid 1953 exit signal Segmentation fault (11) [Sun Mar 17 10:37:20.597582 2019] [core:notice] [pid 909] AH00052: child pid 1954 exit signal Segmentation fault (11) [Sun Mar 17 10:37:21.598702 2019] [core:notice] [pid 909] AH00052: child pid 1934 exit signal Segmentation fault (11) [Sun Mar 17 10:37:22.599940 2019] [core:notice] [pid 909] AH00052: child pid 1925 exit signal Segmentation fault (11) [Sun Mar 17 10:37:22.600071 2019] [core:notice] [pid 909] AH00052: child pid 1952 exit signal Segmentation fault (11) [Sun Mar 17 10:37:22.600112 2019] [core:notice] [pid 909] AH00052: child pid 1955 exit signal Segmentation fault (11) [Sun Mar 17 10:37:23.601264 2019] [core:notice] [pid 909] AH00052: child pid 1945 exit signal Segmentation fault (11) [Sun Mar 17 10:37:25.247097 2019] [authz_core:error] [pid 1962] [client 192.168.1.157:50416] AH01630: client denied by server configuration: /var/www/cloud.mydomain.cz/data/.ocdata [Sun Mar 17 10:37:26.640700 2019] [core:notice] [pid 909] AH00052: child pid 1960 exit signal Segmentation fault (11) ```Nextcloud log (data/nextcloud.log)
Nextcloud log
``` { "reqId": "XLpN8yulfXC26dCnHMhU", "level": 3, "time": "2019-03-17T09:16:27+00:00", "remoteAddr": "", "user": "--", "app": "core", "method": "", "url": "--", "message": { "Exception": "Doctrine\\DBAL\\Exception\\DriverException", "Message": "An exception occurred while executing 'SELECT * FROM `oc_calendar_resources`':\n\nSQLSTATE[HY000]: General error: 1712 Index oc_calendar_resources is corrupted", "Code": 0, "Trace": [{ "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php", "line": 128, "function": "convertException", "class": "Doctrine\\DBAL\\Driver\\AbstractMySQLDriver", "type": "->", "args": ["An exception occurred while executing 'SELECT * FROM `oc_calendar_resources`':\n\nSQLSTATE[HY000]: General error: 1712 Index oc_calendar_resources is corrupted", { "errorInfo": ["HY000", 1712, "Index oc_calendar_resources is corrupted"], "__class__": "Doctrine\\DBAL\\Driver\\PDOException" } ] }, { "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php", "line": 855, "function": "driverExceptionDuringQuery", "class": "Doctrine\\DBAL\\DBALException", "type": "::", "args": [{ "__class__": "Doctrine\\DBAL\\Driver\\PDOMySql\\Driver" }, { "errorInfo": ["HY000", 1712, "Index oc_calendar_resources is corrupted"], "__class__": "Doctrine\\DBAL\\Driver\\PDOException" }, "SELECT * FROM `oc_calendar_resources`", []] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/Connection.php", "line": 195, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], [], null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php", "line": 206, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], []] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php", "line": 214, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 206, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 97, "function": "getCached", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": ["calendar_resources"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 88, "function": "runResources", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/Job.php", "line": 61, "function": "run", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/TimedJob.php", "line": 55, "function": "execute", "class": "OC\\BackgroundJob\\Job", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] }, { "file": "\/var\/www\/cloud.mydomain.cz\/cron.php", "line": 123, "function": "execute", "class": "OC\\BackgroundJob\\TimedJob", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] } ], "File": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php", "Line": 115, "Previous": { "Exception": "Doctrine\\DBAL\\Driver\\PDOException", "Message": "SQLSTATE[HY000]: General error: 1712 Index oc_calendar_resources is corrupted", "Code": "HY000", "Trace": [{ "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php", "line": 852, "function": "query", "class": "Doctrine\\DBAL\\Driver\\PDOConnection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/Connection.php", "line": 195, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], [], null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php", "line": 206, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], []] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php", "line": 214, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 206, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 97, "function": "getCached", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": ["calendar_resources"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 88, "function": "runResources", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/Job.php", "line": 61, "function": "run", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/TimedJob.php", "line": 55, "function": "execute", "class": "OC\\BackgroundJob\\Job", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] }, { "file": "\/var\/www\/cloud.mydomain.cz\/cron.php", "line": 123, "function": "execute", "class": "OC\\BackgroundJob\\TimedJob", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] } ], "File": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php", "Line": 106, "Previous": { "Exception": "PDOException", "Message": "SQLSTATE[HY000]: General error: 1712 Index oc_calendar_resources is corrupted", "Code": "HY000", "Trace": [{ "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php", "line": 104, "function": "query", "class": "PDO", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php", "line": 852, "function": "query", "class": "Doctrine\\DBAL\\Driver\\PDOConnection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/Connection.php", "line": 195, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], [], null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php", "line": 206, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": ["SELECT * FROM `oc_calendar_resources`", [], []] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php", "line": 214, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 206, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 97, "function": "getCached", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": ["calendar_resources"] }, { "file": "\/var\/www\/cloud.mydomain.cz\/apps\/dav\/lib\/BackgroundJob\/UpdateCalendarResourcesRoomsBackgroundJob.php", "line": 88, "function": "runResources", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/Job.php", "line": 61, "function": "run", "class": "OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob", "type": "->", "args": [null] }, { "file": "\/var\/www\/cloud.mydomain.cz\/lib\/private\/BackgroundJob\/TimedJob.php", "line": 55, "function": "execute", "class": "OC\\BackgroundJob\\Job", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] }, { "file": "\/var\/www\/cloud.mydomain.cz\/cron.php", "line": 123, "function": "execute", "class": "OC\\BackgroundJob\\TimedJob", "type": "->", "args": [{ "__class__": "OC\\BackgroundJob\\JobList" }, { "__class__": "OC\\Log" } ] } ], "File": "\/var\/www\/cloud.mydomain.cz\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php", "Line": 104 } }, "CustomMessage": "Error while running background job (class: OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob, arguments: )" }, "userAgent": "--", "version": "15.0.5.3" } ```Browser log
Browser log
``` core.js?v=e554434a-4:7 JQMIGRATE: Migrate is installed, version 1.4.0 content.js:94 Content Server Web Browser Extension: not applicable for href='https://cloud.mydomain.cz/settings/admin/externalstorages'; /remote.php/webdav:1 Failed to load resource: net::ERR_EMPTY_RESPONSE /apps/files_external/globalstorages/14?testOnly=true:1 Failed to load resource: net::ERR_EMPTY_RESPONSE DevTools failed to parse SourceMap: https://cloud.mydomain.cz/apps/notifications/js/notifications.js.map ```