Issue Bug Closed

#86591Cannot update extensions when using galera cluster

Anastasios Sotiropoulos 10/08/18, 09:28 updated 05/07/19, 12:17

Description

After installing typo3 using a Galera Cluster with mysql, the extension list cannot be updated, throwing the error “No extension repository was found.“
There is a correct row in tx_extensionmanager_domain_model_repository:

SELECT * FROM tx_extensionmanager_domain_model_repository\G;
*************************** 1. row ***************************
uid: 3
title: TYPO3.org Main Repository
description: Main repository on typo3.org. This repository has some mirrors configured which are available with the mirror url.
wsdl_url: https://typo3.org/wsdl/tx_ter_wsdl.php
mirror_list_url: https://repositories.typo3.org/mirrors.xml.gz
last_update: 1346191200
extension_count: 0
pid: 0

however the uid here is 3. On a typical mysql database the uid is 1. This is an expected behaviour since there are 3 nodes in the tested multi-master setup (https://mariadb.org/auto-increments-in-galera/)
If the uid is changed to 1, everything works fine:

Temporary solution: UPDATE tx_extensionmanager_domain_model_repository SET uid=1 WHERE uid=3;

Reviews 1