[GH-ISSUE #1017] MySQL on Nextcloud high CPU post sync #670

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

Originally created by @Xtropy74 on GitHub (Jan 17, 2022).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/1017

Describe the bug

After Floccus syncs with Bookmarks in NextCloud there is a query that runs and never stops, maxing out all CPU cores

To Reproduce

Steps to reproduce the behavior:

  1. Sync Floccus to NextCloud
  2. On the Server, run: sudo mysqladmin -p processlist
  3. See the following nextcloud database process details:
SELECT `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`cl

Expected behavior

The query ends (ended process after 48 hours stuck in this state)

Desktop

(please complete the following information)

  • OS: Windows 10
  • Browser Chrome and Brave
  • Browser Version 1.33
  • Floccus version: 4.8.7
  • Floccus sync method: nextcloud

Server

  • OS: Ubuntu 20.04
  • Nextcloud version: 22.2.3
  • Bookmarks app version: 10.0.3

Additional context

If I disable the "Bookmarks" app in NextCloud, the issue is resolved (but obviously can't use Floccus sync).

Originally created by @Xtropy74 on GitHub (Jan 17, 2022). Original GitHub issue: https://github.com/floccusaddon/floccus/issues/1017 ### Describe the bug After Floccus syncs with Bookmarks in NextCloud there is a query that runs and never stops, maxing out all CPU cores ### To Reproduce Steps to reproduce the behavior: 1. Sync Floccus to NextCloud 2. On the Server, run: sudo mysqladmin -p processlist 3. See the following nextcloud database process details: ``` SELECT `b`.`id`, `b`.`url`, `b`.`title`, `b`.`description`, `b`.`lastmodified`, `b`.`added`, `b`.`cl ``` ### Expected behavior The query ends (ended process after 48 hours stuck in this state) ### Desktop (please complete the following information) - OS: Windows 10 - Browser Chrome and Brave - Browser Version 1.33 - Floccus version: 4.8.7 - Floccus sync method: nextcloud ### Server - OS: Ubuntu 20.04 - Nextcloud version: 22.2.3 - Bookmarks app version: 10.0.3 ### Additional context If I disable the "Bookmarks" app in NextCloud, the issue is resolved (but obviously can't use Floccus sync).
kerem 2026-02-25 22:37:48 +03:00
  • closed this issue
  • added the
    bug
    label
Author
Owner

@Xtropy74 commented on GitHub (Jan 26, 2022):

Issue has resolved itself. Maybe related to a package update on Ubuntu as Nextcloud, Bookmarks and Floccus were not updated.

<!-- gh-comment-id:1022394884 --> @Xtropy74 commented on GitHub (Jan 26, 2022): Issue has resolved itself. Maybe related to a package update on Ubuntu as Nextcloud, Bookmarks and Floccus were not updated.
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.

<!-- gh-comment-id:1476308074 --> @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.
Sign in to join this conversation.
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#670
No description provided.