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