statsdb on the fritz again
Re: statsdb on the fritz again
You can wipe only me. I don't care.
Re: statsdb on the fritz again
No, the balancer doesn't rely on the statsDB, they're not connected. Balancer stores its own pph stats.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.
“Never argue with stupid people, they will drag you down to their level and then beat you with experience.”
― Mark Twain
― Mark Twain
- pooty
- Posts: 4486
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: statsdb on the fritz again
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.
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
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?
“Never argue with stupid people, they will drag you down to their level and then beat you with experience.”
― Mark Twain
― Mark Twain
- infinitecat
- Posts: 144
- Joined: Tue Jun 08, 2021 3:02 pm
- Location: Dallas
Re: statsdb on the fritz again
HELLO-HELLO-hello-ello-lo-o.
- infinitecat
- Posts: 144
- Joined: Tue Jun 08, 2021 3:02 pm
- Location: Dallas
Re: statsdb on the fritz again
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?
- pooty
- Posts: 4486
- Joined: Sat Apr 03, 2021 10:22 am
- Location: Michigan
- Server Sponsor: Yes
- Server Admin: Yes
Re: statsdb on the fritz again
Real Stats page is on this domain omnipotents.com
The GameTracker "stats" is nothing but sum of your score and basically worthless.
The GameTracker "stats" is nothing but sum of your score and basically worthless.
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.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?
- captainsnarf
- Posts: 2682
- Joined: Tue Jul 06, 2021 1:51 pm
- Location: Washington
- Server Sponsor: Yes
- Server Admin: Yes
- Contact:
Re: statsdb on the fritz again
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.
- McLovin
- Posts: 1191
- Joined: Sat Apr 03, 2021 12:54 pm
- Location: Salt Lake City, Utah
- Server Sponsor: Yes
- Server Admin: Yes
Re: statsdb on the fritz again
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