Page 1 of 2

Server outage 2023-08-19

Posted: Sat Aug 19, 2023 7:30 pm
by boehmi
Hi all,

we had a server outage today around noon. We restored most of it from the backups we made in the morning.

That means some ranking games from this morning are lost.

A following things are not working yet and will be fixed tomorrow
*Logfile Analysis
*Leaderboard
*Gametable
*Champion of the day
*Monthly Cup website
*Registration / Password-Reset
*scotland flag in the forum are missing

Re: Server outage 2023-08-19

Posted: Sun Aug 20, 2023 10:27 am
by Deleted
And also Gametable

Re: Server outage 2023-08-19

Posted: Sun Aug 20, 2023 1:22 pm
by Deleted
Hello.
Login, registration and access to game tables were failing this morning again.

Re: Server outage 2023-08-19

Posted: Sun Aug 20, 2023 2:41 pm
by boehmi
EXTAZ wrote: Sun Aug 20, 2023 1:22 pm Hello.
Login, registration and access to game tables were failing this morning again.
Login works, otherwise you would not have been able to make this post. Sometimes the Cloudflare cache gives an error, but after a browser refresh everything works.

There seems to be a problem with registrations thought. But strangely I can see new registrations in the database.

Re: Server outage 2023-08-19

Posted: Mon Aug 21, 2023 1:01 am
by sp0ck
  • Log-File-Analysis
    Leaderboard
    Gametable
    Champion of the Day
    Registration & Password-Reset


... are all working again.

Sorry for inconveniences and thank you for your patience!

Re: Server outage 2023-08-19

Posted: Mon Aug 21, 2023 9:25 am
by Andrew4
The games from yesterday and today still don't give points. Will this be changed? Had three times first place :'( ...

Re: Server outage 2023-08-19

Posted: Mon Aug 21, 2023 11:56 am
by Follak
New game results are not shown in stats.

I've played this game today:
gametable?u1=Follak&u2=Kitty%20Samt&u3= ... =name_sunl

But on my profile page I don't see that result: player?u=Follak

Only stats till 18-08 are shown.

Re: Server outage 2023-08-19

Posted: Mon Aug 21, 2023 1:08 pm
by boehmi
Andrew4 wrote: Mon Aug 21, 2023 9:25 am The games from yesterday and today still don't give points. Will this be changed? Had three times first place :'( ...
The games are not lost, they are written in the database correctly. But there is a problem with the database table which is used to create the ranking and updates the user profile. As soon as we find the problem, we can fix all the games since Saturday noon.

But we can't promise to fix it today.

Re: Server outage 2023-08-19

Posted: Mon Aug 21, 2023 11:33 pm
by mr.Botsman
thank you for explain about games-result stats.
we waiting fix this issue with patience

Re: Server outage 2023-08-19

Posted: Tue Aug 22, 2023 8:05 pm
by boehmi
mr.Botsman wrote: Mon Aug 21, 2023 11:33 pm thank you for explain about games-result stats.
The db backups didn't include functions und procedures. sp0ck will fix it by tomorrow hopefully.