Subscribers count not updating

Referencing this issue here - https://github.com/appwrite/appwrite/issues/7892

Strange thing is as Steven mentioned here - https://discord.com/channels/564160730845151244/636852860709240842/1250259972776919134, it could be a permission issue but this doesn't show any error.

I also noted the return value of this block of code that handles the subscriber count -

Authorization::skip(fn () => $dbForProject->increaseDocumentAttribute(
    'topics',
    $topicId,
    $totalAttribute,
));

The return value is 1 which means the operation succeeded.

Alternatively, I manually updated the mariadb row (as linked in the github issue) and strangely, after manually updating the row, the changes from console are properly reflected. But a new topic again has same issue.

Any ideas <@462046107556511744>?

The server is the same as restored from here - https://discord.com/channels/564160730845151244/1228630098241126401/1228630098241126401

Could it be that the DB has some issues? Is there a way to repair the DB?

Update: locally hosted version works, and a different appwrite server running 1.5.4 seems to work as well. I guess this is a db issue.

Update: I discussed this with Matej and seem to have found a possible issue.