Gesendet: Montag, 12. Juni 2017 um 19:51 Uhr Von: "Stanislav Brabec" An: "Sarah Julia Kriesch" , OS-trans Betreff: Re: [opensuse-translation] Weblate upgrade planned (several days outage expected)

Sarah Julia Kriesch wrote:

...

1) You can do the migration during the working week. Most translotors are working then and want to translate during the weekend.

Keeping weekends on-line was my intention as well. Then I would say: "Do it!" :-) But look after the activity in different languages before choosing the day. It seems the middle of the week is the best time. Some people have contributed on Monday a lot, too. This week is bad, because we have got a public holiday on Thursday and some people want to have a free Friday then. Tell us what you want to choose. So we can plan our translations.

...

2) We wait for the release day of Leap. If Stanislav wants to use a special version of Weblate, he can download it now. Generally open source projects have got a download page with a list with all released (old) versions. He can use it, too.

I always wanted to use the latest version. But SLE12 (SP1) was not a good decision for Weblate. It lacks too many packages, backporting them took many time, and often failed.

It caused delay in regular updates. It not only became outdated, running an unsupported weblate version on an unsupported OS. It is so old version that the migration to the new version is even not supported! We have to use intermediate upgrade to succeed.

Now we finally have a working packages for Leap 42.2 and we also solved all migration problems. Everything compiles, upgrade succeeds with a special process on a testing copy of the current L10N snapshot, no data is lost.

Did you think about using 42.3 for that? Christian and I want to rollout the test wiki on 42.3 before the release day.

...

Another question about the migration migration process: What is the reason for the change from mysql to postgresql?

Postgres is the main development platform of Weblate. We are probably the only large instance of Weblate using MariaDB and Apache.

Also openSUSE infrastructure people prefer postgres, as it already serves large part of the infrastructure.

...

That will be a difficult change. Postgres isn't the same and I was allowed to repair such a database in the last year. I believe, you will have such problems during the migration, too.

Hopefully, Weblate is a Django application, and most database differences are hidden behind Django.

We already performed the change on a testing instance, and everything worked.

We met only technical problems in this migration:

- Current Django migration tools import the whole database into the memory. It requires about 32 GB RAM or swap.

- Some tables are dependent on other tables. These have to be created in a correct order in a destination database.

...

But "Thank you for the upgrade in the future! The change management process sounds really good."

We tried the migration process on a L10N snapshot many times before I was able to send this mail.

-- Best Regards / S pozdravem,

Stanislav Brabec software developer

I am happy having you in the Heroes Team. :-) One hint for the next change: Split your information mail into 2 emails (heroes and translation)in the future, please. The change management and downtime is important for most heroes. We can review that and you can receive your "Go!" there. Sometimes that will be a topic in the Heroes meeting. Not every Translator is interested for the change management process. Translators want to have a online system and need only the planned downtime. You can ask on the translation mailinglist for the preferred time/ date. After that you can have a perfect organized change. :-) We are a minimum of 3 Heroes on this mailinglist now (Ludwig, I and you). So you can receive feedback by us. But a review by others would give you more security. Best regards, Sarah -- To unsubscribe, e-mail: opensuse-translation+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-translation+owner@opensuse.org

Gesendet: Dienstag, 13. Juni 2017 um 15:19 Uhr Von: "Stanislav Brabec" An: "Sarah Julia Kriesch" Cc: OS-trans Betreff: Re: [opensuse-translation] Weblate upgrade planned (several days outage expected)

Sarah Julia Kriesch wrote:

...

But look after the activity in different languages before choosing the day. It seems the middle of the week is the best time. Some people have contributed on Monday a lot, too. This week is bad, because we have got a public holiday on Thursday and some people want to have a free Friday then. Tell us what you want to choose. So we can plan our translations.

What about next week, starting with Tuesday? If everything will succeed on the first try, it will be back online with a new version on Thursday. In case or one problem, it will be back in Friday. In case of two problems (power outage, out of memory etc.), i will switch the old instance back to R/W mode in Friday, and start next try on the next Tuesday.

Once we will get a consensus on the date, I will send a separate mail. That sounds good for me. Let's wait for other opinions. I hope the first try would succeed. ;-)

Or will other translators have public holidays next week and you want to translate Thursday until Tuesday? Then say it, please. Best regards, Sarah -- To unsubscribe, e-mail: opensuse-translation+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-translation+owner@opensuse.org