Page 1 of 3

Database upgrade on 1st December

Posted: 30 November 2020, 17:21
by Een
Hello devs,

Following several reports about slow connections to the current studio gamserver database (where you can check on the current state of the database created for your game), we are going to switch to a new database tomorrow morning (around 9:00 CET).

This means that ongoing games on the studio will be broken, so it's probably best if you express stop them in advance.

Thanks and let's see tomorrow if we can get some snappy response times from a new DB!

Re: Database upgrade on 1st December

Posted: 01 December 2020, 10:19
by Een
New database has been set up. Should be more snappy launching games and accessing your games databases.
Please let us know your feedback!

Re: Database upgrade on 1st December

Posted: 01 December 2020, 13:32
by Tisaac
Een wrote: 01 December 2020, 10:19 New database has been set up. Should be more snappy launching games and accessing your games databases.
Please let us know your feedback!
That's too fast, gotta fill a bug report :evil:

Just kidding, this is perfect ! :D
Thanks !

Re: Database upgrade on 1st December

Posted: 01 December 2020, 22:49
by Een
Great, thanks for the feedback :)

Re: Database upgrade on 1st December

Posted: 02 December 2020, 00:13
by tchobello
Absolutely Fabulous

Re: Database upgrade on 1st December

Posted: 02 December 2020, 11:06
by RicardoRix
Een wrote: 01 December 2020, 10:19 New database has been set up. Should be more snappy launching games and accessing your games databases.
Please let us know your feedback!
Buttons: 'Load 1', 'Load 2' are not working. The game stays in the same state. Pretty sure this was working yesterday.

Re: Database upgrade on 1st December

Posted: 02 December 2020, 18:07
by Hornir91
Really big thanks with solving the problem. Accessing db in the last weeks was a nightmare.

But there is a problem. When I want to check something in my tables, I can't get into them, because SQL request is wrong.

I'm receiving this message in the error window:
#1146 - Table 'phpmyadmin.pma__tracking' doesn't exist

It only occurs in the new server "leto.boardgamearena.com".

There is nothing wrong with previous server "localhost" in which I have tables from my previous test games (but waiting time is big).

Could you fix it? Thanks in advance.

Re: Database upgrade on 1st December

Posted: 02 December 2020, 18:15
by paramesis
RicardoRix wrote: 02 December 2020, 11:06
Een wrote: 01 December 2020, 10:19 New database has been set up. Should be more snappy launching games and accessing your games databases.
Please let us know your feedback!
Buttons: 'Load 1', 'Load 2' are not working. The game stays in the same state. Pretty sure this was working yesterday.
I can confirm that these aren't working.
Hornir91 wrote: 02 December 2020, 18:07 When I want to check something in my tables
Were these tables created prior to the database update? If so, see Een's first message - they will need to be express-stopped. (go to /table?table=NNNNN)

Re: Database upgrade on 1st December

Posted: 02 December 2020, 18:47
by Hornir91
paramesis wrote: 02 December 2020, 18:15 Were these tables created prior to the database update?
They were freshly started, few minutes before checking in db.

Re: Database upgrade on 1st December

Posted: 02 December 2020, 21:05
by Lunalol
I confirm that load/save doesn't work for old and new tables.