Thread:Project:Support desk/PostgreSQL and "LOCK IN SHARE MODE"/reply

I can confirm that. Using current mediawiki 1.19.1 version and postgresql 8.3. Using a category with pages and files. In some categories it still works. Others are broken.

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: SELECT COUNT(*) AS pages,COUNT( (CASE WHEN page_namespace=14 THEN 1 ELSE NULL END) ) AS subcats,COUNT( (CASE WHEN page_namespace=6 THEN 1 ELSE NULL END) ) AS files FROM "categorylinks","page" WHERE cl_to = 'Java_EE' AND (page_id = cl_from) LIMIT 1 LOCK IN SHARE MODE Function: Category::refreshCounts Error: 1 FEHLER: Syntaxfehler bei »LOCK« LINE 1: ...to = 'Java_EE' AND (page_id = cl_from) LIMIT 1 LOCK IN SH... ^ ' in /var/www/mediawiki-1.19.1/includes/db/Database.php:918 Stack trace:
 * 1) 0 /var/www/mediawiki-1.19.1/includes/db/Database.php(885): DatabaseBase->reportQueryError('FEHLER: Syntax...', 1, 'SELECT COUNT(*...', 'Category::refre...', false)
 * 2) 1 /var/www/mediawiki-1.19.1/includes/db/Database.php(1358): DatabaseBase->query('SELECT COUNT(*...', 'Category::refre...')
 * 3) 2 /var/www/mediawiki-1.19.1/includes/db/Database.php(1445): DatabaseBase->select(Array, Array, Array, 'Category::refre...', Array, Array)
 * 4) 3 /var/www/mediawiki-1.19.1/includes/Category.php(289): DatabaseBase->selectRow(Array, Array, Array, 'Category::refre...', 'LOCK IN SHARE M...')
 * 5) 4 /var/www/mediawiki-1.19.1/includes/CategoryViewer.php(670): Category->refreshCounts
 * 6) 5 /var/www/mediawiki-1.19.1/includes/CategoryViewer.php(401): CategoryViewer->getCountMessage(3, '5', 'file')
 * 7) 6 /var/www/mediawiki-1.19.1/includes/CategoryViewer.php(91): CategoryViewer->getImageSection
 * 8) 7 /var/www/mediawiki-1.19.1/includes/CategoryPage.php(97): CategoryViewer->getHTML
 * 9) 8 /var/www/mediawiki-1.19.1/includes/CategoryPage.php(63): CategoryPage->closeShowCategory
 * 10) 9 /var/www/mediawiki-1.19.1/includes/actions/ViewAction.php(40): CategoryPage->view
 * 11) 10 /var/www/mediawiki-1.19.1/includes/Wiki.php(484): ViewAction->show
 * 12) 11 /var/www/mediawiki-1.19.1/includes/Wiki.php(278): MediaWiki->performAction(Object(CategoryPage))
 * 13) 12 /var/www/mediawiki-1.19.1/includes/Wiki.php(593): MediaWiki->performRequest
 * 14) 13 /var/www/mediawiki-1.19.1/includes/Wiki.php(503): MediaWiki->main
 * 15) 14 /var/www/mediawiki-1.19.1/index.php(58): MediaWiki->run
 * 16) 15 {main}