Thanks for reporting this issue. We are planning to improve the situation by first reducing the schema drift between PG and MySQL: https://phabricator.wikimedia.org/T164898 and in the next step with abstracting schema and shcema changes https://phabricator.wikimedia.org/T191231
My request is that what exactly did you do to fix the issue? I want to turn them to patches so we fix the upgrade path for other PG instances. Thanks! On Tue, Jun 2, 2020 at 12:03 AM dabicho <[email protected]> wrote: > Solved it. Not sure if it is that something changed in postgres, but I > am using postgres 12 here. > After digging the source code and debugging the error messages, I > found a few places where it prepends 'default' to the name of tables > and sequences and other relations. > > After I commented out those calls, it worked > > On Sun, May 31, 2020 at 11:09 PM dabicho <[email protected]> wrote: > > > > Hello > > > > I am new to the list > > > > I am trying to upgrade my mediawiki installation from 1.31.7 to 1.34.1 > > and I am getting errors when executing php update.php. > > Same thing happened when trying to upgrade to 1.33.3 > > I have seen bug reports dating back to 2016. Last suggestion being to > > move such things to the public schema instead of the database schema. > > Is this safe/good idea? > > What other solution can I apply? > > > > ----------- Example of output -------------------- > > MediaWiki 1.34.1 Updater > > > > Your composer.lock file is up to date with current dependencies! > > Going to run database updates for mypedia-default- > > Depending on the size of your database this may take a while! > > ...skipping: 'mwuser' table doesn't exist yet. > > ...skipping: 'mwuser' table doesn't exist yet. > > ...skipping: 'pagecontent' table doesn't exist yet. > > Creating sequence logging_log_id_seq > > Wikimedia\Rdbms\DBQueryError from line 1603 of > > /var/www/html/mypedia/includes/libs/rdbms/database/Database.php: A > > database query error has occurred. Did you forget to run your > > application's database schema updater after upgrading? > > Query: CREATE SEQUENCE logging_log_id_seq > > Function: Wikimedia\Rdbms\DBConnRef::query > > Error: 42P07 ERROR: relation "logging_log_id_seq" already exists > > > > > > #0 /var/www/html/mypedia/includes/libs/rdbms/database/Database.php(1574): > > Wikimedia\Rdbms\Database->getQueryExceptionAndLog('ERROR: > > relatio...', '42P07', 'CREATE SEQUENCE...', 'Wikimedia\\Rdbms...') > > #1 /var/www/html/mypedia/includes/libs/rdbms/database/Database.php(1152): > > Wikimedia\Rdbms\Database->reportQueryError('ERROR: relatio...', > > '42P07', 'CREATE SEQUENCE...', 'Wikimedia\\Rdbms...', false) > > #2 /var/www/html/mypedia/includes/libs/rdbms/database/DBConnRef.php(68): > > Wikimedia\Rdbms\Database->query('CREATE SEQUENCE...', > > 'Wikimedia\\Rdbms...', 0) > > #3 /var/www/html/mypedia/includes/libs/rdbms/database/DBConnRef.php(292): > > Wikimedia\Rdbms\DBConnRef->__call('query', Array) > > #4 /var/www/html/mypedia/includes/installer/PostgresUpdater.php(833): > > Wikimedia\Rdbms\DBConnRef->query('CREATE SEQUENCE...') > > #5 /var/www/html/mypedia/includes/installer/DatabaseUpdater.php(490): > > PostgresUpdater->addSequence('logging', false, 'logging_log_id_...') > > #6 /var/www/html/mypedia/includes/installer/DatabaseUpdater.php(454): > > DatabaseUpdater->runUpdates(Array, false) > > #7 /var/www/html/mypedia/maintenance/update.php(205): > > DatabaseUpdater->doUpdates(Array) > > #8 /var/www/html/mypedia/maintenance/doMaintenance.php(99): > > UpdateMediaWiki->execute() > > #9 /var/www/html/mypedia/maintenance/update.php(277): > > require_once('/var/www/html/s...') > > #10 {main} > > > > --------------------------------------------------------- > > > > > > > > Thankyou > > _______________________________________________ > MediaWiki-l mailing list > To unsubscribe, go to: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > -- Amir (he/him) _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
