statsdb on the fritz again

Discuss and provide feedback on Maps.
User avatar
leon
Posts: 171
Joined: Tue Jun 08, 2021 5:35 pm
Location: Clearwater, Florida

Re: statsdb on the fritz again

Post by leon »

You can wipe only me. I don't care.
User avatar
Enyo
Posts: 1626
Joined: Mon Apr 05, 2021 11:27 pm
Server Sponsor: Yes
Server Admin: Yes

Re: statsdb on the fritz again

Post 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.
“Never argue with stupid people, they will drag you down to their level and then beat you with experience.”
― Mark Twain
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: statsdb on the fritz again

Post 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.
User avatar
Enyo
Posts: 1626
Joined: Mon Apr 05, 2021 11:27 pm
Server Sponsor: Yes
Server Admin: Yes

Re: statsdb on the fritz again

Post 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?
“Never argue with stupid people, they will drag you down to their level and then beat you with experience.”
― Mark Twain
User avatar
infinitecat
Posts: 141
Joined: Tue Jun 08, 2021 3:02 pm
Location: Dallas

Re: statsdb on the fritz again

Post by infinitecat »

HELLO-HELLO-hello-ello-lo-o.
User avatar
infinitecat
Posts: 141
Joined: Tue Jun 08, 2021 3:02 pm
Location: Dallas

Re: statsdb on the fritz again

Post 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?
User avatar
McLovin
Posts: 1165
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

Post 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
User avatar
pooty
Posts: 4358
Joined: Sat Apr 03, 2021 10:22 am
Location: Michigan
Server Sponsor: Yes
Server Admin: Yes

Re: statsdb on the fritz again

Post 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.
User avatar
captainsnarf
Posts: 2632
Joined: Tue Jul 06, 2021 1:51 pm
Location: Washington
Server Sponsor: Yes
Server Admin: Yes
Contact:

Re: statsdb on the fritz again

Post 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.
User avatar
McLovin
Posts: 1165
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

Post 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
Post Reply