Problem

The update to Microblog Version 5.1.1 and onwards seems to take a lot of time.

Solution

This release fixed a bug that made spaces with micropost replies or edited posts undeletable.
Any update from previous versions might take several minutes.
This is because it is required to run through all replies and historical versions of posts.
We measured around 5 minutes update on an instance with around 16 thousand replies.

The progress can only be tracked by enabling INFO logging for net.seibertmedia.

If you want to check how many replies are on your system, you may want to run this SQL on your database (example made in PostgreSQL):

SELECT count(*) FROM content WHERE pluginkey = 'net.seibertmedia.plugin.confluence.microblog:micropostContent' AND prevver IS NOT NULL AND parentccid IS NOT NULL;

Explanation:

* content is the table with any content object in Confluence.
* pluginkey is the column that indicates our plugin's Micropost content object.
* prevver is a foreign key to the newest version of a post and NOT NULL indicates a historical version.
* parentccid is a foreign key to the parent post and NOT NULL indicates a reply.



  • No labels
This page was last edited on 05/22/2023.