Sudden constant disconnects/maintenance mode and high CPU usage

ā„¹ļø Support šŸ“¦ Appliances (Docker, Snappy, VM, NCP, AIO)
,
1

Hi

My windows client (windows-10.0.19045) recently started experiencing weird disconnects. The only way to connect again is to kill/restart the client.

When i looked into it I noticed that the webpage frequently (10-30 times an hour) states ā€œMaintenance Modeā€, and then after a few seconds or minutes displays the file list after refreshing the page a few times.

These brief switches to maintenance mode coincide with the windows client permanently loosing its connection.

When investigating further, I noticed that the CPU load was constantly high (50-90%) which is weird because it has been running on 1-20% mostly for the last few years.
Giving the VM (qemu/proxmox) two more cores and doubling the RAM (4 ā†’ 8GB) mitigated the CPU load linearly, but did not stop the constant maintenance modes/disconnects.

I am only one user with four devices accessing the server, this has not changed for the past 2-3 years.
My server is 25.0.6, running as a snap on Ubuntu 22.04.2 LTS (fully updated, both Snap and packages).

The logs in nextcoud present the followin two errors frequently:

  1. " OCA\Circles\Exceptions\MigrationException: A migration process is already running"

  2. ā€œDoctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ā€˜625-bookmark-1ā€™ for key ā€˜oc_bookmarks_tree.PRIMARYā€™ā€

Iā€™m scratching my head and do not even know where to start looking for a source to thisā€¦ Any help or guidance would be greatly appreciated.

2

I think I finally solved it.
First I set the logging policy to ā€œwarningā€ instead of the default setting ā€œdebugā€, which actually lowered the load from above 1 to 0.90-0.99.

The second error message stated that there was no app involved, but when I read it more carefully I saw that it repeatedly mentions ā€œbookmarkā€ in the body of the message.
I disabled the ā€œbookmarksā€ app and the error dissappeared, and now the server runs smoothly/stably again.

I liked the bookmarks app, but I guess Iā€™ll have to look for an alternative.