UPDATE: Pootle downtime / translations.documentfoundation.org

Hi,

the database migration is currently running, but due to the amount of data in our database and the not very efficient design of MySQL regarding ALTER TABLE operations it is taking longer than expected.

Alex

The database migration is still in progress as of Wednesday, 20 April, 1230 UTC.
It is taking longer than expected by the pootle experts.

Details about the ongoing migration:

- The current database migration is the addition of a column to the largest table of pootle
- The size of the tablespace for this table alone is over 33G
- The MySQL/InnoDB database that is used uses a temporary table to store the data while a new table with the additional column is created
- The size of the temporary table is currently 9.3G
- The tablespace for the original table of 33G may contain unused space due to the structure of InnoDB
- In worst case scenario, the migration of this table alone might take until Friday

After evaluating the different options (continuing migration/aborting migration and downgrade), we decided to continue on until Friday Noon. If no sufficient progress was made by then, the migration will be aborted and the pootle installation downgraded.

For up-to-date information, see http://status.documentfoundation.org/pootle-update.html

Hello,

The database migration is still in progress as of Wednesday, 20 April, 1230 UTC.
It is taking longer than expected by the pootle experts.

thanks so much to you and Cloph for all your hard work on this and the long night shift - kudos!

Florian

Hi,

the pootle database migration is still running. Christian and I decided to let the Migration keep running and tightly monitor the status.

I’ll keep you posted,
Alex

Hi,

the pootle migration has been completed. We will look for solutions to minimize the downtime for further migrations.

Thanks,
Alex

Hi,

the file translation statistics are currently updating, so it might take some time to show the translation state for languages, projects, files and so on.

Sorry for the inconvenience,
Alex