MaRDI4NFDI / docker-wikibase

Wikibase Docker image with preinstalled extensions for the MaRDI-Portal
2 stars 0 forks source link

Migration to 1.43-wmf9 #156

Closed physikerwelt closed 4 months ago

physikerwelt commented 4 months ago

MaRDI Pull Request

Changes:

Instructions for PR review:

Checklist for this PR:

physikerwelt commented 4 months ago

There was a blocker with wmf9 https://phabricator.wikimedia.org/T367334 which I think should not affect us

physikerwelt commented 4 months ago

@eloiferrer deplpyed to staging https://staging.mardi4nfdi.org/wiki/Special:Version I didn't see issue so far. Can you double-check.

physikerwelt commented 4 months ago

The respective migration requires manual intervention, though.


 Modifying rev_id field of table revision...Wikimedia\Rdbms\DBQueryError from line 1195 of /var/www/html/includes/libs/rdbms/database/Database.php: Error 1833: Cannot change column 'rev_id': used in a foreign key constraint 'mathindex_ibfk_1' of table 'my_wiki.mathindex'
Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/maintenance/archives/patch-revision-cleanup.sql )
Query: ALTER TABLE `revision`
 CHANGE rev_id rev_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
 CHANGE rev_comment_id rev_comment_id BIGINT UNSIGNED NOT NULL,
 CHANGE rev_actor rev_actor BIGINT UNSIGNED NOT NULL,
 CHANGE rev_parent_id rev_parent_id BIGINT UNSIGNED DEFAULT NULL
physikerwelt commented 4 months ago
alter table mathindex drop foreign key mathindex_ibfk_1;
Query OK, 0 rows affected (0.063 sec)
Records: 0  Duplicates: 0  Warnings: 0
MariaDB [my_wiki]> drop table mathrevisionstat;
Query OK, 0 rows affected (0.031 sec)

MariaDB [my_wiki]> drop table mathindex;

The easiest solution is to delete the respective tables in mathsearch and reindex the formulae.