mirror of
https://github.com/floccusaddon/floccus.git
synced 2026-04-25 22:26:06 +03:00
[GH-ISSUE #741] floccus sync error #474
Labels
No labels
browser-specific
bug
correctness issues
enhancement
feature: Google Drive
feature: Linkwarden
feature: git
feature: nextcloud-bookmarks
feature: tabs
feature: webdav
help wanted
native-app
priority: high
priority: low
priority: medium
pull-request
question
question
stale
upstream
waiting for more information
wontfix
🙁 Not following issue template
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/floccus#474
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @yo-honey on GitHub (Dec 12, 2020).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/741
Describe the bug
when i click on sync now there is some error
see attached snap.
my account is connected & bookmarks app is already installed i can access it via browser.
Expected behavior
sync properly
Screenshots
added
Desktop (please complete the following information):
Server (please complete the following information):
Note: Please write down the actual version numbers instead of writing 'latest'.
Debug log
It is often useful to provide a debug log file along with the issue. You can obtain a debug log of the most recent sync runs by clicking 'Debug log' in the bottom right corner of the floccus panel in your browser.
Note: As your debug log usually contains large parts of your bookmark data, instead of attaching it publicly to the issue here, I recommend uploading it privately at the following URL https://klehranlage.net/index.php/s/7nn82NSBsfQKdsJ
Additional context
Add any other context about the problem here.
@marcelklehr commented on GitHub (Dec 31, 2020):
Can you check the nextcloud log for errors?
@marcelklehr commented on GitHub (Jan 14, 2021):
Any news?
@panachoi commented on GitHub (Jan 20, 2021):
I have something similar, and checking the nextcloud log shows this:
{"reqId":"PpG1QnfMX9xctj4UCaCI","level":3,"time":"2021-01-20T11:16:02+00:00","re
moteAddr":"XXXX","user":"XXX","app":"index","method":"GET","url":"/
index.php/apps/bookmarks/public/rest/v2/bookmark?page=0&limit=300","message":{"E
xception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception o
ccurred while executing 'SELECT
b.id,b.url,b.title,b.descripti on,b.lastmodified,b.added,b.clickcount,b.last_preview,b.available,b.archived_file,b.user_id, GROUP_CONCAT(tree.parent_fol der) ASfolders, GROUP_CONCAT(t.tag) AStagsFROMoc_bookmarksbLEFT JOIN
oc_bookmarks_treetreeON (b.id=tree.id) AND (tree.type= ?) LEFT JOINoc_bookmarks_tagstONt.bookmark_id=b.idLEFT JOIN
oc_bookmarks_treetrON (tr.id=b.id) AND (tr.type= ?) LEFTJOIN
oc_bookmarks_shared_folderssfONtr.parent_folder=sf.folder_ idLEFT JOINoc_bookmarks_treetr2ON (tr2.id=tr.parent_folder) AND (
tr2.type= ?) LEFT JOINoc_bookmarks_shared_folderssf2ONtr2.pa rent_folder=sf.folder_idWHERE (b.user_id= ?) OR (sf.user_id= ?) OR (
sf2.user_id= ?) GROUP BYb.id,b.url,b.title,b.descr iption,b.lastmodified,b.added,b.clickcount,b.last_preview,b.available,b.archived_file,b.user_id,b.idORDER BYb.last modifiedDESC,b.idASC LIMIT 300' with params ["bookmark", "bookmark","folder", "XXX", "XXX", "XXX"]:\n\nSQLSTATE[HY000]: General er
ror: 3 Error writing file '/tmp/MYTj8xjC' (Errcode: 28 - No space left on device
)","Code":0,
Which seems to indicate a full disk, but this is certainly NOT true. I'm at a loss to explain this error.
@marcelklehr commented on GitHub (Jan 20, 2021):
@panachoi Stackoverflow gives me this: https://stackoverflow.com/questions/51150338/mysql-select-query-error-in-live-server-errcode-28-no-space-left-on-device Other than that, you may have run out of inodes, because of too many files: https://dba.stackexchange.com/questions/57543/mysql-error-28-no-space-left-on-the-device#57544
@panachoi commented on GitHub (Jan 20, 2021):
Its very strange.
The database is remote, and has plenty of space, both where the DB is stored and in /tmp (tmpfs) and plenty of inodes.
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 46G 23G 21G 53% /
tmpfs 1.0G 0 1.0G 0% /tmp
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda1 3.0M 70K 2.9M 3% /
tmpfs 248K 16 248K 1% /tmp
Hence my confusion.
@marcelklehr commented on GitHub (Jan 20, 2021):
This may explain your problems. Some of your indexes may be broken: https://github.com/marcelklehr/floccus/issues/792
@panachoi commented on GitHub (Jan 20, 2021):
I'm just wondering how they got broke, at the moment. Was working without issues, and other than updating floccus, the server hasn't been touched (still running 19.0.1, I think).
@marcelklehr commented on GitHub (Jan 20, 2021):
Have you ever had to recover a db backup?
@panachoi commented on GitHub (Jan 21, 2021):
No, This is the "original" database that was created at installation of nextcloud (version of 17.0.1, migrated to 18.0.4 and currently 19.0.4). Everything else seems to work fine, just bookmarks appears broken, after updating the the latest Floccus App a few days ago. Maybe related to #792. ?
@marcelklehr commented on GitHub (Jan 21, 2021):
Mh. Floccus shouldn't be able to break your server.
@mnalis commented on GitHub (Jan 21, 2021):
No space left on deviceerror can also happen if filesystem implements disk quotas for users or groups. (usually checked withquota username)Another possibility might be if nextcloud itself enforces its disk usage per nextcloud user (I know it does it for pictures and files, but I have no idea if other extensions like bookmarks might also be subject to those limits).
@panachoi also, do you have other filesystems? mysql database is usually stored under
/var/lib/mysql, which might be different partition than/@panachoi commented on GitHub (Jan 27, 2021):
The mysql database is remote; there are no users and no quotas on the DB or Nextcloud servers, and there is plenty of space in /tmp on both instances. So this looks like an "internal" mysql thing to me, although I cannot say exactly where the issue is, just that floccus stopped working. I dont think this particular problem is related to #792, because my queries do not run slowly at all.
@mnalis commented on GitHub (Jan 27, 2021):
@panachoi You should check with admin of your remote mysql instance, it looks like it is running out of space (or hitting quota). The
No space left on deviceis usually very specific and does not happen unless that is exactly the case what the error says. It is just a matter of finding on what host (if they are multiple ones involved as with your case) and on what partition it is running out of space.@marcelklehr commented on GitHub (Jan 30, 2021):
@mnalis Thank you for chiming in with your expertise! ❤️ Shall we continue this over at #792? OP seems unresponsive.
@github-actions[bot] commented on GitHub (Mar 21, 2023):
This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.