[Wikidata-bugs] [Maniphest] [Commented On] T174028: Finalize database schema for MCR content meta-data

[mwjames]

mwjames added a comment.

[mediawiki/core@master] MCR database schema
https://gerrit.wikimedia.org/r/378724

This PR causes:

...column 'logging.log_comment' is already set as NOT NULL
...column 'logging.log_comment_id' already exists
Changing 'protected_titles.pt_reason' default value
...column 'protected_titles.pt_reason' is already set as NOT NULL
...column 'protected_titles.pt_reason_id' already exists
...comment table already exists.
...index site_stats_pkey already set on site_stats table.
...ip_changes table already exists.
...slots table already exists.
...content table already exists.
Creating content_moddels table ...[d15b7b76a1d10fa2abe8440a] [no req]   Wikimedia\Rdbms\DBQueryError from line 1185 of ...\includes\libs\rdbms\database\Database.php: A database query error has occurred. Did you forget to run your app
lication's database schema updater after upgrading?
Query: CREATE SEQUENCE content_models_model_id_seq

Function: Wikimedia\Rdbms\Database::sourceFile( .../maintenance/postgres/archives/patch-content_models-t
able.sql )
Error: 42P07 ERROR:  relation "content_models_model_id_seq" already exists


Backtrace:
#0 ...\includes\libs\rdbms\database\DatabasePostgres.php(262): Wikimedia\Rdbms\Database->reportQueryErro
r(string, string, string, string, boolean)
#1 ...\includes\libs\rdbms\database\Database.php(997): Wikimedia\Rdbms\DatabasePostgres->reportQueryErro
r(string, string, string, string, boolean)
#2 ...\includes\libs\rdbms\database\Database.php(3422): Wikimedia\Rdbms\Database->query(string, string)
#3 ...\includes\libs\rdbms\database\Database.php(3370): Wikimedia\Rdbms\Database->sourceStream(unknown type, NULL, NULL, string, NULL)
#4 ...\includes\installer\DatabaseUpdater.php(683): Wikimedia\Rdbms\Database->sourceFile(string)
#5 ...\includes\installer\DatabaseUpdater.php(726): DatabaseUpdater->applyPatch(string, boolean, string)

#6 ...\includes\installer\DatabaseUpdater.php(482): DatabaseUpdater->addTable(string, string)
#7 ...\includes\installer\DatabaseUpdater.php(446): DatabaseUpdater->runUpdates(array, boolean)
#8 ...\maintenance\update.php(200): DatabaseUpdater->doUpdates(array)
#9 ...\maintenance\doMaintenance.php(94): UpdateMediaWiki->execute()
#10 ...\maintenance\update.php(245): require_once(string)

on

MediaWiki	1.31.0-alpha (80f7ac1)
PHP	7.1.1 (apache2handler)
PostgreSQL	9.3.12
ICU	57.1

@aude @daniel Please make sure you follow-up on this.

TASK DETAIL

https://phabricator.wikimedia.org/T174028

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: daniel, mwjames
Cc: mwjames, aude, Marostegui, Abit, brion, Anomie, jcrespo, gerritbot, Aklapper, daniel, Cpaulf30, Lahi, PDrouin-WMF, Gq86, Baloch007, E1presidente, Ramsey-WMF, Darkminds3113, SandraF_WMF, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Tramullas, Acer, LawExplorer, Lewizho99, Maathavan, Susannaanas, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Fabrice_Florin, Raymond, Steinsplitter, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs