Anyone else getting a lot of unexpected errors while moderating the queue?

[Thanatos_Prime]

I hate to be the bearer of bad news, but Moderation is not responding this morning. It just fails to load, all browsers.

[Mr. Shizzy]

Still having trouble adding new (Nintendo Switch) games to the database.  When I hit submit, it loads forever.  This seems to happen about 75% of the time.  Happening on both Opera and Chrome (Windows).

[Thanatos_Prime]

I'm back to getting an error when moderating, starting again yesterday and now much more frequent. It seems to be more prevalent as I get closer to finishing. Happens in all browsers and in browser with no add-ins.

 

[C-Beats]

37 minutes ago, Thanatos_Prime said:

I'm back to getting an error when moderating, starting again yesterday and now much more frequent. It seems to be more prevalent as I get closer to finishing. Happens in all browsers and in browser with no add-ins.

 

Thanks, had a few bad change records that were failing to apply. I cleaned them up which hopefully removes this. Let us know if you keep seeing it.

[Jakatsu]

20 hours ago, C-Beats said:

Thanks, had a few bad change records that were failing to apply. I cleaned them up which hopefully removes this. Let us know if you keep seeing it.

I have a queue of ~150 and the error page is now appearing after almost every moderation.

Edited November 13, 2024 by Jakatsu

[Thanatos_Prime]

On 11/12/2024 at 7:16 AM, C-Beats said:

Thanks, had a few bad change records that were failing to apply. I cleaned them up which hopefully removes this. Let us know if you keep seeing it.

Yes, I am still seeing it as of right now.

[Thanatos_Prime]

On 11/12/2024 at 7:16 AM, C-Beats said:

Thanks, had a few bad change records that were failing to apply. I cleaned them up which hopefully removes this. Let us know if you keep seeing it.

Frankly, it appears to be getting worse.

[MJF]

On 11/12/2024 at 11:46 AM, C-Beats said:

Thanks, had a few bad change records that were failing to apply. I cleaned them up which hopefully removes this. Let us know if you keep seeing it.

It's WORSE now. It happens EVERY TIME you press accept or reject.

[C-Beats]

Thanks I looked in the DB again and found a few more bad change sets that were clogging up the system. We're looking into how these keep getting the in the DB. I'll do my best to update the thread when any new code gets deployed. I'll do my best to keep monitoring the DB until then but feel free to let us know if you keep seeing the issue. Will help us determine if we're looking into the same issue you're all getting tripped up by.

[Jakatsu]

2 minutes ago, C-Beats said:

Thanks I looked in the DB again and found a few more bad change sets that were clogging up the system. We're looking into how these keep getting the in the DB. I'll do my best to update the thread when any new code gets deployed. I'll do my best to keep monitoring the DB until then but feel free to let us know if you keep seeing the issue. Will help us determine if we're looking into the same issue you're all getting tripped up by.

Works fine now for me, no more error pages before or after getting to the end of the queue.

[C-Beats]

Just now, Jakatsu said:

Works fine now for me, no more error pages before or after getting to the end of the queue.

Thanks for confirming. Feel free to post up in here if that changes for you.

[C-Beats]

I have updated one of the processes that fetches the moderation item for you to skip these obviously bad change sets in an effort to keep the DB running smoothly while I track down the change. It MAY result in the page taking a slight bit longer to fetch a change to moderate but should stop the error from occurring at all. This will get reverted once the bug is found and the permanent correction is pushed to the server. Thanks all for the help tracking down this issue, and the patience in it's resolution. Both are much appreciated.

[Jakatsu]

Cool, thanks for keeping us updated. Good luck finding and squashing the bug, your work is greatly appreciated 👍

Edit: Saw the dreaded error page a couple of times again, but at least now it shows the correct page when your queue is empty.

Edited November 18, 2024 by Jakatsu

[C-Beats]

Code changes were just pushed to the server and the temporary fix removed. Not sure we got ALL the cause for errors, but should have at least nipped some of the more pressing bugs in this code change. I'll continue to monitor from my side, but let us know if the issues start to creep back in on your side of things.

[Jakatsu]

Saw one error yesterday and one today, so the fixes work pretty well and for the most part moderation goes without a hitch.

[Thanatos_Prime]

On 11/19/2024 at 8:50 AM, C-Beats said:

Code changes were just pushed to the server and the temporary fix removed. Not sure we got ALL the cause for errors, but should have at least nipped some of the more pressing bugs in this code change. I'll continue to monitor from my side, but let us know if the issues start to creep back in on your side of things.

Creeping back in, but just when I get down to the last 20-30 moderations 
 

[Jakatsu]

10 hours ago, Thanatos_Prime said:

Creeping back in, but just when I get down to the last 20-30 moderations

This, and once the queue is cleared, the error page pops up every single time you refresh the page.

[C-Beats]

Yeah, if the cause is something similar to before the less items in the queue the more often you're going to see it since the odds of tripping on the bad record are increased. I'll take a look and see what I can find out. Thanks for the heads up.

[LonestarK]

I'm getting about 3 to 5 of these for every request I successfully process.  Any ideas?

[C-Beats]

There were a few bad records in the DB again, I cleaned them out and should eliminate the error.