Page 5 of 6

Re: statsdb on the fritz again

Posted: Mon Jun 06, 2022 7:47 pm
by leon
You can wipe only me. I don't care.

Re: statsdb on the fritz again

Posted: Mon Jun 06, 2022 7:50 pm
by Enyo
infinitecat wrote: Mon Jun 06, 2022 6:28 pm A complete wipe will make the team balancer a bit useless for a while but it'll right itself eventually.
No, the balancer doesn't rely on the statsDB, they're not connected. Balancer stores its own pph stats.

Re: statsdb on the fritz again

Posted: Tue Jun 07, 2022 8:03 am
by pooty
StatsDB has been reinitialized.
It still keeps all the code/table changes I made, but does give us more time to find the 65535 bug on kills.

Re: statsdb on the fritz again

Posted: Tue Jun 07, 2022 9:53 am
by Enyo
pooty wrote: Tue Jun 07, 2022 8:03 am StatsDB has been reinitialized.
It still keeps all the code/table changes I made, but does give us more time to find the 65535 bug on kills.
The RMD guys apparently figured it out, their statsDB numbers, including kills, goes way above 65535. Maybe send rockalien or wacko a message on their forum to see what they did to fix it?

Re: statsdb on the fritz again

Posted: Tue Jun 07, 2022 9:58 am
by infinitecat
HELLO-HELLO-hello-ello-lo-o.

Re: statsdb on the fritz again

Posted: Tue Jun 07, 2022 2:30 pm
by infinitecat
I just checked the stats page and there are a few players already listed in the rankings but the data seems to be pulled from matches that were played back in April and May. Are these just stray DNA remnants of the previous DB?

Re: statsdb on the fritz again

Posted: Tue Jun 07, 2022 6:26 pm
by McLovin
infinitecat wrote: Tue Jun 07, 2022 2:30 pm I just checked the stats page
...
Which is the real stats page?

https://www.gametracker.com/server_info ... 3.41:7777/

https://omnipotents2.site.nfoservers.co ... nkings.php

Re: statsdb on the fritz again

Posted: Wed Jun 08, 2022 7:37 am
by pooty
Real Stats page is on this domain omnipotents.com

The GameTracker "stats" is nothing but sum of your score and basically worthless.
The RMD guys apparently figured it out, their statsDB numbers, including kills, goes way above 65535. Maybe send rockalien or wacko a message on their forum to see what they did to fix it?
Probably worth a message, I suspect that they are using a different backend database which likely doesn't have this bug...otherwise I think the UTstats would have fixed it. I'll dust off my RMD login and ask.

Re: statsdb on the fritz again

Posted: Tue Jun 28, 2022 11:45 am
by captainsnarf
I noticed utstatsdb supports multiple database backends. It seems we are using MySql. I think if we used a different db backend the 65535 limit would go away. Maybe next time it needs reset (probably years away) we could switch to sqlite.

Re: statsdb on the fritz again

Posted: Tue Jun 28, 2022 2:37 pm
by McLovin
captainsnarf wrote: Tue Jun 28, 2022 11:45 am ...
65535 limit would go away.
...
OMGosh, some jackass chose a 2-byte short integer instead of a long integer. Had guys trying to use 4-byte floats once. Ripped that bitch code out and replaced all their floats with doubles, LOL