starred/floccus

Fork 0

mirror of https://github.com/floccusaddon/floccus.git synced 2026-04-25 14:16:12 +03:00

[GH-ISSUE #1069] Browser sync results in huge SEELCT Query Result #711

New issue

Closed

opened 2026-02-25 22:37:53 +03:00 by kerem · 2 comments

kerem commented

2026-02-25 22:37:53 +03:00

Owner

Originally created by @LotusAxt on GitHub (Mar 8, 2022).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/1069

Which version of floccus are you using?

4.10.1

Sync method

{"label"=>"Nextcloud Bookmarks"}

Which browser are you using?

Vivaldi 5.1.2567.57 (Stable channel) (64-bit)

Which version of Nextcloud Bookmarks are you using? (if relevant)

10.1.0

Which version of Nextcloud? (if relevant)

23.0.2

What kind of WebDAV server are you using? (if relevant)

No response

Describe the Bug

If my Browser tries to sync my Bookmarks it creates the following Query (Result of 'MariaDB [(none)]> SHOW FULL PROCESSLIST\G'):

*************************** 6. row ***************************
      Id: 237
    User: oc_Admin
    Host: 172.17.0.10:49214
      db: rp_nextcloud
 Command: Query
    Time: 3286
   State: Sending data
    Info: SELECT `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`clickcount`, `b`.`last_preview`, `b`.`available`, `b`.`archived_file`, `b`.`user_id`, `b`.`text_content`, `b`.`html_content`, GROUP_CONCAT(`tree`.`parent_folder`) AS `folders`, GROUP_CONCAT(`t`.`tag`) AS `tags` FROM `oc_bookmarks` `b` LEFT JOIN `oc_bookmarks_tree` `tree` ON b.id =tree.id AND tree.type = 'bookmark' LEFT JOIN `oc_bookmarks_tags` `t` ON `t`.`bookmark_id` = `b`.`id` LEFT JOIN `oc_bookmarks_tree` `tr` ON tr.id = b.id AND tr.type = 'bookmark' LEFT JOIN `oc_bookmarks_shared_folders` `sf` ON `tr`.`parent_folder` = `sf`.`folder_id` LEFT JOIN `oc_bookmarks_tree` `tr2` ON tr2.id = tr.parent_folder AND tr2.type = 'folder' LEFT JOIN `oc_bookmarks_shared_folders` `sf2` ON `tr2`.`parent_folder` = `sf`.`folder_id` WHERE ((`b`.`user_id` = 'XXX') OR (`sf`.`user_id` = 'XXX') OR (`sf2`.`user_id` = 'XXX')) AND (`b`.`user_id` IN ('XXX')) GROUP BY `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`clickcount`, `b`.`last_preview`, `b`.`available`, `b`.`archived_file`, `b`.`user_id`, `b`.`text_content`, `b`.`html_content`, `b`.`id` ORDER BY `b`.`added` DESC, `b`.`id` ASC LIMIT 42
Progress: 0.000

This thing runs forever on my DB and results a ~1TB temp table file, before I killed the query. (With mariaDB 10)

Expected Behavior

A sensible Query runtime.

To Reproduce

For me it happens each time the Browser on my PC tries to sync the Bookmarks.

Debug log provided

I have provided a debug log file

Originally created by @LotusAxt on GitHub (Mar 8, 2022). Original GitHub issue: https://github.com/floccusaddon/floccus/issues/1069 ### Which version of floccus are you using? 4.10.1 ### Sync method {"label"=>"Nextcloud Bookmarks"} ### Which browser are you using? Vivaldi 5.1.2567.57 (Stable channel) (64-bit) ### Which version of Nextcloud Bookmarks are you using? (if relevant) 10.1.0 ### Which version of Nextcloud? (if relevant) 23.0.2 ### What kind of WebDAV server are you using? (if relevant) _No response_ ### Describe the Bug If my Browser tries to sync my Bookmarks it creates the following Query (Result of 'MariaDB [(none)]> SHOW FULL PROCESSLIST\G'): ```SQL *************************** 6. row *************************** Id: 237 User: oc_Admin Host: 172.17.0.10:49214 db: rp_nextcloud Command: Query Time: 3286 State: Sending data Info: SELECT `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`clickcount`, `b`.`last_preview`, `b`.`available`, `b`.`archived_file`, `b`.`user_id`, `b`.`text_content`, `b`.`html_content`, GROUP_CONCAT(`tree`.`parent_folder`) AS `folders`, GROUP_CONCAT(`t`.`tag`) AS `tags` FROM `oc_bookmarks` `b` LEFT JOIN `oc_bookmarks_tree` `tree` ON b.id =tree.id AND tree.type = 'bookmark' LEFT JOIN `oc_bookmarks_tags` `t` ON `t`.`bookmark_id` = `b`.`id` LEFT JOIN `oc_bookmarks_tree` `tr` ON tr.id = b.id AND tr.type = 'bookmark' LEFT JOIN `oc_bookmarks_shared_folders` `sf` ON `tr`.`parent_folder` = `sf`.`folder_id` LEFT JOIN `oc_bookmarks_tree` `tr2` ON tr2.id = tr.parent_folder AND tr2.type = 'folder' LEFT JOIN `oc_bookmarks_shared_folders` `sf2` ON `tr2`.`parent_folder` = `sf`.`folder_id` WHERE ((`b`.`user_id` = 'XXX') OR (`sf`.`user_id` = 'XXX') OR (`sf2`.`user_id` = 'XXX')) AND (`b`.`user_id` IN ('XXX')) GROUP BY `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`clickcount`, `b`.`last_preview`, `b`.`available`, `b`.`archived_file`, `b`.`user_id`, `b`.`text_content`, `b`.`html_content`, `b`.`id` ORDER BY `b`.`added` DESC, `b`.`id` ASC LIMIT 42 Progress: 0.000 ``` This thing runs forever on my DB and results a ~1TB temp table file, before I killed the query. (With mariaDB 10) ### Expected Behavior A sensible Query runtime. ### To Reproduce For me it happens each time the Browser on my PC tries to sync the Bookmarks. ### Debug log provided - [ ] I have provided a debug log file

kerem

2026-02-25 22:37:53 +03:00

closed this issue
added the
bug
label

kerem commented

2026-02-25 22:37:54 +03:00

Author

Owner

@marcelklehr commented on GitHub (Mar 8, 2022):

Please see https://github.com/nextcloud/bookmarks/issues/1661

@marcelklehr commented on GitHub (Mar 8, 2022): Please see https://github.com/nextcloud/bookmarks/issues/1661

kerem commented

2026-02-25 22:37:54 +03:00

Author

Owner

@github-actions[bot] commented on GitHub (Mar 20, 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.

@github-actions[bot] commented on GitHub (Mar 20, 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.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/floccus#711

No description provided.

Rows
Columns