I’m on 3.19.0 of the Android mobile app. I just updated the server to 23.0.1.1 (RC3). Trying to fix my never ending cron jobs so tried the latest version to see if bugs have been fixed. The Android apps seems to periodically say the ‘server is in maintenance mode’. Its not - Server maintenance in config.php = false. Response time in general seems slow. If the app times out does the ‘server in maintenance mode’ message show?
Not running Collabora or nextcloud office. As a follow up I just received the following from my hosting provider: XYZ is my sanitized db name. For now I have disabled the bookmarks app to see if that heps. The broswer bookmarks extension Floccus seemed to have problems with lots of bookmarks with lots of subfolders and kept creating duplicates so may be a combination of these things?
Our server monitoring systems indicate excessive MySQL server load persistently maintained by your hosting account for XYZ.
Most of the MySQL load is caused by the following query:
SHOW TABLE STATUS FROM XYZ LIKE ‘oc_bookmarks_tree’\G
SHOW CREATE TABLE ‘XYZ’ .oc_bookmarks_tree`\G
SHOW TABLE STATUS FROM XYZ LIKE ‘oc_bookmarks_tags’\G
SHOW CREATE TABLE XYZ.oc_bookmarks_tags\G
SHOW TABLE STATUS FROM XYZ LIKE ‘oc_bookmarks_shared_folders’\G
SHOW CREATE TABLE XYZ.oc_bookmarks_shared_folders\G
EXPLAIN /!50100 PARTITIONS/
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_bookmarksb LEFT JOIN oc_bookmarks_treetree ON b.id =tree.id AND tree.type = ‘bookmark’ LEFT JOIN oc_bookmarks_tagst ON t.bookmark_id = b.id LEFT JOIN oc_bookmarks_treetr ON tr.id = b.id AND tr.type = ‘bookmark’ LEFT JOIN oc_bookmarks_shared_folderssf ON tr.parent_folder = sf.folder_id LEFT JOIN oc_bookmarks_treetr2 ON tr2.id = tr.parent_folder AND tr2.type = ‘folder’ LEFT JOIN oc_bookmarks_shared_folderssf2 ON tr2.parent_folder = sf.folder_id WHERE (((b.user_id = ‘me’) OR (sf.user_id = ‘me’) OR (sf2.user_id = ‘me’)) AND (b.user_id IN (‘me’))) AND (b.url = ‘https:deleted url’) 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.lastmodified DESC, b.id ASC LIMIT 10\G
It appears that the Bookmarks App is making these queries. A possible solution would be to delete all bookmarks, as advised here:
If this action doesn’t reduce the MySQL usage, you can try completely disabling this app and also optimize the authentication procedure, as advised here:
I fixed this runaway by deleting all of my bookmarks and disabling the bookmarks app. For whatever reason while this was going on the Android app thought the server was in maintenance mode despite it not being (maybe because of the runaway?)