https://bugzilla.wikimedia.org/show_bug.cgi?id=28291
Summary: Database query error when ordering categorymembers by
timestamp
Product: MediaWiki
Version: wikimedia-deployment
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: API
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected]
Queries using generator=categorymembers and gcmsort=timestamp intermittently
return database errors.
Sample query URL:
http://en.wikipedia.org/w/api.php?action=query&generator=categorymembers&gcmtitle=Category:Wikipedia%20soft%20redirected%20categories&prop=info&gcmlimit=500&gcmsort=timestamp
Response:
<?xml version="1.0"?>
<api servedby="srv296">
<error code="internal_api_error_DBQueryError" info="Database query error"
xml:space="preserve">
#0 /usr/local/apache/common-local/php-1.17/includes/db/Database.php(734):
DatabaseBase->reportQueryError('Query execution...', 1317, 'SELECT
page_na...', 'ApiQueryCategor...', false)
#1 /usr/local/apache/common-local/php-1.17/includes/db/Database.php(1033):
DatabaseBase->query('SELECT page_na...', 'ApiQueryCategor...')
#2 /usr/local/apache/common-local/php-1.17/includes/api/ApiQueryBase.php(263):
DatabaseBase->select(Array, Array, Array, 'ApiQueryCategor...', Array, Array)
#3
/usr/local/apache/common-local/php-1.17/includes/api/ApiQueryCategoryMembers.php(161):
ApiQueryBase->select('ApiQueryCategor...', Array)
#4
/usr/local/apache/common-local/php-1.17/includes/api/ApiQueryCategoryMembers.php(52):
ApiQueryCategoryMembers->run(Object(ApiPageSet))
#5 /usr/local/apache/common-local/php-1.17/includes/api/ApiQuery.php(550):
ApiQueryCategoryMembers->executeGenerator(Object(ApiPageSet))
#6 /usr/local/apache/common-local/php-1.17/includes/api/ApiQuery.php(246):
ApiQuery->executeGeneratorModule(Object(ApiQueryCategoryMembers), Array)
#7 /usr/local/apache/common-local/php-1.17/includes/api/ApiMain.php(657):
ApiQuery->execute()
#8 /usr/local/apache/common-local/php-1.17/includes/api/ApiMain.php(339):
ApiMain->executeAction()
#9 /usr/local/apache/common-local/php-1.17/includes/api/ApiMain.php(323):
ApiMain->executeActionWithErrorHandling()
#10 /usr/local/apache/common-local/php-1.17/api.php(116): ApiMain->execute()
#11 /usr/local/apache/common-local/live-1.5/api.php(3):
require('/usr/local/apac...')
#12 {main}
</error>
</api>
As mentioned earlier, this error is intermittent. I can submit the _identical_
query 10 times and it will only result in an error 2 or 3 times. So far, I
have not encountered any similar errors when the ordering is by sortkey.
I have encountered the same error when using list=categorymembers instead of
generator=categorymembers.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
