[Pkg-mediawiki-devel] Database error (confused sequences?) after upgrade to MW 1.19

Tue Oct 9 10:15:38 UTC 2012

Hi,

has anyone seen the following error? I can reproduce it
on two of our systems at the very least, and Roland Mas
has seen it on fusionforge.org, too. He thinks it was a
confusion in naming about sequences (two exist with si‐
milar names and the wrong was used or something).

(And yes, upgrade.php _was_ run.)

--- snip ---
MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: INSERT INTO "logging" (log_id,log_type,log_action,log_timestamp,log_user,log_user_text,log_namespace,log_title,log_page,log_comment,log_params) VALUES ('1','upload','upload','2012-10-09 10:10:12 GMT','1','Tglase','6','UniData.txt','0','Unicode Database (BMP)','')
Function: LogPage::saveContent
Error: 1 ERROR: duplicate key value violates unique constraint "logging_pkey"
DETAIL: Key (log_id)=(1) already exists.
' in /usr/share/mediawiki/includes/db/Database.php:918
Stack trace:
#0 /usr/share/mediawiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('ERROR: duplica...', 1, 'INSERT INTO "lo...', 'LogPage::saveCo...', '')
#1 /usr/share/gforge/plugins/mediawiki/www/LocalSettings.php(134): DatabaseBase->query('INSERT INTO "lo...', 'LogPage::saveCo...', '')
#2 /usr/share/mediawiki/includes/db/DatabasePostgres.php(524): DatabaseForge->query('INSERT INTO "lo...', 'LogPage::saveCo...', '')
#3 /usr/share/mediawiki/includes/logging/LogPage.php(93): DatabasePostgres->insert('logging', Array, 'LogPage::saveCo...')
#4 /usr/share/mediawiki/includes/logging/LogPage.php(465): LogPage->saveContent()
#5 /usr/share/mediawiki/includes/filerepo/file/LocalFile.php(1082): LogPage->addEntry('upload', Object(Title), 'Unicode Databas...', Array, Object(User))
#6 /usr/share/mediawiki/includes/filerepo/file/LocalFile.php(914): LocalFile->recordUpload2('', 'Unicode Databas...', 'Unicode Databas...', Array, false, Object(User))
#7 /usr/share/mediawiki/includes/upload/UploadBase.php(573): LocalFile->upload('/tmp/2012100910...', 'Unicode Databas...', 'Unicode Databas...', 1, Array, false, Object(User))
#8 /usr/share/mediawiki/includes/upload/UploadFromStash.php(158): UploadBase->performUpload('Unicode Databas...', 'Unicode Databas...', false, Object(User))
#9 /usr/share/mediawiki/includes/specials/SpecialUpload.php(439): UploadFromStash->performUpload('Unicode Databas...', 'Unicode Databas...', false, Object(User))
#10 /usr/share/mediawiki/includes/specials/SpecialUpload.php(174): SpecialUpload->processUpload()
#11 /usr/share/mediawiki/includes/SpecialPageFactory.php(476): SpecialUpload->execute(NULL)
#12 /usr/share/mediawiki/includes/Wiki.php(263): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#13 /usr/share/mediawiki/includes/Wiki.php(593): MediaWiki->performRequest()
#14 /usr/share/mediawiki/includes/Wiki.php(503): MediaWiki->main()
#15 /usr/share/mediawiki/index.php(58): MediaWiki->run()
#16 {main}

Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT value,exptime FROM "objectcache" WHERE keyname = 'gforge:resourceloader:filter:minify-css:7:c88e2bcd56513749bec09a7e29cb3ffa' LIMIT 1
Function: SqlBagOStuff::get
Error: 1 ERROR: current transaction is aborted, commands ignored until end of transaction block
' in /usr/share/mediawiki/includes/db/Database.php:918
Stack trace:
#0 /usr/share/mediawiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('ERROR: current...', 1, 'SELECT value,e...', 'SqlBagOStuff::g...', false)
#1 /usr/share/mediawiki/includes/db/Database.php(1358): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...')
#2 /usr/share/mediawiki/includes/db/Database.php(1445): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array)
#3 /usr/share/mediawiki/includes/objectcache/SqlBagOStuff.php(124): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...')
#4 /usr/share/mediawiki/includes/resourceloader/ResourceLoader.php(149): SqlBagOStuff->get('gforge:resource...')
#5 /usr/share/mediawiki/includes/resourceloader/ResourceLoader.php(783): ResourceLoader->filter('minify-css', 'a:lang(ar), a:l...')
#6 /usr/share/mediawiki/includes/OutputPage.php(2594): ResourceLoader->makeModuleResponse(Object(ResourceLoaderContext), Array)
#7 /usr/share/mediawiki/includes/OutputPage.php(3310): OutputPage->makeResourceLoaderLink(Array, 'styles')
#8 /usr/share/mediawiki/includes/OutputPage.php(2407): OutputPage->buildCssLinks()
#9 /usr/share/mediawiki/includes/SkinTemplate.php(465): OutputPage->headElement(Object(SkinFusionForge))
#10 /usr/share/mediawiki/includes/OutputPage.php(1982): SkinTemplate->outputPage()
#11 /usr/share/mediawiki/includes/Exception.php(182): OutputPage->output()
#12 /usr/share/mediawiki/includes/Exception.php(209): MWException->reportHTML()
#13 /usr/share/mediawiki/includes/Exception.php(490): MWException->report()
#14 /usr/share/mediawiki/includes/Exception.php(569): MWExceptionHandler::report(Object(DBQueryError))
#15 /usr/share/mediawiki/includes/Wiki.php(506): MWExceptionHandler::handle(Object(DBQueryError))
#16 /usr/share/mediawiki/index.php(58): MediaWiki->run()
#17 {main}
Click to toggle
[2] pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "logging_pkey" DETAIL: Key (log_id)=(1) already exists. (/usr/share/mediawiki/includes/db/DatabasePostgres.php at 254)
[2] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block (/usr/share/mediawiki/includes/db/DatabasePostgres.php at 254)
[2] Invalid argument supplied for foreach() (/usr/share/mediawiki/includes/resourceloader/ResourceLoaderWikiModule.php at 202)
--- snip ---

Thanks,
//mirabilos
-- 
tarent solutions GmbH
Rochusstraße 2-4, D-53123 Bonn • http://www.tarent.de/
Tel: +49 228 54881-393 • Fax: +49 228 54881-314
HRB 5168 (AG Bonn) • USt-ID (VAT): DE122264941
Geschäftsführer: Boris Esser, Sebastian Mancke