[Scheduled maintenance] Damned Lies (l10n.gnome.org) - 23th of November 2024 at 2:30 - 3:30 PM UTC

Infrastructure
,
1

Hello,

This upcoming Saturday we will be migrating Damned Lies (l10n.gnome.org) to our new cluster (as previously announced at GNOME Infrastructure migration to AWS · Andrea Veri's Blog). The expected downtime will be approximately one hour, what we have planned is:

  1. One last data synchronization between the 2 sites
  2. Database dump, migration from mysql to psql, import
  3. DNS change and service restoration

CC @gbernard

Thanks,
Andrea

2 Likes
2

I am anticipating a little bit and the services will be shut down soon to anticipate the time to migrate the database.

1 Like
3

https://status.gnome.org/ has an entry for this maintenance. Just FYI.

status.gnome.org.l10n

4

The migration was completed, please let us know of any possible issue you may be experiencing, thanks!

5

I did two different actions in two workflows, and both times the action shows at the top of the history instead of the bottom.

6

Could it be a database id thing, where the new events are numbered starting from an earlier index (maybe even 1) instead of starting from the proper increment?

7

Good catch.

   id    |         name          |            created            
---------+-----------------------+-------------------------------
       6 | WriteAComment         | 2024-11-23 18:14:33.93781+00
       4 | ReserveProofreading   | 2024-11-23 17:58:07.0627+00
       3 | WriteAComment         | 2024-11-23 17:52:23.345362+00

And so we have a problem :slight_smile:. I will manually update the increment values.

8

This error has been fixed, all the sequences have been restarted to the current maximum value (+1) of each autoincrement id :slight_smile: .