Embed Notice

@dansup
Great, thanks.

Now my issue is solved! This is how I achieved it and I'm unsure why this actually worked, but it appears the problem has disappeared.

1. Updated the code in account-post-count-stat-update to call getAllPostCountIncr(1000) with an arbitrary limit.

2. Executed manually the updated routine, took about one minute but executed successfully.

3. Restored the original code in account-post-count-stat-update to call getAllPostCountIncr() with no limit.

4. Now it executes in less than a second, and the scheduled job no longer hogs any resources.

Maybe this eliminated a rogue entry in DB/Redis which led to an infinite loop?

I will monitor the situation but it seems ok so far.

Thanks for your answers, and many thanks to all your contributions and efforts to the Fediverse!