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.000This 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
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'):
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