Floccus: Flocus just hangs when trying to sync
Describe the bug
This has been going on for weeks and I only finally find some time to look more closely at it. Symptom is:
and it just sits there, for days, and days and days. In fact, clicking Cancel achieves nothing.
To Reproduce
Well, nothing. It just started happening. Floccus had been working for a long long time, happily. Then one day this ... but I'm a very busy person alas and I just lived with it for ages, and only now finally after weeks of this take a closer look.
Expected behavior
That it finishes syncing.
Screenshots
Provided above under Describe the bug.
Desktop (please complete the following information):
- OS: Linux Mint 19, Windows 10
- Browser: Firefox and Chrome
- Browser Version: Latest of each. 68.0.2 in FF and 70.0.3538.77 in Chrome on my Linux box.
- Floccus version: 3.4.0.5
- Floccus sync method: Unsure. Checked options can't see which one I am using. Am certainly using the Nextcloud Bookmarks app and see my bookmarks there.
Server (please complete the following information):
- OS: Nextcloud Pi v1.15.3
- Nextcloud version: 16.0.4.1
- Bookmarks app version: 2.0.3
Debug log
The last line of the debug log is suspiciously:
Syncing failed with E019: HTTP status 500. Failed PUT request. Check your server configuration and log.
But I've said it before and I'll say it again these logs would be much improved with a timestamp at start of each line. No idea how old that last line is for example.
Will upload to here as suggested:
https://klehranlage.net/index.php/s/7nn82NSBsfQKdsJ
- [X ] Debug log provided
Additional context
One reason I waited on this is my Nextcloud server wanted an upgrade. I've done that, it's at the latest version, and passes all its tests with flying colours.
I'm aware of a few log files on that server to consult:
/var/log/apache2/error.log
/var/log/apache2/nc-access.log
/var/log/apache2/nc-error.log
/var/log/apache2/other_vhosts_access.log
But none of these seem to suggest anything related. And the lack of clear time stamps on the floccus log makes it impossible to correlate events between them, just saying.
bug
bernd-wechner
All 12 comments
FYI Uploaded debug log as: Issue 360 - floccus-3.4.0-2019-08-31-1.log
After once uploading it without the issue number (oops).
bernd-wechner
on 31 Aug 2019
But I've said it before and I'll say it again these logs would be much improved with a timestamp at start of each line
ah, yes. Repetition improves reception :D
E019: HTTP status 500. Failed PUT request. Check your server configuration and log.
Could you check the nextcloud.log as well? There should be an error in there
marcelklehr
on 31 Aug 2019
See https://github.com/marcelklehr/floccus/commit/3c13a1da9b0352235f192e1f0905ea25125bf011 ;)
marcelklehr
on 31 Aug 2019
👍1
E019: HTTP status 500. Failed PUT request. Check your server configuration and log.
Could you check the nextcloud.log as well? There should be an error in there
Wasn't aware of that log. In fact had to search my drive for it, as it's not in/var/log, but ins the ncdata folder.
But found it. It's got huge lines alas, so I took a punt (I use glogg) and got the last line with 500 on it. And it's a JSON line, so I've beautified it. I can of cours eupload the whole log file. And when that timestamp pathc makes it into a floccus release, I can install it, restart and the timestamps will make it much easier to correlate these logs!
{
"reqId": "XWRChH8AAQEAAFEaXLAAAI0I",
"level": 3,
"time": "2019-08-26T20:35:16+00:00",
"remoteAddr": "192.168.0.11",
"user": "--",
"app": "core",
"method": "GET",
"url": "\/csrftoken",
"message": {
"Exception": "Doctrine\\DBAL\\Exception\\TableNotFoundException",
"Message": "An exception occurred while executing 'SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)' with params [\"local::\\\/media\\\/USBdrive\\\/ncdata\\\/\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_storages' doesn't exist",
"Code": 0,
"Trace": [{
"file": "\/var\/www\/nextcloud\/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 `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)' with params [\"local::\\\/media\\\/USBdrive\\\/ncdata\\\/\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_storages' doesn't exist", {
"errorInfo": ["42S02", 1146, "Table 'nextcloud.oc_storages' doesn't exist"],
"__class__": "Doctrine\\DBAL\\Driver\\PDOException"
}]
}, {
"file": "\/var\/www\/nextcloud\/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": ["42S02", 1146, "Table 'nextcloud.oc_storages' doesn't exist"],
"__class__": "Doctrine\\DBAL\\Driver\\PDOException"
}, "SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)", {
"1": "local::\/media\/USBdrive\/ncdata\/"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/Connection.php",
"line": 195,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)", ["local::\/media\/USBdrive\/ncdata\/"],
[2], null
]
}, {
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php",
"line": 206,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (:dcValue1)", {
"dcValue1": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"dcValue1": 102
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 60,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 72,
"function": "loadForStorageIds",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": [
["local::\/media\/USBdrive\/ncdata\/"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 93,
"function": "getStorageInfo",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 71,
"function": "getStorageById",
"class": "OC\\Files\\Cache\\Storage",
"type": "::",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Cache.php",
"line": 104,
"function": "__construct",
"class": "OC\\Files\\Cache\\Storage",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Storage\/Common.php",
"line": 333,
"function": "__construct",
"class": "OC\\Files\\Cache\\Cache",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1320,
"function": "getCache",
"class": "OC\\Files\\Storage\\Common",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1376,
"function": "getCacheEntry",
"class": "OC\\Files\\View",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}, "appdata_oc3xiwqouz8h", "\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/Root.php",
"line": 198,
"function": "getFileInfo",
"class": "OC\\Files\\View",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"function": "get",
"class": "OC\\Files\\Node\\Root",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 64,
"function": "call_user_func_array",
"args": [
[{
"__class__": "OC\\Files\\Node\\Root"
}, "get"],
["appdata_oc3xiwqouz8h"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 141,
"function": "__call",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["get", ["appdata_oc3xiwqouz8h"]]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 81,
"function": "get",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 107,
"function": "getAppDataFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSCombiner.php",
"line": 94,
"function": "getFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": ["core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 114,
"function": "process",
"class": "OC\\Template\\JSCombiner",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json", "core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 70,
"function": "cacheAndAppendCombineJsonIfExist",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/ResourceLocator.php",
"line": 78,
"function": "doFind",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["js\/merged-template-prepend"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 328,
"function": "find",
"class": "OC\\Template\\ResourceLocator",
"type": "->",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 160,
"function": "findJavascriptFiles",
"class": "OC\\TemplateLayout",
"type": "::",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 211,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->",
"args": ["error", ""]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/Base.php",
"line": 132,
"function": "fetchPage",
"class": "OC_Template",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 360,
"function": "printPage",
"class": "OC\\Template\\Base",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/index.php",
"line": 69,
"function": "printExceptionErrorPage",
"class": "OC_Template",
"type": "::",
"args": [{
"__class__": "Doctrine\\DBAL\\Exception\\TableNotFoundException"
}, 500]
}],
"File": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",
"Line": 53,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDOException",
"Message": "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_storages' doesn't exist",
"Code": "42S02",
"Trace": [{
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 847,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDOStatement",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/Connection.php",
"line": 195,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)", ["local::\/media\/USBdrive\/ncdata\/"],
[2], null
]
}, {
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php",
"line": 206,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (:dcValue1)", {
"dcValue1": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"dcValue1": 102
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 60,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 72,
"function": "loadForStorageIds",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": [
["local::\/media\/USBdrive\/ncdata\/"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 93,
"function": "getStorageInfo",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 71,
"function": "getStorageById",
"class": "OC\\Files\\Cache\\Storage",
"type": "::",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Cache.php",
"line": 104,
"function": "__construct",
"class": "OC\\Files\\Cache\\Storage",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Storage\/Common.php",
"line": 333,
"function": "__construct",
"class": "OC\\Files\\Cache\\Cache",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1320,
"function": "getCache",
"class": "OC\\Files\\Storage\\Common",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1376,
"function": "getCacheEntry",
"class": "OC\\Files\\View",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}, "appdata_oc3xiwqouz8h", "\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/Root.php",
"line": 198,
"function": "getFileInfo",
"class": "OC\\Files\\View",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"function": "get",
"class": "OC\\Files\\Node\\Root",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 64,
"function": "call_user_func_array",
"args": [
[{
"__class__": "OC\\Files\\Node\\Root"
}, "get"],
["appdata_oc3xiwqouz8h"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 141,
"function": "__call",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["get", ["appdata_oc3xiwqouz8h"]]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 81,
"function": "get",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 107,
"function": "getAppDataFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSCombiner.php",
"line": 94,
"function": "getFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": ["core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 114,
"function": "process",
"class": "OC\\Template\\JSCombiner",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json", "core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 70,
"function": "cacheAndAppendCombineJsonIfExist",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/ResourceLocator.php",
"line": 78,
"function": "doFind",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["js\/merged-template-prepend"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 328,
"function": "find",
"class": "OC\\Template\\ResourceLocator",
"type": "->",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 160,
"function": "findJavascriptFiles",
"class": "OC\\TemplateLayout",
"type": "::",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 211,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->",
"args": ["error", ""]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/Base.php",
"line": 132,
"function": "fetchPage",
"class": "OC_Template",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 360,
"function": "printPage",
"class": "OC\\Template\\Base",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/index.php",
"line": 69,
"function": "printExceptionErrorPage",
"class": "OC_Template",
"type": "::",
"args": [{
"__class__": "Doctrine\\DBAL\\Exception\\TableNotFoundException"
}, 500]
}],
"File": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",
"Line": 107,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_storages' doesn't exist",
"Code": "42S02",
"Trace": [{
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",
"line": 105,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [null]
}, {
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php",
"line": 847,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDOStatement",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/Connection.php",
"line": 195,
"function": "executeQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (?)", ["local::\/media\/USBdrive\/ncdata\/"],
[2], null
]
}, {
"file": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php",
"line": 206,
"function": "executeQuery",
"class": "OC\\DB\\Connection",
"type": "->",
"args": ["SELECT `id`, `numeric_id`, `available`, `last_checked` FROM `oc_storages` WHERE `id` IN (:dcValue1)", {
"dcValue1": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"dcValue1": 102
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 60,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/StorageGlobal.php",
"line": 72,
"function": "loadForStorageIds",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": [
["local::\/media\/USBdrive\/ncdata\/"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 93,
"function": "getStorageInfo",
"class": "OC\\Files\\Cache\\StorageGlobal",
"type": "->",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Storage.php",
"line": 71,
"function": "getStorageById",
"class": "OC\\Files\\Cache\\Storage",
"type": "::",
"args": ["local::\/media\/USBdrive\/ncdata\/"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Cache\/Cache.php",
"line": 104,
"function": "__construct",
"class": "OC\\Files\\Cache\\Storage",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Storage\/Common.php",
"line": 333,
"function": "__construct",
"class": "OC\\Files\\Cache\\Cache",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1320,
"function": "getCache",
"class": "OC\\Files\\Storage\\Common",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/View.php",
"line": 1376,
"function": "getCacheEntry",
"class": "OC\\Files\\View",
"type": "->",
"args": [{
"__class__": "OC\\Files\\Storage\\Local"
}, "appdata_oc3xiwqouz8h", "\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/Root.php",
"line": 198,
"function": "getFileInfo",
"class": "OC\\Files\\View",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"function": "get",
"class": "OC\\Files\\Node\\Root",
"type": "->",
"args": ["\/appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 64,
"function": "call_user_func_array",
"args": [
[{
"__class__": "OC\\Files\\Node\\Root"
}, "get"],
["appdata_oc3xiwqouz8h"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php",
"line": 141,
"function": "__call",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["get", ["appdata_oc3xiwqouz8h"]]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 81,
"function": "get",
"class": "OC\\Files\\Node\\LazyRoot",
"type": "->",
"args": ["appdata_oc3xiwqouz8h"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php",
"line": 107,
"function": "getAppDataFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSCombiner.php",
"line": 94,
"function": "getFolder",
"class": "OC\\Files\\AppData\\AppData",
"type": "->",
"args": ["core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 114,
"function": "process",
"class": "OC\\Template\\JSCombiner",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json", "core"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php",
"line": 70,
"function": "cacheAndAppendCombineJsonIfExist",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["\/var\/www\/nextcloud", "core\/js\/merged-template-prepend.json"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/ResourceLocator.php",
"line": 78,
"function": "doFind",
"class": "OC\\Template\\JSResourceLocator",
"type": "->",
"args": ["js\/merged-template-prepend"]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 328,
"function": "find",
"class": "OC\\Template\\ResourceLocator",
"type": "->",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/TemplateLayout.php",
"line": 160,
"function": "findJavascriptFiles",
"class": "OC\\TemplateLayout",
"type": "::",
"args": [
["vendor\/core", "js\/merged-template-prepend", "search\/js\/search", "core\/l10n\/en", "search\/l10n\/en", "search\/js\/searchprovider", "js\/jquery-ui-fixes", "js\/files\/fileinfo", "js\/files\/client", "js\/contactsmenu", "js\/contactsmenu_templates", "js\/maintenance-check"]
]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 211,
"function": "__construct",
"class": "OC\\TemplateLayout",
"type": "->",
"args": ["error", ""]
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/Template\/Base.php",
"line": 132,
"function": "fetchPage",
"class": "OC_Template",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/lib\/private\/legacy\/template.php",
"line": 360,
"function": "printPage",
"class": "OC\\Template\\Base",
"type": "->",
"args": []
}, {
"file": "\/var\/www\/nextcloud\/index.php",
"line": 69,
"function": "printExceptionErrorPage",
"class": "OC_Template",
"type": "::",
"args": [{
"__class__": "Doctrine\\DBAL\\Exception\\TableNotFoundException"
}, 500]
}],
"File": "\/var\/www\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php",
"Line": 105
}
},
"CustomMessage": "--"
},
"userAgent": "Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:68.0) Gecko\/20100101 Firefox\/68.0",
"version": "15.0.8.1"
}
Ah, this one is very likely an unrelated error, though :/ Could you check for 500 and bookmarks?
marcelklehr
on 1 Sep 2019
Hmmm, could find no such line. More luck with bookmarks and PUT. I went one better and just uploaded it as: Issue 360 - nextcloud.log.zip
As an aside, that uploader is cool. Is it powered by NextCloud?
bernd-wechner
on 1 Sep 2019
Wowsers, I just restarted FF and this time it bombed with a failed PATCH error. Uploaded the log labelled thusly: Issue 360 (failed PATCH request) - floccus-3.4.0-2019-08-31.log
But then bizarrely, ran to completion on the next try and changes are visible in the Nextcloud Bookmarks app. AND I did it on Chrome too! Restarted Chrome and sycnhed, and it was mega slow, but finished and the bookmarks that were new on FF appeared in Chrome.
Hmmm. I shall try this off site (my work PC on Tuesday) where they have rested hung for weeks and I've not seen these new bookmarks appear. This puzzles me some I admit!
bernd-wechner
on 1 Sep 2019
As an aside, that uploader is cool. Is it powered by NextCloud?
yep, that's my nextcloud :D
Issue 360 (failed PATCH request) - floccus-3.4.0-2019-08-31.log
This one didn't make it through, I'm afraid
marcelklehr
on 1 Sep 2019
Uploaded it again.
I'll have to work out how to get my Nextcloud to have such a cool uploader.
bernd-wechner
on 1 Sep 2019
Uploaded it again.
Oh, sorry, the important part is the server log portion with the 500 error. Floccus doesn't get to know the reason for the error.
I'll have to work out how to get my Nextcloud to have such a cool uploader.
:blush: see https://docs.nextcloud.com/server/16/user_manual/files/file_drop.html
marcelklehr
on 2 Sep 2019
Not sure exactly in which log to find that alas and I guess we can let it rest as it's all working again, after a round of upgrades/updates on my NexcloudPi server.
So many logs. What I have now on record is:
/var/log/apache2/error.log
/var/log/apache2/nc-access.log
/var/log/apache2/nc-error.log
/var/log/apache2/other_vhosts_access.log
$ncp_datadir/nextcloud.log
$ncp_datadir is A NextCloudPi configuration, on my Pi it's /media/USBdrive/ncdata for example as I stuck it on a USB drive not the Pi's internal SSD (flash drive).
I'm guessing I'd find the 500 error in an apache log:
/var/log/apache2/error.log
/var/log/apache2/nc-error.log
but don't see one there. That said they roll over and I have a pile that are zipped up and I haven't a quick easy way to scan all those (personal todo, find a log scanner that can look at those in one fell swoop).
bernd-wechner
on 2 Sep 2019
OK, checked the browsers at work, and still hung, but restarted Chrome and it came good. Restarted Firefox and no such luck. Still hung. So I disabled floccus. Restarted Firefox, then enabled floccus and it finally completed a synch and all seems good again. Somethings odd going on there with saved state between FIrefox runs methinks. If it was mid synch when I closed FF, when I open it it still seems mid sync and not going anyhwere. But who knows?
Main point here, is all four browsers I use now synched properly for the first time in weeks, and the likely, only common confident factor was a complete update of my Nextcould server at all levels!
bernd-wechner
on 3 Sep 2019
🎉1
Was this page helpful?
0 / 5 - 0 ratings
Related issues
marcelklehr
路
5Comments
belgotux
路
6Comments
nemihome
路
5Comments
gerroon
路
6Comments
fermat2a
路
3Comments