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
