toan added a comment.

  Could it be that you are running the mediawiki script to populate interwiki 
links? (The suggested fix seems to mention that script rather)
  
    root@mediawiki:/var/www/mediawiki# php maintenance/populateInterwiki.php 
    Xdebug: [Step Debug] Could not connect to debugging client. Tried: 
172.17.0.1:9000 (fallback through xdebug.client_host/xdebug.client_port) :-(
    Wikimedia\Rdbms\DBQueryError from line 1719 of 
/var/www/mediawiki/includes/libs/rdbms/database/Database.php: Error 23502: 
ERROR:  null value in column "iw_api" violates not-null constraint
    DETAIL:  Failing row contains (advisory, 
https://advisory.wikimedia.org/wiki/$1, null, null, 1, 0).
    
    Function: PopulateInterwiki::doPopulate
    Query: INSERT INTO "interwiki" (iw_prefix,iw_url,iw_local) VALUES 
('advisory','https://advisory.wikimedia.org/wiki/$1',1) ON CONFLICT DO NOTHING
    
    #0 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(1703): 
Wikimedia\Rdbms\Database->getQueryException('ERROR:  null va...', '23502', 
'INSERT INTO "in...', 'PopulateInterwi...')
    #1 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(1678): 
Wikimedia\Rdbms\Database->getQueryExceptionAndLog('ERROR:  null va...', 
'23502', 'INSERT INTO "in...', 'PopulateInterwi...')
    #2 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(1244): 
Wikimedia\Rdbms\Database->reportQueryError('ERROR:  null va...', '23502', 
'INSERT INTO "in...', 'PopulateInterwi...', false)
    #3 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(2383): 
Wikimedia\Rdbms\Database->query('INSERT INTO "in...', 'PopulateInterwi...', 128)
    #4 
/var/www/mediawiki/includes/libs/rdbms/database/DatabasePostgres.php(562): 
Wikimedia\Rdbms\Database->doInsertNonConflicting('interwiki', Array, 
'PopulateInterwi...')
    #5 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(2343): 
Wikimedia\Rdbms\DatabasePostgres->doInsertNonConflicting('interwiki', Array, 
'PopulateInterwi...')
    #6 /var/www/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): 
Wikimedia\Rdbms\Database->insert('interwiki', Array, 'PopulateInterwi...', 
Array)
    #7 /var/www/mediawiki/includes/libs/rdbms/database/DBConnRef.php(369): 
Wikimedia\Rdbms\DBConnRef->__call('insert', Array)
    #8 /var/www/mediawiki/maintenance/populateInterwiki.php(144): 
Wikimedia\Rdbms\DBConnRef->insert('interwiki', Array, 'PopulateInterwi...', 
Array)
    #9 /var/www/mediawiki/maintenance/populateInterwiki.php(69): 
PopulateInterwiki->doPopulate(Array, false)
    #10 /var/www/mediawiki/maintenance/doMaintenance.php(112): 
PopulateInterwiki->execute()
    #11 /var/www/mediawiki/maintenance/populateInterwiki.php(159): 
require_once('/var/www/mediaw...')
    #12 {main}
  
  This seems to be not a Wikibase error (Wikibase was disabled in the above 
installation). I think the suggested fix could do the trick however since there 
is no testing for postgres in CI we could probably only assert that adding the 
defaults does not crash MariaDB/Mysql.
  
  https://www.mediawiki.org/wiki/Manual:PostgreSQL

TASK DETAIL
  https://phabricator.wikimedia.org/T287564

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

To: toan
Cc: LucasWerkmeister, Samantha_Alipio_WMDE, Aklapper, OkayIguess, Invadibot, 
maantietaja, Akuckartz, Iflorez, darthmon_wmde, alaa_wmde, Nandana, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, saper, aude, Jjanes, Turnstep, Lydia_Pintscher, scfc, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to